Temporary and Workfile Databases

To create or template a database for declared temporary tables, set the Database Create, Alter, or Template panel's AS option to TEMP.
carcudb2
To create or template a database for declared temporary tables, set the Database Create, Alter, or Template panel's AS option to TEMP.
You can create only one temporary database for each DB2 subsystem or data sharing member. A temporary database cannot be shared between DB2 subsystems or data sharing members.
A temporary database must have its CCSID option set to blanks.
Specifying the AS option to TEMP causes the AS TEMP clause to be inserted into the generated DDL.
To create or template a work file database, set the Database Create, Alter, or Template panel's AS option to Workfile. You can only do this in a data sharing environment and you can only create one work file data base for each DB2 member.