Hi fellow DB2 DBA's,

I need a very urgent answer for my problem.

A couple of days ago we had the production DB2 v.6 for OS/390 migrated to v.7. (The version in development was already the v.7)

Now, I populate a particionate tablespace from a FULLCOPY IMAGE and when I do a simple SELECT statment it abends me with S04E - RC=00C90101, which i looked up and it is not so explicit.(Catalog damage,Migration problems,RIDS...)


If I do a SELECT COUNT(*) throughout the various parts of the table it is okay, and a full count gives me the exact record count, so I know that the records are all there but I cannot see them.

I've already repaired the level IDs of all the parts of the tablespace.
I've already rebuilt the indexes, just to end up with the same RC=00C90101 when I do a SELECT on the table.


PS: The strangest thing is that if I LOAD a part of the records to the table I can see them, no problem.


Thanks in advance,

Pedro Gonçalves

DB2 & UDB email list listserv db2-l LazyDBA home page