Accounting Analysis

Accounting for z/VM Servers

At the z/VM level, installations will want to provide accounting by

The database extracts are very simple and look like the following, extracting by user, the account number, cpu consumed, pages resident, and virtual I/O. Users only in the *Linux class are extracted, and only during prime shift.

 
EXTRACT:            ; First extract system data
 
columns ='10 10 10 10 7 8 8 8'
TITLE = 'STARTTIME  STOPTIME  USERID    ACCTNBR      CPU   Pages'
TITLEc= '      VIO'
TITLE = '---------- --------- --------- -------- -------  ------'
TITLEc= ' --------'
 
X = 'STARTTIME'
Y = 'STOPTIME'
Y = 'USERID'
Y = 'USRCON.VMDACTNO'
Y = 'USEACT.VMDTTIME' ; cpu utilization
Y = 'USEACT.VMDCTPVR / 256' ; MB Resident
Y = 'USEACT.VMDVDSCT' ; VIO
 
INTERVAL='SU'
CRITERIA='USRTYPE=USER'
CRITERIA='USRCON.CLASSID=*Linux'
CRITERIA='STARTTIME >= 080000'
CRITERIA='STOPTIME <= 170000'

The results of this extract then would look like the following showing hourly consumption by linux server. This would be input into installation accounting procedures.

 
Date    Time     STARTTIME  STOPTIME    USERID     CPU   Pages     VIO
                 ---------- --------- --------- -------  ------ -------
 20081019 120000  120000    130000    LXSG0001       24     854    8177
 20081019 120000  120000    130000    LXSG0002      239    6907  112741
 20081019 120000  120000    130000    LXSG0003      278    3233   15874
 20081019 120000  120000    130000    LXSG0008       73    4479    8509
 20081019 120000  120000    130000    LXSG0009       61    4484    9472
 20081019 120000  120000    130000    LXSG0010       83    3058   61239
 20081019 120000  120000    130000    LXSG0011      705    8637   23840
 20081019 120000  120000    130000    LXSG0012     2023    2491  510430
 20081019 120000  120000    130000    LXSG0013       54    3857   10175
 20081019 120000  120000    130000    LXSG0014       65    3022   37205
 20081019 120000  120000    130000    LXSG0015       69    3057   11297
 20081019 120000  120000    130000    LXSG0016       68    3063   11624
 20081019 120000  120000    130000    LXSG0017       92    1621    7030
 20081019 120000  120000    130000    LXSG0018       61    2043   10633
 20081019 120000  120000    130000    LXSG0019        9    2577   26429
 20081019 120000  120000    130000    LXSG0020      351    5696   13619
 20081019 120000  120000    130000    LXSG0022       82    2999    8390
 20081019 120000  120000    130000    LXSG0023      370    2988   29565
 20081019 120000  120000    130000    LXUS3062        2     413     885
 20081019 120000  120000    130000    LXUS3071        5     686    2980
 20081019 120000  120000    130000    LXUS4031        3     443    2214
 20081019 120000  120000    130000    LXUS4071        5     588    2860
 20081019 120000  120000    130000    LXUS4072        5     631    3021
 20081019 130000  130000    140000    LXSG0001       24     857    8091
 20081019 130000  130000    140000    LXSG0002      232    7417  103216
 20081019 130000  130000    140000    LXSG0003      281    3225   15846
 20081019 130000  130000    140000    LXSG0008       71    4466    8581
 20081019 130000  130000    140000    LXSG0009       56    4482    9520
 20081019 130000  130000    140000    LXSG0010       63    3055   55998
 20081019 130000  130000    140000    LXSG0011      348    8995   16514
 20081019 130000  130000    140000    LXSG0012     2016    2465  502991
 20081019 130000  130000    140000    LXSG0013       60    3858   10242
 20081019 130000  130000    140000    LXSG0014       51    3045   35876