core/sql/regress/core/FILTERRTS

fil=$1
if [ "$fil" = "" ]; then
  echo "Usage: $0 filename"
  exit 1
fi
sed  "
/6        EX_HASH_GRBY/{N
s/6        EX_HASH_GRBY[ ]*[A-Z0-9 ,._-]*\n/hash_grby_stats/
}
s/6 EX_HASH_GRBY [A-Z0-9 ,._-]*/@hash_grby_stats@/
s/hash_grby_stats[0-9 ,.]*/@hash_grby_stats@/
s/[A-Z0-9 ,-]*\.[A-Z0-9]*\.TSTATI/#CAT.#SCH.TSTATI pertableStats/
s/[A-Z0-9 ,-]*\.[A-Z0-9]*\.TSTAT/#CAT.#SCH.TSTAT pertableStats/
s/QID[ ]*MXID[A-Z0-9_]*/QID @QID@/
s/QID[ ]*'MXID[A-Z0-9_]*'/QID '@QID@'/
s/Qid[ ]*MXID[A-Z0-9_]*/Qid @QID@/
s/qid[ ]*MXID[A-Z0-9_]*/qid @QID@/
s/Start Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Start Time @StartTime@/
s/End Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/End Time @EndTime@/
s/Elapsed Time[ ]*[0-9]*:[0-9]*:[0-9]*.[0-9]*/Elapsed Time @ElpasedTime@/
s/Compile Start Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Compile Start Time @CompileStartTime@/
s/Compile End Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Compile End Time @CompileEndTime@/
s/Execute Start Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Execute Start Time @ExecuteStartTime@/
s/Execute End Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Execute End Time @ExecuteEndTime@/
s/First Row Returned Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/First Row Returned Time @First Row Returned Time@/
s/Execution Time[ ]*[0-9]*:[0-9]*:[0-9]*.[0-9]*/Execution Time @ExecutionTime@/
s/Compile Time[ ]*[0-9]*:[0-9]*:[0-9]*.[0-9]*/Compile Time @CompileTime@/
s/SQL Error Code[ ]*[0-1]*/SQL Error Code @SQL Error Code@/
s/Estimated Accessed Rows[ ]*[0-9,]*/Estimated Accessed Rows @EstimatedAccessedRows@/
s/Estimated Used Rows[ ]*[0-9,]*/Estimated Used Rows @EstimatedUsedRows@/
s/Last Error before AQR[ ]*[0\-]*[0-9]*/Last Error before AQR @Last Error before AQR@/
s/Number of AQR retries[ ]*[0-9,]*/Number of AQR retries @Number of AQR retries@/
s/Delay before AQR[ ]*[0-9,]*/Delay before AQR @Delay before AQR@/
s/Message Count[ ]*[0-9,]*/Message Count @MessageCount@/
s/Message Bytes[ ]*[0-9,]*/Message Bytes @MessageBytes@/
s/SE IOs[ ]*[0-9,]*/SE IOs @SE IOs@/
s/SE IO Bytes[ ]*[0-9,]*/SE IO Bytes @MessageBytes@/
s/SE IO MAX Time[ ]*[0-9,]*/SE IO MAX Time @SE IO MAX Time@/
s/SQL Process Busy Time[ ]*[0-9,]*/SQL Process Busy Time @SQLProcessBusyTime@/
s/SQL Space Allocated[ ]*[0-9,]*[ ]*/SQL Space Allocated @SQLSpaceAllocated@/
s/SQL Space Used[ ]*[0-9,]*[ ]*/SQL Space Used @SQLSpaceUsed@/
s/SQL Heap Allocated[ ]*[0-9,]*[ ]*/SQL Heap Allocated @SQLHeapAllocated@/
s/SQL Heap Used[ ]*[0-9,]*[ ]*/SQL Heap Used @SQLHeapUsed@/
s/SQL Heap WM[ ]*[0-9,]*[ ]*/SQL Heap WM @SQLHeapWM@/
s/Process Create Time[ ]*[0-9,]*/Process Create Time @ProcessCreateTime@/
s/Processes Created[ ]*[0-9,]*/Processes Created @ProcessesCreated@/
s/Opens[ ]*[0-9,]*/Opens @Opens@/
s/Open Time[ ]*[0-9,]*/Open Time @OpenTime@/
s/Query Id MXID[A-Z0-9_]*/Query Id @QID@/
s/Number of Cpus[ ]*[0-9,]*/Number of Cpus @numberofcpus@/
s/Number of SQL Processes[ ]*[0-9,]*/Number of SQL Processes @numberofsqlprocesses@/
s/Execution Priority[ ]*[0-9,-]*/Execution Priority @executionpriority@/
s/Transaction Id[ ]*[\0-9A-Z().-]*/Transaction Id @transactionId@/
s/Execute Time[ ]*[0-9,.]*/Execution Time@executionTime@/
s/Node name[ ]*[\0-9A-Za-z().:-]*/Node name @nodeName@/
s/RMS Version[ ]*[0-9,]*/RMS Version @rmsVersion@/
s/SSCP PID[ ]*[0-9,]*/SSCP PID @sscpPID@/
s/SSCP Creation Timestamp[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/SSCP Creation Timestamp @sscpCreationTimestamp@/
s/SSMP PID[ ]*[0-9,]*/SSMP PID @ssmpPID@/
s/SSMP Creation Timestamp[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/SSMP Creation Timestamp @ssmpCreationTimestamp@/
s/Stats Heap Allocated[ ]*[0-9,]*/Stats Heap Allocated @statsHeapAllocated@/
s/Stats Heap Used[ ]*[0-9,]*/Stats Heap Used @statsHeapUsed@/
s/Stats Heap High WM[ ]*[0-9,]*/Stats Heap High WM @statsHeapHighWM@/
s/No.of Process Stats Heaps[ ]*[0-9,]*/No.of Process Stats Heaps @noOfProcessStatsHeaps@/
s/No.of Process Regd.[ ]*[0-9,]*/No.of Process Regd. @noOfProcessRegd@/
s/No.of Query Fragments Regd.[ ]*[0-9,]*/No.of Query Fragments Regd. @noOfQueryFragmentsRegd@/
s/RMS Semaphore Owner[ ]*[0-9,]*/RMS Semaphore Owner @rmsSemaphoreOwner@/
s/No.of SSCPs Opened[ ]*[0-9,]*/No.of SSCPs Opened @noOfSSCPsOpened@/
s/No.of SSCPs Open Deleted[ ]*[0-9,]*/No.of SSCPs Open Deleted @noOfSSCPsOpenDeleted@/
s/Last GC Time[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/Last GC Time @lastGCTime@/
s/Queries GCed in Last Run[ ]*[0-9,]*/Queries GCed in Last Run @queriesGCedInLastRun@/
s/Total Queries GCed[ ]*[0-9,]*/Total Queries GCed @totalQueriesGCed@/
s/SSMP Request Message Count[ ]*[0-9,]*/SSMP Request Message Count @ssmpRequestMessageCount@/
s/SSMP Request Message Bytes[ ]*[0-9,]*/SSMP Request Message Bytes @ssmpRequestMessageBytes@/
s/SSMP Reply Message Count[ ]*[0-9,]*/SSMP Reply Message Count @ssmpReplytMessageCount@/
s/SSMP Reply Message Bytes[ ]*[0-9,]*/SSMP Reply Message Bytes @ssmpReplyMessageBytes@/
s/SSCP Request Message Count[ ]*[0-9,]*/SSCP Request Message Count @sscpRequestMessageCount@/
s/SSCP Request Message Bytes[ ]*[0-9,]*/SSCP Request Message Bytes @sscpRequestMessageBytes@/
s/SSCP Reply Message Count[ ]*[0-9,]*/SSCP Reply Message Count @sscpReplytMessageCount@/
s/SSCP Reply Message Bytes[ ]*[0-9,]*/SSCP Reply Message Bytes @sscpReplyMessageBytes@/
s/Query Invalidation Keys[ ]*[0-9]*/Query Invalidation Keys/
s/Configured Pid Max[ ]*[0-9]*/Configured Pid Max @configuredPidMax@/
s/IPC Memory Allocated[ 0-9]*/IPC Memory Allocated @exeMemory@/
s/EXE Memory Allocated[ 0-9]*/EXE Memory Allocated @ipcMemory@/
s/IPC Memory Used High WM[ 0-9]*/IPC Memory Used High WM @exeMemory@/
s/EXE Memory Used High WM[ 0-9]*/EXE Memory Used High WM @ipcMemory@/
s/IPC Memory Used[ 0-9]*/IPC Memory Used @exeMemory@/
s/EXE Memory Used[ 0-9]*/EXE Memory Used @ipcMemory@/
s/PID[0-9 ]*/PID @pid@/
s/RMS Stats Reset Timestamp[ ]*[0-9]*\/[0-9]*\/[0-9]* [0-9]*:[0-9]*:[0-9]*.[0-9]*/RMS Stats Reset Timestamp @rmsStatsResetTimestamp@/
s/EX_ROOT[ ]*[0-9, |]*/EX_ROOT @exRootCounters@/
s/EX_SPLIT_TOP[ ]*[0-9, |]*/EX_SPLIT_TOP @exSplitTopCounters@/
s/EX_SPLIT_BOTTOM[ ]*[0-9, |]*/EX_SPLIT_BOTTOM @exSplitBottomCounters@/
s/EX_SEND_TOP[ ]*[0-9, |]*/EX_SEND_TOP @exSendTopCounters@/
s/EX_SEND_BOTTOM[ ]*[0-9, |]*/EX_SEND_BOTTOM @exSendBottomCounters@/
s/EX_HASH_GRBY[ ]*[0-9, -|A-Z]*/EX_HASH_GRBY @exHashGrbyCounters@/
s/EX_TRAF_KEY_SELECT[ ]*[0-9, |]*/EX_TRAF_KEY_SELECT @exTrafKeySelectCounters@/

/[A-Z0-9]*\.[A-Z0-9]*\.TSTATI[ ]*/{N
s/[A-Z0-9]*\.[A-Z0-9]*\.TSTATI[ ]*\n[0-9 ,]*/#CAT.#SCH.TSTATI pertableStats/
}
/[A-Z0-9]*\.[A-Z0-9]*\.TSTAT[ ]*/{N
s/[A-Z0-9]*\.[A-Z0-9]*\.TSTAT[ ]*\n[0-9 ,]*/#CAT.#SCH.TSTAT pertableStats/
}
/TSTAT(TSTAT)[ ]*/{N
s/TSTAT(TSTAT)[ ]*\n[0-9 ]*\n[0-9 ,]*/TSTAT(TSTAT) @pertableStats@/
}
/STORE/{N
s/STORE\n[0-9 ,]*/STORE @pertableStats@/
}
/pertableStats/{N
s/pertableStats\n[0-9 ,]*/@pertableStats@/
}
s/pertableStats[0-9 ,()|a-z]*/@pertableStats@/
" $fil