Hello All,   Looking for some help on how to resolve the error DB2JAVIT : RC = 9505. Then you're in luck because we have put together the following tech doc to help you with that:   Error DB2JAVIT : RC = 9505 upon opening a DB2 GUI tool   Still seeing the error or have questions about it, then please feel free to comment below.

Tags:  = rc db2javit 9505 :

We all know how important it is to have the data spread across few tablespaces in order to speed up the backup. DB2 utilizes IO parallelism during the backup by processing multiple tablespaces at the same time (BACKUP ... PARALLELISM <N>). E.g. if you would have 10 tablespaces and go with parallelism 5, DB2 will spawn 5 buffer manipulator EDUs (db2bm) that will read 5 tablespaces in parallel (with the help of prefetchers). Once given db2bm is done with a tablespace, it will pick up the next one from those, which were not backed up yet.... [More]

Tags:  db2 backup compression

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. ... [More]

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

  Are you interested in helping to shape future enhancements to IBM Support Portal, Fix Central, My notifications, Service Request, and other online tools? The IBM Electronic Support user experience team is currently recruiting clients to participate in design reviews and usability testing.  You can choose from several different opportunities to participate:   Drive requirements for the future What: Join the 2013 IBM Electronic Support Client Advisory Panel Who: Ideal for clients who support or use at least one IBM product and who... [More]

Tags:  request service feedback support portal

  We have a very good knowledge center document to follow when upgrading db2 servers in MSCS set-ups :       Upgrading DB2 servers in Microsoft Cluster Server environments                                                 ... [More]

Tags:  db2support db2luw

Once you find DB2 HADR ( High Availability Disaster Recovery ) operation is somehow slow, what's the next ? You may want to narrow down if this delay is from writing to transaction log disk subsystem or something on network communication. Here is a sample scenario. - Intermittently, the number of 'commit active' status applications spikes. - Application team reports this has very serious impact even though that status stays very short 1 second period.   ( Application processes increasing with High CPU consumption due to... [More]

Tags:  hadr performance

This is a problem I met last year, I just get the time to write it down, hope it helps! I have a pureScale with 8 members, say member 0,1,2,3,4,5,6,7,  and I have some applications running on a web application server will access a database on this pureScale,  the application server manages a database connection pool, and the applications share the database connections within the pool. The design of the connection pool is setting connection count to 1000, and workload should be evenly distributed to 8 members.  I know workload... [More]

Tags:  round-robin purescale maxtransportobjects wlb

Have you ever been curious about the way to verify if a LOB column I/O with a table uses file system cache or NOT ? There are common two perception points regarding LOB. 1. LOB uses file system cache. That means it does NOT utilise the buffer pool. 2. By setting with inline LOB, it uses buffer pool.. Above things may or may not be true. For example, one of my friend had the following doubt. "Does  LOB I/O utilize O/S File system caching even though tablespace ... [More]

Tags:  db2 lob performance

Hello! We often get a question from customers "How to find the version of DB2 JDBC driver they are using?" Answer is simple, you need to run below command:   The following command will retrieve the JCC driver version if executed from the command line: java com.ibm.db2.jcc.DB2Jcc -version Or for drivers that are not yet installed: java -cp ./db2jcc.jar com.ibm.db2.jcc.DB2Jcc -version   For eg.   Once you find the DB2 JDBC driver version, next question will be, "What DB2 release it belongs to?" We have... [More]

Tags:  driver db2_techtip 75_db2demystify jdbc version