{"id":10660,"date":"2017-11-25T18:11:05","date_gmt":"2017-11-25T17:11:05","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/"},"modified":"2024-08-11T09:43:54","modified_gmt":"2024-08-11T07:43:54","slug":"documentum-dfc-traces-setup-investigation","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/","title":{"rendered":"Documentum &#8211; DFC traces setup &amp; investigation"},"content":{"rendered":"<p>When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are the limitations of such things.<\/p>\n<p>Enabling the DFC traces can be done very easily by updating the dfc.properties file of the client. This client can be a DA, D2, JMS, Index Agent, aso&#8230; The change is applied directly (if enabled=true) and disabled by default (if commented or enable=false). If you have a dfc.properties that is inside a war file (for DA\/D2 for example) and that you deployed your application as a war file (not exploded), then disabling the tracing might need a restart of your application. To avoid that, you can have a dfc.properties inside the war file that just point to another one outside of the war file and then enabling\/disabling the traces from this second file will work properly. There are a lot of options to customize how the traces should be generated. A first example with only a few properties that you can use and reuse every time you need traces:<\/p>\n<div>\n<div id=\"highlighter_552596\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">enable<\/code><code class=\"bash plain\">=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">dfc.tracing.verbose=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">dfc.tracing.max_stack_depth=0<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">dfc.tracing.mode=compact<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">dir<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/tmp\/dfc_tracing<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Another example with more properties to really specify what you want to see:<\/p>\n<div>\n<div id=\"highlighter_834055\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">enable<\/code><code class=\"bash plain\">=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">dfc.tracing.verbose=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">dfc.tracing.max_stack_depth=4<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">dfc.tracing.include_rpcs=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">dfc.tracing.mode=standard<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">dfc.tracing.include_session_id=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">dfc.tracing.user_name_filter[0]=dmadmin<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">dfc.tracing.user_name_filter[1]=myuser<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">dfc.tracing.thread_name_filter[0]=Thread-3<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">dfc.tracing.thread_name_filter[1]=Thread-25<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">dfc.tracing.timing_style=milliseconds_from_start<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">dir<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/tmp\/dfc_tracing<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">dfc.tracing.file_prefix=mydfc<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">dfc.tracing.max_backup_index=10<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"bash plain\">dfc.tracing.max_file_size=104857600<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"bash plain\">...<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>All these properties are quite easy to understand even without explanation but you can probably find more information and all the possible options in the official Documentum documentation. It&#8217;s not the main purpose of this blog so I&#8217;m just mentioning a few properties to get started. By default, the name of the generated files will be something like &#8220;dfctrace.timestamp.log&#8221;, you can change that by setting the &#8220;dfc.tracing.file_prefix&#8221; for example. Adding and customizing the properties will change the display format and style inside the files so if you want to have a way to analyze these DFC traces, it is better to use more or less always the same set of options. For the example below, OTX asked me to use these properties only:<\/p>\n<div>\n<div id=\"highlighter_213595\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">enable<\/code><code class=\"bash plain\">=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">dfc.tracing.verbose=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">dfc.tracing.max_stack_depth=4<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">dfc.tracing.include_rpcs=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">dfc.tracing.mode=compact<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">dfc.tracing.include_session_id=<\/code><code class=\"bash functions\">true<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">dfc.tracing.<\/code><code class=\"bash functions\">dir<\/code><code class=\"bash plain\">=<\/code><code class=\"bash plain\">\/tmp\/dfc_tracing<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>When you have your DFC traces, you need a way to analyze them. They are pretty much readable but it will be complicated to get something out of it without spending a certain amount of time &#8211; unless you already know what you are looking for &#8211; simply because there are a lot of information inside&#8230; For that purpose, Ed Bueche developed more than 10 years ago some AWK scripts to parse the DFC traces files: traceD6.awk and trace_rpc_histD6.awk. You can find these scripts at the following locations (all EMC links&#8230; So might not be working at some point in the future):<\/p>\n<ul>\n<li><a href=\"https:\/\/community.emc.com\/docs\/DOC-1218\" target=\"_blank\" rel=\"noopener\">https:\/\/community.emc.com\/docs\/DOC-1218<\/a> =&gt; awk scripts in v2.0 (2007)<\/li>\n<li><a href=\"https:\/\/community.emc.com\/docs\/DOC-6355\" target=\"_blank\" rel=\"noopener\">https:\/\/community.emc.com\/docs\/DOC-6355<\/a> =&gt; awk scripts in v2.0<\/li>\n<li><a href=\"https:\/\/support.emc.com\/kb\/157573\" target=\"_blank\" rel=\"noopener\">https:\/\/support.emc.com\/kb\/157573<\/a> =&gt; awk scripts in v2.0 (traceD6) and v4.0 (trace_rpc_histD6)<\/li>\n<li><a href=\"https:\/\/community.emc.com\/docs\/DOC-21563\" target=\"_blank\" rel=\"noopener\">https:\/\/community.emc.com\/docs\/DOC-21563<\/a> =&gt; awk scripts in v4.0 (2009)<\/li>\n<li><a href=\"https:\/\/community.emc.com\/docs\/DOC-21567\" target=\"_blank\" rel=\"noopener\">https:\/\/community.emc.com\/docs\/DOC-21567<\/a> =&gt; python script (2013)<\/li>\n<\/ul>\n<p><em>Edit: Since the above links are apparently not working anymore, you can find the v2.0 version on OpenText KB0508263 &amp; KB0475266. Or you can find the v4.0 version here: <a href=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/traceD6.docx\">traceD6<\/a> &amp; <a href=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2024\/08\/trace_rpc_histD6.docx\">trace_rpc_histD6<\/a> (sorry it&#8217;s a docx file containing the content of the awk scripts as I cannot upload an awk or txt or zip file into our blog but docx is allowed, somehow&#8230;?)<\/em><\/p>\n<p>As you can see above, it is not really maintained and the same scripts or a mix of several versions can be found at several locations so it can be a little bit confusing. All the old links are about the awk scripts but since 2013, there is now a python script too (also developed by Ed Bueche).<\/p>\n<p>In this blog, I wanted to talk about the AWK scripts mainly. Earlier this month, I was working with OTX on some performance tuning tasks and for that, I gathered the DFC traces for several scenarios, in different log files, well separated, aso&#8230; Then, I provided them to OTX for the analysis. OTX came back to me a few minutes later saying that most of the traces were corrupted and asking me to regenerate them. Since it takes time and because there were some testing in progress on this environment, then gathering clean DFC traces for several scenarios would have forced the tests to be stopped, aso&#8230; So if possible, I wanted to avoid doing that. (Ok ok you got me, I&#8217;m just lazy ;))<\/p>\n<p>The content of the DFC traces looked correct to me and after a quick verification, I saw that OTX was trying to use the AWK scripts (traceD6.awk and trace_rpc_histD6.awk) to analyze the logs but they were apparently getting an error. The files didn&#8217;t look corrupted to me so I mentioned to OTX that the issue might very well be with the AWK scripts they were using. They weren&#8217;t really convinced about that so I decided to take a look at these scripts and try to find it out. I already used these scripts but never really looked inside so it was the perfect <span id=\"result_box\" class=\"short_text\" lang=\"en\"><span class=\"\">opportunity<\/span><\/span> to take some time for that:<\/p>\n<div>\n<div id=\"highlighter_631628\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1 highlighted\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1 highlighted\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2 highlighted\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 ~]$ <\/code><code class=\"bash functions\">cd<\/code> <code class=\"bash plain\">\/tmp\/dfc_tracing\/<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">ls<\/code> <code class=\"bash plain\">-l trace* dfctrace.*.log<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">-rw-r-----. 1 dmadmin dmadmin 92661060 Nov 3 09:24 dfctrace.1510220481672.log<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">-rw-r-----. 1 dmadmin dmadmin 3240 Nov 4 14:10 traceD6.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">-rw-r-----. 1 dmadmin dmadmin 7379 Nov 4 14:10 traceD6.py<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">-rw-r-----. 1 dmadmin dmadmin 5191 Nov 4 14:10 trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">-f traceD6.<\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">&lt; dfctrace.1510220481672.log &gt; output_awk_1.log<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-l output_awk_1.log<\/code><\/div>\n<div class=\"line number12 index11 alt1 highlighted\"><code class=\"bash plain\">2 output_awk_1.log<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">-f trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">&lt; dfctrace.1510220481672.log &gt; output_awk_2.log<\/code><\/div>\n<div class=\"line number16 index15 alt1 highlighted\"><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">: trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">:203: (FILENAME=- FNR=428309) fatal: division by zero attempted<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-l output_awk_2.log<\/code><\/div>\n<div class=\"line number19 index18 alt2 highlighted\"><code class=\"bash plain\">4 output_awk_2.log<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>As you can see above, the first script generated a log file that contains only 2 lines, so this is already suspicious even if there are no errors. The second script generated an error and its log file contains only 4 lines&#8230; The input DFC trace file has a size of 90Mb so it&#8217;s clear that there is something wrong and that&#8217;s why OTX said that the DFC traces were corrupted. The error message shows the line (203) as the origin of the issue as well as a &#8220;division by zero attempted&#8221; message. This obviously means that somewhere on this line, there is a division and that the divisor is equal to 0 or at least not set at all. Since I love all kind of UNIX scripting, I would rather fix the bug in the script than having to generate a new set of DFC traces (and the new set would still be impacted by the issue anyway&#8230;)! So checking inside the trace_rpc_histD6.awk file, the line 203 is the following one:<\/p>\n<div>\n<div id=\"highlighter_38183\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">grep<\/code> <code class=\"bash plain\">-n -C1 <\/code><code class=\"bash string\">\"TIME SPENT\"<\/code> <code class=\"bash plain\">trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">202-\u00a0\u00a0\u00a0 <\/code><code class=\"bash functions\">printf<\/code> <code class=\"bash plain\">(<\/code><code class=\"bash string\">\"DURATION (secs):t%17.3fn\"<\/code><code class=\"bash plain\">, ((curr_tms - st_tms)) );<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">203:\u00a0\u00a0\u00a0 <\/code><code class=\"bash functions\">printf<\/code> <code class=\"bash plain\">(<\/code><code class=\"bash string\">\"TIME SPENT EXECUTING RPCs (secs):%8.3f (which is %3.2f percent of total time)n\"<\/code><code class=\"bash plain\">, total_rpc_time, 100*total_rpc_time\/(curr_tms - st_tms));<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">204-\u00a0\u00a0\u00a0 <\/code><code class=\"bash functions\">printf<\/code> <code class=\"bash plain\">(<\/code><code class=\"bash string\">\"Threads :t%25dn\"<\/code><code class=\"bash plain\">, thread_cnt);<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The only division on this line is the total time taken to execute the RPCs divided by the duration of the log file (timestamp of last message &#8211; first message). So the value of &#8220;curr_tms &#8211; st_tms&#8221; is 0. Potentially, it could be that both variables have the exact same value but since the first and last messages on the DFC traces don&#8217;t have the same timestamp, this isn&#8217;t possible and therefore both variables are actually 0 or not set. To check where these variables are defined, how and in which function:<\/p>\n<div>\n<div id=\"highlighter_821483\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1 highlighted\">2<\/div>\n<div class=\"line number3 index2 alt2 highlighted\">3<\/div>\n<div class=\"line number4 index3 alt1 highlighted\">4<\/div>\n<div class=\"line number5 index4 alt2 highlighted\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">grep<\/code> <code class=\"bash plain\">-n -C15 -E <\/code><code class=\"bash string\">\"curr_tms|st_tms\"<\/code> <code class=\"bash plain\">trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">| <\/code><code class=\"bash functions\">grep<\/code> <code class=\"bash plain\">-E <\/code><code class=\"bash string\">\"curr_tms|st_tms|^[0-9]*[:-][^[:space:]]\"<\/code><\/div>\n<div class=\"line number2 index1 alt1 highlighted\"><code class=\"bash plain\">144-\/ .RPC:\/ {<\/code><\/div>\n<div class=\"line number3 index2 alt2 highlighted\"><code class=\"bash plain\">159:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 st_tms = $1;<\/code><\/div>\n<div class=\"line number4 index3 alt1 highlighted\"><code class=\"bash plain\">162:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 curr_tms = $1;<\/code><\/div>\n<div class=\"line number5 index4 alt2 highlighted\"><code class=\"bash plain\">175-}<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">177-<\/code><code class=\"bash plain\">\/obtained<\/code> <code class=\"bash plain\">from pool\/ {<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">--<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">187-}<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">188-\/.INFO: Session\/ {<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">193-}<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">197-END {<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">202:\u00a0\u00a0\u00a0 <\/code><code class=\"bash functions\">printf<\/code> <code class=\"bash plain\">(<\/code><code class=\"bash string\">\"DURATION (secs):t%17.3fn\"<\/code><code class=\"bash plain\">, ((curr_tms - st_tms)) );<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">203:\u00a0\u00a0\u00a0 <\/code><code class=\"bash functions\">printf<\/code> <code class=\"bash plain\">(<\/code><code class=\"bash string\">\"TIME SPENT EXECUTING RPCs (secs):%8.3f (which is %3.2f percent of total time)n\"<\/code><code class=\"bash plain\">, total_rpc_time, 100*total_rpc_time\/(curr_tms - st_tms));<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>This shows that the only location where these two variables are set is inside the matching pattern &#8220;\/ .RPC:\/&#8221; (st_tms is set to $1 only on the first execution). So it means that this portion of code is never executed so in other words: this pattern is never found in the DFC trace file. Why is that? Well that&#8217;s pretty simple: the DFC traces file contains a lot of RPC calls but these lines never contain &#8221; .RPC:&#8221;, there are always at least two dots (so something like that: &#8221; ..RPC:&#8221; or &#8221; &#8230;RPC:&#8221; or &#8221; &#8230;.RPC:&#8221;). The reason why there are several dots is simply because the RPC are placed where they are called&#8230; In this case, OTX asked us to use &#8220;dfc.tracing.max_stack_depth=4&#8221; so this is what I did and it is the reason why the AWK scripts cannot work by default because they need &#8220;dfc.tracing.max_stack_depth=0&#8221;, that&#8217;s written at the beginning of the scripts in the comment sections.<\/p>\n<p>So a simple way to fix the AWK scripts is to remove the space at the beginning of the pattern for both the traceD6.awk and trace_rpc_histD6.awk scripts and after doing that, it will work for all max_stack_depth values:<\/p>\n<div>\n<div id=\"highlighter_91882\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1 highlighted\">2<\/div>\n<div class=\"line number3 index2 alt2 highlighted\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2 highlighted\">9<\/div>\n<div class=\"line number10 index9 alt1 highlighted\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2 highlighted\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<div class=\"line number21 index20 alt2 highlighted\">21<\/div>\n<div class=\"line number22 index21 alt1\">22<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">grep<\/code> <code class=\"bash plain\">-n <\/code><code class=\"bash string\">\".RPC:\/\"<\/code> <code class=\"bash plain\">*.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number2 index1 alt1 highlighted\"><code class=\"bash plain\">traceD6.<\/code><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">:145:\/ .RPC:\/ {<\/code><\/div>\n<div class=\"line number3 index2 alt2 highlighted\"><code class=\"bash plain\">trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">:144:\/ .RPC:\/ {<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">sed<\/code> <code class=\"bash plain\">-i <\/code><code class=\"bash string\">'s,\/ .RPC:\/,\/.RPC:\/,'<\/code> <code class=\"bash plain\">*.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">grep<\/code> <code class=\"bash plain\">-n <\/code><code class=\"bash string\">\".RPC:\/\"<\/code> <code class=\"bash plain\">*.<\/code><code class=\"bash functions\">awk<\/code><\/div>\n<div class=\"line number9 index8 alt2 highlighted\"><code class=\"bash plain\">traceD6.<\/code><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">:145:\/.RPC:\/ {<\/code><\/div>\n<div class=\"line number10 index9 alt1 highlighted\"><code class=\"bash plain\">trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code><code class=\"bash plain\">:144:\/.RPC:\/ {<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">-f traceD6.<\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">&lt; dfctrace.1510220481672.log &gt; output_awk_1.log<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-lc output_awk_1.log<\/code><\/div>\n<div class=\"line number15 index14 alt2 highlighted\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">1961 163788 output_awk_1.log<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">-f trace_rpc_histD6.<\/code><code class=\"bash functions\">awk<\/code> <code class=\"bash plain\">&lt; dfctrace.1510220481672.log &gt; output_awk_2.log<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-l output_awk_2.log<\/code><\/div>\n<div class=\"line number21 index20 alt2 highlighted\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">367 49050 output_awk_2.log<\/code><\/div>\n<div class=\"line number22 index21 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>That looks much much better&#8230; Basically, the first script list all RPCs with their thread, name and times while the second script creates a sorted list of queries that took the most time to execute as well as a list of calls and occurrences per types\/names.<\/p>\n<p>The AWK and Python scripts, even if they are globally working, might have some issues with commas, parenthesis and stuff like that (again it depends which dfc.tracing options you selected). This is why I mentioned above that there is actually both a AWK and Python version of these scripts. Sometimes, the AWK scripts will contain the right information, sometimes it is the Python version that will but in all cases, the later will run much faster. So if you want to work with these scripts, you will have to juggle a little bit:<\/p>\n<div>\n<div id=\"highlighter_86612\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1 highlighted\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1 highlighted\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ python traceD6.py dfctrace.1510220481672.log &gt; output_py_1.log<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-l output_py_1.log<\/code><\/div>\n<div class=\"line number4 index3 alt1 highlighted\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">1959 194011 output_py_1.log<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ python traceD6.py dfctrace.1510220481672.log -profile &gt; output_py_2.log<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">wc<\/code> <code class=\"bash plain\">-l output_py_2.log<\/code><\/div>\n<div class=\"line number10 index9 alt1 highlighted\"><code class=\"bash spaces\">\u00a0<\/code><code class=\"bash plain\">342 65917 output_py_2.log<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>As you can see, there are fewer lines in the python output files but that&#8217;s because some unnecessary headers have been removed in the python version so it&#8217;s actually normal. However there are much more characters so it shows that, in this case, the extracted DQL queries contain more characters but it does not mean that these characters are actually part of the DQL queries: you will see below that there are references to &#8220;, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,true,true)&#8221; =&gt; This is NOT part of the DQL but it is present on the output of the Python script while it is not for the AWK one:<\/p>\n<div>\n<div id=\"highlighter_138719\" class=\"syntaxhighlighter  bash\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<div class=\"line number20 index19 alt1\">20<\/div>\n<div class=\"line number21 index20 alt2\">21<\/div>\n<div class=\"line number22 index21 alt1\">22<\/div>\n<div class=\"line number23 index22 alt2\">23<\/div>\n<div class=\"line number24 index23 alt1\">24<\/div>\n<div class=\"line number25 index24 alt2\">25<\/div>\n<div class=\"line number26 index25 alt1\">26<\/div>\n<div class=\"line number27 index26 alt2\">27<\/div>\n<div class=\"line number28 index27 alt1\">28<\/div>\n<div class=\"line number29 index28 alt2\">29<\/div>\n<div class=\"line number30 index29 alt1\">30<\/div>\n<div class=\"line number31 index30 alt2\">31<\/div>\n<div class=\"line number32 index31 alt1\">32<\/div>\n<div class=\"line number33 index32 alt2\">33<\/div>\n<div class=\"line number34 index33 alt1\">34<\/div>\n<div class=\"line number35 index34 alt2\">35<\/div>\n<div class=\"line number36 index35 alt1\">36<\/div>\n<div class=\"line number37 index36 alt2\">37<\/div>\n<div class=\"line number38 index37 alt1\">38<\/div>\n<div class=\"line number39 index38 alt2\">39<\/div>\n<div class=\"line number40 index39 alt1\">40<\/div>\n<div class=\"line number41 index40 alt2\">41<\/div>\n<div class=\"line number42 index41 alt1\">42<\/div>\n<div class=\"line number43 index42 alt2\">43<\/div>\n<div class=\"line number44 index43 alt1\">44<\/div>\n<div class=\"line number45 index44 alt2\">45<\/div>\n<div class=\"line number46 index45 alt1\">46<\/div>\n<div class=\"line number47 index46 alt2\">47<\/div>\n<div class=\"line number48 index47 alt1\">48<\/div>\n<div class=\"line number49 index48 alt2\">49<\/div>\n<div class=\"line number50 index49 alt1\">50<\/div>\n<div class=\"line number51 index50 alt2\">51<\/div>\n<div class=\"line number52 index51 alt1\">52<\/div>\n<div class=\"line number53 index52 alt2\">53<\/div>\n<div class=\"line number54 index53 alt1\">54<\/div>\n<div class=\"line number55 index54 alt2\">55<\/div>\n<div class=\"line number56 index55 alt1\">56<\/div>\n<div class=\"line number57 index56 alt2\">57<\/div>\n<div class=\"line number58 index57 alt1\">58<\/div>\n<div class=\"line number59 index58 alt2\">59<\/div>\n<div class=\"line number60 index59 alt1\">60<\/div>\n<div class=\"line number61 index60 alt2\">61<\/div>\n<div class=\"line number62 index61 alt1\">62<\/div>\n<div class=\"line number63 index62 alt2\">63<\/div>\n<div class=\"line number64 index63 alt1\">64<\/div>\n<div class=\"line number65 index64 alt2\">65<\/div>\n<div class=\"line number66 index65 alt1\">66<\/div>\n<div class=\"line number67 index66 alt2\">67<\/div>\n<div class=\"line number68 index67 alt1\">68<\/div>\n<div class=\"line number69 index68 alt2\">69<\/div>\n<div class=\"line number70 index69 alt1\">70<\/div>\n<div class=\"line number71 index70 alt2\">71<\/div>\n<div class=\"line number72 index71 alt1\">72<\/div>\n<div class=\"line number73 index72 alt2\">73<\/div>\n<div class=\"line number74 index73 alt1\">74<\/div>\n<div class=\"line number75 index74 alt2\">75<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">head<\/code> <code class=\"bash plain\">-15 output_awk_1.log<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"bash plain\">analysis program version 2 based on DFC build 6.0.0.76<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"bash plain\">68354.130 &amp; 0.005 &amp; [http--0.0.0.0-9082-3] &amp; EXEC_QUERY\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/Home'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"bash plain\">68354.135 &amp; 0.000 &amp; [http--0.0.0.0-9082-3] &amp; multiNext<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"bash plain\">68354.136 &amp; 0.005 &amp; [http--0.0.0.0-9082-3] &amp; SysObjFullFetch\u00a0 0b0f12345004f0de<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"bash plain\">68354.165 &amp; 0.002 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_user where user_name = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"bash plain\">68354.167 &amp; 0.000 &amp; [http--0.0.0.0-9082-4] &amp; multiNext<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"bash plain\">68354.167 &amp; 0.002 &amp; [http--0.0.0.0-9082-4] &amp; IsCurrent<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"bash plain\">68354.170 &amp; 0.003 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY\u00a0 SELECT COUNT(*) AS items FROM dm_group WHERE group_name = <\/code><code class=\"bash string\">'report_user'<\/code> <code class=\"bash plain\">AND ANY i_all_users_names = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"bash plain\">68354.173 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; multiNext<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"bash plain\">68354.175 &amp; 0.003 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/myInsight'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'myInsight.license'<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"bash plain\">68354.178 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; multiNext<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"bash plain\">68354.179 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; IsCurrent<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"bash plain\">68354.165 &amp; 0.010 &amp; [http--0.0.0.0-9082-3] &amp; SysObjGetPermit<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"bash plain\">68354.175 &amp; 0.006 &amp; [http--0.0.0.0-9082-3] &amp; SysObjGetXPermit<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"bash plain\">68354.181 &amp; 0.006 &amp; [http--0.0.0.0-9082-4] &amp; MAKE_PULLER<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">head<\/code> <code class=\"bash plain\">-15 output_py_1.log<\/code><\/div>\n<div class=\"line number20 index19 alt1\"><code class=\"bash plain\">68354.130 &amp; 0.005 &amp; [http--0.0.0.0-9082-3] &amp; EXEC_QUERY &amp; <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/Home'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><code class=\"bash plain\">, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number21 index20 alt2\"><code class=\"bash plain\">68354.135 &amp; 0.000 &amp; [http--0.0.0.0-9082-3] &amp; multiNext &amp;<\/code><\/div>\n<div class=\"line number22 index21 alt1\"><code class=\"bash plain\">68354.136 &amp; 0.005 &amp; [http--0.0.0.0-9082-3] &amp; SysObjFullFetch &amp; 0b0f12345004f0de<\/code><\/div>\n<div class=\"line number23 index22 alt2\"><code class=\"bash plain\">68354.165 &amp; 0.002 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY &amp; <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_user where user_name = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><code class=\"bash plain\">, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number24 index23 alt1\"><code class=\"bash plain\">68354.167 &amp; 0.000 &amp; [http--0.0.0.0-9082-4] &amp; multiNext &amp;<\/code><\/div>\n<div class=\"line number25 index24 alt2\"><code class=\"bash plain\">68354.167 &amp; 0.002 &amp; [http--0.0.0.0-9082-4] &amp; IsCurrent &amp; 110f123450001d07<\/code><\/div>\n<div class=\"line number26 index25 alt1\"><code class=\"bash plain\">68354.170 &amp; 0.003 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY &amp; SELECT COUNT(*) AS items FROM dm_group WHERE group_name = <\/code><code class=\"bash string\">'report_user'<\/code> <code class=\"bash plain\">AND ANY i_all_users_names = <\/code><code class=\"bash string\">'Morgan Patou'<\/code><code class=\"bash plain\">, FOR_UPDATE=T, BATCH_HINT=50, BOF_DQL=T, FLUSH_BATCH=-1]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number27 index26 alt2\"><code class=\"bash plain\">68354.173 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; multiNext &amp;<\/code><\/div>\n<div class=\"line number28 index27 alt1\"><code class=\"bash plain\">68354.175 &amp; 0.003 &amp; [http--0.0.0.0-9082-4] &amp; EXEC_QUERY &amp; <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/myInsight'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'myInsight.license'<\/code><code class=\"bash plain\">, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number29 index28 alt2\"><code class=\"bash plain\">68354.178 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; multiNext &amp;<\/code><\/div>\n<div class=\"line number30 index29 alt1\"><code class=\"bash plain\">68354.179 &amp; 0.001 &amp; [http--0.0.0.0-9082-4] &amp; IsCurrent &amp; 090f123450023f63<\/code><\/div>\n<div class=\"line number31 index30 alt2\"><code class=\"bash plain\">68354.165 &amp; 0.010 &amp; [http--0.0.0.0-9082-3] &amp; SysObjGetPermit &amp; 0b0f12345004f0de<\/code><\/div>\n<div class=\"line number32 index31 alt1\"><code class=\"bash plain\">68354.175 &amp; 0.006 &amp; [http--0.0.0.0-9082-3] &amp; SysObjGetXPermit &amp; 0b0f12345004f0de<\/code><\/div>\n<div class=\"line number33 index32 alt2\"><code class=\"bash plain\">68354.181 &amp; 0.006 &amp; [http--0.0.0.0-9082-4] &amp; MAKE_PULLER &amp; null<\/code><\/div>\n<div class=\"line number34 index33 alt1\"><code class=\"bash plain\">68354.187 &amp; 0.000 &amp; [http--0.0.0.0-9082-4] &amp; getBlock &amp;<\/code><\/div>\n<div class=\"line number35 index34 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number36 index35 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number37 index36 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number38 index37 alt1\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<div class=\"line number39 index38 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$ <\/code><code class=\"bash functions\">head<\/code> <code class=\"bash plain\">-35 output_py_2.log<\/code><\/div>\n<div class=\"line number40 index39 alt1\"><\/div>\n<div class=\"line number41 index40 alt2\"><code class=\"bash plain\">****** PROFILE OF rpc CALLS *****<\/code><\/div>\n<div class=\"line number42 index41 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">3.273\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.080\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 41\u00a0\u00a0\u00a0\u00a0\u00a0 AUTHENTICATE_USER<\/code><\/div>\n<div class=\"line number43 index42 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.032\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 BEGIN_TRANS<\/code><\/div>\n<div class=\"line number44 index43 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 END_PUSH_V2<\/code><\/div>\n<div class=\"line number45 index44 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.202\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17\u00a0\u00a0\u00a0\u00a0\u00a0 END_TRANS<\/code><\/div>\n<div class=\"line number46 index45 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">21.898\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.071\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 310\u00a0\u00a0\u00a0\u00a0\u00a0 EXEC_QUERY<\/code><\/div>\n<div class=\"line number47 index46 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.028\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.005\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6\u00a0\u00a0\u00a0\u00a0\u00a0 FETCH_CONTENT<\/code><\/div>\n<div class=\"line number48 index47 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.011\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 55\u00a0\u00a0\u00a0\u00a0\u00a0 GET_ERRORS<\/code><\/div>\n<div class=\"line number49 index48 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.117\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 27\u00a0\u00a0\u00a0\u00a0\u00a0 GET_LOGIN<\/code><\/div>\n<div class=\"line number50 index49 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.290\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 163\u00a0\u00a0\u00a0\u00a0\u00a0 IsCurrent<\/code><\/div>\n<div class=\"line number51 index50 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.013\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 82\u00a0\u00a0\u00a0\u00a0\u00a0 KILL_PULLER<\/code><\/div>\n<div class=\"line number52 index51 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 KILL_PUSHER<\/code><\/div>\n<div class=\"line number53 index52 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.991\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.012\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 82\u00a0\u00a0\u00a0\u00a0\u00a0 MAKE_PULLER<\/code><\/div>\n<div class=\"line number54 index53 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.005\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 MAKE_PUSHER<\/code><\/div>\n<div class=\"line number55 index54 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0\u00a0\u00a0 NEXT_ID_LIST<\/code><\/div>\n<div class=\"line number56 index55 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.083\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 38\u00a0\u00a0\u00a0\u00a0\u00a0 NORPC<\/code><\/div>\n<div class=\"line number57 index56 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.015\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.005\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0 RelationCopy<\/code><\/div>\n<div class=\"line number58 index57 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.446\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.032\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 SAVE<\/code><\/div>\n<div class=\"line number59 index58 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.274\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.014\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20\u00a0\u00a0\u00a0\u00a0\u00a0 SAVE_CONT_ATTRS<\/code><\/div>\n<div class=\"line number60 index59 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.140\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.010\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 START_PUSH<\/code><\/div>\n<div class=\"line number61 index60 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.134\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.045\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjCheckin<\/code><\/div>\n<div class=\"line number62 index61 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.048\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjCheckout<\/code><\/div>\n<div class=\"line number63 index62 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">2.199\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.009\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 240\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjFullFetch<\/code><\/div>\n<div class=\"line number64 index63 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.913\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 141\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjGetPermit<\/code><\/div>\n<div class=\"line number65 index64 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.764\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.005\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 141\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjGetXPermit<\/code><\/div>\n<div class=\"line number66 index65 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.642\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.046\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 14\u00a0\u00a0\u00a0\u00a0\u00a0 SysObjSave<\/code><\/div>\n<div class=\"line number67 index66 alt2\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">0.033\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.000\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 82\u00a0\u00a0\u00a0\u00a0\u00a0 getBlock<\/code><\/div>\n<div class=\"line number68 index67 alt1\"><code class=\"bash spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"bash plain\">1.454\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0.004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 399\u00a0\u00a0\u00a0\u00a0\u00a0 multiNext<\/code><\/div>\n<div class=\"line number69 index68 alt2\"><\/div>\n<div class=\"line number70 index69 alt1\"><code class=\"bash plain\">**** QUERY RESPONSE SORTED IN DESCENDING ORDER ****<\/code><\/div>\n<div class=\"line number71 index70 alt2\"><\/div>\n<div class=\"line number72 index71 alt1\"><code class=\"bash plain\">10.317\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">distinct wf.object_name as workflow_name, <\/code><code class=\"bash functions\">pr<\/code><code class=\"bash plain\">.object_name as process_name, i.name as Performer_Name, i.task_name as Task_Name, i.date_sent as Date_Task_Sent, i.actual_start_date as Date_Task_Acquired, wf.r_creator_name as Workflow_Initiator, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.primary_group as <\/code><code class=\"bash string\">\"group\"<\/code><code class=\"bash plain\">, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.subgroup as subgroup, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.artifact_name as Artifact_Name, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.object_name as document_name, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.r_version_label as version_label, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.title as Document_Title, <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">.r_object_id as object_id from cd_common_ref_model(all) <\/code><code class=\"bash functions\">cd<\/code><code class=\"bash plain\">, dmi_package p, dmi_queue_item i, dm_workflow wf, dm_process <\/code><code class=\"bash functions\">pr<\/code><\/div>\n<div class=\"line number73 index72 alt2\"><code class=\"bash plain\">0.607\u00a0\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/myInsight\/Presentations\/Standard Presentations\/Graphical Reports'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'FusionInterface.xsl'<\/code><code class=\"bash plain\">, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number74 index73 alt1\"><code class=\"bash plain\">0.505\u00a0\u00a0 <\/code><code class=\"bash functions\">select<\/code> <code class=\"bash plain\">r_object_id from dm_sysobject where folder (<\/code><code class=\"bash string\">'\/myInsight\/Presentations\/Life Sciences'<\/code><code class=\"bash plain\">) and object_name = <\/code><code class=\"bash string\">'Unique Templates.xsl'<\/code><code class=\"bash plain\">, FOR_UPDATE=F, BATCH_HINT=50, BOF_DQL=T]],50,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">,<\/code><code class=\"bash functions\">true<\/code><code class=\"bash plain\">)<\/code><\/div>\n<div class=\"line number75 index74 alt2\"><code class=\"bash plain\">[dmadmin@content_server_01 dfc_tracing]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>To conclude this blog on a more philosophical note: think twice before doing the same thing over and over again because it might just be useless. \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are [&hellip;]<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197,525],"tags":[1224,567,129,232,1089,1225,98,339],"type_dbi":[],"class_list":["post-10660","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","category-enterprise-content-management","tag-awk","tag-dfc","tag-documentum","tag-dql","tag-python","tag-rpc","tag-sql","tag-trace"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Documentum - DFC traces setup &amp; investigation - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Documentum - DFC traces setup &amp; investigation\" \/>\n<meta property=\"og:description\" content=\"When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-11-25T17:11:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-11T07:43:54+00:00\" \/>\n<meta name=\"author\" content=\"Morgan Patou\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MorganPatou\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Morgan Patou\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\"},\"author\":{\"name\":\"Morgan Patou\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8\"},\"headline\":\"Documentum &#8211; DFC traces setup &amp; investigation\",\"datePublished\":\"2017-11-25T17:11:05+00:00\",\"dateModified\":\"2024-08-11T07:43:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\"},\"wordCount\":1647,\"commentCount\":3,\"keywords\":[\"awk\",\"dfc\",\"Documentum\",\"DQL\",\"Python\",\"RPC\",\"SQL\",\"Trace\"],\"articleSection\":[\"Application integration &amp; Middleware\",\"Enterprise content management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\",\"name\":\"Documentum - DFC traces setup &amp; investigation - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-11-25T17:11:05+00:00\",\"dateModified\":\"2024-08-11T07:43:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Documentum &#8211; DFC traces setup &amp; investigation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8\",\"name\":\"Morgan Patou\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g\",\"caption\":\"Morgan Patou\"},\"description\":\"Morgan Patou has over 12 years of experience in Enterprise Content Management (ECM) systems, with a strong focus in recent years on platforms such as Alfresco, Documentum, and M-Files. He specializes in the architecture, setup, customization, and maintenance of ECM infrastructures in complex &amp; critical environments. Morgan is well-versed in both engineering and operations aspects, including high availability design, system integration, and lifecycle management. He also has a solid foundation in open-source and proprietary technologies - ranging from Apache, OpenLDAP or Kerberos to enterprise-grade systems like WebLogic. Morgan Patou holds an Engineering Degree in Computer Science from ENSISA (\u00c9cole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse, France. He is Alfresco Content Services Certified Administrator (ACSCA), Alfresco Content Services Certified Engineer (ACSCE) as well as OpenText Documentum Certified Administrator. His industry experience spans the Public Sector, IT Services, Financial Services\/Banking, and the Pharmaceutical industry.\",\"sameAs\":[\"https:\/\/blog.dbi-services.com\/author\/morgan-patou\/\",\"https:\/\/x.com\/MorganPatou\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/morgan-patou\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Documentum - DFC traces setup &amp; investigation - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/","og_locale":"en_US","og_type":"article","og_title":"Documentum - DFC traces setup &amp; investigation","og_description":"When working with Documentum, you will most probably have to enable the DFC traces one day or another and then work with these traces to analyze them. The purpose of this blog is simply to show how the DFC traces can be enabled, which tools can be used to quickly process them and what are [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/","og_site_name":"dbi Blog","article_published_time":"2017-11-25T17:11:05+00:00","article_modified_time":"2024-08-11T07:43:54+00:00","author":"Morgan Patou","twitter_card":"summary_large_image","twitter_creator":"@MorganPatou","twitter_misc":{"Written by":"Morgan Patou","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/"},"author":{"name":"Morgan Patou","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8"},"headline":"Documentum &#8211; DFC traces setup &amp; investigation","datePublished":"2017-11-25T17:11:05+00:00","dateModified":"2024-08-11T07:43:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/"},"wordCount":1647,"commentCount":3,"keywords":["awk","dfc","Documentum","DQL","Python","RPC","SQL","Trace"],"articleSection":["Application integration &amp; Middleware","Enterprise content management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/","url":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/","name":"Documentum - DFC traces setup &amp; investigation - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-11-25T17:11:05+00:00","dateModified":"2024-08-11T07:43:54+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/documentum-dfc-traces-setup-investigation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Documentum &#8211; DFC traces setup &amp; investigation"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/c4d05b25843a9bc2ab20415dae6bd2d8","name":"Morgan Patou","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5d7f5bec8b597db68a09107a6f5309e3870d6296ef94fb10ead4b09454ca67e5?s=96&d=mm&r=g","caption":"Morgan Patou"},"description":"Morgan Patou has over 12 years of experience in Enterprise Content Management (ECM) systems, with a strong focus in recent years on platforms such as Alfresco, Documentum, and M-Files. He specializes in the architecture, setup, customization, and maintenance of ECM infrastructures in complex &amp; critical environments. Morgan is well-versed in both engineering and operations aspects, including high availability design, system integration, and lifecycle management. He also has a solid foundation in open-source and proprietary technologies - ranging from Apache, OpenLDAP or Kerberos to enterprise-grade systems like WebLogic. Morgan Patou holds an Engineering Degree in Computer Science from ENSISA (\u00c9cole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse, France. He is Alfresco Content Services Certified Administrator (ACSCA), Alfresco Content Services Certified Engineer (ACSCE) as well as OpenText Documentum Certified Administrator. His industry experience spans the Public Sector, IT Services, Financial Services\/Banking, and the Pharmaceutical industry.","sameAs":["https:\/\/blog.dbi-services.com\/author\/morgan-patou\/","https:\/\/x.com\/MorganPatou"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/morgan-patou\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10660","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=10660"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10660\/revisions"}],"predecessor-version":[{"id":34499,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10660\/revisions\/34499"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10660"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10660"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10660"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10660"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}