To Reorg or not to Reorg (is not the question anymore)

Tuesday, 13 June, 2006 - 16:45 - 17:15
Mirna Kos

Problems  concerning  daily  database maintenance are down to big amount of necessary  out-of-working-hours  DBA  time.  Solution  to  this problem is automation  of  maintenance jobs. After automating execution of imagecopies and  runstats jobs, DBA in Zagrebačka banka implemented complete automation of index and tablespace reorganization. Through  numerous  planning and categorization steps we managed to elaborate in  detail  schedule  and  prerequisites  for  a database/table/application reorganization.   We  used  standard  DB2  utility  jobs  and standard z/OS capabilities  to  devise  the  way  the  jobs  are executed, execution time control,  as  well as error and abend control. All solutions with examples, as well as imperfections and shortcomings and potential future enhancements are topic of this presentation.



SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us



Events in 2021

VIRTUAL EVENT - 27th - 28th May 2021