Logging

[shsandeep]

Q 1.
How do I come to know what type of logging has been enabled for a
particular database (circular/archival,etc.) ?

Q 2.
DataStage is loading data into the tables. A parameter has been set into
it to commit every 1000 rows. How to verify whether the commit is
happening every 1000 rows on the database side?

Thanks.

Cheers,
San.

[Ian]

shsandeep wrote:

Q 1.
How do I come to know what type of logging has been enabled for a
particular database (circular/archival,etc.) ?
Look at the LOGRETAIN database config parameter.
Q 2.
DataStage is loading data into the tables. A parameter has been set into
it to commit every 1000 rows. How to verify whether the commit is
happening every 1000 rows on the database side?

Look at an application snapshot for the datastage process that's writing
data and compare the number of commit statements to rows inserted. The
ratio should be pretty close to 1:1000.

[Bob [IBM]]

Ian wrote:

shsandeep wrote:

Q 1.
How do I come to know what type of logging has been enabled for a
particular database (circular/archival,etc.) ?

Look at the LOGRETAIN database config parameter.

Q 2.
DataStage is loading data into the tables. A parameter has been set into
it to commit every 1000 rows. How to verify whether the commit is
happening every 1000 rows on the database side?

Look at an application snapshot for the datastage process that's writing
data and compare the number of commit statements to rows inserted. The
ratio should be pretty close to 1:1000.

If I am not mistaken, archival logging can also be turned on with
USEREXIT = ON and I do not think in that case the log retain is set to
ON. Have no system to check at this time however.

Bob

[Peter Postlbauer]

> >

If I am not mistaken, archival logging can also be turned on with
USEREXIT = ON and I do not think in that case the log retain is set to
ON. Have no system to check at this time however.

Bob

First you have to turn on USEREXIT=ON then you can set LOG RETAIN = ON.
Per default userexit=off and circularlogging = on.
regards, peter

[Bob [IBM]]

Peter Postlbauer wrote:

If I am not mistaken, archival logging can also be turned on with
USEREXIT = ON and I do not think in that case the log retain is set to
ON. Have no system to check at this time however.

Bob

First you have to turn on USEREXIT=ON then you can set LOG RETAIN = ON.
Per default userexit=off and circularlogging = on.
regards, peter

Actually this is not correct -- turning USEREXIT =ON does in fact turn
on LOG RETAIN by default -- the switch does not show LOG RETAIN=RECOVERY
but as long as USEREXIT=ON LOGRETAIN=RECOVERY by default.

This is documented at : *http://tinyurl.com/bslng*

[Bob [IBM]]

Bob [IBM] wrote:

Peter Postlbauer wrote:

If I am not mistaken, archival logging can also be turned on with
USEREXIT = ON and I do not think in that case the log retain is set to
ON. Have no system to check at this time however.

Bob

First you have to turn on USEREXIT=ON then you can set LOG RETAIN = ON.
Per default userexit=off and circularlogging = on.
regards, peter

Actually this is not correct -- turning USEREXIT =ON does in fact turn
on LOG RETAIN by default -- the switch does not show LOG
RETAIN=RECOVERY but as long as USEREXIT=ON LOGRETAIN=RECOVERY by default.

This is documented at : *http://tinyurl.com/bslng*

Just an addendum as my link not work propery -- search for USEREXIT on
the online documentation and this is documented:

"If this parameter is enabled, log retention logging is performed
_regardless of how the logretain parameter is set_. This parameter also
indicates that a user exit program should be used to archive and
retrieve the log files. Log files are archived when the database manager
closes the log file. They are retrieved when the ROLLFORWARD utility
needs to use them to restore a database."
"