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.
How to restore critical administrative files with onbar utility?
It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows:
The onconfig file
UNIX: The sqlhosts file
The ON-Bar emergency boot file: ixbar.servernum
The server boot file: oncfg_servername.servernum
There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported... [More]
While your business is growing, you might face some performance issues, that weren't there when you started using DataStage, or even worse, DataStage, has never been as fast as you thought it would be.
As follows, I'm sharing with you some tips to check in general and specific environments, maybe it's matter of changing a parameter or maybe you have to install a product Fix, but remember, it's always useful to test in a controlled environment, stress your environment, and review if modifications helped or not.
Recently we receive several customer issue of downloading InforSphere Data Explorer 8.2-3 from Fix Central. Sorry for any inconvenience. To resolve this kind of issue please contact them by calling 1-800-IBM-SERV or emailing them at UStsmail@us.ibm.com.
InfoSphere Data Explorer Engine Support
IBM Support Portal at
When is a door not a door? When it's APAR???
In response to your feedback, we are changing our email notification process for APAR subscriptions.
If you have a My Notifications subscription to the APAR category for a product, you will receive email notification ONLY FOR NEW APARs.
You CAN also subscribe to all APARs for a specific product component.
To follow the resolution of a specific APAR : click the APAR link, and then subscribe to that APAR.
What's new for you? Thanks to everyone who has been out there rating our documents on the web, we're now able to show you a list of the top rated documents in Support Portal. This is in addition to the "Most recent" and "Most viewed". So, if you are working in "browse" mode, trying to be proactive by visiting the Support Portal to keep an eye on - what's new, of course - then you need to check out the "Overview top ten" portlet! Enjoy!!!
Puppet is IT automation software that defines and enforces the state of your infrastructure throughout your software development cycle. From provisioning and configuration to orchestration and reporting, from initial code development through production release and updates, Puppet frees sysadmins from writing one-off, fragile scripts and other manual tasks. At the same time, Puppet ensures consistency and dependability across your infrastructure.
With Puppet, repetitive tasks are automated away, so sysadmins can quickly deploy business... [More]
Have you heard about IBM InfoSphere Guardium or Guardium product as it is usually called? If not, read below a brief description of what this product can do to protect your database access with a powerful product. Or, if you have heard or have experience using the product, please share your experiences. What is IBM InfoSphere Guardium: It is a product that can be a combination of dedicated hardware (appliance) and software or just software (a virtual appliance plus additional software) . It provides a solution for
assuring the privacy and... [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]
End of Support i s a natural stage in the IBM Software Support Lifecycle. End of Support marks the 'official' withdrawal of technical support for specific versions and releases of software products.
Learn more in this new video about the Product Lifecycle available in the IBM eSupport channel on YouTube:
Other Product Lifecycle resources:
The Support Lifecycle page
Lifecycle information for IM products only
What are the Best Practices for Running Informix Instances in VMWare vSphere Virtual Environments
The document provided in the following link:
What is VMware Virtualization?
Evolution of VMWare Virtualization
Why Informix on VMWare
Informix Scalability Tests
Informix Scalability Test Results
Best Practices for running Informix on VMWare
Welcome to the THUNDERDOME! Ok, it's the "Thoughts from Information Management Support" blog. Somehow "the Thunderdome " seemed more exciting... On the other hand, this blog will benefit you in working with your IBM Information Management products (unlike a steel cage match to the death - yikes!). In coming weeks, we'll deliver information to you regarding ways that we can help you, ways that you can help yourself, and hopefully in the process we'll help each other by getting to know each other better. The Magical Mystery... [More]
Merry Christmas. DB2 mates !!
Holiday is actually good timing for writing blogs for me. Today I would like to write a topic a bit aside from DB2 but very necessary in some difficult performance cases.
When we need hands from OS team and expert, it's better to understand what kind of OS tools are necessary and how it works.
Actually these tools boost up the problem investigation and provide a smoking gun evidence very shortly.
If we don't know much about right tool for a case, we may sometimes spend lots of time to... [More]
I will be providing quick shortcuts to open various DB2 Control Center tools. If you are still using DB2 Control Center that will save you some time!
Activity Monitor – db2am
Control Center – db2cc
Configuration Assistant – db2ca
Development Center – db2dc
Event Analyzer – db2eva
Health Center – db2hc
Indoubt Transaction Manager - db2indbt
License Center – db2lc
Memory Visualizer – db2memvis
Query Patroller Center – db2qpc
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]
FMP memory can be configured with the help of the registry variable DB2_FMP_COMM_HEAPSZ and the database manager configuration parameter aslheapsz.
The default DB2_FMP_COMM_HEAPSZ is 256 MB on AIX and 20 MB on other OS
memory used by each FMP process = 2 * ASLHEAPSZ
If the active fenced routines exceed this limit then we see the following message in the db2diag.log
MESSAGE : Insufficient memory available for IPC communication with the db2fmp
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]
We have many customers wondering how to fine tune their dynamic SQL queries . The following snapshots can be run based on a particular environment:
db2 get snapshot for dynamic sql on <dbname>
db2 get snapshot for dynamic sql on <dbname> global
Number of executions = 2
Number of... [More]
1. The below command will help us identify which application is consuming the maximum LOG space:
db2 "SELECT SUBSTR(AI.PRIMARY_AUTH_ID,1,10) AS AUTHID, SUBSTR(AI.APPL_NAME,1,10) AS APPLNAME, SUBSTR(AI.APPL_STATUS,1,10) AS STATUS, INT(A.UOW_LOG_SPACE_USED) AS LOG_SPACE, A.UOW_START_TIME FROM SYSIBMADM.SNAPAPPL A, SYSIBMADM.SNAPAPPL_INFO AI WHERE A.AGENT_ID = AI.AGENT_ID AND A.UOW_LOG_SPACE_USED > 0 ORDER BY A.UOW_LOG_SPACE_USED DESC"
AUTHID APPLNAME STATUS... [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]