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.
It is hard to believe that by this time next week, IBM Insight 2014 will be in full swing! We look forward to meeting everyone who is attending in the Smarter Support Zone, booth 405! See our Tumblr page for more info about Smarter Support and how you can connect with us.
Today, we bring you an update from our friends over at BA Support Link! They recently shared an excellent blog on certification at Insight, so we thought we would pass it along. Read the blog here or we've included the... [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 to remove Duplicate Rows in a nonfragmented IBM Informix Dynamic Server (IDS) Table .
Use the SQL in this article to remove duplicate rows from a nonfragmented table.
Note: This method does not work on fragmented tables. Rowid's must exist on the table.
Create and run this SQL to remove duplicate rows from a table:
WHERE rowid NOT IN (
FROM table_name GROUP BY column_name
) INTO TEMP temp_name;
DELETE FROM... [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.
Your query is causing Informix to attempt to explicitly or implicitly cast
non-numeric data in a character column to a... [More]
The following new IBM Education Assistant modules are now in production:
How to configure Information Analyzer 11.3 - DCF #7042463 - This presentation explains how to configure Information Analyzer 11.3.
Importing metadata using Greenplum Connector through Information Metadata Asset Manager - DCF #7042465, The objectives of this presentation are to show how to create the necessary ODBC data source and how to import metadata using... [More]
In a DB2 MSCS setup during fail-over DB2 resource does not fail-over and we see the following error in the cluster log
ERR [RES] DB2 Server <DB2-0>: Error 2215575553 bringing resource online.
This can happen due to incorrect permissions on the db2nodes.lck file
DB2 trace will show the following entry
SYSTEM ERROR DB2 UDB oper system services sqloopenp cei
Error ZRC = 0x840F0001 = -2079391743 = SQLO_ACCD
System Errno: 5... [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
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]