I am new to DB2 and have had such a pain with DB2. I had to manually install and configure my P-series Redhat Linux server with DB2. The gui install froze on us so I had to do everything manually using the IBM Installation and Configuration supplement. I am running Admin Client 8.1.0.36, RedHat Linux AS 2.1 on the server, DB2 UDB 8.1 on the server. Here is where I am: I have installed DB2 on the server, created an instance called db2inst2. I have 3 linux users called db2inst2 (group name db2iadm1), db2fenc1 (group name db2fadm1), and db2as (group name db2asgrp).


Here is my problem at this point, there may be more to come later I am sure once I get past this point.I am able to go into the Control Center on my Windows XP workstation and I can see the Linux Server (name LinuxDB2). I can click the + beside the system and see the instances folder and under that I see DB2LINUX (db2inst2). I had already previously cataloged the TCPIP node using the client command line. The port # is the same on both the client and the server (40000). Whenever I try to create a database it asks for a username/password, I put in the instance owner username of db2inst2. It then pops up with an error SQL22204N. I am thinking it is something I have missed in the setup either on the server or client side.

DB2 & UDB email list listserv db2-l LazyDBA home page