Collector agent parameters

The collector agent parameters are described in this section.

APPLIANCE_CONNECT_RETRY_COUNT
Use APPLIANCE_CONNECT_RETRY_COUNT to specify the number of consecutive failed connection attempts before terminating.
APPLIANCE_NETWORK_REQUEST_TIMEOUT
Use APPLIANCE_NETWORK_REQUEST_TIMEOUT to specify the period of time to wait for a network send or receive request to complete.
APPLIANCE_PING_RATE
You can ping the Guardium appliance system to prevent timeouts and disconnects during idle times. Do not change the value of this keyword unless directed by IBM Support.
APPLIANCE_PORT
APPLIANCE_PORT sets the port that Guardium appliance listens to the S-TAP and is dedicated to the IP address of the appliance.
APPLIANCE_RETRY_INTERVAL
APPLIANCE_RETRY_INTERVAL specifies the time between attempts to connect to Guardium appliance system.
APPLIANCE_SERVER
APPLIANCE_SERVER specifies the address of the Guardium appliance system you want to connect to. Use this keyword to enable collection of audit data and a connection to the Guardium appliance system.
APPLIANCE_SERVER_LIST
Use APPLIANCE_SERVER_LIST to determine streaming behavior when multiple appliances are defined.
AUDIT
Specify a Db2 subsystem ID for the Db2 subsystem you want to capture query data on.
AUTHID
Specify a Db2 user name Db2 uses to establish a connection to Db2 during interval processing.
CICS_USERID
Use CICS_USERID to enable capture of CICS Login User ID for SQL statements run in Db2 for CICS.
COLLECT_COMMIT_ROLLBACK
COLLECT_COMMIT_ROLLBACK enables collection of COMMIT and ROLLBACK events.
DEBUG
Enable DEBUG to produce diagnostic messages that help troubleshoot issues.
FORCE
The FORCE parameter forces installation of a monitoring agent.
FORCE_LOG_LIMITED
FORCE_LOG_LIMITED enables you to force limited audit logging by removing sensitive information from data sent to the Guardium appliance by the S-TAP.
HOSTVAR_LIMIT
HOSTVAR_LIMIT sets the number of storage blocks to allocate for host variable collection per event.
ISM_CONSTRAINT_AGE
ISM_CONSTRAINT_AGE determines when a constraint occurrence is considered relieved.
ISM_ERROR_BLOCKS
Set ISM_ERROR_BLOCKS to determine the number of ISM Error Blocks allocated when Db2 initializes.
ISM_ERROR_DETAIL
ISM_ERROR_DETAIL controls whether messages ADHQ1203I and ADHQ1204I are issued to provide detailed information for ISM Storage Constraint situations.
ISM_ERROR_MSG_BLOCKS
ISM_ERROR_MSG_BLOCKS determines the number of ISM Error Message Blocks allocated when Db2 initializes.
MASTER_PROCNAME
MASTER_PROCNAME enables you to specify the PROCNAME to be used for the Primary Address Space.
MAXIMUM_ALLOCATIONS
Use MAXIMUM_ALLOCATIONS to specify the maximum amount of global shared memory that Db2 allocates for internal Integrated Storage Manager spaces.
MESSAGE_LOG_LEVEL
Use MESSAGE_LOG_LEVEL to specify the severity of error messages you want to log for.
OUTAGE_SPILLAREA_SIZE
OUTAGE_SPILLAREA_SIZE sets the size of the spill file to use in the event of a Guardium system connection outage.
PREFER_IPV4_STACK
You can use PREFER_IPV4_STACK to return an IPV4 address of the host name used to connect to the Guardium appliance.
SEND_FAIL_EVENT_COUNT
SEND_FAIL_EVENT_COUNT sets the maximum number of events to buffer during a communication outage with the Guardium system.
SHUTDOWN_DIAGNOSTICS
Use SHUTDOWN_DIAGNOSTICS to produce diagnostic information.
SMEM_SIZE
Use SMEM_SIZE to specify the maximum amount of global shared memory to allocate by IBM Security Guardium S-TAP for Db2 for all purposes.
STAP_BLOCKING
The STAP_BLOCKING parameter controls whether blocking is enabled and whether the blocking operator command is permitted to enable, disable, or report status for blocking.
STAP_MEGABUFFER
STAP_MEGABUFFER improves the efficiency of communications with the appliance.
STAP_STREAM_EVENTS
STAP_STREAM_EVENTS determines whether events are streamed to the Guardium appliance.
STAP_STREAM_GTT_EVENTS
STAP_STREAM_GTT_EVENTS controls the collection of global temporary table events.
STAP_TERMINATE_OPTIMIZE
You can use STAP_TERMINATE_OPTIMIZE to improve response time for processing STAP_TERMINATE requests from the Guardium appliance.
STAP_UTILITY_MULTITABLE
The STAP_UTILITY_MULTITABLE parameter works in conjunction with the STAP_UTILITY_TS_TO_TABLE parameter to control how table information is reported.
STAP_UTILITY_TS_TO_TABLE
The STAP_UTILITY_TS_TO_TABLE parameter works in conjunction with the STAP_UTILITY_MULTITABLE parameter to control how table information is reported for Db2 Utility accesses to tablespaces.
STARTUP_DIAGNOSTICS
STARTUP_DIAGNOSTICS causes IBM Security Guardium S-TAP for Db2 to produce diagnostic information output during startup of the collector agent.
SUBSYS
SUBSYS defines the SQL Collector subsystem name.
TS_OFFSET
Use TS_OFFSET to adjust the event timestamps streamed to the appliance.
ZIIP_FILTER
Enabling ZIIP_FILTER allows the collector agent to perform offload profile filtering to an IBM System z Integrated Information Processor (zIIP).
ZIIP_TCP
ZIIP_TCP enables the z/OS® image running the collector agent started task to have an IBM System z® Integrated Information Processor (zIIP).
/f cqmstc,ISMERROR_DETAIL
This parameter controls whether ISM constraint message detail is on or off.

Parent topic: Reference information