Repository table layouts

This topic describes the tables in the Repository including column names, types, and length.

Table 1. NODE

NODE attributes
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
Table 2. NODE_CAPACITY

NODE_CAPACITY attributes
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
Table 3. PRODUCT

PRODUCT attributes
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
Table 4. PRODUCT_INSTALL

PRODUCT_INSTALL attributes
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
Table 5. PRODUCT_NODE_CAPACITY

PRODUCT_NODE_CAPACITY attributes
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
Table 6. PRODUCT_USE

PRODUCT_USE attributes
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
Table 7. PRODUCT_USE_DETAIL

PRODUCT_USE_DETAIL attributes
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
Table 8. SYSTEM

SYSTEM attributes
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
Table 9. SYSTEM_NODE

SYSTEM_NODE attributes
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
Table 10. TACCOUNT

TACCOUNT attributes
Column name Column type Column length Description
FACCOUNTID Integer Account ID
FACCOUNTCODE Char 20 Job Account Code, truncated to 20 characters
Table 11. TALTERNATE

TALTERNATE attributes
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
Table 12. TANNOTATE

TANNOTATE attributes
Column name Column type Column length Description
FTYPE Char 1 Annotation type:
  • A – Asset
  • D- Discovery
  • B - Both
PRODUCT_GUID Char 32 Globally Unique ID for VENDOR_NAME + PRODUCT_NAME
FANNOTATION Varchar 255 Text that is annotation
Table 13. TCHANNEL_PATH

TCHANNEL_PATH attributes
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
Table 14. TCONTROL_UNIT

TCONTROL_UNIT attributes
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
Table 15. TCSECT

TCSECT attributes
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
Table 16. TISVEOS

TISVEOS attributes
Column name Column type Column length Description

FPOVID

Integer

Product ID

FEOSDATE

Timestamp

End of Service Date

Table 17. TJOBDATA

TJOBDATA attributes
Column name Column type Column length Description
FJOBNAME Char 8 Job Name
FJOBID Integer   Job ID
FJOBTYPE Char 6 Job Type
Table 18. TLIBRARY

TLIBRARY attributes
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
Table 19. TLIBSYS

TLIBSYS attributes
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
Table 20. TLOGIQ

TLOGIQ attributes
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
Table 21. TLOGUI

TLOGUI attributes
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
Table 22. TLPAR

TLPAR attributes
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
Table 23. TMACHINE_RESOURCE

TMACHINE_RESOURCE attributes
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
Table 24. TMODULE

TMODULE attributes
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
Table 25. TPARAM

TPARAM attributes
Column name Column type Column length Description
FKEY Char 64 Parameter Key
FVALUE Char 254 Parameter Value
Table 26. TPERIODS

TPERIODS attributes
Column name Column type Column length Description
FPERIOD Date   Calendar month for usage
FINVID Integer   Inventory ID
FSUMMARISED Smallint   Summary status
Table 27. TPOVINV

TPOVINV attributes
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.
Table 28. TPOVLIB

TPOVLIB attributes
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
Table 29. TPRODUCT

TPRODUCT attributes
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
Table 30. TPRODUCT_REGISTRATION

TPRODUCT_REGISTRATION attributes
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
Table 31. TREGISTERED_PRODUCT_USAGE

TREGISTERED_PRODUCT_USAGE attributes
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
Table 32. TUSEMTD

TUSEMTD attributes
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
Table 33. TUSEPOV

TUSEPOV attributes
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
Table 34. TUSEPOVLIB

TUSEPOVLIB attributes
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
Table 35. TUSEPRS

TUSEPRS attributes
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
Table 36. TUSERDATA

TUSERDATA attributes
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
Table 37. TVENDOR

TVENDOR attributes
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.
Table 38. TVERSION

TVERSION attributes
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
Table 39. ACTIVCON (V2.2)

ACTIVCON attributes
Column name Column type Column length Description
ACTIVCON_ID Integer Active Container ID
CONTAINER_ID Char 6 ID of the Container
CONTAINER_NAME Char 50 Name of the Container
SOLUTION_ID Char 64 The solution ID supplied by IBM
MACHINE_ID Char  6 Name of the Machine
SERIAL Char 12 System z Hardware Serial
PERIOD Date Reporting Period
PEAK_4HOUR Integer Peak 4 Hour Consumption
TOTAL_MSU Integer Total MSU Consumption
Table 40. ACTIVPRD (V2.2)

