Urgent , database in "Restore Pending" state, and I dont have backup image.

[Jason]

I dont have backup image & now my db is in 'restore pending' state,
How could I restore it back to normal state. Pls help & very urgent.
Thanks

[Rhino]

What OS are you running? What version of DB2 are you running? This
information is an important factor in giving you the right answer to your
question.

Have you read the manual for your OS and version of DB2? The manuals,
particularly the Administration Guide and the Command Reference often have
the answers to questions in them. That can save time, especially on a long
weekend (it's the Labour Day long weekend in North America)when few people
are using this newsgroup.

Do you still have the data that you loaded into the table originally, either
in another database or file or in a script? If yes, you could always
recreate the database if you aren't able to restore it.

Sorry, I have a busy day planned so I don't have the time to help more than
this.

Rhino

"Jason" <choon3@hotmail.com> wrote in message
news:a2b3e221.0308300439.895ffa6@posting.google.co m...

> I dont have backup image & now my db is in 'restore pending' state,
> How could I restore it back to normal state. Pls help & very urgent.
> Thanks

[Larry]

Jason,

There are many possibilties. If you have a production system down, the quickest way to get help is to open up a
PMR with IBM support.

Larry

Jason wrote:

> Hi all DB2 expert,
> I'm using AIX 4.3 & DB2/6000 ver 5.0.0.
>
> Now I can't even connect to this db, it shown "SQL0290N Table space
> access is not allowed. SQLSTATE=55039" when I try using "connect to
> <databsename>".
> Anyway to restore this db to 'normal' state without backup image?
> I need help urgently, thanks.
>
> Jason
>
> "Rhino" <rhino1@NOSPAM.sympatico.ca> wrote in message news:<0y24b.17498$Cg2.1475925@news20.bellglobal.co m>...

> > What OS are you running? What version of DB2 are you running? This
> > information is an important factor in giving you the right answer to your
> > question.
> >
> > Have you read the manual for your OS and version of DB2? The manuals,
> > particularly the Administration Guide and the Command Reference often have
> > the answers to questions in them. That can save time, especially on a long
> > weekend (it's the Labour Day long weekend in North America)when few people
> > are using this newsgroup.
> >
> > Do you still have the data that you loaded into the table originally, either
> > in another database or file or in a script? If yes, you could always
> > recreate the database if you aren't able to restore it.
> >
> > Sorry, I have a busy day planned so I don't have the time to help more than
> > this.
> >
> > Rhino
> >
> > "Jason" <choon3@hotmail.com> wrote in message
> > news:a2b3e221.0308300439.895ffa6@posting.google.co m...

> > > I dont have backup image & now my db is in 'restore pending' state,
> > > How could I restore it back to normal state. Pls help & very urgent.
> > > Thanks

[whitepaper]

Hi,
Too bad, that was my production server....
Already open a PMR to IBM support , send all neccessary logs to them ,
but no feedback from them yet.
Plz suggest any alternative way, thanks.


Josan
Larry <lsedels@us.ibm.com> wrote in message news:3
[email]zF510A2D.B9842378@us.ibm.com[/email]...

> Jason,
>
> There are many possibilties. If you have a production system down, the

quickest way to get help is to open up a

> PMR with IBM support.
>
> Larry
>
> Jason wrote:
>

> > Hi all DB2 expert,
> > I'm using AIX 4.3 & DB2/6000 ver 5.0.0.
> >
> > Now I can't even connect to this db, it shown "SQL0290N Table space
> > access is not allowed. SQLSTATE=55039" when I try using "connect to
> > <databsename>".
> > Anyway to restore this db to 'normal' state without backup image?
> > I need help urgently, thanks.
> >
> > Jason
> >

[Larry]

How long ago did you send the logs to them? If this is your production
server, it shouldn't be very long.

Larry

whitepaper wrote:

> Hi,
> Too bad, that was my production server....
> Already open a PMR to IBM support , send all neccessary logs to them ,
> but no feedback from them yet.
> Plz suggest any alternative way, thanks.
>
> Josan
> Larry <lsedels@us.ibm.com> wrote in message news:3
> [email]zF510A2D.B9842378@us.ibm.com[/email]...

> > Jason,
> >
> > There are many possibilties. If you have a production system down, the

> quickest way to get help is to open up a

> > PMR with IBM support.
> >
> > Larry
> >
> > Jason wrote:
> >

> > > Hi all DB2 expert,
> > > I'm using AIX 4.3 & DB2/6000 ver 5.0.0.
> > >
> > > Now I can't even connect to this db, it shown "SQL0290N Table space
> > > access is not allowed. SQLSTATE=55039" when I try using "connect to
> > > <databsename>".
> > > Anyway to restore this db to 'normal' state without backup image?
> > > I need help urgently, thanks.
> > >
> > > Jason
> > >

[Matthew Emmerton]

It's worthwhile to point out that DB2 v5 has been out of service since June
30, 2001. You won't get much of a response unless you've got a paid-up
support contract.

[url]http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/newsletter.d2w/n20020101[/url]

--
Matt Emmerton


"Larry" <lsedels@us.ibm.com> wrote in message
news:3F512040.83E3B0CC@us.ibm.com...

> How long ago did you send the logs to them? If this is your production
> server, it shouldn't be very long.
>
> Larry
>
> whitepaper wrote:
>

> > Hi,
> > Too bad, that was my production server....
> > Already open a PMR to IBM support , send all neccessary logs to them

,

> > but no feedback from them yet.
> > Plz suggest any alternative way, thanks.
> >
> > Josan
> > Larry <lsedels@us.ibm.com> wrote in message news:3
> > [email]zF510A2D.B9842378@us.ibm.com[/email]...

> > > Jason,
> > >
> > > There are many possibilties. If you have a production system down, the

> > quickest way to get help is to open up a

> > > PMR with IBM support.
> > >
> > > Larry
> > >
> > > Jason wrote:
> > >
> > > > Hi all DB2 expert,
> > > > I'm using AIX 4.3 & DB2/6000 ver 5.0.0.
> > > >
> > > > Now I can't even connect to this db, it shown "SQL0290N Table

space

> > > > access is not allowed. SQLSTATE=55039" when I try using "connect to
> > > > <databsename>".
> > > > Anyway to restore this db to 'normal' state without backup image?
> > > > I need help urgently, thanks.
> > > >
> > > > Jason
> > > >

>

[Powell]

[email]choon3@hotmail.com[/email] (Jason) wrote in message news:<a2b3e221.0308300439.895ffa6@posting.google.c om>...

> I dont have backup image & now my db is in 'restore pending' state,
> How could I restore it back to normal state. Pls help & very urgent.
> Thanks

you can get out of restore pending state with:
restore db mydb abort

something went wrong with your restore cmd, check containers, paths...etc
and try again.

Powell.