First of all, take the advice from Stefan regarding silver bullet. In my opinion it is very seldom necessary to reorg a table periodically. All you do is adding work to the database.
Second again, i would prefer a simple cronjob or scheduled task, we do our stuff that way.
Third i think it is possible to schedule tasks with BRStudio, but i don't know anybody who ever did this. Does the BRStudio even still exist?
But i did not post to repeat stuff already said. Now i am going to tell you how to schedule the reorgs in DB13. One warning though, this is not official and quite dirty. You will have to check/redo the work after an upgrade/kernel patch. Use at your own risk!
My idea was to change the options of one of the unused commands (Initialize Tape) in DB13 to do a brspace tbreorg. In my example i did a reorg on tables T000 and T001. This is how you do it:
However yes you can schedule it by running the command line tool brspace with force option via DB13, crontab or any other scheduler. You can copy and paste the brspace call from your reorg log file and extend it with the force option.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.