Any site???

Mohammed Nayeem

Any site???
Hi

Is there any URL where I can have sample REXX routine that checks the DB2
catalogs and generates reorg jobs ?
(If it is available)

Thanks & Regards
Nayeem



Lee Mandel

Re: Any site???
(in response to Mohammed Nayeem)
Hi Nayeem,
I am not sure about reorg jobs but if you are looking for a tool that read
DB2 catalog and generate recovery jobs of all kind on the MVS platform see:
http://www.recoveryknowledge.bigstep.com

Good luck,
Lee



Edward Vassie

Re: Any site???
(in response to Lee Mandel)
I wrote something like this in the past, but eventually it got replaced by a
formal product.

The automation of reorgs is good, but is best done using a supported product
from an established vendor. This allows the DBA to concentrate on database
management, and not on fixing application code. Most vendor products will
drive the reorganisation process harder than code you can develop, and
provide you with an updated product to support a new DB2 release.

Also, most vendors supply products that allow you to automate backup and
recovery, and some tackle service management SLA-type issues.

The key for deciding to use a vendor product is if the money saved by using
the product is greater than its cost. For a reorg, this means looking at
the cost of doing a reorganisation (outage & CPU time) compared to the cost
of not doing it (poor performance). If this can be established, then you
should also work out which company can maximise your savings.

The main vendors for such products are BMC, CA, and IBM. If you want to
discuss the issues further with someone from the company I work for (BMC)
please e-mail me direct on [login to unmask email]

From Edward Vassie...


-----Original Message-----
From: Mohammed Nayeem [mailto:[login to unmask email]
Sent: 05 January 2001 23:08
To: [login to unmask email]
Subject: Any site???


Hi

Is there any URL where I can have sample REXX routine that checks the DB2
catalogs and generates reorg jobs ?
(If it is available)

Thanks & Regards
Nayeem








Seppo Nurmi

Re: Any site???
(in response to Edward Vassie)
Hi Nayeem!
I read this a few days late, but anyway, look at www.xephon.com

/Seppo

> -----Original Message-----
> From: Mohammed Nayeem [SMTP:[login to unmask email]
> Sent: Saturday, January 06, 2001 12:08 AM
> To: [login to unmask email]
> Subject: Any site???
>
> Hi
>
> Is there any URL where I can have sample REXX routine that checks the DB2
> catalogs and generates reorg jobs ?
> (If it is available)
>
> Thanks & Regards
> Nayeem
>
>
>
>
>