Question regarding database pages in TSM 6.2.2.3

[preet.pawan]

Hi All,

I have a question regarding the database pages in TSM, free pages are showing as 4520 but the database free size is ok.This doesnt look ok to me

Database Name: TSMDB1
Total Size of File System (MB): 384,000
Space Used by Database(MB): 273,040
Free Space Available (MB): 109,298
Total Pages: 14,857,799
Usable Pages: 14,856,983
Used Pages: 14,852,463
Free Pages: 4,520
Buffer Pool Hit Ratio: 97.7
Total Buffer Requests: 1,092,674,174
Sort Overflows: 0
Package Cache Hit Ratio: 99.7
Last Database Reorganization:
Full Device Class Name: LTO4
Incrementals Since Last Full: 0
Last Complete Backup Date/Time: 27/10/11 13:00:12

Kindly let me know if you need any more output.

 

[chad_small]

It's OK because DB2 handles DB expansion differently than the old TSM DB did. With the old DB you had to have fixed DB volumes and space was allocated within those volumes which also fixed the number of DB pages you had available. As DB2 identifies that more DB space is required it will allocate more within the filesystem and thereby create more free pages. DB2 does it dynamically so you only need to worry about the filespace that is available.