sa_get_dtt system procedure

sa_get_dtt( file_id )

file_id Use this UNSIGNED SMALLINT parameter to specify the database file ID.

You can obtain the file_id from the SYSDBSPACE system view.

This procedure, intended for internal diagnostic purposes, retrieves data from the ISYSOPTSTAT system table.

Column name	Data type	Description
BandSize	UNSIGNED INTEGER	Size, in pages, of disk over which random access takes place.
ReadTime	UNSIGNED INTEGER	Amortized cost, in microseconds, of reading one page.
WriteTime	UNSIGNED INTEGER	Amortized cost, in microseconds, of writing one page.

None

The following example reports the current value of the Disk Transfer Time (DTT) model for the system dbspace.

CALL sa_get_dtt( (select dbspace_id from SYSDBSPACE where dbspace_name='system') );