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.
External Stored procedures and UDFs (collectively referred to as routines) that utilize the database are susceptible to the same performance issues as any other application. Unlike other database applications, external routines are run in DB2 processes that are managed by an infrastructure. This infrastructure can be configured through the Database Manager Configuration or the dbm cfg.
In this blog post I will explain some of the dbm cfg parameters that are related to external routine performance, including KEEPFENCED,... [More]
Below are five new self-assist videos in the IBM Electronic Support tools and resources section of the IBM Education Assistant website:
What is IBM Support Assistant?
Glossary of support terms
Glossary of technical support documents
IBM Electronic Support overview
Finding online support for IBM FlashSystem
IBM Software Group InfoCenter is organized in the same way, so the information below applies to MDM versions, as well as other IBM software such as Websphere and DB2 products.
MDM v10.0 to the latest MDM v11.0 combined three different MDM products: MDM Server, MDM Collaboration Edition and MDS. Since the three individual MDM products combined into one product family, the InfoCenter documentation is combined as well.
Sometimes when you need to search on MDMCS documentation from the combined InfoCenter, and you want to avoid the... [More]
Important Announcement: IBM InfoSphere Master Data Management Collaboration Server versions 10.0.0 and 10.1.0 are being merged. Please see the following technote for detail.
The CLP or Command Line Processor is the primary and lowest level interface available for DB2 LUW. It is capable of running SQL statements and DB2 commands, changing the DB2 Configuration and running DB2 scripts. The clp “db2” command can even be added to OS scripts to execute DB2 commands. The CLP also has various options that can be used to change its behavior, a few of these are:
-c option. This option changes the autocommit behavior. By default autocommit is on and the CLP issues a commit after every query... [More]
Hot off the press!! The Q2 2013 Support Newsletter for our IP&S products has just published!
If you are interested in support resources for any of the following products, check out the newsletter for tips, tools, and info:
InfoSphere Information Server
InfoSphere Data Replication
InfoSphere Replication Server
InfoSphere Change Data Capture
InfoSphere Master Data Management Server
InfoSphere Master Data Management Collaboration... [More]
The IBM Information Management best practices present advice on the optimal way to use a variety of IBM Information Management products. They include technical papers, presentations, and articles authored by leading experts in IBM's development and consulting teams and are designed to give you practical advice to improve the value of your IBM data servers and data integration products.
Best practices for IBM InfoSphere Information Server
These best practices papers present advice on ways you can... [More]
IBM offers a number of information management related free ebooks that were written and published with the cooperation of subject matter experts and the community
Please see the some of published free ebooks :
Understanding Big Data :
In this book, the three defining characteristics of Big Data -- volume, variety, and velocity, are discussed. You'll get a primer on Hadoop and how IBM is 'hardening' it for the enterprise, and learn when to leverage IBM InfoSphere BigInsights (Big Data at... [More]
SQL0428N error is easy to resolve provided you have actual SQL statement causing the error. Here is more information about actual error message link
The SQL statement is only allowed as the first statement in a unit of work.
Issue a COMMIT or ROLLBACK prior to processing the SQL statement. If there are any WITH HOLD cursors, these will need to be closed. If the statement is SET INTEGRITY, remove the COMMIT THRESHOLD clause.
Adding a COMMIT or ROLLBACK prior to SQL... [More]
Informix RFE ( R equest F or E nhancement) Process
Learn how the RFE process works in the IBM RFE Community. In the RFE Community, you can collaborate with IBM development teams and other product users through your ability to search, view, comment on, submit, and track product requests for enhancement (RFEs )
Submit from the IM RFE site – simply complete the RFE form and click Submit when ready
Many fields will be auto-filled as a convenience for you
Note that fields with the ‘key’ field e.g. Company... [More]
Keeping track of your Netezza product names and model numbers can be tricky. The list below summarizes this information in a quick reference table.
IBM Netezza product names and models numbers
Product Line A : PureData System For Hadoop
Product Line B : PureData System for Analytics
Models : "TwinFin product line":
Looking for information about end of support dates for DB2 products on Linux, Unix and Windows to plan ahead for upgrade?
Here are the some links you will find it useful.
List of End of support dates for different versions of DB2 Products on Linux, Unix and Windows:
Common FAQ on End of Support products:
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... [More]
Check this out!
Here is a full list of Developer Works articles on DB2 for Linux, Unix and Windows Optimizer that our experts have published to this date which you may find useful.
1) Get the most out of DB2 optimizer: Leveraging statistical views to improve query execution performance
2) Recreate optimizer access plans using db2look
3) ... [More]
Recently I came across a problem, where we saw the timestamp value returned by DB2 Java application was off by 1 hour than the actual timestamp value being stored in database. This was happening only for timestamp values falling in Daylight Savings range. These are the steps I used to reproduce the issue:
1> Create table timestamptest( col1 timestamp)
2> db2 "insert into timestamptest values ('2013-03-10-188.8.131.522013')"
3> Select from timestamptest