File-AID Extract for Db2
The Extract DB2 - Driving Object screen displayed when you enter Option 1 on the Extract-Load-Menu.
Use this screen to specify a Db2 table from which to extract all or a subset of data.
Extract Db2 - Driving Object
The body of this screen consists of the following fields:
Mode
Displays the current execution mode of the extract request, either BATCH (default) or ONLINE. Use the MODE primary command to switch from one mode to the other.
Specify Table To Drive Extract Process From Area:
Use the fields in this area to specify the Db2 table from which you want extract data. When specifying patterns in the fields, File-AID for Db2 searches the Db2 catalog and presents selection lists.
SSID
Displays the current Db2 subsystem ID. Type over this field to connect to a different Db2 subsystem. If you leave the Location field blank, the table you specify must exist in the Db2 subsystem displayed here.
Location
Specify the location ID of the table you want to drive the extract, if it resides in a remote Db2 subsystem. The location you enter must be defined in the Db2 system catalog table, SYSIBM.LOCATIONS.
Leave this field blank if the table you want to extract data from is in the Db2 subsystem in the SSID field.
Creator
Specify the authorization ID of the owner of the table, view, synonym, or alias that you want to extract data from. You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Wildcard-Characters). If you specify a pattern, File-AID searches the Db2 catalog and displays matches in a Table List pop-up window.
Table Name
Specify the name of the table, view, or synonym that you want to extract data from. For more information about how File-AID for Db2 supports view, aliases, and synonyms in Extract.
You can enter a pattern in this field. Valid pattern characters are %, _, and * (see Wildcard-Characters). If you specify a pattern, File-AID searches the Db2 catalog and displays matches in a Table List pop-up window.
Specify Extract Options Area:
Use this area to specify the following extract options:
Add Selection Criteria
Enter Yes so you can specify selection criteria for the table. File-AID will display the Object Selection Criteria screen when you press Enter.
Enter No to extract all rows from the table.
Enter D to enable Selective Column extract and/or output of the extract file as delimited. When you press Enter, the Delimited Format Options Screen displays which starts the Delimited Extract/Selective Column extract option specification.
Selective Column Extract
Selective Column Extract allows you to specify the columns of an Object you want to extract. You can indicate the order of the selected columns and in addition, you can indicate the order that you would like to see the rows extracted. Selection criteria can also be entered for each column. A standard extract data set is created which can be used to load data.
Delimited Extract
Delimited Extract creates an extract data set which may be loadable into other RDBMS or spreadsheets that accept delimited file format. Selective Columns are allowed with the Delimited format. A Delimited Extract file is not loadable in File-AID for Db2.
Maximum Rows to Select
Specify the maximum number of rows or records to be extracted from all related objects. Once the limit is reached the extract will terminate. Enter an asterisk (*) to set no limit.
Use Uncommitted Read
Specify whether File-AID should extract data from Db2 objects that include Uncommitted Reads or not.
The field is prefilled with the specified UNCOMMITTED_READ_DEFAULT configuration parameter value (Yes or No) of the Db2 Environment PARMLIB member or with the current profile value (Yes or No) if UNCOMMITTED_READ_DEFAULT is set to blank (default, see also UNCOMMITTED_READ_DEFAULT in the Db2 environment).
Extract IMPLICITLY HIDDEN columns
Specify whether File-AID should extract data from Db2 columns that are defined as IMPLICITLY HIDDEN. When this option is set to Y, the resulting File-AID extract file will include the data from IMPLICITLY HIDDEN columns.
DB2 Format
Specify whether Db2 data extracted from tables with Unicode encoding is written to the extract file in Unicode or EBCDIC format.
1 | Unicode option will write the data using Unicode encoding. |
2 | Compatibility format will maintain the EBCDIC encoding used in previous releases. |
Extract Output Information Area:
Use this area to specify the following extract output options:
File name
Specify the name of the file to which data will be extracted. Include the member name (in parentheses) when the file is a PDS. See File-AID Extract File for more information on the extract file. Remember, File-AID will not prompt for a member name.
For more information, see Pattern-File-Names-for-Options-3-7-1-and-3-7-2-in-Extract-Load-function on how to use patterns.
When specifying a file that does not exist, File-AID for Db2 will display the Create New File screen.
Disguise Extract File
Specify whether File-AID should disguise the extracted data as part of the extract batch job or not. When set to 1 (DCF) or 2 (DPR), all extracted objects which have disguise criteria defined in the Disguise Control file (DCF) or in the Dynamic Privacy Rules Project (DPR) will be disguised.
1 | Use DCF. Disguise the extracted data using a Disguise Control file (DCF). This option requires installation of Compuware’s File-AID/Data Solutions. |
2 | Use DPR. Disguise the extracted data using a Dynamic Privacy Rules Project (DPR). This option requires installation of Compuware’s File-AID/Data Solutions and the File-AID Data Privacy plugin of the Topaz Workbench. Note: Before submitting the job, be sure to specify a region size large enough to run Java (REGION=0M is suggested, 300M is the minimum) in your jobcard (see also Edit-JCL). |
3 | No Disguise. The extracted data will not be disguised. |
DCF: Control File
Specify the name of Disguise Control File (DCF) that contains the disguise criteria to be used with Disguise Extract File option 1 for this extract. Disguise Control Files can be created with Option 7.4, Allocate Disguise Control File. The disguise criteria is specified using Option 7.1, Create and Modify Disguise Criteria.
For more information, see Pattern-File-Names-for-Options-3-7-1-and-3-7-2-in-Extract-Load-function on how to use patterns.
Hints
- Before you submit the disguise job, make sure that the Disguise Control File includes the desired disguise criteria for the object included in the extract file.
- For related disguise rules, always define the criteria on the object that contains all of the different unique values (including orphans) to be extracted.
DPR: Repository Name
Specify the name of the Privacy Rules Repository to be used with Disguise Selection option 2 for this extract.
Specify the full repository name (up to 128 characters). Or enter an asterisk (*) by itself for a list of all repositories. Then select the desired repository from the list (see Privacy Repository List Screen).
DPR: Project Name
Specify the name of the Dynamic Privacy Rules Project to be used with Disguise Extract File option 2 for this extract. Dynamic Privacy Rules are created with the File-AID Data Privacy component of the Topaz Workbench. The Dynamic Privacy Rules Project keeps track of how to apply the privacy rules to which extracted data element. This option requires installation of Compuware’s File-AID/Data Solutions Release 4.4 or higher and File-AID Data Privacy.
Specify the full project name (up to 128 characters) or a pattern ending with an asterisk (*) for a list of matching projects. Asterisk (*) by itself lists all projects. Then select the desired project from the list (see Privacy Project List ).
Create Audit Trail
Specify whether or not the File-AID/Data Solutions disguise process should produce an audit trail report for the extracted table data to be disguised.
Y | Create audit trail reports using File-AID/Data Solutions audit trail exits. Note that the File-AID/Data Solutions audit trail exits determine if a report is created and what is reported. |
N | Don’t create audit trail reports. |
Audit Trail Prefix
Specify the prefix for the File-AID/Data Solutions audit trail reports for this extract. Prefix plus USERID can be up to 14 positions, the remainder of the data set name will follow the above mentioned naming convention. If prefix is blank, only the USERID will be used. Any value specified will be appended to the USERID. Precede the prefix value with a single quote (‘) to use the value without the USERID.
Primary Commands
The following File-AID-specific primary command is valid on this screen:
EDIT (E)
Displays the JCL for this extract request. File-AID shows the Generated JCL panel where you review and modify the extract JCL. See also Edit-JCL. With ONLINE mode enabled, File-AID shows the generated REXX panel where you review the extract REXX. See also Edit-REXX.
GO (G)
Submits this extract request. Before issuing the GO command, make sure you have completed all the extract information. File-AID will also issue a message upon completion of the job.
MODE
Enter the MODE command to switch the extract execution mode from BATCH (default) to ONLINE or from ONLINE back to BATCH. MODE acts as a toggle switch. MODE command is only valid when variable ALLOW_EXTRACTS_TO_RUN_ONLINE is set to Y. For more information, see ALLOW_EXTRACTS_TO_RUN_ONLINE in the SVC information.
This section provides information about the following topics: