7.8.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×1024⁴÷（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回まで測定結果を出力できます。