Hi,

I an interested in getting information regarding the path of data file containers.
The relevant version is 8.1.1 fixpack 4-14 for Unix.
The user i intend to use for this job cannot be member of the SYSMON/SYSCTL groups and can be given only read-only permissions.
How can i do that?

I've been struggling with this issue for quite a while now - could use help.

Thanks in advance,
-- Yaniv

try the table function SNAP_GET_CONTAINER

You need a SYSCTRL group permission for that (No SYSMON yet in this version). Another alternative is turning off authentication for snap tables.

both options are unfortunately unacceptable.

Any other way? workaround? hack?

Thanks

I don't say that this is the way to find it, but try

"find . -name *.dbf -print"

This will give you a list of the containers that exists on the server.

Anks

oops...

find / -name *.dbf -print

Anks