IBM Mainframe Forum

[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.

[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