Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: Total, Usable, Used

    Hallo everyone,

    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.

    My question:
    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.

    Thank you very much for the helps.



  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    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-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts