Link to home
Get AccessLog in
Avatar of contr315
contr315

asked on

How to get server name/cpu count/udb version via sql queries

I need to get the CPU count, database version, name (or I could settle for the IP if the name isn't avaiable) of server holding the UDB database.  We cannot use O/S utilities because we have no access to the O/S, we can just connect via jdbc to access the data.  Ideally we also can see the fixpack levels for the UDB database.
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image


Hi contr315,

I'm curious -- why do you need to know the underlying O/S and DB environments?


Kent
Avatar of contr315
contr315

ASKER

We need to enforce licensing of the server.  The licenses are issued for a particular server with a set number of cpus.

License enforcement should be a function of the server.  It's too difficult (if not impossible) to manage from the client side.



Kent
ASKER CERTIFIED SOLUTION
Avatar of db2inst1
db2inst1
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Or you should install System Inventory agents e.g Tivoli  on Server.
It looks like this query would work, but it seems to only be supported in 8.2.2 and higher.

SELECT HOST_NAME, TOTAL_CPUS
   FROM TABLE(SYSPROC.ENV_GET_SYS_INFO()) AS SYSTEMINFO