Symptom
After database switch over from DC to DR, some table space cannot be accessed on DR side.
This will cause the shortdump as below:
Category Installation Errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
SQL error "-1477" when accessing table "abc".
Error Text of the Database: "SQL1477N For table "SAPABC.ABC" an object "123"
in table space "1" cannot be accessed. SQLSTATE=55019"
and ADM5570W can be found in the db2diag.log:
2022-08-07-02.47.15.846645+330 E256611538A794 LEVEL: Warning
PID : 1234567 TID : 123 PROC : db2sysc 0
INSTANCE: db2abc NODE : 000 DB : ABC
APPHDL : 0-123 APPID: 12.12.123.123.12345.123456789012
AUTHID : SAPABC HOSTNAME: ABC
EDUID : 123 EDUNAME: db2agent (ABC) 0
FUNCTION: DB2 UDB, data management, sqldSetupSQLCA, probe:3
MESSAGE : ADM5570W Access was attempted on an unavailable object with id "123"
in tablespace "1" for table "SAPABC.ABC". If the object is a table
it will have to be dropped. If the object is a partition it will
have to be detached. If the object is a non-partitioned index the
index will have to be dropped.
Read more...
Environment
SAP on IBM Db2 for Linux, UNIX, and Windows
Keywords
HADR, SQL1477N, ADM5570W, DB6CONV, nonrecoverable, Access was attempted on an unavailable object, cannot be accessed , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.