OGG z/OS: Altering Extracting Using EXTRBA Command Alters All The Checkpoints Leading To Data Loss (Doc ID 2259076.1)

Last updated on JULY 24, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.2 to 12.2.0.1.0 [Release 12.1 to 12.2]
IBM z/OS on System z

Symptoms

Problem Summary
---------------------------------------------------
ERROR: Invalid parameter specified for ALTER EXTRACT.

Problem Description
---------------------------------------------------
Unable to alter extract using LSN

Changes

EXTRACT EXTCUST Last Started 2015-05-01 10:19 Status STOPPED
Checkpoint Lag 00:00:00 (updated 1440:26:26 ago)
Log Read Checkpoint 2009-10-04 09:53:05.146926 LSN: 7C540001CEE187DB7C54

DB2 Transaction Log

Startup Checkpoint (starting position in the data source):
LSN: 7C540001CEE187DB7C54
Timestamp: 2009-10-04 09:53:05.146926

Recovery Checkpoint (position of oldest unprocessed transaction in the data
source):
LSN: 7C540001CEE187DB7C54
Timestamp: 2009-10-04 09:53:05.146926

Current Checkpoint (position of last record read in the data source):
LSN: 7C540001CEE187DB7C54
Timestamp: 2009-10-04 09:53:05.146926

GGSCI (SYSG3) 1> alter extcust, extrba 0x00B9F63d0000

EXTRACT EXTCUST Initialized 2015-06-30 10:54 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:05 ago)
Log Read Checkpoint First Record LSN: 0000000000B9F63D0000

Current Checkpoint Detail:

Read Checkpoint #1

DB2 Transaction Log

Startup Checkpoint (starting position in the data source):
LSN: 0000000000B9F63D0000
Timestamp: Not Available

Recovery Checkpoint (position of oldest unprocessed transaction in the data
source):
LSN: 0000000000B9F63D0000
Timestamp: Not Available

Current Checkpoint (position of last record read in the data source):
LSN: 0000000000B9F63D0000
Timestamp: Not Available

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms