HCL Workload Automation, Version 9.4

Job log output

The HCL Workload Automation for IBM InfoSphere DataStage job log and its content.

Purpose

The output of an HCL Workload Automation for IBM InfoSphere DataStage job is composed of two parts:
  • The first part is the result of the IBM InfoSphere DataStage dsjob -logsum command.
  • The second part is the result of the IBM InfoSphere DataStage dsjob -report DETAIL command.
The output shows the current job status. See Analyzing the job log for more information about accessing the job log.

Sample

This example shows the output of a job that completed successfully:
===============================================================
0       RESET   Wed Oct 05 17:15:44 2011
        Log cleared by user
1       STARTED Wed Oct 05 17:18:28 2011
        Starting Job dsj01_succ.
2       INFO    Wed Oct 05 17:18:28 2011
        Environment variable settings:  (...)
3       INFO    Wed Oct 05 17:18:28 2011
        dsj01_succ: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,
        US-ENGLISH,US-ENGLISH
4       INFO    Wed Oct 05 17:18:31 2011
        dsj01_succ..DB2_UDB_API_2.IDENT2:
        DSD.StageRun Active stage starting, tracemode = 0.
5       INFO    Wed Oct 05 17:18:31 2011
        dsj01_succ..DB2_UDB_API_2.IDENT2: NLS stage locale is
          US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH
6       INFO    Wed Oct 05 17:18:31 2011
        dsj01_succ..InputDataFile: Using project default NLS map MS1252
7       INFO    Wed Oct 05 17:18:31 2011
        dsj01_succ..DB2_UDB_API_2: Using NLS map MS1252
8       INFO    Wed Oct 05 17:18:35 2011
        dsj01_succ..DB2_UDB_API_2: Executing BeforeSQL
9       INFO    Wed Oct 05 17:18:37 2011
        dsj01_succ..DB2_UDB_API_2:
        Transaction committed as part of link close processing.
10      INFO    Wed Oct 05 17:18:37 2011
        dsj01_succ..DB2_UDB_API_2.IDENT2: Stage statistics  (...)
11      INFO    Wed Oct 05 17:18:37 2011
        dsj01_succ..DB2_UDB_API_2.IDENT2: DSD.StageRun Active stage finishing.
12      INFO    Wed Oct 05 17:18:38 2011
        dsj01_succ..OutputDataFile.IDENT1:
        DSD.StageRun Active stage starting, tracemode = 0.
13      INFO    Wed Oct 05 17:18:38 2011
        dsj01_succ..OutputDataFile.IDENT1: NLS stage locale is
         US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH
14      INFO    Wed Oct 05 17:18:38 2011
        dsj01_succ..DB2_UDB_API_2: Using NLS map MS1252
15      INFO    Wed Oct 05 17:18:40 2011
        dsj01_succ..OutputDataFile: Using project default NLS map MS1252
16      WARNING Wed Oct 05 17:18:41 2011
        Link report for link dsj01_succ.DB2_UDB_API_2.DSLink3 not found.
17      INFO    Wed Oct 05 17:18:41 2011
        dsj01_succ..OutputDataFile.IDENT1: Stage statistics  (...)
18      INFO    Wed Oct 05 17:18:41 2011
        dsj01_succ..OutputDataFile.IDENT1: DSD.StageRun Active stage finishing.
19      STARTED Wed Oct 05 17:18:42 2011
        Finished Job dsj01_succ.
**************************************************
STATUS REPORT FOR JOB: dsj01_succ
Generated: 2011-10-05 17:19:11
   Job start time=2011-10-05 17:18:28
   Job end time=2011-10-05 17:18:41
   Job elapsed time=00:00:13
   Job status=2 (Finished with warnings)
      Stage: DB2_UDB_API_2.IDENT2, 10 rows input
      Stage start time=2011-10-05 17:18:37, end time=2011-10-05 17:18:37,
      elapsed=00:00:00
         Link: DSLink7, 10 rows
         Link: DSLink7, 10 rows
      Stage: OutputDataFile.IDENT1, 10 rows input,
           last error=2011-10-05 17:18:41\NC112206|isadmin\2\Link 
           report for link dsj01_succ.DB2_UDB_API_2.DSLink3 not found.
      Stage start time=2011-10-05 17:18:41, end time=2011-10-05 17:18:41,
      elapsed=00:00:00
         Link: DSLink3, 10 rows,
         last error=2011-10-05 17:18:41\NC112206|isadmin\2\Link 
         report for link dsj01_succ.DB2_UDB_API_2.DSLink3 not found.
         Link: DSLink3, 10 rows, 
         last error=2011-10-05 17:18:41\NC112206|isadmin\2\Link 
         report for link dsj01_succ.DB2_UDB_API_2.DSLink3 not found.