How can i journal all my tables's schema in db2 iseries as/400?

Question

I have created using system i navigator a jounral called abc in schema called TEST.Now i want to journal all the tables in my schema called mySchema how can i do that.I can only journal only one table.Is there any script to journal all the tables at once.

thanks in advance

Answer 1

Find your journal then right click on it.

Choose start or end table journaling. You'll get this screen:

Find and add your tables. I believe you can Ctrl or Shift- click multiple tables at once.

Answer 2

If you created a "schema" with iSeries Navigator, then a journal will be created in the schema automatically and all tables created in that schema will be journaled automatically. Automatic journaling can also be set up for simple "libraries", in case you created a "library" rather than a "schema". See Automatically starting journaling for details. (For i 6.1 and later, also look at the STRJRNLIB command.)