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.
Hello All, DB2 v9.1 will be going out of support as of April 30, 2012. You can find out more by clicking on the below image: Or the following link: http://www.ibm.com/support/docview.wss?uid=swg21575777 If the above link doesn't address your questions, then please feel free to comment below.
Looking for some ideas to troubleshoot problems with DB2 on LUW? Check out our available self-help problem determination guides. Each guide has 4 different sections to help you troubleshoot the issue: Learning more Troubleshooting Collecting Data Analyzing the data DB2 LUW Crash: http://www.ibm.com/support/docview.wss?uid=swg21426669
DB2 Security Model on Windows http://www.ibm.com/support/docview.wss?uid=swg21423923
DB2 Unable to start DAS issue SQL4401C ... [More]
Starting from MDMPIM 9.1-FP2 and MDMCS 10 onward, there is a great tool for customers to collect support related data for the technical support team. The pimSupport.sh script is located in $TOP/bin/ directory. Here are the steps you may follow to collect the support information: 1. Login to the PIM installation server side as your PIM user. 2. Run the $TOP/bin/pimSupport.sh script. You may use the following parameters. Note the value after parameter "-p" is the PMR number separated by "." instead of ",". $... [More]
To stay current with the latest technical information for IBM Informix, here is a summary of the most popular technical docs for Informix. Happy reading!
11 Oct 2011: Download Informix Products
07 Sep 2011: Informix Server System Requirements 26 Aug 2011: Publications for the IBM Informix family of products 28 Mar 2011: Recommended Fixes for Informix Server Products
11 Oct 2011: Knowledge Collection: Informix Upgrade and Migration
16 Apr 2011: Setting and unsetting environment variables
24 Oct 2011:... [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]
100 Tech Tips, #62 Finding and Changing the DB2 fenced ID
on Unix and Linux
External DB2 LUW routines (stored
procedures and user defined functions that are not coded in SQL) often run
under the fenced user ID, which is provided when the DB2 instance is
created. The authority these routines have on the system is
limited to the access the fenced ID has, so it is useful when
designing external routines to know the fenced ID. You can find the
ID that will run routines by checking the ownership of the .fenced
file located in the ... [More]
IBM significantly updated the IBM Support Portal
with improvements to make this worldwide one-stop site for technical
resources for all IBM products even more effective and useful for our
clients. Some are adjustments our clients have requested, others are
redesigns to improve our clients' efficiency finding the information
they need. Here's a quick rundown of new capabilities to look for: Support for mobile users Enhanced Technical Support (ETS) client offering updates New design and color scheme Changes in module design in the... [More]
Product Lifecycles - A Primer
Just like any other product you may encounter in your day to day
activities, software has a lifecycle as well. It's almost like a "best
before" date. Even though the software still works it's time to move to a newer release. The IBM Software Support Lifecycle policy
explains the details of the length of support and all other information
that may come in handy as your customers approach the end of support of
any IM product.
Some key points in the Lifecycle policy are:
Provide a... [More]
Our friends in IBM eSupport are buzzing about all the exciting eSupport announcements to come in November, and today they published a preview of the IBM Support Portal Enhancements on their blog ! Click here to read their full post.
Here is a snapshot of the improvements:
Select between single and multiple products more easily
Simplified page navigation and layout will make it faster for you to find what you need on the Portal
Easier to find fixes and downloads
Russian language support
Does runstats seem to be running longer than usual? There could be a few explinations for this. First you should consider if there is a significant amount of data than before, this could just be normal. If you are in a situation where you will be working with a larger volume of data, you may consider different sampling options with runstats. When collecting detailed statistics collection can consume considerable CPU and memory for large tables, and may take longer than planned. The various sampling options can provide accurate statistics... [More]
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]
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]
There are few recent published technotes that address to different InfoSphere Information Server installation related issues : During InfoSphere Information Server 9.1 installation, users might get the message "The image properties file was not found...." In order to avoid this message,You need to download the proper IIS_V9.1_BUNDLE*.zip which contains the license key from the Passport Advantage site for your
purchased InfoSphere Information Server 9.1 product edition and unpack
it into your product media directory,e.g.... [More]
Ever wonder where to get a cheatsheet to catalog a connection from a DB2 client to a remote DB2 server on LUW? Here it is with simple step-by-step instructions!!! On the DB2 server: 1) Set the DB2COMM registry variable to tcpip. db2set DB2COMM=tcpip. 2) Verify whether it is set correctly using the following command: db2set -all Output: [i] DB2COMM=tcpip 3)Check the DBM CFG for SVCENAME parameter and make a note of it. db2 get dbm cfg For example: TCP/IP Service name (SVCENAME) = db2c_db2inst1 (Either... [More]
Only the named callers can see PMRs for their company; basic callers can only see PMRs they have opened. Nobody else can see their PMRs and they cannot see anything else. If you are the named caller, to find all of your Service Requests (PMRs) for your company, please follow these steps: 1. Log into SR - http://www.ibm.com/support/servicerequest 2. Select the "Search service requests" link from the left nav menu. 3. Choose the radio button for "Search all service requests", (select customer number if applicable). ... [More]