Extract File Specification in File-AID Load for Db2
The following figure is displayed when you enter option 2, File-AID Load for DB2 in the Extract/Load Menu.
Extract File Specification
Use this screen to specify the name of the extract file from which you want to load data and select the load method to use, either SQL insert statements or the IBM Db2 Batch Load Utility.
If your extract file is on tape or cartridge, specify the summary file to use, create or update.
Press ENTER to continue to either the Load-SQL-Insert, Load-DB2-Load, Create-New-File (Summary File usage = C), or the ISPF/PDF EDIT Screen (Summary File usage = U).
Extract File
Specify the name of the File-AID for Db2 extract file from which you want to load data. The extract file must be in the format that File-AID for Db2 creates during extract. See File-AID Extract File for information about the format of the extract file.
Refer to Pattern File Names for Options 3.7.1 and 3.7.2 (Extract/Load) for more information on how to use patterns.
Load Option
Specify whether you want to load Db2 data using SQL INSERT statements or the IBM Db2 Batch Load Utility. See also SQL Insert and DB2 Load Utility Load Options.
1
Perform the load using SQL INSERT statements. This option allows you to update rows if they already exist.
2
Perform the load using the IBM Db2 Batch Load Utility.
Summary File usage
Specify whether your load request should utilize the summary file. The summary file is required for extract files on tape or cartridge, it’s optional for extract files on disk. For a multi-volume disk extract file, a summary file can speed up processing as it contains the header and trailer information for the extract.
N | None - Specify N when the extract file is on disk and a summary file is not needed. |
E | Existing - Specify E when the summary file for this particular extract file already exists. File-AID continues with the Load-SQL-Insert or LOAD - DB2 Load screens. |
C | Create - Specify C when you want File-AID for Db2 to create the summary file for the above extract file. File-AID for Db2 then starts a batch job that extracts header and trailer information from the extract file. After the batch job to create the summary file has finished, you can continue the load request for this extract file. File-AID for Db2 will display the Create New File screen to allocate the new file. |
U | Update - Specify U when you want File-AID for Db2 to update an existing summary file for the above extract file. File-AID for Db2 then starts a batch job that extracts header and trailer information from the extract file. After the batch job to update the summary file has finished, you can continue the load request for this extract file. |
Summary File
Specify the name for the summary file (previously known as tape control file) that contains the information for the above extract file that’s stored on tape, cartridge, or disk. Starting with Release 6.2 of File-AID for Db2, a summary file is created automatically during the extract to tape process (see Extract Output Information Area). If your extract file is a multi-volume file, a summary file can speed up processing as it contains the header and trailer information for the extract.
For more information on how to use patterns, see Pattern-File-Names-for-Options-3-7-1-and-3-7-2-in-Extract-Load-function.