Hi all, I m trying to load the data exported from DB2 v5 Os/2 to DB2 v 8 .1 and getting the following error in the process..
SQL03089N A non D record was found where a D record was expected......
ANy idea?????

loading the data exported from DB2 v5 Os/2 to DB2 v 8 .1 ?? Is it allowed?
DB2s are incompatible.

Aren't there any useful LOAD parameters to be set, so that the data becomes compatible?
Sorry for not being more helpful; I'm not fully familiar with LOAD params on non-z/OS, and neither do I know the data format of OS/2 ...

hi,,, i have the exports file in IXF format . i am already done with some 58 tables,. This error is coming only in one of the tables. and infact that table ois the largest one with some 63K records.
I think i should try it out with the DEL format.....
what do u say!!!

You could check the correctness of the exported data by loading it back into the OS/2 system (of course into a different table).
If that works, a possible problem could be (just guessing) a difference in codepages, with a certain character from the source codepage missing in the target codepage.
If that's the case, try loading into a UNICODE-encoded table.

An other problem could be the "physical" transfer of the data file between the two systems: did you make sure to copy it (with FTP or whatever) in BINARY mode?
Or did you ZIP it? In that case, using GNU zip instead of winzip could solve the problem...