Fixes are available
DB2 Version 9.1 Fix Pack 7 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11 for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12 for Linux, UNIX and Windows
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