Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: SCHEMA level logging

    Team,,

    How to determine schema level logging.
    Our DW has 90 schemas.
    management needs to provide logging according to schema level.

    Is there any way?

    Thanks,
    R

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What do you mean by "schema level logging"? Also provide DB2 version and OS.

    Andy

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    Schemas

    DM1
    DM2
    DM3
    DM4

    Would like to know how much logs are generated by DM1 schema.

    V8.1 Fp9 Multi partition 64bit
    Linux Suse 64bit

    Thanks,
    R

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Are you talking about auditing? Or really log records (which DB2 uses internally to ensure the D in the ACID properties of transactions).
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2006
    Posts
    82
    Did you mean to say, When a user connects to DB2 he should be able to access the objects of one schema only..?
    Vinay,

Posting Permissions

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