How to run a Database Reorganization in Background?

[Former Member]

We are using a Windows Platform and we would like to run database reorganization in Background. How will we do this? Via a command? Can we do it via BRTOOLS? Can we schedule the running of Database reorganization via BRTOOLS? DB13 is out of the question so no need to indicate the solution to run the Database Reorganization in Background via DB13. Kindly advice. Thanks.

[stefan_koehler · Accepted solution]

Hello Jett,

you can run your reorg via BR*Tools.

You can schedule the BR*Tools via the windows task scheduler.. but in my opinion you should monitor the reorg and make it manually.

A database reorg should be tested and validated in a QA system to verify possible performance issues.

If you can reorg your whole database depends on different factors and restricitions (LONG fields, and so on).

Why do you want to do this in background? A reorg is a very rare activity..

Regards

Stefan

[Former Member · Accepted solution]

Actually, we do know the various approaches and the Hows on implementing them, we just need the how with regards to running DB reorganization in Background.

For instance, we will schedule the database reorganization on the evening, since there may come a time when there is nobody available at a certain schedule, we need to schedule it in background so that we could still meet the schedule without anybody, personally, checking on it. Another advantage for it is when there are very large objects that usually took lots of time to finish, we usually let it rest in weekends wherein there is a possibilty that no one is available, we could just schedule it in background without having the problems with regards to timeout in dialog sessions. Also, usually, due to location constraints, we cannot personally access the application server thus, we use remote desktop sessions so as to access the servers. Background session can prevent the risk of having failures with regards to network issues or any other factors that might affect the result of the continuity of the reorganization thus, we need way/s on how to implement it in background session.

Do anyone have a command in running brtools (specifically for reorganization) to run in background?

[lbreddemann · Accepted solution]

Hi Jett,

there is no scheduling feature built into the BR*Tools.

So you will have to use the scheduling features of the operating system (e.g. cron job).

As you'll probably know the brtools can be run without user interaction.

Just use the BRSPACE command line created by the BRTOOLS to run the reorganisation.

To avoid the user interaction use the -c force (confirm) option.

KR Lars

[former_member204746 · Accepted solution]

if on Unix, use crontab

if on Windows, use scheduled tasks.

command should look like this one for an online reorg:

brspace -u system/your_password -c force -f tbreorg -t "*" -s PSAPCLUD -n PSAPCLU2D -i PSAPCLU2I -p 1 -e 1