DB2 now delivers temporary table support. DB2 will create and use temporary tables within a single connection, providing you with performance gains for the type of query workloads that can make use of intermediary tables. See the Administration Guide for more information.