Db2 Tools

Expand all | Collapse all

Monitoring of DB2 Data Sets ext and extents

Jump to Best Answer
  • 1.  Monitoring of DB2 Data Sets ext and extents

    Posted 05-16-2019 09:39 AM

    Through the CA SYSVIEW FOR DB2 tool, we are trying to implement a monitoring of the DB2 Data Sets ext and extents. We need to check the amount of extents and extents of DB2 TableSpaces datasets and generate an alert.

     

    The following example, where SELECT is returning Tablespaces with more than 27 DataSets, where the maximum is 31 for these Tablespaces.

     

    select DBNAME, TSNAME, DSNUM, EXTENTS ,STATSTIME from SYSIBM.SYSTABLEPART
    where
    TSNAME LIKE 'S%'
    AND
    DSNUM > 27
    order by
    DBNAME, TSNAME
    with ur
    ;

     

    DBNAME   TSNAME   DSNUM EXTENTS STATSTIME

    -------- -------- ----- ------- --------------------------

    DFIN134  S134LOGE    28      21 2019-04-14 16:23:52.809173

    DFIN519  S519LOGB    29      18 2019-04-14 21:28:50.876675



  • 2.  Re: Monitoring of DB2 Data Sets ext and extents

    Posted 05-20-2019 11:13 AM

    Good morning. I've moved this question to the right community: CA Database Management for Db2 and IMS



  • 3.  Re: Monitoring of DB2 Data Sets ext and extents
    Best Answer

    Posted 05-20-2019 03:24 PM

    Hi Francicso, 

    Please visit the following Sysview for DB2 r19 documentation link for information concerning Database Exceptions:

    https://docops.ca.com/ca-sysview-db2/19/en/reference/exceptions/defined-exceptions/database-defined-exceptions

    or for r20: 

    https://docops.ca.com/ca-sysview-db2/20/en/reference/exceptions/defined-exceptions/database-defined-exceptions

    The product comes with a default pre-defined High number of data set extents exception.  I recommend 

    reviewing it within the product under Option 0 Permanent Exception Definitions and then option 2 Database Exceptions.

    If you have further questions or concerns I recommend opening a case with Sysview for DB2 support.



  • 4.  Re: Monitoring of DB2 Data Sets ext and extents

    Posted 05-23-2019 07:23 AM

    I am contacting  Francisco to be sure if he has more questions around this topic.