With the SELECT function, you can extract data from the database directly from the dbextents. This function is available regardless of whether the database server is online or offline. If SELECT is used when the database server is online, Data Restore requests an exclusive lock on the dbspace. This lock ensures that no one can update data while Data Restore is processing the SELECT request. The exclusive dbspace lock may cause lock contention for other users. The SELECT function requires that you specify the SQLDBA password on the DBAPW parameter of the CONTROL statement as a security precaution.
When you specify OUTPUT=PRINTER, the SELECT function displays the selected data in a report format to SYSPRINT.
When the OUTPUT=TAPE or the OUTPUT=DASD parameter is specified, you can use the SELECT function to replace the DBSU DATAUNLOAD command. Data Restore writes the selected data to the DATAUNL file in a format that the DBSU DATALOAD facility can use. To help with the use of the DBSU DATALOAD facility, DBSU control statements are written to SYSPRINT. Examples are provided later in this chapter.
| Note: | The SELECT function divides at least by 2 the necessary time to unload data using the DBSU DATAUNLOD function. |