Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 75)

CAUTION:

• You must use the original control file to recover load jobs. If the control file has changed,

Transporter reports an error and exits.

• The original and unmodified data files must be available to Transporter during recovery.

• Do not attempt to recover a job that is still running.

• Do not attempt to recover a job that is already in the recovery process.

Job Statistics on the Neoview Platform

Job statistics on the Neoview platform are used by Transporter to facilitate job recovery. The job

statistics table, HP_TRANSPORTER.BASE_JOB_STATS, maintains this information for every

job:

• job name

• job progress and status

• source and target for each job entry

• start and end time for each job entry

Each row in the BASE_JOB_STATS table represents a job entry instance. The ROWS_PROCESSED

column reflects the number of rows processed for a particular job entry instance, including

discarded and failed records. The number of rows logged in this table is not cumulative. For

example, if you must run several instances of a control file because of errors in a job entry, you

must add together the number of rows processed from all instances to get the total number of

rows processed for that job entry.

Example 9-2 Sample HP_TRANSPORTER_BASE_JOB_STATS File

TRANSACTION_SIZE | ROW_LEN | END_TIME | SQL_TEXT |

| 17714284327823 | load1 | src1 | tgt1 | 2008-02-13 16:50:44.503 | 7 | 2406 | 777 | 342 | 2008-02-13 16:50:46.284

| INSERT INTO NEO.SALES.INFORMATION (FIRST_NAME,LAST_NAME,ADDRESS,ZIP,PHONE,SSN,INFO2) VALUES (?,?,?,?,?,?,?)

| 17713711815864 | load1 | src1 | tgt1 | 2008-02-13 16:50:53.56 | 33 | 3452 | 777 | 120 | 2008-02-13 16:50:55.61

| INSERT INTO NEO.SALES.ORDERS

(O_ORDERDATE,O_ORDERKEY,O_CUSTKEY,O_SHIPPRIORITY,O_TOTALPRICE,O_ORDERSTATUS,O_ORDERPRIORITY,O_CLERK,O_COMMENT)

VALUES (?,?,?,?,?,?,?,?,?) |

You can use a simple Neoview SQL query to retrieve all of the statistics for a particular Neoview

platform:

SELECT * FROM HP_TRANSPORTER.BASE_JOB_STATS

These are the static and dynamic statistics that you can retrieve:

• Static

— Extract source: Neoview SQL Text or Multi-Partition Set Table Extract

— Single Stream or Parallel Extract Streams

— Target information: name of file, named pipe or data source

— Indication if recovery operation was initiated by user

— Load target table name

— Text of DML query for load

• Dynamic

— Run status: scheduled, in progress, complete or error

— Exit status or error reason: Transporter exit error message

— Internal recovery attempt triggered due to tenacity setting: for example, 2 of 3

— Total rows extracted

— Extract statistics per stream basis

— Start time of the job entry

Job Statistics on the Neoview Platform 75

1 2 ... 70 71 72 73 74 75 76 77 78 79 80 ... 123 124

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 75

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.4 Software