Specify physical file and member attributes when creating a physical file

This topic describes some of the attributes you can specify for 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 the file (ADDPFM, CHGPFM, CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).
• Size of the physical file member
  The SIZE parameter specifies the maximum number of records that can be placed in each member (CRTPF, CHGPF, CRTSRCPF, AND CHGSRCPF commands).
• Storage allocation
  The ALLOCATE parameter controls the storage allocated for members when they are added to the file (CRTPF, CHGPF, CRTSRCPF, and CHGSRCPF commands).
• Method of allocating storage
  The CONTIG parameter controls the method of allocating physical storage for a member (CRTPF and CRTSRCPF commands).
• Record length
  The RCDLEN parameter specifies the length of records in the file (CRTPF and CRTSRCPF commands).
• Deleted records
  The DLTPCT parameter specifies the percentage of deleted records a file 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 if the file is update-capable and delete-capable (CRTPF and CRTSRCPF commands).
• Source type
  The SRCTYPE parameter specifies the source type for a member in a source file (ADDPFM and CHGPFM commands).