ACCOUNT-RESTORE

Restores one or more accounts from an ACCOUNT-SAVE or a FILE-SAVE tape.

Note

To restore a whole database from a file-save tape, use an asterisk (*) to specify all accounts and the O option to overwrite existing files and items.

Caution

When migrating data from a Reality system, you must carry out a FILE-SAVE of the migrated database as soon as possible after the migration procedures on the restored database are completed. Similarly, when resizing a database you must carry out a FILE-SAVE as soon as possible after the resized database has been restored. In each case, this allows the modified database to be recovered quickly in the event of a system crash, otherwise migration procedures / resizing will need to be repeated.

Command Class

TCL-I command.

Syntax

ACCOUNT-RESTORE {[account-names||*]} {(options}

or

ACCOUNT-RESTORE new-account-names (C{options}

Syntax Elements

account-names One or more names of accounts to be restored from tape. Multiple account names must be separated by spaces. If restoring from an M-A-S tape, you can only restore the account at the current tape position.

* Specifies that all accounts are to be restored.

new-account-names
The new names under which accounts are to be restored when invoking the C option. The account names given here must not exist already on the system.

Note

A list of account names can be provided by an immediately preceding List Generating statement - in this case, account-names must be omitted. If no account names are specified, but there is no list, the first account on the tape is loaded, provided this does not already exist in the database.

Options

A Specifies that files for which reallocation parameters have been specified should not be configured for automatic sizing.

C Specifies that you want to rename the account(s) restored.

In this case the new account names required must be entered with the ACCOUNT-RESTORE command. You are prompted:

NAMES ON TAPE?

If more than one account is to be restored, names should be separated by single spaces and be entered in a corresponding sequence to those entered in the ACCOUNT-RESTORE command.

E If restoring with automatic file sizing active, expand the restored files as necessary. Without this option, the files will be configured for automatic sizing, but will not be expanded.

Without this option, the restore will complete more quickly, but the files concerned will take some time to reach their optimum modulo. You should use this option if it is important that the files are correctly sized.

F Must be specified for tapes with a density of 6250 bpi. It sets the tape speed to 50 ips.

K Specifies that any reallocation parameters specified should not be cleared in the restored account and files.

L Specifies that, if Transaction Logging is running, all DL-pointers restored by ACCOUNT-RESTORE are to be logged as updates to the database. Normally, restored items are not logged.

O Overwrites all existing files and items in the account(s) with those on tape of the same name. New files and items on tape are added and existing database files and items not on the tape remain unchanged.

Caution

Before using the O option ensure that you fully understand its effect on your database. Use of this option without understanding, may result in corruption and loss of data.

As the O option does not remove new items created after the save was taken, to preserve database consistency it may be necessary to clear the database before the restore, using mkdbase -r. However, if it is desirable to retain new items, or the new items may be updated by the subsequent restore of a clean log, the remaking of the database is not required.

P Prints a list of files restored instead of displaying it.

R Suppresses file resizing (as otherwise directed by D-pointer attribute 13 values).

U Upgrade option. See Caution below.

Note

If a REMFS account appears on the database after executing ACCOUNT-RESTORE * (U), it must be deleted, as it is not required from Release 4.0 onwards.

Caution

The U option should ONLY be used by NEC Software Solutions support personnel who understand its operation. It is ONLY intended for use during a Reality upgrade procedure and should not be used otherwise. Do not attempt to use this option for normal account restore as this may result in an inconsistent and unpredictable database.

W Specifies that the save is from a case-insensitive database.

Notes

  • If the save was created using FILE-SAVE or F-S, the saved SYSTEM file is used to determine the case-sensitivity; the W option is ignored.

  • You should use this option when loading a save from a D3 database.

Note

Additional options are available for use when restoring saves from other MultiValue systems. See MultiValue Compatibility for details.

Restrictions

SYSMAN and SYSPROG accounts only.

Comments

If automatic file sizing is active, unless you use the A option, each restored file will be configured for automatic sizing using, as the initial modulo, the previous modulo or that specified in the reallocation parameters. If automatic file sizing is not active, each file is restored with the same sizing mode as it was saved. Automatically sized files will not be expanded during the restore unless you specify the E option.

When an index is restored, it is always configured for automatic file sizing.

Unless the K option is specified, any reallocation parameters specified are cleared in the restored account and files.

If a single account is to be restored from a multiple tape set, the file statistics report can be used to select the appropriate tape.

When restoring an account or accounts saved from a Reality system or another release of Reality, the UPDATE-ACCOUNT procedure must be run, then you must recompile and catalogue any programs. If the originating release is pre-7.0 Reality, change any DL/IDs.

If the data on the tape is encrypted, your REK file must contain the correct encryption keys to allow your users access. If transferring data from another database, you must load the keys (using the LOAD-REK command) before starting the restore. Refer to Copying Encrypted Data to another Host for more details.

Procedure

  1. Ensure that the tape is loaded, on-line and positioned at the beginning-of-tape (BOT) marker, and that you are logged onto SYSMAN or SYSPROG.

  2. Attach the tape unit using ASSIGN or T-ATT.

  3. If a dummy bootstrap is present (FILE-SAVE or equivalent) enter T-FWD.

  4. Read the tape label to ensure you have the correct save tape by entering T-RDLBL.

  5. If a dummy ABS section is present (FILE-SAVE or equivalent), or if an account list is present (M-A-S) enter T-FWD.

    The tape is now positioned at the files section. If you are restoring from an M-A-S tape you must T-FWD to the particular account(s) you want to restore.

  6. Now enter ACCOUNT-RESTORE with appropriate options to restore one or more accounts.

    To restore a complete database from a FILE-SAVE (or F-S) tape, use:

    ACCOUNT-RESTORE * (O

    This updates the complete database, including the System Dictionary.

    The account restore now proceeds and, when completed, the TCL prompt is returned. If required, it prompts for additional reels to be mounted.

  7. Finally detach the tape unit, using CLEAR-ASSIGN or T-DET, to allow other users to attach the tape unit.

Examples

The following examples show typical ACCOUNT-RESTORE procedures.

:ASSIGN =TAPE 1
[1021] DEVICE(S) TAPE 1 NOW ASSIGNED,
           RECORD SIZE = 8000       DENSITY = 1600
:T-FWD
[94] END OF FILE
:T-RDLBL
LABEL = FILE-SAVE]08:01:33  01 FEB 1990
:T-FWD
[94] END OF FILE
:ACCOUNT-RESTORE STATUS ACCP (C <--------- New account names

NAMES ON TAPE? STAT DCP <---------------- Accounts to be restored
LABEL = FILE-SAVE]08:01:33  01 FEB 1990
  STATUS 11949,17,1     
        .
        .
:CLEAR-ASSIGN
:

 

:ASSIGN =TAPE 1
[1021] DEVICE(S) TAPE 1 NOW ASSIGNED,
           RECORD SIZE = 8000       DENSITY = 1600
:T-RDLBL
LABEL = DOC.ACC]08:01:33 01 FEB 1990
:ACCOUNT-RESTORE (R
        STATUS 11137,17,1
        ERRORS 11154,1,1
        .
        .
:CLEAR-ASSIGN
: