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.
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... [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]
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]
When trying to convert your database to BLU. You may see that some tables fail. This can be seen like this.
In the progress of the convert utility. The below will be seen.
Table RowsNum RowsComm Status Progress (%)
--------------------------------------- --------------- --------------- --------------- ---------------
"TANJINXU"."ACT" 18 0 COPY Failed
This is caused by the utility heap size. The convert utility utilizes the admin move table function. If the utility heap size is not... [More]
I would like to share with our readers the license issue that one of our customers ran into.
Its straightforward and I'm sure you have seen this license problem before and know to resolve it but I would like to show the symptoms, what options we had, which one did we choose to fix the license error .
The product installed was DB2 10.1 Enterprise Server Edition (ESE) as seen here below:
Product name: "DB2... [More]
For most of us, we refer the word ' ARCHIVE ' in DB2 to DB2 Transactional Logs archiving.
There are other items that you can archive as well. Let's explore what all we can archive:
1. DB2 Transactional Logs - This refers to DB2 transactional log archiving. I assume you are familiar with this concept. Hence I won't discuss it in detail here. If you have any question, please feel free to ask us. You can add a comment to this article at the bottom.
2. DB2 Diagnostic Logs Archiving -... [More]
I am quite sure that most of you are using 'svmon' utility with various option to monitor the memory utilisation on AIX box. The most useful option I found is 'P'. It quickly shows you the approximate memory consumption at process level:
$ svmon -G
size inuse free pin ... [More]
100 Tech Tips: #86 What information is in the name of the db2fmp
The db2fmp or DB2 Fenced Mode Process
is used to run untrusted external routines. These routines can be
created in a variety of languages and can be thread-safe (meaning it
is safe to run them in a multi-threaded db2fmp process with other
unrelated routines), or not thread-safe (meaning they will be run in
a single db2fmp process). The name of the db2fmp in the ps output
can be used to determine the language and thread-safeness of the
db2fmp. The name also indicates... [More]
Today we are very excited to announce two new ways to get Support information specifically for DB2! A crack team of DB2 experts around the world will be sharing their expertise through Twitter and Facebook. Follow us: DB2_Support on Twitter Like us: IBM DB2 Support on Facebook These channels will cover DB2 Tools... JDBC CLI Security Stored Procedures ... and DB2 Engines Memory HADR Internal Architecture DB2 Blog posts will continue to be posted here on our Thoughts from Information Management Support blog. Follow DB2 Support on Twitter... [More]
STAR ME UP! Over the weekend, a pilot "Star Rating" program was deployed for several IBM products across the portfolio, including technical support documents for Informix Servers and DB2 for Linux, Unix, and Windows. In the future, you will be able to see these ratings in the IBM Support Portal. This rating system is in addition to our current feedback mechanism, so please continue to let us know if our support documents help you achieve your goal and how we can improve them. Star me up! I'll take you places that you've never, never... [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]
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