Resolving Errors Due to Lack of *ALLOBJ and *JOBCTL Authority

By default the Installation program grants *JOBCTL authority to the ONEWORLD user profile. You may have a temporary requirement to grant *ALLOBJ authority to ONEWORLD. This could be required if ONEWORLD needs to start journaling on a table but does not have OBJMGT rights to that table. For example, when submitting a UBE to the server for the first time, ONEWORLD needs to start journaling on F986111. Symptoms of this problem are errors indicating a transaction was cancelled because a commit cycle could not be start.

Of the multiple ways to grant the *ALLOBJ authority to ONEWORLD, the simplest is to give ONEWORLD rights to all tables using the SETOWAUT tool. Alternatively, you could run the GRTOBJAUT command to give ONEWORLD OBJMGT authority of to all tables in your business data, system, and server map libraries. Note that either method causes locks to be put on tables, which could interfere with other users on your system. In order to avoid that potential interference caused by locks, it may be preferable to temporarily grant *ALLOBJ authority to ONEWORLD, which you can revoke after a short while.

To grant *ALLOBJ authority, from a green screen enter the following command:

CHGUSRPRF USRPRF(ONEWORLD) SPCAUT(*ALLOBJ *JOBCTL) JOBD(*LIBL\ONEWORLD)