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.