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) |