Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003

    Unanswered: How to findout the number of CPUs / Cores the instance is running?

    Hi All,

    I am a newbie, and currently constructing a program that want to act differently according to the number of CPUs / Cores available on the machine running the instance.

    Is there a query that I can execute and show me the number? I know there is a setting for the degree of parallelism, but it could be 'ANY', and the setting may not reflect the actual number of CPUs / cores.

    I am currently using IBM DB2 9.7 Windows version.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    If you are using DB2 Express-C (free version) Db2 will only use up to 2 of the Cores. Anything else, DB2 will use whatever is there.


  3. #3
    Join Date
    Jul 2006
    Pune , India
    Environment administrative views: Supported administrative SQL routines and views
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Oct 2003
    Thanks, I got what I need by using the following SQLs:

    --to get the env db info
    select * from SYSIBMADM.ENV_PROD_INFO

    --to get system info
    select * from SYSIBMADM.ENV_SYS_INFO

    I have all the OS, DBMS, and CPU information

Posting Permissions

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