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.
Are you considering ‘Admin move table’ for reorganization work of your tables ? And are you finding the way to reduce time of last ‘SWAP’ of admin move table work ?
Nowadays, our database systems have so many number of tables and the tables are getting bigger. And as a database administrator, we are facing the reality that we need to do the time consuming work for maintaining huge tables and business departments usually do not permit enough time to work on those on weekends offline maintenance work... [More]
There are situations where in a HADR environment, transaction on the Primary are blocked(applications will seem to hang) when the HADR database is in peer state and there is a network event (network congestion/network down or the Primary does not receive ACK from the Standby-Standby log buffer full). This can be explained with the help of Brewer's CAP theorem.
Brewer's CAP Theorem:
Brewer's CAP theorem states that, in a Distributed Computer System, we can guarantee only two of the following... [More]
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]
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".
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]
Have you ever wondered why during a DB2 fixpack upgrade on a DPF environment, db2iupdt fails with DBI1167E "DPF instance cannot be updated from non instance owning nodes."?
Beginning in DB2 V9.5, fixpack upgrade was enhanced on Unix and Linux platforms to only run db2iupdt on instance owning node. Prior to DB2 V9.5, db2iupdat didn't do a hostname check. This was first introduced in DB2 V9.5. This check was done to ensure that the instance update only happens on the node defined on the first line of db2nodes.cfg for DPF... [More]
There are 3 error messages that commonly occur related to Stored Procedures and Functions (collectively referred to as routines). These are SQL0440, SQL1131 and SQL0443.
A SQL0440 returns an error indicating the routine does not exist. Usually when this error occurs the routine does exist but is being called incorrectly. Routines can be overloaded so two or more routines can be created using the same schema and name if they use either a different number of input or return variables (3 input as opposed to 2) or different data... [More]
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... [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]
Are you stuck with DB2 installation/upgrade/migration?
I am listing down few common check points to start with:
1. Please look for any db2 related processes running on the system. You may run 'ps -elf | grep -i db2' on unix or look for db2* processes in task manager on windows and see what db2 processes are running. You may want to shutdown/kill the process if it is not required.
2. Please make sure *all* db2 filesystems are mounted and accessible.
3. Please make sure you have enough free space under /opt, /tmp and... [More]
To troubleshoot an issue with complex CLI application, DB2 CLI script with similar functionality can be used.
In many cases, customers usually have a complex CLI application that run into issues.
To simplify the issue and to quickly gather diagnostics, we often ask customers to try with a simple DB2 CLI script.
Here are some Windows based examples:
1. To test the CLI connectivity to the remote database from the DB2 Client where the application... [More]
We have seen many customers having problems with the db2iupgrade command. Some are very common and can be resolved in seconds. To save your time, here is the most common problem while upgrading and some tried and tested solutions to overcome it.
Problem Description :
When you try to upgrade a db2 database using db2iupgrade command sometimes it may fail with following error
DBI1264E Errors were encountered in running db2iupgrade. Please
refer to the installation log file /tmp/db2iupgrade.log.xxxxxxx... [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]
The current JDBC driver shipped with DB2 called the IBM CLIENT DRIVER FOR JDBC AND SQLJ can function as both a JDBC Type 4 and JDBC type 2 driver.
Type 4 Mode
When functioning as a JDBC type 4 driver, the driver is independent of the DB2 Client and only the driver jar db2jcc.jar or db2jcc4.jar need be installed. In this mode all TCP/IP command execution and routing is done through Java. In type 4 mode the driver requires the TCP/IP name and port of the server and uses the name of the database alias at the server. ... [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]
Today, we're please to share three newly published support newsletters for three of our top Information Platform & Solutions products: InfoSphere Information Server, InfoSphere Master Data Management, and InfoSphere Data Replication !
In each newsletter, you'll find three sections:
In the spotlight , featuring support news and important product updates
Plan , featuring top technotes and fixes
Education , featuring videos, modules, and other resources available to help you increase your... [More]
Where is online information for my product?
Where can I go to ask a question?
How do I know what versions and fixes are available for my product?
Where can I find documentation for my products?
How do I connect to the online community for my product?
Check out our newest all-in-one list:
IBM Information Management Support Online Resources and Subscriptions
all technical support downloads, content, tools / updates... [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]