REDIRECT
Specifies a redirected restore. To complete a redirected restore, this
command should be followed by one or more SET TABLESPACE CONTAINERS
commands, and then by a RESTORE DATABASE command with the CONTINUE
option.
Note: All commands associated with a single redirected restore must be
executed from the same window or CLP session.
-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x52349842.[Email address protected]
Sent: Wednesday, December 27, 2006 3:27 PM
To: LazyDBA Discussion
Subject: RE: Redirected restore
The following statements must be processed in sequence (no other
statements can be processed before the "DB2 RESTORE DB TEST2 CONTINUE".
If any other statements are processed, the redirected restore will fail.
DB2 CONNECT TO TEST2
DB2 BACKUP DATABASE TEST2 TO D:\DB2\BACKUP\TEST2 WITH 2 BUFFERS BUFFER
1024 PARALLELISM 1 WITHOUT PROMPTING
DB2 RESTORE DATABASE TEST2 FROM D:\DB2\BACKUP\TEST2 TAKEN AT
20060820162230 INTO TEST3 REDIRECT WITHOUT ROLLING FORWARD WITHOUT
PROMPTING
DB2 SET TABLESPACE CONTAINERS FOR 0 USING (Path "D:\DB2\TEST3")
DB2 SET TABLESPACE CONTAINERS FOR 1 USING (Path "D:\DB2\TEST31")
DB2 SET TABLESPACE CONTAINERS FOR 2 USING (Path "D:\DB2\TEST32")
DB2 SET TABLESPACE CONTAINERS FOR 3 USING (File "D:\DB2\DATA8.dat" 5104)
DB2 RESTORE DB TEST2 CONTINUE
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Michael Bell
[mailto:db2udbdba-ezmlmshield-x2299475.[Email address protected]
Sent: Wednesday, December 27, 2006 3:14 PM
To: LazyDBA Discussion
Subject: RE: Redirected restore
The error is occurring before I even have a chance to set containers. I
believe it's a fixpack issue (12 -> 14).
Thank you,
Michael Bell
Professional Services
Manhattan Associates, Inc.
Phone +1 678.597.7516
Email [Email address protected]
http://www.manh.com
_____________________________________________
Manhattan Associates
Everything Outside the Box.
How can you plan and execute optimally across today's global supply
chain?
Manhattan Associates' Supply Chain Solutions. We provide everything
outside the box so you can focus on what's inside. www.manh.com
-----Original Message-----
From: Sheuehua [mailto:Sheuehua.[Email address protected]
Sent: Wednesday, December 27, 2006 3:00 PM
To: Michael Bell
Subject: Re: Redirected restore
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Michael,
You have to put containers statement like as in the
script
db2 "set tablespace containers for 0 using (path
'/db2dev/db2fs4/ts0con4', PATH '/db2dev/db2fs5/t
s0con5', PATH '/db2dev/db2fs6/ts0con6')"
Sue
"Michael Bell " [Email address protected]
Sent by: [Email address protected]
12/27/2006 02:29 PM
To
"LazyDBA Discussion" [Email address protected]
cc
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
To: "LazyDBA Discussion" [Email address protected]
cc:
From: [Email address protected]
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed. If
you have received this e-mail by mistake, or you are not the intended
recipient, any disclosure, dissemination, distribution, copying or
other use or retention of this communication or its substance is
prohibited. If you have received this communication in error, please
immediately reply to the author via e-mail that you received this
message by mistake and also permanently delete the original and all
copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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