Methods to migrate DB2 v5.1 data to DB2 v8.2 2

[DeepDiverMom]

I know this sounds nutty, but we need to migrate DB2 v5.1 data to DB2 v8.2. There are hundreds of tables in each of a dozen databases that need to make the trip from v5.1 to v8.2. I've successfully created (on v8.2) empty databases as targets for the v5.1 data.

We've already confirmed that restoring to v8.2 from v5.1 backup files won't work. (It throws the error,
"SQL2514N The RESTORE was not successful. The backup used to restore the database contained a database with a release number that is not compatible with the installed version of the database manager.")

What methods are available to migrate our v5.1 data to v8.2?

Thanks,

Becca

 

[MarcLodge]

Hi Becca,
does an unload/reload have any possibility?
Marc

 

[DeepDiverMom]

Marc,

Thanks for your reply. I am an Oracle DBA in a "DB2 DBA's clothing", so I am not familiar with all the options available to me. I am willing to try anything to resolve our need.

I do, however, have a few questions:
1) Is an "unload" from v5.1 followed by a "reload" into v8.2 supported by DB2?
2) Have you successfully used "unload/reload" between such diverse versions?
2) Can you suggest the specific syntax I should use for each step?


Thanks, Marc, for your help.

Becca

 

[tbtcust]

DeepDiverBecca,

You should try moving your database through the following versions:
From v5 => v7 => v8 or
From v5 => v6 => v8. The first will be less likely to have problems, especially if you used v7.2 rather than v7.1.

I prefer moving a database via a DB2 utility called db2move. See

https://aurora.vcu.edu/db2help/db2dm/frame3.htm#db2dm86

for details. Hope this helps.

 

[DeepDiverMom]

Marc,

Unload/Reload seems non-viable since my research shows that "Unload" is not available prior to V7. Please correct me if I'm wrong.

Tbt103,

Your suggestion is looking very viable. I ran "db2move DSVREL export -l /dbsrv/db2/data2/migrate/DSVREL/longs " with 99% success. I say 99% since I received the following error:

*** Table "DICTREL "."DD_DTIMPLMNTTNS": ERROR -3040. Check message file tab24.msg!
*** SQLCODE: -3040 - SQLSTATE:
*** SQL3040N Unable to use the lobpath/lobfile parameters as specified. Reason
code: "4".

There is plenty of space in the file system (> 1GB). DB2’s official description of this error says:

Cause: The utility is unable to use the lobpath or lobfile parameters as specified for the reason given by "<reason-code>". The codes are listed below: …
4 There are not enough lobfile names provided. For
export, there are more lobs than the number of lobfile
names provided multiplied by SQLU_MAX_SESSIONS.

The syntax explanation (from

https://aurora.vcu.edu/db2help/db2dm/frame3.htm#db2dm86)

says for the “-l” parameter

"This option specifies the absolute path names where LOB files are created (as part of EXPORT) “.

Can you, Tbt103, (or anyone) explain what I should try in order to resolve this issue?

Thanks,

Becca

 

[DeepDiverMom]

DB2 Gurus,

I'm posting here again out of desperation. My management is amping badly about this migration becoming stalled due to my hanging up on migrating LOB columns from DB2 v5.1 to DB2 v8.2.

TBT103's suggestion to use "db2move" is excellent and is successful for all tables that do not contain LOB columns (such as LONGVAR, BLOB, CLOB, et cetera). With the errors, above, that I receive, I am dead in the water. Can someone please advise me what to do to get this migration project done and to save my job?

Thanks,

Becca

 

[MarcLodge]

Becca,
I'll freely admit that I've never used this utility, but as noone else has ansered, I'll have a go.....

I've had a snoop around on the net, and it appears that you can specify more than one lobfile directory, and that the definition of such is problematical as it looks like you need commas between your lobfiles.
Have a look at these sites and see if they help:

http://groups.google.co.uk/groups?h...selm=8ito31%24hl6%241%40nnrp1.deja.com&rnum=1

http://dbforums.com/t357063.html

http://www2.herethey.com:8888/db2eug.w3archive/199909/msg00052.html

I think they should sort you out, as they seem to be describing exactly the same problem.

Marc

 

[DeepDiverMom]

Marc and TBT103,

Combined, your suggestions and links got me through a rather traumatic migration. Thanks so much and "Purple Stars" to you both !

Becca

 

[MarcLodge]

Glad to have been of help Becca and thanks for the star!

 

[tbtcust]

Becca,

Glad you got throught the migration.