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

re: Redirected restore, when only Instance is created & cataloged

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" <icanhearyou@rediffmail.com> wrote in message
news:d236b1b8.0401232101.4e63836@posting.google.co m...[color=blue]
> 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[/color]

re: Redirected restore, when only Instance is created & cataloged

"Jagdip Singh" <jxs1878@cs.rit.edu> wrote in message news:<40129fe1$1@buckaroo.cs.rit.edu>...[color=blue]
> 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" <icanhearyou@rediffmail.com> wrote in message
> news:d236b1b8.0401232101.4e63836@posting.google.co m...[color=green]
> > 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[/color][/color]
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

re: Redirected restore, when only Instance is created & cataloged

"Vikrant" <icanhearyou@rediffmail.com> wrote in message
news:d236b1b8.0401242055.7fd83c9@posting.google.co m...[color=blue]
> "Jagdip Singh" <jxs1878@cs.rit.edu> wrote in message[/color]
news:<40129fe1$1@buckaroo.cs.rit.edu>...[color=blue][color=green]
> > 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[/color][/color]
communication[color=blue][color=green]
> > between client and server is OK
> > see if required parameters have valid values.
> >
> > restore redirect will definitely recreate database if that is something[/color][/color]
you[color=blue][color=green]
> > want to do
> > check the syntax of restore redirect in manuals
> >
> > regards,
> > jagdip singh
> >
> > "Vikrant" <icanhearyou@rediffmail.com> wrote in message
> > news:d236b1b8.0401232101.4e63836@posting.google.co m...[color=darkred]
> > > 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[/color][/color]
> 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[/color]

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