OBID assignments in DB2greenspun.com : LUSENET : DBAzine : One Thread
I think I understand what is happening - I just want to be sure. I am creating a database for testing that will contain a large number (20k+) of objects. The OBID column is smallint - therefore limited to 32,765. But the OBID number is also assigned to PSID in the TABLESPACE table and the ISOBID in the INDEXES table. Is there a single reference point for the next available OBID? Or does each table need to be queried for the MAX(OBID) value present?
-- Bob Wood (firstname.lastname@example.org), November 18, 2003