Sequences in DB2

CREATE SEQUENCE myseq AS INTEGER START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE NO CYCLE CACHE 10 ORDER

ALTER SEQUENCE myseq RESTART WITH 2 INCREMENT BY 3 MAXVALUE 33 CYCLE CACHE 12 ORDER

GRANT USAGE ON SEQUENCE myseq TO USER myuser;

http://www.ibm.com/developerworks/db2/library/techarticle/0205pilaka/0205pilaka2.html