IBM Support

LI73868: UPDATING A SEQUENCE MAY RESULT IN "SEQUENCE IS OVERFLOW RECORD -UNSUPPORTED" ERROR IN DB2DIAG.LOG AND TRAP.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If an existing sequence is modified, the updated system catalog
    record for it may end up as on overflow record resulting in the
    following error in the db2diag.log:
    
    2008-10-14-11.52.48.358357-240 I307592E409        LEVEL: Severe
    PID : 18459 TID : 183046793888PROC : db2agent (SAMPLE) 0
    INSTANCE: db2inst1             NODE : 000         DB   : SAMPLE
    APPHDL  : 0-94                 APPID:
    127.0.0.1.H785.081012101824
    AUTHID  : db2inst1
    FUNCTION: DB2 UDB, data management, sqldSeqFetch, probe:2
    MESSAGE : !! Sequence is overflow record - UNSUPPORTED !!
    
    This restriction has been removed in V95 and above and this APAR
    is open to backfit that change to V91.
    

Local fix

  • Drop and recreate the sequence with the changes that you wanted
    to update it to.
    

Problem summary

  • Users Affected: Any updating an existing sequence.
    Problem Description: If you modify an existing sequence and the
    updated record is an overflow record you can get a
    record unsupported error.
    Problem Summary: See above
    

Problem conclusion

  • Problem was first fixed in Version 9.1 FixPak 7
    

Temporary fix

  • Drop and then recreate the sequence with the changes you want.
    

Comments

APAR Information

  • APAR number

    LI73868

  • Reported component name

    DB2 EDE LINUX

  • Reported component ID

    5724N7604

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-10-28

  • Closed date

    2009-04-08

  • Last modified date

    2009-04-08

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

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

Fix information

  • Fixed component name

    DB2 EDE LINUX

  • Fixed component ID

    5724N7604

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021