HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems > Appendix F SQLUtil

STOREINFO

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

This command lists the physical name of all the files backed up on a specified tape.

Scope

SQLUtil Only

SQLUtil Syntax

>> STOREINFO From File Name: StoreFileName

Parameters

StoreFileName

is the name of the tape volume.

Description

  • The STOREINFO command lists the names of the DBEFiles stored on the specified device.

  • The STOREINFO command should be used from the same group and account from which the STORE or STOREONLINE command was issued. This is usually the group and account containing the DBECon file and the SYSTEM DBEFileSet.

  • If the backup was created using a full STORE or STOREONLINE, the DBECon file will be shown as one of the listed files. If the backup was created using a STORE PARTIAL or STOREONLINE PARTIAL, the DBECon file is not stored and will not be shown in the list of stored files.

  • If the DBEFiles have been moved to a group and account different from the one containing the DBECon file and the SYSTEM DBEFileSet, the fully qualified file name will be shown by STOREINFO. When you later restore the files, you must be in the group and account from which the files were stored (usually the group and account containing the DBECon file and SYSTEM DBEFileSet) and the file name used for the restore process must be exactly as shown by the STOREINFO command.

Authorization

Anyone can list the physical names of files on the archive.

Example

   >> STOREINFO

   From File Name: TAPE

   DBEfile Name: PartsDBE

   DBEfile Name: PartsF0

   DBEfile Name: PurchDF1

   DBEfile Name: PurchFX1

   DBEfile Name: driveB/WarehDF1

   DBEfile Name: driveC/WarehXF1

   DBEfile Name: OrderDF1

   DBEfile Name: FileData

   DBEfile Name: RecDF1


Feedback to webmaster