DB2 - Problem description
Problem IC90506 | Status: Closed |
DB2 COMMAND EDITOR CRASHES WHILE RUNNING VISUAL EXPLAIN | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
If you have an XML index and you are trying to use Visual Explain to get the explain information, the DB2 Command Editor may crash. A java core is created in %DB2PATH%\tools with a similar stack trace : 4XESTACKTRACE at com/ibm/db2/tools/ve/VEDriver.processVisualExplainGraph(Native Method) 4XESTACKTRACE at com/ibm/db2/tools/ve/LOB.processTheLOB(Bytecode PC:169) 4XESTACKTRACE at com/ibm/db2/tools/ve/LOB.<init>(Bytecode PC:192) 4XESTACKTRACE at com/ibm/db2/tools/ve/VEExplainHist.getSnapShotBLOB(Bytecode PC:678) 4XESTACKTRACE at com/ibm/db2/tools/ve/VERequest.dynamicExplain(Bytecode PC:618) 4XESTACKTRACE at com/ibm/db2/tools/ve/VERequest.executeInThread(Bytecode PC:323) 4XESTACKTRACE at com/ibm/db2/tools/ve/VERequest.run(Bytecode PC:20) 4XESTACKTRACE at java/lang/Thread.run(Thread.java:736) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 Command Editor * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.7 FP9 or above * **************************************************************** | |
Local Fix: | |
N/A | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
The problem was first fixed in DB2 9.7 FP9 | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC95207 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.02.2013 02.10.2013 02.10.2013 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.9 | |
9.7.0.9 |