How can I make the DB2 work file table space generator program (DSNTWFG) create work file table spaces with an explicit SECQTY?

Answer

The DB2 work file table space generator program (DSNTWFG) always creates the work file table spaces with a default secondary space (SECQTY) allocation. To cause it to use an explicit SECQTY value when creating work file table spaces, you need to modify it as follows:

(1) Edit member DSNTWFG in your prefix.SDSNCLST target library, or your private copy of DSNTWFG.

(2) Locate the following code:

IF priQty > 0 THEN /* If no PRIQTY go with default*/
DO
priQtyInKB = priQty * 1024
SQLSTMT = SQLSTMT,
"PRIQTY" priQtyInKB
END

(3) Below this, add the following code:

SQLSTMT = SQLSTMT,
"SECQTY n"

Where 'n' is the desired secondary space allocation for work file table spaces.

The updated code should be similar to that shown below:

:
IF priQty > 0 THEN /* If no PRIQTY go with default*/
DO
priQtyInKB = priQty * 1024
SQLSTMT = SQLSTMT,
"PRIQTY" priQtyInKB
END

SQLSTMT = SQLSTMT,
"SECQTY n"
:

(4) Save your changes.

(5) Be sure that the SYSEXEC DD of the job you use to execute DSNTWFG
allocates the library with your updated copy.