When issuing drop/create a table frequently, CREATE TABLE
statement will return SQL1655C intermittently. Here is a
sample scenario using an SMS tablespace:
loop1 (=0,1,2, ...)
drop / create tablespace
loop2 (=0,1,2 ; max 3 loops)
db2trc on -f db2trc_loop1_loop2.dmp -t
drop / create table (<= will cause SQL1655C)
load which cause log full in delete phase
drop / create table
sleep 600
db2trc off
end of loop2
end of loop1
2016-06-22-13.31.06.274768+540 I97657A6488 LEVEL:
Severe
PID : 12345678 TID : 45678 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-958 APPID:
*LOCAL.db2inst1.160622043107
AUTHID : DB2INST1 HOSTNAME: host1
EDUID : 45678 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page,
probe:2
MESSAGE : ZRC=0x86020001=-2046689279=SQLB_BADP "page is bad"
DIA8400C A bad page was encountered.
DATA #1 : String, 64 bytes
Error encountered trying to read a page - information follows :
DATA #2 : String, 23 bytes
Page verification error
DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
0
DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 104 bytes
Obj: {pool:492;obj:2;type:0} Parent={492;2}
2016-06-22-13.31.14.389723+540 E138507A646 LEVEL:
Warning
PID : 12345678 TID : 45678 PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
APPHDL : 0-958 APPID:
*LOCAL.db2inst1.160622043107
AUTHID : DB2INST1 HOSTNAME: host1
EDUID : 45678 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbReadPage,
probe:1199
MESSAGE : ADM6006E DB2 encountered an error while reading page
"0" from table
space "492" for object "2" (located at offset "0" of
container
"/database/2/SQL00002.DAT").
This is a timing issue where a CREATE TABLE statement is issued
after
a failed LOAD without first issuing LOAD TERMINATE. The error in
db2diag.log will look different for DMS/AS tablespaces. |
