Hi,

When we execute an SQL statement for example select * from emp.

How does DB2 know which data pages on disk has this table info? Is there any system table for to know this ?

Thanks in advance.

Thanks,
Panditt

I think you may want to read this: Table spaces and storage management - IBM DB2 9.7 for Linux, UNIX, and Windows