You display the specified information.
· You have the DBInfoRead server authorization.
· You have opened a database session (see: Opening a Database Session).
info <info_ID>
<info_ID> |
ID of the information to be displayed. |
Possible values for info_ID
Value |
Description |
BADVOLUMES |
Damaged volumes |
BADIDX |
Damaged indexes |
CACHES |
Cache accesses |
CLSCON |
SAP liveCache class container (for database instance type liveCache only) |
COLUMNS |
Columns of database instance tables |
DATA |
Data volumes |
VOLUMES |
Volumes |
DISABLEDIDX |
Deactivated indexes |
EVENTS |
Active events |
INDEXES |
Database instance indexes |
INFOS |
Available information |
IO |
Read and write operations |
LOCKS |
Locks |
LOG |
Log status (see also Logging Transactions) |
OMSCACHES |
liveCache caches (only for liveCache instance type) |
OMSMON |
liveCache monitors (only for liveCache instance type) |
PARAMS |
Database parameters |
STATE |
Short description of the status of the database instance |
SYSDDCONFIG |
Internal configuration |
SYSDDMONITOR |
Internal monitors |
SYSDDSRVDB |
Internal database status |
TABLES |
Database instance tables |
UNUSEDIDX |
Unused indexes |
UPDSTAT |
Option for updating the Optimizer statistics |
UPDSTATW |
Statistics must be updated for the Optimizer |
USERS |
Logged on database users |
VERSIONS |
Version of the database software |
OK<NL>
(END|CONTINUE)<NL>
<description_record><NL>
<info_record><NL>
<info_record><NL>
Values for the Reply Fields
Field |
Description |
END |
Result set output complete |
Continue |
More result data available |
<description_record> |
Name of the fields in the subsequent information lines |
<info_record> |
Information |