z/OS Cryptographic Services PKI Services Guide and Reference
Previous topic | Next topic | Contents | Contact z/OS | Library | PDF


Columns in the ICL and object store DB2 tables

z/OS Cryptographic Services PKI Services Guide and Reference
SA23-2286-00

Not Programming Interface information
Not Programming Interface information

The information in Table 1 and Table 2 is intended for your use when creating DB2® queries and reports. It is not a programming interface.

Table 1. Columns in the object store DB2 tables
Column name Format Contents
Header:    
RECORD_KEY BINARY(4)  
RECORD_STATE BINARY(4)  
REQDATA_LEN INTEGER  
REQUESTOR_NAME VARCHAR(32) Requestor name
TRANS_ID CHAR(24) Transaction ID
COMMENT VARCHAR(64) Comment
ISSUED_TIME TIMESTAMP Issued time
LAST_CHANGE_TIME TIMESTAMP Last changed time
TEMPLATE_NICKNAME VARCHAR(8) Template nickname
SERIAL_NUM BINARY(4) Serial number
Body:    
REQDATA VARBINARY(32512) Request object in ASN1 format
Table 2. Columns in the ICL DB2 tables
Column name Format Contents
Header:    
SERIAL_NUM BINARY(4) Serial number
CERT_STATE BINARY(4)  
CERT_LEN INTEGER  
REQUESTOR_NAME VARCHAR(32) Requestor name
REVOKE_DATE TIMESTAMP Revocation date
INVALID_DATE TIMESTAMP Expiration date
REVOKE_REASON INTEGER Revoke reason
COMMENT VARCHAR(64) Comment
ISSUED_TIME TIMESTAMP Issued time
LAST_CHANGE_TIME TIMESTAMP Last changed time
TEMPLATE_NICKNAME VARCHAR(8) Template nickname
OBFUS_PW VARCHAR(32) Obfuscated passphrase
PROCESS_FLAGS BINARY(4) Flags
KEYID BINARY (20) SHA1 hash of public key
CRLDP_NUM INTEGER CRL DP number
EXPIRE_EPOCH_DAYS INTEGER Expiration date, expressed as "days since the epoch " (January 1, 1970)
EXPIRE_DATE TIMESTAMP Expiration date, expressed in DB2 TIMESTAMP format
KU_DIGTSIG BINARY(1) digitalSignature keyusage
KU_NONRPU BINARY(1) nonRepudiation keyusage
KU_KEYENC BINARY(1) keyEncipherment keyusage
KU_DATAENC BINARY(1) dataEncipherment keyusage
KU_KEYAGR BINARY(1) keyAgreement keyusage
KU_CRTSGN BINARY(1) keyCertSign keyusage
KU_CRLSGN BINARY(1) CRLSign keyusage
KU_ENCONLY BINARY(1) encipherOnly keyusage
KU_DECONLY BINARY(1) decipherOnly keyusage
EKU_SEVAUTH BINARY(1) serverAuth extended keyusage
EKU_CLIAUTH BINARY(1) clientAuth extended keyusage
EKU_CODESGN BINARY(1) codeSigning extended keyusage
EKU_EMLPROT BINARY(1) emailProtection extended keyusage
EKU_TMESTMP BINARY(1) timeStamping extended keyusage
EKU_OCSPSGN BINARY(1) OCSPSigning extended keyusage
EKU_MSSCLNON BINARY(1) Microsoft smart card logon extended keyusage
PREV_SERIAL_NUM BINARY(4) Previous serial number if the certificate has been renewed
SUBJ_DN VARCHAR(1024) Subject distinguished name
Body:    
X509CERT VARBINARY(10240) Certificate in ASN1 format
Parent topic: Creating the object store and ICL using DB2 tables
End of Not Programming Interface information
End of Not Programming Interface information

Go to the previous page Go to the next page

Notices | Terms of use | Support | Contact z/OS | zFavorites



Copyright IBM Corporation 1990, 2014