PCSTRN
 
Data Columns | Computed Columns

AdapterHP Perf Agent
HP Performance Agent. Formerly OpenView Performance Agent. Enterprise systems management measurement data for IT resources from Windows systems and many UNIX variants.
Domain CategoryTransaction
DescriptionPCS Transaction Metrics
External TableTRANSACTIONS
Table TypeINTERVAL
RecommendedNo

Data Columns
NameLabelTypeLengthFormatInformatExternal NameRecommended
DATETIMEDatetime Numeric 6 NLDATM.     Yes
DURATIONDuration Numeric 6 TIME8.     Yes
LSTPDATELastProcessDate Numeric 8 NLDATM.   ProcessDate Yes
MACHINEMachine Character32 $32.     Yes
OSOpSys Character16       Yes
TRNBINSTransBinCount Numeric 6 NLNUM16.0   TT_NUM_BINS Yes
TRNBORTTransAbortedCount Numeric 6 NLNUM16.0   TT_ABORT Yes
TRNCENTTransServiceLevelExceededPct Numeric 6 NLPCT16.2   TT_SLO_PERCENT Yes
TRNDATEDate Numeric 6     DATE No
TRNDAYDay Numeric 6     DAY No
TRNGE1TransBin1TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_1 Yes
TRNGE10TransBin10TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_10 Yes
TRNGE2TransBin2TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_2 Yes
TRNGE3TransBin3TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_3 Yes
TRNGE4TransBin4TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_4 Yes
TRNGE5TransBin5TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_5 Yes
TRNGE6TransBin6TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_6 Yes
TRNGE7TransBin7TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_7 Yes
TRNGE8TransBin8TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_8 Yes
TRNGE9TransBin9TimeLimit Numeric 6 NLNUM16.0   TTBIN_UPPER_RANGE_9 Yes
TRNHOLDTransServiceLevelThreshold Numeric 6 NLNUM16.0   TT_SLO_THRESHOLD Yes
TRNINTVInterval Numeric 6     INTERVAL No
TRNNAMETransName Character60 $60.   TT_NAME Yes
TRNNT1TransBin1Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_1 Yes
TRNNT10TransBin10Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_10 Yes
TRNNT2TransBin2Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_2 Yes
TRNNT3TransBin3Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_3 Yes
TRNNT4TransBin4Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_4 Yes
TRNNT5TransBin5Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_5 Yes
TRNNT6TransBin6Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_6 Yes
TRNNT7TransBin7Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_7 Yes
TRNNT8TransBin8Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_8 Yes
TRNNT9TransBin9Count Numeric 6 NLNUM16.0   TTBIN_TRANS_COUNT_9 Yes
TRNOUNTTransCompletedCount Numeric 6 NLNUM16.0   TT_COUNT Yes
TRNRATETransCompletedPerMinute Numeric 6 NLNUM16.2   TT_TRAN_1_MIN_RATE Yes
TRNRCTYRecordType Character4 $4.   RECORD_TYPE No
TRNSECSDateSeconds Numeric 6     DATE_SECONDS No
TRNSLOCTransServiceLevelExceededCount Numeric 6 NLNUM16.0   TT_SLO_COUNT Yes
TRNT1RTTransCompletedPerHour Numeric 6 NLNUM16.2   TT_TERM_TRAN_1_HR_RATE Yes
TRNTIMETime Numeric 6     TIME No
TRNTRANResponseAvgTime Numeric 6 TIME12.2   TT_WALL_TIME_PER_TRAN Yes
TRNWTTRAbortedResponseAvgTime Numeric 6 TIME12.2   TT_ABORT_WALL_TIME_PER_TRAN Yes
TRNYEARYear Numeric 6     YEAR No
TTAPPNMApplicationName Character60     TT_APP_NAME Yes
TTAPPTNApplicationConcatenatedName Character60     TT_APP_TRAN_NAME Yes
TTCLADDClientAddress Character16     TT_CLIENT_ADDRESS Yes
TTCLAFTClientAddressFormat Numeric 8 NLNUM16.0   TT_CLIENT_ADDRESS_FORMAT Yes
TTCLTIDClientTransId Numeric 8 NLNUM16.0   TT_CLIENT_TRAN_ID Yes
TTCTTPTCpuAvgSeconds Numeric 8 NLNUM16.2   TT_CPU_TOTAL_TIME_PER_TRAN Yes
TTDLIPTDiskLogicalAvgIoCount Numeric 8 NLNUM16.0   TT_DISK_LOGL_IO_PER_TRAN Yes
TTDPIPTDiskPhysicalIoAvgCount Numeric 8 NLNUM16.0   TT_DISK_PHYS_IO_PER_TRAN Yes
TTFAILDTransFailedCount Numeric 8 NLNUM16.0   TT_FAILED Yes
TTINFOTransInformation Character60     TT_INFO Yes
TTTRNIDTransId Numeric 6 NLNUM16.0   TT_TRAN_ID Yes
TTUMAV2UserMeasurementAvg2 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG_2 No
TTUMAV3UserMeasurementAvg3 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG_3 No
TTUMAV4UserMeasurementAvg4 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG_4 No
TTUMAV5UserMeasurementAvg5 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG_5 No
TTUMAV6UserMeasurementAvg6 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG_6 No
TTUMAVGUserMeasurementAvg1 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_AVG No
TTUMCN2UserMeasurementCount2 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT_2 No
TTUMCN3UserMeasurementCount3 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT_3 No
TTUMCN4UserMeasurementCount4 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT_4 No
TTUMCN5UserMeasurementCount5 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT_5 No
TTUMCN6UserMeasurementCount6 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT_6 No
TTUMCNTUserMeasurementCount1 Numeric 6 NLNUM16.0   TT_USER_MEASUREMENT_COUNT No
TTUMMAXUserMeasurementMaximum1 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX No
TTUMMINUserMeasurementMinimum1 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN No
TTUMMN2UserMeasurementMinimum2 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN_2 No
TTUMMN3UserMeasurementMinimum3 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN_3 No
TTUMMN4UserMeasurementMinimum4 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN_4 No
TTUMMN5UserMeasurementMinimum5 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN_5 No
TTUMMN6UserMeasurementMinimum6 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MIN_6 No
TTUMMX2UserMeasurementMaximum2 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX_2 No
TTUMMX3UserMeasurementMaximum3 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX_3 No
TTUMMX4UserMeasurementMaximum4 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX_4 No
TTUMMX5UserMeasurementMaximum5 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX_5 No
TTUMMX6UserMeasurementMaximum6 Numeric 8 NLNUM16.2   TT_USER_MEASUREMENT_MAX_6 No
TTUMNM2UserMeasurementName2 Character12     TT_USER_MEASUREMENT_NAME_2 No
TTUMNM3UserMeasurementName3 Character12     TT_USER_MEASUREMENT_NAME_3 No
TTUMNM4UserMeasurementName4 Character12     TT_USER_MEASUREMENT_NAME_4 No
TTUMNM5UserMeasurementName5 Character12     TT_USER_MEASUREMENT_NAME_5 No
TTUMNM6UserMeasurementName6 Character12     TT_USER_MEASUREMENT_NAME_6 No
TTUMNMEUserMeasurementName1 Character12     TT_USER_MEASUREMENT_NAME No
TTUNAMEUserName Character60     TT_UNAME Yes
Top of Page

