RGZPFM and journaling

[Vepr]

Hi!
I try to look help but find nothing.
How RGZPFM affects journal while running?

[DeadManWalks]

Re: RGZPFM and journaling

I belive it has little effect, but just create a test file , journal it, fill it will a few records and then do a RgzPfm and see what happens.

Good luck.

[K2r400]

Re: RGZPFM and journaling

Be careful don't use CLRPFM or RGZPFM with journaling.
After, no possibility to do a RMVJRNCHG or APYJRNCHG.
Otherwise, back up at once the file after.

[iseriescobol]

Re: RGZPFM and journaling

RGZPFM will create a Database File Member journal entry: Journal Code = F, and Entry Type = RG. The same for CLRPFM, but with an Entry Type = CR. For those running on V5R3 or above, an SQL DELETE with no WHERE clause will actually do a CLRPFM rather than delete each record seperately (there are a few exceptions). I am assuming that the original post was talking about Record level journalling, but I wanted to put this info out also.

I got burned on this. I was trying to figure out who cleared my file, and I mistakenly was looking at the record level journal entries, and was not finding anything. Then I realized that it was in the file member journal entries.

Good Luck,
iSeriesCOBOL

https://www.iseries-cobol.com

[Vepr]

Re: RGZPFM and journaling

Thanks for all!
I have one more question.
How mimix will act while running RGZPFM?
(I have database replication on my files.)

[arrow483]

Re: RGZPFM and journaling

Generally, MIMIX will need to resych the entire file. So will Echo2, although these vendors have been getting better at this.

[gcraill]

Re: RGZPFM and journaling

My understanding was that MIMIX will replicate the CLRPFM command which then runs on the remote system, thereby not requiring millions of record level deletes to be replicated.

If an SQL (DELETE FROM Filename) actually does a CLRPFM then I guess this would replicate the same way ???

GC

[arrow483]

Re: RGZPFM and journaling

I used both MIMIX and Echo2. The CLRPFM was never a problem. I did have re-synch's when RGZPFM was run. I did have Echo2 handling this automatically, but I could see re-sychs of some sort going on.

[Vepr]

Re: RGZPFM and journaling

Thanks for all!
I run RGZPFM on my largest files and as i can see most of time take "rebuilding access path" for LF and i didn't see re-synch's. May be in MIMIX 4.4. it realy run RGZPFM on both systems.