When running a query using ADMIN_GET_TAB_COMPRESS_INFO the
following stack may be repeatedly seen in the db2diag.log whilst
this is running:
2016-11-23-11.37.20.508223+000 I1968A3700 LEVEL: Error
PID : 3343030 TID : 470126 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-33079 APPID:
*LOCAL.db2inst1.161123113613
AUTHID : db2inst1 HOSTNAME: db2host
EDUID : 470126 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldPrefetchForEstimate,
probe:7433
MESSAGE : ZRC=0x00000063=99
DATA #1 : String, 50 bytes
Error occurred when prefetching pages for estimate
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x090000000A16BC4C
sqldBuildDictionary__FP13SQLD_DFM_WORKP13SQLD_REORG_CBUiPcPP15sq
ldDictBuilderPP18SQLD_TCB_DICT_INFOP20SQLD_SAMPLINGPRED_CB +
0x2F24
[1] 0x090000000A16B23C
sqldBuildDictionary__FP13SQLD_DFM_WORKP13SQLD_REORG_CBUiPcPP15sq
ldDictBuilderPP18SQLD_TCB_DICT_INFOP20SQLD_SAMPLINGPRED_CB +
0x2514
[2] 0x090000000A169A60
sqldBuildDictionary__FP13SQLD_DFM_WORKP13SQLD_REORG_CBUiPcPP15sq
ldDictBuilderPP18SQLD_TCB_DICT_INFOP20SQLD_SAMPLINGPRED_CB +
0xD38
[3] 0x090000000FC31648
sqldBuildDictionaryForEstimate__FP8sqeAgentP8SQLD_TCBP13SQLD_DFM
_WORKUiPcP20SQLD_SAMPLINGPRED_CBP18SQLD_TAB_DICT_INFO + 0x110
[4] 0x090000000DFFA204
sqldGetTableDataForPermOrTemp__FP8sqeAgentP19SQLD_TABLE_DATA_REQ
P15SQLD_TABLE_DATAUsT4UcT4Ul + 0x55C
[5] 0x090000000DFB9988
sqldGetTableDataForPermOrTemp__FP8sqeAgentP19SQLD_TABLE_DATA_REQ
P15SQLD_TABLE_DATAUsT4UcT4Ul + 0x148C
[6] 0x090000000DFB8124
sqldGetTableData__FP8sqeAgentP19SQLD_TABLE_DATA_REQP15SQLD_TABLE
_DATA + 0x160
[7] 0x090000000FD99888 sqlerTrustedRtnCallbackRouter__FUiPPv +
0x23464
[8] 0x090000000FD76618 sqlerTrustedRtnCallbackRouter__FUiPPv +
0x1F4
[9] 0x090000001F24059C
call_get_tab_info__FPcT1UiPsT4P16sqludf_call_typePFUiPPv_iP23adm
inTabInfoScratchAreaP5sqlca + 0x39C
[10] 0x090000001F242F64 admin_get_tab_compress_estimate + 0xC4
[11] 0x090000000E233758 sqloInvokeFnArgs + 0x592C
[12] 0x0000000000000000 ?unknown + 0x0
[13] 0x090000000E1B9BB0 sqlriInvokeInvoker__FP10sqlri_ufobb +
0xF08
[14] 0x090000000E1B9678 sqlriInvokeInvoker__FP10sqlri_ufobb +
0x9D0
[15] 0x090000000C7FFB7C
sqlriFetch__FP8sqlrr_cbP9sqlri_taol@OL@24898 + 0x38C
[16] 0x090000000E6224AC sqlriFetch__FP8sqlrr_cbP9sqlri_taol +
0x6C
[17] 0x090000000E6224AC sqlriFetch__FP8sqlrr_cbP9sqlri_taol +
0x6C
[18] 0x090000000E66C264
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x1C
[19] 0x090000000E63FB78
sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x520
[20] 0x090000000E992A74
sqlrr_process_fetch_request__FP14db2UCinterface + 0x170
[21] 0x090000000E98ACD0
sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x29C
[22] 0x090000000E1D109C
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0xE04
[23] 0x090000000E1F57FC
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC
interface + 0x770
[24] 0x090000000DA4AFD0
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb@OL@224
52 + 0x654
[25] 0x090000000E240F10
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x2C
[26] 0x090000000E1C7B5C
@72@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0xE44
[27] 0x090000000D84EA08
@72@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xA8
[28] 0x090000000D84F51C
@72@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5F8
[29] 0x090000000DAF992C RunEDU__8sqeAgentFv + 0x3D900
[30] 0x090000000DB45D48 RunEDU__8sqeAgentFv + 0x120
[31] 0x090000000EC6F790 EDUDriver__9sqzEDUObjFv + 0x130
[32] 0x090000000DF3A1E8 sqloEDUEntry + 0x390
[33] 0x0900000000515E10 _pthread_body + 0xF0
[34] 0xFFFFFFFFFFFFFFFC ?unknown + 0xFFFFFFFF
If the return code shows as:
ZRC=0x00000063=99
then this can be safely ignored as this is a not an error.
A change will be made to prevent this message from being
incorrectly logged.
Stack may also shows as:
sqldBuildDictionary(SQLD_DFM_WORK*,SQLD_REORG_CB*,unsigned
int,char*,sqldDictBuilder**,SQLD_TCB_DICT_INFO**,SQLD_SAMPLINGPR
ED_CB*) + 0x2F24
sqldBuildDictionary(SQLD_DFM_WORK*,SQLD_REORG_CB*,unsigned
int,char*,sqldDictBuilder**,SQLD_TCB_DICT_INFO**,SQLD_SAMPLINGPR
ED_CB*) + 0x2514
sqldBuildDictionary(SQLD_DFM_WORK*,SQLD_REORG_CB*,unsigned
int,char*,sqldDictBuilder**,SQLD_TCB_DICT_INFO**,SQLD_SAMPLINGPR
ED_CB*) + 0xD38
sqldBuildDictionaryForEstimate(sqeAgent*,SQLD_TCB*,SQLD_DFM_WORK
*,unsigned int,char*,SQLD_SAMPLINGPRED_CB*,SQLD_TAB_DICT_INFO*)
+ 0x110
sqldGetTableDataForPermOrTemp(sqeAgent*,SQLD_TABLE_DATA_REQ*,SQL
D_TABLE_DATA*,unsigned short,unsigned short,unsigned
char,unsigned short,unsigned long) + 0x55C
sqldGetTableDataForPermOrTemp(sqeAgent*,SQLD_TABLE_DATA_REQ*,SQL
D_TABLE_DATA*,unsigned short,unsigned short,unsigned
char,unsigned short,unsigned long) + 0x148C
sqldGetTableData(sqeAgent*,SQLD_TABLE_DATA_REQ*,SQLD_TABLE_DATA*
) + 0x160
sqlerTrustedRtnCallbackRouter(unsigned int,void**) + 0x23464
sqlerTrustedRtnCallbackRouter(unsigned int,void**) + 0x1F4
call_get_tab_info(char*,char*,unsigned
int,short*,short*,sqludf_call_type*,int(*)(unsigned
int,void**),adminTabInfoScratchArea*,sqlca*) + 0x39C
admin_get_tab_compress_estimate + 0xC4
sqloInvokeFnArgs + 0x592C
?unknown + 0x0
sqlriInvokeInvoker(sqlri_ufob*,bool) + 0xF08
sqlriInvokeInvoker(sqlri_ufob*,bool) + 0x9D0
sqlriFetch(sqlrr_cb*,sqlri_tao*,long)@OL@24898 + 0x38C
sqlriFetch(sqlrr_cb*,sqlri_tao*,long) + 0x6C
sqlriFetch(sqlrr_cb*,sqlri_tao*,long) + 0x6C
sqlriSectInvoke(sqlrr_cb*,sqlri_opparm*) + 0x1C
sqlriSectInvoke(sqlrr_cb*,sqlri_opparm*) + 0x520
sqlrr_process_fetch_request(db2UCinterface*) + 0x170
sqlrr_open(db2UCinterface*,db2UCCursorInfo*) + 0x29C
sqljsParseRdbAccessed(sqljsDrdaAsCb*,sqljDDMObject*,db2UCinterfa
ce*) + 0xE04
sqljsParseRdbAccessed(sqljsDrdaAsCb*,sqljDDMObject*,db2UCinterfa
ce*) + 0x770
sqljsParse(sqljsDrdaAsCb*,db2UCinterface*,sqeAgent*,bool)@OL@224
52 + 0x654
@72@sqljsSqlam(db2UCinterface*,sqeAgent*,bool) + 0x2C
@72@sqljsSqlam(db2UCinterface*,sqeAgent*,bool) + 0xE44
@72@sqljsDriveRequests(sqeAgent*,db2UCconHandle*) + 0xA8
@72@sqljsDrdaAsInnerDriver(SQLCC_INITSTRUCT_T*,bool) + 0x5F8
sqeAgent::RunEDU() + 0x3D900
sqeAgent::RunEDU() + 0x120
sqzEDUObj::EDUDriver() + 0x130
sqloEDUEntry + 0x390
_pthread_body + 0xF0
?unknown + 0xFFFFFFFF |
