how to stop file under work directory

[Former Member]

Dear All,

I am getting large files are being generated under the following directory,

C:\usr\sap\DEV\DVEBMGS00\work

Please suggest how to stop it.

Regard,

SM

[Former Member]

Hi SharkMachin,

I believe this is an Oracle Net client trace file.

See SAP Note [562403 - FAQ: Oracle Net |https://websmp230.sap-ag.de/sap(bD1oZSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=562403;nlang=EN&smpsrv=https%3a%2f%2fwebsmp205%2esap-ag%2ede] - question 16

and check the configuration of this trace in the parameter file: sqlnet.ora

Hope this helps you.

[Former Member]

Hi SharkMachine,

The work directory is used to contain the developer traces (logs) of the work processes of the system.

Perhaps someone changed the trace level of the work processes. The trace level sets how detailed the developer traces should be. The more detailed the trace is, the bigger the file gets.

In order to check/change the trace level do the following:

1. Go to transaction SM50

2. Click on the menu button: Process -> Trace -> Active Components (or press ctrlshiftF7)

The following are values that can be set to the trace level:

0 - No trace

1 - Errors only

2 - Full trace

3 - Full trace with buffers

For more information see the following resources:

SAP notes:

[84850 - Increase trace level of work processes|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=84850&nlang=EN&smpsrv=https%3a%2f%2fwebsmp104%2esap-ag%2ede]

[ 112 - Trace and error information in the "dev_" files|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=112]

SAP Help Library topics:

[Developer traces|http://help.sap.com/saphelp_nw04s/helpdata/en/1f/8311664bc511d189750000e8322d00/frameset.htm]

[Turning Developer Traces On and Off|http://help.sap.com/saphelp_nw04s/helpdata/en/be/3723f3d41b41a9bc2ec54d03618948/frameset.htm]

Hope this helps.

[Former Member]

What is the name of the file?

[Former Member]

the name of the file which keeps on increasing the size is

cli_nnnn.trc where nnnn is the four digit number. there are several files like this.

Regards,

SM

[Former Member]

Hi SM,

Yes it is a client trace file and four digit number is process id.

You can move these files to different folder or change the location in sqlnet.ora file or reduce the trace level.

-Pinkle