Reports connection property information
sa_conn_properties ( [ connection-id ] )
Returns the connection id as Number, and the PropNum, PropName, PropDescription, and Value for each available connection property. Omitting the connection-id produces results for all connections.
For a listing of available connection properties, see the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide.
sa_conn_properties
569851433,29,'CacheHits','Cache hits','0' 569851433,30,'CacheRead','Cache reads','0' 569851433,31,'DiskRead','Disk reads','57' 569851433,32,'DiskSyncRead','Disk synchronous reads','0' 569851433,33,'DiskWaitRead','Disk wait for reads','0' 569851433,34,'DiskWaitWrite','Disk wait for writes','0' 569851433,35,'CacheReadTable','Cache table reads','0' 569851433,36,'CacheReadIndLeaf','Cache index leaf reads','0' 569851433,37,'CacheReadIndInt','Cache index interior reads','0' 569851433,38,'DiskReadTable','Disk table reads','0' 569851433,39,'DiskReadIndLeaf','Disk index leaf reads','0' 569851433,40,'DiskReadIndInt','Disk index interior reads','0' 569851433,41,'CacheWrite','Cache writes','0' 569851433,42,'DiskWrite','Disk writes','4'
CacheHits is
always reported as 0 by sa_conn_properties,
as this information is not stored by user connection. To get cache
hit statistics for the entire cache, use sa_eng_properties,
and see the output lines for CacheHitsEng, CacheReadEng,
and DiskReadEng. If you
run the same query on the Catalog Store repeatedly, the first time
you should see reads increase but no cache hits; as you repeat the
query, cache hits increase in step with cache reads.
