Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390
Basic Data
| Data Element | D2PIT_RBA |
| Short Description | Column PIT_RBA of table SYSIBM.SYSCOPY (DB2 on OS/390) |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | D2HEX_RBA | |
| Data Type | CHAR | Character String |
| Length | 20 | |
| Decimal Places | 0 | |
| Output Length | 20 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | PIT_RBA |
| Medium | 17 | Point in time RBA |
| Long | 39 | DB2 log point of point in time recovery |
| Heading | 12 | PIT |
Documentation
Description
When operation was partial recovery (ICTYPE=P), this column of the catalog table SYSIBM.SYSCOPY contains the LRSN for the point in the DB2 log. (The LRSN is the RBA in a non data-sharing-environment). For other types of operation, this column is X'000000000000'.
For partial recovery this column indicates the stop location of a point-in-time recovery. If a record contains the ICTYPE=P and PIT_RBA=X'000000000000', the copy pending status is active and a full image copy is required. If such a record is encountered during fallback processing of RECOVER, the recover job fails, and a point-in-time recovery is required. PIT_RBA can be zero if the point-in-time recovery is completed by the fallback processing of RECOVER, or if ICTYPE=P from a previous release of DB2.
For more information see the DB2 SQL Reference and the DB2 Administration Guide.
History
| Last changed by/on | SAP | 20141013 |
| SAP Release Created in |
