The data types for GET DIAGNOSTICS items that return connection
information.
Item
|
Description
|
Data type
|
DB2_AUTHENTICATION_TYPE
|
Contains the
authentication type (S, C, D, E, or blank).
|
CHAR(1)
|
DB2_AUTHORIZATION_ID
|
Contains the authorization ID used
by the connected server.
|
VARCHAR(128)
|
DB2_CONNECTION_STATE
|
INTEGER
|
|
DB2_CONNECTION_STATUS
|
This item indicates whether
updates can be committed for the current unit of work (1 for yes or 2 for
no).
|
INTEGER
|
DB2_ENCRYPTION_TYPE
|
Contains A
or D, indicating the level of encryption for the connection: (A = only the
authentication tokens (authid and password) are encrypted; D = all the data
for the connection is encrypted).
|
CHAR(1)
|
DB2_SERVER_CLASS_NAME
|
After a CONNECT or SET CONNECTION
statement, contains the DB2 server class name.
|
VARCHAR(128)
|
DB2_PRODUCT_ID
|
Contains the
DB2 product signature.
|
VARCHAR(8)
|
No comments:
Post a Comment