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 = yyyy/mm/dd hh:mm:ss 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 = yyyy/mm/dd hh:mm:ss #
CSVファイルの出力例
[Paths:000020] "UTC","Date","Time","LDEV","HDevName","Device","PathID","Count_R/s","Count_W/s","MB_R/s","MB_W/s","Time_R","Time_W" "20250619T090812","20250619","180812","VSP_5000.39368.0010E0","hdisk7","00000","000004","38","300","0.1466","1.1719","90.3883","132.5527" "20250619T090812","20250619","180812","VSP_5000.39368.0010E0","hdisk7","00001","000005","38","300","0.1466","1.1719","117.4470","152.8775" "20250619T090812","20250619","180812","VSP_5000.39368.0010E1","hdisk8","00000","000000","38","300","0.1466","1.1719","116.1439","160.8227" "20250619T090812","20250619","180812","VSP_5000.39368.0010E1","hdisk8","00001","000001","38","300","0.1466","1.1719","115.5646","159.9738" "20250619T090812","20250619","180812","VSP_5000.39368.0010E2","hdisk9","00000","000010","38","300","0.1466","1.1719","117.5882","161.8637" "20250619T090812","20250619","180812","VSP_5000.39368.0010E2","hdisk9","00001","000011","38","300","0.1466","1.1719","89.9418","138.5692" "20250619T090812","20250619","180812","VSP_5000.39368.0010E3","hdisk10","00000","000012","38","300","0.1466","1.1719","119.5142","169.9977" "20250619T090812","20250619","180812","VSP_5000.39368.0010E3","hdisk10","00001","000013","38","300","0.1466","1.1719","118.9600","168.6664" "20250619T090812","20250619","180812","VSP_5000.39368.0010E4","hdisk11","00000","000002","38","300","0.1466","1.1719","90.9922","132.4017" "20250619T090812","20250619","180812","VSP_5000.39368.0010E4","hdisk11","00001","000003","38","300","0.1466","1.1719","117.4436","152.8577" "20250619T090812","20250619","180812","VSP_5000.39368.0010E5","hdisk12","00000","000008","38","300","0.1466","1.1719","115.2178","161.2373" "20250619T090812","20250619","180812","VSP_5000.39368.0010E5","hdisk12","00001","000009","38","300","0.1466","1.1719","114.6267","160.7446" "20250619T090812","20250619","180812","VSP_5000.39368.0010E6","hdisk13","00000","000016","38","300","0.1466","1.1719","117.1726","162.9331" "20250619T090812","20250619","180812","VSP_5000.39368.0010E6","hdisk13","00001","000017","38","300","0.1466","1.1719","89.1909","138.6826" "20250619T090812","20250619","180812","VSP_5000.39368.0010E7","hdisk14","00000","000014","38","300","0.1466","1.1719","119.8519","170.6979" "20250619T090812","20250619","180812","VSP_5000.39368.0010E7","hdisk14","00001","000015","38","300","0.1466","1.1719","118.5932","169.5914" "20250619T090812","20250619","180812","VSP_5000.39368.0010E8","hdisk15","00000","000018","36","285","0.1392","1.1126","90.4089","132.4155" "20250619T090812","20250619","180812","VSP_5000.39368.0010E8","hdisk15","00001","000019","36","285","0.1391","1.1123","117.3243","152.9983" "20250619T090812","20250619","180812","VSP_5000.39368.0010E9","hdisk16","00000","000006","35","283","0.1384","1.1065","114.4543","161.6651" "20250619T090812","20250619","180812","VSP_5000.39368.0010E9","hdisk16","00001","000007","35","283","0.1385","1.1071","114.3736","160.5120" "UTC","Date","Time","LDEV","HDevName","Device","PathID","Count_R/s","Count_W/s","MB_R/s","MB_W/s","Time_R","Time_W" "20250619T091312","20250619","181312","VSP_5000.39368.0010E0","hdisk7","00000","000004","38","300","0.1466","1.1719","89.9967","132.3672" "20250619T091312","20250619","181312","VSP_5000.39368.0010E0","hdisk7","00001","000005","38","300","0.1466","1.1719","116.3529","152.5056" "20250619T091312","20250619","181312","VSP_5000.39368.0010E1","hdisk8","00000","000000","38","300","0.1466","1.1719","115.6368","160.9191" "20250619T091312","20250619","181312","VSP_5000.39368.0010E1","hdisk8","00001","000001","38","300","0.1466","1.1719","114.9051","159.7950" "20250619T091312","20250619","181312","VSP_5000.39368.0010E2","hdisk9","00000","000010","38","300","0.1466","1.1719","117.9507","161.9552" "20250619T091312","20250619","181312","VSP_5000.39368.0010E2","hdisk9","00001","000011","38","300","0.1466","1.1719","89.9841","138.5760" "20250619T091312","20250619","181312","VSP_5000.39368.0010E3","hdisk10","00000","000012","38","300","0.1466","1.1719","119.6205","169.3871" "20250619T091312","20250619","181312","VSP_5000.39368.0010E3","hdisk10","00001","000013","38","300","0.1466","1.1719","119.3955","169.3386" "20250619T091312","20250619","181312","VSP_5000.39368.0010E4","hdisk11","00000","000002","38","300","0.1466","1.1719","90.3959","132.0045" "20250619T091312","20250619","181312","VSP_5000.39368.0010E4","hdisk11","00001","000003","38","300","0.1466","1.1719","116.7634","152.5841" "20250619T091312","20250619","181312","VSP_5000.39368.0010E5","hdisk12","00000","000008","38","300","0.1466","1.1719","114.8744","161.1648" "20250619T091312","20250619","181312","VSP_5000.39368.0010E5","hdisk12","00001","000009","38","300","0.1466","1.1719","114.5434","160.7401" "20250619T091312","20250619","181312","VSP_5000.39368.0010E6","hdisk13","00000","000016","37","292","0.1427","1.1406","117.2117","162.8283" "20250619T091312","20250619","181312","VSP_5000.39368.0010E6","hdisk13","00001","000017","37","292","0.1426","1.1402","89.8542","138.8795" "20250619T091312","20250619","181312","VSP_5000.39368.0010E7","hdisk14","00000","000014","35","283","0.1385","1.1070","119.5293","170.2054" "20250619T091312","20250619","181312","VSP_5000.39368.0010E7","hdisk14","00001","000015","35","283","0.1384","1.1065","118.7624","169.2422" "20250619T091312","20250619","181312","VSP_5000.39368.0010E8","hdisk15","00000","000018","37","299","0.1459","1.1663","90.2183","132.0293" "20250619T091312","20250619","181312","VSP_5000.39368.0010E8","hdisk15","00001","000019","37","299","0.1458","1.1661","116.8517","152.5085" "20250619T091312","20250619","181312","VSP_5000.39368.0010E9","hdisk16","00000","000006","38","300","0.1466","1.1719","114.5328","161.3204" "20250619T091312","20250619","181312","VSP_5000.39368.0010E9","hdisk16","00001","000007","38","300","0.1466","1.1719","114.0604","160.2310"
注意事項
-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回まで測定結果を出力できます。