Checking Whether the SSM Has the Snapshot of Interest

Before invoking the hotcopy command, you can check whether the snapshot you want to restore to is in the SSM’s snapshot store. For example, execute a select * statement on the database’s SYSTEM.SNAPSHOTS table. For each snapshot that is in the SSM’s snapshots directory, this table provides:

If the ID of the snapshot you need is not in the SYSTEM.SNAPSHOTS table then that snapshot has been removed. In other words, invoking the hotcopy command on the SSM cannot copy the required snapshot.