Administration Getting Started

Appendix A. Working with Scripts and Jobs

This chapter introduces you to the Command Center, the Script Center, and the Journal, and describes how you can use them together. They are all accessible from the Control Center.

The Command Center and Script Center provide interactive windows where you can:

• Execute SQL statement and DB2 commands. From the Script Center, you can execute operating system commands from a script by doing the following:
  1. Select Script -> New. The New Command Script window opens.
  2. For Script Type select the OS command radio button.
  From the Command Center, you can execute operating system commands by preceding them with an exclamation mark (!).

• See the execution result of one or many SQL statements and DB2 commands in a result window. You can scroll through the results and generate a report of the execution.

• Create, save, execute, and schedule command scripts.

• Get quick access to the DB2 administration tools such as the Control Center from the main toolbar.

• From the Command Center, see the access plan and statistics associated with an SQL statement before execution. You do this by selecting the Access plan menu item, or the Access Plan page, or selecting the Create access plan icon in the toolbar.

[ DB2 List of Books | Search the DB2 Books ]