ACTIVPRD attributes
Column name Column type Column length Description
CONTAINER_ID Char 6 ID of the Container
PID Char 16 Product Identifier
SOLUTION_ID Char 64 The solution ID supplied by IBM
PERIOD Date Reporting Period
PRODUCT Char 80 Name of the Product
PRDTYPE Char 8 MLC or IPLA
MACHINE_ID Char 6 Name of the Machine
SERIAL Char 12 System z Hardware Serial
Table 41. CONTCPU (V2.2)

CONTCPU attributes
Column name Column type Column length Description
MACHINE_ID Char 6 Name of the Machine
SERIAL Char 12 System z Hardware Serial
MODEL Char 10 Model of the Harware - eg 2965-605
PERIOD Date Reporting Period
MSU Integer   Total MSU for the machine
Table 42. CONTLPAR (V2.2)

CONTLPAR attributes
Column name Column type Column length Description
LPAR_ID Char 20 Name of the LPAR
TOTAL_MINUTES Integer Total minutes LPAR could have been online
TOTAL_MINUTES_COLLECTED Integer Total minutes for LPAR collected
MISSING_MINUTES Integer Missing minutes between possible online and actual collected.
TOTAL_MSU_CONSUM Integer Total MSU Consumed
CONTAINER_ID Char  6 ID of the Container
PERIOD Date Reporting Period
PEAK_HOUR_CONSUM Integer Peak Hour MSU consumption
MACHINE_ID Char 6 Name of the Machine
SERIAL Char 12 System z Hardware Serial
Table 43. CONTNER (V2.2)

CONTNER attributes
Column name Column type Column length Description
CONTAINER_ID Char 6 ID of the Container
CONTAINER_NAME Char 50 Name of the Container
SOLUTION_ID Char 64 The solution ID supplied by IBM
PERIOD Date Reporting Period
TOTAL_MSU Integer Total MSU consumed by the Container
MACHINE_ID Char  6 Name of the Machine
SERIAL Char 12 System z Hardware Serial
Table 44. EXCLUDE_SUITES (V2.2)

EXCLUDE_SUITES attributes
Column name Column type Column length Description
FLPARID Integer LPAR ID
FSYSPLEXID Char 8 z/OS Sysplex name
PRODUCT_NAME Char 80 Name of the Product
VERSION Char 16 Version of the Product
PID Char 16 PID of the Suite
SUITE_ID Smallint ID of the Suite
Table 45. PRODUCT_SUITES (V2.2)

PRODUCT_SUITES attributes
Column name Column type Column length Description
FLPARID Integer LPAR ID
FSYSPLEXID Char 8 z/OS Sysplex name
SUITE_ID Smallint ID of the Suite
SUITE_NAME Char 80 Name of the Suite
SUITE_VERSION Char 16 Version of the Suite
PID Char 16 PID of the Suite
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.
VENDOR_NAME Char 50 Vendor name of the Suite
FOBSERVEDELETED Timestamp Date and time that suite was deleted from system
Table 46. PRODUCT_VUE (V2.2)

PRODUCT_VUE attributes
Column name Column type Column length Description
PRODUCT_NAME Char 80 Product Name
FEATURE_NAME Char 80 Feature Name
PID Char 16 Product PID
VUPID Char 16 VUE PID
VUEID Char 8 VUE EID
VUSSPID Char 8 VUE S&S PID
VUSSEID Char 8 VUE S&S EID
VUICA Char 1 VUE ICA
VUIPLA Char 1 VUE IPLA
Table 47. TLICENSE (V2.2)

TLICENSE attributes
Column name Column type Column length Description
LICENSE KEY Integer License Key. Auto generated number
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_RNW_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 80 Product name
FEATURE Char 80 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
INITIAL_PRICE Char 80 Initial price
MAINT_PRICE Char 80 Maintenance price
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
LICENSE_SERIAL Char 255 License serial number
Table 48. LICENSE_VERIFY (V2.2)

LICENSE_VERIFY attributes
Column name Column type Column length Description
IMPORT_ID Integer Unique value
IMPORT_DATE Timestamp Date and time record was imported
VENDOR_NAME Char 50 Vendor Name
PRODUCT_NAME Char 80 Product Name
FEATURE_NAME Char 80 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 10 Hardware type, capacity, and serial number
SERIAL Char 12 CPU Serial Number Sample F6A27
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