472,796 Members | 2,336 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Redirected restore, when only Instance is created & cataloged

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 database for this
application, but I have desired DB2 backup (by db2 backup db command).

Can I do redirected restore (SET TABLESPACE CONTAINERS ....) only
when instance is created & cataloged , I am under the impression that
redirected restore is smart enough to create required database?

If it can not create desired database, what is minimum (apart from
correct level of DB2 software) I should do, before I start redirected
restore.

I would sincerely appreciate your advice / suggestion.

Thanks,
VKG
Nov 12 '05 #1
3 3412
Hi Vikrant,
Your question is somewhat unclear.
but i think u have problem with existing database
If you can not catalog it properly on client, you can check if communication
between client and server is OK
see if required parameters have valid values.

restore redirect will definitely recreate database if that is something you
want to do
check the syntax of restore redirect in manuals

regards,
jagdip singh

"Vikrant" <ic*********@rediffmail.com> wrote in message
news:d2*************************@posting.google.co m...
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 database for this
application, but I have desired DB2 backup (by db2 backup db command).

Can I do redirected restore (SET TABLESPACE CONTAINERS ....) only
when instance is created & cataloged , I am under the impression that
redirected restore is smart enough to create required database?

If it can not create desired database, what is minimum (apart from
correct level of DB2 software) I should do, before I start redirected
restore.

I would sincerely appreciate your advice / suggestion.

Thanks,
VKG

Nov 12 '05 #2
"Jagdip Singh" <jx*****@cs.rit.edu> wrote in message news:<40********@buckaroo.cs.rit.edu>...
Hi Vikrant,
Your question is somewhat unclear.
but i think u have problem with existing database
If you can not catalog it properly on client, you can check if communication
between client and server is OK
see if required parameters have valid values.

restore redirect will definitely recreate database if that is something you
want to do
check the syntax of restore redirect in manuals

regards,
jagdip singh

"Vikrant" <ic*********@rediffmail.com> wrote in message
news:d2*************************@posting.google.co m...
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 database for this
application, but I have desired DB2 backup (by db2 backup db command).

Can I do redirected restore (SET TABLESPACE CONTAINERS ....) only
when instance is created & cataloged , I am under the impression that
redirected restore is smart enough to create required database?

If it can not create desired database, what is minimum (apart from
correct level of DB2 software) I should do, before I start redirected
restore.

I would sincerely appreciate your advice / suggestion.

Thanks,
VKG

Hi Jagdip,

Thanks for your response. ya, I do have problem on existing database
(its local on pSeries AIX 5.2 32 bit) [Problem is I application
install had not generated proper DDL to create required database), I
can catalog it. I can also do 'db2 list database directory'.

Enjoy,
VKG
Nov 12 '05 #3

"Vikrant" <ic*********@rediffmail.com> wrote in message
news:d2*************************@posting.google.co m...
"Jagdip Singh" <jx*****@cs.rit.edu> wrote in message

news:<40********@buckaroo.cs.rit.edu>...
Hi Vikrant,
Your question is somewhat unclear.
but i think u have problem with existing database
If you can not catalog it properly on client, you can check if communication between client and server is OK
see if required parameters have valid values.

restore redirect will definitely recreate database if that is something you want to do
check the syntax of restore redirect in manuals

regards,
jagdip singh

"Vikrant" <ic*********@rediffmail.com> wrote in message
news:d2*************************@posting.google.co m...
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 database for this
application, but I have desired DB2 backup (by db2 backup db command).

Can I do redirected restore (SET TABLESPACE CONTAINERS ....) only
when instance is created & cataloged , I am under the impression that
redirected restore is smart enough to create required database?

If it can not create desired database, what is minimum (apart from
correct level of DB2 software) I should do, before I start redirected
restore.

I would sincerely appreciate your advice / suggestion.

Thanks,
VKG

Hi Jagdip,

Thanks for your response. ya, I do have problem on existing database
(its local on pSeries AIX 5.2 32 bit) [Problem is I application
install had not generated proper DDL to create required database), I
can catalog it. I can also do 'db2 list database directory'.

Enjoy,
VKG


The only difference between a regular restore and a redirected restore is
that with a redirected restore, the tablespace definitions can be different.
(This is the purpose of the SET TABLESPACE CONTAINERS argument -- it maps
the current tablespaces to the ones listed in the backup image.)

If you still have access to the original database, you should use the
'db2look' program. This program will output all the required DDL to create
the database, tablespaces, bufferpools, tables, indexes, and so on.
(Everything except the data itself.)

db2look -d <database name> -a -e -l -m -f -o <output file>

If you don't have access to the original database, you're probably out of
luck.

--
Matt Emmerton
DB2 OLTP Performance
IBM Toronto Lab
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Philip Nelson | last post by:
Ran into a problem doing a redirected restore of a database with SQL stored procedures. On our production server database DPXXX001 has a number of SQL stored procedures defined. After...
0
by: db2inst2 | last post by:
Hi all, I did a redirected restore into a new DB in the same instance, I get the following error message in db2diag.log right after doing that. The new DB that i restored to is working fine. ...
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...
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"....
3
by: cerbdog | last post by:
Hello, all. Was hoping someone might be able to help us out with an issue: We're trying to perform a restore from a backup of one AIX 5.1 server, we'll call it "AIX", to another AIX 5.1 server;...
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...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth

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.