
DB2 settings
Use the DB2® settings to specify settings for exporting data from historical databases (HDBs) to DB2 tables.
To display the DB2 Settings panel, select option 4 DB2 Settings from the Profile Options Menu.
Figure 1. DB2 settings
File Options Help
------------------------------------------------------------------------------
DB2 Settings
Command ===> _________________________________________________________________
DB2 Settings:
DB2 Subsystem ID . . . DB2P
DSNTIAD Plan Name . . DSNTIA91
DB2 Load Library . . . 'DB2.PROD.SDSNLOAD'___________________________
DB2 Exit Library . . . 'DB2.PROD.SDSNEXIT'___________________________
DB2 RUNLIB Library . . 'DB2.PROD.RUNLIB.LOAD'________________________
Database . . . . . . . CICSPA__ Storage Group . . SYSDEFLT
VCAT Catalog name . . USER____ Volume . . . . . . DA0001
Allocation: Primary 20______ Secondary . . . . 20____
The options are:
- DB2 Subsystem ID
- The DB2 Subsystem ID to be used to for the Export function.
- DSNTIAD Plan Name
- The Plan name for the dynamic SQL program (DSNTIAD), for example DSNTIA91.
- DB2 Load Library
- The DB2 SDSNLOAD Load Library data set name.
- DB2 Exit Library
- The DB2 SDSNEXIT Exit Library data set name.
- DB2 RUNLIB Library
- The DB2 RUNLIB.LOAD Application Load Library data set name.
- Database
- The DB2 Database name that
is to contain the tables.Note: The Database name will be replaced by the qualifier if a Qualifier has been specified in the HDB definition.
- Storage Group
- The DB2 Storage Group name for the DB2 Table Spaces.
- VCAT Catalog name
- Identifies the integrated catalog facility catalog for the storage group.
- Volume
- Defines the volume of the storage group.
- Primary Allocation
- Specifies the minimum primary space allocation (PRIQTY) for DB2-managed data sets.
- Secondary Allocation
- Specifies the minimum secondary space allocation (SECQTY) for DB2-managed data sets.
