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.
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]
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.
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]
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]
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]
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]
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
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]
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]
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]
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]
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]
DB2 LUW provides the db2pd tool with
two fmp options that when used in conjunction with each other can
provide information which will identify the routine that was running
in a particular db2fmp. The following technote documents a method to
determine which db2fmp a routine ran in using the db2pd tool.
If a db2fmp entry is logged in the
db2diag.log, the entry should contain the process ID (PID) and thread
ID (TID). Below is a sample of a db2diag.log entry which... [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]
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]