Home | Previous Page | Next Page   Developing an Access Method >

Testing the Access Method

To test the access method, take the same actions that users of the access method take to create and access virtual data:

To test the access method
  1. Create one or more storage spaces.
  2. Use the access method to create tables in your storage spaces.
  3. Run SQL statements to insert, query, and alter data.
  4. Use the oncheck utility, which executes am_check, to check the integrity of the data structures that the access method writes to disk.

Typically, a database system administrator who is responsible for the configuration of the database server performs steps 1 and 4. A database administrator performs step 2. Anyone with the appropriate SQL privileges to access or update the table that uses the access method performs step 3.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]