DB2 pureScale Install Problem Determination

RSCT License Issue $ db2start 128 SQL1677N  DB2START or DB2STOP processing failed due to a DB2 cluster services error DATA #9 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 3508 bytes commandResponse->callRC: 0x00000000 commandResponse->output:...

DB2 purescale Install GPL Error

GPL Compile Problem When you try to install DB2 pureScale on Linux platform (RHEL or SLES), you may receive the error. ERROR: A missing Linux package is preventing the compilation of the IBM General Parallel File System (GPFS) Portability Layer (GPL) module. The...

db2start add member fails

If you try to add a member to a running cluster, you may get the following db2start error. ERROR: The "db2start add MEMBER 2 hostname node04.purescale.ibm.local netname node04.purescale.ibm.local port 0 -iupdt" command failed with the return code: "55", and following...

Install Dropline Neu! Icons in CentOS 7.2

One of my most favorite icons on GNOME has been Dropline Neu! for many years and I still have a copy of it since 2006. It is now hard to find. Download ICON-DroplineNeu.tar.bz2 And, copy to /tmp directory # cd /usr/share/icons # tar xvfj /tmp/ICON-DroplineNeu.tar.bz2...

Drop a member in DB2 pureScale by Force

If you need to drop a member in DB2 pureScale, the db2iupdt process requires that member to be available during the drop process. But, the actual world is more cruel than what db2iupdt thinks. For example: If you have a 3 member cluster and someone moved / migrated...

Enable Fast I/O Fencing Scipt for Linux

If you install DB2 pureScale in Linux, the Fast I/O Fencing does not get enabled automatically. If you refer to Knowledge Center for DB2, you will find number of steps to enable fast I/O fencing. After DB2 instance is created and databases are created, I usually run...

Find out Slot number of PCI Card

Use dmidecode -t slot to find out the slot numbers that are in USE and the Bus Address. Use that bus address in lspci -s <busaddress> to find out what is in the slot. For example: I have NIC in slot-7, Q-Logic in Slot – 2 and Mellanox in Slot – 3. I...

WWNN and WWPN of FC Card

A FC card has a World Wide Name (WWN). Card may have two ports and each port is known as by its World Wide Port Name (WWPN). I seemed to have confused myself with WWN, WWNN and WWPN and didn’t understand the difference as this is not my topic. In the example...

DB2 pureScale rebuild TSA Resources

In order to be a successful DB2 pureScale DBA, one has to learn how to diagnose and fix TSA. Though, this is not necessary but it will help to fix cluster in case you run into situation when you get messages like "SQL1517N db2start failed because the cluster manager...

TCPIP Tuning at VIOS and AIX

This is for for my own reference and does not constitute any recommendations. VIO Server Changes Verify flow_control is set to yes – This is the default setting lsattr –El ent0 | grep flow and lsattr –El ent1 | grep flow chdev -l ent0 –a flow_control=yes chdev...

Avoid Tie Breaker Disk

It is possible to avoid tie breaker disk in pureScale and HADR just by following a simple majority rule. You need a tie breaker disk in pureScale and HADR if number of hosts are even. So, in HADR you have only two nodes so your need a tie breaker disk. But, even in...

RSCT Commands – Cheat Sheet

Reset RSCT Configuration (completely remove all cluster configuration) # /usr/sbin/rsct/install/bin/recfgct Change the tie-breaker # chrsrc -c IBM.PeerNode OpQuorumTieBreaker='Operator' Find out which tie-breaker is in use # lsrsrc -c IBM.PeerNode OpQuorumTieBreaker...

Clear Reservations from Tie-Breaker

Read reservations: /usr/bin/sg_persist --in --no-inquiry --read-reservation --device=/dev/sdc /usr/bin/sg_persist --in --no-inquiry --read-key --device=/dev/sdc Prepare for cancel: /usr/bin/sg_persist --out --no-inquiry --register --param-sark=0x1 --device=/dev/sdc...

Tie-Breaker Disk for HADR or pureScale

I had documented same for zLinux here http://www.zinox.com/archives/182 When you use a tie-breaker disk in pureScale or in HADR, it must be Write Exclusive Registrants Only. It is a good idea to test if the tie-breaker disk is working as expected or not. The...

GPFS, RSCT and TSA Version Info.

RSCT Version [root@node02 iscsi]# /usr/sbin/rsct/install/bin/ctversion -b rliss005a 3.1.5.5 14182.07:51:59 TSA Version [root@node02 iscsi]# /usr/sbin/rsct/bin/samversion rsa322s008a 3.2.2.8 Jul 18 2014 10:02:26 # lsrsrc -Ab -c IBM.CHARMControl # lssamctrl GPFS Version...

DB2 pureScale – shared disks using SCSI-3 PR

How to find if the shared disks being used for pureScale are SCSI-3 PR capable or not after creation of pureScale install. # /usr/lpp/mmfs/bin/mmlsconfig minReleaseLevel,usePersistentReserve minReleaseLevel 3.5.0.11 usePersistentReserve no  ...

Clean-up pureScale

If you want to clean the system having pureScale or want to drop pureScale instancefor installing a fresh instance of pureScale, follow on: Obviously, you want to follow the steps given in DB2 Knowledge Center first. If you have a working pureScale install where you...

DB2 pureScale – Online Rolling update

These note are valid only on AIX. Please note the following: There are two types of updates – System update (applying eFixes or Service Packs on AIX). If you are applying the system packs or efixes on a pureScale host, please call the DBAs and work in...

DB2 Table Spaces – When to use File System Caching

In DB2, the file system caching is turned on by default for SYSTEM or USER TEMPORARY table spaces but turned off other DMS. If you have LOBS (CLOB, BLOB or XML) in a table, try to follow these guidelines: Put LOBS in a separate table space. Use ADMIN_MOVE_TABLE to do...