OBID assignments in DB2

greenspun.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 (wouldi@sherbtel.net), November 18, 2003

Moderation questions? read the FAQ