Reorg directory database

Grace Chen

Reorg directory database
Hi List,
I ran REORG REPORTONLY with LOG NO on directory database tablepsace
DSNDB01.DBD01, DSNDB01.SCT02 and DSNDB01.SPT01. It failed with
REASON=X'00E4070D' .
Since the Utility manual only indicate:
'You can't reorganize DSNDB01.SYSUTILX and DSNDB01.SYSLGRNGX'. I assume
that I should be able to reorganize DSNDB01.DBD01, DSNDB01.SCT02 and
DSNDB01.SPT01. Am I right?

Grace Chen
Technical Support
Credit Union Central Alberta Ltd.
Tel: (403) 258-5982
E-mail : [login to unmask email]


_______________________________________________________
eSafe Protect Gateway has scanned this mail for viruses, vandals and
suspicious attachments.

Sanjeev (CTS) S

Re: Reorg directory database
(in response to Grace Chen)
Grace,

The reason code says that there is a problem in updating the EPOCH column in
SYSIBM.SYSTABLEPART. This column is incrementing value of row displacement.
I believe someone who has seen this problem in past may provide you the
better solution otherwise please send us the complete message which you got
in the reorg job or if there is any in the MSTR a/s.

You can run reorg on DBD01, SCT02 and SPT01. Also recommended is to use
inline IC.

With Best Regards,
Sanjeev

> -----Original Message-----
> From: Grace Chen [SMTP:[login to unmask email]
> Sent: Tuesday, January 08, 2002 2:36 AM
> To: [login to unmask email]
> Subject: Reorg directory database
>
> Hi List,
> I ran REORG REPORTONLY with LOG NO on directory database tablepsace
> DSNDB01.DBD01, DSNDB01.SCT02 and DSNDB01.SPT01. It failed with
> REASON=X'00E4070D' .
> Since the Utility manual only indicate:
> 'You can't reorganize DSNDB01.SYSUTILX and DSNDB01.SYSLGRNGX'. I assume
> that I should be able to reorganize DSNDB01.DBD01, DSNDB01.SCT02 and
> DSNDB01.SPT01. Am I right?
>
> Grace Chen
> Technical Support
> Credit Union Central Alberta Ltd.
> Tel: (403) 258-5982
> E-mail : [login to unmask email]
>
> _______________________________________________________
> eSafe Protect Gateway has scanned this mail for viruses, vandals and
> suspicious attachments.



Michael Ebert

Re: Reorg directory database
(in response to Sanjeev (CTS) S)
Hello Grace,

the Conditional REORG checks the statistics in SYSINDEXPART/SYSTABLEPART
(OFFPOS/INDREF) to determine whether to REORG or not. For the DSNDB01
objects, these entries do not exist, so you cannot run Conditional REORG
on them.

Also, the docus available to me (IBM Manuals, the DB2 Developers Guide...)
say you can't REORG SYSLGRNX, but they're wrong. For V6, there was a PTF
that added the capability. For V5, there is no PTF but it still
mysteriously started working sometime in the middle of last year (I asked
the list where it came from but got no replies). See the Cat/Dir REORG JCL
I placed on the DB2-L-Documents site.
I just tried to re-check the Online Docu, but all IBM sites in my
Favorites list seem to be down...

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany



Hi List,
I ran REORG REPORTONLY with LOG NO on directory database tablepsace
DSNDB01.DBD01, DSNDB01.SCT02 and DSNDB01.SPT01. It failed with
REASON=X'00E4070D' .
Since the Utility manual only indicate:
'You can't reorganize DSNDB01.SYSUTILX and DSNDB01.SYSLGRNGX'. I assume
that I should be able to reorganize DSNDB01.DBD01, DSNDB01.SCT02 and
DSNDB01.SPT01. Am I right?

Grace Chen
Technical Support
Credit Union Central Alberta Ltd.
Tel: (403) 258-5982
E-mail : [login to unmask email]

Jim Ruddy

Re: Reorg directory database
(in response to Michael Ebert)
Since there are no catalog entries for directory tablespaces or indexes and
OFFPOSLIMIT, INDREFLIMIT, and LEAFDISTLIMIT keywords causes REORG to
attempt to lookup statistics in the catalog related to the tablespace or
index and abend occurs. Apar PQ43913 is open to check for this
combination and issue an error message.

Jim Ruddy
DB2 for z/OS and OS/390 Development.