TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

452 Chapter8
Using the Database Utilities
>>SHOW
Example (Show All)
.
.
.
>>SHOW ORDERS ALL Display all information for ORDERS database.
For database ORDERS
MAINTENANCE WORD: SELL
Access is enabled.
Autodefer is disabled.
Dumping is disabled.
Rollback recovery is disabled.
Recovery is enabled.
ILR is disabled.
Mustrecover is enabled.
Logging is enabled.
Prefetch is disabled.
Indexing is disabled.
HWMPUT is disabled.
Restart is disabled.
Database last stored using True-Online Backup and
logfile NLOG001 on WED, MAR 26, 1997, 8:07 AM.
Database has been modified since last store date.
Shadowing is disabled.
Subsystem access is READ/WRITE.
CIUPDATE is allowed.
Dynamic capacity expansion is not used.
Database has at least one indexed dataset.
BTREEMODE1 is off, wildcard = "@".
Logid: NLOGID is valid.
password is correct.
XM log set : default XM user log set
for volume set MPEXL_SYSTEM_VOLUME_SET
XM log set type : circular
XM log set size : 32 megabytes
The language is 0 - NATIVE-3000.
Buffer specifications:
50(1/120)
No other users are accessing the database.
>>
where volname is the name of the volume set in which the database resides.
Example Discussion
The listing above indicates that the current buffer specifications provide for 50 buffers to
be allocated when there are between 1 and 120 concurrent users of the database. On
TurboIMAGE/XL the buffer specifications remain fixed, so the information shown in the