DB2 Restore V8.2 Express

DATABASE

    Sponsored Links

    Next

  • 1. Upgrade and License questions
    I can not seem to get a good answer to these questions: I have a DB2 database that we run DB2 6.1 workgroup Edition. We had purchased upgrade protection up until 2002. So I have my cd's for Workgroup Edition 7.1. Really what I would like to do is upgrade to 8.1 or 8.2 What is it going to take for me to get to that level? I have tried calling IBM but I can not seem to get a good answer from them. How long will 7.1 be supported? Additonally we purchased 8.2 Enterprise Server for another system we use. Does that include multiple installations usually? As yall know 6.1 is no longer supported so I need to get this DB ugraded quickily. Any advice?
  • 2. ETL & Data Mapping
    Anyone know of any ETL or DataMapping software that can be used to migrate to IBM DB2 from Oracle? Thanks, DWB
  • 3. Search odbc driver for udb
    Hello, I would like to access a UDB database on a Sun Solaris 5.8. The client is a XP station. When I list the default odbc drivers, I found "Microsoft ODBC Driver for DB2". But I think it can not be used to access a UDB DB on Unix machine. So where can I find a ODBC driver ? Thank you
  • 4. stored proc error - ADO and DB2
    Greetings! I am VERY new to DB2 but not Orable, Sybase and SQL Server. I am trying to call a stored procedure via VB 6 and ADO/OLEDB. But when I try to execute
  • 5. Can't register DB as data source
    I have a windows 2000 server running V8 fix pack 4a with the DB2 Instance. I wanted to move the active database off of the db2 instance away from the TOOLSDB so I created a new instance INST2. I created a database XYZ in INST2 and that went fine. I went into client configurationa and wanted to set the XYZ database "Register this database for ODBC" I clicked on the check box Selected "As System data source" and tool the default name XYZ as the source name. I click finish and nothing happens. I don't get an error message or anything it just thinks for a minute and doesn't do anything. Any one had this problem before? Am I missing a step? Thanks. Steven

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 22 guest