[ADSM-L] DB Usage spike after turning on ALLOWTABLEREORG

6.1.5.10 server. Back when there were issues with log usage due to table
reorgs, I like many folks turned off ALLOWTABLEREORG.

Recently, I did some big purging (moved a node with 189M objects to
another server).  Since the DB has grown to over 200G, I decided to
reactivate ALLOWTABLEREORG this morning.  Also increased the activelog to
120GB.

I just got an alert from my monitoring program that the DB has grown to
90% used. "Q DB" shows very few free pages.

10:14:40 AM   WIND : q db f=d
                 Database Name: TSMDB1
Total Size of File System (MB): 399,747
    Space Used by Database(MB): 208,416
     Free Space Available (MB): 43,158
                   Total Pages: 10,955,875
                  Usable Pages: 10,955,739
                    Used Pages: 10,948,407
                    Free Pages: 5,348
         Buffer Pool Hit Ratio: 95.2
         Total Buffer Requests: 360,268
                Sort Overflows: 0
       Package Cache Hit Ratio: 96.8
  Last Database Reorganization:
        Full Device Class Name: TS1130
  Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 09/15/2011 22:00:16

Is this normal/due to turning on reorg?  Will this settle down after it
gets through going the reorg?


Zoltan Forray
TSM Software & Hardware Administrator
Virginia Commonwealth University
UCC/Office of Technology Services
zforray AT vcu DOT edu - 804-828-4807
Don't be a phishing victim - VCU and other reputable organizations will
never use email to request that you reply with your password, social
security number or confidential personal information. For more details
visit http://infosecurity.vcu.edu/phishing.html