Repository table layouts
This topic describes the tables in the Repository including column names, types, and length.
Column name | Column type | Column length | Description |
---|---|---|---|
NODE_KEY | Char | 32 | Global Unique ID (GUID) for this entry |
NODE_TYPE | Char | 4 | Entry Type: HW or LPAR |
HW_TYPE | Char | 4 | System z® Hardware Type, for example 2096 |
HW_MODEL | Char | 3 | System z® Hardware Model, for example P03 |
HW_PLANT | Char | 2 | System z® Hardware Plant, for example 02 |
HW_SERIAL | Char | 12 | System z® Hardware Serial, for example. 000000013EED |
HW_NAME | Char | 10 | Configured Hardware Name |
HW_VENDOR | Char | 10 | System z® Hardware Vendor, for example HCL |
LPAR_NUMBER | Integer | Logical Partition Number, for example 1 | |
LPAR_NAME | Char | 10 | Logical Partition Name, for example LPARSYS1 |
VMGUEST_NAME | Char | 10 | z/VM® Guest Name (if z/OS® is running under z/VM®) |
HW_NODE_KEY | Char | 32 | NODE_KEY for related hardware parent |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
HW_ID | Smallint | NODE_KEY identifier |
Column name | Column type | Column length | Description |
---|---|---|---|
NODE_KEY | Char | 32 | NODE GUID |
PERIOD | Date | Month for this entry | |
START_TIME | Timestamp | First date that this entry is applicable for this Month | |
END_TIME | Timestamp | Last date that this entry is applicable for this Month | |
METRIC_TYPE | Char | 10 | Metric Type: MSU, SUBCAPMSTY |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
QUANTITY | Integer | Metric Value | |
MODEL_CAPACITY | Char | 4 | CPU model for capacity planning purpose |
Column name | Column type | Column length | Description |
---|---|---|---|
SW_KEY | Char | 32 | Global Unique ID (GUID) for this entry. For SW_TYPE=VERSION this will be the same value as VERSION_GUID For SW_TYPE=FEATURE this will be the same value as FEATURE_GUID |
SW_TYPE | Char | 8 | Entry type - VERSION or FEATURE |
VENDOR_NAME | Char | 50 | Vendor name |
PRODUCT_NAME | Char | 80 | Product name, which is a normalized form of Version Name in order to group different versions of products under the same product name |
VERSION | Integer | Version | |
VERSION_NAME | Char | 80 | Product Version Title |
FEATURE_NAME | Char | 80 | Product Feature Title |
PID | Char | 16 | Product Identifier |
EID | Char | 8 | Entitlement Identifier for the Product Feature |
SSPID | Char | 8 | Subscription & Support Product Identifier |
SSEID | Char | 8 | Subscription & Support Entitlement Identifier for the Product Feature |
PRICETYPE | Char | 10 | Price Type (not used in 7.2) |
SUBCAPACITY | Char | 20 | IPLA Subcapacity type: Execution-based, Reference-based, z/OS-based, Not eligible, NULL |
ICA | Char | 1 | Y or N: HCL Company Agreement license |
IPLA | Char | 1 | Y or N: International Program License Agreement |
VUE | Char | 8 | IPLA Value Unit Exhibit |
VENDOR_GUID | Char | 32 | Globally Unique ID for VENDOR_NAME |
PRODUCT_GUID | Char | 32 | Globally Unique ID for VENDOR_NAME + PRODUCT_NAME |
VERSION_GUID | Char | 32 | Globally Unique ID for VENDOR_NAME + VERSION_NAME + VERSION |
FEATURE_GUID | Char | 32 | Globally Unique ID for VENDOR_NAME + VERSION_NAME + VERSION + FEATURE_NAME |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
ALT_PRODUCT_NAME | Char | 80 | Alternate product name |
FOBSERVEDELETED | Timestamp | Date and time that the library was deleted from Inquisitor data. | |
BUNDLE_NAME | Char | 50 | Product suite |
FTYPE | Char | 1 | P=Product, S=Suite, X=Exclude, Null |
FSUITE_ID | Smallint | ID of the Suite |
Column name | Column type | Column length | Description |
---|---|---|---|
SW_KEY | Char | 32 | Product GUID |
SYSTEM_KEY | Char | 32 | System GUID |
INSTALL_DATE | Date | Date the product was first observed to be installed on this System | |
UNINSTALL_DATE | Date | Date the product was first observed to be missing from this System | |
LAST_USED_DATE | Date | Date the product was last used on this System | |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated |
Column name | Column type | Column length | Description |
---|---|---|---|
SW_KEY | Char | 32 | Product GUID |
NODE_KEY | Date | Node GUID | |
PERIOD | Timestamp | Month for this entry | |
START_TIME | Timestamp | First date that this entry is applicable for this Month | |
END_TIME | Timestamp | Last date that this entry is applicable for this Month | |
METRIC_TYPE | Integer | Metric Type: INSTALLED, JOBNAMES, MODULES, USERS, SUBCAPMSU | |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
QUANTITY | Float | Metric Value |
Column name | Column type | Column length | Description |
---|---|---|---|
PERIOD | Date | Month for this entry | |
SYSTEM_KEY | Char | 32 | System GUID |
SW_KEY | Char | 32 | Product GUID |
FLPARID | Integer | TLPAR.FLPARID for convenient linking with PRODUCT_USE_DETAIL | |
HW_NODE_KEY | Char | 32 | NODE GUID for Hardware NODE that this System was last running on in this month |
USER_CNT | Integer | MAX distinct Userid count | |
JOBNAME_CNT | Integer | MAX distinct Job Name count | |
ACCOUNT_CNT | Integer | MAX distinct Account Code count | |
SCRT_MSU | Sub-capacity Reporting Tool MSU (millions of service units per hour) | ||
EVENT_CNT | Double | SUM of Module usage | |
START_DATE | Date | Date within this Period that usage was for first recorded | |
END_DATE | Date | Date within this Period that usage was for last recorded | |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
PRODUCTUSE | Double | Counter field for Product usage |
Column name | Column type | Column length | Description |
---|---|---|---|
PERIOD | Date | Month for this entry | |
FLPARID | Integer | System TLPAR.FLPARID for convenient linking with PRODUCT_USE | |
VERSION_GUID | Char | 32 | Product Version GUID |
FEATURE_GUID | Char | 32 | Product Feature GUID |
USERNAME | Char | 8 | User ID |
JOBNAME | Char | 8 | Job Name |
ACCOUNTCODE | Char | 20 | First 20 chars of the Job Account Code |
EVENT_CNT | Double | SUM of Module usage | |
START_DATE | Date | Date within this Period that usage was for first recorded | |
END_DATE | Date | Date within this Period that usage was for last recorded | |
PRODUCTUSE | Double | Counter field for Product usage |
Column name | Column type | Column length | Description |
---|---|---|---|
SYSTEM_KEY | Char | 32 | Global Unique ID (GUID) for this entry |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated | |
SID | Char | 4 | Product system ID. By default this is the SMFID. In cases where the same SMFID is used on different systems, the SID must be defined to a unique value for the customer enterprise in the Usage Monitor |
SMFID | Char | 4 | z/OS® SMF ID |
SYSPLEX | Char | 8 | z/OS® Sysplex name |
IPADDR | Varchar | 45 | Host TCP/IP address |
HOSTNAME | Varchar | 256 | Host TCP/IP name |
FOBSERVEDELETED | Timestamp | Date and time that system was deleted from Inquisitor data |
Column name | Column type | Column length | Description |
---|---|---|---|
SYSTEM_KEY | Char | 32 | System GUID |
NODE_KEY | Char | 32 | Node GUID |
PERIOD | Date | Month this entry is for | |
START_TIME | Timestamp | Time it was first observed that this system is using this Node in this month period | |
END_TIME | Timestamp | Time it was last observed that this system is using this Node in this month period | |
LAST_UPDATE_TIME | Timestamp | Time stamp entry was last updated |
Column name | Column type | Column length | Description |
---|---|---|---|
FACCOUNTID | Integer | Account ID | |
FACCOUNTCODE | Char | 20 | Job Account Code, truncated to 20 characters |
Column name | Column type | Column length | Description |
---|---|---|---|
PRODUCT_NAME | Char | 80 | Product name, which is a normalized form of Version Name in order to group different versions of products under the same product name |
ALT_PRODUCT_NAME | Char | 80 | Alternate product name |
BUNDLE_NAME | Char | 50 | Product suite |
Column name | Column type | Column length | Description |
---|---|---|---|
FTYPE | Char | 1 | Annotation type:
|
PRODUCT_GUID | Char | 32 | Globally Unique ID for VENDOR_NAME + PRODUCT_NAME |
FANNOTATION | Varchar | 255 | Text that is annotation |
Column name | Column type | Column length | Description |
---|---|---|---|
SID | Char | 4 | Product system ID. By default this is the SMFID |
CP_CHPID | Char | 4 | Channel path identifier |
CP_TYPE | Char | 5 | Channel path type acronym |
PERIOD | Date | Month for this entry | |
CP_DESC | Char | 32 | Channel path description |
Column name | Column type | Column length | Description |
---|---|---|---|
SID | Char | 4 | Product system ID. By default this is the SMFID |
PERIOD | Date | Month for this entry | |
CU_DEV1 | Char | 4 | First device number |
CU_DEV2 | Char | 4 | Last device number |
CU_DEVCT | Integer | Device count for CU record | |
CU_UNTNM | Char | 8 | Generic device unit name |
CU_CHN1 | Char | 4 | Channel path 1 |
CU_CHN2 | Char | 4 | Channel path 2 |
CU_CHN3 | Char | 4 | Channel path 3 |
CU_CHN4 | Char | 4 | Channel path 4 |
CU_CHN5 | Char | 4 | Channel path 5 |
CU_CHN6 | Char | 4 | Channel path 6 |
CU_CHN7 | Char | 4 | Channel path 7 |
CU_CHN8 | Char | 4 | Channel path 8 |
CU_TYPE | Char | 6 | Control unit type |
CU_MODEL | Char | 3 | Control unit model |
CU_MFR | Char | 3 | Control unit manufacturer |
CU_PLANT | Char | 2 | Control unit plant of manufacture |
CU_SEQNUM | Char | 12 | Control unit sequence number |
Column name | Column type | Column length | Description |
---|---|---|---|
FMODID |
Integer |
Module ID |
|
FCSECTNAME |
Char |
40 |
Name of CSECT |
FCSECTSIZE | Char | 8 | CSECT size |
FCOMPDATE | Char | 8 | Compile date of CSECT |
FCOMPTIME | Char | 6 | Compile time of CSECT |
FCOMPNAME | Char | 50 | Compiler name |
FCOMPVERSION | Char | 8 | Compiler version |
FLANGENV | Char | 2 | LE language type |
FARCHLEVEL | Char | 3 | Architecture level |
FOPTIMIZE | Char | 1 | Optimize level |
FDSTATEMENTS | Char | 6 | Number of statements the DATA DIVISION of a COBOL program |
FPSTATEMENTS | Char | 6 | Number of statements the PROCEDURE DIVISION of a COBOL program |
Column name | Column type | Column length | Description |
---|---|---|---|
FPOVID |
Integer |
Product ID |
|
FEOSDATE |
Timestamp |
End of Service Date |
Column name | Column type | Column length | Description |
---|---|---|---|
FJOBNAME | Char | 8 | Job Name |
FJOBID | Integer | Job ID | |
FJOBTYPE | Char | 6 | Job Type |
Column name | Column type | Column length | Description |
---|---|---|---|
FLIBID | Integer | Library ID | |
FLIBNAME | Char | 128 | Library name |
FINVID | Integer | Inventory ID | |
FCREATIONDATE | Timestamp | Library creation date on Mainframe | |
FLIBDEVNUM | Char | 4 | DASD device number |
FREFERENCEDATE | Timestamp | Date library last referenced | |
FLIBVOLSER | Char | 8 | Volser library resides on |
FTRACKSALLOC | Char | 10 | Number of allocated tracks |
FTRACKSUSED | Char | 10 | Number of used tracks |
FORIGIN | Char | 1 | Blank - PDS, E - PDSE, V - VTOC, Q - PDS (subtask QSAM scan) |
FCATALOG | Char | 1 | S - SMS managed, C - Cataloged, U - uncataloged, W - cataloged on wrong volume |
FLINKLIST | Char | 1 | Is this a link listed library? |
FLINKPACK | Char | 1 | Is this library in the Linkpack |
FAPFAUTH | Char | 1 | Is this library APF authorized |
FLASTUSAGE | Date | 1st month of the most recent usage applied to any module in this library | |
FUSEFLAG | Smallint | Flag for library usage | |
FMODCNT | Integer | Number of modules in library | |
FOBSERVEFIRST | Timestamp | Date and time that library was first observed | |
FOBSERVELAST | Timestamp | Date and time that library was last observed | |
FOBSERVEDELETED | Timestamp | Date and time that library was deleted from Inquisitor data. | |
FCHECKSUM | Char | 40 | A checksum of module names and sizes in a given library used to determine whether a library has changed. |
FSTORAGEGROUP | Char | 8 | The storage group the library belongs to |
FLIBRARYCLASS | Char | 30 | Name of the Library Class |
Column name | Column type | Column length | Description |
---|---|---|---|
FLIBID | Integer | Library ID | |
FLPARID | Integer | LPAR ID | |
FOBSERVEFIRST | Timestamp | Date and time that library was first observed | |
FOBSERVELAST | Timestamp | Date and time that library was last observed | |
FOBSERVEDELETED | Timestamp | Date and time that library was deleted from Inquisitor data | |
FAPFAUTH | Char | 1 | APFAUTH flag Y or N |
FAPFLASTUPDATE | Timestamp | Date and time field was last updated |
Column name | Column type | Column length | Description |
---|---|---|---|
FIQDATE | Timestamp | Inquisitor date | |
FIMPORTDATE | Timestamp | Inquisitor Import date | |
FSID | Char | 4 | Product system ID. By default this is the SMFID |
FSYSPLEXID | Char | 8 | z/OS Sysplex name |
FFULLREMATCH | Char | 1 | Y or N. Described in job HZASIQIM |
FPRODUCTONLY | Char | 1 | Y or N. Described in job HZASIQIM |
FOSTYPE | Char | 4 | z/OS or USS |
FPLX | Char | 1 | PLX option (Y or N) as defined in Inquisitor scan |
FVERSIONGKB | Char | 15 | The version of the GKB that the IQ is matched with |
FSPNUM | Char | 8 | System Product number of the z/OS |
FFMID | Char | 8 | FMID of the z/OS |
FOSNUM | Char | 8 | Product ID of the z/OS |
FOSVERSION | Char | 8 | Version of the z/OS |
HW_TYPE | Char | 4 | System z hardware type |
HW_MODEL | Char | 4 | System z hardware model |
HW_SERIAL | Char | 12 | System z hardware serial |
FFILTER | Varchar | 256 | List of filters in the Inquisitor file |
Column name | Column type | Column length | Description |
---|---|---|---|
FUMONDATE | Timestamp | Usage Monitor date | |
FIMPORTDATE | Timestamp | Usage Import date | |
FSID | Char | 4 | Product system ID. By default this is the SMFID |
FSYSPLEXID | Char | 8 | z/OS Sysplex name |
HW_TYPE | Char | 4 | System z Hardware Type |
HW_MODEL | Char | 4 | System z Hardware Model |
HW_SERIAL | Char | 12 | System z Hardware Serial |
FFILTER | Varchar | 256 | List of filters in the UMON file |
Column name | Column type | Column length | Description |
---|---|---|---|
FLPARID | Integer | LPAR ID | |
FLPARNAME | Char | 20 | Name of the LPAR |
FUSEFLAG | Smallint | Indicates if usage has been attributed to this LPAR | |
FEDITFLAG | Smallint | Has this LPAR record been updated manually | |
FMANF | Char | 10 | Machine manufacturer |
FMACHINE | Char | 12 | CPU Model |
FSERIALNO | Char | 12 | CPU Serial number |
FSYSPLEXID | Char | 8 | Sysplex name if in a Sysplex |
FMIPS | Integer | Number of MIPS for LPAR | |
FHW_NAME | Char | 10 | Configured hardware name |
FIPADDR | Varchar | 45 | Host TCP/IP address |
FHOSTNAME | Varchar | 256 | Host TCP/IP name |
FOBSERVEDELETED | Timestamp | Date and time that LPAR was deleted from Inquisitor data | |
FMSU | Integer | MSU value for the LPAR | |
FHWMODEL | Char | 12 | Hardware Model |
FSWCAP | Char | 12 | Software capacity model |
Column name | Column type | Column length | Description |
---|---|---|---|
HW_NODE_KEY | Char | 32 | NODE GUID for Hardware NODE that this System was last running on in this month |
LPAR_NAME | Char | 10 | Logical partition name |
PERIOD | Date | Month for this entry | |
LPAR_NUMBER | Integer | Logical partition number | |
LPC_NAME | Char | 10 | LPC name |
OSTYPE | Char | 8 | OS name |
ENGINE_CNT1 | Char | 4 | CPU available count |
ENGINE_CNT2 | Char | 4 | CPU online count |
ENGINE_CNT3 | Char | 4 | CPU dedicated count |
ENGINE_CNT4 | Char | 4 | zAAP available count |
ENGINE_CNT5 | Char | 4 | zAAP online count |
ENGINE_CNT6 | Char | 4 | zAAP dedicated count |
ENGINE_CNT7 | Char | 4 | IFL available count |
ENGINE_CNT8 | Char | 4 | IFL online count |
ENGINE_CNT9 | Char | 4 | IFL dedicated count |
ENGINE_CNT10 | Char | 4 | ICF available count |
ENGINE_CNT11 | Char | 4 | ICF online count |
ENGINE_CNT12 | Char | 4 | ICF dedicated count |
ENGINE_CNT13 | Char | 4 | zIIP available count |
ENGINE_CNT14 | Char | 4 | zIIP online count |
ENGINE_CNT15 | Char | 4 | zIIP dedicated count |
ENGINE_CNT16 | Char | 4 | Other available count |
ENGINE_CNT17 | Char | 4 | Other online count |
ENGINE_CNT18 | Char | 4 | Other dedicated count |
Column name | Column type | Column length | Description |
---|---|---|---|
FMODID | Integer | Module ID | |
FMODNAME | Char | 40 | Module name |
FLIBID | Integer | Library ID | |
FPOVLIBID | Integer | Product Library ID | |
FMODFLAG | Smallint | Module indication flag as to which product version it belongs to and whether it has been superseded. | |
FFMID | Char | 12 | FMID |
FMODSIZE | Char | 8 | Module size |
FUSEFLAG | Smallint | Flag for module usage | |
FMODTYPE | Smallint | Type of module | |
FOBSERVEFIRST | Timestamp | Date and time that module was first observed | |
FOBSERVELAST | Timestamp | Date and time that module was last observed | |
FOBSERVEDELETED | Timestamp | Date and time that module was deleted from Inquisitor data | |
LINKEDITDATE | Date | Link edit date of module | |
FCOMPNAME | Char | 50 | Name of the Compiler, for example, Enterprise COBOL |
FCOMPVERSION | Char | 50 | Version of the Complier |
FCOMPDATE | Date | Compiled date of module | |
FAMODE | Char | 3 | Specifies the addressing mode in which the program is designed to receive control. |
FRMODE | Char | 3 | Indicates where the program can reside in virtual storage. |
FREUSE | Char | 4 | The REUS option allows you to specify how a program can be reused. |
FFMIDIQ | Char | 12 | FMID found by Inquisitor for module |
FPTF | Char | 8 | Last PTF number for module |
FPUTLEVEL | Char | 8 | PUTLEVEL that module was in |
FRSU | Char | 8 | Last RSU level that module was in |
Column name | Column type | Column length | Description |
---|---|---|---|
FKEY | Char | 64 | Parameter Key |
FVALUE | Char | 254 | Parameter Value |
Column name | Column type | Column length | Description |
---|---|---|---|
FPERIOD | Date | Calendar month for usage | |
FINVID | Integer | Inventory ID | |
FSUMMARISED | Smallint | Summary status |
Column name | Column type | Column length | Description |
---|---|---|---|
FPOVINVID | Integer | Unique ID | |
FPOVID | Integer | Product ID | |
FINVID | Integer | Inventory ID | |
FPOVGID | Integer | Global Knowledge Base Version ID | |
FOBSERVEFIRST | Timestamp | First time observation was made | |
FOBSERVELAST | Timestamp | Last time observation was made | |
FOBSERVEDELETED | Timestamp | First time observation was not found in this library | |
FPRODUCTID | Integer | Product ID | |
FVENDORID | Integer | Vendor ID | |
FPRODINVID | Integer | Product and Inventory ID | |
FPATCHLIST | Varchar | 254 | List of current patches applied to z/OS® UNIX™ product. |
Column name | Column type | Column length | Description |
---|---|---|---|
FPOVLIBID | Integer | Unique ID | |
FPOVINVID | Integer | Product inventory ID | |
FLIBID | Integer | Library ID | |
FPOVLIBPID | Integer | Previous Product Version ID | |
FMATCHCODE | Char | 3 | Matching code |
FMATCHID | Integer | Link to Inquisitor Decision table | |
FPRODUCTPCT | Integer | Product percentage used during match | |
FVERSIONPCT | Integer | Version percentage used during match | |
FOBSERVEFIRST | Timestamp | First time observation was made | |
FOBSERVELAST | Timestamp | Last time observation was made | |
FOBSERVEDELETED | Timestamp | First time observation was not found in this library | |
FMODCNT | Integer | Number of load modules in library for product |
Column name | Column type | Column length | Description |
---|---|---|---|
FPRODUCTID | Integer | Product ID | |
FPRODUCTNAME | Char | 80 | Product Name (could be alias name) |
FGLOBALNAME | Char | 80 | Product Name (always Global Name if Alias is used) |
FOPTIONNAME | Char | 80 | Option Name |
FVENDORID | Integer | Vendor ID | |
FPRODSTATUS | Smallint | Billable Status | |
FCATEGORY | Char | 30 | Product Category |
FDESCRIPTION | Varchar | 254 | Product Description |
FOBSERVEDELETED | Timestamp | Date and time that the library was deleted from Inquisitor data. | |
FTYPE | Char | 1 | P=Product, M=Maybe, N=None, U=Unknown |
Column name | Column type | Column length | Description |
---|---|---|---|
SID | Char | 4 | Product system ID. By default this is the SMFID |
PID | Char | 16 | Product Identifier |
PRODUCT_OWNER | Char | 16 | Product owner or vendor |
PRODUCT_NAME | Char | 50 | Product name |
PRODUCT_FEATURE | Char | 16 | Product feature or option name |
PRODUCT_VERSION | Char | 6 | Product version |
PRODUCT_FLAGS | Char | 8 | Register state entry flags |
PERIOD | Date | Month for this entry |
Column name | Column type | Column length | Description |
---|---|---|---|
SID | Char | 4 | Product system ID. By default this is the SMFID |
PRODUCT_OWNER | Char | 16 | Product owner or vendor |
PRODUCT_NAME | Char | 50 | Product name |
PRODUCT_VERSION | Char | 8 | Product version |
PRODUCT_QUALIFIER | Char | 8 | Product qualifier |
PERIOD | Date | Month for this entry | |
PID | Char | 16 | Product Identifier |
PRODUCT_FLAGS | Char | 8 | Register usage entry flags |
SMFRECORDS | Integer | SMF record count | |
TCBTIME | Integer | Product TCB time | |
SRBTIME | Integer | Product SRB time |
Column name | Column type | Column length | Description |
---|---|---|---|
FMTDID | Float | Unique ID | |
FLPARID | Integer | LPAR ID | |
FMODID | Integer | Module ID | |
FJOBID | Integer | Job ID | |
FUSERID | Integer | User ID | |
FPOVLIBID | Integer | Product Library ID | |
FEVENTCNT | Float | Total calls to module for this month | |
FPERIOD | Date | Calendar month that usage occurred | |
FFIRSTDATE | Date | First day of usage in the month | |
FLASTDATE | Date | Last day of usage in the month | |
FPROVIDER | Char | 4 | Provider Service |
FPOVINVID | Integer | Unique ID | |
FPRODINVID | Integer | Product and Inventory ID | |
FACCOUNTID | Integer | Account ID | |
FJESID | Char | 8 | Last JES job ID updated for the month |
FTCBCNT | Float | TCB count | |
FTCBTIME | Float | TCB time | |
FHWID | Smallint | NODE_KEY identifier |
Column name | Column type | Column length | Description |
---|---|---|---|
FUSEPOVINVID | Float | Unique ID | |
FLARPID | Integer | LPAR ID | |
FPOVINVID | Integer | POVINV ID | |
FJOBCNT | Integer | Number of distinct Jobs for a product | |
FUSERCNT | Integer | Number of distinct Users for a product | |
FEVENTCNT1 | Float | Sum of calls to this product current month | |
FEVENTCNT3 | Float | Sum of calls to this product previous 3 month | |
FEVENTCNT6 | Float | Sum of calls to this product previous 4-6 month | |
FEVENTCNT9 | Float | Sum of calls to this product previous 7-9 month | |
FEVENTCNT12 | Float | Sum of calls to this product previous 10-12 month | |
FPERIOD | Date | Calendar month in which usage occurred | |
FFIRSTUSED | Date | The earliest usage date in month | |
FLASTUSED | Date | The most recent usage date in month | |
FPRODINVID | Integer | Product Inventory ID | |
FSEQNO | Smallint | Internal use only | |
FACCCNT | Integer | Number of distinct account codes | |
FTCBCNT | Float | TCB count | |
FTCBTIME | Float | TCB time | |
FHWID | Smallint | NODE_KEY identifier |
Column name | Column type | Column length | Description |
---|---|---|---|
FUSEPOVLIBID | Float | Unique ID | |
FLARPID | Integer | LPAR ID | |
FPOVLIBID | Integer | POVLIB ID | |
FJOBCNT | Integer | Number of distinct Jobs for a product | |
FUSERCNT | Integer | Number of distinct Users for a product | |
FEVENTCNT1 | Float | Sum of calls to this product current month | |
FEVENTCNT3 | Float | Sum of calls to this product previous 3 month | |
FEVENTCNT6 | Float | Sum of calls to this product previous 4-6 month | |
FEVENTCNT9 | Float | Sum of calls to this product previous 7-9 month | |
FEVENTCNT12 | Float | Sum of calls to this product previous 10-12 month | |
FPERIOD | Date | Calendar month in which usage occurred | |
FFIRSTUSED | Date | The earliest usage date in month | |
FLASTUSED | Date | The most recent usage date in month | |
FSEQNO | Smallint | Internal use only | |
FACCCNT | Integer | Number of distinct account codes | |
FTCBCNT | Float | TCB count | |
FTCBTIME | Float | TCB time | |
FHWID | Smallint | NODE_KEY identifier |
Column name | Column type | Column length | Description |
---|---|---|---|
FUSEPRSID | Integer | Unique ID for TUSEPRS table | |
FREGVEND | Char | 16 | Product Registration Vendor name |
FREGPROD | Char | 16 | Product Registration Product name |
FREGFEAT | Char | 16 | Product Registration Feature name |
FREGVRN | Char | 6 | Product Registration Version |
FREGPID | Char | 8 | Product Registration Product identifier |
FREGFLAGS | Char | 8 | Product Registration flags |
FLPARID | Integer | LPAR ID | |
FPERIOD | Date | Calendar month when usage occurred | |
FFIRSTDATE | Date | The earliest usage date in month | |
FLASTDATE | Date | The most recent usage date in month |
Column name | Column type | Column length | Description |
---|---|---|---|
FUSERID | Integer | User ID | |
FUSERNAME | Char | 10 | User Name |
FORGNAME | Char | 8 | Owning Organization |
FREALNAME | Char | 20 | Real person's name |
Column name | Column type | Column length | Description |
---|---|---|---|
FVENDORID | Integer | Vendor ID | |
FVENDORNAME | Char | 50 | Vendor Name (could be alias name) |
FGLOBALNAME | Char | 80 | Reserved |
FVENDORGUID | Char | 32 | Vendor globally unique ID |
FOBSERVEDELETED | Timestamp | Date and time that the library was deleted from Inquisitor data. |
Column name | Column type | Column length | Description |
---|---|---|---|
FPOVID | Integer | Version ID | |
FVERSIONNAME | Char | 44 | Version name |
FPPNUMNAME | Char | 16 | PPNUM |
FPRODUCTID | Integer | Product Option ID | |
FMINUSAGE | Float | Minimum usage threshold | |
FVERSIONGUID | Char | 32 | Product version globally unique identifier. PRODUCT.SW_KEY for SW_TYPE = VERSION |
FFEATUREGUID | Char | 32 | Product feature globally unique identifier. PRODUCT.SW_KEY for SW_TYPE = FEATURE |
FOBSERVEDELETED | Timestamp | Date and time that the library was deleted from Inquisitor data. | |
FFMID | Char | 8 | FMID of the z/OS |
FSUITE_ID | Smallint | ID of the Suite |
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-508Searila |
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 | Feature name |
Version | Integer | Version | |
PID | CHAR | 16 | PID |
SSPID | CHAR | 16 | S&S PID |
EIDPID | CHAR | 16 | Entitlement 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 | 25 | 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 machine used |
LAST_UPDATE | DATE | Last date it was updated | |
ENTITLED | CHAR | 1 | Licensed Y or N |
VERIFY_ERROR | VARCHAR | 255 | Verification errors |