|
Problem IC65977
|
Status: Closed |
REORGCHK COMMAND HANGS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - 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 |
| Local Fix: |
The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can
be used as a workaround |
| available fix packs: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 v9.5 fixpak 6 |
| Workaround |
The stored procedure REORGCHK_TB_STATS and REORGCHK_IX_STATS can
be used as a workaround |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC66444
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2010
13.05.2010
13.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.
|
| Problem solved according to the fixlist(s) of the following version(s) |
