1. db2look failed with following error: $ db2look -d sample -e -o db2look.ddl -- Generate statistics for all creators -- Creating DDL for table(s) -- Output is sent to file: sample.ddl SQL10004C An I/O error occurred while accessing the database directory. SQLSTATE=58031 2. error in db2diag.log 2017-04-11-02.48.11.615491-240 I38860E2300 LEVEL: Error (OS) PID : 28473 ... [More]
I-Spy returns an authentication error 951 when a user opens a database. Example : $ dbaccess sysmaster - 746: I-Spy: SQLERR -951 connecting to shadow server These are some possible solutions for the 951 error: Set INFORMIXSERVER to the shadowserver (database server name) in order to bypass I-Spy. If you are still seeing the 951 error, search other documents specific to the Informix server that addresses the 951 error. Check if the password for this user has expired. Check the permissions on the $ISPY_DIR/bin/realbin/ispy... [More]
Informix 12.10.xC4 is released (eGA) today, 19 June 2014. GA date is 2 July 2014. Feature Outline Migration Server changes Enterprise Replication conversion and reversion requirements JSON compatibility conversion and reversion requirements Easier to import tables with large rows Installation Easier installation of 32-bit programs on Windows 64-bit operating systems Uninstall Informix programs on Windows from the Control Panel Administration Multitenancy in Informix Enhancements to OAT Easier removal of outstanding... [More]
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]
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 logs for... [More]
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 it. While NoSQL... [More]
Why not extend your conference stay another day and attend one of several tutorials to be offered on Thursday May 2nd? This years tutorials are again included as part of your PAID conference registration. Take a minute to check out this year's tutorials and don't miss this fantastic opportunity to get in-depth training in one or more of the following topics: Certification Preparation - Informix 12.10 System Administrator Deploy and optimize IBM Cognos BI with IBM Informix and IWA Acceleration John and Scott's performance tutorial... [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 parameter... [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 .
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.
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
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]
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 .
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]