Link to home
Start Free TrialLog in
Avatar of Michael
MichaelFlag for United States of America

asked on

Is there a RGZPFM option that will not update the previous or existing Relative Records Numbers (RRNs)?

Secondary replication tool is using Relative Record Numbers (RRN)s for table that do not have a PRIMARY (UNIQUE  ) index.  So, is there a RGZPFM option that will not update the previous or existing Relative Records Numbers (RRNs)?

Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

RGZPFM's main job is to physically reorganize the data in the file - by removing deleted rows, and optionally physically sorting the rows.  So, no there is no way to preserve RRN - and that is by design.  RRN's are not stored in the file, they are imputed by the position of the row in the file.  So if you remove a deleted row, it will change the RRN of every row that follows.

Here is a simplified view of what RGZPFM does:

RRN   Data
1         ABCDEF
2        (Deleted record)
3        XYZ123
4        (Deleted record)
EOF

After RGZPFM:

RRN   Data
1         ABCDEF
2        XYZ123
EOF

Typically to reorg a file under replication, you stop replication, reorg the file, then start replication back up for the file.  Generally this results in a full copy of the reorganized file being sent.  Specific process varies depending on the replication software, and is usually documented pretty clearly, or instructions for reorganizing a non-keyed file can be obtained from your replication vendor's tech support team.  

What replication software are you using?

Avatar of Michael

ASKER

Thanks, that was my conclusion also, but I did not consider that the RRN was not stored in the Table.  Relative means relative to the data currently in table,deleted or active rows.  Replication application is Attunity.  We have tables without a Primary (Unique) index, so Attunity uses RRN.
ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial