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

X Display Issues as sudo

When you do sudo to another user, you may have to do extra things to get X display working or any GUI working. Many organizations do not allow root login so X window cookie does not get generated and hence GUI does not work. I prayed to Google God for solutions and...

DB2 10.5 pureScale TSA Recovery

A third party single sign-on application was installed on two nodes of db2 cluster having 2 CF and 4 members. The pureScale cluster started showing signs of trouble and naively, we did not think the impact of the software installed. This single sign-on software (as we...

Client Connection Attributes and WLM

Client Connection Attributes When you establish connection to DB2 using Java programs, you need 5 minimum attributes DB2 server name or IP address Port Number (socket connection) Database name User ID Password This could be defined as a URL in the Java program such...

Change mount point in pureScale Cluster

When we install DB2 instance as a pureScale, we can specify the name of the mount point by using option instance_shared_mount. If we do not use this option, the mount point name is generated by the db2icrt command as /dv2sd_<timestamp> and this may not be the...

Monitor Crash Recovery Script

If DB2 was processing a very long running transaction (say updating millions of rows) and for some reason like power failure, server goes down. When you start the server and activate the database, it may take a long time as it needs to do the crash recovery. This is...

How to find out LOG HOG

If you run into LOG FULL condition in DB2 with SQL error code: SQL0964C, you need to increase the size of either of the following: LOGPRIMARY, LOGSECOND or LOGFILSZ. So, you change that even after that you again run into LOG FULL condition. What is happening? You can...