{"id":295,"date":"2013-06-28T14:15:45","date_gmt":"2013-06-28T14:15:45","guid":{"rendered":"http:\/\/www.alemdopeoplebooks.com.br\/site\/?p=295"},"modified":"2013-08-09T00:33:13","modified_gmt":"2013-08-09T00:33:13","slug":"trace-appengine-dicas-e-truques","status":"publish","type":"post","link":"https:\/\/www.alemdopeoplebooks.com.br\/site\/trace-appengine-dicas-e-truques\/","title":{"rendered":"Trace AppEngine Dicas e Truques"},"content":{"rendered":"<p>Recentemente tive um problema onde eu precisava rastrear um processo para determinar onde estava o erro e n\u00e3o lembrava todas as op\u00e7\u00f5es de trace, abaixo o passo-a-passo para execu\u00e7\u00e3o do trace e suas op\u00e7\u00f5es.<\/p>\n<p>Primeiramente vamos ativar o rastreamento, para isso v\u00e1 no PeopleSoft e acesse o menu PeopleTools -&gt; Process Scheduller -&gt; Processos e procure o processo que deseja ativar o trace.<\/p>\n<p>Na aba &#8220;Op\u00e7\u00f5es de Substitui\u00e7\u00e3o&#8221; informe na lista de par\u00e2metros os valores desejados.<\/p>\n<p><a href=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/06\/trace1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-330\" alt=\"trace1\" src=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/06\/trace1.jpg\" width=\"522\" height=\"237\" srcset=\"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/06\/trace1.jpg 745w, https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-content\/uploads\/2013\/06\/trace1-300x136.jpg 300w\" sizes=\"auto, (max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<p>Neste exemplo estou utilizando o\u00a0-TRACE 15 -TOOLSTRACEPC 3780 -TOOLSTRACESQL 7<\/p>\n<p>Abaixo as op\u00e7\u00f5es de trace:<\/p>\n<p>A op\u00e7\u00e3o &#8211;<strong>TRACE<\/strong>\u00a0define o rastreamento para o programa App Engine em geral. Por exemplo, ele pode ligar a sa\u00edda de rastreamento que mostra quais etapas ser\u00e3o executadas e em qual ordem.<\/p>\n<ul>\n<li>1 =\u00a0Trace STEP execution sequence to AET file<\/li>\n<li>2 =\u00a0Trace Application SQL statements to AET file<\/li>\n<li>4 =\u00a0Trace Dedicated Temp Table Allocation to AET file<\/li>\n<li>8 =\u00a0not yet allocated<\/li>\n<li>16 =\u00a0not yet allocated<\/li>\n<li>32 =\u00a0not yet allocated<\/li>\n<li>64 =\u00a0not yet allocated<\/li>\n<li>128 =\u00a0Timings Report to AET file<\/li>\n<li>256 =\u00a0Method\/BuiltIn detail instead of summary in AET Timings Report<\/li>\n<li>512 =\u00a0not yet allocated<\/li>\n<li>1024 =\u00a0Timings Report to tables<\/li>\n<li>2048 =\u00a0DB optimizer trace to file<\/li>\n<li>4096 =\u00a0DB optimizer trace to tables<\/li>\n<\/ul>\n<p>A op\u00e7\u00e3o <strong>-TOOLSTRACESQL<\/strong>\u00a0possui op\u00e7\u00f5es especificas para rastreament SQL, al\u00e9m do SQL executado por etapas em um programa \u00a0App Engine ele inclui qualquer comunica\u00e7\u00e3o de dados do sistema com o banco de dados.<\/p>\n<ul>\n<li>1 =\u00a0SQL statements<\/li>\n<li>2 =\u00a0SQL statement variables<\/li>\n<li>4 =\u00a0SQL connect, disconnect, commit and rollback<\/li>\n<li>8 =\u00a0Row Fetch (indicates that it occurred, not data)<\/li>\n<li>16 =\u00a0All other API calls except ssb<\/li>\n<li>32 =\u00a0Set Select Buffers (identifies the attributes of columns\u00a0to be selected<\/li>\n<li>64 =\u00a0Database API specific calls<\/li>\n<li>128 =\u00a0COBOL statement timings<\/li>\n<li>256 =\u00a0Sybase Bind information<\/li>\n<li>512 =\u00a0Sybase Fetch information<\/li>\n<li>1024 =\u00a0SQL Informational Trace<\/li>\n<\/ul>\n<p>A op\u00e7\u00e3o <strong>-TOOLSTRACEPC<\/strong>\u00a0ativa o rastreamento para PeopleCode, mostrando assim os passos do PeopleCode dentro do App Engine.<\/p>\n<ul>\n<li>1 =\u00a0Trace Evaluator instructions (not recommended)<\/li>\n<li>2 =\u00a0List Evaluator program (not recommended)<\/li>\n<li>4 =\u00a0Show assignments to variables<\/li>\n<li>8 =\u00a0Show fetched values<\/li>\n<li>16 =\u00a0Show stack<\/li>\n<li>64 =\u00a0Trace start of programs<\/li>\n<li>128 =\u00a0Trace external function calls<\/li>\n<li>256 =\u00a0Trace internal function calls<\/li>\n<li>512 =\u00a0Show parameter values<\/li>\n<li>1024 =\u00a0Show function return value<\/li>\n<li>2048 =\u00a0Trace each statement in program (recommended)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Recentemente tive um problema onde eu precisava rastrear um processo para determinar onde estava o erro e n\u00e3o lembrava todas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[69,3],"tags":[10,13,110,21,19,9],"class_list":["post-295","post","type-post","status-publish","format-standard","hentry","category-peoplesoft","category-peopletools","tag-app-engine","tag-oracle-peoplesoft","tag-peopletools","tag-toolstracepc","tag-toolstracesql","tag-trace"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":19,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/posts\/295\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alemdopeoplebooks.com.br\/site\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}