OBID assignments in DB2 : 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 (, November 18, 2003

Moderation questions? read the FAQ