Cleanup logs issue using BRTOOLS

[Former Member]

Hey experts,

I am facing an issue when using BRTOOLS with command prompt for cleanup job.

When I run the job, it stays at BR0259I Program execution will be continued... and nothing happens after that.

It stays there forever until I kill it and in the logs, it stays the same.

Any help on this regard would be greatly appreciated.

Regards.

[Former Member]

hello

So the job of cleaning is not completing you mean.

If you are having large amount of logs and when one part of action is completed and BRtools switch to next one this statement will be written that its doing next set of action.

This is normal statement of BRtools when it starts executing the task.

Regards

Vivek

[Former Member]

Hey Vivek,

Thanks for your reply.

It is stuck on this statement for more than a day now and it seems nothing is deleted till now.

While the same thing is working on remaining servers that we have on our environment.

I am completely baffled. The following is the log from the .cln file.

BR0280I BRCONNECT time stamp: 2011-06-05 08.44.47

BR0813I Schema owners found in database XID: SAPSR3,* SAPSR3DB%*

BR0280I BRCONNECT time stamp: 2011-06-05 08.44.47

BR0807I Name of database instance: XID

BR0808I BRCONNECT action ID: cegaycvb

BR0809I BRCONNECT function ID: cln

BR0810I BRCONNECT function: cleanup

BR0926I BRARCHIVE log files will be deleted from directory: E:\oracle\XID\saparch

BR0926I BRBACKUP log files will be deleted from directory: E:\oracle\XID\sapbackup

BR0926I BRCONNECT log files will be deleted from directory: E:\oracle\XID\sapcheck

BR0926I BRRESTORE log files will be deleted from directory: E:\oracle\XID\sapbackup

BR0926I BRRECOVER log files will be deleted from directory: E:\oracle\XID\sapbackup

BR0926I BRSPACE log files will be deleted from directory: E:\oracle\XID\sapreorg

BR0926I SAPDBA log files will be deleted from directories:

E:\oracle\XID\sapreorg

E:\oracle\XID\sapcheck

BR0927I Trace files will be deleted from directories:

E:\ORACLE\XID\SAPTRACE\USERTRACE

E:\ORACLE\XID\SAPTRACE\BACKGROUND

E:\oracle\XID\saptrace\background

BR0928I Database log records will be deleted from tables of owner SAPSR3:

SDBAH, SDBAD, DBABARL, DBABD, DBABL, DBADFL, DBAEXTL, DBAML, DBAOBJL, DBAOPTL, DBAPHAL, DBARCL, DBAREOL, DBASPAL, DBATL, DBMSGORA

BR0928I Database log records will be deleted from tables of owner SAPSR3DB:

SDBAH, SDBAD

BR0280I BRCONNECT time stamp: 2011-06-05 08.44.47

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

BR0280I BRCONNECT time stamp: 2011-06-05 08.44.51

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

[Former Member]

Hello Naga,

can you check anything is being written into alert log once if you have any alerts.

Regards

Vivek

[Former Member]

Hey Vivek,

I checked the alert_XID.log and I could not find any alerts in the file. Is there any specific file that I need to look for?

Regards

[Former Member]

Have you tried to schedule the cleanup job from DB13?

Also whats your brtools version? if possible try to upgrade, (no downtime require, just make sure no br* process are running)

[Former Member]

Yes Sunil, I have tried using DB13 too. Same problem. BRTools is 7.00 and our NW is 7.01.

The weird thing is that this job runs on all the remaining servers merrily except for this one.

[Former Member]

Anyone to help please?

[Former Member]

Hi Satya,

please check free space in sapreorg and all your tablespaces ...

Thanks,

Deepthi

[TomCenens]

Hello Satya

You can update BR*Tools to 7.20 or even higher depending on prerequisites mentioned in the SAP Notes.

I would surely recommend it because there are features in 7.20 that are not available in 7.00 such as automatic calculation of system/dictionary statistics every X days along with regular statistics run.

Kind regards

Tom