Page 1 of 1

fetching information about tablespace/database for a user

PostPosted: Mon Oct 18, 2010 12:26 pm
by jaggz
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.

Re: fetching information about tablespace/database for a user

PostPosted: Mon Oct 18, 2010 12:47 pm
by GuyC
In sysibm.systables you can find in which db.ts tables with creator = 'XXXXXX' are located

other than that and authorization, I can not think of a relation user ~ db.ts