Documenting Databases of Different Types

This document covers the following topics:

Note:
The window for the object type Database contains common sections that are always the same for all object types. For detailed information on these sections, see Global Attributes.


Database Type A - Adabas

Adabas database attributes

Note:
Attributes that are not in the table below are described in the section Defining Basic Attributes of Databases.

Attributes
Adabas attributes
Maximal files Number of files permitted in the database (ADADEF parameter MAXFILES). This number must either be 0 or at least 5 but not more than 32767.
Checkpoint file The number of the Adabas file which contains checkpoint information for the database. Predict automatically creates a data dictionary object with the file ID SAG-ADA-CHECKPOINT for this file.
Adabas security The number of the Adabas file which contains Adabas security information for the database. Predict automatically creates a data dictionary object with the file ID SAG-ADA-SECURITY for this file.
Size of RABN
Specifies the length of RABNs in the database.
0 not specified
3 3 Byte for 24-bit RABNs
4 4 Byte for 31-bit RABNs
Distr. transaction
N No (Default)
RM Resource Manager
TM Transaction Manager
Field must be filled if the database is part of the distributed transaction processing (DTP) of the Adabas Transaction Manager
Vista access only
Y If the attributes of the database are such that files in the database can only be accessed using Adabas Vista.
Vista access only is set by Predict.
OS/400 Attributes Specify an OS/400 database in the field Database name.
Natural file numbers
System file (FNAT) The number of the Natural system file.
NAT Security (FSEC) The number of the Adabas file which contains Natural Security information.
Predict (FDIC) The number of the Adabas file which contains the dictionary data.
Universal Encoding Support
Universal encoding support of an Adabas Database can be defined in this section. See the Adabas documentation for detailed information on this topic.

Specifying the Size of an Adabas Database

Physical properties of a database (device types and sizes of the data sets containing the Adabas ASSO, DATA, WORK, SORT and TEMP) can be defined on the Sizes tab.

Data sizes

To specify the size, choose the Add button. A new row appears in the table and you can now select a device type and enter the size in RABNs. You can also select an existing entry and change its values.

Parameters
Device Devices are identified with a four-letter code that must have been defined in Predict on the server side with the function Adabas device types in the Special functions menu. If a device type is changed, the change should also be made in each file object that is linked to the database.
Number of RABN The number of RABNs (relative Adabas block numbers) of the specified device that are occupied by the specified extent of the specified database.

Specifying the Encodings of an Adabas Database

Universal encoding support of an Adabas Database can be defined

Note:
See the Adabas documentation for detailed information on this topic.

Database Types C, E, P - Conceptual, General SQL Handler, Entire System Server Nodes

A window similar to the following is displayed when adding or modifying databases of the types C, E and P.

Entire System Server

The database-specific parameters are described in the section Defining Basic Attributes of Databases.

Database Type D - DB2

The following attributes apply to databases of type D.

DB2 database

Attributes
DB2 name The name of the database in DB2.
Buffer pool The buffer pool of the database.
Index buffer pool Buffer pool which is used for the indexes created within the database.
Temporary database
N No (Default).
Y Database is used for declared temporary tables.
Data sharing group member Name of the member of the data sharing group. Leave blank or specify name with up to eight characters (letters A-Z, digits 0-9 and special characters $, # and @).
Default storagespace DB2 tables of the database will be implemented in this storage group if no other storage group is explicitly specified.
CCSID
Defines the encoding scheme of the database.
blank not specified
A ASCII
E EBCDIC

Database Type O - Oracle Handler

A window similar to the following is displayed when adding or modifying databases of the type O.

Oracle Handler

The database-specific parameters are described in the section Defining Basic Attributes of Databases.

Database Types Q, M, R, H - Adabas SQL Handler, RMS Handler, rdb Handler, Other Handler

Database type Q is used to document databases of type Adabas SQL handler. See the section Adabas SQL Server in the Predict and Other Systems documentation for more information.

Database type M is used to document RMS databases; database type R is used to document rdb databases.

Database type H is used to represent database handlers, such as USER-DB, SESAM, DL/I, WIZZARD, TRS etc. Database type other handler can be used to reserve a database number (prevent it from being used by Adabas).

Adabas SQL Handler

Parameters
Physical database number

For database type RMS Handler: the database number must be declared in the Natural NATPARM parameter file as an RMS database number if DDMs for RMS files contained in the database are to be generated.

See table in the section Defining Basic Attributes of Databases for range of permitted values.

Database Type I - IMS

IMS databases cannot be added using Predict Description and Generation. For further information on how to create an IMS Database object in Predict, see External Objects in Predict.

IMS database

The following attributes apply to databases of type I.

Attributes
IMS or DL1 The kind of database. Valid values:

IMS
DL1

IMS name The name of the database in IMS.
IMS type The type of the database in IMS. Valid values:

LOGICAL
PHYSICAL

Database Type S - SQL Server

Database type S is used to represent objects of type SQL server.

SQL server

Attributes
Connection type The type of connection:

N - Natural for DB2
O - Entire Access
C - Natural SQL Gateway

Server name / catalog name The name that was specified when the data source was created.
Port number Identifies the server daemon.
Host name / Gateway Identifies the host machine or gateway on which the server runs.
Driver / CDD data source Specifies the database driver or data source to be used.

Database Type T - Target Node

Database type T is used to represent database nodes entered in the ID table of an SVC which cannot be documented with a corresponding database type: BROKER, NATURAL GLOBAL BUFFER POOL etc.

This type of database is used to reserve the corresponding database number and thus prevent this number being used for an Adabas database.

Target node

Attributes
Run mode
Must be specified for databases of this type. Valid values:
I Isolated
L Local
Physical database number The physical database number must be in range 1-65535.

Database Type V - VSAM Handler

Database objects of type V are used to collect all definitions of VSAM clusters which are accessed by the same Natural VSAM handler. The database number defined in a database object of type V is used by the GENERATE DDM function.

VSAM handler

Attributes
Run mode Must be local for databases of this type.
Physical database number The physical database number must be in the range from 1 - 65535.

Other SQL Database Types

The windows used to maintain database objects of the following types are the same as for VSAM databases above. The physical database number must be less than or equal to 254.

Type Description
J Ingres Handler
O Oracle Handler
X Informix Handler
Y Sybase Handler
B Adabas D Handler