Creating the default storage group, defining temporary work files, and binding Db2 REXX Language Support: DSNTIJTM
After you start Db2 when you add a data sharing member, you must activate its buffer pools and create its work file database.
Procedure
To define the new member’s buffer pools and create its work file database:
If job DSNTIJTM runs successfully, it produces the return codes that are shown in the following table:
| Step | PROCSTEP | Return code |
|---|---|---|
| DSNTIAB | (none) | 0000 |
| DSNTIAS | (none) | 0000 |
| DSNTICR | (none) | 0000 |
| DSNTIST | (none) | 0000 |
Results
DSNTIJTM defines the new member's initial buffer pools according to the sizes that are specified on installation panels DSNTIP1 and DSNTIP2. It also creates the work file database for the new member according to the values that you specified on panel DSNTIP9.
DSNTIJTM also provides some cleanup to ease reruns.
What to do next
For data sharing installations, the work file database name is the name that was specified in the WORK FILE DB field on installation panel DSNTIPK. After creating the work file database, the DSNTIJTM job creates the work file table spaces as specified on installation panel DSNTIP9.
You can increase the number of additional temporary work file table spaces by increasing the values in the work file table space fields on panel DSNTIP9, particularly if you expect a large amount of sorting at your site. Additional temporary work file table spaces can improve Db2 performance by reducing device contention among applications. These additional work files also can be used for sorting indexes on large tables during index creation.
You can choose to have job DSNTIJTM create these additional table spaces, or you can create them after you run DSNTIJTM. To create additional work file table spaces after you run job DSNTIJTM, use the DSNTWFG exec in job step DSNTIST. See the comment block for job step DSNTIST for information about the parameters for DSNTWFG.
If you do not run the installation CLIST, customize DSNTIJTM or the DSNTWFG exec to create at least one 4 KB and one 32 KB work file table space.