please help

[malik280283]

hi
can any one tell how db2 picks up an particular column for a table
is there any identifier associated with table corresponding to column

[kazam]

The information about every database object is stored in system catalog tables. System catalog tables reside in SYSCATSPACE tablespace. whenever an object is referenced in queries or any other operation, DB2 checks for that object in system catalog tables first, if exists, it checks all other details like if permissions are there, etc and executes that operation/query.

[malik280283]

thanks for reply,
i want to know what id or identifier that makes a table to get its columns from large syscatspace , is it page reference to the column block or anything else .


thanks
& regards
malik280283