Expert Advise: DB2 Alphablox 9.5.7 Fix Pack 4 is now available. This release provides the following: Support for the Essbase 188.8.131.52 - 64 bit bridge interface for Windows, Solaris and AIX. Browser support for Internet Explorer 9.0 and Firefox 9, and Firefox10 Click here to find out more about additional supported packages and fixes.
Here is a simple DB2 command which will display the DB2 products that are installed on the system: db2ls - it displays the Install path, product level, fix pack details, Special Install Number, Installation date , Installer UID. The db2ls command is the only method to list all DB2 product at Version 9 or later. However you cannot use the db2ls command on Windows operating systems. $ db2ls Install... [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]
Take a Proactive Approach to Managing your Support Plans and Issues - with help from AVP (the Accelerated Value program) IBM Subscription and Support provides world-class software support via award-winning tools and support personnel. AVP – aka the Accelerated Value Program - added to your S&S contract, provides comprehensive maintenance and support guidance and assistance for issues that occur across all phases of the software life-cycle . With AVP, you can get assistance with tasks like file fixing, code reviews, and upgrade tasks, as... [More]
developerWorks Works! And Wins! developerWorks has been recognized by Forrester in the Busi ness -To- Busi ness (B2B) - " Supporting" category as an outstanding example among nearly 130 entrants... as the best use of B2B support. Having a user community skilled on IBM products and open standards
technologies who can quickly and easily find answers to their questions
using social media oriented search tools is critical to IBM success.
developerWorks supports IT professionals to become skilled on critical
technologies so... [More]
The db2ReadLog API is used to read log records from the DB2® database logs, or queries the Log Manager for current log state information. Before a Embedded SQLC program can be used it has to be precompiled, bound, compiled and linked. Here is an example on how to use the db2ReadLog API using the dblogconn.sqc sample SQLC program that is provide with the DB2 sample scripts. This program reads the database log files asynchronously with a database connection using the db2ReadLog API. Copy the sample c scripts from ~/sqllib/samples/c to local... [More]
Our friends in IBM eSupport are buzzing about all the exciting eSupport announcements to come in November, and today they published a preview of the IBM Support Portal Enhancements on their blog ! Click here to read their full post. Here is a snapshot of the improvements: Select between single and multiple products more easily
Simplified page navigation and layout will make it faster for you to find what you need on the Portal
Easier to find fixes and downloads
Russian language support
This list is only the tip of... [More]
Commitment is hard. It's much easier to put your effort toward a quick goal, get it done, and move on. But achieving a quick goal doesn't always provide the best long term results. Last June, our blog authors made a commitment - 100 posts to honor IBM's Centennial anniversary. This post marks the completion of that commitment, and we'd like to say "Thanks" to everyone.
Readers - thank you for your interest. We hope that you find our information relevant and helpful.
Here are the names of some of the authors who have... [More]
Getting "SQL0407N Assignment of a NULL value to a NOT NULL column" error when inserting an empty string. An empty string is not a NULL value in DB2. The root cause of the issue is due to the following db cfg parameter. Varchar2 compatibility = ON The VARCHAR2 and NVARCHAR2 data types are introduced to support applications that use the Oracle VARCHAR2 and NVARCHAR2 data type. If DB2_COMPATIBILITY_VECTOR=ORA set in your instance environment and then when you create a database, the value of the Varchar2 compatibility will be set... [More]
How to run REORG table command from a CLI application against a DB2 database server? REORG command is supported by command line processor, you
cannot use the REORG command directly from a CLI application. In order to run REORG from a CLI application, you will have to use ADMIN_CMD stored procedure. For example: CALL SYSPROC.ADMIN_CMD ('REORG TABLE test') ADMIN_CMD - DB2 V9.1 ADMIN_CMD - DB2 V9.5 ADMIN_CMD - DB2 V9.7 If you try to use the REORG command from a CLI application, it will return SQL0104N (syntax error). You will find a... [More]
An ODBC driver manager is not supplied on UNIX platforms as part of the operating system. Using ODBC on UNIX systems, therefore, requires a separate commercial or open source ODBC driver manager. The unixODBC Driver Manager is an open source ODBC driver
manager for use on UNIX platforms.
This driver manager is supported for ODBC applications on supported DB2® platforms.
To run ODBC applications on Linux or UNIX operating systems, you must configure the UnixODBC Driver Manager. Here are the steps to install and configure UnixODBC for... [More]
Things to know about db2connectactivate Server Activation Tool: You can obtain db2connectactivate license key from DB2 Connect Unlimited Edition for system z via
DB2 Connect Unlimited Edition for System z CD or By downloading the IBM DB2 Connect 9.7, Unlimited Edition for System z Quick Start and Activation for Linux, UNIX and Windows - CI36DML from Passport Advantage Refer to: DB2 Version 9.7 Activation key part numbers To be more specific, this utility is present under ~\consv_zs\db2\license directory Note: db2connectactivate is... [More]
First off, Happy New Year! I hope 2011 finds you and yours safe and well. Second, we want to share a compliment we are very proud of: In December, we posted a video to help explain how IM Support uses Knowledge-Centered Support (KCS) and some of the benefits: http://ow.ly/3yKEO David Kay, one of the leading voices in KM and KCS, just posted a "pat on the back" for the video in his blog: Communicating KM to Customers: IBM does it right We're still maturing as an organization using KCS, but hopefully you've seen... [More]
Attention MDM users! We are pleased to share a FREE education session available in April: Upgrading to MDM v11 . This session is now complete. Click here to watch the replay . Date: April 7, 2015 Time: 10:00am - 11:00am ET Session description: In this presentation, we will perform a comprehensive overview of the MDM v11 upgrade process. We will begin the session by reviewing how MDM v11 differs from our previous releases of MDM Advanced Edition and MDM Standard Edition from a technical perspective. Next we will outline... [More]