Creating explain snapshots for static SQL or XQuery statements

A number of steps are required create explain snapshots for static SQL or XQuery statements

To create an explain snapshot for a static SQL or XQuery statement:

1. If the database manager has not already been started, issue the db2start command.
2. Ensure that explain tables exist in your database.
   
   To do this, follow the instructions in Creating the explain tables.
3. From the CLP prompt, connect to the database that you want to use.
   
   For example, to connect to the SAMPLE database, issue the connect to sample command.
4. Create an explain snapshot for a static SQL or XQuery statement by using the EXPLSNAP option when binding or preparing your application.
   
   For example, issue the BIND your_file EXPLSNAP YES command.