topic Re: How to empty a log file in OpenVMS in Operating System - OpenVMS

How to empty a log file in OpenVMS

GS Voz y RI — Tue, 01 Mar 2005 12:22:39 GMT

How can we empty a log file? We have several big log files and need to free space on disk.

Re: How to empty a log file in OpenVMS

Volker Halle — Tue, 01 Mar 2005 12:34:15 GMT

Hi,

this depends on how your application uses that logfile.

You could create a new version of the file, then restart your application (if it keeps the file open all the time and appends to an existing logfile).

Volker.

Re: How to empty a log file in OpenVMS

Uwe Zessin — Tue, 01 Mar 2005 12:40:03 GMT

Some system log files:

For the accounting file it is:
$ SET ACCOUNTING /NEW_FILE
this opens a new version.

For the operator log it is (on a trminal):
$ REPLY /ENABLE
$ REPLY /LOG
$ REPLY /DISABLE
again, a new version is created

For the error log:
$ SET DEFAULT SYS$ERRORLOG:
$ RENAME ERRLOG.SYS ERRLOG.OLD
a new file is automatically created

I don't have a VMS system handy at the moment, someone else will come up with the command to roll over the AUDIT log...

Re: How to empty a log file in OpenVMS

Volker Halle — Tue, 01 Mar 2005 12:44:15 GMT

The command to create a new AUDIT server logfile is:

$ SET AUDIT/JOURNAL=SECURITY/THRESHOLD=WARN=200
(to reset the space monitoring threshold and create a new smaller file)

$ SET AUDIT/SERVER=NEW_LOG

Volker.

Re: How to empty a log file in OpenVMS

GS Voz y RI — Tue, 01 Mar 2005 12:47:44 GMT

One of the files we want to empty is sqlnet.log. What we need is to execute something like this (UNIX):

cp /dev/null sqlnet.log

but in VMS

Re: How to empty a log file in OpenVMS

Volker Halle — Tue, 01 Mar 2005 12:49:14 GMT

How about

$ CREATE sqlnet.log

Volker.

Re: How to empty a log file in OpenVMS

Volker Halle — Tue, 01 Mar 2005 12:51:06 GMT

or COPY NL: sqlnet.log

But it still depends on the application to re-open the file and continue to write on the new (empty) logfile.

Then you can PURGE sqlnet.log

Volker.

Re: How to empty a log file in OpenVMS

GS Voz y RI — Tue, 01 Mar 2005 12:59:16 GMT

copy nl: seems to work as expected