Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2009
    Posts
    6

    Unanswered: db2tcpcm service not running.

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Nov 2009
    Posts
    6
    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 View Post
    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

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  5. #5
    Join Date
    Nov 2009
    Posts
    6
    Not really.... I am totally new to db2..

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

    Quote Originally Posted by ARWinner View Post
    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

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by sangfroid View Post
    by the way, where does db2 store its database files ?
    Wherever the DBA tells it to.

    Andy

  7. #7
    Join Date
    Nov 2009
    Posts
    6
    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 View Post
    Wherever the DBA tells it to.

    Andy

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by sangfroid View Post
    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"

  10. #10
    Join Date
    Nov 2009
    Posts
    6
    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..

  11. #11
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sangfroid View Post
    ok, where can i get basic tutorials of db2 ? I tried to search a lot....but hardly could find any useful one...
    Try these: IBM developerWorks : DB2 9 Fundamentals certification 730 prep series
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •