I'm trying to perform a redirected restore and when I run the command:



db2 restore db trmdb taken at 20061221135744 to
/db2/db2data/db2inst1/trmdb into TRMDB redirect



I get the following error:



SQL0902C A system error (reason code = "2") occurred. Subsequent SQL

statements cannot be processed. SQLSTATE=58005



And db2diag.log has a bunch of these errors:



2006-12-27-10.57.12.587781-300 I6573520A384 LEVEL: Error

PID : 393266 TID : 1 PROC : db2bm.577742.0
0

INSTANCE: db2inst1 NODE : 000

FUNCTION: DB2 UDB, buffer pool services, sqlbRestorePoolDef, probe:40

RETCODE : ZRC=0x87020002=-2029912062=SQLB_BPSE "Debug logic error
detected"

DIA8501C A buffer pool logic error has occurred.



Although I'm not sure these are related.



I also see these errors, although I don't know why since redirect is
specified:



2006-12-27-14.28.42.334074-300 I22369506A362 LEVEL: Error

PID : 807126 TID : 1 PROC : db2bm.1331520.0
0

INSTANCE: db2inst1 NODE : 000

FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:815

MESSAGE : Error checking container 0 (/u53ptrm1/trmdb/tmp1/TEMPSPACE1)
for tbsp

1. Rc = 870F0011



2006-12-27-14.28.42.334530-300 I22369869A357 LEVEL: Error

PID : 807126 TID : 1 PROC : db2bm.1331520.0
0

INSTANCE: db2inst1 NODE : 000

FUNCTION: DB2 UDB, buffer pool services, sqlbSMSDoContainerOp, probe:815

RETCODE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE

"Container not accessible"



The source is DB2 8.1 FP12 and the destination is DB2 8.1 FP14, both
servers are on AIX 5.3. Any ideas?



Thank you,

Michael Bell




DB2 & UDB email list listserv db2-l LazyDBA home page