1.19 How can I restore files from a tape which were saved from one group into another group? We are trying to restore our last month-end backup into a test database.

Log in to MANAGER.SYS (or another user ID with SM capability) and use:

:FILE tape;DEV=n
:RESTORE *TAPE; <fileset>; ACCOUNT=; GROUP=; CREATOR=; OLDDATE;KEEP

Only a user with SM capability can restore files from one account into a different account using the 'ACCOUNT=' directive. If you are restoring into the same account but a different group you can eliminate the ';ACCOUNT=' option. However, the user ID you are logged into must be in the specific account and have AM capability.

The 'CREATOR=' directive sets the creator of the files to an existing user ID in the account. In the case of IMAGE databases, this is considered the database creator. If you are restoring into the same account but simply a different group, you probably won't need this option, as the creator ID should already exist in the account. If indeed you are changing accounts, it is best to include this directive in the restore.

The 'KEEP' option says that if files by this name already exist in the target, do not overlay them with the copies from tape. So if you indeed want to replace these files, you'll need to eliminate the ";KEEP" option.

Note: Always use the KEEP option unless you are absolutely certain you want to overwrite existing files. I usually purge files first and then use the KEEP option to prevent any surprises.