Posted on Monday, 25th January 2010 by Balazs
Summary
Patching AIX can be intimidating at first for someone coming from the Windows / Linux world. AIX has capabilities that natively support production quality operations. One of these qualities is that one can install patches on an alternative volume, make that volume bootable for testing and allowing an easy way out if something [...]
Tags: AIX 6.1, IBM, Patch, smit, smitty, SUMA
Posted in AIX | Comments (Comments)
Posted on Monday, 28th September 2009 by Balazs
Synopsis
After changing the name of the host on which DB2 9.7 is running, the following error message is received when trying to start the database:
09/28/2009 02:32:50 0 0 SQL6048N A communication error occurred during START or STOP DATABASE MANAGER processing.
SQL1032N No start database manager command [...]
Tags: AIX 6.1, DB2 9.7, IBM
Posted in AIX, DB2 | Comments (Comments)
Posted on Monday, 24th August 2009 by Balazs
Introduction
In large data-warehousing applications, the efficiency of storage systems is critical. With the same hardware and software release, we have seen queries that never terminate (i.e. still runs after a week) under one configuration to be able to finish within hours after optimizations.
Of course in the case of a database like DB2, there are [...]
Tags: AIX 6.1, FC, Fiber Channel, IBM, SAN
Posted in AIX, DB2 | Comments (Comments)
Posted on Saturday, 1st August 2009 by Balazs
AIX has a neat feature that allows to manage a system completely from a browser interface. Since AIX 6.1 TL3, this interface runs on port 80, which makes it easy to find it. However there might be several reasons one might not want to run the AIX Web Based System Manager. For [...]
Tags: AIX 6.1, IBM, IBM Systems Director, ISD
Posted in DB2 | Comments (Comments)
Posted on Thursday, 30th July 2009 by Balazs
Aix allows extending a filesystem on the fly. This feature has been around for over 15 years. I first used it with AIX 3.1. What an AIX system is intalled, it can be set up with minimal requirements and then each filesystem can be grown on the fly as needed. In [...]
Posted on Monday, 8th June 2009 by Balazs
IBM Systems Director is a very powerful management tool that comes free with PowerVM (that is: free to anyone that purchases a Power System). I have gathered here the different steps. Most of the information comes from the official documentation: Installing IBM Systems Director on the management server. In this guide I [...]
Tags: AIX 6.1, DB2 9.5, IBM, IBM Systems Director, ISD, LinkedIn
Posted in AIX, DB2 | Comments (Comments)
Posted on Sunday, 7th June 2009 by Balazs
To mount a CD or DVD in an LPAR, first you need to use the media library to assign one of the CDs in the library to the LPAR. For example, using the ivm inteface:
Click on the lpar name in the “View/Modify Partitions” section
Select the optical devices tab
Create a virtual optical device if there [...]
Tags: AIX 6.1, IBM
Posted in AIX, Linux | Comments (Comments)
Posted on Sunday, 7th June 2009 by Balazs
In case an application such as the IBM Systems Director needs the DB2 client to be installed, the process has a couple of pitfalls. Here are steps that make the installation very simple.
Download the DB2 client from IBM: http://www.ibm.com/software/data/db2/9/download.html
Create a directory and unpack the tarball in that directory, and install the client:
wget ‘https://www6.software.ibm.com/sdfdl/v2/regs2/smkane/dsclients/IBM_DATA_SERVER_CLIENT/Xa.2/Xb.YZomhqTjd0WgkJqNENbocjIpCoqHi4eEhNMEPXE/Xc.v9.5_aix64_client.tar.gz/Xd./Xf.LPr.D1vk/Xg.4962564/Xi.swg-idsc11/XY.regsrvs/XZ.JOzao7W3aaunX0L_IE0SvHPww1I/v9.5_aix64_client.tar.gz’
mkdir db2
cd [...]
Tags: AIX 6.1, Client, DB2 9.5, IBM, Install
Posted in AIX, DB2 | Comments (Comments)