Hi All, Can anyone help me which DB2's system table keeps the inforamation about tablespace container's for example number of used pages, number of free pages, usable pages etc.
thanks
sunny

That information is not kept in the system catalog tables (except for some stale statistics that are only updated after a runstats). You can do a tablespace snapshot to get the information.

SYSIBM.SYSTABLEPART
(at least, on z/OS)

Since he mentioned containers, he was talking about DB2 or LUW. In any event, that catalog stats are only updated after a runstats or stospace utility (for z/OS), depending on the number being looking at.

Keeping such statistics current in the catalog is not a good idea in the first place. The reason being that each write operation on a container that causes changes to those statistics would trigger an update to the catalog. And catalog updates must be locked. So besides requiring 2 writes instead of just 1, it also impacts concurrency in a negative way. Therefore, the mentioned statistics are only snapshot information of the point in time when RUNSTATS was executed the last time.

What about runtime statistics (RTS) ?

Same thing. So if you have a system where you really need to squeeze out the last fraction of a percent for performance, you will typically turn off RTS.

DB2 can try to do things in a smarter way like maintaining deltas of changes on the per-table level and then writing those changes only once.

The same could be done on a container-level. However, the need for current statistics on a container-level is much, much less. Today, you usually use automatic storage and don't care about container-stats anyway. RTS on the other hand is used for a lot of different things now, and the usage will expand over time.