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:

• New system parameter: ADMIN_SET_SYSPARM stored procedure
• Administration: ADMIN_COMMAND_DB2 stored procedure
• Installation:
  • Additional steps for enabling the administrative task scheduler and administrative enablement routines
  • DB2-supplied stored procedures and user-defined functions
  • Core WLM environments for DB2-supplied routines
  • DB2 administration routines panel: DSNTIPRL

DB2 9 for z/OS documentation:

• New system parameter: ADMIN_SET_SYSPARM stored procedure
• Administration: ADMIN_COMMAND_DB2 stored procedure
• Installation:
  • Additional steps for enabling the administrative task scheduler and administrative enablement routines
  • Enabling DB2-supplied routines
  • Setting up a WLM application environment for stored procedures
  • Job DNSTIJSG