Overriding default data set space allocations for Db2 CI/CD Expert

You can override the default space allocations for data sets used by Db2 Administration Tool and Db2 Object Comparison Tool to suit your deployment environment or improve execution performance. By specifying additional data set parameters in the request body for the CREATE and RUN actions in a deployment plan, you can ensure sufficient space allocation for processing, comparison, sorting, and recovery tasks. These overrides provide more flexibility in managing resources and optimizing deployment efficiency.

Before you begin

  • Ensure perform these actions as a Db2 CD administrator or Db2 CD operator.
  • The parameter names, values, and data set allocations shown in the examples are for reference only. Adjust them according to your site standards or deployment requirements.

Procedure

  1. To override default data set allocations, include the dataSetOverrides object in the request body of a deployment plan when executing CREATE and RUN actions. Within this object, you can specify custom space parameters for various supported data set types used by Db2 Administration Tool and Db2 Object Comparison Tool during Db2 continuous deployment operations.
    The following data set categories are supported:
    1. Run and Recovery JCL data sets (CREDS).
      Include the CREDS section in the dataSetOverrides object to override default allocations for run.jcl and recover.jcl data sets.
      
                  "CREDS": [
                      {
                          "ddName": "RNJCLDD",
                          "ddDef": [
                              "DSN={tempDatasetHlq}.{worklist}.RUN.JCL",
                              "DISP=(NEW,CATLG,DELETE)",
                              "SPACE=(TRK,(100,200))",
                              "UNIT=SYSDA",
                              "DSNTYPE=LIBRARY",
                              "DCB=(DSORG=PO,RECFM=FB,LRECL=80,BLKSIZE=6160)"
                          ]
                      },
                      {
                          "ddName": "RCJCLDD",
                          "ddDef": [
                              "DSN={tempDatasetHlq}.{worklist}.RECOVER.JCL",
                              "DISP=(NEW,CATLG,DELETE)",
                              "SPACE=(TRK,(100,200))",
                              "UNIT=SYSDA",
                              "DSNTYPE=LIBRARY",
                              "DCB=(DSORG=PO,RECFM=FB,LRECL=80,BLKSIZE=6160)"
                          ]
                      }
                  ] 
    2. GOCCM data sets.
      Include the GOCCM section within the dataSetOverrides object to override space for data sets used in Db2 object comparison.
      
                  "GOCCM": [
                      {
                          "ddName": "SYSIN",
                          "ddDef": [
                              "DSN=&SYSIN",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(200,300),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                          ]
                      },
                      {
                          "ddName": "SRC2OUT",
                          "ddDef": [
                              "DSN=&SRC2OUT",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(200,300),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                          ]
                      },
                      {
                          "ddName": "SRCSOUT",
                          "ddDef": [
                              "DSN=&SRCSOUT",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(200,300),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                          ]
                      },
                      {
                          "ddName": "SRCSIN",
                          "ddDef": [
                              "DSN=&SRCSIN",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(200,300),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                          ]
                      },
                      {
                          "ddName": "SRTBOUT",
                          "ddDef": [
                              "DSN=&SRTBOUT",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(200,300),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                          ]
                      },
                      {
                          "ddName": "NEWDD",
                          "ddDef": [
                              "DSN=&NEWDD",
                              "DISP=(,DELETE)",
                              "SPACE=(TRK,(100,100),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                          ]
                      },
                      {
                          "ddName": "OLDDD",
                          "ddDef": [
                              "DSN=&OLDDD",
                              "DISP=(,DELETE)",
                              "SPACE=(TRK,(100,100),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                          ]
                      },
                      {
                          "ddName": "ISPWRK1",
                          "ddDef": [
                              "DSN=&ISPWRK1",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(20,30),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                          ]
                      },
                      {
                          "ddName": "ISPWRK2",
                          "ddDef": [
                              "DSN=&ISPWRK2",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(20,30),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                          ]
                      },
                      {
                          "ddName": "CATOUT",
                          "ddDef": [
                              "DSN=&CATOUT",
                              "DISP=(,DELETE)",
                              "SPACE=(TRK,(100,100),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=16384,RECFM=VB,BLKSIZE=27998,DSORG=PS)"
                          ]
                      },
                      {
                          "ddName": "ADBWLT",
                          "ddDef": [
                              "DSN=&ADBWLT",
                              "DISP=(,DELETE)",
                              "SPACE=(CYL,(25,25,10),RLSE)",
                              "UNIT=&SPCUNIT",
                              "DCB=(LRECL=80,RECFM=FB,BLKSIZE=6160,DSORG=PO)"
                          ]
                      }
                  ]

      GOCCM overrides now apply to both CREATE and RUN actions.

    3. Sort data sets (ADDL).
      Include the ADDL section within the dataSetOverrides object to override dynamic space allocation for sort data sets.
      
                  "ADDL": [
                      {
                          "ddName": "DFSPARM",
                          "ddDef": [
                              "OPTION DYNALLOC=(SYSALLDA,30)"
                          ]
                      }
                  ]
    4. Admin data sets (ADMINDATASET).
      Include the ADMINDATASET section within the dataSetOverrides object to override resource allocations for administrative data sets.
      
                  "ADMINDATASET": [
                      {
                          "ddName": "ADMINDATASET",
                          "ddDef": [
                              "ADMIN_DATASET_TYPE= ''SRCVF'',",
                              "ADMIN_DATASET_DSN= ''&JOBNAME..SRCVF''",
                              "ADMIN_DATASET_SPACE_PRIQTY= ''300''",
                              "ADMIN_DATASET_SPACE_SECQTY= ''100''",
                              "ADMIN_DATASET_SPACE_TYPE= ''CYL'';",
                              "ADMIN_DATASET_TYPE= ''TGTVF'',",
                              "ADMIN_DATASET_DSN= ''&JOBNAME..TGTVF''",
                              "ADMIN_DATASET_SPACE_PRIQTY= ''300''",
                              "ADMIN_DATASET_SPACE_SECQTY= ''100''",
                              "ADMIN_DATASET_SPACE_TYPE= ''CYL'';"
                          ]
                      }
                  ]
  2. Supported data sets for override during the CREATE and RUN actions:
    • The CREATE action supports override of allocations for all data set types: CREDS, GOCCM, ADDL, and ADMINDATASET.
    • The RUN action supports override of allocations for GOCCM and ADDL only. Other data set overrides are not supported for RUN.
  3. When defining parameters for multiple data set types in dataSetOverrides, ensure that each data set type block (CREDS, GOCCM, ADDL, ADMINDATASET) is separated by a comma to prevent syntax errors during request parsing.

Example

Sample dataSetOverrides object in a CREATE plan request:
{
   
    "dataSetOverrides": {
        "overrideDD": {
            "ADDL": [
                {
                    "ddName": "DFSPARM",
                    "ddDef": [
                       "OPTION DYNALLOC=(SYSALLDA,70)"     // Sort data set with increased space
                    ]
                }
            ],
            "CREDS": [
                {
                    "ddName": "RNJCLDD",
                    "ddDef": [
                        "DSN={tempDatasetHlq}.{worklist}.RUN.JCL",
                        "DISP=(NEW,CATLG,DELETE)",                // run.jcl data set
                        "SPACE=(TRK,(100,200))",
                        "UNIT=SYSDA",
                        "DSNTYPE=LIBRARY",
                        "DCB=(DSORG=PO,RECFM=FB,LRECL=80,BLKSIZE=6160)"
                    ]
                },
                {
                    "ddName": "RCJCLDD",
                    "ddDef": [
                        "DSN={tempDatasetHlq}.{worklist}.RECOVER.JCL",
                        "DISP=(NEW,CATLG,DELETE)",                // recover.jcl data set
                        "SPACE=(TRK,(100,200))",
                        "UNIT=SYSDA",
                        "DSNTYPE=LIBRARY",
                        "DCB=(DSORG=PO,RECFM=FB,LRECL=80,BLKSIZE=6160)"
                    ]
                }
            ],
            "GOCCM": [
                {
                    "ddName": "SYSIN",
                    "ddDef": [
                        "DSN=&SYSIN",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRC2OUT",
                    "ddDef": [
                        "DSN=&SRC2OUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",             /// GOCCM data sets 
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRCSOUT",
                    "ddDef": [
                        "DSN=&SRCSOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRCSIN",
                    "ddDef": [
                        "DSN=&SRCSIN",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRTBOUT",
                    "ddDef": [
                        "DSN=&SRTBOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "NEWDD",
                    "ddDef": [
                        "DSN=&NEWDD",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "OLDDD",
                    "ddDef": [
                        "DSN=&OLDDD",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ISPWRK1",
                    "ddDef": [
                        "DSN=&ISPWRK1",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(20,30),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ISPWRK2",
                    "ddDef": [
                        "DSN=&ISPWRK2",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(20,30),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "CATOUT",
                    "ddDef": [
                        "DSN=&CATOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16384,RECFM=VB,BLKSIZE=27998,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ADBWLT",
                    "ddDef": [
                        "DSN=&ADBWLT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(25,25,10),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=80,RECFM=FB,BLKSIZE=6160,DSORG=PO)"
                    ]
                }
            ],
            "ADMINDATASET": [
                {
                    "ddName": "ADMINDATASET",
                    "ddDef": [
                        "ADMIN_DATASET_TYPE= ''SRCVF'',",
                        "ADMIN_DATASET_DSN= ''&JOBNAME..SRCVF''",
                        "ADMIN_DATASET_SPACE_PRIQTY= ''300''",        // Admin data sets
                        "ADMIN_DATASET_SPACE_SECQTY= ''100''",
                        "ADMIN_DATASET_SPACE_TYPE= ''CYL'';",
                        "ADMIN_DATASET_TYPE= ''TGTVF'',",
                        "ADMIN_DATASET_DSN= ''&JOBNAME..TGTVF''",
                        "ADMIN_DATASET_SPACE_PRIQTY= ''300''",
                        "ADMIN_DATASET_SPACE_SECQTY= ''100''",
                        "ADMIN_DATASET_SPACE_TYPE= ''CYL'';"
                    ]
                }
            ]
        }
    }
}

Sample dataSetOverrides object in a RUN plan request:
{
   
    "dataSetOverrides": {
        "overrideDD": {
            "ADDL": [
                {
                    "ddName": "DFSPARM",
                    "ddDef": [
                       "OPTION DYNALLOC=(SYSALLDA,70)"     // Sort data set with increased space
                    ]
                }
            ],
            "GOCCM": [
                {
                    "ddName": "SYSIN",
                    "ddDef": [
                        "DSN=&SYSIN",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRC2OUT",
                    "ddDef": [
                        "DSN=&SRC2OUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",             /// GOCCM data sets 
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRCSOUT",
                    "ddDef": [
                        "DSN=&SRCSOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRCSIN",
                    "ddDef": [
                        "DSN=&SRCSIN",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "SRTBOUT",
                    "ddDef": [
                        "DSN=&SRTBOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(200,300),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16800,RECFM=VB,BLKSIZE=27998)"
                    ]
                },
                {
                    "ddName": "NEWDD",
                    "ddDef": [
                        "DSN=&NEWDD",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "OLDDD",
                    "ddDef": [
                        "DSN=&OLDDD",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=32760,RECFM=VB,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ISPWRK1",
                    "ddDef": [
                        "DSN=&ISPWRK1",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(20,30),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ISPWRK2",
                    "ddDef": [
                        "DSN=&ISPWRK2",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(20,30),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(RECFM=FB,LRECL=256,BLKSIZE=256,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "CATOUT",
                    "ddDef": [
                        "DSN=&CATOUT",
                        "DISP=(,DELETE)",
                        "SPACE=(TRK,(100,100),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=16384,RECFM=VB,BLKSIZE=27998,DSORG=PS)"
                    ]
                },
                {
                    "ddName": "ADBWLT",
                    "ddDef": [
                        "DSN=&ADBWLT",
                        "DISP=(,DELETE)",
                        "SPACE=(CYL,(25,25,10),RLSE)",
                        "UNIT=&SPCUNIT",
                        "DCB=(LRECL=80,RECFM=FB,BLKSIZE=6160,DSORG=PO)"
                    ]
                }
            ]
        }
    }
}