by Vikram Khatri | Apr 18, 2016
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...
by Vikram Khatri | Apr 11, 2016
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...
by Vikram Khatri | Apr 11, 2016
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 ...
by Vikram Khatri | Apr 11, 2016
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...
by Vikram Khatri | Apr 10, 2016
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...
by Vikram Khatri | Apr 10, 2016
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...
by Vikram Khatri | Apr 10, 2016
When adding a member through db2iupdt command, you may get an error something like this: ERROR: The “db2start add MEMBER 1 hostname hostc.zinox.com netname hostc-r.zinox.com port 0 -iupdt” command failed with the return code: “4”, and following...
by Vikram Khatri | Dec 22, 2015
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...
by Vikram Khatri | Sep 18, 2015
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...
by Vikram Khatri | Aug 24, 2015
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...
by Vikram Khatri | Mar 4, 2015
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...
by Vikram Khatri | Oct 11, 2014
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...
by Vikram Khatri | Aug 8, 2014
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...
by Vikram Khatri | Apr 15, 2014
These instructions are for changing the IP address in a pureScale cluster. Please remember that the IP address can be changed easily for DB2 but it is RSCT and GPFS that requires special handling to change the IP address. You change the IP address one by one in a...
by Vikram Khatri | Mar 13, 2014
I started using Google from very early on (Since Feb 1998) and since then it has remained my home page. Needless to say that I now consider Google as God since it knows everything. In my day-to-day conversation, I ask people “Did you ask Google God?” So...
by Vikram Khatri | Mar 11, 2014
Let us understand client affinity and automatic client reroute. For example: We have 3 members in a DB2 pureScale cluster and I have one application that connects to one member from any application server. The same application connects to the second member from...
by Vikram Khatri | Mar 11, 2014
Wouldn’t it be nice to do some Java testing without writing a line of code? For the following to work, it is necessary that db2jcc.jar and db2jcc_license_cu.jar are on the CLASSPATH. If you login as db2 instance user, these jar files should be in the CLASSPATH...
by Vikram Khatri | Mar 6, 2014
Say for example, you are creating a file system using db2clutser command in DB2 pureScale and it fails with this error: # db2cluster -cfs -create -filesystem db2data1 -disk /dev/dm-2 -mount /db2data/data1 There was an internal db2cluster error. Refer to the diagnostic...
by Vikram Khatri | Feb 23, 2014
Additional Packages After installation of basic Redhat 6.2 OS, the following additional components are required. # yum install perftest # yum install sysfsutils # yum install kernel-devel # yum install compat-libstdc++ # yum install tcl # yum install tk # yum install...
by Vikram Khatri | Feb 16, 2014
I downloaded Informix 12.10.FC2 on my Linux SLES 11 SP3 using part number CIM0GEN. After unzipping of the Informix media in /tmp/informix, I see the following files. -rw-r–r– 1 root bin 10201 Aug 30 00:53 bundle.properties drwxr-xr-x 3 root bin 4096 Aug 30...