[OT] catalog reorgs for maintenance

Philip Sevetson

[OT] catalog reorgs for maintenance
Behave. Or come on over to this side of the pond and we’ll have pizza and beer (whiskey, for me) after work.

From: Bell, Raymond (Hosting Services, Technology) [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 8:21 AM
To: '[login to unmask email]'
Subject: [DB2-L] - RE: catalog reorgs for maintenance

A stake through the heart also wards off creatures of the night (aka programmers). Or ‘steak’ if you have Roy’s spell-chucker activated. :o)

Or course, ‘chucker’ could just be a Kiwi accent and therefore perfectly valid…

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: 02 July 2019 13:19
To: '[login to unmask email]'
Subject: [DB2-L] - RE: catalog reorgs for maintenance


*********************************************
" This message originates from outside our organisation. Consider carefully whether you should click on any links, open any attachments or reply. If in doubt, forward to ~ Phishing"
*********************************************
Roy, and all –

My experience with Catalog reorgs is that you do them for space management – primarily for SYSCOPY and SYSLGRNX – and then, after that, you do them as a talisman to ward off programmers blaming you for slow BINDs or catalog queries.

-phil (sevetson)

From: Grainger, Phil [mailto:[login to unmask email]
Sent: Tuesday, July 02, 2019 7:00 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: catalog reorgs for maintenance

Or as Roger (Miller) once postulated

How far into the life of Db2 did IBM deliver a catalog reorg? About 20 years?? Then I guess once every 20 years would be about right

Well, Db2 has certainly evolved since then and it’s a much more rapidly changing world than it was but I still wonder if anyone has measured the “improvements” (and improvements in what precisely) that accrue from a catalog reorg. Or is it really just about space management?

Phil Grainger
Principal Enablement Manager

[BMC Exchange 2019 - Global Event Series - REGISTER] https://www.bmc.com/ami

Direct

+44 1189 218 000

Mobile

+44 7808 643 479

Email

[login to unmask email]

E2, Eskdale Road
Winnersh
Berkshire
United Kingdom
RG41 5TS
[image001 (002)][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png][https://acclaim-production-app.s3.amazonaws.com/images/2429c3cd-a1de-44fc-b4f3-bc762bb2f963/IBM%2BChampion%2B-%2BAnalytics%2B2018.png]



From: Boxwell, Roy <[login to unmask email]>
Sent: 02 July 2019 10:58
To: [login to unmask email]
Subject: [EXTERNAL] [DB2-L] - RE: catalog reorgs for maintenance

I think the old recommendation still stands: once a year is enough (apart from SYSCOPY that might need much more regular REORGs!) unless you have CATMAINT that adds columns – then straight after the apply of course.

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]>
Web http://www.seg.de https://urldefense.proofpoint.com/v2/url?u=http-3A__www.seg.de_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=uWn3uYlsT0Vfx-vpQbx1hQA11ZoS6twZroq2bFuoXn4&s=Ti8KQRtUQ9hb2f5nupLCrC6MboOi4x4JsyPJNFowEzI&e=
Link zur Datenschutzerklärung https://urldefense.proofpoint.com/v2/url?u=https-3A__www.seg.de_corporate_rechtliche-2Dhinweise_datenschutz_&d=DwMFaQ&c=UrUhmHsiTVT5qkaA4d_oSzcamb9hmamiCDMzBAEwC7E&r=EAGrd_qzLADPfI8dgytr8sbCG7_U9QfXwQMLgK1Zo30&m=uWn3uYlsT0Vfx-vpQbx1hQA11ZoS6twZroq2bFuoXn4&s=azeRnIJEPQPHClvS4Swty8BwdvZoHx8oTRPqxcoQGsU&e=

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

From: william giannelli [mailto:[login to unmask email]
Sent: Tuesday, July 2, 2019 11:51 AM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [DB2-L] - catalog reorgs for maintenance


does anyone have any best practices for doing catalog reorgs when applying maintenance? Or does it just depend on the particular maintenance itself? I am applying maintenance that may require (depending on the results of apar supplied queries) some catmaint runs. Would it be advisable to run catalog reorgs before? after? or both?

thanks

Bill

-----End Original Message-----
BMC Software Limited Registered Office: Building E2, Eskdale Road, Winnersh, Wokingham, Berkshire, United Kingdom, RG41 5TS Registered in England No. 1927903 The content of this email is confidential. If you are not the addressee, you may not distribute, copy or disclose any part of it. If you receive this message in error, please delete this from your system and notify the sender immediately.
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**
-----End Original Message-----
The Royal Bank of Scotland plc. Registered in Scotland No 83026. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB. The Royal Bank of Scotland is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and Prudential Regulation Authority. The Royal Bank of Scotland N.V. is authorised and regulated by the De Nederlandsche Bank and has its seat at Amsterdam, the Netherlands, and is registered in the Commercial Register under number 33002587. Registered Office: Gustav Mahlerlaan 350, Amsterdam, The Netherlands. The Royal Bank of Scotland N.V. and The Royal Bank of Scotland plc are authorised to act as agent for each other in certain jurisdictions.

National Westminster Bank Plc. Registered in England No. 929027. Registered Office: 250 Bishopsgate, London EC2M 4AA. National Westminster Bank Plc is authorised by the Prudential Regulation Authority, and regulated by the Financial Conduct Authority and the Prudential Regulation Authority.

The Royal Bank of Scotland plc and National Westminster Bank Plc are authorised to act as agent for each other.

This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc, The Royal Bank of Scotland N.V., National Westminster Bank Plc or any affiliated entity (RBS or us) does not accept responsibility for changes made to this message after it was sent. RBS may monitor e-mails for business and operational purposes. By replying to this message you understand that the content of your message may be monitored.

Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by RBS in this regard and the recipient should carry out such virus and other checks as it considers appropriate.


Visit our website at www.rbs.com http://www.rbs.com
-----End Original Message-----
**This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.**