-SET SYSPARM command (Db2)

You can use the SET SYSPARM command to change subsystem parameters that can be updated online, while Db2 is started.

Environment

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program that uses the instrumentation facility interface (IFI).

Data sharing scope: Member

Authorization

To execute this command, you must use a privilege set of the process that includes one of the following authorities:
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority
  • SECADM authority

To change the following security-related subsystem parameters, the privilege set of the process must include installation SYSADM authority or SECADM authority:

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. Start of changeA logged-on z/OS user ID must be defined in RACF or a similar security server.End of change

Syntax

Read syntax diagramSkip visual syntax diagram SET SYSPARM LOAD(DSNZPARMload-module-name)RELOADSTARTUP

Option descriptions

LOAD( load-module-name )
Start of change Specifies the name of the subsystem parameter load module to load into storage. The subsystem parameter load module is generated by installation job DSNTIJUZ. The default load module name is DSNZPARM.End of change
RELOAD
Reloads the last named subsystem parameter load module into storage.
STARTUP
Resets loaded parameters to their startup values.

Usage notes

To update the subsystem parameters on a subsystem, follow these steps:
  1. Run through the installation process in Update mode.
  2. Produce a new subsystem parameter load module.
  3. Issue the SET SYSPARM command.
    Important:
    • Do not issue SET SYSPARM while you are compressing the data set that contains the new subsystem parameter load module.
    • If you are compressing the data set that contains the new subsystem parameter load module, and the data set resides in the system LLA, after you compress the data set, and before you issue SET SYSPARM, issue command F LLA, REFRESH. Wait for message CSV210I, which indicates that F LLA, REFRESH is complete.

If you attempt to change installation SYSADM or installation SYSOPR subsystem parameters and you do not have the proper authority, the parameter values that are in place prior to the load of the new subsystem-parameter module are used instead of the unauthorized values in the new module. Db2 issues message DSNZ015 for each attempt of an unauthorized change to a subsystem parameter.

Examples

Example 1: Change from DSNZPARM to ADMPARM1. 
-SET SYSPARM LOAD(ADMPARM1)
Example 2: Reload ADMPARM1 if it is the currently running load module. 
-SET SYSPARM RELOAD
Example 3: Reload the subsystem parameters that the Db2 subsystem loaded at startup. 
-SET SYSPARM STARTUP