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.
I-Spy returns an authentication error 951 when a user opens a database.
$ 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... [More]
Six new IBM Education Assistant (IEA) training modules are now in production. Please see the details below:
Subscribing to Platform Computing patch notifications - This video demonstrates how to subscribe to Platform Computing patch notifications using the IBM MyNotifications service.
IBM Support Assistant 5.0 Team Server: New features - This video demonstrates new features introduced in IBM Support Assistant Team Server V5 Fix... [More]
By default, 64 bit Windows versions use a 64 bit ODBC Administrator utility. How do I install a 32 bit version of ODBC to work with IBM Informix Dynamic Server, when I am using a 64 bit Windows version?
The menu option Administrative Tools->Data Sources (ODBC), is the Windows 7 utility used to maintain ODBC data sources and drivers. The path for this ODBC administrator utility is "%windir%\system32\odbcad32.exe". Although it is referenced as "32" in the path name, it is a 64 bit... [More]
You install IBM Informix Client Software Development Kit (CSDK) 3.70.FC4 or higher on a machine running a Windows operating system. The installation does not include OpenAdmin Tool (OAT). You note that OAT is included when you install the 32-bit Windows CSDK 3.70.TC4
OAT is first bundled with CSDK in 3.70.TC4 fixpaks (32 bit) . This does not include the 64-bit CSDK 3.70.FC4 or higher on Windows
You can install the 32-bit OAT on a Windows 64-bit machine.
Platforms where OAT is available ... [More]
Puppet is IT automation software that defines and enforces the state of your infrastructure throughout your software development cycle. From provisioning and configuration to orchestration and reporting, from initial code development through production release and updates, Puppet frees sysadmins from writing one-off, fragile scripts and other manual tasks. At the same time, Puppet ensures consistency and dependability across your infrastructure.
With Puppet, repetitive tasks are automated away, so sysadmins can quickly deploy business... [More]
Basic identification of system problems - This presentation discusses and demonstrates how to identify system level problems the PureData for Analytics Appliance. This includes using the command line interface, viewing diagnostic log data, running the System Health Check utility, and using graphical tools, including the Netezza Administration Tool and the Netezza Performance Portal. Related Techdoc #7042884.
There is a new IBM Education Assistant video available titled "How to start and stop a PureData System for Analytics" . This presentation provides details regarding the system environment, default users and passwords, what commands to use to start and stop a PureData System for Analytics and what to monitor during system startup. Related Techdoc #7042881.
Diagnosing a hung Information Server V8.1 - 9.1 DataStage parallel job on Windows - This presentation discusses how to rule out known issues, show how to determine if a parallel job is hung, and if so, it describes the environment variables that need to be set and what information to collect during the hang. DCF #7042477
Relocating QualityStage Match Designer Database - This presentation explains the steps that are required to change the configuration to relocate InfoSphere QualityStage Match Designer database. This is a component of InfoSphere QualityStage that stores the results of match test passes by the InfoSphere QualityStage Match Designer stage. DCF #7042467
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]
IBM PureData System for Analytics is excited to announce the publication of APARs as part of the problem reporting process!
An APAR - Authorized Program Analysis Report - is a formal report to IBM development of a problem caused by a suspected defect, published so that it is visible to supported customers. If IBM development is able to confirm the defect, they will update the APAR with any known workarounds and perhaps an indication of which future release they intend to target for a formal fix to the defect.
APARs are easy to... [More]
The following new IBM Education Assistant videos are in production. These videos will assist you in resolving certain issues without the need for contacting a Technical Support Professional!
Social Media Aggregator in Support Portal
Introduction to IBM Platform MPI
Standard LSF installation on Linux
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]
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]
Andrew wanted to let you know about some new information that has been
posted to iiug2014.org about this year's conference.
Sessions are now available at iiug2014.org/sessions.php
Hands on Labs are now available at iiug2014.org/hol.php
Tutorials are now available at iiug2014.org/tutorials.php
Keynote Speakers this year will be Beth Smith, General Manager IBM
Information Management and good friend of the IIUG Jerry... [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]
Three new IBM InfoSphere Information Server training modules are now in production:
Using dslogger for Information Server version 8 and 9 - The objectives of this presentation are to provide an overview about the dslogger utility, how to install it, how to run it, and how to collect information generated by the tool.
Configuring Information Server 9.1 for Informix - The objectives of this presentation are to explain the required prerequisites before you can connect to Informix, how to configure DataStage to connect to... [More]
Informix 11.70.xC8 is released (eGA) on 9 January 2014. GA date is 14 January 2014.
Informix Developer Edition
Informix Innovator-C Edition
Informix Express Edition
Informix Growth Edition
Informix Growth Warehouse Edition
Informix Ultimate Edition
Informix Ultimate Warehouse Edition
Information Center - http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp
IBM Informix, Version 11.70.xC8... [More]
Check out the 2 new IBM InfoSphere Master Data Management Collaboration Server education modules on the IBM Education Assistant website :
How to resolve 'Out of Memory' errors
Resolving instance startup error '25041'
The following new IBM Education Assistant modules are now in production:
Troubleshooting DataStage engine start up issues
How to create a new Information Analyzer Analysis Engine and configure Information Analyzer to use the new engine
Diagnosing a hung Information Server DataStage Parallel job on UNIX/Linux
Configuring Information Server 9.1 for Sybase
Infosphere Guardium support will end September 30, 2014, but customers may purchase a service extension.
Customers interested in continued support for these versions after the EOS date may purchase a Service Extension (SE) up to 2 years. The fee-based Service Extension provides technical support (e.g. defect corrections, restrictions, and bypasses) for new problems discovered after a product has been withdrawn from support. Fixes are provided at the "then current" corrective service level (Fix Pack, PTF, CSD,... [More]
How to restore critical administrative files with onbar utility?
It is already known to us that onbar backs up some critical administrative files during storage space backup. These critical files are as follows:
The onconfig file
UNIX: The sqlhosts file
The ON-Bar emergency boot file: ixbar.servernum
The server boot file: oncfg_servername.servernum
There may be a situation when you need to restore one of these files, for example: replace disks, restore to a second computer system (imported... [More]
What are the Best Practices for Running Informix Instances in VMWare vSphere Virtual Environments
The document provided in the following link:
What is VMware Virtualization?
Evolution of VMWare Virtualization
Why Informix on VMWare
Informix Scalability Tests
Informix Scalability Test Results
Best Practices for running Informix on VMWare