Journaling if I drop a table

WendyB

95 pts.

Tags:

AS400 iseries

DB2/400

Hi Tom,

New to iSeries.

If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table?

I have this brief........

We need to have the old journal entries (relating to the current layout before the changes) removed as the journal extract procedure will crash if we extract journals containing entries

for different layouts.

After this the journaling will have to be re enabled with both images enabled.

Asked: May 2, 2012 10:35 AM Last updated: May 4, 2012 10:01 AM

Answer Wiki

Last updated: May 2, 2012 1:12 PM GMT

CharlieBrowne62,340 pts.
History
Contributors
- Ordered by most recent
- CharlieBrowne62,340 pts.

Thanks. We'll let you know when a new response is added.

When you do the DROP, you will need to end the jouirnalling since there will no longer be an object to journal.
When you do the CREATE, you will need to start the journalling again..
The old journal receivers can stay on the system if you need them.
You will be starting a new receiver when to do the STRJRN.
I am not sure what journal extract procedures you are asking about.
It this answer did not give you what you need, please give us more information on the extract.

Discuss This Question: 8 Replies

WendyB May 2, 2012 1:55 PM GMT

Thank you so much Charlie Brown. Do I also lose the permissions when I DROP the table?

95 pointsBadges:

report
philpl1jb May 2, 2012 7:35 PM GMT

Yes, you would loose the Object authorities. Have you thought about ALTER TABLE insetad of drop and create? Phil

54,090 pointsBadges:

report
TomLiotta May 2, 2012 10:30 PM GMT

If I drop and recreate a table with two additional fields, will the journalling be cleared out too? No. Also will the jounalling be enabled when I recreate the table? That depends on how journaling was set up previously. If this is a SQL schema, then it will probably be reenabled. Or if not a schema, then if the library was assigned a default journal, it will probably be reenabled. Otherwise, probably not. ...the journal extract procedure will crash if we extract journals containing entries for different layouts. Can you describe the "journal extract procedure" a little? That may have a significant impact. Tom

125,585 pointsBadges:

report
WendyB May 3, 2012 6:44 AM GMT

Hi Phil,Charlie and Tom The reason I did not use ALTER because I was led to believe that a DROP would sort out my journalling delema. Hence me coming to "the people in the know". The developers use a home written app to read the journal and did not want the rows with the OLD layout (excluding the two new columns) on the journal that they were reading.

95 pointsBadges:

report
TomLiotta May 4, 2012 0:29 AM GMT

The developers use a home written app to read the journal and did not want the rows with the OLD layout (excluding the two new columns) on the journal that they were reading. Yes, but can you describe it? For example, is it expected always to be running? Does it retrieve entries as they are being added to the journal? Or is it started each day (each week? each month?) so that it quickly grabs the latest journal entries and then quits? Whenever it is started, how does it know which entries to retrieve? Does it always start with the *CURRENT receiver? ...*CURCHAIN? ...an explicit receiver name? General info about its behavior could be useful in considering the process you should go through. Tom

125,585 pointsBadges:

report
philpl1jb May 4, 2012 1:11 AM GMT

The design of the Journal "reader" missed a critial design issue . Since it didn't allow for different versions of the files. That's little help at the moment but it's something to put on the list for a future enhancement. Phil

54,090 pointsBadges:

report
philpl1jb May 4, 2012 1:15 AM GMT

In fact, if it's a critical issue. The journal "reader" needs to be fixed first. Phil

54,090 pointsBadges:

report
WendyB May 4, 2012 10:01 AM GMT

Thank you once again everyone for the input, all is well and I learnt alot. Regards Wendy

95 pointsBadges:

report