Articles & Content

Archives

Automation of DB Administration at the Systemlevel (G14)

Topic: DB2 for z/OS

Subtopic: 2005



DATE: 2005-10-26 (11:00 - 12:00)
SPEAKERS: Joachim Duevel (Joachim Duevel Consulting)

The growing number of DB2 systems with a huge number of dynamically changing objects makes DB administration with static jobs impossible. COPY, RUNSTATS, MODIFY, REORG, object resizing/compression must be run against moving targets. This presentation shows how Realtime Statistics, LISTDEF, DYNALLOC, TEMPLATE, EXEC SQL in DSNUTIL, Declared Temp Tables and History Tables are used in an SAP project to automate utility tasks.

EXP. LEVEL: Advanced

OBJECTIVES:

10 DB2 Systems, 200000 Tables: Too much for 1 DBA?

Moving target for COPY,MODIFY,RUNSTATS,REORG,Space

New DBA-Functions: RTS,Listdef,DynAlloc,Templates

Use DB2 History Tables to store compression rates

SQL script generates all jobs for your DB2 Systems



Click Here to Download

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