Change default value of PAGENUM attribute in Db2 Admin tools

Products

• RC/Migrator for DB2 for z/OS
• RC/Update for DB2 for z/OS

Issue/Introduction

The Db2 default value of the PAGENUM attribute is ABSOLUTE.

Can the default value be changed globally so that the PAGENUM attribute defaults to RELATIVE when generated for the CREATE TABLESPACE DDL statement?

Environment

RC/Migrator for Db2 for z/OS (RCM)

RC/Update for Db2 for z/OS (RCU)

Cause

Resolution

A new default value can be set using the 'Define Defaults for Db2 Object Attributes' function.

From the RC/Migrator or RC/Update main menus enter command:

DEFAULTS (can be abbreviated to DEF)

DESCRIPTION : The DEFAULTS command is used to specify your own default values
              for a variety of DB2 object attributes.  The defaults you
              establish will then be used as initial values on the appropriate
              DB2 object creation screens.

Use the online(PF1) help when in the function to get more information.

The defaults can be set up for all users, one user or a selection of users based on an authid mask. Decide which authid or groups of authids this default will apply to and set the authid mask accordingly when you save the defaults record.

You specify the maskid in the Userid field as below.

ROPSYSD1 ----- Object Definition Defaults for SYSADM ----- 2024/05/21 10:50:51
OPTION  ===>                                                  SCROLL ===> PAGE

Userid      ==> maskid        Action ==> _ (R - Retrieve, S - Save, D - Delete)

To change the default value for PAGENUM, scroll down to the Tablespace section.

PAGENUM will currently be set to ABSOLUTE. Change the default to RELATIVE.

PAGENUM                 RELATIVE         (Absolute,Relative)

Then scroll back up to the header and update the Userid field to your chosen maskid. If you want to set this value for all users, you can specify '*'.

For example:

ROPSYSD1 ----- Object Definition Defaults for SYSADM ----- 2024/05/21 10:50:51
OPTION  ===>                                                  SCROLL ===> PAGE

Userid      ==> *             Action ==> s (R - Retrieve, S - Save, D - Delete)

Enter 's' in the Action field and hit ENTER to save the new defaults.

PT224I USER DEFAULTS HAVE BEEN SAVED.

Now when you create a new PBR Tablespace the default PAGENUM value appearing on the Tablespace creation screen will be RELATIVE:

PAGENUM     => RELATIVE

and in the DDL generated...

CREATE TABLESPACE TEST
       USING STOGROUP SYSDEFLT
           PRIQTY -1
           SECQTY -1
           ERASE NO
       BUFFERPOOL BP0
       CLOSE YES
       LOCKMAX 0
       SEGSIZE 4
       INSERT ALGORITHM 0
       PAGENUM RELATIVE
       DEFINE YES
       LOGGED
       LOCKSIZE ANY
       MAXROWS 255
       NUMPARTS 1

Additional Information

For further details, please refer to the Define Defaults for Db2 Object Attriubutes.