Scripts for offline scheduling

With Optim Database Administrator, you can save the administrative commands to a script that can be run directly from the data server.

As a database administrator, you might want to schedule administrative commands to be run offline on the data server. For example, a common practice is to run scripts in the middle of the night or on a production server that other products cannot connect to.

The Save button in the Command section of each task assistant lets you save the commands to a script. When you click Save, the commands are displayed in the Save the Commands to a Script window. The commands are modified as needed so that they can be run from a data server. In the dialog window, you can edit the commands, including any comments that have been inserted, and specify the file name, path, and location for saving the script. You can save the script to the data server file system, which may be remote, or to the local file system.

Tip: The Secure Shell (SSH) protocol must be set up to browse for and save files to a remote server on a Windows operating system. If this protocol is not set up, you can save the script to the local server and then manually transfer the file by using a file transfer mechanism, such as FTP.

You can run the scripts or schedule them to run in batches on the server through the DB2 Command Line Processor (CLP) shell interface.


Feedback