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