DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can 
be used as a workaround

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 v9.7 fixpak 2

The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can 
 
be used as a workaround

Vorgänger  : APAR is sysrouted TO one or more of the following: IC65977 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

02.02.2010
13.05.2010
13.05.2010

9.7.