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 |