Symptom
Encounter SQL0293N while performing system copy or other activity touching the Db2 tablespace containers.
The db2diag.log will contain errors such as;
- Error message: SQL0293N Error accessing a table space container. SQLSTATE=57048
- FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible" - *********************** LEVEL: Error
PID : **** TID : *************** PROC : db2sysc 0
INSTANCE: db2*** NODE : 000 DB : ***
APPHDL : 0-8 APPID: *LOCAL******************
AUTHID : DB2***
EDUID : 26 EDUNAME: db2agent (***) 0
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:810
DATA #1 : String, 115 bytes
Error checking container 0 (/db2/***/sapdata1/db2***/NODE0000/***/T0000000/C0000000.CAT) for tbsp 0. Rc = 870F0011 - SWPM
create database <SID> automatic storage yes on /db2/<SID>/sapdata1, /db2/<SID>/sapdata2, /db2/<SID>/sapdata3, using codeset UTF-8 territory en_US collate using IDENTITY_16BITpagesize 16 k dft_extent_sz 2 catalog tablespace managed by automatic storage extentsize 2 with 'SAP database <SID>'
SQL0293N Error accessing a table space container.
Read more...
Environment
- Db2 for LUW IBM
BC-OP*
Product
SAP Supply Chain Management 7.0 ; SAP enhancement package 1 for SAP NetWeaver Process Integration 7.1
Keywords
Container, SQLB_CONTAINER_NOT_ACCESSIBLE, Ownership, permission, AZURE, CREATE Database, SWPM, SAPDATA, SAPInst calls the LogInquirer because of an error in execution of step , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-OP-LNX , Linux , BC-OP-NT , Windows , BC-INS-SWPM , Installation with Software Provisioning Manager , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview