V8.2 will do the SPs as well.
"Praveenkumar"
<db2udbdba-ezmlms
hield-x26290869.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
11/23/2005 02:59
AM Subject
RE: Problem with DB restoration
after upgrade
Hi George
Db2move will only transfer the tables and data.
If you have stored procedures and user defined functions then you will
have to use db2loopk as well. For SP's and UDF's greater than 32kb you
will need to use import/load and export commands using lobsinfile
modifier.
HTH
Warm regards,
Praveen Pandey
Choose a job you love, and you will never have to work a day in your
life
-----Original Message-----
From: George I. Develekos
[mailto:db2udbdba-ezmlmshield-x50439108.[Email address protected]
Sent: Tuesday, November 22, 2005 4:07 PM
To: LazyDBA Discussion
Subject: RE: Problem with DB restoration after upgrade
Thanks, Akhilesh,
I don't have the v7 server any longer, I'm about to re-install it and
have both versions active on the same machine till I'm done.
Then I'll run db2move, I suspect that would do the trick without db2look
for the DDL...
George
-----Original Message-----
From: akhileshmittal
[mailto:db2udbdba-ezmlmshield-x65081213.[Email address protected]
Sent: 22 November 2005 11:30
To: LazyDBA Discussion
Subject: Re: Problem with DB restoration after upgrade
George:
Generate the DDL from the Old server database.
Create the DB on new server, run the extracted ddl
Use DB2MOVE utility for moving data.
HTH,
Akhilesh
"George I. Develekos "
<db2udbdba-ezmlmshield-x93180477.[Email address protected]
11/22/2005 02:37 PM
Mail Size: 4216
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
Problem with DB restoration after upgrade
Our Ref
Your Ref
Greetings,
We recently upgraded our pSeries e-server model 615 to AIX 5.3 and DB2
8.1.
I have a backup of our production DBs taken on AIX 4.X and DB2 7.3.
It seems I can't restore, getting a 2570 error, because the platform has
changed (???!!!)
The manuals suggest that I use the db2move utility, which, however,
appears unable to restore from a backup image, as it uses
export/import/load instead.
Is there a way out??? It never occurred to me that the new platform is
different from the old one, to the point of not being able to do a DB
restore!!! I only expected to do a migrate after the restoring (as a
matter of fact I asked the forum for some help on that last week).
Thank You,
George I. Develekos
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
-----------------------------------------
******************************************************************
This message originated from the Internet. Its originator may or may
not be who they claim to be and the information contained in the
message and any attachments may or may not be accurate.
******************************************************************
-----------------------------------------
***********************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.
Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
***********************************************************************
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page