Hello, 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. SQLSTATE=428F5. This error is returned when an invocation of a function is ambiguous. This occurs when there... [More]
In this blog,you will find few Standardization Rules Designer related resources available for you 1. Education Assistant: Using the QualityStage Standardization Rules Designer in the InfoSphere Information Server Version 9.1 This link points to an IBM Education Assistant module about how to use the Standardization Rules Designer in InfoSphere Information Server QualityStage Version 9.1 2. Tutorial: Enhancing an address rule set in the Standardization Rules Designer In this tutorial , you will use the IBM InfoSphere®... [More]
db2pd is a very powerful tool which can be used for troubleshooting many complex issue in DB2 like - high memory usage, locking issues, HADR, and collecting various statistics. It can also be used to find out a simple thing like how long the instance has been up. db2pd with a '-' option displays the uptime for an instance. It displays the number of days and hours the instance has been running. No database connection is required. $ db2pd - Database Member 0 -- Active -- Up 4 days 00:13:14 -- Date 2014-10-27-14.56.06.346538 If the... [More]
Informix introduced the PSM (Primary Storage Manager); a new backup storage manager in version 12.10 that replaced the previous ISM (Informix Storage Manager). The PSM manages storage devices used for backup and restore requests that are issued by Onbar. This storage manager supports both serial and parallel processing for backup and restore requests. PSM is easier to set up and use, even in embedded environments. You just need to perform four simple steps to configure PSM and take an Onbar backup: Decide where you will create the PSM catalog.... [More]
Inoperative DB2 Package: Packages in DB2, can be dependent on certain types of database objects such as tables, views, aliases, indexes, triggers, referential constraints and table check constraints. If a package is dependent on a database object (such as a table, view, trigger, and so on), and that object is dropped, the package is placed into an invalid state. If the object that is dropped is an UDF, the package is placed into an inoperative state. For an inoperative package, in the SYSCAT.PACKAGES system catalog view, the VALID column shows:... [More]
During crash recovery, if many load operations have to be replayed, then it might take a long time to complete. The load operation will keep the pending operations in transaction logs no matter if it is recoverable load or non-recoverable. These pending operations will be kept in transaction log just before the table status is changed back from "load in progress" state to "normal" state. If the crash recovery starting point - min(lowtranlsn, minbufflsn) is before load pending operations then db2 will have to replay... [More]
IBM Information On Demand (IOD) 2012 will be hosted in Mandalay Bay, Las Vegas from October 21st through 25th. I hope you will have a chance to attend this exciting event to learn about the products in the IBM Software Group InfoSphere portfolio, and see what we can do to help you and your business compete in today's challenging global economy. Here is a short overview of the event from my own personal experience, and some suggestions to help you prepare before you head out to the Silver State. When you first check in to the event, you will be... [More]
Here is a list of license documents that may help resolve the DB2 license errors you encounter with DB2 on Linux, Unix and Windows: Knowledge Collection DB2 License Issues Useful DB2 license references from our Information Center: DB2 License Files db2licm - License management tool command License Center overview db2connectactivate -Server License Activation Utility Activating the license key for DB2 Connect Unlimited Edition (system z) Setting the DB2 license policy using the db2licm command Setting the DB2 license policy using the License... [More]
IBM Support Portal - updated in May based on your feedback Last week, IBM significantly updated the IBM Support Portal with improvements to make this worldwide one-stop site for technical resources for all IBM products even more effective and useful for our clients. Some are adjustments our clients have requested, others are redesigns to improve our clients' efficiency in finding the information they need. Here's a quick rundown of new capabilities to look for. Click on the highlights image to the right for a full-size version of the associated... [More]
100 Tech Tips: #86 What information is in the name of the db2fmp The db2fmp or DB2 Fenced Mode Process
is used to run untrusted external routines. These routines can be
created in a variety of languages and can be thread-safe (meaning it
is safe to run them in a multi-threaded db2fmp process with other
unrelated routines), or not thread-safe (meaning they will be run in
a single db2fmp process). The name of the db2fmp in the ps output
can be used to determine the language and thread-safeness of the
db2fmp. The name also indicates if... [More]
Do you see different results for same query from Websphere Application, even though the underlying data is not changed? Consider a table with column of datatype decimal(5,2). If you are inserting "0.18999999999999995" into this table multiple times from Websphere applications using JCC drivers, you will see the results as follows: COL1 ----- 0.19 < First Run 0.18 < Second Run 0.18 < Third... [More]
Last week we published popular blogs with the top technical documents for Informix and for DB2 for LUW . Today we bring you the top technical documents for InfoSphere Information Server.
25 Oct 2011: IBM InfoSphere Information Server product documentation 10 Aug 2011: IBM InfoSphere Information Server, Version 8.1, system requirements 13 Jul 2011: IBM InfoSphere Information Server Version 8.5 product documentation 19 Aug 2011: InfoSphere Information Server, Version 8.1 Fix Pack 1, Fix List 03 Aug 2011: System requirements for IBM InfoSphere... [More]
The IBM InfoSphere DataStage and QualityStage Operations Console is a web application that allows the DataStage engine components of an InfoSphere Information Server installation to be monitored in real time. This provides a complete view of all DataStage job runs on that system, both present time and historic. It also includes the monitoring of key operating system metrics such as CPU usage, free memory and disk space. We have gathered few published documents concerning this topic below for you :... [More]
More education content on InfoSphere Information Server - Relocating Information Server 9.1 InfoSphere Data Quality Console exceptions database (ESDB) . Related techdoc #7041978 . This presentation discusses how to relocate the InfoSphere® Data Quality Console exceptions database to another server. It assumes that you are still using the same services tier to manage repository registration in the same metadata repository. This presentation is valid for Information Server version 9.1.
To continue our series covering the most popular technical documents, today we're bringing you a list of the top 10 documents for IBM Optim !
20 Sep 2011: Detailed System Requirements for components of IBM Optim 7.2 03 Nov 2011: Detailed System Requirements for components of IBM Optim 7.3 03 Jun 2011: Detailed system requirements for components of IBM Optim Data Privacy Solution v2.1 28 Jul 2011: Installing your Optim solution in Windows Vista and succeeding Windows platforms 15 Nov 2010: Detailed System Requirements for components of IBM... [More]