IBM Support

How to eliminate XTX messages to be written to Server Trace browse

Troubleshooting


Problem

Some SQL queries produce lots of XTX messages that are written to Server Trace Browse thus causing Trace data set to fill up very fast
Since these messages are usually are of no use, how can they be stopped from being written to Trace Browse

Symptom

All blanks lines are XTX lines associated with "DSNHLI INTERNAL GET DIAGNOSTIC" message

2466807512 13:38:08 002DF240
2466807513 13:38:08 002DF240
2466807514 13:38:08 002DF240
2466807515 13:38:08 002DF240 DSNHLI INTERNAL GET DIAGNOSTICS - DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION - SDBC1010
2466807516 13:38:08 002DF240 GDAR   µøø  ¯ø  ¯hŒ ®¤×   -   \                GDSM   -ø   × ø   ¯
                                  ó0140                                 N    NUMBER=141;ROW_COUNT=0140;MORE=N;
2466807517 13:38:08 002DF240
2466807519 13:38:08 002DF240
2466807520 13:38:08 002DF240
 

Diagnosing The Problem

Once in Server Trace Browse if enter "D EVN" (Stands for Display EVENT) , it will show all these blanks lines are of event type XTX

Resolving The Problem

In order to stop the XTX messages to be written to Server Trace Browse, insert the following line in IN00 and recycle the server:
"MODIFY PARM NAME(TRACESQLDIAGDETAIL)  VALUE(NO)"
This parameter can also be changed dynamically by going to server ispf optin C.2 - PRODTRACE and change the value for TRACE SQL GET DIAGNOSTICS DETAIL to NO

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKRKK","label":"IBM Db2 Analytics Accelerator Loader for z\/OS"},"ARM Category":[{"code":"a8m0z0000001hBeAAI","label":"Db2 Analytics Accelerator Loader for z\/OS"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU016","label":"Multiple Vendor Support"},"Product":{"code":"SGMV22","label":"IBM Support for Apache Spark"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB61","label":"IBM Technology Lifecycle Services"}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4NKG","label":"IBM Data Virtualization Manager for z\/OS"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
23 September 2020

UID

ibm16251911

Page Feedback