IY93094: INSTANCE MIGHT TRAP WITH "DTS MISMATCH: SEQUENCE REQUEST:" DURING CONCURRENT ALTER/DROP OF SEQUENCE AND SEQUENCE USE.

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• An Instance may trap with "DTS mismatch: Sequence Request:"
  during concurrent ALTER/DROP of sequence and sequence use.
  
  Additional recovery information after an DB2 Instance trap:
  
  If the SQL sequence object, which was causing the DB2 trap with
  the ALTER/DROP statement, has dependant objects (for example it
  may be referenced by an SQL trigger) - then the following
  procedure to re-create the SQL objects may be necessary:
  
  re-start the instance
  quiesce instance # to gain exclusive access to the instance
                   # (optional)
  drop dependant triggers
  drop sequence
  recreate sequence
  recreate triggers
  unquiesce instance # restore user access (optional)
  retry the application
  
  This will avoid subsequent DB2 traps when referencing the
  trigger object via SQL.
  

Local fix

• Do not alter / drop a sequence while using it.
  

Problem summary

• An Instance may trap with "DTS mismatch: Sequence Request:"
  during concurrent ALTER/DROP of sequence and sequence use.
  

Problem conclusion

• Problem was first fixed in Version 8.1 FixPak 15 (s070720).
  

Temporary fix

• Do not alter / drop a sequence while using it.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IY93108

Fix information

• Fixed component name

  DB2 UDB WSUE SO

• Fixed component ID

  5765F4302

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP