DB2 - Problembeschreibung
Problem IT07256 | Status: Geschlossen |
DB2SUPPORT FAILED TO COLLECT DATA FOR SYNOPSIS TABLES IF THE TABLES INVOLVED CONTAIN '/' IN THE TABLE NAME | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
When you run db2support to collect optimizer data for a query, and if the tables involved are column organized tables. db2support collects data for the associated synopsis tables as well and store them in db2support/db2supp_opt/OPTIMIZER/BLU. If the table name for column organized tables contains special charactor like '/' , the data collection for the synopsis table would fail. and in optimizer.log, you may see errors like the following: ************** select count(*) from SYSIBM.SYN140509134229640085_/BIC/SSHIP_TO SQL Code: "0" rc "1" Error invoking "select count(*) from SYSIBM.SYN140509134229640085_/BIC/SSHIP_TO" describe select * from SYSIBM.SYN140509134229640085_/BIC/SSHIP_TO SQL Code: "0" rc "1" Error invoking "describe select * from SYSIBM.SYN140509134229640085_/BIC/SSHIP_TO" **************** | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to V105FP7+. * **************************************************************** | |
Local-Fix: | |
Lösung | |
V105FP7+ contains the fix. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.02.2015 25.08.2015 25.08.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.6 |