Part of the IBM Analytics family, focused on Analytic Platform product support. This blog is administered by Andrew McCarl (amccarl) and Kate Nichols (KateDawson), and follows the IBM Social Computing Guidelines.
Most default installations of DB2 when bundled with other products lays out the database and storage spaces in its most basic form. Usually it has USERSPACE1 where all of the data are stored by default. Over time as the data grows your so does the time it takes to backup your database bringing it to unacceptable levels.
It has also been observed that in such situations a restore operation of the same database completes in a fraction of the time. To explain this phenomenon it is important to understand the Buffer Manipulator (BM).
Today we'd like to share a very important reminder for any of our clients running DB2 version 9.5. You should be aware that DB2 version 9.5 will reach End of Support on April 30, 2015.
Please see our DB2 EOS Technote , for answers and guidance on topics including:
How do I purchase a Support Extension?
Is there information to help me upgrade?
What DB2 9.5 servers are affected?
What if I have a special build or an older fix pack on DB2 9.5? Am I still supported?
I am using DB2 9.5 as... [More]
Recently worked on an issue with DB2 Fault Monitor (FM) process failing to start on a Linux RHEL 6 platform. After following the steps in the technical note below:
the DB2 Fault Monitor process was failing with the following message :
# su - db2inst1
$ . ./sqllib/db2profile
$ db2fm -s -S
Gcf module 'fault monitor' is INSTALLED PROPERLY but NOT ALIVE
Gcf module '/opt/IBM/DB2/lib64/libdb2gcf.so' is INSTALLED PROPERLY but NOT ALIVE
Consider the following scenario, in a DB2 HADR configuration using ASYNC mode. Presently,the log files were extracted from TSM to a local file system on the standby server. Standby database was deactivated and re-activated causing the standby to go into LocalCatchUp state. However, its unable to read the local log file because its considered as a "stale" file and the standby re-enters a RemoteCatchUp state. This process was repeated two to three times and the standby fails to read the log file and switch HADR to RemoteCatchUp... [More]
We often deal with PMRs on "SQL0805N Package not found" error and get questions about DB2 Packages from customers.
We do have lot of technotes and white papers on DB2 packages. I just wanted to consolidate all the information and give you a quick overview of DB2 CLI packages and help you to solve SQL0805N errors.
Packages : Packages in DB2 are control-structure database objects that contain executable forms of SQL statements or placement holders for executable forms or access plans.
Section: A dynamic section... [More]
Here is a simple DB2 command which will display the DB2 products that are installed on the system:
db2ls - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems.
db2pd is a very powerful tool which can be used for troubleshooting many complex issue in DB2 like - high memory usage, locking issues, HADR, and collecting various statistics. It can also be used to find out a simple thing like how long the instance has been up.
db2pd with a '-' option displays the uptime for an instance. It displays the number of days and hours the instance has been running. No database connection is required.
$ db2pd -
Database Member 0 -- Active -- Up 4 days 00:13:14 -- Date... [More]
Many have been utilizing the light weight deployment solution i.e. IBM Data Server Driver Package that provides run-time support for applications without the need to install Run-time Client/Data Server Client. We already have DS Driver install demos for Windows out there, but not for Unix platforms, So, I would like to take this opportunity to share a demo of IBM Data Server Driver install in a Unix environment. The documentation is in our Knowledge Center:... [More]
In a DB2 HA environment using TSAMP, here is what goes on in the background when certain DB2 commands are run.
Running db2stop will lock the Instance resource group where the stop is issued against. Consequently the HADR Database will fall out of peer state and the DB2 engine will request that the HADR resource group gets locked, preventing the resources from being restarted automatically by TSA.
Running db2start will unlock the instance resrouce group, once the DB automatically reintegrates, the lock... [More]
Ever wondered what the TSAMP control flags stand for in a DB2 HA environment? Here are some of the most common ones:
" StartInhibited " - Start of dependent resource is not satisfactory (only displayed if OpState is Offline and DesiredState is Online)
" StopInhibited " - Stop of dependent resource is not satisfactory (only displayed if OpState is Online and DesiredState is Offline)
" SuspendedPropagated " - A lock request is propagated to this resource
Hello db2 DBAs
Have you encountered any db2 instance hang situations where in the db2fodc -hang command also hung? Fear Not! I have created a template that walks through the commands to execute at various levels i.e. db2 instance / database etc manually to collect the hang diagnostics and provide that to the support team. It would make the diagnosis of the hang much easier :)
Clean out sqllib/db2dump directory, move or remove any FODC_* directories from this directory to keep the db2support.zip... [More]
Here are the links with details on what to collect when you run into any issues with IBM Infosphere Federation Server. Gathering this information before calling IBM support will help you familiarize with the troubleshooting process and save you time.
Collecting data for installation failures for InfoSphere Federation Server versions 9.x
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... [More]
Inoperative DB2 Package:
Packages in DB2, can be dependent on certain types of database objects such as tables, views, aliases, indexes, triggers, referential constraints and table check constraints. If a package is dependent on a database object (such as a table, view, trigger, and so on), and that object is dropped, the package is placed into an invalid state. If the object that is dropped is an UDF, the package is placed into an inoperative state.
For an inoperative package, in the SYSCAT.PACKAGES system catalog view, the VALID... [More]
When installing DB2 Universal Database for Linux, Unix, and Windows version 10.5, the installation script no longer lists the "ESE" (Enterprise Server Edition) and "AESE" (Advanced Enterprise Server Edition) options as it did with earlier versions. They have both been replaced with the option of "SERVER". The other options have remained the same.
The reason for this is that whether you have "ESE" or "AESE" depends solely on the license you install (EG the actual libraries that are... [More]