Defining the scope of autonomic statistics monitoring

You can specify tables to include and exclude from autonomic statistics monitoring.

About this task

Begin program-specific programming interface information.

You might want to exclude tables from autonomic monitoring for certain special situations, such as those that require you to maintain or manipulate statistics manually, or for particularly large tables.

Procedure

To define the scope of autonomic monitoring:

Specify the restrict-ts option when you schedule calls to the ADMIN_UTL_MONITOR stored procedure in the administrative scheduler.

The restrict-ts option allows any string that contains valid content for a WHERE clause on the SYSIBM.SYSTABLESPACESTATS catalog table.

For example, you might specify the following predicates for the restrict-ts option:

To check only the Db2 catalog:
```
DBNAME='DSNDB06'
```
To check all table spaces, except for the Db2 catalog:
```
DBNAME<>'DSNDB06'
```
To check all tables spaces that have names that begin with 'A':
```
NAME LIKE ‘A%'
```

To check all table spaces that were created by SYSIBM:

(DBNAME,NAME) in (SELECT DBNAME,TSNAME
FROM SYSIBM.SYSTABLES WHERE
CREATOR='SYSIBM')

Only tables spaces that meet the criteria of the predicates that are defined in the restrict-ts option are checked by autonomic statistics. When the restrict-ts option is not specified, all table spaces are checked by autonomic statistics. End program-specific programming interface information.

End program-specific programming interface information.