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.
| Non-Production | Windows (DEV) | Production |
Database Tasks | |||
✓ | ✓ | ✓ | |
✓ | Under Investigation | Investigating | |
✓ | ✓ | Investigating | |
✓ | Under Investigation | Investigating | |
✓ | ✓ | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | ✓ | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | ✓ | ✓ | |
Application Tasks | |||
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
✓ | Under Investigation | ✓ | |
Compliance Reports (Applicable to All Environments) | |||
✓ | ✓ | ✓ |
Database Tasks
Backup Database
...
This service completes the following steps: Complete a full an incremental online backup (counts as one of 3 backups) of source system's database. Copies the database to the target system, stops the target system, completes a full online offline backup of the target system, restores the database taken from the source system, executes the previously defined post-processing script and starts the target system.
Both DB2 and Oracle databases are supported. Oracle database support is limited to scenarios where where the source database server or target database server are not shared between multiple assets.
Allows customer to supply a new or updated post-processing script as an attachment to the task. To retrieve a copy of the existing post-processing script or a template (if one does not exist), run the UPLOAD POST BACKFLOW SCRIPT task (see below).
...
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.
...
This task will collect Application Server logs from the target environment’s application server(s) and upload the logs to the ECuRep (IBM Support) server.
The requested log start date/time and end date/time can be a maximum of 24 hours apart. You can submit multiple service requests if a log coverage of more than 24 hours is needed.
JVM Dump Collection
...
This task initiates a JVM heap dump. You can either select all servers by checking the “all servers” box, or specify JVMs by listing their individual names separated by commas:
For example: MXServer01,MXServer02The heap dumps are zipped and copied to the corresponding SFTP site. Only one copy of the heap dump zip file will be retained on the SFTP site. Subsequent runs of this task will remove any existing zip files.
...