MAMisc - sequence.sas7bdat

[mb1008]

How does the sequence.sas7bdat file get incremented? Location of this file is LevN/Applications/SASCustomerIntelligence/CustomerIntelligenceCommon/Data/MAMisc/

I was under the impression that this file was incremented at the time of execution.  

During recovery should the objects in this be increased to avoid overlap in the SAS Common Data Model?

Should I obtain the max value from the SAS CDM?

[jpsm70]

Hello,

The increment value depends on the record type although most are incremented by one. There is a record type that is incremented by 20 as it is cached.

When are they incremented depends on the record type. For example, a cell_package_sk is incremented placed in the diagram and when execution happens.

Yes, the maximum + N (1, 10, 100, 1000, etc) is best to avoid constraint conflicts in the CDM.

[mbrannon]

In a DR situation, would it be best to increment by say 100 for each ?  Is there documentation for best practices in a DR situation?

Thanks.

[shill]

Bumping up by at least 100 should be fine, especially if you're on an older (<= 5.X) version. You could make a bigger jump on more recent releases.