tag:blogger.com,1999:blog-18371456.post3944136465708570668..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: MODIFY RECOVERY [DB2 9 for z/OS]Craig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-18371456.post-33581269923452854722009-01-06T17:40:00.000-06:002009-01-06T17:40:00.000-06:00Craig, Suppose a db created in 1993 has been reg...Craig,<BR/> Suppose a db created in 1993 has been regularly dropping a table so often the dbd size is 8 million. will modify recovery reduce the dbd size? is a reorg necessary ? it will eliminate the -497 abend but is the large dbd size a detriment to concurrency and performance or do we really just care that that the syslgrnx and syscopy entries are cleared out? Is there an upper threshold limit as to what a DBD can be? My recommendation was to dop the db and start from scratch also emlinating the need for contiguous space when a dbd is loaded in.<BR/>Thanks,<BR/>GerryAnonymousnoreply@blogger.com