Identifying Tables with short rows

Steve Schuering

Identifying Tables with short rows
Is there a way to identify Tables that have had columns added via an Alter
Add Columns but have not been reorged or loaded yet?

We frequently refresh environments using DSN1COPY and we need to know if
any of the Tables have "short" rows and the other environment's version does
not.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Sevetson

Re: Identifying Tables with short rows
(in response to Steve Schuering)
Well, what comes to mind is to check ALTEREDTS for a table against
SYSIBM.SYSCOPY for existence of a REORG or LOAD row with a greater
date/time... the SQL is "left as an exercise for the student" (to quote
a professor I never much liked back in college).

--Phil Sevetson, NYCAPS DBA Support
Financial Information Services Agency of The City of New York
450 West 33rd Street, 4th Floor
New York, NY 10001
phone: (212) 857-1688
mailto: [login to unmask email]
-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve Schuering
Sent: Monday, December 17, 2007 11:46 AM
To: [login to unmask email]
Subject: [DB2-L] Identifying Tables with short rows

Is there a way to identify Tables that have had columns added via an
Alter
Add Columns but have not been reorged or loaded yet?

We frequently refresh environments using DSN1COPY and we need to know if

any of the Tables have "short" rows and the other environment's version
does
not.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site,
you can also access the IDUG Online Learning Center, Tech Library and
Code Place, see the latest IDUG conference information, and much more.
If you have not yet signed up for Basic Membership in IDUG, available at
no cost, click on Member Services at http://www.idug.org/lsms


=========
Confidentiality Notice: This e-mail communication, and any attachments, contains confidential and privileged information for the exclusive use of the recipient(s) named above. If you are not an intended recipient, or the employee or agent responsible to deliver it to an intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error, please notify me immediately by replying to this message and delete this communication from your computer. Thank you.

Any opinions, expressed or implied, presented are solely those of the author and do not necessarily represent the opinions of the agency or the City.
=========

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Sally Mir

Re: Identifying Tables with short rows
(in response to Philip Sevetson)
If you want to go digging into the DBD, fields OBDREVLR, OBDREVLF, and
OBDREVAF would be of interest.

But in my opinion, that's too difficult and impractical to track down.


Sally A. Mir, AVP
Wachovia Enterprise Data Management
(336) 773-4011
IBM Certified Database Administrator
DB2 9 DBA for Z/OS
DB2 Universal Database V8.1 for Z/OS
IBM Certified Database Associate
DB2 Universal Database V8.1 Family



Steve Schuering
<steven.schuering
@EXELONCORP.COM> To
Sent by: DB2 Data [login to unmask email]
Base Discussion cc
List
<[login to unmask email] Subject
ORG> Identifying Tables with short rows


12/17/2007 11:46
AM


Please respond to
DB2 Database
Discussion list
at IDUG
<[login to unmask email]
2-l.org>






Is there a way to identify Tables that have had columns added via an Alter
Add Columns but have not been reorged or loaded yet?

We frequently refresh environments using DSN1COPY and we need to know if
any of the Tables have "short" rows and the other environment's version
does
not.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L
list archives, the FAQ, and delivery preferences are at
http://www.idug.org/lsidug under the Listserv tab. While at the site, you
can also access the IDUG Online Learning Center, Tech Library and Code
Place, see the latest IDUG conference information, and much more. If you
have not yet signed up for Basic Membership in IDUG, available at no cost,
click on Member Services at http://www.idug.org/lsms

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Chris Hoelscher

Re: Identifying Tables with short rows
(in response to Sally Mir)
as for columns added via alter - look for columns whose date/time stamp in
syscolumns is different than the date/time stamp of the owining table? (or
at least within a second?)




Chris Hoelscher
Senior IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]



The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

The IDUG DB2-L Listserv is only part of your membership in IDUG. DB2-L list archives, the FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information, and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms