Support for Informix

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IT33687	Status: Closed
ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE
product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
A restore that redirects DMS table spaces to use automatic storage can cause a subsequent rollforward to fail with SQL1042C if the rollforward replays an ALTER TABLESPACE operation involving a raw device container. The ALTER TABLESPACE being replayed must be for one of the table spaces redirected to use automatic storage. Â An example of such an ALTER TABLESPACE is ?alter tablespace begin new stripe set ( device '' 1000 )? Â This will produce entires in the db2diag.log file similar to the following: Â 2020-07-22-09.19.50.406541-240 I365142E602 Â Â Â Â Â LEVEL: Error PID Â Â : 10359 Â Â Â Â Â Â Â Â TID : 139668939073280 PROC : db2sysc INSTANCE: XXXXXXXX Â Â Â Â Â Â NODE : 000 Â Â Â Â Â Â DB Â : XXXXXX APPHDL Â : 0-63 Â Â Â Â Â Â Â Â APPID: XXXXXXXX AUTHID Â : XXXXXXXX Â Â Â Â Â Â HOSTNAME: XXXXXXXX EDUID Â : 213 Â Â Â Â Â Â Â Â Â EDUNAME: db2redom (XXXXXX) FUNCTION: DB2 UDB, buffer pool services, sqlbAlterPool, probe:65 MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED Â Â Â Â Â "A tablespace clause was not allowed in the command or statement." Â 2020-07-22-09.19.50.406710-240 I365745E596 Â Â Â Â Â LEVEL: Error PID Â Â : 10359 Â Â Â Â Â Â Â Â TID : 139668939073280 PROC : db2sysc INSTANCE: XXXXXXXX Â Â Â Â Â Â NODE : 000 Â Â Â Â Â Â DB Â : XXXXXX APPHDL Â : 0-63 Â Â Â Â Â Â Â Â APPID: XXXXXXXX AUTHID Â : XXXXXXXX Â Â Â Â Â Â HOSTNAME: XXXXXXXX EDUID Â : 213 Â Â Â Â Â Â Â Â Â EDUNAME: db2redom (XXXXXX) FUNCTION: DB2 UDB, buffer pool services, sqlbRedo, probe:0 MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED Â Â Â Â Â "A tablespace clause was not allowed in the command or statement." Â 2020-07-22-09.19.50.406784-240 I366342E713 Â Â Â Â Â LEVEL: Severe PID Â Â : 10359 Â Â Â Â Â Â Â Â TID : 139668939073280 PROC : db2sysc INSTANCE: XXXXXXXX Â Â Â Â Â Â NODE : 000 Â Â Â Â Â Â DB Â : XXXXXX APPHDL Â : 0-63 Â Â Â Â Â Â Â Â APPID: XXXXXXXX AUTHID Â : XXXXXXXX Â Â Â Â Â Â HOSTNAME: XXXXXXXX EDUID Â : 213 Â Â Â Â Â Â Â Â Â EDUNAME: db2redom (XXXXXX) FUNCTION: DB2 UDB, data management, sqldmrdo, probe:1388 MESSAGE : ZRC=0x800201A3=-2147352157=SQLB_AS_CLAUSE_NOT_ALLOWED Â Â Â Â Â "A tablespace clause was not allowed in the command or statement." DATA #1 : String, 25 bytes Error during REDO of LSN: DATA #2 : SQLP_LSN8, PD_TYPE_SQLP_LSN8, 8 bytes 0000000000039C6D
Problem Summary:
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1.4.6 or higher * ****************************************************************
Local Fix:
Take a backup after alter table space operations involving raw devices have completed, then do a redirected restore and rollforward using that backup image.
Solution

Workaround
See local Fix
BUG-Tracking
forerunner : IT33680 follow-up :
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	24.07.2020 31.03.2021 31.03.2021
Problem solved at the following versions (IBM BugInfos)

Problem solved according to the fixlist(s) of the following version(s)