Big integer support

BIGINT is a new DB2 version 9.1 SQL datatype. Use BIGINT in a table when integer values for a column are too large to fit in an integer column value.

BIGINT is a binary integer and an exact numeric datatype, like SMALLINT and INTEGER. It has a precision of 63 bits.

Note Replication Agent for DB2 UDB sends the BIGINT value to Replication Server, which then passes the value to the target database for the replicated table. Because some databases may not support an integer value with the precision of BIGINT, some precision may be lost during replication.

See the IBM DB2 version 9.1 for z/OS documentation for more information.