HP 3000 Manuals

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


HP 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 1987|
|     >>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