SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:30 AM
| ||||
| ||||
 Logging 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.      |
|
02-27-2008, 06:30 AM
| |||
| |||
| Re: Logging 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. |
|
02-27-2008, 06:31 AM
| |||
| |||
| Re: Logging 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 |
|
02-27-2008, 06:31 AM
| |||
| |||
| Re: Logging > > > 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 |
|
02-27-2008, 06:31 AM
| |||
| |||
| Re: Logging 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* |
|
02-27-2008, 06:31 AM
| ||||
| ||||
| Re: Logging 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." " |
Linear Mode
