Articles & Content
Topic: 2005 EU
Subtopic: 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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.