fetching information about tablespace/database for a user



IBM's flagship relational database management system

fetching information about tablespace/database for a user

Postby jaggz » 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.
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times

Re: fetching information about tablespace/database for a user

Postby GuyC » Mon Oct 18, 2010 12:47 pm

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
I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post