RECOVERY_UNITS

Information on recovery units for spaces. The current authorization identifier must have the UTILITY privilege for the database or must own the space.

Column name

Data type

Contents

SPACE_CATALOG

CHAR (18)

Database name

SPACE_NAME

CHAR (18)

Name of the space

RECOVERY_TIMESTAMP

TIMESTAMP (3)

Time of the recovery operation

VERSION

INTEGER

Internal number

if RECOVERY_TYPE is 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 is COPY

Internal number

if RECOVERY_TYPE is RESTART
or REST_TO

NULL value in all other cases

SPACE_OWNER

CHAR (18)

Authorization identifier that owns the
space

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 is 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 is 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

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

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

PBI_TIMESTAMP

TIMESTAMP (3)

Time at which the PBI file was generated

PBI_COUNTER

INTEGER

undefined

Table 81: RECOVERY_UNITS view of the INFORMATION_SCHEMA (section 3 of 3)