Page Comparison

Tasks currently supported in the self service portal are shown in the table below. Tasks in green are currently available. Jump to the description of a task by clicking on it. Customers will receive email notification when tasks are started and when they are completed.

Please note:
Production (PROD) environments are not available in the Self Service Portal during the annual change/freeze period.

Database Tasks

Backup Database

...

• The existing action “RUN OFFLINE DB REORG AND RUNSTATS” has been deprecated. Action “DB2 REORG AND RUNSTATS” should be selected instead.

• This action runs one of the following 3 2 operations depending on user selection

  • Runstats only operation to improve SQL performance. This option updates statistics in the system catalog about tables, view, and indexes. DB2’s query optimizer uses these statistics to improve query performance.  This is the default operation. Offine reorganization of tablespaces along with runstats operation for the target asset to improve SQL performance and reclaim fragmented disk space. Please note, environment will be unavailable and depending on the size of the database this task may take up to several hours complete. Email updates on task progress are provided every 30 minutes. 

  • Online reorganization of tablespaces along with runstats operation for the target asset to improve SQL performance and reclaim fragmented disk space.  The environment is not stopped for this option. Email updates on task progress are provided every 30 minutes.

• Note: Most cases require only the Runstats operation. Reorganization of tablespaces need only be run if a significant amount of data has been deleted from the database since the last tablespace reorganization.

...