Diagnostic BI threshold files

When an BI threshold event is triggered, depending on the event level, the following BI logging files are created in the event subdirectory.

If your output format is CSV, the BI logging summary file is formatted as follows:

"Timestamp" "EventId" "DbName" "BIIO" "CrashProt" "CommitDelay" "ClusterAge" "Blksize" "Clustersize" "NumExtents" "BISize" "BytesFree" "LastChkpt" "BIBufs" "FullBuffers" "CurrCluster" "ClusterHWM"

If your output format is CSV, the BI logging detail file is formatted as follows:

"Timestamp" "EventId" "DbName" "TotalWrts" "BIWWrites" "RecWriten" "BytesWrtn" "TotReads" "RecRead" "BytesRead" "ClstrClose" "BBuffWaits" "EBuffWaits" "ForceWaits" "ForceWrts" "PartialWrts" "Trans" "UpTime" "InputBufHit" "OutputBufHit" "ModBufHit" "BOBufHit"

If your output format is CSV, the transaction detail file is formatted as follows:

"Timestamp" "EventId" "DbName" "UserNum" "TenantID" "TransID" "RLCounter" "State" "Flags" "JState" "JFlags" "XID" "Txtime" "Coord" "CoordTx" "Duration" "BIRecReads" "BIRecWrites"

If your output format is JSON, there is only one file in the event directory. The following example shows BI entries from a JSON-formatted diagnostic file:

{"BILogging_summary":{"BIIO":"Reliable","CrashProt":1,"CommitDelay":3,"ClusterAge":0,
"Blksize":8192,"Clustersize":524288,"NumExtents":1,"BISize":3193,"BytesFree":482471,
"LastChkpt":"2016-08-15T14:55:11.000-4:00]","BIBufs":20,"FullBuffers":5,"CurrCluster":2,
"ClusterHWM":5},

"file_detail":{
"file_entry":{"FileName":"/usr1/richb/11/x.db","Size":640,"InUse":5,"Extend":512,"Blksize":8192,
"IOMode":"BOTHIO","Reads":5,"Writes":0,"Extends":0,"BufWrites":1,"UnbufWrites":0,"BufReads":7,
"UnbufReads":0},
"file_entry":{"FileName":"/usr1/richb/11/x.b1","Size":3200,"InUse":400,"Extend":512,"Blksize":8192,
"IOMode":"UNBUFIO","Reads":15685,"Writes":67901,"Extends":1,"BufWrites":0,"UnbufWrites":67934,
"BufReads":0,"UnbufReads":15686},
"file_entry":{"FileName":"/usr1/richb/11/x.d1","Size":2176,"InUse":256,"Extend":512,"Blksize":8192,
"IOMode":"BOTHIO","Reads":67,"Writes":1018,"Extends":0,"BufWrites":1,"UnbufWrites":1018,
"BufReads":69,"UnbufReads":0},
"file_entry":{"FileName":"/usr1/richb/11/x_7.d1","Size":128,"InUse":15,"Extend":512,"Blksize":8192,
"IOMode":"BOTHIO","Reads":1,"Writes":0,"Extends":0,"BufWrites":1,"UnbufWrites":0,"BufReads":3,
"UnbufReads":0},
"file_entry":{"FileName":"/usr1/richb/11/x_8.d1","Size":4096,"InUse":511,"Extend":512,"Blksize":8192,
"IOMode":"BOTHIO","Reads":193,"Writes":30836,"Extends":0,"BufWrites":30837,"UnbufWrites":0,
"BufReads":195,"UnbufReads":0},