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.
Commitment is hard. It's much easier to put your effort toward a quick goal, get it done, and move on. But achieving a quick goal doesn't always provide the best long term results. Last June, our blog authors made a commitment - 100 posts to honor IBM's Centennial anniversary. This post marks the completion of that commitment, and we'd like to say "Thanks" to everyone.
Readers - thank you for your interest. We hope that you find our information relevant and helpful.
Here are the names of some of the authors who have... [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]
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]