DB2 - Problembeschreibung
Problem IC82606 | Status: Geschlossen |
ADMIN_MOVE_TABLE() MAY FAIL WITH SQL0567N IF A TABLE HAS "PUBLIC" PRIVILEGE GRANTED | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If a table has the PUBLIC privilege granted then an ADMIN_MOVE_TABLE() may fail during SWAP phase with SQL0567N. For examle, suppose table T1 has the following authorization: GRANT SELECT ON TABLE "MYSCHEMA"."T1" TO PUBLIC ; Then ADMIN_MOVE_TABLE() might fail: CALL SYSPROC.ADMIN_MOVE_TABLE( 'MYSCHEMA', 'T1', 'TABLESPACEA', 'TABLESPACEB', 'TABLESPACEA', '', '', '', '','','SWAP' ) STAGING : T1xyz STATUS : REPLAY TARGET : QCM8T1 VERSION : 09.07.0005 ADMIN_MOVE_TABLE - SWAP step aborted. SQL0567N The operation failed because the specified authorization name does not meet the identifier naming rules. Authorization name: "PUBLIC". SQLSTATE=42602 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Problem Description above. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 7. * **************************************************************** | |
Local-Fix: | |
Revoke the SELECT privilege on the source table to the PUBLIC group before the SWAP, and then after the SWAP is finished successfully, set the privilege back from the command line immediately, i.e.: db2 revoke SELECT ON TABLE "MYSCHEMA"."T1" from public db2 "CALL SYSPROC.ADMIN_MOVE_TABLE( 'MYSCHEMA', 'T1', 'TABLESPACEA', 'TABLESPACEB', 'TABLESPACEA', '', '', '', '','','SWAP' )" db2 grant SELECT ON TABLE "MYSCHEMA"."T1" to public | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in Version 9.7 Fix Pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC87909 IC88627 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 11.04.2012 25.10.2012 25.10.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP7 | |
Problem behoben lt. FixList in der Version | |
9.7.0.7 |