Event monitor creation in Control Center

[Jean-Marc Blaise]

Dear all,

The Control Center (V8.1 FP4 / Windows), gives as output options :

<evmGroup>
( [(TABLE <tableName>,]
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (elem1, elem2, ..)]
), ....

I would like to make a suggestion to make it more attractive by
incorporating the result of the db2evtbl command.

Let say I selected statements, so I would get some kind of:

STATEMENTS
WRITE TO TABLE
CONNHEADER (TABLE CONNHEADER_TRAP SQL,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (AGENT_ID,
APPL_ID,
APPL_NAME,
AUTH_ID,
CLIENT_DB_ALIAS ,
CLIENT_NNAME,
CLIENT_PID,
CLIENT_PLATFORM ,
CLIENT_PRDID,
CLIENT_PROTOCOL ,
CODEPAGE_ID,
CONN_TIME,
CORR_TOKEN,
EXECUTION_ID,
SEQUENCE_NO,
TERRITORY_CODE )),
STMT (TABLE STMT_TRAPSQL,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (AGENT_ID,
AGENTS_TOP,
APPL_ID,
BLOCKING_CURSOR ,
CONSISTENCY_TOK EN,
..../... CREATOR,
CONTROL (TABLE CONTROL_TRAPSQL ,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (EVENT_MONITOR_ NAME,
MESSAGE,
MESSAGE_TIME ));

Is something like this planned to make this output option more friendly ?
Besides, I've noticed you cannot choose FILE as output, only TABLES.

Thanks for your reply,

Jean-Marc

[Blair Adamache]

Thanks for the input - I'll let the appropriate development mgr know.

Jean-Marc Blaise wrote:

Dear all,

The Control Center (V8.1 FP4 / Windows), gives as output options :

<evmGroup>
( [(TABLE <tableName>,]
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (elem1, elem2, ..)]
), ....

I would like to make a suggestion to make it more attractive by
incorporating the result of the db2evtbl command.

Let say I selected statements, so I would get some kind of:

STATEMENTS
WRITE TO TABLE
CONNHEADER (TABLE CONNHEADER_TRAP SQL,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (AGENT_ID,
APPL_ID,
APPL_NAME,
AUTH_ID,
CLIENT_DB_ALIAS ,
CLIENT_NNAME,
CLIENT_PID,
CLIENT_PLATFORM ,
CLIENT_PRDID,
CLIENT_PROTOCOL ,
CODEPAGE_ID,
CONN_TIME,
CORR_TOKEN,
EXECUTION_ID,
SEQUENCE_NO,
TERRITORY_CODE )),
STMT (TABLE STMT_TRAPSQL,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (AGENT_ID,
AGENTS_TOP,
APPL_ID,
BLOCKING_CURSOR ,
CONSISTENCY_TOK EN,
.../... CREATOR,
CONTROL (TABLE CONTROL_TRAPSQL ,
[IN <tablespaceName >,]
[PCTDEACTIVATE <integer>,]
[TRUNC]
[INCLUDES|EXCLUD ES (EVENT_MONITOR_ NAME,
MESSAGE,
MESSAGE_TIME ));

Is something like this planned to make this output option more friendly ?
Besides, I've noticed you cannot choose FILE as output, only TABLES.

Thanks for your reply,

Jean-Marc

[Fred]

Thanks for taking care of that, Blair. I'd also like to know if IBM
could put the ability to specify event monitor predicates back into
Control Center. As it stands now, Control Center only offers the
ability to run event monitors that write to local tables with no
predicates to limit verbosity, which is simply too expensive for me to
run on my production server.

Thanks,

Fred