DB2 - Problembeschreibung
Problem IC70674 | Status: Geschlossen |
If you have set the BLOCKNONLOGGED parameter to YES, then you will encounter error SQL20054N while creating EXPLAIN tables. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
If the database configuration parameter BLOCKNONLOGGED is set to YES, then some of the DDLs used within EXPLAIN.DDL file and the SQL statement calling the stored procedure SYSPROC.SYSINSTALLOBJECTS to create EXPLAIN tables will fail with error SQL20054N. For example: "CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN','C',NULL,CURRENT SCHEMA)". | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All users below V9.7 FP4 version are affected. * **************************************************************** * PROBLEM DESCRIPTION: * * If you have set the BLOCKNONLOGGED parameter to YES, then * * you will encounter error SQL20054N while creating EXPLAIN * * tables. * **************************************************************** * RECOMMENDATION: * * Upgrade to version V9.7 FP4 to resolve the problem. * **************************************************************** | |
Local-Fix: | |
Edit the EXPLAIN.DDL file and remove the NOT LOGGED clause. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
Problem fixed in V9.7 FP4. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC75116 IC75171 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 20.08.2010 02.05.2011 02.05.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |