SYS_RECOVERY_UNITS

Information on recovery units.

Column name

Data type

Contents

SPACE_NAME

CHAR (18)

Name of the space

RECOVERY_TIMESTAMP

TIMESTAMP (3)

Time at which the backup was created

VERSION

INTEGER

Internal number

if RECOVERY_TYPE = 'COPY'

NULL value in all other cases

VALIDITY

VARCHAR (3)

YES	Recovery unit valid for recovery operations up to next recovery unit
NO	invalid (may however change to YES after a RECOVER statement)
NOT	invalid (cannot change)

RECOVERY_UNIT_NAME

VARCHAR (54)

File name of the copy

if RECOVERY_TYPE = 'COPY'

internal number,

RECOVERY_TYPE = 'RESTART'
or 'REST_TO'

NULL value in all other cases

ARCHIVE_COPY_VERSION

VARCHAR (15)

Time of ARCHIVE backup,

if MEDIUM = 'TAPE'

Time of HSMS backup,

if MEDIUM = 'HSMS', 'HSMW'
or 'HSMB'

NULL value in all other cases

MEDIUM

CHAR (4)

DISC	SESAM backup on disk
TAPE	SESAM backup with ARCHIVE
HSMW	SESAM backup with HSMS (work file)
HSMB	SESAM backup with HSMS (additional mirror unit)
SRDF	SESAM backup with HSMS (SRDF target)

if RECOVERY_TYPE = 'COPY'

NULL value in all other cases

RECOVERY_TYPE

VARCHAR (7)

Values evaluated by the recovery utility:
COPY
CREATE
RESTART
REST_TO (RESTART TO)
MARK

COPY_TYPE

VARCHAR (7)

ONLINE or OFFLINE

if RECOVERY_TYPE = 'COPY'

NULL value in all other cases

DALOG_VERSION

INTEGER

Version number of the
DA-LOG file

DA-LOG level
before the
recovery unit is
entered

DALOG_SUBNUMBER

INTEGER

Sequence number of
the DA-LOG file within
the version

DALOG_BLOCKNUMBER

INTEGER

First block in the DA-LOG

file for this DA-LOG unit

NEXT_DALOG_VERSION

INTEGER

Version number of the
DA-LOG file

DA-LOG level
after the
recovery unit is
entered

NEXT_DALOG_SUBNUMBER

INTEGER

Sequence number of
the DA-LOG file within
the version

NEXT_DALOG_BLOCKNUMBER

INTEGER

First block in the DA-
LOG file for this DA-
LOG unit

LOG_COUNTER

INTEGER

Not currently used

ARCHIVE_DIRECTORY_NAME

VARCHAR (54)

Name of the ARCHIVE directory,

if MEDIUM = 'TAPE'

Name of the HSMS archive,

if MEDIUM = 'HSMS', 'HSMW', 'HSMB' or 'SRDF'

NULL value in all other cases

ARCHIVE_PBI_VERSION

VARCHAR (15)

Time of ARCHIVE backup of the PBI file,

if MEDIUM = 'TAPE' and COPY_TYPE = 'ONLINE'

NULL value in all other cases

PBI_TIMESTAMP

TIMESTAMP (3)

Time at which the PBI file was generated

PBI_COUNTER

INTEGER

undefined

Table 122: SYS_RECOVERY_UNITS view of the SYS_INFO_SCHEMA (section 3 of 3)