db2tcpcm service not running.

sangfroid · #1 (**permalink**) 11-24-09, 12:05

Hi,

I have a linux server, which seems to run IBM db2. I am not quite sure if it is running fully functional or not.

When I run ps -ef command, it shows as below:

root 868 1 0 Oct27 ? 00:00:00 db2wdog
db2inst1 869 868 0 Oct27 ? 00:00:00 db2sysc
root 870 869 0 Oct27 ? 00:00:00 db2gds
db2inst1 871 869 0 Oct27 ? 00:00:00 db2ipccm
db2inst1 872 870 0 Oct27 ? 00:00:00 db2resyn
db2inst1 873 870 0 Oct27 ? 00:00:00 db2srvlst

But when I run the same command, it shows an additional db2tcpcm service too...

I am confused what is the purpose of this service and if it is really needed or not ?

By the way, what is the default port that IBM db2 runs on ? Is it 50000 ?

Thank you

ARWinner · #2 (**permalink**) 11-24-09, 12:54

See the attached:

Everything You Wanted to Know About DB2 Universal Database Processes

50000 is the default port that DB2 suggest when creating an instance, but it does not have to be thus. Look in /etc/services for what port is being used.

Andy

sangfroid · #3 (**permalink**) 11-24-09, 12:58

As per this document, then only IBM db2 is running in that server locally...but no one can make connections from out of this server (as db2tcpcm service is not running).

Am I correct ?

Quote:

Originally Posted by ARWinner

See the attached:

Everything You Wanted to Know About DB2 Universal Database Processes

50000 is the default port that DB2 suggest when creating an instance, but it does not have to be thus. Look in /etc/services for what port is being used.

Andy

ARWinner · #4 (**permalink**) 11-24-09, 13:04

I am not certain. I think connections can be made. I have looked at my servers, and I do not see the process, but I can connect from remote workstations. Do you know what DB2 version it is?

Andy

sangfroid · #5 (**permalink**) 11-24-09, 14:07

Not really.... I am totally new to db2..

by the way, where does db2 store its database files ?

Quote:

Originally Posted by ARWinner

I am not certain. I think connections can be made. I have looked at my servers, and I do not see the process, but I can connect from remote workstations. Do you know what DB2 version it is?

Andy

ARWinner · #6 (**permalink**) 11-24-09, 14:09

Quote:

Originally Posted by sangfroid

by the way, where does db2 store its database files ?

Wherever the DBA tells it to.

Andy

sangfroid · #7 (**permalink**) 11-24-09, 16:06

by the way, what command do i run to find it out ?

for eg: what command do i run to see the list of databases and its tables ?

Quote:

Originally Posted by ARWinner

Wherever the DBA tells it to.

Andy

ARWinner · #8 (**permalink**) 11-24-09, 16:10

You need to do everything as the instance owner (db2inst1 in your case).

To see the databases: db2 list db directory
To determine which version: db2level
To see the tables:
db2 connect to MyDB
db2 select tabschema,tabname from syscat.tables

Andy

db2girl · #9 (**permalink**) 11-24-09, 18:15

Quote:

Originally Posted by sangfroid

db2tcpcm service is not running)

Could it be that you're using db2 v9.5 or higher? I don't believe you see db2tcpcm with the ps command in a thread-based model. Try "db2pd -edus"

sangfroid · #10 (**permalink**) 11-25-09, 10:37

I am in fact totally confused...

ok, where can i get basic tutorials of db2 ? I tried to search a lot....but hardly could find any useful one...

all i need to know is how to connect to db2 database and see its databases and tables...

also i need to know where db2 is storing database files...that's it..