By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,021 Members | 912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,021 IT Pros & Developers. It's quick & easy.

Identifying those tables with 'Not Logged Initially'

P: n/a
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

Feb 26 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.


Feb 27 '07 #2

P: n/a
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
Mar 2 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.