7.7.4 CSVファイルの出力
dlmperfinfoユーティリティーに-fパラメーターを指定すると,指定したファイル※に性能情報を出力します。項目名と値は,それぞれ「"」(引用符)で囲まれ,コンマ区切りで出力されます(CSV形式)。出力する内容は「表7‒5 出力内容一覧」を参照してください。
- 注※
-cパラメーターに「0」を指定した場合は,指定したCSVファイル名の後に_YYYYMMDDhhmmss.csvが付いたファイルに出力されます。YYYYMMDDhhmmssは,ファイルを作成した日時(協定世界時)です。
CSVファイルの出力例を次に示します。
実行例
# /usr/DynamicLinkManager/bin/dlmperfinfo -i 300 -c 2 -f CSVファイル名 KAPL13031-I The utility for displaying HDLM performance information (dlmperfinfo) will now start. Start time = 2018/02/27 10:46:45 KAPL13047-I Performance information is now being measured. (1 / 2) KAPL13047-I Performance information is now being measured. (2 / 2) KAPL13032-I The utility for displaying HDLM performance information (dlmperfinfo) finished. End time = 2018/02/27 10:56:45
CSVファイルの出力例
[Paths:000016] "UTC","Date","Time","LDEV","HDevName","Device","PathID","Count_R/s","Count_W/s","MB_R/s","MB_W/s","Time_R","Time_W" "20180227T014645","20180227","104645","VSP_G1500.51306.001816","hdisk22","00000","000000","292","2035","1.1418","7.9481","90.3120","114.1692" "20180227T014645","20180227","104645","VSP_G1500.51306.001816","hdisk22","00001","000001","292","2035","1.1394","7.9505","90.3569","114.2280" "20180227T014645","20180227","104645","VSP_G1500.51306.001816","hdisk22","00002","000002","292","2035","1.1390","7.9505","90.3647","114.1597" "20180227T014645","20180227","104645","VSP_G1500.51306.001816","hdisk22","00003","000003","292","2035","1.1391","7.9506","90.3475","114.2408" "20180227T014645","20180227","104645","VSP_G1500.51306.001817","hdisk23","00000","000004","290","2039","1.1335","7.9666","90.4164","114.1518" "20180227T014645","20180227","104645","VSP_G1500.51306.001817","hdisk23","00001","000005","291","2039","1.1360","7.9629","90.5416","114.2381" "20180227T014645","20180227","104645","VSP_G1500.51306.001817","hdisk23","00002","000006","291","2039","1.1362","7.9631","90.4259","114.1148" "20180227T014645","20180227","104645","VSP_G1500.51306.001817","hdisk23","00003","000007","291","2039","1.1374","7.9629","90.5037","114.2286" "20180227T014645","20180227","104645","VSP_G1500.51306.001818","hdisk24","00000","000012","290","2038","1.1344","7.9619","90.3891","114.1140" "20180227T014645","20180227","104645","VSP_G1500.51306.001818","hdisk24","00001","000013","291","2038","1.1347","7.9613","90.5078","114.2379" "20180227T014645","20180227","104645","VSP_G1500.51306.001818","hdisk24","00002","000014","290","2038","1.1337","7.9613","90.4661","114.2039" "20180227T014645","20180227","104645","VSP_G1500.51306.001818","hdisk24","00003","000015","290","2039","1.1318","7.9632","90.4551","114.2337" "20180227T014645","20180227","104645","VSP_G1500.51306.001819","hdisk25","00000","000008","291","2035","1.1384","7.9489","90.2306","114.0427" "20180227T014645","20180227","104645","VSP_G1500.51306.001819","hdisk25","00001","000009","291","2035","1.1383","7.9489","90.4776","114.2717" "20180227T014645","20180227","104645","VSP_G1500.51306.001819","hdisk25","00002","000010","292","2035","1.1391","7.9481","90.3865","114.1072" "20180227T014645","20180227","104645","VSP_G1500.51306.001819","hdisk25","00003","000011","292","2034","1.1396","7.9467","90.5456","114.2921" "UTC","Date","Time","LDEV","HDevName","Device","PathID","Count_R/s","Count_W/s","MB_R/s","MB_W/s","Time_R","Time_W" "20180227T015145","20180227","105145","VSP_G1500.51306.001816","hdisk22","00000","000000","295","2047","1.1516","7.9955","88.4042","113.3561" "20180227T015145","20180227","105145","VSP_G1500.51306.001816","hdisk22","00001","000001","295","2047","1.1517","7.9955","88.4009","113.4001" "20180227T015145","20180227","105145","VSP_G1500.51306.001816","hdisk22","00002","000002","294","2047","1.1499","7.9970","88.5480","113.4037" "20180227T015145","20180227","105145","VSP_G1500.51306.001816","hdisk22","00003","000003","295","2046","1.1536","7.9935","88.2833","113.4166" "20180227T015145","20180227","105145","VSP_G1500.51306.001817","hdisk23","00000","000004","291","2058","1.1363","8.0383","88.8031","113.3785" "20180227T015145","20180227","105145","VSP_G1500.51306.001817","hdisk23","00001","000005","291","2058","1.1373","8.0376","88.8011","113.4080" "20180227T015145","20180227","105145","VSP_G1500.51306.001817","hdisk23","00002","000006","291","2057","1.1381","8.0364","88.8005","113.3757" "20180227T015145","20180227","105145","VSP_G1500.51306.001817","hdisk23","00003","000007","290","2059","1.1332","8.0413","88.7721","113.4138" "20180227T015145","20180227","105145","VSP_G1500.51306.001818","hdisk24","00000","000012","291","2055","1.1378","8.0289","88.7737","113.3211" "20180227T015145","20180227","105145","VSP_G1500.51306.001818","hdisk24","00001","000013","290","2056","1.1345","8.0316","88.9091","113.5148" "20180227T015145","20180227","105145","VSP_G1500.51306.001818","hdisk24","00002","000014","291","2056","1.1352","8.0315","88.8525","113.4083" "20180227T015145","20180227","105145","VSP_G1500.51306.001818","hdisk24","00003","000015","290","2056","1.1346","8.0321","88.8914","113.4840" "20180227T015145","20180227","105145","VSP_G1500.51306.001819","hdisk25","00000","000008","296","2044","1.1554","7.9852","88.2043","113.2160" "20180227T015145","20180227","105145","VSP_G1500.51306.001819","hdisk25","00001","000009","295","2045","1.1534","7.9872","88.4633","113.4485" "20180227T015145","20180227","105145","VSP_G1500.51306.001819","hdisk25","00002","000010","295","2045","1.1542","7.9864","88.3137","113.2795" "20180227T015145","20180227","105145","VSP_G1500.51306.001819","hdisk25","00003","000011","296","2044","1.1557","7.9856","88.4467","113.4392"
注意事項
-cパラメーターに「0」を指定した場合,ユーザーがユーティリティーの実行を中止しないかぎり,連続実行します。ユーティリティーを終了するには[Ctrl]+[C]で処理を中止してください。
CSVファイルを出力する場合は,ファイル出力先のディスクを圧迫しないように,次の計算式で必要なディスク容量を計算してください。また,不要になったCSVファイルは適宜削除するようにしてください。
-cパラメーターに「0」を指定した場合
-aパラメーターを指定した場合
1025バイト×((パス数+1)×-mパラメーターで指定する値+1)×-rパラメーターで指定する値(バイト)
-aパラメーターを指定しない場合
671バイト×((パス数+1)×-mパラメーターで指定する値+1)×-rパラメーターで指定する値(バイト)
-cパラメーターに「0」以外を指定した場合
-aパラメーターを指定した場合
1025バイト×((パス数+1)×-cパラメーターで指定する値+1)(バイト)
-aパラメーターを指定しない場合
671バイト×((パス数+1)×-cパラメーターで指定する値+1)(バイト)
- (例1)パス数が3060の環境で,-aパラメーターを指定して288回収集する場合
dlmperfinfo -c 288 -f CSVファイル名 -aを実行する場合で,ファイルサイズは次のとおりです。
1025×((3060+1)×288+1)=903608225(バイト)(約862MB)
- (例2)パス数が500の環境で,-aパラメーターを指定して,1分の時間間隔で1日分を1ファイルとして,1年間分のファイルを収集する場合
-mパラメーターは,60分×24時間=1440,-rパラメーターは,1年の日数+1=366 なので,dlmperfinfo -i 60 -c 0 -f CSVファイル名 -m 1440 -r 366 -aを実行する場合で,ファイルサイズは次のとおりです。
1025×(500+1)×(1440+1)×366=270836166150(バイト)(約252.2GB)
- (例3)パス数が1000の環境で,-aパラメーターを指定して,ファイルあたりの測定回数を1440として,ファイル容量を2TB以内にする場合
-rパラメーターの値=2×10244÷(1025×1001×1441)≒1487.3(ファイル)
そのため,ファイル容量を2TB以内にするには1487ファイルまで作成できるので,dlmperfinfo -c 0 -f CSVファイル名 -m 1440 -r 1487 -aを実行できます。
CSV出力ファイルの行数は次の計算で求められます。次の計算式で1ファイル当たりの出力行数を算出し,測定回数を調整してください。
-cパラメーターに「0」を指定した場合
(パス数+1)×-mパラメーターで指定する値+1
ただし,ヘッダー部分を表示しないように-tパラメーターを指定して実行した場合は,次のようになります。
パス数×-mパラメーターで指定する値
-cパラメーターに「0」以外を指定した場合
(パス数+1)×-cパラメーターで指定する値+1
ただし,ヘッダー部分を表示しないように-tパラメーターを指定して実行した場合は,次のようになります。
パス数×-cパラメーターで指定する値
- (例1)パス数が500の環境で,ヘッダー部分を表示しないで1ファイルに500回分測定結果を出力する場合の行数
(500+0)×500+0=250000(行)
- (例2)パス数が1000の環境で,ヘッダー部分も表示して1048576行までに抑える測定回数
(1048576-1)÷(1000+1)≒1047.5(回)
そのため,1ファイルに1047回まで測定結果を出力できます。