If service is required

During service activities, every attempt is made to keep the appliance running. However, certain repair procedures require the database to be stopped, restarted, or rebalanced. Such database actions should be performed by a customer, hence it is necessary that a customer representative be available during service activities. Without a customer representative available, the IBM® service personnel may have to perform these actions, which results in the database being unavailable to users, and possible disruption to running queries.

Following is a list of replacement procedures for which prerequisite steps must be performed by a customer representative ahead of the service works. Note that scheduling a maintenance window might be required.

Table 1. Prerequisite tasks to be performed by a customer
Service type Prerequisite tasks
All service on system nodes (except power supplies, fans and disk drives), for instance:
  • PCI Adapter (FC or Combo NIC)
  • RAID Controler
  • DIMM
  • CMOS battery
  • VPD card
  • Processor
  • Disk drive backplane
  • Planar (server backplane)
 Disable the node by executing the following steps:
  1. Check the state of the appliance as appliance administrator apuser: 
    [apuser@node~]# ap state
  2. If the appliance state is Inactive, no action is required.
  3. If the appliance state is Ready, check the states of the nodes: 
    [apuser@node~]# ap node
+-----------------+---------+-----------+-----------+
| Node | State | Monitored | Is Master |
+-----------------+---------+-----------+-----------+
| hadomain1.node1 | ENABLED | YES | YES |
| hadomain1.node2 | ENABLED | YES | NO |
| hadomain1.node3 | ENABLED | YES | NO |
+-----------------+---------+-----------+-----------+
  4. If the node requiring service is ENABLED, disable the node by running: 
    [apuser@node~]# ap node disable hadomain1.nodex
    where x is the number of the node being serviced.

    This command stops the IBM Db2® warehouse container on the selected node and rebalances Multiple Logical Nodes (MLNs) on the remaining nodes.

    When prompted, confirm the action by typing y.

Canister replacement

Midplane replacement

Power® interposer board replacement

LED card replacement

 Shut down the appliance by executing the following steps:
  1. Check the state of the appliance as apuser: 
    [apuser@node~# ap state
  2. If the appliance state is Inactive, no action is required.
  3. If the appliance state is Ready, stop IBM Db2 Warehouse: 
    [apuser@node~]# apstop
  4. Ensure that no programs are running: 
    [apuser@node~]# ap sw
    There must be no applications active. 
    +-----------------------+--------------------+--------+----------------------+
| Name | Location | Status | Version |
+-----------------------+--------------------+--------+----------------------+
| Appliance Application | db2 | STOPPED | 11.1.9.0_s1704260100 |
+-----------------------+--------------------+--------+----------------------+

Following are the tasks that need to be performed by the customer representative after the service work is finished.

Table 2. Follow-up tasks performed by a customer
Service type Follow-up tasks
All service on system nodes (except power supplies, fans and disk drives), such as:
  • PCI Adapter (FC or Combo NIC)
  • RAID Controler
  • DIMM
  • CMOS battery
  • VPD card
  • Processor
  • Disk drive backplane
  • Planar (server backplane)
 When you are ready, run the following command: 
[apuser@node~]# ap node rebalance
When prompted, confirm the action by typing y.

Canister replacement

Midplane replacement

Power interposer board replacement

LED card replacement

 When you are ready, use the following command to start the Db2 Warehouse application: 
[root@node~]# apstart