REORG TABLE may fail in DPF environment after an
alter table drop column statement has been issued.
The reported error is SQL2216 with a reason code of -301 or
-420..
example:
SQL2216N SQL error "-301" occurred while reorganizing a
database table or its
indexes.
The db2diag.log msg may report as follows..
2012-11-06-19.51.32.409907-300 I2707103A598 LEVEL:
Severe
PID : 28020 TID : 1324 PROC :
db2sysc 763
INSTANCE: regress2 NODE : 763 DB :
SCHEMADB
APPHDL : 19-1449 APPID: *N19.regress2.121107005008
AUTHID : REGRESS2 HOSTNAME: reghpiac7k06
EDUID : 1324 EDUNAME: db2agntp (SCHEMADB) 763
FUNCTION: DB2 UDB, data management, sqldMapAlteredZval,
probe:1828
RETCODE : ZRC=0x80160016=-2146041834=SQLRXICT3 "incompatible
types"
DIA8022C Incompatible data type "" used with an
EXECUTE or OPEN.
2012-11-06-19.51.32.472267-300 I2707702A624 LEVEL:
Warning
PID : 28020 TID : 1324 PROC :
db2sysc 763
INSTANCE: regress2 NODE : 763 DB :
SCHEMADB
APPHDL : 19-1449 APPID: *N19.regress2.121107005008
AUTHID : REGRESS2 HOSTNAME: reghpiac7k06
EDUID : 1324 EDUNAME: db2agntp (SCHEMADB) 763
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging function), probe:30
MESSAGE : Reorg table failed.
DATA #1 : String, 84 bytes
Table(2:4)=UNLIMALTPERUOW01.TAB1, Flags=x0111000000004091,
IID=0, Temp=0, LongTemp=0
2012-11-06-19.51.32.472789-300 I2708327A601 LEVEL:
Warning
PID : 28020 TID : 1324 PROC :
db2sysc 763
INSTANCE: regress2 NODE : 763 DB :
SCHEMADB
APPHDL : 19-1449 APPID: *N19.regress2.121107005008
AUTHID : REGRESS2 HOSTNAME: reghpiac7k06
EDUID : 1324 EDUNAME: db2agntp (SCHEMADB) 763
FUNCTION: DB2 UDB, data management, sqldTableReorgObject,
probe:4296
RETCODE : ZRC=0x80160016=-2146041834=SQLRXICT3 "incompatible
types"
DIA8022C Incompatible data type "" used with an
EXECUTE or OPEN.
2012-11-06-19.51.32.473229-300 I2708929A583 LEVEL: Error
PID : 28020 TID : 1324 PROC :
db2sysc 763
INSTANCE: regress2 NODE : 763 DB :
SCHEMADB
APPHDL : 19-1449 APPID: *N19.regress2.121107005008
AUTHID : REGRESS2 HOSTNAME: reghpiac7k06
EDUID : 1324 EDUNAME: db2agntp (SCHEMADB) 763
FUNCTION: DB2 UDB, relation data serv, sqlrreorg_table,
probe:550
MESSAGE : Reorg: DMS return rc =
DATA #1 : Hexdump, 4 bytes
0x87FFFFFFE6BFD5F8 : 8016 0016
.... |
