Working with jobs and scripts

  • Command Center - Working With
  • Executing commands in sequence
  • Creating and saving a command script
  • Running an existing command script on the Script page of the Command Center notebook
  • Executing single DB2 commands or SQL statements
  • Running an existing command script on the Interactive page of the Command Center notebook
  • Scheduling a job
  • Viewing the results of a query.
  • Saving query results.
  • Viewing a graphical representation of the Access Plan for an explained SQL statement.
  • Selecting a database.
  • Creating an access plan
  • Changing the options in the Command Center notebook
  • Script Center - Working With
  • Creating a command script
  • Running a saved command script now
  • Scheduling a saved command script
  • Editing a saved command script
  • Copying a saved command script
  • Deleting a saved command script
  • Journal - Working With
  • Running a job now
  • Showing the results of a job
  • Showing the contents of a script
  • Enabling or disabling a job
  • Rescheduling a job
  • Deleting a job
  • Restoring a database
  • Restoring to a new database
  • Restoring the recovery history
  • Viewing table space information
  • Pruning a log
  • Scheduler - Working With
  • Scheduling a single job
  • Scheduling a recurring job
  • Scheduling a job to run twice a month
  • Using invalid dates when scheduling a job
  • Defining completion actions

    •