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...
by Vikram Khatri | Feb 10, 2014
In DB2 10.5 with default WLM configuration, you can achieve something very special that you might not have given a thought. WLM is one of my favorite topic on which I can talk non-stop for few hours. Based upon my experiences working with large customers, here is a...
by Vikram Khatri | Oct 23, 2013
One of less known but very useful feature of DB2 is the post login script after an application makes a connection. DB2 database has a configuration parameter known as CONNECT_PROC which is name of the database procedure which will be executed everytime someone...
by Vikram Khatri | Oct 9, 2013
After specifying entries in db2dsdriver.cfg, the db2cli validate -dsn >dbname> does not show that the client actually read db2dsdriver.cfg file. For example: A sample db2dsdriver.cfg file: db2psc@node01:~/pot_purescale/04application> db2cli validate -dsn psdb...
by Vikram Khatri | Aug 27, 2013
Management of my shoe-closet computer center requires that I should take some steps to protect the data by taking a backup. In last 10 years, I never took any backup and luckily I was never in the situation to have lost the data. The servers kept on running and...
by Vikram Khatri | Aug 18, 2013
Usually enterprise distributions like SLES or Redhat are slow to adopt latest in consumer products such as CUPS used for printing. The version of cups on SLES 11 SP2 is 1.3 when the latest version at the time of writing this is 1.6.2. The older version 1.2 uses older...
by Vikram Khatri | Aug 18, 2013
http://www.novell.com/support/kb/doc.php?id=7003097
by Vikram Khatri | Aug 18, 2013
In today's world, due to some dishonest populace who are like parasites living on somebody's else blood, implemenation of security comes at a heavy price and it has more problems than solutions. It is also a great business model for the companies to exploit...
by Vikram Khatri | Apr 30, 2013
When taking a DB2 backup, if you get the following error: $ db2 backup database <dbname> to /backup compress SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request...
by Vikram Khatri | Apr 26, 2013
When database is converted from circular log to archive log, it will force the backup of the database which is a good thing. But, sometime, we do not want to do it. Say, when we are in test environment like testing upgrade from DB2 ESE to DB2 pureScale. If database is...
by Vikram Khatri | Apr 22, 2013
Best practice or things that appear to work well in a two nodes cluser or a single node (just with one DB2 and a CF). The cthats subsystem handles heartbeating between nodes. When in steady state, there is a ring formed where each member is sending heartbeats to their...
by Vikram Khatri | Apr 22, 2013
For example, we have a two (or more) nodes DB2 cluster having a shared database and we want to configure Optim Perfromance Manager (OPM) for the database monitoring. The questions comes – which node should OPM connect to and what if that node is down for any...
by Vikram Khatri | Mar 13, 2013
In DB2 pureScale, when you run the command db2instance -list, it shows the DB2 pureScale topology and which member is up and running and which CF is in PRIMARY mode and which one is in PEER mode. If you want to change the role of CF from PRIMARY to PEER or from PEER...
by Vikram Khatri | Mar 11, 2013
Work Load Balancing In order to utilize DB2 automatic Work Load Balancing for JBoss application, some changes need to be made in the JBoss JDBC driver manager configuration. Myth – Most people think that work load balancing is done by the DB2 pureScale and it is...
by Vikram Khatri | Mar 4, 2013
DB2 timestamp can show micro seconds and I was trying to generate an excel report showing elapsed time between 2 DB2 timestamps and had to work a little bit to write this excel formulae. Timestamp (Cell B3) = 2013-03-04-13.38.26.677483 Timestamp (Cell C3) =...
by Vikram Khatri | Feb 20, 2013
On AIX, how to find out the uDAPL version? # lslpp -la "*udapl*" Fileset Level State Description...
by Vikram Khatri | Jan 29, 2013
In DB2 pureScale if a node goes down, it is started on another host in a light mode just to do the crash recovery. When the home host becomes available, the host should fail back to its home host seamlessly. For example: This is a sample output from the db2instance...
