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.
