Identifying those tables with 'Not Logged Initially'

[bwmiller16]

Folks -

DB2 FP9 on Linux AS 4.

We are running PeopleSoft which has every table generated with "Not
Logged Initially". Fine.

But we need to know if Peoplesoft has manually run the 'Activated Not
Logged Initially" statement.

IBM, is this available in any of the SYS tables?

-B

[Ian]

bw********@yahoo.com wrote:

Folks -

DB2 FP9 on Linux AS 4.

We are running PeopleSoft which has every table generated with "Not
Logged Initially". Fine.

But we need to know if Peoplesoft has manually run the 'Activated Not
Logged Initially" statement.

It used to be (in V7) that you had to create a table with the 'NOT
LOGGED INITIALLY' option in order to use 'ALTER TABLE ... ACTIVATE
NOT LOGGED INITIALLY'.

However, V8 removed this restriction -- you can disable logging on
any table, whether you specified 'not logged initially' during create
or not.

[Pierre Saint-Jacques]

The only way I know of would be if you were running the DB2AUDIT facility at
the time the application issued the ALTER .. ACTIVATE ....
The activation is dine within the appl. and the either the audit facility
would catch that or an EVENT MONITOR for statements would. The last option
would assume that the event monitor is autostart and tracks all statements
(costly !!!).
Hope this helps , Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<bw********@yahoo.coma écrit dans le message de news:
11**********************@8g2000cwh.googlegroups.co m...

Folks -

DB2 FP9 on Linux AS 4.

We are running PeopleSoft which has every table generated with "Not
Logged Initially". Fine.

But we need to know if Peoplesoft has manually run the 'Activated Not
Logged Initially" statement.

IBM, is this available in any of the SYS tables?

-B