DB2 Maintenance Question

Michael Bancale

DB2 Maintenance Question
Since we began with DB2 we have been putting ESO Maintenance on the system
prior to migrating to a new release of DB2. I know this is not a good thing
to wait so long between maint but we did it. Recently we applied ESO
Maintenance to DB2 for put level 9907. Once this maintenance was applied we
pointed DB2 and the utilities to the new SDSNLOAD library.

Is this the way everyone else does it?

I would be interested in your maintenance strategies.

TIA

Michael


Michael Bancale
[login to unmask email]
Texas Farm Bureau Insurance Company
www.txfb-ins.com
Waco, Texas



Bill Welch

Re: DB2 Maintenance Question
(in response to Michael Bancale)
>At 01:22 PM 12/17/99 -0600, Michael Bancale wrote:
>Since we began with DB2 we have been putting ESO Maintenance on the system
>prior to migrating to a new release of DB2. I know this is not a good thing
>to wait so long between maint but we did it. Recently we applied ESO
>Maintenance to DB2 for put level 9907. Once this maintenance was applied we
>pointed DB2 and the utilities to the new SDSNLOAD library.
>
>Is this the way everyone else does it?
>
>I would be interested in your maintenance strategies.
>
>TIA
>
>Michael
>
>
>Michael Bancale
>[login to unmask email]
>Texas Farm Bureau Insurance Company
>www.txfb-ins.com
>Waco, Texas
>
>
>
>
>


We have one SDSNLOAD library for each DB2 subsystem (and other DB2 datasets
such as SDSNEXIT). We apply the maintenance first to our "install" or
"playpen" DB2 subsystem that we use for this purpose. We then use IEBCOPY
to do a copy with replace for the entire SDSNLOAD library (and any other
datasets affected) of each DB2 subsystem in turn over a period of time. We
copy the changes to the test DB2 subsystems first, run for a while to test
them, then copy the changes to the production DB2 subsystems. Any steps
required after applying the PTF, such as reassembling DSNZPARMS, must be
repeated for each DB2 subsystem.

We put the DB2 version number in our DB2 librarys' DSNAME here, so a new
PDS will be created when we go to a new version of DB2. In my previous
job, we did not put the version number in the DSNAME of the DB2 libraries
and used the same ones across DB2 versions.

Bill Welch

--

The opinions or statements expressed herein are my own
and should not be taken as a position, opinion, or
endorsement of the University of California.


--



William D. Welch
University of California, Berkeley
Central Computing Services, 502 Banway
510/643-2608
[login to unmask email]