
All posts
- Sort by:
- Date
- Title
- Likes
- Comments ▼
- Views
Resource Info: New InfoSphere Information Server Training Available
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]
Tags:  education iea infosphere |
Weekly Tips from DB2 Experts : How to resolve "Error 2215575553 bringing resource online" during DB2 MSCS fail-over
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]
|
Weekly Tips from DB2 Experts: How to tune FMP memory
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]
|
Join the Smarter Support @ Insight Treasure Hunt!
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
|
Informix 32 bit ODBC setup for Microsoft Windows
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]
Tags:  im_resource im_advice |
Informix 64-bit CSDK for Windows Platforms does not Include OAT
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]
Tags:  im_techtip im_resource |
What is puppet or why use it with INFORMIX
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]
Tags:  im_resource im_advice |
Weekly Tips from DB2 Experts: Demo of DB2 connectivity using type 2 Universal JDBC Driver
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: import java.sql.Connection; import java.sql.DriverManager; import java.sql.*; import java.sql.SQLException; public... [More]
Tags:  jdbc db2;db2_advice type2 |
Weekly Tips from DB2 Experts: Explore db2cli - DB2 interactive CLI command
Hello, 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]
Tags:  cli db2_techtip db2cli |
Weekly Tips from DB2 Experts: How to check what is taking up the LOG SPACE?
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" Example: AUTHID APPLNAME STATUS LOG_SPACE... [More]
Tags:  spacereserved db2_techtip log_space |
Weekly Tips from DB2 Experts: How to identify a long running or badly tuned dynamic SQL using DB2 snapshots?
We have many customers wondering how to fine tune their dynamic SQL queries . The following snapshots can be run based on a particular environment: Single partition: db2 get snapshot for dynamic sql on <dbname> DPF: db2 get snapshot for dynamic sql on <dbname> global Example: Number of executions = 2 Number of compilations = 0 Worst preparation time... [More]
Tags:  db2_techtip perf long_running_query dynamic_sql |
IBM Support Handbooks
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. http://www14.software.ibm.com/webapp/set2/sas/f/handbook/home.html Appliance Support Handbook. http://www-304.ibm.com/support/customercare/sas/f/applhandbook/home.html
Tags:  handbooks support |
Collecting Data: Informix Family products
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 defect that identifies a workaround to... [More]
|
Weekly Tips from DB2 Experts: How to overcome common db2iupgrade failures (DBI1264E)
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 message : DBI1264E Errors were encountered in running db2iupgrade. Please refer to the installation log file /tmp/db2iupgrade.log.xxxxxxx In the db2iupgrade.log file it... [More]
Tags:  dbi1250e upgrade_db2 db2iupgrade dbi1264e db2_techtip |
Is Your Linux System Ready for Informix ?
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 broken down in to... [More]
|