Change Host Name of DB2 9.7 Server on AIX

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 was issued. SQLSTATE=57019

Solution

For each database instance on the machine where the name changed, and on each federated server instance, the file $INST_HOME/sqllib/db2nodes.cfg needs to be edited, and the old host name changed to the new name for each occurrence. The format of the node lines is:
0 host.domain.tld 0

References


Install Open MQ 4.4 on Mac OS X 10.6 (Snow Leopard)

Intro

Snow Leopard comes with a native 64 bit Java 1.6 environment. The Open MQ binaries are made for the JDK 1.5 in 32 bit. This article shows how to make Open MQ work on OS X 1.6 by compiling from source.

Steps

  • Set environment
    export JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Home
    export ANT_HOME=$HOME/apache-ant-1.7.1
    export ANT_OPTS=-Xmx512m
    export IMQ_HOME=$HOME/mq/dist/mq
    export CLASSPATH=$CLASSPATH:$IMQ_HOME/lib/jms.jar:$IMQ_HOME/lib/imq.jar
  • Download and unpack ant in your home directory
  • Download and uppack OpenMQ 4.4 source in your home directory
  • Create extlib:
    mkdir ~/mq/extlib
  • Download the Java EE 5 API into extlib:
    http://download.java.net/maven/1/javaee/jars/javaee-api-5.jar
  • Compile Open MQ:
    cd ~/mq
    ant
  • Test Open MQ:
    cd dist/mq/bin
    ./imqbrokerd -tty &
    cd ../examples/helloworld/helloworldmessage
    java HelloWorldMessage
    You should see
    Sending Message: Hello World
    Read Message: Hello World
    And some debug messages on the imqbrokerd console.

References