Exception processing

During initialization or authorization checking, Db2 issues diagnostic message DSNX210I to the operator's console when an error condition occur.

Begin program-specific programming interface information.Db2 issues diagnostic message DSNX210I if one of the following conditions occur:
  • The authorization exit returns a return code of 12 or an invalid return code.
  • The authorization exit abnormally terminates.

Additional actions that Db2 performs depend on the reason code that the exit returns during initialization. The following is a list of these actions.

Table 1. How an error condition affects Db2 actions during initialization and authorization checking
Exit result Reason code of 16 returned by exit routine during initialization Reason code other than 16 or -1 returned by exit routine during initialization1
Return code 12
  • The task2 abnormally terminates with reason code 00E70015
  • Db2 terminates
  • The task2 abnormally terminates with reason code 00E70009
  • Db2 switches to Db2 authorization checking
Invalid return code
  • The task2 abnormally terminates with reason code 00E70015
  • Db2 terminates
  • The task2 abnormally terminates with reason code 00E70009
  • Db2 switches to Db2 authorization checking
Abnormal termination during initialization Db2 terminates Db2 switches to Db2 authorization checking
Abnormal termination during authorization checking You can use the subsystem parameter AEXITLIM3 to control how Db2 and the exit behave.

Example: If you set AEXITLIM to 10, the exit routine continues to run after the first 10 abnormal terminations. On the eleventh abnormal termination, the exit stops and Db2 terminates.

 You can use the subsystem parameter AEXITLIM to control how Db2 and the exit behave.

Example: If you set AEXITLIM to 10, the exit routine continues to run after the first 10 abnormal terminations. On the eleventh abnormal termination, the exit routine stops and Db2 switches to Db2 authorization checking.
Note:
  1. During initialization, Db2 sets a value of -1 to identify the default exit. The user exit routine should not set the reason code to -1.
  2. During initialization, the task is Db2 startup. During authorization checking, the task is the application.
  3. AEXITLIM (authorization exit limit) can be updated online.
End program-specific programming interface information.