LOB info - the good, bad and UGLY

Nigel Lemaire

LOB info - the good, bad and UGLY
There is an excellent Red Book - Large Objects with DB2 for z/OS and
OS/390 SG24-6571 that you might want to review.

Having LOG YES will probably drive the SS Logging crazy IMHO.

We have an "adventurous application" that will be using 2g LOBs, *and*
moving them over our network!
That will be interesting to see!

Reorg with Purge is very problematic, see IBMs response below -

At the suggestion of the IBM rep, I opened a DCR (Design Change Request)
with IBM to have REORG properly address this issue.

Here is the current technique from the ETR to "re-align" the BASE and
AUX tables..... quite manual, with a high potential for "finger checks"
IMHO

Thanks for the update. I checked and tested the following procedure and
it works here: (after running the REORG with DISCARD on BASE Table)

1. Check lob tablespace---Nothing returned
2. Rebuild index----auxilary index on auxilary tablespace
3. Check data tablespace AUXERROR INVALIDATE (against base tablespace),
check message DSNU813I, which reported the orphaned lob entry's
ROWID and VERSION.
4. Run Repair locate tablespace ROWID x'nnnnnn' VERSION x'nnnnn' Delete
(against lob tablespace)
5. Rerun check data against base tablespace, returned nothing.

YUCK!


Nigel Lemaire
EDS Americas Infrastructure Technology & Engineering
Mainframe DB2 Production DBA
Phone : 541-618-8444
vnet : NONE
Pager : 1-877-285-2796
Email page : [login to unmask email]
EMAIL : Nigel.Lemaire @ EDS.COM
AOLIM : WA6MSE
JABBER : nigel.lemaire
Windows Messenger : Lemaire, Nigel B

I have learned a lot, but know nothing




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm