Schema transport will fail if BLOCKNONLOGGED YES was set on the
source database. The following error will be to the user:
$ db2 restore db sample continue
SQL0443N Routine "*RATE_DDL" (specific name "") has returned an
error
SQLSTATE with diagnostic text "SQL2005 Reason code or token: lob
options
prohibited with ". SQLSTATE=3855
The db2diag will show:
2013-08-22-12.22.24.188352-240 I437372E466 LEVEL: Info
PID : 24861 TID : 46916901529920PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SYSTG000
APPHDL : 0-174 APPID:
*LOCAL.db2inst1.130822162128
AUTHID : db2inst1
EDUID : 1380 EDUNAME: db2agent (SYSTG000)
FUNCTION: DB2 UDB, database application extension for utili,
transport, probe:7753
MESSAGE : Transport:End Extract DDL phase
2013-08-22-12.22.24.189858-240 I437839E585 LEVEL: Error
PID : 24861 TID : 46916901529920PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SYSTG000
APPHDL : 0-174 APPID:
*LOCAL.db2inst1.130822162128
AUTHID : db2inst1
EDUID : 1380 EDUNAME: db2agent (SYSTG000)
FUNCTION: DB2 UDB, database utilities,
sqludExtractAndSaveDDLForTransport, probe:2753
MESSAGE : SQL10007N Message "2146303891" could not be
retrieved. Reason code:
"4".
DATA #1 : String, 43 bytes
Transport: Error calling TRANSPORT(EXTRACT)
2013-08-22-12.22.24.190183-240 E438425E908 LEVEL: Severe
PID : 7670 TID : 46912579536736PROC : db2bp
INSTANCE: db2inst1 NODE : 000 DB :
SYSTG000
APPID : *LOCAL.db2inst1.130822162128
FUNCTION: DB2 UDB, database utilities,
sqludTransportExtractDDLStagingDB, probe:1397
MESSAGE : ZRC=0xFFFFFE45=-443
DATA #1 : String, 44 bytes
Error during transport DDL extraction phase.
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -443 sqlerrml: 70
sqlerrmc: *RATE_DDL SQL2005 Reason code or token: lob options
prohibited with
sqlerrp : SQL09078
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 3855 |
