title: Auto increment in db2
body: <p>i have created a table which auto increments the id values starting with 100 with an increment of 100, but after 1000 and the next data is inserted it jumps to 2000, where it should be 1100.</p>
  
  <p>this is the syntax:  </p>
  
  <pre><code>create table student(  
  id int not null generated always as identity(start with 100, increment by 100),  
  name varchar(30),  
  primary key(id)  
  )
  </code></pre>