Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Unanswered: Finding Version No. and Language using Command Center

    I am using DB2 Version 8.1 on Windows operating system.
    Is it possible to find the following queries through "Command Center".
    1.)What is the DB2 "version No. " ?
    2.)What is the "language" used in my system?
    3.)What is the "Server Name" i had connected?
    4.) No. of Connections made to server?

    Please Help.......
    Thanks in Advance
    -Anderson

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Finding Version No. and Language using Command Center

    Originally posted by Anderson
    I am using DB2 Version 8.1 on Windows operating system.
    Is it possible to find the following queries through "Command Center".
    1.)What is the DB2 "version No. " ?
    2.)What is the "language" used in my system?
    3.)What is the "Server Name" i had connected?
    4.) No. of Connections made to server?

    Please Help.......
    Thanks in Advance
    -Anderson
    1) use "db2level" OS command or "get connection state"

    2) This is what the administration guide says:

    "The application code page is derived from the active environment when the database connection is made. If the DB2CODEPAGE registry variable is set, its value is taken as the application code page. Normally, you do not need to set the DB2CODEPAGE registry variable, because DB2 automatically derives the code page information from the operating system."

    3) use "get connection state" to determine the database you are connected to. Use "list db directory" to find out the node hosting that database. Use "list node directory" to determine node's host name.

    4) "list applications"

  3. #3
    Join Date
    Jan 2004
    Posts
    30

    Re: Finding Version No. and Language using Command Center

    thanks.. but i couldn't able to get the SERVER NAME and LANGUAGE with these commands. Please give some more tips..

    Thanks
    Anderson

  4. #4
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    type


    db2licm -l


    this will give more info


    --Raju

Posting Permissions

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