Reorgchk command could be hung on the v9.7 if the following
message in the db2diag.log file.
2010-01-11-17.38.46.301944-300 I31947A1039 LEVEL: Severe
PID : 729298 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2gcd.100111223631
EDUID : 1
FUNCTION: DB2 UDB, command line process,
clp_reorgchk_get_tpagesize,
probe:2963
DATA #1 : String, 34 bytes
Unexpected result getting pagesize
DATA #2 : String, 468 bytes
WITH JTAB(JSCHEMA,JNAME) AS (VALUES(TABLE_SCHEMA(CAST(? AS
varchar(128))
,
CAST(? AS v
rchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT
YSIBM.SYSTABLESPACES.PAGESIZE, SYSIBM.SYSTABLESPACES.EXTENTSIZE,
SYSIBM.SYSTABLESPACE
.DATATYPE FROM SYSIBM.SYSTABLESPACES, SYSIBM.SYSTABLES, JTAB
WHERE
(SYSIBM.SYSTABLES.
REATOR = JTAB.JSCHEMA) AND (SYSIBM.SYSTABLES.NAME = JTAB.JNAME)
AND
(SYSIBM.SYSTABLES
TID = SYSIBM.SYSTABLESPACES.TBSPACEID)
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : String, 4 bytes
TAB1
DATA #6 : String, 8 bytes
db2admin
DATA #7 : unsigned integer, 4 bytes
100 |
Reorgchk command could be hung on the v9.7 if the following
message in the db2diag.log file.
2010-01-11-17.38.46.301944-300 I31947A1039 LEVEL: Severe
PID : 729298 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2gcd.100111223631
EDUID : 1
FUNCTION: DB2 UDB, command line process,
clp_reorgchk_get_tpagesize,
probe:2963
DATA #1 : String, 34 bytes
Unexpected result getting pagesize
DATA #2 : String, 468 bytes
WITH JTAB(JSCHEMA,JNAME) AS (VALUES(TABLE_SCHEMA(CAST(? AS
varchar(128))
,
CAST(? AS v
rchar(128))), TABLE_NAME (CAST(? AS varchar(128)), CAST(? AS
varchar(128))))) SELECT
YSIBM.SYSTABLESPACES.PAGESIZE, SYSIBM.SYSTABLESPACES.EXTENTSIZE,
SYSIBM.SYSTABLESPACE
.DATATYPE FROM SYSIBM.SYSTABLESPACES, SYSIBM.SYSTABLES, JTAB
WHERE
(SYSIBM.SYSTABLES.
REATOR = JTAB.JSCHEMA) AND (SYSIBM.SYSTABLES.NAME = JTAB.JNAME)
AND
(SYSIBM.SYSTABLES
TID = SYSIBM.SYSTABLESPACES.TBSPACEID)
DATA #3 : unsigned integer, 4 bytes
0
DATA #4 : unsigned integer, 4 bytes
1
DATA #5 : String, 4 bytes
TAB1
DATA #6 : String, 8 bytes
db2admin
DATA #7 : unsigned integer, 4 bytes
100 |
