Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unanswered: getting containers info for v8.1.1 fixpack 4-14

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    try the table function SNAP_GET_CONTAINER
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Oct 2007
    Posts
    2
    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

  4. #4
    Join Date
    Jul 2005
    Posts
    102
    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

  5. #5
    Join Date
    Jul 2005
    Posts
    102
    oops...

    find / -name *.dbf -print

    Anks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •