Application programming default values

Each DB2® for z/OS® subsystem has a set of application programming default values. These values are the default settings for SQL applications that run on that subsystem. For example, the ENSCHEME application programming default value specifies the default encoding scheme for new objects. Some users colloquially refer to these values as DECP values.

System administrators generally set the application programming default values when they install or migrate DB2. After installation or migration, a system administrator should change these values only if necessary and according to the update advice that is documented for each application programming value. Changing an application programming default value requires DB2 to be stopped and restarted.

For a list of application programming defaults, see Directory of subsystem parameters, panel fields, and application default values.

Application programming default values are contained in the DSNHDECP load module that is generated by installation job DSNTIJUZ. In a data sharing environment, each member is not required to have a separate application defaults load module. The DSNHDECP module is also required by the DB2 precompiler and coprocessor for C, C++, COBOL, and PL/I.

One way to check the application programming default values is to call stored procedure SYSPROC.ADMIN_INFO_SYSPARM by running sample job DSNTEJ6Z. For certain application programming defaults, you can also check the value by invoking the GETVARIABLE function.