|
Problem IC63335
|
Status: Closed |
DROP EXPLAIN TABLES VIA SYSINSTALLOBJECTS RETURNS SQL0204N. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Calling SYSINSTALLOBJECTS to drop the explain tables can return
SQL0204N when certain explain tables/obeject are missing.
it should nto report this as it should not matter they do not
exist. We still continue to drop the other related objects, but
this should be ignored as we are looking to drop the object
anyway.
eg.
SYSPROC.SYSINSTALLOBJECTS('EXPLAIN', 'D', CAST (NULL AS
VARCHAR(128)),'MYSCHEMA' ) |
| Problem Summary: |
DROP EXPLAIN TABLES VIA SYSINSTALLOBJECTS RETURNS SQL0204N. |
| Local Fix: |
This error can be ignored since we continue to drop the other
object. We can then Create the EXPLAIN object afterwards. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.09.2009
17.05.2010
17.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
