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.
Ever wonder where to get a cheatsheet to catalog a connection from a DB2 client to a remote DB2 server on LUW? Here it is with simple step-by-step instructions!!! On the DB2 server: 1) Set the DB2COMM registry variable to tcpip. db2set DB2COMM=tcpip. 2) Verify whether it is set correctly using the following command: db2set -all Output: [i] DB2COMM=tcpip 3)Check the DBM CFG for SVCENAME parameter and make a note of it. db2 get dbm cfg For example: TCP/IP Service name (SVCENAME) = db2c_db2inst1 (Either... [More]
This technote describes how the number of jobs that a DataStage project can have may be impacted by Operating Systems' limitations. When you reach the maximum number of folders the OS allows then you won't be able to create new jobs. Please refer to the technote that lists some suggestions about how to address this problem.
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]
This a great resource to understand how to use APT_DUMP_SCORE and how to read scores in parallel jobs. This document written by the Development team uses a example to show the sections of a typical score and includes descriptions for every section, partition and operator notation, and even suggested self-training excercises Please refer to the published technote
The IBM Software Accelerated Value Program delivers a proactive,
cost-reducing, and productivity enhancing advisory service. The program
pairs you with an assigned team who builds a foundational understanding
of your overall environment. Through that understanding, the trusted
partner works to facilitate faster deployment, lifecycle leadership,
risk mitigation, and more by identifying ways to improve your
environment, staff skill set, and processes. To learn more click on the link .
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 IBM Internet of Things and Informix 2014 Spring / Summer Roadshows are coming to a city near you!!
Registration is now open for two new FREE technical Roadshow events being held through North America.
The first is for anyone interested in the next wave in data processing. Generally referred to as "The Internet of Things", it represents a massive change currently occurring throughout the IT landscape. Unstructured data is flooding into the enterprise and everyone is struggling with how to manage... [More]
At present most of the Informix configuration parameters can be modified dynamically. Typically, users run 'onmode -wf' or 'onmode -wm' command to dynamically change a specific configuration parameter. But there may be a situation when you need to modify multiple parameters at once. For example, you have ten Informix instance and want to tune some of SQL statement cache configuration parameters on all the Informix instances.
Now, you can import a configuration file using onmode command to change multiple configuration... [More]
Did you find an answer that solved your issue? Have trouble finding what you need? Please let us know! Whether you have comments, questions, suggestions or ratings, we love to receive your feedback. Help us serve you better by sharing your feedback! Did you know? IBM Information Management Support experts review every single piece of feedback received on our IBM Support content IBM Information Management Support experts are networking on Twitter, Facebook, and Blogs You can leave us feedback in numerous ways:... [More]
Tune logical and physical log automatically
Starting with version 12.10.xC3 Informix can automatically tune the logical and physical log as needed.
You can set the AUTO_LLOG configuration parameter to enable Informix to dynamically add logical logs when lack of logical logs causes frequent checkpoints, blocking checkpoints, long checkpoints etc. In addition, with AUTO_LLOG configuration parameter you can specify a dbspace in which to create new logical log files and the size of all logical log files at which the server stops adding... [More]
Do you want more details on working with IBM Support ? How about using the IBM Support Assistant ? Everything you need to know about opening a Service Request (SR) with IBM Support can be found here: http://publib.boulder.ibm.com/infocenter/ieduasst/imv1r0/topic/com.ibm.iea.selfassist/selfassist/1.0/work.html .