Creating Vdbench503 Swat charts using Swat302
By Henk Vandenbergh-Oracle on Mar 08, 2012
A few weeks ago I was reminded of an incompatibility between Vdbench503and Swat302 that I introduced quite a while back. The file format when using Swat302 'File' 'Import Vdbench data' for Vdbench503 data has changed. Since at this time no new version of Swat is available outside of Oracle that of course is a problem.
To help you convert the new 503 'swat_mon.txt' file contents so that it can be used by Swat302, run the AWK program below.
# Conversion of Vdbench503 swat_mon.txt file to a format that can be read
# by Swat302 using 'Import Vdbench data'.
# Note that this AWK program reads file swat_mon.txt (or a copy of it) and
# then replaces swat_mon.txt again.
# I suggest therefore that you first make a copy of swat_mon.txt and use that
# as input, because if you would accidentally run TWICE using swat_mon.txt as
# both input AND output you will have destroyed the original content of the file.
# To run:
# - cd /vdbench503
# - awk -f convert.awk output/swat_mon.txt.copy > output/swat_mon.txt
if ($1 == ":vdbench503_vdbench_data_for_swat303")
else if (NF != 14)
printf("%d %d %d %d %d %d %d %d %d %d %d %d %d %d\n",
$1, $2, $3, $4, $5/1000, $6, $7, $8, $9/1000, 0, 0, 0, 0, 0);