IBM Support

How to use Sql Agent Trace Configuration Utility (KoqCtlEditUtility)

Technical Blog Post


Abstract

How to use Sql Agent Trace Configuration Utility (KoqCtlEditUtility)

Body

Having problems manually updating OQ agent configurations. Now SQL Agent Trace Configuration Utility (KoqCtlEditUtility.exe) which can edit koqcoll.ctl and koqtrac.ctl files was introduced to users to easily change any settings for troubleshooting purpose.

 

Increasing collector logs:

Instead of manually increasing collector logs following steps below:

- Enable detailed collector logs:                                       
a. Open the koqtrac.ctl file. The file is located in the following path:
install_dir\tmaitm6, where install_dir is the location of the IBM Tivoli
Monitoring component.                                                   
b. Remove the two semicolons (;;) from the beginning of the line that   
contains trace_all;.                                                    
c. Save the file. 

 

To run the KoqCtlEditUtility.exe utility, complete one of the following steps:

  •         For a 64-bit agent, go to the candle_home\TMAITM6_x64 directory.
  •         For a 32-bit agent, go to the candle_home\TMAITM6 directory.

In koqtrac tab move cursors which you want to trace from right to left side or check Enable all detail logs to enable all with one click:

imageAfter that click Apply button and restart agent so new changes are in effect.

 

Below scrshot show collector log with enabled tracing:

image

Below scrhot show collector logs with no detailed tracing set:

image

Disabling problematic cursors:

Because only two cursors KOQTBLD and KOQDBD can be disabled via MTEMS window or CLI (DBSETTINGS.db_extparms="KOQDBD")

 

image

Use KoqCtlEditUtility.exe utility and navigate to Koqcoll tab to disable other cursors. To disable cursor select cursor on right side and more it to left side. Cursors on left side are disabled cursors.

 

image

After that click Apply button and restart agent so new changes are in effect. When cursor is disabled means that there will be no data collection for this attribute group. Verify on below url which cursor affects which attribute group:

https://www.ibm.com/support/knowledgecenter/SSDKXQ_6.3.0/com.ibm.itcamms.doc_6.3/sql/capacityplan.html

 

 

 

 

Tutorials Point

 

Subscribe and follow us for all the latest information directly on your social feeds:

 

 

image

 

image

 

image

 

 

  

Check out all our other posts and updates:

Academy Blogs: http://ow.ly/Otue0
Academy Videos: http://ow.ly/PIKFz
Academy Google+: http://ow.ly/Dj3nn
Academy Twitter Handle: http://ow.ly/Dj35c


image

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSVJUL","label":"IBM Application Performance Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11277350