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.
This will start a series of blog post concerning the Optim End of Service (EOS) for September 2014.
To ensure you are ready for the Optim products reaching EOS in September , here is a summary.
End Of Support
Optim Development Studio
Informix 12.10.xC4 is released (eGA) today, 19 June 2014. GA date is 2 July 2014.
Enterprise Replication conversion and reversion requirements
JSON compatibility conversion and reversion requirements
Easier to import tables with large rows
Easier installation of 32-bit programs on Windows 64-bit operating systems
Uninstall Informix programs on Windows from the Control Panel
The best-fit Java class for an Informix DATETIME value is java.sql.Timestamp. Java.sql.Timestamp technically inherits from java.util.Date; although, there are some semantic differences which are not typical of inheritance relationships. All the constructors, getters, and setters which are not deprecated for Date and Timestamp use values based on Greenwich Mean Time (GMT). They are offsets in milliseconds from the epoch, January 1, 1970 00:00:00 GMT. So, it would be logically consistent for Timestamps to convert to DATETIMEs using the GMT... [More]
PureData System for Analytics (PDA), Netezza Platform Software (NPS) will be ending patch support for the maintenance release v7.0.0 on June 30, 2014. This means that no more fixpacks or patches will be created for 7.0.0 after June 30, 2014.
The last regularly scheduled quarterly Fixpack (184.108.40.206) was posted to Fix Central on December 24, 2013.
You may still open PMRs for version 7.0.0 after June 30, 2014. However, should you encounter a new bug or issue, any code changes made to address... [More]
Common Issue: InfoSphere Data Architect (#IDA): IC93016 ERROR DIALOG POPS UP WHEN PRINTING A DIAGRAM IN DATA STUDIO Fixed in V9.1.1
Good News!! This issue and more are fixed in InfoSphere Data Architect version 9.1.1
The full list of fixed APAR's can be viewed here - http://bit.ly/IDAAPAR
What's New and Changed in IBM InfoSphere Data Architect 9.1.1 - http://bit.ly/1ozx9Rb
Get to the latest by Downloading InfoSphere Data Architect... [More]
One of our clients has a JCC application going through a DB2 Connect gateway connecting to DB2/Z database, instead of direct connection to DB2/Z. They wanted to know how to setup the automatic client re-route(ACR) if the DB2 Connect goes down.
Here are the steps:
In the case of the DB2 Connect server, because there is no requirement for the synchronization of local databases, you only need to ensure that both the original and alternate DB2 Connect servers have the target IBM mainframe database cataloged in... [More]
Did you know that IBM has extended software support agreements? Depending on the product, IBM has a commitment with its customers to provide product and technical support on software products for a designated amount of time, after the product has reached end of support (EOS) also known as end of life.
Once a product reaches EOS, the support is no longer available for purchase or technical support without an extended support agreement. The lifecycle policy indicator determines how long IBM will continue to support the product once it has... [More]
The current JDBC driver shipped with DB2 called the IBM CLIENT DRIVER FOR JDBC AND SQLJ can function as both a JDBC Type 4 and JDBC type 2 driver.
Type 4 Mode
When functioning as a JDBC type 4 driver, the driver is independent of the DB2 Client and only the driver jar db2jcc.jar or db2jcc4.jar need be installed. In this mode all TCP/IP command execution and routing is done through Java. In type 4 mode the driver requires the TCP/IP name and port of the server and uses the name of the database alias at the server. ... [More]
Hostname of operating system needs to be changed ?
I believe it's not frequent work. But those cases sometimes happen. For example, some naming policies changes or post work after solution package software delivery.
Changing hostname is not the difficult work itself in operating system administrator's perspective.
But if multiple softwares starts to up and running on the system, it needs to be handled very, very carefully especially with high availability cluster... [More]
The following #OPTIMTools YouTube videos will help you identify, diagnose, solve, and prevent performance problems before they impact the business.
Overview of Performance Monitoring
Proactively and Reactively Monitor Performance with Alerts
Monitor and Analyze Stored Procedures
Identify and Resolve Slow Queries
From DB2 V9.7 Batched INSERT statements can return automatically generated keys.
If batch execution of a PreparedStatement object returns automatically generated keys, you can call the DB2PreparedStatement.getDBGeneratedKeys
method to retrieve an array of ResultSet objects that contains the automatically generated keys.
Recently I had a customer trying to use getDBGeneratedKeys method with Batch inserts in a JDBC application using JCC driver and was looking for an example.
Here is an example of how to use the... [More]
To collect explain output for a stored procedure (the stored procedure will be executed) :
db2set DB2_SQLROUTINE_PREPOPTS="EXPLAIN ALL"
Run the stored procedure
db2exfmt -d db_name -g TIC -w -1 -n % -s % -# 0 -o exfmt_bad.txt
To collect explain output for a stored procedure without executing it, you need to set db2set DB2_SQLROUTINE_PREPOPTS and db2 set current explain mode.
db2set DB2_SQLROUTINE_PREPOPTS="EXPLAIN ALL"
InfoSphere Information Server 9.1.2 introduced new connectivity option : JDBC Connector
JDBC connector in InfoSphere Information Server is used to connect to supported JDBC data sources and perform data access and metadata import operations on them.
Before you can use the JDBC connector , you must set up the driver configuration file . The connector uses this file to obtain information about the available JDBC drivers in your system.
Refer to the page to learn how to design jobs with JDBC... [More]
InfoSphere Information Analyzer provides capabilities to profile and analyze data to deliver trusted information to your organization
We have gathered few interesting links and information about InfoSphere Information Analyzer that can be useful for you
Visit the site for configuring IBM InfoSphere Information Analyzer (You must have Information Analyzer Data Administrator authority)
This link takes you to the frequently asked questions about IBM InfoSphere Information Analyzer
The log files... [More]
PureData System for Analytics (PDA), Netezza Platform Software (NPS) will be ending patch support for the maintenance release v6.0.8 on December 31, 2014. This is the final fix for version 6.0.x. This means that no more fixpacks or patches will be created for 6.0.8 after December 31, 2014.
The last regularly scheduled quarterly Fixpack (220.127.116.11) will be posted to Fix Central on or before June 30, 2014. Additional patches or fixpacks will be created on an as needed basis for the remaining 6 months of patch support.... [More]