TLOG-RESTORE Command

The TLOG-RESTORE command uses the taped output of transaction logging as input and restores transactions onto the existing database.

Format

TLOG-RESTORE [(options)]

Parameter(s)

options	The following options are supported:
	D	(Detail) Displays path and item-ID detail.
	F	(File level query mode) Displays this prompt at each file level transaction:
		^----- Process (Y,N,*,X)
		Any of these responses can be entered:
		Y	Restores all transactions to the file.
		N	Ignores the transaction; no transactions to the file are restored.
		*	Restores the transactions, then disables the F option. No further queries occur, and all subsequent transactions are restored automatically.
		X	Exits to TCL.
	R	(Redirection) Restores transactions to new accounts specified by items in the PATH-XREF file.
	S	(Selective restore.) Prompts you to define the criteria for restoring the data.
	X	(Index.) Displays file paths only. No updates to the database are performed. If the X option is used with the D option, both file paths and item-IDs display.

Description

As transactions are restored, the transaction numbers display on the screen. The account which TLOG-RESTORE is run from must have access to the LOCK-XREF, RESTORE-XREF, and PATH-XREF files, as well as to all data files where transactions are to be restored

Used with the R Option

The R option uses the PATH-XREF file as an old-to-new account index file. Items in the PATH-XREF file use old account names as item-IDs. Attribute 1 of each item contains the new account name. All new file references first attempt to translate the account-reference portion of the file path by using the old account name as an item-ID into the PATH-XREF file.

Once an item is found, transactions are restored to the new account listed in Attribute 1 of the item in PATH-XREF.

Used with the S Option

When the S option is used, this prompt displays:

Original ACCOUNT NAME [1]:

Type the name of one of the accounts whose transactions you want to restore. The prompt is then repeated.

Type as many account names as you like. To proceed to the next prompt, press ENTER.

If you did not enter an account name at the first prompt, this prompt displays:

FILE PATH (eg. A>B>C) [1]:

A is the account name, B is the file dictionary name, and C is the data file name (if there is one).

Type the pathname of one of the files whose transactions you want to restore. The prompt is then repeated. Type as many file pathnames as you like. To proceed to the next prompt, press ENTER.

This prompt displays:

Global TRANSACTION NUMBER:

Type the starting and ending numbers of the range of transactions you want to restore. To specify all transactions up to a certain number, press ENTER to input <not used> for the starting number, then type the ending number.

To specify all transactions starting from a certain number, type the starting number, then press ENTER to input <not used> for the ending number. To proceed to the next prompt, press ENTER.
This prompt displays:

PROCESS NUMBER:

Type the starting and ending numbers of the range of processes whose transactions you want to restore. To restore transactions of just one process, enter the starting number only and press ENTER for the ending number. Press ENTER again to proceed to the next prompt.

The final prompt displays:

TIME , DATE:

Type the starting and ending time and date of the range of transactions you want to restore. Separate TIME and DATE with a comma.
To specify all transactions up to a certain time-and-date, press ENTER to input <not used> for the starting number, then type the ending time-and-date.
To specify all transactions starting from a certain time-and-date, type the starting number, then press ENTER to input <not used> for the ending time-and-date. When you press the ENTER key again, the selected transactions are restored from backup medium.

Using TLOG-RESTORE in Query Mode

This example shows the kind of prompts that are shown when the F option of TLOG-RESTORE is used:

>TLOG-RESTORE (F)

BLOCK SIZE: 16896

SESSION LABEL:

L 4200 14:47:30 DD MMM YYYY TLOG 14 01

(14-00016511+) TEST

^--- PROCESS (Y,N,*,X) ? Y

14-00016942 CREATE-FILE : TEST > ONE

^--- PROCESS (Y,N,*,X) ? Y

(14-00016945+) TEST > ONE > ONE

^--- PROCESS (Y,N,*,X) ? N

14-00017098 CREATE-FILE : TEST > TWO

^--- PROCESS (Y,N,*,X) ? Y

(14-00017099+) TEST > TWO

^--- PROCESS (Y,N,*,X) ? X

[378] TRANSACTION RESTORE 'TERMINATED'.

Restoring Transactions Selectively

These two examples show two different selective transaction restorations. During selective restoration the message <not used> displays if the user presses the ENTER key at any of the prompts.

In the first example, the user specifies account names, so no file paths are prompted for:

>TLOG-RESTORE (S)

*------------------------ TLOG RESTORE "SELECT" CRITERIA -------------------*

Original ACCOUNT NAME [1]: SYSPROG

Original ACCOUNT NAME [2]: TEST

Original ACCOUNT NAME [3]:<ENTER>

*--- starting --- *--- ending ---*

Global TRANSACTION NUMBER: 16514 17123

PROCESS NUMBER: 10 12

TIME , DATE: 14:22,MMM DD YY 18:12,MMM DD YY

*------------------------------------------------------------------------------------------------*

BLOCK SIZE: 16896

SESSION LABEL:<ENTER>

[378] TRANSACTION RESTORE 'TERMINATED'.

In the next example, selective restoration does not specify an ACCOUNT-NAME, so that FILE-PATHs are prompted for:

>TLOG-RESTORE (S)

*------------------------ TLOG RESTORE "SELECT" CRITERIA ------------------*

Original ACCOUNT NAME [1]: < not used >

FILE PATH (eg. A>B>C) [1]: SYSPROG>BP>BP

FILE PATH (eg. A>B>C) [2]: SYSPROG>FILE.ONE

FILE PATH (eg. A>B>C) [3]:

*--- starting ---* *--- ending ---*

Global TRANSACTION NUMBER: < not used > < not used >

PROCESS NUMBER: 10 < not used >

TIME , DATE: < not used > 10:05,MM/DD/YY

*------------------------------------------------------------------------------------------------*

BLOCK SIZE: 16896

SESSION LABEL:

[378] TRANSACTION RESTORE 'TERMINATED'.