ProfileEventTraceEdit pete

In a client/server configuration, changes an event trace profile for an OpenAccess SDK service.

Syntax

{ProfileEventTraceEdit | pete} service_name {enable | disable | event_group} [{enable | disable} | {event_name | event_id} [{on | off}]] [custom_event_filter]

where:

service_name is the service for which to change an event trace profile. This is a requirement value. Service names can be obtained using the ServiceList | sl command.

event_group is the type of event within the service to change. Valid values are:

• {Service | srvc}
• {Session | sess}
• {Statement | stmt}
• {Transaction | trans}
• {Network | net}
• {Error | err}
• {Other | oth}

event_name is the name of the event within in the specified event group to change. You can use the ProfileEventTraceInfo command to list available event names.

event_id is the numeric identifier of the event within the specified event group to change. You can specify either event_name or event_id, not both. You can use the ProfileEventTraceInfo command to list available event identifiers.

custom_event_filter is an optional event filter that can be specified for all events being enabled. See Filtering Events for more information.

Example

Example A: The following example disables all events for the OpenAccessSDK810_C data access service, meaning that no events are written to the event trace file:

pete OpenAccessSDK810_C disable

Example B: The following example enables the event specified by the custom event filter:

pete OpenAccessSDK810_C Session enable ’${ClientInfo}="127.0.0.1"’

Example C: The following example enables all service events for the OpenAccessSDK810_C data access service:

pete OpenAccessSDK810_C service enable

Example D: The following example disables all error events for the OpenAccessSDK810_C data access service:

pete OpenAccessSDK810_C err disable

Example E: The following example changes the state of the transaction event named Transaction Rollback to off:

pete OpenAccessSDK810_C trans "Transaction Rollback" off

Example F: The following example changes the state of the session event identified by 2 to "on" if the event meets the custom event query filter:

pete OpenAccessSDK810_C sess 2 on ’${DbmsUser} = "scott"’