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.
Arrrr ye climbin' aboard at Insight 2014?
Join the Smarter Support Treasure Hunt!
Collect clue words ‘n unscramble special letters to spy th’ secret phrase . Parley wit’ us at th’ IBM Smarter Support Zone (Booth 405) and share th’ secret phrase to receive special treasure thar!.
Come aboard to collect clues each Monday and Friday!
By default, 64 bit Windows versions use a 64 bit ODBC Administrator utility. How do I install a 32 bit version of ODBC to work with IBM Informix Dynamic Server, when I am using a 64 bit Windows version?
The menu option Administrative Tools->Data Sources (ODBC), is the Windows 7 utility used to maintain ODBC data sources and drivers. The path for this ODBC administrator utility is "%windir%\system32\odbcad32.exe". Although it is referenced as "32" in the path name, it is a 64 bit... [More]
You install IBM Informix Client Software Development Kit (CSDK) 3.70.FC4 or higher on a machine running a Windows operating system. The installation does not include OpenAdmin Tool (OAT). You note that OAT is included when you install the 32-bit Windows CSDK 3.70.TC4
OAT is first bundled with CSDK in 3.70.TC4 fixpaks (32 bit) . This does not include the 64-bit CSDK 3.70.FC4 or higher on Windows
You can install the 32-bit OAT on a Windows 64-bit machine.
Platforms where OAT is available ... [More]
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]
In this demo, I have considered the following to demonstrate DB2 connectivity using type 2 Universal JDBC type 2 driver with 32-bit and 64 application:
- Downloaded IBM 32-bit JDK for Windows from the web: http://www.ibm.com/developerworks/java/jdk/
- Installed DB2 V9.7 FP5 64-bit Client on Windows 7
- DB2 V10.1 FP4 database server on Linux.
Used the following sample code:
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]
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]
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]
Want to improve your experience when contacting IBM Support?
Would you like to know how to enhance your IBM Support with additional services that suit your needs?
Check out IBM Software Support Handbook and its companion the IBM Appliance Support Handbook.
Software Support Handbook.
Appliance Support Handbook.
For every problem, collecting data can aid in problem determination and save time resolving Problem Management Records (PMRs). Collecting this data before calling IBM support will help you understand the problem and save time analyzing the data.
Collecting data before opening a PMR helps IBM Support determine if:
symptoms match known problems (rediscovery).
there is a non-defect problem that can be identified and resolved.
there is a defect that identifies with an immediately available fix.
there is a... [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]
Linux is an operating system that becomes very popular over the last several years. The growing popularity of Linux influenced business to port their Informix databases on this platform.
If you are a Linux user, is your Linux system optimally configured for Informix? In this presentation you will see what needs to consider to run Informix optimally on Linux platform.
Please find attached a presentation that provides guidelines for how to install and manage Informix on Linux platform. The Presentation is... [More]
Insight 2014 is only 37 days away. While the Smarter Support team gets ready for the event of the year, we connected with the Smarter Support leadership team to get their take on the event and what Smarter Support is all about.
The Smarter Support leadership team includes:
Al Martin (AM) , Vice President, Information Management Worldwide Client Support
Andrew Lee (AL) , Vice President, Business Analytics Customer Support & Success
David Churchill (DC) , Director, Global Enterprise Content Management... [More]
You're invited to our September Support Technical Exchange!
Topic: IBM PureData for Analytics (Netezza) Connectivity for Information Server DataStage
Speaker: Scott Brokaw, Information Server Support Engineer, Team Lead
Date: Tuesday, September 30, 2014
Time: 11:00am - 12:00pm EDT
Description: Extend data integration and governance in IBM PureData for Analytics by fully leveraging InfoSphere Information Server. This presentation will provide a connectivity and quick start guide for Netezza... [More]
We are very happy to announce that we have completed 50 DB2 Nuggets goal - 50 exclusive DB2 Blogs in Information Management support for 2014!
Readers - thank you for your interest. We hope that you find our information relevant and helpful.
Authors - thank you for your dedication, effort, expertise and help in promoting client self-assist.
Here are the names of the authors who have contributed towards the goal.
Adam Koile - USA
Christopher Rose - USA
Gord Owens - Canada
John Gera - USA
Jun Su Lee -... [More]
Recently I worked on another interesting case where an ODBC/CLI application using SUBSTRING(..., CODEUNITS32) and LOCATE(..., CODEUNITS32) functions in case when first argument is a parameter and the function is used in WHERE or HAVING clause expression resulted in error:
[IBM][CLI Driver][DB2/NT] SQL0245N The invocation of routine "SUBSTRING" is ambiguous. The argument in position "1" does not have a best fit.
This error is returned when an invocation of a function is ambiguous.... [More]
In a DB2 HA environment using TSAMP, here is what goes on in the background when certain DB2 commands are run.
Running db2stop will lock the Instance resource group where the stop is issued against. Consequently the HADR Database will fall out of peer state and the DB2 engine will request that the HADR resource group gets locked, preventing the resources from being restarted automatically by TSA.
Running db2start will unlock the instance resrouce group, once the DB automatically reintegrates, the lock... [More]
Ever wondered what the TSAMP control flags stand for in a DB2 HA environment? Here are some of the most common ones:
" StartInhibited " - Start of dependent resource is not satisfactory (only displayed if OpState is Offline and DesiredState is Online)
" StopInhibited " - Stop of dependent resource is not satisfactory (only displayed if OpState is Online and DesiredState is Offline)
" SuspendedPropagated " - A lock request is propagated to this resource
Recently I worked on an interesting case where a CLI application received " CLI0145E Fetch type out of range. SQLSTATE=S1106 " error and I would like to share with you the steps I did, to troubleshoot the issue.
This is a new application which worked in one server and failed in this specific server.
I asked customer for CLI trace reproducing the issue and db2Support.zip from the DB2 Client.
Basic identification of system problems - This presentation discusses and demonstrates how to identify system level problems the PureData for Analytics Appliance. This includes using the command line interface, viewing diagnostic log data, running the System Health Check utility, and using graphical tools, including the Netezza Administration Tool and the Netezza Performance Portal. Related Techdoc #7042884.
The Database design: Distribution keys and data types IBM Education Assistant video discusses two important components of Database Design with a focus on distribution keys and data types. Related Techdoc #7042882.
There is a new IBM Education Assistant video available titled "How to start and stop a PureData System for Analytics" . This presentation provides details regarding the system environment, default users and passwords, what commands to use to start and stop a PureData System for Analytics and what to monitor during system startup. Related Techdoc #7042881.
It's about that time of year again... time to get ready to head to Vegas for the largest big data conference in the world! This year, there are a few important changes you should know about:
Information on Demand is now IBM Insight! The name has changed for a reason: It's no longer just about information; it's what you can do with the information and how you can use data as a competitive advantage. See the conference website . Insight runs from October 26-30, 2014.
Diagnosing a hung Information Server V8.1 - 9.1 DataStage parallel job on Windows - This presentation discusses how to rule out known issues, show how to determine if a parallel job is hung, and if so, it describes the environment variables that need to be set and what information to collect during the hang. DCF #7042477
Relocating QualityStage Match Designer Database - This presentation explains the steps that are required to change the configuration to relocate InfoSphere QualityStage Match Designer database. This is a component of InfoSphere QualityStage that stores the results of match test passes by the InfoSphere QualityStage Match Designer stage. DCF #7042467
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]
To ensure you are ready for the Optim z/OS products reaching EOS in September , here is a summary. You can view the original EOS announcement here .
End Of Support
Optim Database Relationship Analyzer for z/OS
Here are the links with details on what to collect when you run into any issues with IBM Infosphere Federation Server. Gathering this information before calling IBM support will help you familiarize with the troubleshooting process and save you time.
Collecting data for installation failures for InfoSphere Federation Server versions 9.x