Db2 Tools

  • 1.  Monitoring of DB2 Data Sets ext and extents

    Posted May 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

    Community Manager
    Posted May 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

    Broadcom Employee
    Posted May 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

    Broadcom Employee
    Posted May 23, 2019 07:23 AM

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