DB2 Restore V8.2 Express

DATABASE

    Sponsored Links

    Next

  • 1. How to check data integrity of a DB2 instance?
    Hello, Sorry if this is a basic question but I can't seem to find the answer in the DB2 tutorial series or my DB2 manuals. How does one check the data integrity and referential integrity of an instance before running a backup? I see how one can run "db2ckbkp" after the backup has run, and I've seen some discussion of checksums in past postings, but what I'm looking for is more of: #!/bin/sh <command to check the data integrity of DB2 instance> <command to check the referential integrity of a DB2 instance, if not handled by the previous command> DB2 BACKUP DATABASE . . . If anyone is familiar with Informix, something like the "oncheck" or "onutil check" commands. Thanks to all and any responses, including flames. Brice Avila
  • 2. DB2 under win xp
    We have user with normal user access in our setup. We need to be cataloged their database and the batch file is on a share on the network. The drive is mapped but we can not switch to that drive ie "P:". Even when I do a runas the db2cmd.exe environment does not change. If we were to give the user admin rights thet db2cmd.exe environment is loaded correct. How would we go about solving this issue. Please send responses to XXXX@XXXXX.COM , Thank You!
  • 3. what is true image?
    Step 1: Write suspend for database. Connect to database. Issue the following command: db2 set write suspend for database Step 2: Create True Image Create a True Image of the required NAS Volumes. Step 3: Write resume for database. Issue the following command: db2 set write resume for database Can someone elaborate how to take a true image...is it the normal backup referred as true image? Thanks for your time.
  • 4. about auto-commit
    HI, I had a question on auto-commit in DB2 EEE V8 on AIX V5. Here is my example.. there are two script A.sh , B.SQL A.sh is following: db2 +c -tvf B.SQL B.SQL is following: create index test_ind on test (a asc); commit; drop index test_ind; I run the A.sh in following way in DB2 EEE V7 and V8 ./A.sh I got different result for V7 and V8 V7: the index test_ind was dropped after run the scripts. V8: the index is still there after run the scripts.. Any idea about it?
  • 5. REBIND fails with SQL0029N
    Platform : Solaris UDB : version 7.2 FP9 DB2RBIND PACKAGE SCHEMA.PACKAGE fails with SQL0029N error. When I issue, "db2rbind DBNAME all", it is successfull. Can anyone help me understand this please ?

DB2 Restore V8.2 Express

Postby Ian Mackenzie » Tue, 03 Oct 2006 17:26:08 GMT

Hey.

I am trying to import the following file:

C:\SMARTMUN.0.DB2.NODE0000.CATN0000.20060926082904.001

with the following command:

RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING;

But get the following error:

SQL2542N  No match for a database image file was found based on
the source database alias "SMARTMUN" and timestamp
"20060928082904" provided.

command worked fine on migrating to V9, but when trying on V8.2 it does
not work... Please help!

Thanks

Ian


Re: DB2 Restore V8.2 Express

Postby Gert van der Kooij » Tue, 03 Oct 2006 17:44:51 GMT

In article < XXXX@XXXXX.COM >, 
 XXXX@XXXXX.COM  says...


It looks like a backup file taken on a Linux/Unix system. If so, you 
can't restore it on a windows system.

Re: DB2 Restore V8.2 Express

Postby Ian Mackenzie » Tue, 03 Oct 2006 21:10:38 GMT

Thanks, but the backup was taken on a windows Server 2003 machine.
Trying to restore it to the same machine...






Re: DB2 Restore V8.2 Express

Postby Gert van der Kooij » Tue, 03 Oct 2006 21:24:46 GMT

In article < XXXX@XXXXX.COM >, 
 XXXX@XXXXX.COM  says...

Then your backup directory/file should be something like this:

C:\SMARTMUN.0\DB2\NODE0000\CATN0000\20060926\082904.001

It can't be the one you mentioned.


Re: DB2 Restore V8.2 Express

Postby kavallin » Tue, 03 Oct 2006 21:29:47 GMT

Ian.. I dont know if it's a typo or what but ... your cmd to restore
the database is :
RESTORE DATABASE SMARTMUN FROM "C:\" TAKEN AT 20060928082904 WITH 2
BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTING; but the file has
the following timestamp 20060926082904...20060928 is not the same as
20060926.....

