Using LOAD HEADERONLY, any client can retrieve all the volume and dump header information for all dumps on a particular dump device. The header information is sent as a row by the server for each dump on a given dump device in a table with following columns:
| Option | Datatype | Possible information |
|---|---|---|
| Dumptype | smallint | Database(1) or Transaction(2) |
| Database | varchar(30) | Database name |
| Striped | smallint | Striped dump(1), non-striped dump(0) |
| Compressed | smallint | Compressed(1), uncompressed(0) |
| Sequence | varchar(6) | Position of the dump in the volume |
| Volume | varchar(6) | Volume ID |
| Devicetype | smallint | Disk(2), Floppy(3), Tape(5) or Pipe(6) |
| Table | varchar(30) | Reserved for future use |
| Dumpsize | varchar(15) | Size of dump, in pages |
| Stripeset | varchar(2) | Number of devices in the stripeset |
| Stripesetname | varchar(30) | Stripeset ID, for future use |
| Curseq | char(13) | Current/old sequence number |
| Newseq | char(13) | New sequence number |
| CreationDate | char(15) | Creation date (Shortmonth DD, YY) |
| CreationTime | char(15) | Creation time (HH:MM) |
| ExpireDate | char(15) | Expiration date for the volume (Shortmonth DD, YY) |
Note For any dump, only the appropriate columns will contain a value. All other columns will be NULL.