Samstag, 19 of April of 2014

New ADMIN_UPDATE_SYSPARM stored procedure

The SYSPROC.ADMIN_UPDATE_SYSPARM stored procedure changes the value of one or more DB2 subsystem parameters located in one of these macros: DSN6SPRM, DSN6ARVP, DSN6LOGP, DSN6SYSP, DSN6FAC, and DSN6GRP. It builds a subsystem paramters load module, and if requested by the user, loads it into storage by issuing the DB2 command -SET SYSPARM command with the LOAD option. If not all of the subsystem parameters modified are online updatable, -SET SYSPARM command with the LOAD option will not be performed.

DB2 10 for z/OS documentation:

DB2 9 for z/OS documentation: