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. 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]
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 Pack 1. ... [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. 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]
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 find... [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 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]
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 Keesee, Director of IBM Informix Development. You can find... [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]
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 Informix databases using... [More]
Informix 11.70.xC8 is released (eGA) on 9 January 2014. GA date is 14 January 2014. Product Editions Informix Developer Edition Informix Innovator-C Edition Informix Express Edition Informix Growth Edition Informix Growth Warehouse Edition Informix Ultimate Edition Informix Ultimate Warehouse Edition Features: Information Center - http://pic.dhe.ibm.com/infocenter/idshelp/v117/index.jsp IBM Informix, Version 11.70.xC8 contains the following new functionality. For full... [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, etc.). Conditions... [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 restore) etc. However, previously there was no easy way... [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 General Considerations BIOS Considerations CPU Considerations Memory Considerations Network Considerations Storage Considerations NOTE: If you have issues trying to display this within IE but cut... [More]