perf_db2 Class Reference

Inheritance diagram for perf_db2:

Collaboration diagram for perf_db2:

Public Member Functions
	perf_db2 (&$conn)
	Explain ($sql, $partial=false)
	Tables ()
Data Fields
	$createTableSQL
	$settings

---

Detailed Description

Definition at line 21 of file perf-db2.inc.php.

---

Member Function Documentation

Explain	(	$	sql,
		$	partial = false
	)

Reimplemented from adodb_perf.

Definition at line 64 of file perf-db2.inc.php.

Here is the call graph for this function:

perf_db2

(

&$

conn

)

Definition at line 59 of file perf-db2.inc.php.

Tables

(

)

Definition at line 94 of file perf-db2.inc.php.

Here is the call graph for this function:

---

Field Documentation

$createTableSQL

Initial value:

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

Reimplemented from adodb_perf.

Definition at line 22 of file perf-db2.inc.php.

$settings

Initial value:

 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
        )

Definition at line 31 of file perf-db2.inc.php.

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/perf/perf-db2.inc.php