NOT Programming Interface Information
NOT Programming Interface Information Columns in the ICL and object store DB2 tables
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.
| 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 |
| 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  |
VARBINARY(33) |
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 |
End NOT Programming Interface Information