How to clear log over 2 gigabyte limit

[dufflbag]

I have a log file that reached the 2 gigabyte limit.
Director is unable to clear the log.
When I tried

Code: Select all

DELETE FROM RT_LOG1360 WHERE CAST(@ID AS VARCHAR) NOT LIKE '//%';

in Administrator I got the following error:

Code: Select all

FATAL: Cannot write to transaction cache file.

What would be the bad consequences of trying CLEAR.FILE?
Can you suggest any other way to clear the file?

Thank you for your help.

Doug

P.S. The user in question has been told to run the job in the future only from Director, which has the default setting to abort the job after fifty (50) warnings.

The sizes of the files in RT_LOG1360 are:

Code: Select all

DATA.30 = 2164684800
OVER.30 =  560062464

[ray.wurlod]

Do you have transaction logging enabled (is the parameter TXMODE in uvconfig set to 1)?

The SQL DELETE statement would probably create too big a transaction in any case; the maximum size of a transaction within DataStage is set by other uvconfig paramters, such as LOGBLSZ and LOGBLNUM. This is moot if TXMODE is 0.

CLEAR.FILE is about your only option. You will lose your log purge settings for that job, so would need to reinstate them were you using job-specific purge parameters.