Ladies and Gents,  evidently I'm not getting something about these
stats.

 

"                 Database Name: TSMDB1

Total Size of File System (MB): 161,792

    Space Used by Database(MB): 100,032

     Free Space Available (MB): 61,221

                   Total Pages: 5,866,500

                  Usable Pages: 5,866,364

                    Used Pages: 5,745,180

                    Free Pages: 121,152

         Buffer Pool Hit Ratio: 98.5

         Total Buffer Requests: 1,112,407

                Sort Overflows: 0

       Package Cache Hit Ratio: 99.7

  Last Database Reorganization: 

        Full Device Class Name: LTO4-ENC

  Incrementals Since Last Full: 0

Last Complete Backup Date/Time: 06/29/2011 11:30:20

"

 

It looks like I have 60 GB free, and I'm doing pretty well.  However, it
was showing 20 GB free this morning, and at about noon it died saying it
was out of space.  So, I'm wondering if the DB will actually use the
full size of the file system, or do I need to run a command that will
tell it how big the file space is?  My understanding is that when the
Free pages get low, TSM / DB2 will automatically grow the db until the
filespace fills up.  However, I had 20+ GB Free in the file system
earlier today.  

 

 

See Ya'

Howard Coles Jr.

John 3:16!