Authority Question

2480 pts.
Tags:
*ALLOBJ
Anynet Support
AS/400 security
i5
iSeries
SAVRSTOBJ
We have 2 iSeries Servers. I have setup Anynet support. I am trying to give our DBA the ability to use the SAVRSTOBJ command, but I keep running into the fact that the DBA needs *ALLOBJ authority when Allow Object Differences *ALL is selected. Any words of wisedom, Thanks, Bill Poulin

Answer Wiki

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

Hi,

If you need to use ALWOBJDIF then you need *ALLOBJ – doesn’t matter which restore command you’re using this is related to ALWOBJDIF only.

Personally I don’t recommend using ALWOBJDIF(*ALL) – it can make quite a mess of your database – it renames existing objects instead of replacing them. You end up with lots of objects called xxxx000001, xxxx00002, etc.

Regards,

Martin Gilbert.

==========================================================

Note that if ALWOBJDIF() is actually needed, then you aren’t restoring the object that was saved. It simply isn’t possible that it’s the same object. In your particular case, you’ve already made it clear that these aren’t the same objects — you’re actually “copying” from one system to another but using save/restore to effect the copy.

From the command’s viewpoint, it balks because it has found a different object that has the same name. It demands that this kind of replacement without verification must be done with high authority.

You can’t expect a system to provide well defined save/restore capabilities while also simply allowing “mistakes” without question. High authority is a good thing if it protects an existing object.

Tom

Discuss This Question: 1  Reply

 
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
  • danmd5systemad
    Sir : In your reply above : "Personally I don't recommend using ALWOBJDIF(*ALL) - it can make quite a mess of your database - it renames existing objects instead of replacing them." , just to seek clarification, is it always the case that ALWOBJDIF(*ALL) only renames existing objects, because it has been my understanding all the while that the renaming only applies when the object concern is exactly the same as the copied object but if there are differences, it will completely replace the target object with the original version being restored.
    370 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