Trace Peoplecode & SQL

http://notepad-plus.sourceforge.net/uk/download.php3)Below method from customer connection gives a moreprecise trace..1. Navigate to the page where the problem exists andbe ready to click on the button. In this example, wewant to get an Online Trace for the time we Add a newJournal.2. In the right corner of your screen, click on 'NewWindow' to open a new window. On the new window,navigate to the following menu: PeopleTools >Utilities > Debug. Under this menu, there are severaloptions for the tracing:-Trace SQL-TracePeopleCode-Trace Page.3. For our example, we will create an online trace forSQL as we want to see what the table is being selectedand updated. In most cases, selecting 'Trace SQLStatement' and 'Trace SQL Bind' will be sufficient.For PeopleCode, usually, all the 'Show' options arethe selection that we need. Save the page, and do notclose it.4. Now, check for the existing trace file. The tracewill be created in Logs folder on your ApplicationServer.[PS_HOME]\appserv\[domain]LOGS. For example:E880G71P\appserv\E880G71P\LOGS.5. The online trace filename will be similar to [username]_[machine name].tracesql. For example:VP1_FLINAN12345.tracesql. If you find an existing one,rename or delete it.6. Now go back to your original page. And click on'ADD' button.7. When the process is finished, it should create thetrace file on the Logs directory. Copy the file toyour workstation as it will be appended with newinformation everytime you turn on the online trace.8. Don't forget to turn off the tracing.9. HAPPY TRACING!