AIX (Advanced Interactive eXecutive) is an operating system developed by IBM for business all across the world that needs data metrics that can keep up with the ever-changing scope of business in today’s world. AIX is a version of UNIX. AIX is designed to work on a number of computer platforms from the same manufacturer. On its launch, the system was designed for IBM’s RT PC RISC workstation.
AIX was developed with Bourne Shell
as the default shell for three versions of the OS. Afterwards, it was changed
to KornShell going forward from version 4. The OS uses Common Desktop
Environment (CDE) as the default user interface for graphics. The System
Management Interface Tool on the OS allows users to access the menu using a
hierarchy of commands instead of the command line.
The operating system works on a number of hardware platforms. The initial OS was designed for the IBM RT PC and used a microkernel that controlled the mouse, disk drives, keyboard, and display. This allowed users to use all these components between operating systems by the use of a hot key-the alt+tab combination. The OS was also fitted on newer systems such as the IBM PS/2 series, IDM mainframes, AI-64 systems and can also be used with the Apple’s server network. AIX is commonly used on IBM’s 64-bit POWER processor and systems. AIX can run most Linux applications (after recompiling) and has full support for Java 2.
Since its introduction to computer infrastructure, the operating system has undergone a lot of upgrades with five versions released since 2001. The latest version of the software is the AIX 7.2. All of these come with a high tech security system and fast uptimes.
As an operating system AIX has become popular with students who learn quickly by working on AIX projects live. Working professionals have also been attracted by the dependability of the system and the intuitive that is part of its design.
End of Support for IBM InfoSphere Information Server 9.1.0
IBM InfoSphere Information Server 9.1.0 will reach End of Support on 2018-09-30. If you are still on the InfoSphere Information Server (IIS) 9.1.0, I hope you have a plan to migrate to an 11-series version soon. InfoSphere Information Server (IIS) 11.7 would be worth considering if you don’t already own an 11-series license. InfoSphere Information Server (IIS) 11.7 will allow you to take advantage of the evolving thin client tools and other capabilities in the 2018 release pipeline without needing to perform another upgrade.
IBM Support, End of support notification: InfoSphere Information Server 9.1.0
I had a reason this week to perform a substring on a character in Netezza this week, something I have not had a need to do before. The process was not as straightforward as I would have thought, since the command is explained as a static position command, and the IBM documentation, honestly, wasn’t much help. Knowing full well, that text strings are variable having to provide a static position is not terribly useful in and of itself. So, we need to use an expression to make the substring command flexible and dynamic.
I did get it work the way I needed, but it took two commands to make it happen:
The First was the ’instr’ command to identify the field and character I wanted to substring on: instr(<<FIELD_NAME>>,’~’) as This provides the position number of the tilde (~).
The second was the ‘substr’ command in which I embedded the ‘instr’ command: substr(<<FIELD_NAME>>,0,instr(<<FIELD_NAME>>,’~’) )
This worked nicely for what I needed, which was to pick out a file name from the beginning of a string, which was delimited with a tilde (~)
Substring on a Character Command Format
This format example starts with position zero (0) as position 1 of substring command and goes to the first tilde (~) as position 2 of the substring command.
, instr(<>,’~’) as pos2
, substr(<<FIELD_NAME>>,0,instr(<<FIELD_NAME>>,’~’) ) as Results
IBM Knowledge Center, Home, PureData System for Analytics 7.2.1, IBM Netezza database user documentation, Netezza SQL basics, Netezza SQL extensions, Character string functions
During the course of the week, the discussion happened regarding the different places where a person might read the DataStage and QualityStage logs in InfoSphere. I hadn’t really thought about it, but here are a few places that come to mind:
IBM InfoSphere DataStage and QualityStage Operations Console
IBM InfoSphere DataStage and QualityStageDirector client
IBM InfoSphere DataStage and QualityStageDesigner client by pressing Ctrl+L