The CATALOG ONLY option displays the header information for the database, placing it in the .backup.syb file.
It does not restore any data, either from the catalog store or the IQ store.
When you specify CATALOG ONLY you must include the FROM archive_device clause, but omit the RENAME clause.
RESTORE DATABASE 'iqdemo.db' FROM '/disk1/users/jones/backup/iqdemo' CATALOG ONLY
generates the header:
RESTORE, -1988637423.0, bigendian_420111.db,
ASIQ, '2013-01-11
06:57:00.000', DBA, Full, Arch, bigendian_420111_backup, ''
BACKUP, 453495113.0, iqdemo.db, ASIQ, '2013-01-23 10:33:00.000', DBA,
Full, Arch, /disk1/users/jones/backupiqdemo, ''
RESTORE, 453496081.0, , ASIQ , '2013-01-23 10:33:00.000', DBA,
Full, Arch, /disk1/users/jones/backupiqdemoo,
''