Skip to Content
avatar image
Former Member

dbspace_usage event

Hi Folks,

We have a multiplex environment.

Have created dbspace_usage event in coordinator node to trace MAIN and TEMP dbspace usage.

Now i want to create an event to trace Secondary(reader) node TEMP dbspace usage. Here write is not allowed as the node is reader. So i am not able to create an event here.

Please let me know any related way to trace TEMP usage in reader node.

Regards,

Santosh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 13, 2015 at 02:41 PM

    Hi Santosh,

    You can create it in coordinator with some extra criteria in the event code. It will be visible in all nodes.

    From Events

    "In a multiplex, an event is a global object that is shared across all nodes participating in the multiplex"

    For example, inside the Event code, you can add criteria on server name (select @@servername), so it will be executed on the node you need to be monitored.

    Regards,

    Tayeb.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 14, 2015 at 07:49 PM

    To add to what Tayeb have.

    You can also use the role to code your event.

    select role from SYSIQMPXSERVER where server_name = @@servername

    role

    0 - coordinator

    1 - writer

    2 - reader

    Add comment
    10|10000 characters needed characters exceeded