|
Problem IT33761
|
Status: Closed |
REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem 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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* pureScale *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V11.1 or V11.5 which is fixed version. *
**************************************************************** |
| Local Fix: |
Drop policy before drop role. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* pureScale *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V11.1 or V11.5 which is fixed version. *
**************************************************************** |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2020
04.11.2021
04.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
