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.

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.

Andy

Environment administrative views: Supported administrative SQL routines and views

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