SCHEMA level logging

udbraja · #1 (**permalink**) 03-13-07, 14:15

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

ARWinner · #2 (**permalink**) 03-13-07, 17:01

What do you mean by "schema level logging"? Also provide DB2 version and OS.

Andy

udbraja · #3 (**permalink**) 03-13-07, 17:47

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

stolze · #4 (**permalink**) 03-14-07, 06:50

Are you talking about auditing? Or really log records (which DB2 uses internally to ensure the D in the ACID properties of transactions).

vini_srcna · #5 (**permalink**) 03-15-07, 01:57

Did you mean to say, When a user connects to DB2 he should be able to access the objects of one schema only..?

Internet Services

Web Development

Digital Marketing

Consumer Tech