Personal tools
You are here: Home DB2 DB2 UDB v9 Using sysibmadm to check system configuration
Navigation
Log in


Forgot your password?
 
Document Actions

Using sysibmadm to check system configuration

To see the system configuration you can use the ENV_SYS_INFO view from SYSIBMADM schema.


Perform the select below to check the system configuration.

db2 "select substr(os_name,1,20) as OS_NAME, \
substr(os_version,1,20) as OS_VERSION, substr(os_release,1,20) as OS_RELEASE, \
substr(host_name,1,20) as HOSTNAME, TOTAL_CPUS, CONFIGURED_CPUS, TOTAL_MEMORY \
from SYSIBMADM.ENV_SYS_INFO"


ON AIX:


OS_NAME          OS_VERSION      OS_RELEASE         HOSTNAME      TOTAL_CPUS  CONFIGURED_CPUS     TOTAL_MEMORY
---------------  -------------------- -------------------- --------------------             -----------              --------------- -              -----------
AIX                                      5                        3                   apple                      12                             24                    32768


ON WINDONS:


OS_NAME          OS_VERSION      OS_RELEASE         HOSTNAME      TOTAL_CPUS  CONFIGURED_CPUS     TOTAL_MEMORY
---------------  -------------------- -------------------- --------------------             -----------              ---------------              -----------
WIN32_NT                        5.1     Service Pack 2     IBM-11D7C831F3E                2                              2                   2007


Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls