Copying journal and receivers to a different server and performing WRKJRNA and DSPJRN

[v_sriram]

Hello Everyone,

I'm trying to test an incremental data migration tool in a test server. Unfortunately, I am unable to produce enough data in the test server as such to perform any form of load testing. Instead, I thought of copying the journal and its receivers from the production box into the test server and producing the incremental load out of it. I am not loading the receiver data onto any of the files so there is no need for APYJRNCHG or anything. Just need to be able to fetch the list of receivers from WRKJRNA and also be able to fetch the receiver data and dump it into a file using DSPJRN. Both these commands are a part of my code.

I need to know whether its possible and what would be the prerequisites to copy the journal and receivers without the journaled files. Putting them into a save file and FTPing it to the test box is the easy part. But then I need to be able to perform a RSTOBJ on the test box to put them somewhere. I do remember faintly that they will need to be placed into a library with the same name as the Production library. I guess, there would be a bit of an extra challenge when dealing with the ATTACHED receiver as well, as it will need to stay in the same state (ATTACHED!) when moved to the test box.

Following this, I need to be able to fetch the receiver list (WRKJRNA) and the receiver data (DSPJRN) on the journal and its receivers into a dump file.

Appreciate your time.

Thanks.

[gcraill]

Re: Copying journal and receivers to a different server and performing WRKJRNA and DS

Have a look into remote journaling, it will send the receivers to the target system without the files.

[v_sriram]

Re: Copying journal and receivers to a different server and performing WRKJRNA and DS

Have a look into remote journaling, it will send the receivers to the target system without the files.

Thanks Greg. I've tried remote journalling already. The only problem with this one is that the TCP connection is taken out every evening for one hour. Essentially the remote journal will get disconnected then, so I would have to setup a program (Prog1 lets say) to record the attached receiver name just before the down time and then restart remote journalling after the outage with the same receiver. Meanwhile in the test box, I will also need delete the incomplete version of the attached receiver (I may be wrong, sorry) on the target box.

Since we are talking about a production box here that needs remote journalling (Source system), it would be kinda' complicated to put the program (Prog1) in place.

Regards.

[DeadManWalks]

Re: Copying journal and receivers to a different server and performing WRKJRNA and DS

I vote to ask to not have the TCP brought down.

[gcraill]

Re: Copying journal and receivers to a different server and performing WRKJRNA and DS

It should catch up the remote journaling after TCP is back up (DMW has my vote also though to keep it up)

It does with us after outages ... should be same same all shops on that score

[v_sriram]

Re: Copying journal and receivers to a different server and performing WRKJRNA and DS

I will try this out and share the results. Thanks!

Meanwhile, I had one more question:-
I have the remote journal in place in the target box and I will be performing DSPJRN on this. The only catch is that I will need to specify the file names when running the command and I keep getting CPF7006 - Member *FIRST doesn't exist. This I know is because the JID of the files on the target system doesn't match that on the source system. Is there a way around this or would it have to be *ALL always? More specifically, Is there a way I can use DSPJRN on specific files on a remote journal where the journalled objects may not exist?

Thanks.