Articles & Content
Topic: DB2 for z/OS
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
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.