pdb_skip

Syntax

pdb_skip_op [
 { 
   add , { locator | { scn, thread, rba | lsn } } 
 |  
   remove, { all | locator | { scn, thread, rba | lsn } }
 } 
]

Parameters

add – Adds a specified ID to the list of identifiers of records to skip.
remove – Removes a specified ID from the list of identifiers to skip.
locator – The locator keyword from the list of LTM locators to identify the operations to skip.
scn – (For Oracle) The system change number (SCN) keyword identifies a specified log record to skip.
thread – (For Oracle) The thread keyword of the redo log thread of the operation to skip.
rba – (For Oracle) The record byte address (RBA) keyword of the log record to skip.
lsn – (For UDB) The system change number (LSN) keyword of the log record to skip.
all – Allows you to add or remove all IDs in the list of identifiers to skip.

Examples

Example 1 –
```
pdb_skip_op
```
This command with no parameters returns a list of the identifiers for the records you want to skip.
Example 2 –
```
pdb_skip_op add, id
```
This command adds an ID to the list of identifiers you want to skip.
Example 3 –
```
pdb_skip_op remove, id
```
This command removes an ID from the list of identifiers you want to skip.
Example 4 –
```
pdb_skip_op remove, all
```
This command removes all the IDs on the list of identifiers you want to skip.
Example 5 –
```
pdb_skip_op add, locator
```
This command adds an operation, referred to by its location, to the list of identifiers that you want to skip.

Usage

The pdb_skip_op command allows you to skip problem records, thereby avoiding having to reinitialize Replication Agent.
Skipped records are written to the system log as a warning message.
The pdb_skip_op command is valid when Replication Agent is in Admin or Replication Down state.
The format of the identifier is database specific:
- For Microsoft SQL Server, the identifier is the RBA and it has the following form:
```
virtualfileseqno:pageid:operationsseqno
```
  where:
  - virtualfileseqno is the virtual log sequence number (LSN).
  - pageid is the page number.
  - operationsseqno is the sequence number of the operation.
  You can get the LSN using the Microsoft SQL Server DBCC command, or you can parse it from the locator. For example:
  - LSN in decimal format:
    489:112:27
  - LSN in hexadecimal format:
    0x00000489:00000112:0027
- For Oracle, the identifier contains the system change number (SCN), redo log thread, and record byte address (RBA). It has the following form:
```
wrap.base.sub, thread, lsn.blknum.blkoffset
```
  where:
  - wrap is the SCN wrap number.
  - base is the SCN base number.
  - sub is the SCN subindex.
  - thread is the redo log thread number that the operation occurred on.
  - lsn is the RBA log sequence number.
  - blknum is the RBA block number.
  - blkoffset is the RBA offset into the block where this record resides.
  The values must be specified in the pdb_skip_op command together, as shown above, enclosed in quotes, with each item separated by a period.
  
  For example:
```
‘0000.012345678.00’, ’1’, ’0012.0000444.0000123’
```
  All values can be described as hexadecimal by prefixing the identifier with an “0x” as follows:
```
‘0x000c.00001bc.000007b’
```
  or:
```
‘0x000.00BC614E’
```