Saturday, 24 August 2013

DB2 Data Types for GET DIAGNOSTICS Items Returning Connection Information

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
This item indicates whether the connection is unconnected (-1), local (0), or remote (1).
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)


Created with Artisteer

No comments:

Post a comment