Professional Web Applications Themes

DB2 - OS390: Identity Column Problem - IBM DB2

I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE' 'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips 1000 entries in the numbering scheme. Any suggestions will help....

  1. #1

    Default DB2 - OS390: Identity Column Problem

    I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    1000 entries in the numbering scheme. Any suggestions will help.
    Tom Hiscox Guest

  2. #2

    Default Re: DB2 - OS390: Identity Column Problem

    [email]thiscoxharleysvillegroup.com[/email] (Tom Hiscox) wrote in message news:<ec597d5a.0307080749.3d782fbposting.google.c om>...
    > I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    > 'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    > 1000 entries in the numbering scheme. Any suggestions will help.
    If you have a heavy-hitting transaction application, is it possible
    that transactions are getting rolled back and it just gives the
    appearance of skipping?

    For example, Txn 1 inserts a row with an ID of 1. Concurrently, Txn 2
    inserts a row with an ID of 2. For whatever reason Txn 1 gets rolled
    back but Txn 2 gets committed. So looking at the table it appears
    that 1 was skipped. If this happened on a much larger scale it could
    appear that larger intervals were being skipped.

    HTH,
    klh
    klh Guest

  3. #3

    Default Re: DB2 - OS390: Identity Column Problem

    Looks a bit strange indeed.
    Gaps are possible though when transactions are rolled back.
    Also an alter table can set the next allocated value.

    Vesna Martinovic wrote:
    >I have similar problem: When I load-replace table with identity column,
    >that column starts with 1000 + (maxvalue before load)
    >
    >Vesna
    >
    >Tom Hiscox wrote:
    >
    >
    >>I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    >>'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    >>1000 entries in the numbering scheme. Any suggestions will help.
    >>
    >>
    --
    Anton Versteeg
    IBM Netherlands


    Anton Versteeg Guest

  4. #4

    Default Re: DB2 - OS390: Identity Column Problem

    I have similar problem: When I load-replace table with identity column,
    that column starts with 1000 + (maxvalue before load)

    Vesna

    Tom Hiscox wrote:
    >
    > I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    > 'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    > 1000 entries in the numbering scheme. Any suggestions will help.
    Vesna Martinovic Guest

  5. #5

    Default Re: DB2 - OS390: Identity Column Problem

    I think load can reserve a range.

    PM


    "Vesna Martinovic" <dolenckombank.com> a écrit dans le message de news:
    [email]3F0DBCB8.39DE2A2kombank.com[/email]...
    > This happened when nobody else was working.
    > Mistery :)
    >
    > Vesna
    >
    > Anton Versteeg wrote:
    > >
    > > Looks a bit strange indeed.
    > > Gaps are possible though when transactions are rolled back.
    > > Also an alter table can set the next allocated value.
    > >
    > > Vesna Martinovic wrote:
    > >
    > > >I have similar problem: When I load-replace table with identity
    column,
    > > >that column starts with 1000 + (maxvalue before load)
    > > >
    > > >Vesna
    > > >
    > > >Tom Hiscox wrote:
    > > >
    > > >
    > > >>I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    > > >>'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    > > >>1000 entries in the numbering scheme. Any suggestions will help.
    > > >>
    > > >>
    > >
    > > --
    > > Anton Versteeg
    > > IBM Netherlands

    PM \(pm3iinc-nospam\) Guest

  6. #6

    Default Re: DB2 - OS390: Identity Column Problem

    This happened when nobody else was working.
    Mistery :)

    Vesna

    Anton Versteeg wrote:
    >
    > Looks a bit strange indeed.
    > Gaps are possible though when transactions are rolled back.
    > Also an alter table can set the next allocated value.
    >
    > Vesna Martinovic wrote:
    >
    > >I have similar problem: When I load-replace table with identity column,
    > >that column starts with 1000 + (maxvalue before load)
    > >
    > >Vesna
    > >
    > >Tom Hiscox wrote:
    > >
    > >
    > >>I have an identity column created as 'GENERATED BY DEFAULT' 'NO CACHE'
    > >>'START WITH 1' 'INCREMENT BY 1'. My problem is that at times it skips
    > >>1000 entries in the numbering scheme. Any suggestions will help.
    > >>
    > >>
    >
    > --
    > Anton Versteeg
    > IBM Netherlands
    Vesna Martinovic Guest

Similar Threads

  1. Datagrid column width problem.
    By msh1283 in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: August 1st, 05:27 PM
  2. machine.config process identity problem
    By Allen Davis in forum ASP.NET Security
    Replies: 0
    Last Post: July 29th, 08:27 PM
  3. SQL Server IDENTITY Problem
    By SStory in forum ASP.NET General
    Replies: 1
    Last Post: July 31st, 01:17 PM
  4. checkbox column in a datagrid problem
    By Eric in forum ASP.NET
    Replies: 2
    Last Post: July 16th, 08:25 PM
  5. Problem with IDENTITY and ORDER BY in a INSERT statement
    By Steve Kass in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 2nd, 06:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139