DB2 - Problembeschreibung
Problem IT05722 | Status: Geschlossen |
DATABASE SCHEMA TRANSPORT FAILS ON LINUX390 WITH SQL0293N ERROR ACCESSING A TABLE SPACE CONTAINER. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
Transport expects the block size for a DMS tablespace to be 512 but this generally mismatches the block size on disk. In this case db2 will not allow users to create a tablespace that does not use file system cashing. Transport ignores this and when it tries to perform an unaligned read it fails and does not update the tablespace container flags. This leads to BPS reporting that the container does not belong to the current database and sets the tablespace as inaccessible. Here is how to reproduce on Linux390: db2 create db IBMblue db2 create db IBMred db2 update db cfg for IBMblue using logarchmeth1 disk:/home/dbguest9/IBM_blue_logarch db2 update db cfg for IBMred using logarchmeth1 disk:/home/dbguest9/IBM_red_logarch db2 backup db IBMblue to /home/dbguest9 db2 backup db IBMred to /home/dbguest9 db2 connect to IBMblue db2 create tablespace ts1 db2 create schema schema1 db2 "create table schema1.table1(c1 int, c2 varchar(256)) in ts1" db2 "insert into schema1.table1(c1,c2) values(1,'blue'),(2,'green'),(3,'red'),(4,'yellow')" db2 terminate db2 backup db IBMblue online include logs db2 "restore db IBMblue tablespace (ts1) schema(schema1) transport into IBMred LOGTARGET /home/dbguest9/IBM_red_logarch" SQL0293N Error accessing a table space container. SQLSTATE=57048 Messages you will see in the db2diag.log: 2014-04-08-14.31.23.870565-240 I1144973A929 LEVEL: Error PID : 2091 TID : 2199074781936 PROC : db2bp INSTANCE: dbguest9 NODE : 000 DB : RED APPID : *LOCAL.dbguest9.140408183103 HOSTNAME: fragola FUNCTION: DB2 UDB, database utilities, sqludTransportSetupTargetDB, probe:1381 MESSAGE : ZRC=0x80B00475=-2135948171=SQLUD_TRANSPORT_TARGETDB_ERROR "An error occurred on target database while transporting table spaces. Schema transport stopped." DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -293 sqlerrml: 0 sqlerrmc: sqlerrp : SQL10012 sqlerrd : (1) 0x8402001E (2) 0x0000001E (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 57048 2014-04-08-14.31.23.870719-240 E1145903A918 LEVEL: Severe PID : 2091 TID : 2199074781936 PROC : db2bp INSTANCE: dbguest9 NODE : 000 DB : RED APPID : *LOCAL.dbguest9.140408183103 HOSTNAME: fragola FUNCTION: DB2 UDB, database utilities, sqludTransportSetupTargetDB, probe:1395 MESSAGE : ZRC=0xFFFFFEDB=-293 SQL0293N Error accessing a table space container. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 fix pack 7. * **************************************************************** | |
Local-Fix: | |
N/A | |
Lösung | |
First fixed in DB2 10.5 fix pack 7. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.11.2014 20.01.2016 20.01.2016 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |