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
Good morning. I've moved this question to the right community: CA Database Management for Db2 and IMS
Please visit the following Sysview for DB2 r19 documentation link for information concerning Database Exceptions:
or for r20:
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.
I am contacting Francisco to be sure if he has more questions around this topic.