IBM Support

Message CPF3234 Received on CHGLF

Troubleshooting


Problem

This document describes in detail why message CPF3234 would be received for a Join Logical file and why *ALL authority may be observed.

Resolving The Problem

This document describes in detail why message CPF3234 would be received for a Join Logical file and why *ALL authority may be observed.

A join LF is never updateable and can never have the data rights to *UPD. On those cases where a user gets *ALL from whatever interface, when the attempt is made to update the authority, message CPF3234 is issued to indicate that the authority is being ignored. The user will no longer show *ALL. It will show *USRDEF. If you want *ALL authority, you must grant it using an *AUTL.

The value of *ALL is not impossible; this can be inferred from the above update. Specifically, the OWNER(*GRPPRF) can get *ALL, as well as the original *OWNER can get *ALL.

However, when the authority is changed, message CPF3234 is issued to indicate those authority values were dropped and ignored. Regardless of the authority *ALL, no user can actually update, delete, or insert using the LF because of the ALWxxx values as displayed by DSPFD command.

If a create interface (in other words, restore or CRTxx) gives an authority of *ALL, unless or until the authority change feature is invoked, the *ALL will remain. Since the object is protected by both AUT and ALWxxx of DSPFD, there is no requirement to ensure the *ALL does not show. This is working as coded; we do not intend to prevent *ALL from appearing in all create interfaces.

[{"Product":{"code":"SWG60","label":"IBM i"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 for IBM i","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Historical Number

444567689

Document Information

Modified date:
18 December 2019

UID

nas8N1014478