Instance Info
Instance Info
| Name: | |
| Partitionable: | |
| Partions: | |
| Architecture: | |
| Release number: | |
| Service level: | |
| Build level: | |
| Program temporary fix: | |
| Fixpack number: |
| OS: | |
| OS Version: | |
| OS Release: | |
| Host name: | |
| Total CPUs: | |
| Configured CPUs: | |
| Total memory: |
| Name | Value in memory | Value on disk |
| AGENT_STACK_SZ | 16 | 16 |
| AGENTPRI | -1 | -1 |
| ASLHEAPSZ | 15 | 15 |
| AUDIT_BUF_SZ | 0 | 0 |
| AUTHENTICATION | 0 | 0 |
| BACKBUFSZ | 1024 | 1024 |
| CATALOG_NOAUTH | 0 | 0 |
| CLNT_KRB_PLUGIN | IBMkrb5 | IBMkrb5 |
| CLNT_PW_PLUGIN | ||
| COMM_BANDWIDTH | 0 | 0 |
| CONN_ELAPSE | 0 | 0 |
| CPUSPEED | 3,936202E-07 | 3,936202E-07 |
| DATALINKS | 0 | 0 |
| DBMCONFIG_TYPE | 0 | 1 |
| DFT_ACCOUNT_STR | ||
| DFT_CLIENT_ADPT | 0 | 0 |
| DFT_CLIENT_COMM | ||
| DFT_MON_BUFPOOL | 0 | 0 |
| DFT_MON_LOCK | 0 | 0 |
| DFT_MON_SORT | 0 | 0 |
| DFT_MON_STMT | 0 | 0 |
| DFT_MON_TABLE | 0 | 0 |
| DFT_MON_UOW | 0 | 0 |
| DFT_MONSWITCHES | 64 | 64 |
| DFTDBPATH | C: | C: |
| DIAGLEVEL | 3 | 3 |
| DIAGPATH | ||
| DIR_CACHE | 1 | 1 |
| DIR_OBJ_NAME | ||
| DIR_PATH_NAME | /.:/subsys/database/ | /.:/subsys/database/ |
| DIR_TYPEC | 0 | 0 |
| DISCOVER_COMM | ||
| DISCOVER_INST | 1 | 1 |
| DISCOVERD | 2 | 2 |
| DOS_RQRIOBLK | 4096 | 4096 |
| DRDA_HEAP_SZ | 128 | 128 |
| FCM_NUM_ANCHORS | -1 | -1 |
| FCM_NUM_BUFFERS | 1024 | 0 |
| FCM_NUM_CONNECT | -1 | -1 |
| FCM_NUM_RQB | 512 | 0 |
| FEDERATED | 0 | 0 |
| FILESERVER | ||
| GROUP_PLUGIN | ||
| INDEXRECE | 2 | 2 |
| INITDARI_JVM | 0 | 0 |
| INTRA_PARALLEL | 0 | 0 |
| IPX_SOCKET | 879E | 879E |
| JAVA_HEAP_SZ | 512 | 512 |
| JDK11_PATH | C:\Program Files\IBM\SQLLIB\java\jdk | C:\Program Files\IBM\SQLLIB\java\jdk |
| KEEPDARI | 1 | 1 |
| LOCAL_GSSPLUGIN | ||
| MAX_CONNRETRIES | 0 | 0 |
| MAX_COORDAGENTS | -1 | 200 |
| MAX_LOGICAGENTS | 1 | 59756 |
| MAX_QUERYDEGREE | -1 | -1 |
| MAX_TIME_DIFF | 0 | 0 |
| MAXAGENTS | 200 | 200 |
| MAXCAGENTS | -1 | 200 |
| MAXDARI | -1 | -1 |
| MAXTOTFILOP | 16000 | 16000 |
| MIN_PRIV_MEM | 32 | 32 |
| MON_HEAP_SZ | 66 | 66 |
| NNAME | ||
| NODETYPE | 1 | 1 |
| NOTIFYLEVEL | 3 | 3 |
| NUM_INITAGENTS | 0 | 0 |
| NUM_INITDARIS | 0 | 0 |
| NUM_POOLAGENTS | -1 | 100 |
| NUMDB | 8 | 8 |
| OBJECTNAME | ||
| PLUGIN_MODE | 1 | 1 |
| PRIV_MEM_THRESH | 20000 | 20000 |
| QUERY_HEAP_SZ | 1000 | 1000 |
| RELEASE | 2560 | 2560 |
| RESTBUFSZ | 1024 | 1024 |
| RESYNC_INTERVAL | 180 | 180 |
| ROUTE_OBJ_NAME | ||
| RQRIOBLK | 32767 | 32767 |
| SHEAPTHRES | 10000 | 10000 |
| SPM_LOG_FILE_SZ | 256 | 256 |
| SPM_MAX_RESYNC | 20 | 20 |
| SPM_NAME | TEZORRO | TEZORRO |
| SPM_PATH_NAME | ||
| SRVCON_AUTH | 255 | 255 |
| SRVCON_GSSPLUGIN_LIST | ||
| SRVCON_PW_PLUGIN | ||
| SS_LOGON | 1 | 1 |
| START_STOP_TIME | 0 | 0 |
| SVCENAME | db2c_DB2 | db2c_DB2 |
| SYSADM_GROUP | ||
| SYSCTRL_GROUP | ||
| SYSMAINT_GROUP | ||
| TM_DATABASE | 1ST_CONN | 1ST_CONN |
| TP_MON_NAME | ||
| TPNAME | ||
| TRUST_ALLCLNTSF | 1 | 1 |
| TRUST_CLNTAUTH | 0 | 0 |
| UDF_MEM_SZ | 256 | 256 |