home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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