473,231 Members | 1,672 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Redirected restore

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
1 2747
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Vikrant | last post by:
Friends, Due an application (old) install program problem, Under AIX I could only create DB2 instance, I could also catalog it. Its complex application and I am not expert in creating full...
1
by: Vikrant | last post by:
Hi Kelly This is from old response by you. What is 'callerac' parameter in REDIRECTED restore, how can I provide 'callerac' value ? Thanks, VKG =====
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following SQL2059W A device full warning was...
7
by: CCC via DBMonster.com | last post by:
We use redirected restore to refresh test from prod on different AIX 5.2 servers. The databases have the same number, size and names of cooked containers. The only difference is the fully qualified...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
1
by: Kent.Brooke | last post by:
When a backup is taken from server a and then redirected restore is done on server b, the tables and data is fine however db2advis says "explain & advise tables not created for user x properly"....
4
by: Laurence | last post by:
Hi there, Command Reference book stated for db2relocatedb command: Copy the files/devices belonging to the databases being copied onto the system where the new instance resides. The path names...
0
by: Lew | last post by:
Hi, I have a database that I am restoring to another database in the same instance using a redirected restore. It seems to work fine but what is troubling to me is in the diag log i see that it...
1
by: okonita | last post by:
Hi all, This is a very urgent issue for my team. We are trying a Redirected restore the most current online DB2 UDBv8.2 backup copy from prod disk to disk on another/test instance. Our...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.