Start of change

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.
End of change