The number of pages locked by table or table space and page locking is show for two types of table space: simple and segmented.
For simple table spaces, table space locking is used. A lock on any table applies to every table in the table space. A page lock applies to data from every table on the page.
For segmented table space, table locking is used. A lock on any table only applies to pages that contain data from that table. Therefore, two can hold locks on separate tables within the same table space. Data from separate tables is stored in separate segments, meaning that any page lock applies only to data from a single table.