AWA: What is the system impact if a sequence reaches max value?

book

Article ID: 184091

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

After a long period of running, the DBA's may notice that your sequences are reaching maximum value:

SEQUENCE_OWNER
SEQUENCE_NAME
MIN_VALUE
MAX_VALUE
INCREMENT_BY
C
O
CACHE_SIZE
LAST_NUMBER
AUTOMIC
SQ_MQ1WP   
1
2147483647
1
Y
N
1000
2095940001

Cause

As designed.

Environment

Release : ALL

Component : AUTOMATION ENGINE

Resolution

If there have been no modifications, the sequence numbers will cycle back to the minimum (1) when reached. This can be confirmed by the CYCLE = Y above.

The only impact to the system would be if the MQ* table about to sequence has values that are 'stuck' near the threshold. Have your DBA confirm there are no MQ records for that table with a low primary key.