Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 957
  • Last Modified:

Cannot connect to DB2 second instance

Hi,
  I had 5 databases running in the same instance. All good until now.

  I created a second instance and a third instances.

As I know for each instance, 2 processes has to start on db2start (db2tcpcm)

But for the second instance does not start any.

Any idea?


mariuso@themachine:~> ps aux | grep db2tcpcm
inst1 32421  0.0  0.0 44956  988 ?        S    Apr20   0:00 db2tcpcm
inst1 32422  0.0  0.0 44956  984 ?        S    Apr20   0:00 db2tcpcm
inst3 32423  0.0  0.0 44956  1984 ?        S    Apr20   0:00 db2tcpcm
inst3 32424  0.0  0.0 44956  1984 ?        S    Apr20   0:00 db2tcpcm


no db2tcpcm on inst2


0
mariuso
Asked:
mariuso
1 Solution
 
sachinwadhwaCommented:
any messages in db2diag.log file ??
0
 
mariusoAuthor Commented:
I see:
2006-04-27-15.13.17.618707   Instance:inst2   Node:000
PID:22462(db2batch)   Appid:*LOCAL.inst2.060427131317
oper_system_services  sqloclose   Probe:36

errno: 0900 0000                                     ....

2006-04-28-11.18.05.917847   Instance:inst2   Node:000
PID:9776(db2wdog)   Appid:none
oper_system_services  sqloRunInstance   Probe:98

DiagData
0100 0000                                     ....



------


In jdbcerr.log:
(Fri Apr 28 07:35:29 2006) pid= 32298 jdbcServiceConnection(): Invalid Request R
eceived., einfo= 0 (client IP = 127.0.0.1)

0
 
sachinwadhwaCommented:
try dropping the instance and re-creating it.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
ghp7000Commented:
you probably have run out of memory, therefore the service cannot start and neither can the instance.
Or, make sure you have the node set to zero and that you have swithced instances


db2 get instance-this command tells you which instance is the active instance
to set the instance:
set db2instance=INSTANCE NAME
then, start the instance
db2start
0
 
mariusoAuthor Commented:
Solved in this way:


enter 'db2set DB2COMM' If you get a line reading 'DB2COMM=tcpip' the server is enabled for TCP/IP communication.
If not: enter 'db2set DB2COMM=tcpip' and then restart the database manager: db2stop<enter> db2start<enter>


see also : http://www.experts-exchange.com/Databases/IBM_UDB/Q_20487044.html
0
 
GranModCommented:
PAQed with points refunded (500)

GranMod
Community Support Moderator
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now