Using database file capabilities to control I/O operations

When you create a physical file, you can specify that the file capabilities control which input/output (I/O) operations are allowed for the file, independent of database file authority.

You can specify if the file is update-capable and delete-capable by using the ALWUPD and ALWDLT parameters on the Create Physical File (CRTPF) and Create Source Physical File (CRTSRCPF) commands. By creating a file that is not update-capable and not delete-capable, you can effectively enforce an environment where data cannot be changed or deleted from a file after the data is written.

File capabilities cannot be explicitly set for logical files. The file capabilities of a logical file are determined by the file capabilities of the physical files it is based on.

You cannot change file capabilities after the file is created. You must delete the file and then re-create it with the capability that you want. The Display File Description (DSPFD) command can be used to determine the capabilities of a file.