Creating a database from a file image backup on OS/2 DB2 ver 5.2 
Author Message
 Creating a database from a file image backup on OS/2 DB2 ver 5.2

Story of woe & sadness.
I've been given the task of sorting out a messed up DB2 database (not mine &
I'm not expert)
Well something went wrong, we started getting SQL 58004 messages and our
trusty database no longer wanted to play anymore. Fortunately we had created
backups on a weekly basis so the malfunctional database was dropped so a
backup copy could be restored.
The problem I'm facing right now is that restoring from this image file is
not as straightforward as I thought it would be.

The backup image is stored in the following directory
d:\db2back\SGPDBREL.0\DB2\NODE0000\CATN0000\19991214
The filename is 085303.001 & is about 250Megs.
If I use the smartguide the Journal always reports my restore effort has
failed. Why? What am I doing wrong here?

Any input here would be graciously accepted.

Robert Thomas.



Mon, 12 Aug 2002 03:00:00 GMT
 Creating a database from a file image backup on OS/2 DB2 ver 5.2

Use the Restore Smart Guide (from the DB2 control center, click on the database
folder, right mouse, choose create database based on backup)

Enter your database name, when you are asked for location of the backup enter
d:\db2back, you will need to provide the database name, and finally
you will need to specify the date (19991214) and time 085303.

Good luck

Quote:

> Story of woe & sadness.
> I've been given the task of sorting out a messed up DB2 database (not mine &
> I'm not expert)
> Well something went wrong, we started getting SQL 58004 messages and our
> trusty database no longer wanted to play anymore. Fortunately we had created
> backups on a weekly basis so the malfunctional database was dropped so a
> backup copy could be restored.
> The problem I'm facing right now is that restoring from this image file is
> not as straightforward as I thought it would be.

> The backup image is stored in the following directory
> d:\db2back\SGPDBREL.0\DB2\NODE0000\CATN0000\19991214
> The filename is 085303.001 & is about 250Megs.
> If I use the smartguide the Journal always reports my restore effort has
> failed. Why? What am I doing wrong here?

> Any input here would be graciously accepted.

> Robert Thomas.



Tue, 13 Aug 2002 03:00:00 GMT
 Creating a database from a file image backup on OS/2 DB2 ver 5.2

Thanks a million Ray, it's back up  & running.
I think where I went wrong was that at the selection of the image I
a) went too far down the directory structure
b) didn't bother with the time & to a lesser extent the date because of a)
c) hadn't given it the new database a proper name, I kind of assumed it
would use the name from the backup image.

You are a star.

Rob


Quote:
> Use the Restore Smart Guide (from the DB2 control center, click on the
database
> folder, right mouse, choose create database based on backup)

> Enter your database name, when you are asked for location of the backup
enter
> d:\db2back, you will need to provide the database name, and finally
> you will need to specify the date (19991214) and time 085303.

> Good luck


> > Story of woe & sadness.
> > I've been given the task of sorting out a messed up DB2 database (not
mine &
> > I'm not expert)
> > Well something went wrong, we started getting SQL 58004 messages and our
> > trusty database no longer wanted to play anymore. Fortunately we had
created
> > backups on a weekly basis so the malfunctional database was dropped so a
> > backup copy could be restored.
> > The problem I'm facing right now is that restoring from this image file
is
> > not as straightforward as I thought it would be.

> > The backup image is stored in the following directory
> > d:\db2back\SGPDBREL.0\DB2\NODE0000\CATN0000\19991214
> > The filename is 085303.001 & is about 250Megs.
> > If I use the smartguide the Journal always reports my restore effort has
> > failed. Why? What am I doing wrong here?

> > Any input here would be graciously accepted.

> > Robert Thomas.



Fri, 16 Aug 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. DB2 5.2 backup terminating

2. DB2 5.2 backup problems

3. Permisions error creating DSN to DB2 5.2

4. DB2 Newbie needs help with DB2 5.2 ODBC: can browse schema, but get no data

5. Error in Java Program, when it accesses DB2 UDB 7.2 from DB2 UDB 5.2 Client

6. Connecting to db2 v7.1(linux) from db2 5.2 cc(nt)

7. Connect to db2 5.2 Server from db2 7.1

8. Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect

9. Migrating DB2/2 1.0 database to >= 5.2

10. backup db2/nt via OS file copy

11. Help Command Center ver 5.2

12. Creating DB2 SQL Procedures in DB2 version 6 on OS/390 (June 2000 PUT)


 
Powered by phpBB® Forum Software