WORK FILE DB field

The value of the WORK FILE DB field specifies the name of the work file database that is to be used for the Db2 member.

Acceptable values: 1–8 characters
Default: DSN1
DSNZPxxx: none

Each Db2 member has its own work file database (called DSNDB07 in a non-data-sharing environment). One member of the data sharing group can have the name DSNDB07, but the recommendation is that you use a more meaningful name, such as WRKDSN1. You cannot specify a name that begins with DSNDB unless the name is DSNDB07.