How do I ensure that a particular dbspace contains particular tables. I tried select statements in the sysmaster tables, but i don't know which sysmaster table will contain all these information. Your help will be greatly appreciated. Thank you.

Hi,

You can use the following query:

select DBINFO("DBSPACE",partnum),
dbsname,
tabname,
pe_phys,
pe_size
from sysptnext, systabnames
where pe_partnum = partnum
order by 1

where DBSPACE is the name the dbspace on which you want to run the query.

Bye

Nitin

Hi,

You can use the following query:

select DBINFO("DBSPACE",partnum),
dbsname,
tabname,
pe_phys,
pe_size
from sysptnext, systabnames
where pe_partnum = partnum
order by 1

where DBSPACE is the name the dbspace on which you want to run the query.

Bye

Nitin

Thanks Nitin. It was a great help.