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.
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]
I thought I would get my BLOG started by saying I'm excited about 12.10 the latest and greatest INFORMIX
DYNAMIC SERVER which was available for download as of March 26.
When downloading the product from Passport Advantage (PPA) you will notice a new naming convention.
In a nutshell, as far as name changes go, Growth became Workgroup, Ultimate became Enterprise, and Warehouse became Advanced.
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-22.214.171.1242013')"
3> Select from timestamptest
IBM Software Support Handbook provides guidelines and reference materials that you may need when you require IBM service and support.
Actual terms and conditions are found in the license materials for your software.
IBM Software Support Handbook includes the following objectives :
Introduce you to IBM Software Support
Share information on the people that make up our World Wide (WW) IBM Software Support Organization
Provide information on the support... [More]
There are multiple ways to migrate to InfoSphere Information Server, Versions 8.5, 8.7, or 9.1 depending on the version of InfoSphere DataStage or InfoSphere Information Server you are migrating from, the InfoSphere Information Server products installed, and other factors. IBM offers a Concierge Program for free to provide guidance on the best approach to migrate to Information Server, Version 8.5, Version 8.7, or Version 9.1.
The Concierge Program is offered to all customers, but it is particularly important for customers using the... [More]