Discussion:
DB2 9.1 and CentOS 5 (script error 255)
(too old to reply)
Joachim Selke
2007-10-23 14:26:18 UTC
Permalink
Hi,

according to <http://www-306.ibm.com/software/data/db2/linux/validate/>
DB2 9.1 (Fixpack 3a) is supported on Red Hat Enterprise Linux 5 (RHEL5)
on x86 systems. Since CentOS 5 is binary compatible with RHEL5, DB2
should also run there without problems.

Unfortunately, I have some problems with DB2 9.1 (Fixpack 3a) on a
32-bit machine running CentOS 5. I made a fresh install of CentOS,
disabled SELinux, and then installed DB2 according to the Commons
Criteria Certification guidelines
(<ftp://ftp.software.ibm.com/ps/products/db2/info/vr9/pdf/en_US/db2ese.pdf>).
The installation completes without problems, I also can create and
access the sample database as described in the guidelines.

When starting the DB2 instance "db2inst1" via "db2start" I get the
following error message in /home/db2inst1/sqllib/db2dump/db2diag.log but
db2start still finishes successfully:

-------------------------------------------------------------------------------
2007-10-23-11.36.04.387746+120 I41816G1505 LEVEL: Event
PID : 7346 TID : 3085973184 PROC : db2start
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 34 bytes
/home/db2inst1/sqllib/adm/db2star2
DATA #2 : Hexdump, 256 bytes
0xBF8F3650 : 2F68 6F6D 652F 6462 3269 6E73 7431 2F73 /home/db2inst1/s
0xBF8F3660 : 716C 6C69 622F 6164 6D2F 6462 3273 7461 qllib/adm/db2sta
0xBF8F3670 : 7232 004E 4F4D 5347 0000 0000 0000 0000 r2.NOMSG........
0xBF8F3680 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3690 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F36F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3700 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3710 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3720 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3730 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0xBF8F3740 : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2007-10-23-11.36.04.781131+120 E43322G758 LEVEL: Severe
PID : 7348 TID : 3086396064 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloKADetermineKernelIntegrity,
probe:30
DATA #1 : <preformatted>
Indeterminable operating system.
CALLSTCK:
[0] 0x0160A91B _Z30sqloKADetermineKernelIntegrityP8sqlekrcb + 0x6A7
[1] 0x01609309 _Z13sqloKAAnalyzeP8sqlekrcb + 0x85
[2] 0x0805298B /home/db2inst1/sqllib/adm/db2star2 + 0xA98B
[3] 0x0804E3CB DB2StartMain + 0x2543
[4] 0x0804BE7F main + 0x27
[5] 0x43ADEDEC __libc_start_main + 0xDC
[6] 0x0804BDC1 __gxx_personality_v0 + 0x329
[7] 0x00000000 ?unknown + 0x0
[8] 0x00000000 ?unknown + 0x0
[9] 0x00000000 ?unknown + 0x0

2007-10-23-11.36.06.988431+120 E44081G1209 LEVEL: Event
PID : 7348 TID : 3086396064 PROC : db2star2
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09013"
with level identifier "01040107".
Informational tokens are "DB2 v9.1.0.3", "s070914", "MI00219", Fix Pack
"3a".
DATA #2 : System Info, 436 bytes
System: Linux skydev.l3s.uni-hannover.de 6 2 i686
CPU: total:2 online:2 Cores per socket:4 Threading degree per core:1
Physical Memory(MB): total:2063 free:1569
Virtual Memory(MB): total:4047 free:3553
Swap Memory(MB): total:1984 free:1984
Kernel Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:1024
msgNumberOfHeaders:65536 msgMaxQueueSize:65536
msgMaxSegmentSize:16 shmMax:4294967295 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
-------------------------------------------------------------------------------

This alone would not be a problem but there are some other strange
problems. I want to use the DB2 Control Center to do some adminstrative
stuff from my desktop machine. But everytime I try to connect to the
database via "Add database" in DB2 Control Center (installed on my
desktop machine) I get the following error message:

'SQL22220N The DB2 Administration Server encountered a script error.
Script error code "255"'

The same happens on other desktop machines running Windows and Linux. I
have no idea what is wrong here. The error message does not help me. The
failed connection request also creates error messages in
/home/db2inst1/sqllib/db2dump/db2diag.log and
/home/dasusr1/das/dump/db2dasdiag.log.

/home/db2inst1/sqllib/db2dump/db2diag.log says:
-------------------------------------------------------------------------------
2007-10-23-11.38.50.674193+120 I45291G210 LEVEL: Error
PID : 7555 TID : 31632272
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : Sint32, 4 bytes
255
-------------------------------------------------------------------------------

/home/dasusr1/das/dump/db2dasdiag.log says:
-------------------------------------------------------------------------------
2007-10-23-11.41.40.312138+120 I8993G387 LEVEL: Error
PID : 7843 TID : 99625872
FUNCTION: DB2 Tools, DB2 administration server, db2dasKnownDscv, probe:96
DATA #1 : String, 142 bytes
Warning: DAS encountered problem when running the db2genp utility from
the DB2 instance /home/db2inst1/sqllib of the version 9010003.
DATA #2 : Sint32, 4 bytes
-22220

2007-10-23-11.41.40.312746+120 I9381G446 LEVEL: Error
PID : 7843 TID : 99625872
FUNCTION: DB2 Tools, DB2 administration server, db2dasKnownDscv, probe:32
DATA #1 : String, 234 bytes
Info: There are '1' versions (V81FP8 or above) found on the system by
discovery.
Among these versions, the number of versions that successfully ran
db2genp
are '0'. For the possible error details, please see the log above.
-------------------------------------------------------------------------------


My problem seems to be related to
<http://www.ibm.com/developerworks/forums/dw_thread.jsp?forum=842&thread=177389>
but the hints given there do not help me.

Does anybody know what went wrong here?

Joachim
Joachim Selke
2007-10-24 09:09:06 UTC
Permalink
Post by Joachim Selke
Unfortunately, I have some problems with DB2 9.1 (Fixpack 3a) on a
32-bit machine running CentOS 5.
I tried the same with a fresh installation of Ubuntu 6.06 LTS on a
different machine. This Ubuntu release should also be able to run DB2,
according to <http://www-306.ibm.com/software/data/db2/linux/validate/>.

But here I have almost the same problems. The error message in
/home/db2inst1/sqllib/db2dump/db2diag.log when starting the database
instance now is gone. But the other errors remain the same when I try to
connect to the database via the Control Center.

Maybe there is one thing I should add: The servers I installed DB2 on
are virtual machines (VMware ESX server). But this type of
virtualization also is supported by IBM, so I don't think that the
virtualization is related to my problem.

Unfortunately, I cannot contact IBM support directly because we licensed
DB2 within the "IBM Academic Initiative" program.

Loading...