This course describes how to create and manage the physical files in a DB2 database. The course begins by describing the basics of DDS coding and how to create a DDS source member. It then covers how to define a physical file using DDS. Next, the course shows how to use the CRTPF command to create a physical file from DDS, and how to use the CRTSRCPF command to create a source physical file. The course then describes field reference files. It shows how to both create and use a field reference file. The course ends by showing how to perform various management and maintenance tasks on physical files.
Approximate Study Time: 2 hours
After completing this course, you should be able to:
- Use the SEU to create a DDS source member
- Code the DDS statements to define a data physical file
- Use PDM to create a data physical file from DDS source
- Use the CRTPF command to create a data physical file from DDS source
- Use the CRTSRCPF command to create a source physical file
- Define and create a field reference file
- Use field referencing when defining a physical file
- Display the attributes of a physical file
- Change the attributes of a physical file
- Delete, copy, move, or rename a physical file
- Reorganize a physical file
- Add a member to a physical file
- Remove a member from a physical file
- Rename a member in a physical file
Defining a Data Physical File
Creating a Physical File
Using a Field Reference File
Working with Physical Files
This course is intended for programmers and application developers who will be creating DB2 databases. It should also be taken by anyone who will be creating and/or managing physical files.
This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Introduction to the IBM i Environment series. It also assumes that you have a basic knowledge of DB2. You can satisfy this prerequisite by successfully completing the first course in the series, Introduction to DB2.