Computed Columns
NameLabelTypeLengthFormatInformatExpressionRecommended
DATETIMEFIFTEENMINDatetimeFifteenMinute Numeric 8 NLDATM.   Formula:DatetimeFifteenMinute Yes
DATETIMEFIVEMINDatetimeFiveMinute Numeric 8 NLDATM.   Formula:DatetimeFiveMinute Yes
DATETIMEONEMINDatetimeOneMinute Numeric 8 NLDATM.   Formula:DatetimeOneMinute Yes
DATETIMETENMINDatetimeTenMinute Numeric 8 NLDATM.   Formula:DatetimeTenMinute Yes
DATETIMETHIRTYMINDatetimeThirtyMinute Numeric 8 NLDATM.   Formula:DatetimeThirtyMinute Yes
DATETIMETWENTYMINDatetimeTwentyMinute Numeric 8 NLDATM.   Formula:DatetimeTwentyMinute Yes
DAYDATEDate Numeric 8 NLDATE10.   Formula:DayDate Yes
DAYOFMONTHDayOfMonth Numeric 8 2.   Formula:DayOfMonth Yes
DAYOFWEEKDayOfWeek Numeric 8 WKD.   Formula:DayOfWeek Yes
HOURHour Numeric 8 2.   Formula:Hour Yes
MONTHDATEStartOfMonth Numeric 8 NLDATE10.   Formula:MonthDate Yes
SHIFTShift Character1 $CHAR1.   Formula:Shift Yes
TIMETime Numeric 8 TOD5.   Formula:Time Yes
WEEKDATEStartOfWeek Numeric 8 NLDATE10.   Formula:WeekDate Yes
YEARDATEStartOfYear Numeric 8 NLDATE10.   Formula:YearDate Yes
Top of Page
v304000  27SEP2013