perf_db2 Class Reference

Inheritance diagram for perf_db2:

Public Member Functions
	__construct (&$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://adodb.sourceforge.net/docs-adodb.htm#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 23 of file perf-db2.inc.php.

Constructor & Destructor Documentation

__construct()

perf_db2::__construct

(

&

$conn

)

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

References adodb_perf\$conn.

Member Function Documentation

Explain()

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

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

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

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 101 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 24 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 33 of file perf-db2.inc.php.