Specifying physical file and member attributes

 

You can specify the attributes of physical files and members on the Create Physical File (CRTPF), Create Source Physical File (CRTSRCPF), Change Physical File (CHGPF), Change Source Physical File (CHGSRCPF), Add Physical File Member (ADDPFM), and Change Physical File Member (CHGPFM) commands.

• Expiration date
  The EXPDATE parameter specifies an expiration date for each member in a physical file (ADDPFM, CHGPFM, CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).

• Size of a physical file member
  The SIZE parameter specifies the maximum number of records that can be placed in each physical file member (CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).

• Storage allocation
  The ALLOCATE parameter controls the storage that is allocated to each member when it is added to a physical file (CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).

• Method of allocating storage
  The CONTIG parameter controls the method of allocating physical storage for each physical file member (CRTPF and CRTSRCPF commands).

• Record length
  The RCDLEN parameter specifies the length of records in a physical file (CRTPF and CRTSRCPF commands).

• Deleted records
  The DLTPCT parameter specifies the percentage of deleted records that each physical file member can contain before you want the system to send a message to the system history log (CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).

• Physical file capabilities
  File capabilities are used to control which input/output operations are allowed for a database file independent of database file authority. The ALWUPD and ALWDLT parameters specify whether records in a physical file can be updated and deleted (CRTPF and CRTSRCPF commands).

• Source type
  The SRCTYPE parameter specifies the source type for a member in a source file (ADDPFM and CHGPFM commands).

 

Parent topic:

Setting up physical files