IT33814: REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• It affects PureScale instances only.
  
  When remove audit policy after drop role , you may encountered
  DB21034E.
  --
  DB21034E The command was processed as an SQL statement because
  it was not a valid Command Line Processor command. During SQL
  processing it returned: SQL1034C The database was damaged, so
  all applications processing the database were stopped.
  SQLSTATE=58031
  --
  
  When drop policy, you may encountered SQL0901C.
  ---
  SQL0901N  The SQL statement or command failed because of a
  database system
  error. (Reason "Zero policies in list".)  SQLSTATE=58004
  ---
  
  This error affects both ROLEs and TRUSTED CONTEXT objects.
  

Local fix

• Drop policy before drop role.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.1.4.7                                          *
  ****************************************************************
  

Problem conclusion

• Upgrade to 11.1.4.7
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT33761

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP