HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Appendix F SQLUtil

STOREINFO

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

This command lists the physical name and size of all the files backed up on a specified tape or disk file.

Scope

SQLUtil Only

SQLUtil Syntax

>> STOREINFO From File Name: StoreFileName

Parameters

StoreFileName

is the name of the tape device or serial disk.

Description

  • The STOREINFO command lists the names of the DBEFiles and the size of each in pages stored on the specified device.

  • The STOREINFO command should be used from the same directory from which the STORE or STOREONLINE command was issued. This is usually the directory 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 directory 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 directory from which the files were stored (usually the directory 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: /dev/rmt/0h

   DBEfile Name: PartsDBE

   Size:           0

   DBEfile Name: PartsF0

   Size:           150

   DBEfile Name: PurchDF1

   Size:            50

   DBEfile Name: PurchFX1

   Size:            50

   DBEfile Name: driveB/WarehDF1

   Size:            50

   DBEfile Name: driveC/WarehXF1

   Size:            50

   DBEfile Name: OrderDF1

   Size:            50

   DBEfile Name: FileData

   Size:            50

   DBEfile Name: RecDF1

   Size:            50
Feedback to webmaster