DSNA666I csect-name A REQUIRED ACTION WAS NOT COMPLETED AFTER THE SUBSYSTEM PARAMETERS WERE MODIFIED. ACTION-TYPE= action-type. REASON CODE=reason-code. additional-info
Explanation
A user modified the value of at least one Db2 subsystem parameter by using the SYSPROC.ADMIN_UPDATE_SYSPARM stored procedure. However, Db2 did not complete a required or requested action after the subsystem parameter values were changed.
Message DSNA666I is returned in the result table of the SYSPROC.ADMIN_UPDATE_SYSPARM stored procedure.
- csect-name
- The name of the control section that issued the message.
- action-type
- A numeric value that identifies the action that failed. action-type can
be one of the following values:
- 01
- The SET SYSPARM command with the LOAD option was not invoked.
- 02
- The message DSNA658I was not displayed on the JES SYSLOG.
- reason-code
- A numeric value that indicates the reason for the failure. reason-code can
be one of the following values:
- 01
- The meaning depends on the action-type value
as follows:
- If the action-type is 01, at least one modified subsystem parameter cannot be changed online.
- If the action-type is 02, the stored procedure encountered an error while displaying a DSNA658I message on the JES SYSLOG.
- 02
- Synchronous processing of the SET SYSPARM command is not supported.
- additional-info
- Additional descriptive text that explains the reason that the
specified action failed.
Although additional-info is part of message DSNA666I, it is not returned in the same result set row. additional-info is returned in a separate row after DSNA666I.
System action
Processing continues.
User response
Depending on the value of action-type and reason-code take one of the following actions:
| action-type value | reason-code value | Corrective action |
|---|---|---|
| 01 | 01 | In the input table SYSIBM.SYSPARM_SETTINGS, specify only those subsystem parameters that can be changed online. |
| 01 | 02 | Ensure that APAR PM40501 is installed. |
| 02 | 01 | Check for the return code from module DSNADMCC in the additional-info field and report the problem to IBM® Software Support. |