ENV_INST_INFO administrative view - Retrieve information about the current instance

The ENV_INST_INFO administrative view returns information about the current instance.

The schema is SYSIBMADM.

Authorization

One of the following authorizations is required:
  • SELECT privilege on the ENV_INST_INFO administrative view
  • CONTROL privilege on the ENV_INST_INFO administrative view
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority
  • ACCESSCTRL authority
  • SECADM authority

Default PUBLIC privilege

In a non-restrictive database, SELECT privilege is granted to PUBLIC when the view is automatically created.

Example

Request information about the current instance. 
SELECT * FROM SYSIBMADM.ENV_INST_INFO
The following is an example of output for this query. 
INST_NAME          IS_INST_PARTITIONABLE NUM_DBPARTITIONS INST_PTR_SIZE ...
-----------...---- --------------------- ---------------- ------------- ...
DB2                                    0                1            32 ...

  1 record(s) selected.
Output for this query (continued). 
... RELEASE_NUM       SERVICE_LEVEL        BLD_LEVEL        PTF        FIXPACK_NUM
... -----------...--- --------------...--- ----------...--- ----...--- -----------
... 01010107          Db2 v11.1.1.1       n051106                               0

Information returned

Table 1. Information returned by the ENV_INST_INFO administrative view
Column name Data type Description
INST_NAME VARCHAR(128) Name of the current instance.
IS_INST_PARTITIONABLE SMALLINT Indicates whether or not the current instance is a partitionable database server instance. Possible return values are 0 if it is not a partitionable database server instance, and 1 if it is a partitionable database server instance.
NUM_DBPARTITIONS INTEGER Number of database partitions. If it is not a partitioned database environment, returns a value of 1.
INST_PTR_SIZE INTEGER Bit size of the current instance (32 or 64).
RELEASE_NUM VARCHAR(128) Internal release number, as returned by the db2level command; for example, 03030106.
SERVICE_LEVEL VARCHAR(128) Service level, as returned by the db2level command; for example, Db2® v11.1.1
BLD_LEVEL VARCHAR(128) Build level, as returned by the db2level command; for example, n041021.
PTF VARCHAR(128) Program temporary fix (PTF) identifier, as returned by the db2level command; for example, U498350.
FIXPACK_NUM INTEGER Fix Pack number, as returned by the db2level command; for example, 9.
NUM_MEMBERS INTEGER The number of members on this instance.