DB Files

Add, modify, view properties, or delete a database file.

• Creating a DB File
  Add a DB file to a dbspace.
• Deleting a DB File
  Delete a DB file from a dbspace. With the exception of the IQ_SHARED_TEMP dbspace, you cannot delete the last DB file in a dbspace.
• Emptying a DB File
  Empty a DB file and move the objects in the file to another available read-write DB file. Not applicable to cache dbspace DB files.
• Generating DB File DDL Commands
  Display the data description language SQL code for adding a DB file to a dbspace. The SQL code can be a useful reference and training tool.
• Viewing or Modifying DB File Properties
  Display and change the name, mode, and path properties of a DB file.
• DB File Privilege Summary
  A list of the system privileges and object permissions required to complete the various DB file tasks.