At the LInux level, installations will want to provide accounting for applications and processes by CPU. Storage and I/O are virtual and more difficult to charge.
The database extracts are very simple and look like the following, extracting by LInux application the server, application name, application process ID, and CPU seconds consumed.
EXTRACT: ; First extract system data columns ='10 10 10 8 8 8 8' TITLE = ' STARTTIME STOPTIME NODE APPL PID' Pages' TITLEc= ' CPU' TITLE = '---------- --------- --------- ------- ------' -----' TITLEc= ' -------'' INTERVAL='SU' CRITERIA='STARTTIME >= 080000' CRITERIA='STOPTIME <= 170000' CRITERIA='VSINAP.TOTCPU > 0 ' X = 'STARTTIME' Y = 'STOPTIME' Y ='NODE' Y ='VSINAP.NAME' Y ='VSINAP.ID ' Y ='VSINAP.TOTCPU / 100' ;Turn into CPU Seconds
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 NODE APPL PID CPU
---------- --------- --------- ------- ------ -------
20081019 120000 120000 130000 LXSG0002 *Totals 0 174
20081019 120000 120000 130000 LXSG0002 bash 26558 14
20081019 120000 120000 130000 LXSG0002 db2fmcd 8318 13
20081019 120000 120000 130000 LXSG0002 db2fmp 8558 0
20081019 120000 120000 130000 LXSG0002 db2sysc 8689 0
20081019 120000 120000 130000 LXSG0002 init 1 81
20081019 120000 120000 130000 LXSG0002 kernel 1 1
20081019 120000 120000 130000 LXSG0002 ksh 21432 0
20081019 120000 120000 130000 LXSG0002 oracle 5108 52
20081019 120000 120000 130000 LXSG0002 seosd 5678 4
20081019 120000 120000 130000 LXSG0002 snmpd 4606 5
20081019 120000 120000 130000 LXSG0002 sshd 26557 1
20081019 120000 120000 130000 LXSG0002 tnslsnr 21726 3
20081019 120000 120000 130000 LXSG0003 *Totals 0 223
20081019 120000 120000 130000 LXSG0003 auditd 3506 0
20081019 120000 120000 130000 LXSG0003 cdpmgr 2631 0
20081019 120000 120000 130000 LXSG0003 cron 3731 0
20081019 120000 120000 130000 LXSG0003 cupsd 3573 0
20081019 120000 120000 130000 LXSG0003 db2dasr 6398 0
20081019 120000 120000 130000 LXSG0003 db2fmcd 6337 16
20081019 120000 120000 130000 LXSG0003 db2fmd 6740 0
20081019 120000 120000 130000 LXSG0003 db2fmp 16319 1
20081019 120000 120000 130000 LXSG0003 db2sysc 16510 11
20081019 120000 120000 130000 LXSG0003 init 1 0
20081019 120000 120000 130000 LXSG0003 java 15807 174
20081019 120000 120000 130000 LXSG0003 kernel 1 2
20081019 120000 120000 130000 LXSG0003 lic98fd 3772 0
20081019 120000 120000 130000 LXSG0003 master 3709 0
