Under rare circumstances, minor memory leak in catalog cache can
occur if the following conditions are met:
- RTS (real time statistics) is enabled
- Asynchronous RUNSTATS fails with error code SQL0973N. An error
message will be logged in the event log
for example:
2014-10-13-20.24.37.450827-240 E1732609A716 LEVEL: Event
PID : 34275468 TID : 20977 KTID :
91553865
PROC : db2sysc 1
INSTANCE: MYINST NODE : 001 DB : MYDB
APPHDL : 0-32854 APPID: *N0.myinst.141013192943
AUTHID : MYINST HOSTNAME:
EDUID : 20977 EDUNAME: db2agntp (TEST1C) 1
FUNCTION: DB2 UDB, relation data serv, sqlrLocalRunstats,
probe:10070
COLLECT : TABLE AND INDEX STATS : Object name with schema : AT
"2014-10-13-20.24.37.450720" : BY "Asynchronous" : start
OBJECT : Object name with schema, 36 bytes
SCH1 .TAB1
IMPACT : None
DATA #1 : String, 10 bytes
RTS Daemon
2014-10-13-20.24.37.604352-240 I1732609A1031 LEVEL:
Severe
PID : 34275468 TID : 20977 KTID :
91553865
PROC : db2sysc 1
INSTANCE: MYINST NODE : 001 DB : MYDB
APPHDL : 0-32854 APPID: *N0.myinst.141013192943
AUTHID : MYINST HOSTNAME:
EDUID : 20977 EDUNAME: db2agntp (TEST1C) 1
FUNCTION: DB2 UDB, relation data serv, sqlrLocalRunstats,
probe:12236
MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
"SQLCA has already been built"
DATA #1 : unsigned integer, 8 bytes
11493
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -973 sqlerrml: 15
sqlerrmc: CATALOGCACHE_SZ
sqlerrp : SQLRC0B3
sqlerrd : (1) 0x8B0F0008 (2) 0x00000008 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFFD8 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2014-10-13-20.24.37.605996-240 E1732609A923 LEVEL: Event
PID : 34275468 TID : 20977 KTID :
91553865
PROC : db2sysc 1
INSTANCE: MYINST NODE : 001 DB : MYDB
APPHDL : 0-32854 APPID: *N0.myinst.141013192943
AUTHID : MYINST HOSTNAME:
EDUID : 20977 EDUNAME: db2agntp (TEST1C) 1
FUNCTION: DB2 UDB, relation data serv, sqlrLocalRunstats,
probe:12313
COLLECT : TABLE AND INDEX STATS : Object name with schema : AT
"2014-10-13-20.24.37.605928" : BY "Asynchronous" : failure
OBJECT : Object name with schema, 36 bytes
SCH1 .TAB1
IMPACT : None
DATA #1 : String, 10 bytes
RTS Daemon
DATA #2 : String, 122 bytes
RUNSTATS ON TABLE "SCH1 "."TAB1" ON ALL COLUMNS WITH
DISTRIBUTION ON ALL COLUMNS AND INDEXES ALL
DATA #3 : String, 26 bytes
ZRC=0x8012006D=-2146303891 |
