How to: |
A detailed flow report displays general properties like name, description, DM release, creator, and modify date. It also provides specifics on SQL Select Statements, target information, load options, target transformations, and execution properties. These reports are useful for documentation purposes.
Detailed reports are available for individual flows from the DMC. You also can generate detailed reports for all of the flows in the server's path or in a specific application directory from the Web Console.
Note: If you are using bulk load for DB2, Oracle or SQL Server, the bulk load parameters are now included on the detailed flow report.
The log file for a flow is useful in determining problems encountered when running a flow.
Right-click a flow in the navigation pane and select View and Flow Report.
Note: If you have the flow open in the workspace, you can also select View Flow Report from the Flow menu.
The flow report shown in the following image appears in a separate browser window. It can be printed from that window.
Tip: You can also copy the report to the Clipboard and paste it in Word or any other word processing program. To do this, right-click the report and select Select All. Then right-click and select Copy. You can now paste the report in another program.
You can generate detailed reports for all of the flows in the server path or in a specific application directory from the Web Console.
The Applications page opens.
The flow reports appear in the workspace, as shown in the following image.
You can generate a log file for reports that have been run.
The Log and Statistics window opens.
Specify what time range you want to run the report for. The options are Last, All, or Specify Time.
The log report appears in the workspace, as shown in the following image:
This example contains sample lines from log files, and an explanation of the code.
The first lines of a log display DM job initialization.
------ Start of Log Record for baseapp/one ------ Request - one (Owner: dm) submitted.
The next lines display the data target or file type and whether it is a new or existing data target.
linertps type MS SQL Server New target PREPARE executed Create synonym executed for: linertps Issuing DROP TABLE for linertps Issuing CREATE TABLE for linertps
dmrpts type MS SQL Server Existing target PREPARE executed ROWS AFFECTED BY PASSTHRU COMMAND : 222/DELETE
The log then displays summary data for the request. You can see the number of records that were processed.
Starting Load-- stats for newtab ------------------------------------- 184 : Row(s) processed by job 144 : Row(s) accepted by target table 144 : Row(s) inserted into target table 0 : Row(s) updated in target table 0 : Row(s) deleted from target table 0 : Row(s) rejected due to format errors 40 : Row(s) rejected due to validation errors 0 : Row(s) rejected due to no match logic 0 : Row(s) rejected because duplicate exists
The remaining lines contain summary data, and the return code from the flow.
Ending Load Return Code = 0 Request: one - finished processing Finished
iWay Software |