Appendix B
License Verification - Repository Database Tables
| Column Name | Column Type | Column Length | Description |
|---|---|---|---|
| License Key | Integer | License Key | |
| Site | CHAR | 50 | Optional site name |
| Machine | CHAR | 10 | Combination of hardware type and capacity model
Sample: 002964-508 |
| Serial | CHAR | 12 | CPU Serial
NUmber Sample: F6A27 |
| LPAR | CHAR | 20 | LPAR name |
| License Type | CHAR | 10 | MLC or OTC |
| License Scope | CHAR | 10 | Enterprise, Site, Machine, LPAR |
| License Date | Date | YYYY-MM-DD format only | |
| License Renewal Date | Date | YYYY-MM-DD format only | |
| ELA Start Date | Date | YYYY-MM-DD format only | |
| ELA End Date | Date | YYYY-MM-DD format only | |
| Vendor | CHAR | 50 | Vendor name |
| Product | CHAR | 50 | Product name |
| Feature | CHAR | 50 | Freatre name |
| Version | Integer | Version | |
| PID | CHAR | 16 | PID |
| SSPID | CHAR | 16 | S&S PID |
| EIDPID | CHAR | 16 | Entitilement ID PID |
| Capacity_Unit | CHAR | 10 | MSU, VU, MIPS, SUB. Currently only MSU is supported |
| Quantity | Integer | Null or integer | |
| VEND_CONT_NAME | CHAR | 50 | Vendor Contact Name |
| VEND_CONT_TITLE | CHAR | 50 | Vendor Contact Title |
| VEND_CONT_PHONE | CHAR | 25 | Vendor Contact Phone |
| VEND_CONT_EMAIL | CHAR | 50 | Vendor Contact Email |
| OWNER_CONT_NAME | CHAR | 50 | Owner Name |
| OWNER_CONT_TITLE | CHAR | 50 | Owner Title |
| OWNER_CONT_DEPT | CHAR | 50 | Owner Department |
| OWNER_CONT_PHONE | CHAR | 23 | Owner Phone |
| OWNER_CONT_EMAIL | CHAR | 50 | Owner Email |
| Column Name | Column Type | Column Length | Description |
|---|---|---|---|
| Key | Integer | License Key | |
| VENDOR_NAME | CHAR | 50 | Vendor name |
| PRODUCT_NAME | CHAR | 50 | Product name |
| FEATURE_NAME | CHAR | 50 | Feature name |
| VERSION | Integer | Version | |
| PID | CHAR | 16 | PID |
| VUE | CHAR | 16 | Value Unit PID |
| EID | CHAR | 8 | Entitlement ID |
| SYSPLEX | CHAR | 8 | Sysplex name |
| SYSTEM | CHAR | 4 | LPAR name |
| MSULPAR | INTEGER | MSU rating for LPAR | |
| LICENSE_SCOPE | CHAR | 20 | Enterprise, Site, Machine, LPAR |
| MACHINE | CHAR | 22 | Hardware type, capacity and serial number |
| LICENSE_DATE | DATE | Date of initial license | |
| RENEWAL_DATE | DATE | Renewal date | |
| LAST_USED | DATE | Date product was last used | |
| SYSTEMS_USED | CHAR | 2 | How many LPARS used |
| MACHINES_USED | CHAR | 2 | How many machines used |
| LAST_UPDATE | DATE | Last date it was updated | |
| ENTITLED | CHAR | 1 | Licensed Y or N |
| VERIFY_ERROR | VARCHAR | 255 | Verification errors |