perf_db2 Class Reference

Inheritance diagram for perf_db2:

Public Member Functions
	perf_db2 (&$conn)
	Explain ($sql, $partial=false)
	Tables ($throwaway=0)
Public Member Functions inherited from adodb_perf
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()

Public Attributes
	$createTableSQL
	$settings
Public Attributes inherited from adodb_perf
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

Additional Inherited Members
Static Public Member Functions inherited from adodb_perf
static	table ($newtable=false)

Detailed Description

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

Member Function Documentation

Explain()

perf_db2::Explain	(		$sql,
			$partial = false
	)

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

References $rs, $sql, rs2html(), and adodb_perf\Tracer().

perf_db2()

perf_db2::perf_db2

(

&

$conn

)

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

References adodb_perf\$conn.

Tables()

perf_db2::Tables

(

$throwaway = 0

)

Gets a list of tables

Parameters

int

$throwaway

discarded variable to match the parent method

Returns

string The formatted table list

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

References $rs, and rs2html().

Member Data Documentation

$createTableSQL

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

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

$settings

perf_db2::$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.