Hi I want to find out the name of the database creator or owner.
One way I tried is following query

"SELECT grantee FROM syscat.dbauth WHERE grantor='SYSIBM' and dbadmauth='Y' "

But sometimes it returns more than one users.
So this query is not returing correct owners.

I found that sysibm.sysversions contains AUTHID column.
Is it the name of the database creator or owner?

Thanks,
Abhijit

Though I'm not 100% sure, looks like you are on the right track with SYSVERSIONS catalog table ...

I have checked over 15 databases which I have access over and they seem to be pointing towards your assumption

Cheers

Sathyaram

try select creator, name from sysibm.sysdatabase;
for version 6 MVS at least.

Hi,
could you please explain me what is "version 6 MVS".
I am working for DB2 UDB 6.1, 7.1 and 7.2.
Is it related to DB2 UDB or what ?

Please give me some pointer also if you have regarding this.

Thanks,
Abhijit

mmainguy has told about db2 on mainframe....