Unanswered: Using LISTDEF to do online REORG on tables and indexes
Hi Everyone, I have a question concerning using LISTDEF REORG on my tables and indexes.
My database is a 24/7 and I have to use Online REORG on my tables and indexes. Would using LISTDEF REORG do the job? If yes, would someone supply a simple example of what I could use to run an Online reorg using listdef for my tables and indexes. I also would like to do a runstats after the reorg is done, is it possible to run on the same job?
Also, if someone could point me to a good place on the internet that would give me good documentation on listdef and reorg that would be great.
Also, my database is running on DB2 v7.2 on a S/390 and Z/OS.
If you require any further information to answer my question, just let me know.
Here is a little example for an Online Reorg using Listdef and Templates:
VOLCNT (99) UNIT 3490 STACK YES
INCLUDE TABLESPACE LVDB0300.LVTSS300
INCLUDE TABLESPACE LVDB0300.LVTSP371
REORG TABLESPACE LIST TESTLIST
MAXRO 120 DRAIN ALL LONGLOG TERM DELAY 1200
STATISTICS TABLE ALL UPDATE ALL
Besides the exact syntax is in DB2 Utlities Guide and Reference (unfortunately I do not have the homepage at hand)
Yes, my database has one tablespace and 32 tables.
I want to use LISTDEF since I don't want to keep chaging the JCL in the future to add new tables to it. I know by fact that in the next year or so I will be adding 10 more tables. So LISTDEF is a good solution to just put my JCL into the scheduled runs and don't have to change it.
Anyway, the template was necessary and the creatino of the mappingtable was necessary. I just made a couple of changes to the example Walter Janissen gave me and it ran flawlessly.