As organizations strive to do more with less, IBM® DB2® for Linux®,
UNIX®, and Windows® provides various built-in high availability
features. DB2 further provides high availability solutions by leveraging
enterprise system resources with broad support for clustering software
such as HACMP™, TSA, and Microsoft® Windows Cluster Server.
Here is a collection of some useful links for High Availability:
RedBook : High Availability and Disaster Recovery Options for DB2 on Linux, UNIX, and Windows... [More]
Users can use the DB2 Trace Facility (db2trc) in DB2 BLU ( BLU aka CDE - Columnar Data Engine) environment to collect the critical performance diagnostics information using new component, CDE_PERF_TRACE. To collect performance diagnostics, one should run: db2trc on –m CDE_PERF_TRACE
... run workload ...
db2trc dmp perftrc.dmp
db2trc fmt perftrc.dmp perftrc.fmt
There were reports on "db2trc on –m CDE_PERF_TRACE" not working due to some yet unidentified environment problem.... [More]
We know that when you need access to a fix, you want a smart and simple way to download and install it. And even more importantly, you want to find and download the fix as quickly as possible . We are pleased to share that the IBM Fix Central Support Site has been significantly improved. Many of these improvements stemmed from suggestions made by YOU. Thank you for sharing your feedback with us, and please continue to share your thoughts and suggestions on this upgraded version of Fix Central. Today's tip is to spend some time exploring Fix... [More]
100 Years ... wow. I was fortunate enough to have a grandmother who lived ~almost~ to 100. There was no sadness at her passing - she had lived a very full life and had remained active until close to the end. There was mostly awe and celebration - she had lasted 100 years. We don't celebrate when a rock or even a tree turns 100, because it is not very unique or surprising. But for a person - or for a company like IBM - it's quite an achievement. One of the things that my Grandmother used to say, quite literally, was that ~everything~ had... [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 installed are... [More]
NEW - Download Fix Central fix pack images using FTP Fix Central now supports downloading fix pack images using anonymous FTP. Use your browser, favorite FTP client, ftp command, or even the wget command. A significant number of users have asked for this functionality, so we're glad to make it available and hope that it helps you! The following document is a step by step demonstration how to use the bulk FTP download service in Fix Central to download a fix pack: How to download Fix Central fix packs images using... [More]
This weekend, we'll be performing some
critical maintenance on our systems, and as such, our technical support
content will be unavailable for a period of time between 9:00 pm ET May 21 2011 and 5:20 am ET May 22 2011. What you can expect: The IBM Support Portal will be operational, and Site Availability and News portlet will contain information on the outage Search will provide results; but links will not reach content Our apologies for the temporary inconvenience.
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: http://www.ibm.com/support/docview.wss?uid=swg21209001 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 As a result, the DB2 instance will not... [More]
Making it easier to get your input We've made a few quick changes to make it easier for you to give us feedback on our technical support documents. Now, when you find your solution, in the upper right you should see this: Make your selection and hit Submit - it's that easy! If you want to add more feedback, click on the "Would you like to make additional comments?" link, which will take you to the bottom of the page where you can add your thoughts, opinions, corrections, additions, email address - whatever's on your mind. Your... [More]
Back in December 2011, when we were way back at tip #44, we posted a summary of our Technical Support tips categorized by product/interest area. Since we are now about 75% complete on our goal of posting 100 Tech Tips by June 16 2012 (one tip for every year IBM has been in business), we have updated our summary and below you'll find links to 75 pieces of valuable technical support information!! We hope you find this list useful. Please share it with colleagues who may benefit from this list and let us know if you'd like to see a particular... [More]
Happy new year to our readers! As we move into 2012, we're busy preparing and brainstorming technical support tips and information that will be useful to you in the year ahead. For our first post, we've pulled a list of the most popular technical documents for DB2 for z/OS. Take a look at the list below and get informed. 09 Dec 2011: DB2 for z/OS - Technical Resources - Version 8 09 Dec 2011: DB2 for z/OS - Technical Resources - Version 10 16 Apr 2011: SQLCODE -803 error: An inserted or updated value is invalid when the IDENTITY column in the... [More]
-1213 A character to numeric conversion process failed. A character value is being converted to numeric form for storage in a numeric column or variable. However, the character string cannot be interpreted as a number. It contains some characters other than white space, digits, a sign, a decimal, or the letter e; or the parts are in the wrong order, so the number cannot be deciphered. Cause Your query is causing Informix to attempt to explicitly or implicitly cast non-numeric data in a character column to a number. Example: You have a table... [More]
HEY THERE! Now that I have your attention... IEA. I-E-A. Stands for IBM Education Assistant. Been there lately? Have you checked out the online learning opportunites through the IBM Education Assistant program? Information Management product teams have been busy, busy, busy adding more material to help you with some of the most common tasks around your product. Presentations are available in both Flash and PDF formats Take 2 minutes and go to http://publib.boulder.ibm.com/infocenter/ieduasst/imv1r0/index.jsp and check it out. For... [More]
Hello All, Looking for some help on how to resolve the error SQL1092N on Windows using Domain ID's . Then you're in luck because we have put together the following tech doc to help you with that: Getting SQL1092N error when running any DB2 commands as a domain id Still seeing the error or have questions about it, then please feel free to comment below.
Abstract: In DPF environment, the lock timeout issue could be caused by indoubt transactions. The indoubt transactions cannot be automatically committed or rollback by database manager therefore whenever the application restarts the lock timeout issue occurs. Troubleshooting: Collect the locking data by: db2pd -db <dbname> -alldbp -wlock -app -trans -repeat 5 10 Note that the above db2pd must have -alldbp option which runs on each logical node on one physical box, if there are multiple physical boxes, then db2pd needs to be run on... [More]