Use
You display the information given under
<info_id>.Prerequisites
You have the DBM operator authorization
DBInfoRead.You have started an
SQL session.Syntax
info <info_id>
Option <info_id>
|
BADVOLUMES |
Damaged  volumes |
|
BADIDX |
Damaged indexes |
|
CACHES |
Accesses to the caches |
|
CLSCON |
liveCache class container (only for the liveCache instance type) |
|
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 ( Log Concept) |
|
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 |
Update of the statistics for the Optimizer is possible ( See also: Optimizer: SAP DB 7.4) |
|
UPDSTATW |
Statistics must be updated for the Optimizer |
|
USERS |
Logged on database users |
|
VERSIONS |
Version of the database software |
Reply
OK<NL>
(END|CONTINUE)<NL>
<description_record><NL>
<info_record><NL>
<info_record><NL>
|
END |
Result set output complete |
|
Continue |
More result data ready |
The description line
<description_record> contains the names of the fields of the following information lines <info_record>.