You can alter a sequence alias to specify a different target sequence,
or sequence on which the alias is defined.
About this task
Restriction: The target sequence cannot be any of the following items:
An existing sequence alias
A sequence generated for an identity column
A sequence generated for a DOCID column
Procedure
To alter a sequence alias:
On the DB2 Administration Menu
(ADB2) panel, specify option 1, and press
Enter.
On the System Catalog
(ADB21) panel, specify any selection criteria at the bottom,
specify option Q, and press Enter.
On the Sequence Objects
(ADB21Q) panel, specify ALT against the
alias that you want to alter, and press Enter.
Tip: To filter the list to display only aliases, type
A in the search argument area in the
T column, and press Enter.
Figure 1. Sequence Objects
(ADB21Q) panel
ADB21Q in L7BB Sequence Objects Row 256 from 502
Command ===> Scroll ===> PAGE
Commands: GRANT
Line commands:
A - Auth CRE - Create AL - Alter GR - Grant DROP - Drop DDL - Object DDL
IDC - Identity columns GEN - Generate DDL F - Functions J - Triggers
? - Show all line commands
Sel Schema Name Owner T C Start value
* * * A * *
----- -------> ----------------- -------- - - --------------------------------
SYSPUBLI EBPAL TS5794 A N 0
TS5781 ALIAS000 TS6061 A N 0
ALT TS5775A PJOBALSQ TS5775A A N 0
TS5775A PJALTST TS5775A A N 0
TS5775A PJSEQALCM TS5775A A N 0
TS5772 S2213SEQALIAS TS5772 A N 0
TS5775A PJALSEQ2 TS5775A A N 0
SYSPUBLI PJALSEQ2 TS5775A A N 0
SYSPUBLI ALONSEQ TS5774A A N 0
SYSPUBLI PJALSSEQ3 TS5775A A N 0
TS5775A PJSEQALCM2 TS5775A A N 0
TS5816 TUJSEQ1_ALIAS TS5816 A N 0
******************************* END OF DB2 DATA *******************************
On the Redefine Sequence Alias
(ADBP7QAL) panel, specify a different target sequence under
FOR SEQUENCE:
Figure 2. Redefine Sequence Alias
(ADBP7QAL) panel
ADBP7QAL ------------- L7BB Redefine Sequence Alias ------
Command ===>
Commands: NEXT
Redefine ALIAS
Schema . . . : TS5775A
Name . . . . : PJOBALSQ
FOR SEQUENCE
Schema . . . . TS5775A > (? to look up)
Name . . . . . PJOBSQ > (? to look up)
Specify NEXT, and press Enter.
The Alter Objects
(ADB27CA) panel is displayed. Notice that the
Ty column for your object indicates the type is SA
for sequence alias.
ADB27CA ------------------------ L7BB Alter Objects ---------- Row 1 to 1 of 1
Command ===> Scroll ===> PAGE
Commands: NEXT - Generate jobs ADD - Add objects
ALTOPT - Change alter options
Line commands:
A - Alter object D - Delete S - Select object REL - Alter related
FK - Add FK-affected tables RI - Add RI-related tables E - Edit view DDL
? - Show all line commands
Object Object RI RI FK
Sel Qual Name Ty Info 1 Info 2 Rels Add Add Operation
* * * * * * * * *
--- -------> -----------------> -- -------> -------> ------ --- --- -----------
TS5775A PJOBALSQ SA TS5775A PJOBSQ NA NA MODIFY
******************************* END OF DB2 DATA *******************************
