Make DB2I panels, messages, and load modules available to ISPF and TSO

During installation, to connect the Db2 Interactive facility (DB2I) to TSO, you must make panels, messages, and load modules available to ISPF and TSO.

About this task

DB2I uses the ISPF PROFILE and SHARED variable pools for most panel variable fields. As a result, you can easily re-enter a panel when panel variables have previously been specified. For the Db2 subcommands that permit lists of plan names, package names, DBRMs, and ENABLE and DISABLE statements, DB2I provides ISPF to contain all the user-specified variables for these subcommand keywords.

DB2I creates and maintains a set of ISPF tables in a user-defined TSO data set that is allocated to a data set with a ddname of DSNETBLS. The DB2I-generated tables in this library are DSNCONNS, DSNDBRMS, and DSNPLPKN. The following table shows the Db2 ISPF table library member names and their contents.

DSNCONNS	ENABLE or DISABLE connection type and connection name variables that are referenced by plan or package name
DSNDBRMS	Subcommand DBRM member and LIBRARY name variables that are referenced by plan name
DSNPLPKN	Package list variables that are referenced by package name
DSNPATHS	Schema name variables that are referenced by plan or package name and that are to be included in the PATH keyword

DB2I uses ISPF table services to maintain individual ISPF tables within the DSNETBLS data set. For performance reasons, ISPF keeps this table library in an open state once an individual table has been updated. Attempts to close this data set by using the TSO FREE command results in error message IKJ56861I.

Procedure

To make panels, messages, and load modules available to ISPF and TSO:

If you added the DB2I libraries as part of Generating tailored Db2 12 installation, migration, or function level activation jobs, you can skip this step. Otherwise, concatenate the Db2 ISPF libraries with the ISPPLIB, ISPTLIB, ISPSLIB, and ISPMLIB DD statements in your logon procedures. You must also concatenate the Db2 ISPF libraries with these DD statements in any of your CLISTs where the libraries might be allocated. These libraries are prefix.SDSNSPFP, prefix.SDSNSPFM, prefix.SDSNSPFS, and prefix.SDSNPFPE or prefix.SDSNPFP. If you use English DB2I panels, concatenate SDSNPFPE to ISPPLIB. If you use Kanji DB2I panels, concatenate SDSNPFPK instead of SDSNPFPE.
```
PROFILE WTP MSGID 
ALLOCATE DDNAME(SYSPROC) DSN('prefix.SDSNCLST') SHR REUSE
ALLOCATE DDNAME(ISPMLIB) DSN('prefix.SDSNSPFM' + 
    'ISP.SISPMENU') SHR REUSE 
ALLOCATE DDNAME(ISPPLIB) DSN('prefix.SDSNSPFP' 'prefix.SDSNPFPE' + 
    'ISP.SISPPENU') SHR REUSE 
ALLOCATE DDNAME(ISPSLIB) DSN('prefix.SDSNSPFS' + 
    'ISP.SISPSLIB' 'ISP.SISPSENU') SHR REUSE 
```
Create the DSNETBLS data set.
When allocating this data set, you should assign the following DCB attributes, where n is any integer:
```
DSORG(PO) RECFM(F B) LRECL(80) BLKSIZE(n*LRECL)
```
The following example shows how to set up an ALLOCATE statement to create the data set:
```
ALLOC DA(DSNSPFT) NEW SP(1 1) TR DIR(10) +
DSORG(PO) RECFM(F B) LRECL(80) BLKSIZE(800)
F(DSNETBLS) REUSE
```
The following example shows how to allocate an existing data set to the data set with the DSNETBLS ddname:
```
ALLOC DA(DSNSPFT)      F(DSNETBLS) REUSE
```
If you want to run the ISPF/CAF sample application that is provided with Db2, ensure that the data set prefix.RUNLIB.LOAD is included in the logon procedures or in the ISPLLIB concatenation. If you chose IBMCOB for your LANGUAGE DEFAULT on panel DSNTIPF, you should also include the data set prefix.CEE.SCEERUN.