/Roger


Re: DB2 Restore V8.2 Express

Postby Ian » Thu, 05 Oct 2006 00:05:30 GMT



Gert,

DB2 9 finally fixed the directory tree nightmare for backups on
Windows boxes, so a Windows backup file looks like every other
platform.

Ian, I don't think you can restore a V9 backup image into a V8
engine.  There are all kinds of changes to the catalog, etc. that
V8 won't understand.

Your best best will be to export the data from the V9 database
and import it into a V8 database.




Re: DB2 Restore V8.2 Express

Postby Gert van der Kooij » Thu, 05 Oct 2006 00:23:00 GMT

In article <7%uUg.672$rS.39@fed1read05>,  XXXX@XXXXX.COM  says...



Thanks, Ian. I didn't notice it. Sorry, other Ian :)

Similar Threads:

1.Compatibility of DB2 Express C V9.0 backup to be restored on DB2 ExpressEdition 8.2

Hi All,

Is there any way to  restore the backup of DB2 Express C 9.0 edition
on a DB2 Server that have
DB2 Express edition Version 8.2.
Or atleast any workaround method???

Any suggestion is highly appreciated.

Thankq,
Dutt....

2.Compatibility of DB2 Express C V9.0 backup to be restored on DB2 ExpressEdition 8.2

On Sep 14, 12:16 pm, "Mark A" < XXXX@XXXXX.COM > wrote:
> "Dutt" < XXXX@XXXXX.COM > wrote in message
>
> news: XXXX@XXXXX.COM ...
>
> > Hi All,
>
> > Is there any way to  restore the backup of DB2 Express C 9.0 edition
> > on a DB2 Server that have
> > DB2 Express edition Version 8.2.
> > Or atleast any workaround method???
>
> > Any suggestion is highly appreciated.
>
> > Thankq,
> > Dutt....
>
> Workaround is db2look for schema definition, and then db2move for data.

Thanq Mark.........

Now I have some other question.
Our application installs DB2 Express Edition C V9.0  and then restores
the master database.
But there are other lower versions of DB2 in the client systems
already installed.
DB2 Express C is getting installed into it but the problem comes while
restoring the database.
Its throwing exceptions.

--Our plan is to identify Express C command prompt and restore the db
through it.
We have identified the specific folder that contains DB2 Express C --
CLP exe file but its name will not be specific for all the systems
depending on the number of other versions in it.

Cud u give help me in this issue????/\

Thanq,
Dutt..........

3.DB2 V8 Express Edition install on SUSE Linux 8.2 Prof

Problems with install DB2 V8 Express Edition on SUSE Linux 8.2 Prof.
Normally it have to work, I think.
I have done everything like it is written in the install pdf but the
visualation from the DB2 Wizard do not come to the Display
After writing ./db2setup in the shell it come

Please wait....

Thanks for help

4.RESTORE PROBLEM FROM DB2 V8.2 TO V9

Did restore from an OFFLINE backup under V8.2 to new db in V9.

OS=Windows 2000 Server

Can not migrate.  Receive error:
SQL0270N  Function not supported (Reason code = "75").  SQLSTATE=42997

5.caution using restore DB2 database from v7 to v8

Hi all,

Just wanna share some experices with you. We have experienced deadlock
problems after we migrated our DB2 v7.x to v8.x. And we are using WAS
5.x and WCBE 5.5 at the same time.

It tooks us days to find the root cause. By reading this post,
hopefully it won't cost you that much.

The root cause of the problem is "restore db"  only restores type 1
indexes to type 1. In V8.x, DB2_RR_TO_RS=YES  is deprecated for Type 2
Index. I didn't find the officical document from DB2 info center.
However, I tried this trick on AIX 5.1, DB2 V8.1.1.16 and seems no
longer supported there.


To fix the problem, we need to run reorg for every table to convert
type 1 index to type 2 after we restore the v7 database.

such as 
REORG INDEXES ALL FOR TABLE <FOO> CONVERT;

and it does solve the deadlock problem. 


cheers,
Victor

6. DB2 UDB V8.2 and DB2 V8 on Z/OS

7. Difference between DB2 UDB V8 Fix Pak 7 and V8 UDB Fix Pak 12

8. V8.2 Express Edition XP Home



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 4 guest