By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,559 Members | 1,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,559 IT Pros & Developers. It's quick & easy.

Redirected restore

P: n/a
Is it possible to find out what the tablespace definitions are of
database you are about to build using a redirected restore?

What I am wanting to do is build a script that can take only a backup
file of a database and do a redirected restore into another database.
This means I may not know or have access to the database where the
backup originated at. It seems like once you start the redirected
restore there is no way to do a list tablespaces.

Has anybody dealt with this issue?

thanks

Jack
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Look at the following and specially at: -t where you get the details
from the backup image.
HTH, Pierre.
F:\SQLLIB\BIN>db2ckbkp -h

db2ckbkp: Checks a single image, or the multiple parts of an image;
The use of one or more options will display information
and results to the user.

- The default only verifies if the image is good.
-a - Display <a>ll of the information we can.
-c - Display the results from the page <c>hecking.
-d - Display information on <d>MS tablespace data.
-h - Display the media <h>eader information.
-e - <e>xtract pages from image to a file.
-H - ONLY display the media <h>eader information.
-l - Display the LFH (Log File Header) and MFH (Mirror LFH) data.
-t - Display <t>ablespace details for those in the image.
-T - ONLY display <t>ablespace details for those in the image.
-o - Display detailed information from the <o>bjects.
-n - <n>o prompt for tape mount. Assume 1 tape per device.
-p - Display the number of <p>ages of each object type.

Usage: db2ckbkp [ [-H] | [-T] |
[-h] [-o] [-l] [-d] [-c] [-a] [-n] [-t] [-p] [-e]
[-cl <decompressionLib>] [-co <decompressionOpts>] ]
<image1> [<image2> ...]

Here's a sample of what I get from:
F:\CF45\Backup\MUSICDB.0\INST1\NODE0000\CATN0000\2 0041009>db2ckbkp -t
204117.001

HTH, Pierre.
Container CB
Type: 0
TotalPages: 0
UsablePages: 0
# of OS rsvd bytes: 0
Page 0 offset: 0
Tag offset: 0
Extent offset: 0
Name: d:\sms\sms04

Jack wrote:
Is it possible to find out what the tablespace definitions are of
database you are about to build using a redirected restore?

What I am wanting to do is build a script that can take only a backup
file of a database and do a redirected restore into another database.
This means I may not know or have access to the database where the
backup originated at. It seems like once you start the redirected
restore there is no way to do a list tablespaces.

Has anybody dealt with this issue?

thanks

Jack


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.