Installing IBM DB2 v. 8.x on Linux without X11

To install DB2 manually follow the below steps:

  1. Download DB2 v.8.x for Linux (I downloaded v. 8.1 Express) and transfer the gzip’ed tar-file to the Linux box.
  2. Unpack the distribution to the /tmp directory:

    tar zxf DB2ExE82_Linux.tar.gz -C /tmp
  3. Change to root and go to the unpacked DB2 directory and start the installation:

    cd /tmp/Linux
  4. Select the package to install – I chose “DB2.EXP” since I was installing DB2 Express.
  5. Create an user for the DB2 instance and an user for the administration server (make sure the users belong to a valid group and that the users have a home directory):

    useradd db2inst1
    useradd db2as
    groupadd db2inst1
    groupadd db2as
    mkdir /home/db2inst1
    mkdir /home/db2as
    chown db2inst1:db2inst1 -R /home/db2inst1
    chown db2as:db2as -R /home/db2as
    <associate the group with the user e.g. using yast under SuSE or manually editing
    the /etc/groups file if you are so inclined>
  6. Create an instance:

    cd /opt/IBM/V8.1/instance
    ./db2icrt -u db2inst1 db2inst1
  7. Create the administration server:

    cd /opt/IBM/V8.1/instance
    ./dascrt -u db2as
  8. Set the environment for the db2inst1 user by adding the following to the users ~/.profile:

    export DB2INSTANCE=db2inst1
    export DB2PATH=~/sqllib
    export PATH=$PATH:$DB2PATH/bin
  9. Log in as the db2inst1 user and check the installation by creating the SAMPLE database:

    su - db2inst1


Sametime login issues

The problem was that we got confused with the difference types of server names needed in different places. If you got confused what are you doing setting up Sametime servers one might ask, but in our defense this is the first time we experienced this problem. Whether we have just been “lucky” I don’t know. Anyways…

When setting up Sametime for an user you need to input the Sametime server on the person document in the Domino Directory and the Sametime server on the users location document. The problem turned out to be that the server name on the person document should be the fully qualified name of the server (e.g. Sametime1/XYZ/Example) and the server name on the location document should be a resolvable hostname or IP address to the server (e.g. / Once we found this out configuring it was a breeze using the Domino Administration and policies.

So much for easy to read documentation… 🙂

Update (18 February 2005): Apparently not the only one being confused – a technote has been published.

Thoughts for a shared mail database

The number one problem we see in Notes installations is the lack of proper support for shared mail databases. I don’t mean shared mail in the Domino sense but a non-primary mail database where a number of people access and read shared e-mail (e.g. I will now start compiling a list of requirements for this database so we can develop one once and for all.



The following goes in the notes.ini on the server – the settings are quite self explainatory:

JavaStackSize=<size in bytes>

JavaMaxHeapSize=<size in bytes>


'*** Constants ***
Private Const ITEM_MAX_SIZE = 31000

Public Class NotesItemWrapper
	Private pDoc As NotesDocument
	Private pCurrentItem As NotesItem
	Private pItemNames As Variant
	Private pItemIndex As Integer

	' * Constructor.
	' */
	Public Sub New(doc As NotesDocument, item_names As Variant, append_data As Boolean)
		Dim i As Integer

		'store the document
		Set Me.pDoc = doc

		'item_names must be an array of strings or a item
		Forall n In item_names
			If Typename(n)  "STRING" Then
				Error 9999, "The supplied item names but be a string or an array of strings."
			End If
		End Forall

		'make sure the item names are an array
		If Not Isarray(item_names) Then
			Dim v(0) As String
			v(0) = Cstr(item_names)
			Me.pItemNames = v
			'store the item names to use
			Me.pItemNames = item_names
		End If

		'get the first item to use
		If Not append_data Then
			'remove all the items with the supplied names and recreate the first one
			Forall n In Me.pItemNames
				Call Me.pDoc.RemoveItem(n)
			End Forall

			'recreate the first item
			Set Me.pCurrentItem = New NotesItem(Me.pDoc, Me.pItemNames(Me.pItemIndex), "")
			'find the first item to use
			For i=0 To Ubound(Me.pItemNames)
				'get the first item
				Set Me.pCurrentItem = Me.pDoc.GetFirstItem(Me.pItemNames(Me.pItemIndex))

				'is this item below the threshold
				If Lenb(Me.pCurrentItem.Text) < ITEM_MAX_SIZE Then
					'use this item
					Me.pItemIndex = i
					Exit For
				End If
		End If
	End Sub

	' * Appends text to the item checking whether a new item
	' * is required to hold the text. If no more fields are
	' * available we return an Error 9999.
	' */
	Public Sub AppendText(data As String)
		'check whether there is space for the data
		If Me.pCheckSize(data) Then
			'it is ok - append
			Me.pCurrentItem.Text = Me.pCurrentItem.Text + data
			'raise error
			Error 9999, "Not enought space to hold the data."
		End If
	End Sub

	' * Appends a multi-value item to the item(s). If no more space
	' * is available we return an Error 9999.
	' */
	Public Sub AppendToTextList(data As String)
		'check whether there is space for the data
		If Me.pCheckSize(data) Then
			'it is ok - append
			Call Me.pCurrentItem.AppendToTextList(data)
			'raise error
			Error 9999, "Not enought space to hold the data."
		End If
	End Sub

	'* Private methods

	' * Checks the size of the current item. Returns True if the item
	' * can hold the supplied data.
	' */
	Private Function pCheckSize(data As String) As Boolean
		Dim size As Long

		'calculate the item size
		size = Lenb(Me.pCurrentItem.Text) + Lenb(data)
		'Print "Size is: " & size & " (index = " & Me.pItemIndex & ", " & Me.pCurrentItem.Name & ")"

		'decide what to do
		If size < ITEM_MAX_SIZE Then
			'item can hold the byte count
			pCheckSize = True
			'no can do - try and get the next item
			If Me.pItemIndex <= Ubound(Me.pItemNames) Then
				'get the next item
				Me.pItemIndex = Me.pItemIndex + 1
				Set Me.pCurrentItem = New NotesItem(Me.pDoc, Me.pItemNames(Me.pItemIndex), "")

				'return true
				pCheckSize = True
				'no more items
				pCheckSize = False
			End If
		End If
	End Function

End Class

Thought no one was using mod_jk2 anymore…

…but I appear to be mistaken. I am very confused about the availability and the differences between the different mod_jk
* modules. I will have to look into it.

This article explains how to use mod_jk2 under Apache to cluster multiple Tomcat instances behind an Apache web server.