SAP Note 25099 - Activate SQL trace

Symptom:

An SQL trace is needed for a precise problem analysis.

Solution

Activate SQL trace:

1. System --> Utilities --> Trace SQL

2. Click on the button ´Trace on´ and enter the user ID

(It is also possible to enter * as the user ID)
The trace can be analyzed directly via R/3 and the button ´List Trace´.

On UNIX level, the file TRACE000 is created in the directory. /usr/sap//DVEBMGS00/log This file may only be as large as the parameter rstr/max_diskspace allows it to be (default value: 16384000). If the file is filled, recording of the following data records starts again at the beginning of the file (circular record entry). It is therefore occasionally possible that the sections necessary for problem analysis have been overwritten. To avoid this, the trace should be deactivated (with ´Trace off´) immediately after completion or termination of the problematic run (for example, the payment run).

If very large datasets are generated by the trace, increase the size of the profile parameter rstr/max_diskspace. Below, nn specifies the instance number (sometimes also called system number).

On a UNIX system or Windows NT proceed as follows:

1. Log on as user adm.

2. Shut down the R/3 System.

3. Enter the following command to delete the SCSA:
sapmscsa pf=/usr/sap//SYS/profile/_DVEBMGSnn -r
alternatively, you can execute the command
cleanipc nn remove ausführen. Auf NT Systemen muß kein sapmscsa/cleanipc ausgeführt werden.

4. Increase the value of rstr/max_diskspace in the instance profile
/usr/sap//SYS/profile/_DVEBMGSnn
rstr/max_diskspace =32768000 (sample value, should be within the
framework of the free disk space available)

5. Restart R/3 and activate the SQL trace as described above.

If problems occur when you delete the SCSA refer to the collective Note 12715.
On AS/400, proceed as follows:

1. Log on as OFR.

2. Shut down R/3.

3. Enter the following command:
call sapmscsa 'pf = /usr/sap//SYS/profile/_DVEBMGSnn -r'

4. Increase the value of rstr/max_diskspace in the instance profile
/usr/sap//SYS/profile/_DVEBMGSnn
rstr/max_diskspace =32768000 (sample value, should be within
the framework of the free disk space available)

5. Then enter the following command:
call sapmscsa 'pf = /usr/sap//SYS/profile/_DVEBMGSnn-n'

6. Restart the R/3 System and start the SQL trace as described above

Additional key words

ST05