Issue: NullPointerException was thrown when one of our customers tried to load latest DB2 JCC driver (db2jcc.jar - V10.1 and above) using a custom class loader ( like open source module NestedJarClassLoader). The same worked while loading old DB2 V8.2 db2jcc.jar driver (2.11.24). Here is the error stack: Caused by: java.lang.NullPointerException         at com.ibm.db2.jcc.am.md.run(md.java:49)         at java.security.AccessController.doPrivileged(Native Method)... [More]

Tags:  db2_advice 75_db2demystif

How do you keep the result of overall SQL performance data in your DB2 system ? I could see many DB2 mates have used our long last friend DB2 dynamic SQL snapshot for checking performance statistics of SQL statements. And we have another friend 'mon_get_pkg_cache_stmt' who shows more performance aspect especially in elapsed time perspective. Some smart DBAs regularly gather this result and keep in a table to see the changes and trend. It's also good idea to load the data into other database if you have. Somebody call it as... [More]

Tags:  ibm-blog performance mon_get_pkg_cache_stmt

The pureScale client affinity feature allows client specification of a single primary server and failover sequence to alternate servers and all rerouting is controlled by the client driver. That means all you have to do is basically configuring the right DB2 JCC JDBC properties in your WAS(Web Application Server) side. However the reality is many people has difficulty about how to have right setting about pureScale client affinity during configuration and failover test. ​For having right configuration for them, some people take over 2 weeks or... [More]

Tags:  jcc tomcat purescale ibm-blog clientaffinity db2_techtip jdbc db2 50_db2_nuggets

Continuous availibility is the concept that enables 24/7 access to IT-enabled business functions, processes and applications. And minimizing planned downtime is what business and IT departments consider seriously nowadays. Especially, minimizing and setting the appropriate downtime is a bit challenging decision in case of DB2 version upgrade or migration to another system,  because we also need to consider the time for getting back to original system in preparation for any unexpected problem after the planned change works.  I would like to give... [More]

Tags:  upgrade ibm-blog migration db2_advice server 50_db2_nuggets irs db2 infosphere replication

One of the most valued assets that IBM Information Management Support has... is YOU!   You provide valuable feedback to our technical support process through your insights when talking with us, providing feedback to our documentation, engaging with us here, on Facebook, or on Twitter, or anytime and any way you interact with IBM.  For that, thank you!     Now, we're "test piloting" a new way for you to engage, called "discuss on developerWorks". We've targeted a select set of technical support... [More]

First off, Happy New Year!   I hope 2011 finds you and yours safe and well. Second, we want to share a compliment we are very proud of:   In December, we posted a video to help explain how IM Support uses Knowledge-Centered Support (KCS) and some of  the benefits:  http://ow.ly/3yKEO David Kay, one of the leading voices in KM and KCS, just posted a "pat on the back" for the video in his blog: Communicating KM to Customers: IBM does it right       We're still maturing as an organization using KCS, but hopefully you've seen... [More]

Tags:  kay david support kcs

It is recommended to run db2rbind during maintenance time when there is no application connecting to the database. In case there are applications running while db2rbind is running, you may see the following symptom depending on the timing: - db2rbind returns lock timeout and fails to bind some packages - applications may return SQL error -518 (SQL0518N) - applications may return SQL error -514 (SQL0514N)   The following is an example of application receives error SQLCODE=-518: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error:... [More]

When you put pureScale hosts into maintenance mode, don't be surprised with the following message. You may see this if you are on DB2 V11.1 Mod Pack 3 Fixpack 3.   # /opt/IBM/DB2/V11.1.3/bin/db2cluster -cm -enter -maintenance   "The DB2INSTANCE environment variable has not been set. Set the DB2INSTANCE environment variable to the instance name and re-issue the command. A diagnostic log has been saved to '/tmp/ibm.db2.cluster.xxxxx'.   Starting from V11.1.3.3, when a specific host wants to enter -cm maintenance mode with "... [More]

Tags:  ibm-blog purescale maintenance

The PRUNE HISTORY command is very useful tool to remove the unnecessary archive log files, maintaining the "restore set" which is the most recent full database backup including any restores of that backup image. This document illustrates the PRUNE HISTORY command with the command line examples.   To see working of PRUNE HISTORY command, the following setup is done to make some archvive log files with backup images.(For the script detail, please check ref 1) # 1. 200 row insert # 2. tablespace USERSPACE1 backup # 3. 200... [More]