Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Backup Database

 ✓

 ✓

Restore Database

 ✓

Under Investigation

Investigating

Backflow Database

 ✓

Investigating

Upload Post Backflow Script

 ✓

Under Investigation

Investigating

List Available Backups

 ✓

 ✓

Retrieve Backup History

 ✓

Under Investigation

 ✓

Run SQL

 ✓

Run REORG/RunStats

 ✓

Under Investigation

Export Maximo Database

 ✓

Under Investigation

 ✓

List Long Running Queries

 Application Tasks

Start Application Server

  ✓

Under Investigation

 ✓

Stop Application Server

 ✓ 

Under Investigation

 ✓

Restart Application Server

 ✓ 

Under Investigation

 ✓

Turn Admin Mode On

 ✓ 

Under Investigation

 ✓

Turn Admin Mode Off

 ✓ 

Under Investigation

 ✓

Run DB Config

 ✓ 

Under Investigation

Collect Application Server Logs

 ✓ 

Under Investigation

 ✓

JVM Dump Collection

 ✓ 

Under Investigation

 ✓

Compliance Reports (Applicable to All Environments)

Request IBM Cloud SOC2 Type II Report


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,MXServer02

  • The 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.

...