Authority Question
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
Software/Hardware used:
Software/Hardware used:
ASKED:
February 10, 2009 7:56 PM
UPDATED:
May 18, 2011 10:15 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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.