fetching information about tablespace/database for a user
Posted: Mon Oct 18, 2010 12:26 pm
Hi folks,
Today i tried to view the tablespace and database for user using query "select * from sysibm.systablespace where name like xxxx ". Unluckily i could'nt fetch any information. Does anyone here has any idea to fetch both the information using a single sysibm.xxxxx tables.... I am sorry if not being more precise.
Today i tried to view the tablespace and database for user using query "select * from sysibm.systablespace where name like xxxx ". Unluckily i could'nt fetch any information. Does anyone here has any idea to fetch both the information using a single sysibm.xxxxx tables.... I am sorry if not being more precise.