I havent understand how db2 or dba determines these 3 variables:
I have an example of a table space:
Total (GB) Usable (GB) Used (GB) Free (GB) HighWatermark (GB)
78,34 78,34 15,54 62,80 18,69
If I am not mistake, the high water mark is the "last" size, which data has ever reached to. In this case, we have 18,69 GB as high water mark.
Who decides the total pages/GBs a table space initially gets?
I have found some documentations regarding size of a table space:
"The maximum size of a table space depends on the page size used in that table space". But I think, this has nothing to do with this concrete example.
most info is available here : Automatic re-sizing of DMS table spaces
max size is the max nbr of pages that can be allocated in ts of this page size : see limits in infocenter..
high watermark has todo with location in ts where pages have been allocated (see doc)
all can be adjusted/resized/reset : see also doc depending on version and platform.. (not indicated over here)
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be