Hello

I am using DB2 ESE V9.5 FP5 on windows platform. I am able to perform all the operations on the databases i have like connecting, querying but not able to open db2cc and db2hc neither from run nor from db2cmd command line. The problem is that on running command db2hc or db2cc either it gets hangs in between or the window in which the loading shows disappears suddenly. Can anyone help in this issue....


Thanks.

on checking the db2 logs i found this error:

2011-10-21-01.02.10.294000-240 I568628031H454 LEVEL: Error
PID : 5360 TID : 4680 PROC : db2javit.exe
INSTANCE: DB2 NODE : 000
EDUID : 4680
FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::create, probe:90
MESSAGE : ECF=0x9000004A=-1879048118=ECF_MEM_EXISTS
Shared memory ID already exists with the given resource ID
DATA #1 : String, 46 bytes
OSSEIPC106FPROGRA~1IBMSQLLIBDB2TMPdb2javit.res

Having the exact same problem here. Anybody?

Thanks

Hey, Paste the output of db2set -all and the error in the logs which you are getting on starting db2cc..

db2 installs it's own java alongside the database. Are there other java versions installed on that server?

Sandeep_Sharma:
=============
LOG:
2011-12-27-10.44.41.558000-120 I13722012F455 LEVEL: Error
PID : 20556 TID : 13184 PROC : db2javit.exe
INSTANCE: DB2 NODE : 000
EDUID : 13184
FUNCTION: DB2 Common, OSSe, OSSHIPCMemory::create, probe:90
MESSAGE : ECF=0x9000004A=-1879048118=ECF_MEM_EXISTS
Shared memory ID already exists with the given resource ID
DATA #1 : String, 46 bytes
OSSEIPC106CPROGRA~1IBMSQLLIBDB2TMPdb2javit.res

DB2SET -all:
[e] DB2PATH=C:\Program Files\IBM\SQLLIB
[i] DB2ACCOUNTNAME=SRIBSA019946C09\db2admin
[i] DB2INSTOWNER=SRIBSA019946C09
[i] DB2PORTRANGE=60000:60003
[i] DB2INSTPROF=C:\PROGRAMDATA\IBM\DB2\DB2COPY1
[i] DB2COMM=TCPIP
[g] DB2_EXTSECURITY=YES
[g] DB2SYSTEM=SRIBSA019946C09
[g] DB2PATH=C:\Program Files\IBM\SQLLIB
[g] DB2INSTDEF=DB2
[g] DB2ADMINSERVER=DB2DAS00


dr_te_z:
======

There are two Runtime and one SE that appear into the control panel:

Java 6 Update 13 (Sun Microsystems)
Java 6 Update 21 - 64-bit (Oracle)
Java SE Development Kit 6 Update 13 (Sun Microsystems)

And there is another version at the folder C:\Program Files\IBM\SQLLIB\java
which copyright is as follows:
"Licensed material - Property of IBM.
IBM(R) 64-bit SDK for Windows(R), Java(TM) 2 Technology Edition, Version 5.0
IBM(R) 64-bit Runtime Environment for Windows(R), Java(TM) 2 Technology Edition, Version 5.0
"

Never understood more than 1 java on a server... See if you can make a script so that db2cc only "sees" its own java and classpath.

Neither do I. I'll check it with the server maintenance team and get back here with results.

Thanks :-)

It's the second time it happens. The system simply came back to a regular state. I was planning to reboot the server along with the maintenance people. As I was out of work last week, when I returned this monday and attempted to access the graphic tools they simply got back to normal... No reboot made...

It's so good that things are running fine now, but it's so bad not having any clue about what caused the problem and worse, what resolved it...