iX V6.5 (30391-90011)

Chapter 8 453

Using the Database Utilities

>>SHOW

above listing is useful only for databases that will be migrated to an MPE V system. The

list above also shows that the database is enabled for roll-forward recovery, logging,

MUSTRECOVER, and user access. It shows that the database was backed up using

TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or ONLINE=END

option), and the logﬁle in use at the time was NLOG001. In the example, PREFETCH and

third-party indexing (TPI) are disabled, critical item update (CIUPDATE) is allowed, and the

restart ﬂag is disabled. The restart ﬂag is set by DBRECOV when the user has requested to

suspend recovery between log ﬁles. The logid is shown, the password is veriﬁed, and the

maintenance word is displayed. The messages that appear during the SHOW command

can vary depending on what information is available on the database. If the maintenance

word and logid are not present, the following messages display:

Logid is not present.

Maintenance word is not present.

The message regarding the transaction manager (XM) log set will also vary. The following

message is printed if the database is not attached to transaction manager:

XM log set: this database is not attached to an XM log set

The following message is printed if the database does not support NLS:

This database has been created before support of Native Languages.

If an error has occurred during dynamic roll-back recovery, the following message is

displayed:

Database is logically inconsistent.

The following message is printed if the database is attached to an ALLBASE/SQL

database environment (DBEnvironment) via the IMAGESQL utility:

Attached to these HP SQL DBEnvironments:

DBEname

The following message is printed if the third-party indices are registered in the

DBEnvironments.

Third Party Indexes are registered in these HPSQL DBEnvironments:

DBEname