Identifying Reorg SHRLEVEL NONE objects from catalogue tables

Rakesh Adhikarapu

Identifying Reorg SHRLEVEL NONE objects from catalogue tables

Dear Team,

Could you please help me in finding the tablespaces information that were part of SHRLEVEL NONE Reorg. From SYSCOPY catalogue I couldn't find any. Right now I'm checking from production JCLLIB scheduled jobs and finding objects with Reorg and planning to change them to SHRLEVEL CHANGE and it is time consuming.

Thanks,

Rakeysh

Roy Boxwell

AW: Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Rakesh Adhikarapu)
Use

ICTYPE CHAR(1)

Type of operation:
A ALTER
B REBUILD INDEX
C CREATE
D CHECK DATA LOG(NO) (no log records for the range are available for RECOVER utility)
E RECOVER (to current point)
F COPY FULL YES
I COPY FULL NO
L SQL (type of operation)
M MODIFY RECOVERY utility
P RECOVER TOCOPY or RECOVER TORBA (partial recovery point)
Q QUIESCE
R LOAD REPLACE LOG(YES)
S LOAD REPLACE LOG(NO)
T TERM UTILITY command
V REPAIR VERSIONS utility
W REORG LOG(NO)
X REORG LOG(YES)
Y LOAD LOG(NO)
Z LOAD LOG(YES)

The W is the one you need

Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Bettina Schubert

Von: Rakesh Adhikarapu [mailto:[login to unmask email]
Gesendet: Mittwoch, 20. September 2017 12:49
An: [login to unmask email]
Betreff: [DB2-L] - Identifying Reorg SHRLEVEL NONE objects from catalogue tables


Dear Team,

Could you please help me in finding the tablespaces information that were part of SHRLEVEL NONE Reorg. From SYSCOPY catalogue I couldn't find any. Right now I'm checking from production JCLLIB scheduled jobs and finding objects with Reorg and planning to change them to SHRLEVEL CHANGE and it is time consuming.

Thanks,

Rakeysh

-----End Original Message-----

Rakesh Adhikarapu

RE: AW: Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Roy Boxwell)

Hello Roy,

ICTYPE=W shows for Reorg with Log NO, irrespective of SHRLEVEL. Could be good if we can find the objects that ran with REORG SHRLEVEL NONE from any catalogue entries.

Rakeysh

Roy Boxwell

AW: Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Rakesh Adhikarapu)
Arghhh.... so true...

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Bettina Schubert

On 21 Sep 2017, at 21:04, Rakesh Adhikarapu <[login to unmask email]<mailto:[login to unmask email]>> wrote:


Hello Roy,

ICTYPE=W shows for Reorg with Log NO, irrespective of SHRLEVEL. Could be good if we can find the objects that ran with REORG SHRLEVEL NONE from any catalogue entries.

Rakeysh

-----End Original Message-----

J&#248;rn Thyssen

RE: Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Rakesh Adhikarapu)

Hi Rajesh,

You can also consider Db2 performance trace class 10 IFCID 23 and/or 25.

These traces are inexpensive but you do need a vendor tool to read the SMF records

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

David Baldon

Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Jørn Thyssen)
A shortcoming of this approach is you only know about jobs that have actually been run in the DB2 the traces are active in. How do you determine how long to monitor for the jobs? 3 months to get daily, weekly, quarterly jobs? 6 months to get daily, weekly, quarterly, bi-annual jobs? 1 year to get…well you get the idea.

It sounds like what you need is a good tool for scanning your JCLLIB and SYSIN libraries to find the occurrences of SHRLEVEL and see which ones have the NONE keyword.

Maybe a combination of the approaches would be the best answer.

Regards...David

From: Jørn Thyssen [mailto:[login to unmask email]
Sent: Thursday, September 21, 2017 3:53 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: Identifying Reorg SHRLEVEL NONE objects from catalogue tables


Hi Rajesh,

You can also consider Db2 performance trace class 10 IFCID 23 and/or 25.

These traces are inexpensive but you do need a vendor tool to read the SMF records



Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email]<mailto:[login to unmask email]> • W: www.rocketsoftware.com http://www.rocketsoftware.com

Views are personal.

-----End Original Message-----

J&#248;rn Thyssen

RE: Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to David Baldon)

Hi David,

Yes, a combination is likely best.

If you scan the libraries you will find jobs that are never run. And unless your list of libraries is complete you will miss some utilities.

1) Look in SYSCOPY for REORGs

2) Find the associated SMF IFCID 23/25 record and check SHRLEVEL

3) If SHRLEVEL NONE (and REFERENCE!) search libraries for the offending JCL (IFCID 25 gives you the jobname)

 

I may also add that there are vendor tools that can intercept utility runs and change the options on-the-fly, e.g., changing REORG SHRLEVEL NONE to REORG SHRLEVEL CHANGE or making REORG SHRLEVEL NONE return RC08.

 

 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

Views are personal. 

Edited By:
Jørn Thyssen[Organization Members] @ Sep 22, 2017 - 08:27 AM (Europe/Copenhagen)

Kirk Hampton

Identifying Reorg SHRLEVEL NONE objects from catalogue tables
(in response to Roy Boxwell)
Unfortunately, if you are running MODIFY RECOVERY regularly, (as you should)
then the last reorg job information in SYSIBM.SYSCOPY for any tablespaces which get reorg’ed infrequently, (also desirable)
may have been purged…

J. Kirk Hampton
DB2 z/OS Sysprog
HCL America
Frisco, Texas
817-228-6083


From: Boxwell, Roy [mailto:[login to unmask email]
Sent: Wednesday, September 20, 2017 6:02 AM
To: [login to unmask email]
Subject: [DB2-L] - AW: Identifying Reorg SHRLEVEL NONE objects from catalogue tables

Use

ICTYPE CHAR(1)

Type of operation:
A ALTER
B REBUILD INDEX
C CREATE
D CHECK DATA LOG(NO) (no log records for the range are available for RECOVER utility)
E RECOVER (to current point)
F COPY FULL YES
I COPY FULL NO
L SQL (type of operation)
M MODIFY RECOVERY utility
P RECOVER TOCOPY or RECOVER TORBA (partial recovery point)
Q QUIESCE
R LOAD REPLACE LOG(YES)
S LOAD REPLACE LOG(NO)
T TERM UTILITY command
V REPAIR VERSIONS utility
W REORG LOG(NO)
X REORG LOG(YES)
Y LOAD LOG(NO)
Z LOAD LOG(YES)

The W is the one you need

Roy Boxwell

SOFTWARE ENGINEERING GMBH and SEGUS Inc.
-Product Development-

Heinrichstrasse 83-85
40239 Duesseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]<mailto:[login to unmask email]>
http://www.seg.de http://www.seg.de

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Bettina Schubert

Von: Rakesh Adhikarapu [mailto:[login to unmask email]
Gesendet: Mittwoch, 20. September 2017 12:49
An: [login to unmask email]<mailto:[login to unmask email]>
Betreff: [DB2-L] - Identifying Reorg SHRLEVEL NONE objects from catalogue tables


Dear Team,

Could you please help me in finding the tablespaces information that were part of SHRLEVEL NONE Reorg. From SYSCOPY catalogue I couldn't find any. Right now I'm checking from production JCLLIB scheduled jobs and finding objects with Reorg and planning to change them to SHRLEVEL CHANGE and it is time consuming.

Thanks,

Rakeysh

-----End Original Message-----

-----End Original Message-----


::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------

The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and other defects.

----------------------------------------------------------------------------------------------------------------------------------------------------