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.