Class perf_db2
Description
Located in /adodb5/perf/perf-db2.inc.php (line 21)
adodb_perf | --perf_db2
Variable Summary
mixed
$createTableSQL
mixed
$settings
Variables
mixed
$createTableSQL
= "CREATE TABLE adodb_logsql (
created TIMESTAMP NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 varchar(4000) NOT NULL,
params varchar(3000) NOT NULL,
tracer varchar(500) NOT NULL,
timer decimal(16,6) NOT NULL
)" (line 22)
created TIMESTAMP NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 varchar(4000) NOT NULL,
params varchar(3000) NOT NULL,
tracer varchar(500) NOT NULL,
timer decimal(16,6) NOT NULL
)" (line 22)
mixed
$settings
= array(
'Ratios',
'data cache hit ratio' => array('RATIO',
"SELECT
case when sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)=0 then 0
else 100*(1-sum(POOL_DATA_P_READS+POOL_INDEX_P_READS)/sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)) end
FROM TABLE(SNAPSHOT_APPL('',-2)) as t",
'=WarnCacheRatio'),'Data Cache','data cache buffers'=>array('DATAC','select sum(npages) from SYSCAT.BUFFERPOOLS','See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.'),'cache blocksize'=>array('DATAC','select avg(pagesize) from SYSCAT.BUFFERPOOLS',''),'data cache size'=>array('DATAC','select sum(npages*pagesize) from SYSCAT.BUFFERPOOLS',''),'Connections','current connections'=>array('SESS',"SELECT count(*) FROM TABLE(SNAPSHOT_APPL_INFO('',-2)) as t",''),false) (line 31)
'Ratios',
'data cache hit ratio' => array('RATIO',
"SELECT
case when sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)=0 then 0
else 100*(1-sum(POOL_DATA_P_READS+POOL_INDEX_P_READS)/sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)) end
FROM TABLE(SNAPSHOT_APPL('',-2)) as t",
'=WarnCacheRatio'),'Data Cache','data cache buffers'=>array('DATAC','select sum(npages) from SYSCAT.BUFFERPOOLS','See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.'),'cache blocksize'=>array('DATAC','select avg(pagesize) from SYSCAT.BUFFERPOOLS',''),'data cache size'=>array('DATAC','select sum(npages*pagesize) from SYSCAT.BUFFERPOOLS',''),'Connections','current connections'=>array('SESS',"SELECT count(*) FROM TABLE(SNAPSHOT_APPL_INFO('',-2)) as t",''),false) (line 31)
Methods
Documentation generated on Sun, 09 Mar 2008 23:52:44 -0300 by phpDocumentor 1.4.0
