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

Products

• 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

Environment

Release : ALL

Component : AUTOMATION ENGINE

Cause

As designed.

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.