Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC66444 Status: Closed

REORGCHK COMMAND HANGS

product:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problem description:
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
Problem Summary:
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
Local Fix:
The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can 
be used as a workaround
available fix packs:
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
Solution
The APAR is fixed on the DB2 v9.8fixpak 3
Workaround
The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can 
be used as a workaround
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.02.2010
10.01.2011
10.01.2011
Problem solved at the following versions (IBM BugInfos)
9.8.FIXPAK
Problem solved according to the fixlist(s) of the following version(s)
9.8.0.3 FixList