Reports database server property information.
sa_eng_properties
None.
Returns the PropNum, PropName, PropDescription, and Value for each available server property.
For a listing of available engine properties, see the section “Database properties” in the chapter “Database Performance and Connection Properties” in the Adaptive Server Anywhere Database Administration Guide.
The following statement returns a set of available server properties:
call sa_eng_properties()
PropNum |
PropName |
... |
|---|---|---|
0 |
IdleCheck |
... |
1 |
IdleWrite |
... |
2 |
IdleChkPt |
... |
... |
... |
... |
The following statement returns a set of available server properties:
sa_eng_properties
0,'IdleCheck','Idle I/O checked','0' 1,'IdleWrite','Idle I/O writes','0' 2,'IdleChkpt','Idle I/O checkpoints','0' 3,'IdleChkTime','Idle I/O checkpoint time','0' 4,'Chkpt','Checkpoints','5' 5,'ChkptPage','Checkpoint log pages','19' 6,'ChkptFlush','Checkpoint flushed pages','24' 7,'ExtendDB','Extend database file writes','0' 8,'ExtendTempWrite','Extend temporary file writes','198' 9,'FreeWritePush','Free list write to pushable list','0' 10,'FreeWriteCurr','Free list write to current list','0' 11,'CommitFile','Commit writes to disk','59' 12,'PendingReq','Pending requests detected','0' 13,'CurrRead','Active disk read requests','0' 14,'MaxRead','Maximum active disk read requests','3' 15,'CurrWrite','Active disk write requests','0' 16,'MaxWrite','Maximum active disk write requests','4' 17,'CurrIO','Active disk read/write requests','0' 18,'MaxIO','Maximum active disk read/write requests','4' 19,'JavaNSSize','Java VM Namespace size','0' 20,'IOToRecover','','0'
