The PhysicalDesignContents relationship query returns the names of all DB2/390 tables, views, aliases, indexes, tablespaces, storage groups, bufferpools, and databases which are contained in the specified DB2/390 Physical Design. The query is sorted on the lastUpdate timestamp so you can find the objects which have changed most recently.
View type: DAQDB2390PhysicalDesign
Modifications:
The query uses a SQL UNION clause to provide a more compact and readable table. In order to change the search criteria, you must change it for each subselect statement in the UNION. Change the search criteria of the Physical Design name using the = (equals), IN or LIKE elements in the SQL WHERE clause.
In order to provide unique names, the PhysicalDesign name has the format <>RelationalDesignName:PhysicalDesignName<variation:revision>
To locate a Physical Design name used in multiple Relational Designs, use the LIKE clause with % after the first two angle brackets and before the colon.