Information on system entries.
Current authorization identifier without the CREATE USER privilege:All system entries to the user ́s own authorization identifier in which the authorization identifier has been entered explicitly.
Current authorization identifier with CREATE USER privilege but without GRANT authorization:
All system accesses to authorization identifiers which do not have the CREATE USER privilege or GRANT authorization.Current authorization identifier with CREATE USER privilege and with GRANT authorization:
All system entries
Column name |
Data type |
Contents |
USER_CATALOG |
CHAR (18) |
Database name |
HOST_NAME |
CHAR (8) |
Host name or * |
APPLICATION_NAME |
CHAR (8) |
Application name or * for UTM system |
SYSTEM_USER_NAME |
CHAR (8) |
BS2000 or UTM user ID |
USER_NAME |
CHAR (18) |
Authorization identifier |
Table 96: SYSTEM_ENTRIES view of the INFORMATION_SCHEMA