HP 3000 Manuals

Ap C. IMAGE/SQL and Database Utilities [ IMAGE/SQL Administration Guide ] MPE/iX 5.0 Documentation


IMAGE/SQL Administration Guide

Appendix C  IMAGE/SQL and Database Utilities 

DBUTIL 

DBUTIL contains several enhancements to support IMAGE/SQL.

Displaying Information 

If the TurboIMAGE/XL database is attached to any DBEnvironments, the ALL
parameter of the SHOW command displays this information, as the following
example illustrates:
_______________________________________________________________________________
|                                                                             |
|     :DBUTIL                                                                 |
|     HP30391C.00.92 TurboIMAGE/XL:DBUTIL (C)COPYRIGHT HEWLETT-PACKARD COMPANY|
|                                                                             |
|     >>SHOW SALES ALL                                                        |
|       For database SALES                                                    |
|                                                                             |
|       Maintenance word is not present.                                      |
|                                                                             |
|       Access is enabled.                                                    |
|          .     .      .                                                     |
|          .     .      .                                                     |
|       No other users are accessing the database.                            |
|                                                                             |
|        Attached to these HP SQL DBEnvironments:                             |
|          PARTSDBE.SERED.ATC                                                 |
|     >>                                                                      |
_______________________________________________________________________________

            

Purging an Attached Database 

If you want to purge a TurboIMAGE/XL database that is attached to a
DBEnvironment, a new parameter of the PURGE command allows you to detach
and purge the database:
_____________________________________________________________________
|                                                                   |
|     >>PURGE ORDERS DETACH                                         |
|                                                                   |
|       Database has been detached from these HP SQL DBEnvironments:|
|         PARTSDBE.SERED.ATC                                        |
|                                                                   |
|       Database has been PURGED.                                   |
|     >>                                                            |
_____________________________________________________________________

            



MPE/iX 5.0 Documentation