$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
)"
$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)
