Fixes are available
APAR status
Closed as program error.
Error description
The problem can be reproduced with these steps: 1) A non-automatic storage table space TS1 has a container named /home/db2inst1/db2inst1/NODE0000/SAMPLE/T0000004/C0000000.LRG, which is the same name/path as if it were created as an automatic storage table space. 2) ALTER TABLESPACE TS1 MANAGED BY AUTOMATIC STORAGE -> It fails with SQL0299N 3) ALTER TABLESPACE TS1 MANAGED BY AUTOMATIC STORAGE -> It succeeds 4) Check db2diag.log. The table space is offline due to the following message: 2018-09-08-13.17.33.889445-300 I415126465A684 LEVEL: Error PID : 20316290 TID : 21576 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 0-353 APPID: *LOCAL.db2inst1.180908171848 AUTHID : DB2INST1 HOSTNAME: db2host1 EDUID : 21576 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:867 MESSAGE : ZRC=0x8002003D=-2147352515=SQLB_CONTAINER_ALREADY_ADDED "Duplicate container" DATA #1 : <preformatted>
Local fix
Before altering the table space to automatic storage make sure the container name is different than if it was an automatic storage table space container.
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher * ****************************************************************
Problem conclusion
First fixed in Db2 11.1 Mod 4 Fixpack 5
Temporary fix
Comments
APAR Information
APAR number
IT26871
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-11-07
Closed date
2020-01-16
Last modified date
2020-01-16
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022