Michael,
I have an example of our statement below not sure what your issue is
exactly but maybe this will help!
db2 -v restore database george user geo1 using geo2 load
/usr/lpp/fdrupstream/usudb64 open 2 sessions taken at 20060924142845 into
testdb newlogpath /db2logs/db2itst with 20 buffers buffer 3172 redirect
parallelism 4 without rolling forward without prompting
db2 set tablespace containers for 0 using "(PATH
'/db2data/db2itst/NODE0000/SQL00001/SQLT0000.0')"
db2 set tablespace containers for 1 using "(PATH
'/db2data/db2itst/NODE0000/SQL00001/SQLT0001.0')"
db2 set tablespace containers for 2 using "(PATH
'/db2data/db2itst/NODE0000/SQL00001/SQLT0002.0')"
db2 set tablespace containers for 3 using "(DEVICE '/dev/rlvnode0tmp1'
4325376, DEVICE '/dev/rlvnode0tmp2' 4325376, DEVICE '/dev/rlvnode0tmp4'
4325376, DEVICE '/dev/rlvnode0tmp5' 4325376)"
"
"
"
db2 restore db george continue
Fran Tatonetti
IT Database Group
(336)335-7511
"Michael Bell "
<db2udbdba-ezmlms
hield-x20831070.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
12/27/2006 02:29
PM Subject
Redirected restore
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
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page