Linux-UNIX: Inspection engine parameters

These parameters affect the behavior of the inspection engine that the S-TAP uses to monitor a data repository on a DB server.

These parameters are stored in the individual [DB_<name>] inspection engine section of the S-TAP properties file, guard_tap.ini, with the name of a data repository. There can be multiple sections in a properties file, each describing one inspection engine used by this S-TAP.

Parameters used with IBM Db2 databases

The script find_db2_shmem_parameters.sh, located in stap_directory/bin, outputs what the Db2 shared memory parameters defined in the Inspection Engines should be. Execute it either as root or Db2 user, using the syntax: find_db2_shmem_parameters.sh <instance name>. You can run it from any directory.

Table 1. Additional S-TAP configuration parameters for a Db2 inspection engine
GUI	guard_tap.ini	Default value	Description
DB2 Shared Mem. Adjust.	db2_fix_pack_adjustment	20	Required when Db2® is selected as the database type, and shared memory connections are monitored. The offset to the server's portion of the shared memory area. Offset to the beginning of the Db2 shared memory packet, depends on the Db2 version: 32 in pre-8.2.1, and 80 in 8.2.1 and higher.
DB2 Sh. Mem. Client Pos.	db2_shmem_client_position	61440	The offset to the client's portion of the shared memory area. Required when Db2 is selected as the database type, and shared memory connections are monitored. Use the script find_db2_shmem_parameters.sh to find the value. The script is located in stap_directory/bin, and outputs what the Db2 shared memory parameters that are defined in the Inspection Engines should be. Run it either as root or Db2 user, by using the syntax: `find_db2_shmem_parameters.sh <instance name>`. You can run it from any directory.
	db2bp_path	Null	Relevant only when using A-TAP on Db2. If the program 'db2bp' (part of Db2) is in the standard location, db2bp_path does not need to be set. If it is non-standard, then this parameter points to its location. Set this parameter to the full path of the relevant db2bp as seen from the global zone or WPAR. For example, if the file is /data/db2inst1/sqllib/bin/db2bp and the zone is installed in /data/zones/oracle2nd/root/ then set the full path (db2bp_path) as /data/zones/oracle2nd/root/data/db2inst1/sqllib/bin/db2bp
DB2 Shared Mem. Size	db2_shmem_size	131072	Db2 shared memory segment size. Required when Db2 is selected as the database type, and shared memory connections are monitored.