Edit C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\odbc\7.0.1\help\troubleshooting\diagnostic.3.2.html
<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html;charset=utf-8" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <!-- MOTW-DISABLED saved from url=(0014)about:internet --> <title>ODBC Trace</title> <link rel="StyleSheet" href="css/diagnostic.css" type="text/css" media="all" /> <link rel="StyleSheet" href="css/webworks.css" type="text/css" media="all" /> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/context.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/towwhdir.js"></script> <script type="text/javascript" language="JavaScript1.2" src="wwhdata/common/wwhpagef.js"></script> <script type="text/javascript" language="JavaScript1.2"> <!-- var WebWorksRootPath = ""; // --> </script> <script type="text/javascript" language="JavaScript1.2"> <!-- // Set reference to top level help frame // var WWHFrame = WWHGetWWHFrame("", true); // --> </script> <script type="text/javascript" language="JavaScript1.2" src="scripts/expand.js"></script> </head> <body class="" style="background-color: #FFFFEE;" onload="WWHUpdate();" onunload="WWHUnload();" onkeydown="WWHHandleKeyDown((document.all||document.getElementById||document.layers)?event:null);" onkeypress="WWHHandleKeyPress((document.all||document.getElementById||document.layers)?event:null);" onkeyup="WWHHandleKeyUp((document.all||document.getElementById||document.layers)?event:null);"> <br /> <div class="WebWorks_Breadcrumbs" style="text-align: left;"> <a class="WebWorks_Breadcrumb_Link" href="diagnostic.3.1.html#106157">1 Diagnostic Tools</a> : ODBC Trace</div> <hr align="left" /> <blockquote> <div class="head_1"><a name="106157">ODBC Trace</a></div> <div class="Body"><a name="106158">ODBC tracing allows you to trace calls to ODBC drivers and create a log of the traces. </a>Creating a trace log is particularly useful when you are troubleshooting an issue. </div> <div class="hanging_label_head"><a name="106159">To create a trace log:</a></div> <div class="list_procedure_first_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_first_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">1 </span> </div> </td> <td width="100%"> <div class="list_procedure_first_inner"><a name="106163">Enable tracing (see </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.2.html#110629', '');">â??Enabling Tracingâ??</a></span> for more information). </div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">2 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106164">Start the ODBC application and reproduce the issue.</a></div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">3 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106165">Stop the application and turn off tracing. </a></div> </td> </tr> </table> </div> <div class="list_procedure_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_procedure_inner" style="width: 18pt; white-space: nowrap;"> <span class="Numbers">4 </span> </div> </td> <td width="100%"> <div class="list_procedure_inner"><a name="106166">Open the log file in a text editor and review the output to help you debug the problem.</a></div> </td> </tr> </table> </div> <div class="Body"><a name="114125">For a complete explanation of tracing, refer to the following Progress DataDirect </a>Knowledgebase document:</div> <div class="Body"><span class="Cross_ref_"><a href="http://progresscustomersupport-survey.force.com/ConnectKB/articles/Article/3049?retURL=%2Fapex%2FKnowledgeSearch&popup=false" target="external_window" name="114127">http://progresscustomersupport-survey.force.com/ConnectKB/articles/Article/3049?retURL=%2Fapex%2FKnowledgeSearch&popup=false</a></span> </div> <div class="head_2"><a name="110629">Enabling Tracing</a></div> <div class="Body"><a name="114644">Progress DataDirect provides a tracing library that is enhanced to operate more efficiently, </a>especially in production environments, where log files can rapidly grow in size. The DataDirect tracing library allows you to control the size and number of log files. </div> <div class="Body"><a name="114915">On Windows, you can enable tracing through the Tracing tab of the ODBC Data Source </a>Administrator. </div> <div class="Body"><a name="115754">On UNIX and Linux, you can enable tracing by directly modifying the [ODBC] section in the </a>system information (odbc.ini) file. On Linux, you can also enable tracing through the Trace tab of the DataDirect ODBC Data Source Administrator for Linux.</div> <div class="head_3"><a name="114993">Windows ODBC Administrator</a></div> <div class="Body"><a name="115003">the ODBC Data Source Administrator and the Tracing tab. To specify the path and name of </a>the trace log file, type the path and name in the Log File Path field or click <span class="Action_bold">Browse</span> to select a log file. If no location is specified, the trace log resides in the working directory of the application you are using.</div> <div class="Body"><a name="106178">Click </a><span class="Action_bold">Select DLL</span> in the Custom Trace DLL pane to select the DataDirect enhanced tracing library, <span class="Emphasis">xx</span>trc<span class="Emphasis">yy</span>.dll, where <span class="Emphasis">xx</span> represents either iv (32-bit version) or dd (64-bit version), and <span class="Emphasis">yy</span> represents the driver level number, for example, ivtrc26.dll. The library is installed in the \Windows\System32 directory. </div> <div class="Body"><a name="106179">After making changes on the Tracing tab, click </a><span class="Action_bold">Apply</span> for them to take effect.</div> <div class="Body"><a name="115136">Enable tracing by clicking </a><span class="Action_bold">Start Tracing Now</span>. Tracing continues until you disable it by clicking <span class="Action_bold">Stop Tracing Now</span>. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application.</div> <div class="Body"><a name="115544">When tracing is enabled, information is written to the following trace log files: </a></div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="115545">Trace log file (</a><span class="EquationVariables">trace_filename</span>.log) in the specified directory.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="115546">Trace information log file (</a><span class="EquationVariables">trace_filename</span>INFO.log). This file is created in the same directory as the trace log file and logs the following SQLGetInfo information: </div> </td> </tr> </table> </div> <div class="list_embedded_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_inner"><a name="115547">SQL_DBMS_NAME</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="115548">SQL_DBMS_VER</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="115549">SQL_DRIVER_NAME</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="115550">SQL_DRIVER_VER</a></div> </td> </tr> </table> </div> <div class="list_embedded_single_outer" style="margin-left: 18pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_embedded_single_inner" style="width: 18pt; white-space: nowrap;">â??</div> </td> <td width="100%"> <div class="list_embedded_single_inner"><a name="115551">SQL_DEFAULT_TXN_ISOLATION</a></div> </td> </tr> </table> </div> <div class="Body"><a name="110124">The DataDirect enhanced tracing library allows you to control the size and number of log </a>files. The file size limit of the log file (in KB) is specified by the Windows Registry key ODBCTraceMaxFileSize. Once the size limit is reached, a new log file is created and logging continues in the new file until it reaches its file size limit, after which another log file is created, and so on. </div> <div class="Body"><a name="111018">The maximum number of files that can be created is specified by the Registry key </a>ODBCTraceMaxNumFiles. Once the maximum number of log files is created, tracing reopens the first file in the sequence, deletes the content, and continues logging in that file until the file size limit is reached, after which it repeats the process with the next file in the sequence. Subsequent files are named by appending sequential numbers, starting at 1 and incrementing by 1, to the end of the original file name, for example, SQL1.LOG, SQL2.LOG, and so on.</div> <div class="Body"><a name="110089">The default values of ODBCTraceMaxFileSize and ODBCTraceMaxNumFiles are </a>102400 KB and 10, respectively. To change these values, add or modify the keys in the following Windows Registry section:</div> <div class="Body"><a name="117036">[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\ODBC]</a></div> <div class="Body"><a name="110050">WARNING: Do not edit the Registry unless you are an experienced user. Consult your </a>system administrator if you have not edited the Registry before.</div> <div class="Body"><a name="115665">Edit each key using your values and close the Registry.</a></div> <div class="head_3"><a name="115666">Linux ODBC Administrator</a></div> <div class="Body"><a name="115675">On Linux, you can enable tracing either through the Trace tab of the DataDirect ODBC Data </a>Source Administrator for Linux (the Linux ODBC Administrator) or by directly modifying the [ODBC] section in the system information (odbc.ini) file.</div> <div class="Body"><a name="120506">To specify the path and name of the trace log file, type the path and name in the Trace File </a>field or click <span class="Action_bold">Browse</span> to select a log file. If no location is specified, the trace log resides in the working directory of the application you are using.</div> <div class="Body"><a name="120507">DataDirect ships an enhanced library to perform tracing. This library appears by default in </a>the Trace Library field. If you want to use a custom library instead, type the path and name of the library in the Trace Library field or click <span class="Action_bold">Browse</span> to select a library. </div> <div class="Body"><a name="120508">To enable tracing, select the </a><span class="Action_bold">Enable Tracing</span> check box on the Trace tab of the Administrator. Clear the check box to disable tracing. Tracing continues until you disable it. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application. </div> <div class="Body"><a name="120509">After making changes on the Trace tab, click </a><span class="Action_bold">Apply</span> for them to take effect.</div> <div class="Body"><a name="114358">The DataDirect enhanced tracing library gives you more control over tracing. See </a><span class="Cross_ref_"><a href="javascript:WWHClickedPopup('troubleshooting', 'diagnostic.3.2.html#115702', '');">â??System Information (odbc.ini) Fileâ??</a></span> for a complete discussion of how to configure enhanced tracing.</div> <div class="head_3"><a name="115702">System Information (odbc.ini) File</a></div> <div class="Body"><a name="115711">The [ODBC] section of the system information file includes several keywords that control </a>tracing:</div> <div class="syntax_first"><a name="109016">Trace=[0 | 1]</a></div> <div class="syntax"><a name="109017">TraceFile=</a><span class="EquationVariables">trace_filename</span></div> <div class="syntax"><a name="109018">TraceDll=ODBCHOME/lib/</a><span class="EquationVariables">xx</span>trc<span class="EquationVariables">yy.zz</span></div> <div class="syntax"><a name="109020">ODBCTraceMaxFileSize=</a><span class="EquationVariables">file_size</span></div> <div class="syntax"><a name="109021">ODBCTraceMaxNumFiles=</a><span class="EquationVariables">file_number</span> </div> <div class="syntax"><a name="117089">TraceOptions=0</a></div> <div class="Body"><a name="109683">Where:</a></div> <div class="Body"><span class="Syntax"><a name="109128">Trace=[0</a></span> | <span class="Syntax">1]</span>â??Allows you to enable tracing by setting the value of Trace to 1. Disable tracing by setting the value to 0 (the default). Tracing continues until you disable it. Be sure to turn off tracing when you are finished reproducing the issue because tracing decreases the performance of your ODBC application.</div> <div class="Body"><span class="Syntax"><a name="109129">TraceFile=</a></span><span class="EquationVariables">trace_filename</span>â??Specifies the path and name of the trace log file. If no path is specified, the trace log resides in the working directory of the application you are using.</div> <div class="Body"><span class="Syntax"><a name="108959">TraceDll=ODBCHOME/lib/</a></span><span class="EquationVariables">xx</span><span class="Syntax">trc</span><span class="EquationVariables">yy.zz</span> â??Specifies the library to use for tracing. The driver installation includes a DataDirect enhanced library to perform tracing, <span class="EquationVariables">xx</span><span class="Syntax">trc</span><span class="EquationVariables">yy.zz</span>, where <span class="EquationVariables">xx</span> represents either iv (32-bit version) or dd (64-bit version), <span class="EquationVariables">yy</span> represents the driver level number, and <span class="EquationVariables">zz</span> represents either so or sl. For example, ivtrc26.so is the 32-bit version of the library. To use a custom shared library instead, enter the path and name of the library as the value for the TraceDll keyword.</div> <div class="Body"><a name="115976">The DataDirect enhanced tracing library allows you to control the size and number of log </a>files with the ODBCTraceMaxFileSize and ODBCTraceMaxNumFiles keywords. </div> <div class="Body"><span class="Syntax"><a name="116254">ODBCTraceMaxFileSize=</a></span><span class="EquationVariables">file_size</span>. The ODBCTraceMaxFileSize keyword specifies the file size limit (in KB) of the log file. Once this file size limit is reached, a new log file is created and logging continues in the new file until it reaches the file size limit, after which another log file is created, and so on. The default is 102400. </div> <div class="Body"><span class="Syntax"><a name="116255">ODBCTraceMaxNumFiles=</a></span><span class="EquationVariables">file_number</span>. The ODBCTraceMaxNumFiles keyword specifies the maximum number of log files that can be created. The default is 10. Once the maximum number of log files is created, tracing reopens the first file in the sequence, deletes the content, and continues logging in that file until the file size limit is reached, after which it repeats the process with the next file in the sequence. Subsequent files are named by appending sequential numbers, starting at 1 and incrementing by 1, to the end of the original file name, for example, odbctrace1.out, odbctrace2.out, and so on.</div> <div class="Body"><span class="Syntax"><a name="116419">TraceOptions=[0</a></span> | <span class="Syntax">1 |2 | 3]</span>. The ODBCTraceMaxNumFiles keyword specifies whether to print the current timestamp, parent process id, process id, and thread id for all ODBC functions to the output file. The default is 0.</div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="116687">If set to 0, the driver uses standard ODBC tracing.</a></div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="116688">If set to 1, the log file includes a timestamp on ENTRY and EXIT of each ODBC </a>function.</div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="116689">If set to 2, the log file prints a header on every line. By default, the header includes the </a>parent process ID and process ID. </div> </td> </tr> </table> </div> <div class="list_bulleted_outer" style="margin-left: 0pt;"> <table border="0" cellspacing="0" cellpadding="0" summary=""> <tr style="vertical-align: baseline;"> <td> <div class="list_bulleted_inner" style="width: 18pt; white-space: nowrap;">â? </div> </td> <td width="100%"> <div class="list_bulleted_inner"><a name="116690">If set to 3, both TraceOptions=1 and TraceOptions=2 are enabled. The header includes </a>a timestamp as well as a parent process ID and process ID. </div> </td> </tr> </table> </div> <div class="hanging_label_head"><a name="109102">Example</a></div> <div class="Body"><a name="109107">In the following example of trace settings, tracing has been enabled, the name of the log file </a>is odbctrace.out, the library for tracing is ivtrc26.so, the maximum size of the log file is 51200 KB, and the maximum number of log files is 8. Timestamp and other information is included in odbctrace.out.</div> <div class="syntax_first"><a name="109203">Trace=1</a></div> <div class="syntax"><a name="109204">TraceFile=ODBCHOME/lib/odbctrace.out</a></div> <div class="syntax"><a name="110424">TraceDll=ODBCHOME/lib/ivtrc26.so</a></div> <div class="syntax"><a name="110425">ODBCTraceMaxFileSize=51200</a></div> <div class="syntax"><a name="116592">ODBCTraceMaxNumFiles=8</a></div> <div class="syntax"><a name="116570">TraceOptions=3</a></div> <script type="text/javascript" language="JavaScript1.2"> <!-- // Clear related topics // WWHClearRelatedTopics(); document.writeln(WWHRelatedTopicsInlineHTML()); // --> </script> </blockquote> <script type="text/javascript" language="JavaScript1.2"> <!-- document.write(WWHRelatedTopicsDivTag() + WWHPopupDivTag() + WWHALinksDivTag()); // --> </script> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de