Appendix A
License Verification – Input CSV file layout
Column Name | Size | Description | Comments |
---|---|---|---|
License Key | License Key | Auto Generated | |
Site | VARCHAR(50) |
Example: Central SiteA – Client1 |
No validation |
Machine | VARCHAR(10) |
Aka CPU Model NODE HW_TYPE, HW_MODEL TLPAR FMACHINE Sample: 002964-N30 |
Code checks for presence of Machine |
Serial | VARCHAR(12) |
Aka CPU Serial Number NODE HW_SERIAL TLPAR FSERIALNO Sample: 0000000F6A27 |
Code checks for presence of Serial |
LPAR | VARCHAR(20) | TLPARFLPARNAME | Code checks for presence of LPAR |
License Type | VARCHAR(10) |
MLC: AWLC=Advanced Workload License Charges AEWLC=Advanced Entry Workload License Charges WLC=Workload License Charges EWLC=Entry Workload License Charges MWLC=Midrange Workload License Charges zNALC=z Systems New Application License Charges MzNALC=Multiplex zNALC zELC=zSeries Entry License Charges CMLC=Country Multiplex License Charges PSLC=Parallel Sysplex License Charges ULC=Usage License Charges
OTC: IPLA=International Program License Agreement |
Code checks for valid type. Blank for ISV products. |
License Scope | VARCHAR(10) | E=Enterprise, S=Site, M=Machine, L=LPAR | Code checks for valid scope |
License Date | Date | YYYY-MM-DD format only | Code checks for valid date |
License Renewal Date | Date | YYYY-MM-DD format only | Code checks for valid date |
ELA Start Date | Date | YYYY-MM-DD format only | Code checks for valid date |
ELA End Date | Date | YYYY-MM-DD format only | Code checks for valid date |
Vendor | VARCHAR(50) |
PRODUCTVENDOR_NAME TVENDORFVENDORNAME |
Code checks for presence of Vendor |
Product | VARCHAR(50) | PRODUCTPRODUCT_NAME | Code checks for presence of Product |
Feature | VARCHAR(50) | PRODUCTFEATURE_NAME | Code checks for presence of Feature |
Version | VARCHAR(12) | PRODUCTVERSION | |
PID | VARCHAR(16) | PRODUCTPID | Code checks for presence of PID |
S&S PID | VARCHAR(16) | PRODUCTSSPID | Code checks for presence of S&SPID |
EID PID | VARCHAR(16) | PRODUCTEIDPID |
Code checks for presence of EID PID |
Capacity Unit | VARCHAR(10) | MSU, VU, MIPS, SUB | Code checks for valid unit |
Quantity | Integer | Null or integer | No validation |
VEND_CONT_NAME | VARCHAR(50) | Vendor Contact Name | |
VEND_CONT_TITLE | VARCHAR(50) | Vendor Contact Title | |
VEND_CONT_PHONE | VARCHAR(25) | Vendor Contact Phone | |
VEND_CONT_EMAIL | VARCHAR(50) | Vendor Contact Email | |
OWNER_CONT_NAME | VARCHAR(50) | Owner Name | |
OWNER_CONT_TITLE | VARCHAR(50) | Owner Title | |
OWNER_CONT_DEPT | VARCHAR(50) | Owner Department | |
OWNER_CONT_PHONE | VARCHAR(25) | Owner Phone | |
OWNER_CONT_EMAIL | VARCHAR(50) | Owner Email | |
License Serial Number | VARCHAR(20) | License Number | No validation |