Considerations for using the DB2 database temporary tables

When using a temporary table for DB2, the following points need to be noted:

1. DB2 temporary tables need to be created using the command declare temporary table and need to be created on the user temporary tablespace;

2. DB2 when the database is created, the user temporary table space is not created by default, and if a temporary table is needed, the user is required to create a temporary table space before the temporary table is created;

3. The model of the temporary table is session;

4. By default, all records in a temporary table are deleted when the commit command is executed; This can be controlled by specifying different parameters when creating a temporary table;

5. When running the rollback command, the user temporary table will be deleted;

6. In DB2 version 8, you can log records on temporary tables.