Use
You request the information given under
<info_id>.Prerequisites
You have the DBM operator authorization
DBInfoRead.You have opened an
SQL session.Syntax
info <info_id>
Option <info_id>
|
BADDEVSPACES |
Damaged devspaces |
|
BADIDX |
Damaged indexes |
|
CACHES |
Cache accesses |
|
CLSCON |
liveCache classes container (only for liveCache instance type) |
|
COLUMNS |
Columns of database instance tables |
|
DATA |
Data devspaces |
|
DEVSPACES |
Devspaces |
|
DISABLEDIDX |
Deactivated indexes |
|
EVENTS |
Active events |
|
INDEXES |
Database instance indexes |
|
INFOS |
Available information |
|
IO |
Read and write operations |
|
LOCKS |
Locks |
|
LOG |
Log status |
|
OMSCACHES |
liveCache caches (only for liveCache instance type) |
|
OMSMON |
liveCache monitors (only for liveCache instance type) |
|
PARAMS |
Parameters |
|
STATE |
A 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 |
Statistics can be updated for the Optimizer |
|
UPDSTATW |
Statistics must be updated for the Optimizer |
|
USERS |
Logged on database users |
|
VERSION |
Database program version |
Reply
OK<NL>
(END|CONTINUE)<NL>
<descriptionrecord><NL>
<inforecord><NL>
<inforecord><NL>
|
END |
Result set output complete |
|
Continue |
More result data ready |
The description line
<descriptionrecord> contains the field names of the following information lines <inforecord>.
