IBM Support

Configure DB2 instance to start automatically at boot time

Question & Answer


Question

How can a DB2 instance (needed by a Tivoli Workload Scheduler (TWS) Master or Backup Master) be set to start automatically at boot time?

Cause

A Tivoli Workload Scheduler (TWS) Master level instance requires access to a datasource. If the DB2 instance that the TWS WebSphere instance connects to is not started, then commands such as composer, planman, and optman will fail, access attempts to TWS database objects through TDWC or JSC will fail, and TDWB objects and status information will be inaccessible. In addition, the FINAL jobstream jobs will ABEND because MAKEPLAN requires access to TWS database objects.

Answer

To determine if an instance is enabled to automatically start at boot time, execute this command logged in as the instance owner:

db2set DB2AUTOSTART -i db2inst1

A return of "YES" means the instance is set to start automatically. Otherwise it is not set.

To configure the instance to start automatically at boot:

db2iauto -on <instance name>

In the instance file <InstanceHome>/sqllib/profile.env there will be an entry like this:

DB2AUTOSTART='YES'

If there is an issue starting the DB2 instance, take a look at the following file:

<InstanceHome>/sqllib/db2dump/db2diag.log

[{"Product":{"code":"SSGSPN","label":"IBM Workload Scheduler"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Component":"DB2","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.5;8.5.1;8.6;9.1;9.2;9.3","Edition":"","Line of Business":{"code":"LOB15","label":"Integration"}}]

Product Synonym

Maestro;TWS;TWA

Document Information

Modified date:
17 June 2018

UID

swg21505374