DB2 - Problembeschreibung
Problem IC71872 | Status: Geschlossen |
SQLCODE -901 WITH REASON "ERROR IN GETTING COLDIST_DATA FROM STATS PROFILE" OBSERVED WITH STATEMENT COMPILATION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
The query compiler may return sqlcode -901 with reason "Error in getting coldist_data from stats profile" when processing distribution statistics for the tables involved in the query. Example db2diag.log message: 2010-09-03-16.22.49.982651-240 I227585A815 LEVEL: Severe PID : 3101176 TID : 1 PROC : db2agent (sample) 0 INSTANCE: db2inst1 NODE : 000 DB : sample APPHDL : 0-1789 APPID: *N0.db2inst1.100903201620 AUTHID : db2inst1 FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 48 sqlerrmc: Error in getting coldist_data from stats profile sqlerrp : SQLNQ741 sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all * **************************************************************** * PROBLEM DESCRIPTION: * * The query compiler may return sqlcode -901 with reason * * "Error in * * getting coldist_data from stats profile" when processing * * * * distribution statistics for the tables involved in the * * query. * * * * * * Example db2diag.log message: * * * * * * * * 2010-09-03-16.22.49.982651-240 I227585A815 LEVEL: * * Severe * * * * * * PID : 3101176 TID : 1 PROC : db2agent (sample) 0 * * * * * * * * INSTANCE: db2inst1 NODE : 000 DB : * * sample * * * * * * APPHDL : 0-1789 APPID: * * *N0.db2inst1.100903201620 * * * * * * AUTHID : db2inst1 * * * * * * * * FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0 * * * * * * * * DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes * * * * * * * * sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 48 * * * * * * sqlerrmc: Error in getting coldist_data from stats profile * * * * * * * * sqlerrp : SQLNQ741 * * * * * * * * sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) * * * * 0x00000000 * * * * (4) 0x00000000 (5) 0xFFFFFF9C (6) * * * * 0x00000000 * * * * sqlwarn : (1) (2) (3) (4) (5) (6) * * * * * * * * (7) (8) (9) (10) (11) * * * * * * * * sqlstate: * **************************************************************** * RECOMMENDATION: * * Upgrade to V9.5 fixpack 8 or later * **************************************************************** | |
Local-Fix: | |
It is likely that the error will stop after collecting statistics for affected tables. It is important to consider that the affected tables may include tables that are not directly referenced in the user-specified SQL, for example, replicated tables and MQTs. The statistics collection should have the same num_freqvalues and num_quantiles specification for all the columns of the table. For example, the following runstats commands collect distribution statistics for all columns using the database default num_freqvalues and num_quantiles settings. RUNSTATS ON TABLE S.T WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL RUNSTATS ON TABLE S.T_REPLICATED WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL RUNSTATS ON TABLE S.T_SUMMARY1 WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem was first fixed in V9.5 Fixpack 8 | |
Workaround | |
see Local Fix. | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.10.2010 07.07.2011 07.07.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |