Restoring journal receivers

575 pts.
Tags:
AS/400 database
AS/400 errors
AS/400 journaling
A search400 reader wrote in with this question: A situation has come up in our shop where we need to restore the QAUDJRN receivers from the production box to the test box (due to storage limitations and the large size and number of the receivers to be restored). We ran the following command: RSTOBJ OBJ(AUDRCV*) SAVLIB(##AUDITRCV) DEV(TAPxx) ENDOPT(*LEAVE) RSTLIB(MYLIB) The library on the prod box is in ASP1, while the library we wanted to restore the receivers to on test is in ASP2. The following messages appeared in the job log for each receiver: Message . . . . : JRNRCV AUDRCVxxxx restored to ASP 2. Cause . . . . . : The object was saved from auxiliary storage pool (ASP) 1. However, when the object was restored, library MYLIB existed in ASP 2. When a library exists in a user ASP, all objects in that library must be in the same ASP. When I looked for the journal receivers, they are not there. They're not anywhere. Where did they go? How can we restore the journal receivers?

Answer Wiki

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

Hi,

If you’re able to, rename the library with the objects and then create a library with the original name in ASP 1, move all the objects to this new library, delete the renamed (now empty) library and try the restore again.

Not a nice way to do this, but it should work. This is one of the reasons I don’t recommend using ASPs.

Regards,

Martin Gilbert.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    This is one of the reasons I don't recommend using ASPs. Would you also recommend not using packed-decimal variables since they can get decimal data errors? The solution is simply to restore to the same ASP number in this case. Restore to the system ASP because that's where the receivers were saved from. However, this problem might be more complex if QAUDJRN receivers are maintained in a user ASP on TEST but the system ASP on PROD. Best audit journal performance can come from receivers in a dedicated user ASP. Tom
    125,585 pointsBadges:
    report
  • danmd5systemad
    Sir Tom : I tried to restore previously saved journal receivers from tape to the same Library where it came from ( e.g. SBSPENV library --> TELJRN journal--> TELJRNRCV...TELJRNxxx receivers). From what i have observed, i'm able to restore previous journal receivers to the library but after a short time, the restored journal receivers are deleted by the system without my intervention. Why is this so? Is there a way to preserve these restored journal receivers? Thanks.
    370 pointsBadges:
    report
  • TomLiotta
    ...after a short time, the restored journal receivers are deleted by the system without my intervention. Why is this so? One reasonable possibility is that the journal was created with MNGRCV(*SYSTEM) DLTRCV(*YES) specified. If the journal is set to be managed automatically by the *SYSTEM and new receivers have been created, the system can delete receivers that have been saved. Other possibilities exist. This is different enough from the original question that it should be explored in a new question that you create. Tom
    125,585 pointsBadges:
    report
  • chalenger
    If you are runing Mimiex/ha1 which contains Jrn. Manger , stop it before the restore...
    455 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following