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.
Are you stuck with DB2 installation/upgrade/migration? I am listing down few common check points to start with: 1. Please look for any db2 related processes running on the system. You may run 'ps -elf | grep -i db2' on unix or look for db2* processes in task manager on windows and see what db2 processes are running. You may want to shutdown/kill the process if it is not required. 2. Please make sure *all* db2 filesystems are mounted and accessible. 3. Please make sure you have enough free space under /opt, /tmp and db2 instance's... [More]
Has your internal Site Technical contact left the company and you need to change it to another person? Are you not able to view a PMR created by a coworker via Service Request tool or by phone? Do you need to add coworkers to the Service Request tool? All these questions can be answered by visiting our IBM Service Request help website at https://www-946.ibm.com/sr/help/register.html
What do Kevin Spacey and Captain Phillips have in common? Among other things, IBM! See them and other highlights from the IBM Insight using InsightGO! InsightGO is an interactive digital platform, streaming live broadcasts straight to your laptop or mobile device. It's the next best thing to being in Vegas, but it doesn't stay in Vegas!
Problem(Abstract) Initializing InstallShield Wizard........ Launching InstallShield Wizard........ The wizard cannot continue because of the following error: could not load wizard specified in /wizard.inf (104) Cause Install can't locate java path Resolving the problem ./ids_install -javahome your_JRE_path This forces the installation script to use the bundled IBM Java Runtime Environment.
The IBM Insight conference kicks off on October 26! Find your Smarter Support team in the Smarter Support Zone in the EXPO, booth 405 . A big part of the Zone is our Hands-On Lab. In the lab, you'll find over 50 self-paced workshops covering IBM products from Information Management, Business Analytics, and Enterprise Content Management. Today, we'll share the workshops available for Information Management products: Information Server command line tools across our products for automating tasks LDAP Filtering and LDAP Attribute Mapping... [More]
Hello everyone, 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 content below. See... [More]
Hello All, 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 Replication Center – db2rc Task Center – db2tc... [More]
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. STEPS Create and run this SQL to remove duplicate rows from a table: SELECT rowid FROM table_name WHERE rowid NOT IN ( SELECT MIN(rowid) FROM table_name GROUP BY column_name ) INTO TEMP temp_name; DELETE FROM table_name WHERE rowid = ( SELECT rowid FROM temp_name WHERE table_name.rowid =... [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. Cause Your query is causing Informix to attempt to explicitly or implicitly cast non-numeric data in a character column to a number. Example: You have a table... [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 the new Greenplum... [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 Func.Called: CreateFile System Errno: 5 Data1 (PD_TYPE_FILE_NAME,41) File... [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 process. Use the... [More]
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! SmarterSupport.Tumblr.com #smartersupport #ibminsight
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]