467,118 Members | 1,027 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

How can I force DB2 to advance to next logical log?

aj
DB2 v8 FP5
Red Hat AS/EL 2.1

For disaster recovery purposes (I'm in FL), I am utilizing a custom
DB2 userexit to FTP logical logs to an alternate site in prep for a
potential restore and roll forward.

I am a former Informix DBA, and in Informix I could issue an
"onmode -l" (thats an "el") command to force the database to the
next logical log.

Is there such a command in DB2? How do I force DB2 to complete
the current logical log and go on to the next one?

Any help appreciated.

aj

Nov 12 '05 #1
  • viewed: 3907
Share:
1 Reply
I think a "db2 archive log for database db_name.." could resolve your
problem
"aj" <ro****@mcdonalds.com> a écrit dans le message de
news:10*************@news.supernews.com...
DB2 v8 FP5
Red Hat AS/EL 2.1

For disaster recovery purposes (I'm in FL), I am utilizing a custom
DB2 userexit to FTP logical logs to an alternate site in prep for a
potential restore and roll forward.

I am a former Informix DBA, and in Informix I could issue an
"onmode -l" (thats an "el") command to force the database to the
next logical log.

Is there such a command in DB2? How do I force DB2 to complete
the current logical log and go on to the next one?

Any help appreciated.

aj

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Rob Mayo | last post: by
1 post views Thread by Julie Barnet | last post: by
2 posts views Thread by Oenone | last post: by
20 posts views Thread by Jukka K. Korpela | last post: by
2 posts views Thread by dmc2409@yahoo.com | last post: by
11 posts views Thread by estantep@gmail.com | last post: by
54 posts views Thread by bearophileHUGS@lycos.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.