Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2008
    Posts
    45

    Unanswered: Monitoring DMS tablespaces

    Hi friends,

    I want to write a script to monitor DMS tablespaces..So just looking the used space and available space daily, how and when can we decide to extend or resize any container..Are there any thumb rules for that like 90% of usage??

    And if i want to add or extend a container i think it would be better if i do that during nights as rebalance would run and which would cause performance problems.

    Is a tablespace accessible during rebalance??If so what kind of performance impact does that have??

    Other than monitoring used space are there any other checks that i need to do for DMS??

    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Did you already look at the DB2 health monitor? It pretty much already does what you want, so you wouldn't have to reinvent the wheel.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Dec 2007
    Posts
    30
    if you resize/extend the containers there will not be any rebalancing.if you add any new containers then there would be rebalencing process.
    Adding containers to a table space and any potential rebalance operation is an online, asynchronous operation, but it will impact the overall performance of the server.

  4. #4
    Join Date
    Apr 2008
    Posts
    51
    If we are talking about DMS file, why not use AUTORESIZE and forget about monitoring - let tablespaces grow almost like SMS. All you have to monitor then is free space in filesystems, which you are probably doing now anyway.
    db2topgun.com

  5. #5
    Join Date
    Mar 2008
    Posts
    136
    go through by this link....will be helpfull...

    http://www.dbatodba.com/db2/how-to-d...ablespace/view

  6. #6
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by dareman123
    if you resize/extend the containers there will not be any rebalancing.
    This is true if you resize/extend all the containers in a tablespace in the same SQL statement. This is easy to do using the ALL keyword.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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