Articles & Content


DB2 System Maintenance: Stay Flexible in an Inflexible World (B12)

Topic: 2008 NA

Subtopic: DB2 for z/OS

DATE: 2008-05-21 (04:00 PM - 05:00 PM)
SPEAKERS: Vaughn Overstreet (Wachovia Bank)

We Systems Programmers at Wachovia have had to re-invent and re-think our job role. Formerly, we easily kept up with DB2 APARS and PE's, and we maintained a small number of systems. Test was Test, and Prod was Prod. SQL was much simpler, and we sat a few aisles away from the DBA's and the key application designers. Nowadays, we must comply to strict schedules for the outage window, and we must conform our maintennace strategy to an inflexble set of external rules and requirements. Meanwhile DB2V8 has presented an unprecedented number of challenges, not the least being the sheer volume of DB2 maintenance. Our maintenance strategy is a key component in the new world. We simplify our SMP to a handful of commands, and we build implementation bundles to stand apart from whaever is in the SMP world. We simplified our documentation, we design our maintnenance to be simple, segmented, and with a fully documented backout plan.

EXP. LEVEL: Beginner


Dividing up the DB2 Systems Maintenance, ZPARMS, vs. LOADLIBS, vs. ERLY code, vs. SDSNSAMP, vs HFS, and so on.

A set of useful, but under-appreciated SMP commands and a way to use them without knowing too much about SMPE itself.

A single EXCEL Work sheet to track the maintenance from the time it arrives from IBM to the point at which it is added to a DB2 subsystem

How to build a DB2 maintnenance Bundle

Getting a handle on what makes management nervous.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.