SQL0952N 的错误是指 Processing was cancelled due to an interrupt.
刚刚在错误信息里面看到的和 rerog 相关的错误如下,基本上是 recreate, rebuild index 的信息,目前数据库能正常访问吗?
2018-01-16-02.46.16.642000+480 I71886989F947 LEVEL: Error
PID : 6944 TID : 15828 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DTWB
APPHDL : 0-24079 APPID: *LOCAL.DB2.180115180008
AUTHID : DB2ADMIN HOSTNAME: DBSERVER1
EDUID : 15828 EDUNAME: db2agent (DTWB) 0
FUNCTION: DB2 UDB, relation data serv, sqlrreorg_table, probe:850
MESSAGE : Remap rc to 1279, Reorg: Recreate index return rc = -2147155859
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -952 sqlerrml: 0
sqlerrmc:
sqlerrp : SQL10014
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2018-01-16-02.46.16.642000+480 E71887938F598 LEVEL: Warning
PID : 6944 TID : 6168 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DTWB
APPHDL : 0-23644 APPID: 192.168.1.3.49870.180115183238
AUTHID : DB2ADMIN HOSTNAME: DBSERVER1
EDUID : 6168 EDUNAME: db2agent (DTWB) 0
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:9722
MESSAGE : ADM5572I One or more indexes on table
"DB2ADMIN.MEN_REC" are marked invalid and require
rebuilding.
2018-01-16-02.46.16.658000+480 E71888538F553 LEVEL: Warning
PID : 6944 TID : 6168 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DTWB
APPHDL : 0-23644 APPID: 192.168.1.3.49870.180115183238
AUTHID : DB2ADMIN HOSTNAME: DBSERVER1
EDUID : 6168 EDUNAME: db2agent (DTWB) 0
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate, probe:1
MESSAGE : ADM5540W Rebuilding "9" indexes on table
"DB2ADMIN.MEN_REC".
2018-01-16-02.46.16.674000+480 E71889093F601 LEVEL: Warning
PID : 6944 TID : 6168 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : DTWB
APPHDL : 0-23644 APPID: 192.168.1.3.49870.180115183238
AUTHID : DB2ADMIN HOSTNAME: DBSERVER1
EDUID : 6168 EDUNAME: db2agent (DTWB) 0
FUNCTION: DB2 UDB, data management, sqldIndexCreate, probe:1
MESSAGE : ADM5541W Rebuilding index with IID "1" in object with ID "57" and
table space ID "6" on table "DB2ADMIN.MEN_REC".