Shulou(Shulou.com)05/31 Report--

This article shows you the example analysis of DM tracking log, which is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

DM trace log turns on kernel analysis

1. Enable the trace log SVR _ LOG

SP_SET_PARA_VALUE (1 'SVR_LOG',1)-in the execution of management tools

2. Configure the dmsql.ini file

Vi sqllog.ini at the same level as dm.ini, which needs to be modified as follows

SQL_TRACE_MASK=2:3:21:24:26:27

MIN_EXEC_TIME=500

SWITCH_LIMIT=1440

SWITCH_MODE=3

FILE_PATH=/opt/dmnew/Dmlogcommit-the Dmlogcommit file needs to be created manually. By default, it is in the database installation log file.

3. The path specified by FILE_PATH will generate the dmsql_XXXX.log file. 4. Copy the dmsql_XXXX.log file to the local area for analysis. (my computer win10)

Storage path: d:\ log-make sure there are only trace log files in the Log folder.

5. Copy Dmlog_DM7_6.0.jar to jbk\ bin of the installation database

My path:

(d:\ DM7\ dm7_setup_win64_ent_7.6.0.137_20190218\ source\ jdk\ bin)

6. Initialize an example of storing analysis results

It should be noted that the instance size must be 32K. Other defaults are fine.

The specific operations are as follows:

After the analysis is completed, a folder is generated under the bin path as follows:

Open the file, and the xls file with optimized sql statements is as follows:

The details of Sql execution are as follows:

Connect to the locally instantiated database 127.0.0.1purl 6666. A logcommit table will be generated under the SYSDBA user. It records all the sql performed by the trace log.

The above is the case analysis enabled by the DM trace log. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.