Hp Neoview Release 2.3 Software Bedienungsanleitung Seite 69
- Seite / 110
- Inhaltsverzeichnis
- FEHLERBEHEBUNG
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
• 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
— Time for next retry operation if applicable
— End time of the job entry
Control File Metadata Tables
You can retrieve control file related data from these metadata tables on the Neoview platform:
• HP_TRANSPORTER.CONTROL_FILES — list of control files including the host name,
absolute path, and modification time. Use this list to locate a particular control file.
Example 9-2 Sample HP_TRANSPORTER_CONTROL_FILES File
| FILE_ID | FILE_HOST | FILE_ABS_PATH | FILE_ENCODING | FILE_VERSION | FILE_MODTIME |
| 17714284327823 | mynode.intranet.foo.bar.net | /mydir/control-files/control_info.txt | UTF-8 | 1 |
2008-02-13 16:47:18.0 |
| 17713711815864 | mynode.intranet.foo.bar.net | /mydir/control-files/control_ordr.txt | UTF-8 | 1 |
2008-02-13 16:47:27.0 |
• HP_TRANSPORTER.CONTROL_FILE_TEXT — the text of a particular control file
Example 9-3 Sample HP_TRANSPORTER_CONTROL_FILE_TEXT File
| FILE_ID | SEQ_NUM | FILE_TEXT |
| 17714284327823 | 1 | version 1.0; options { errors = 3 discards = 8, commitsize = 777, rowsetsize =
777 } ... |
| 17713711815864 | 1 | version 1.0; options { errors = 5, discards = 1, commitsize = 777, rowsetsize =
777 } ... |
NOTE: Password values have already been encrypted before control files are saved on the
Neoview platform.
Use these two metadata tables to find and examine the control file used to run a particular job
in the job statistics table. You can use the information from these tables to find and fix problems
that caused a job to fail.
Outdated information must be removed manually from these metadata tables.
CAUTION: Running jobs are actively using rows in the metadata tables. Do not delete these
rows or any other rows that might be needed for the recovery of failed jobs.
Using Transporter Metadata Tables
This section describes several scenarios, with examples, for statistics retrieval and metadata
maintenance.
Job Statistics on the Neoview Platform 69
- HP Part Number: 545787-001 1
- Published: April 2008 1
- Edition: Release 2.3 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- 6 Table of Contents 6
- List of Tables 7
- List of Examples 9
- About This Document 11
- HP Encourages Your Comments 12
- General Syntax Notation 12
- General Syntax Notation 13 13
- Publishing History 14
- 1 Overview 15
- Client Components 16
- Installation Requirements 17
- Installing Transporter 17
- Installing Transporter 19 19
- 3 Functions and Features 21
- 22 Functions and Features 22
- 4 Security 23
- Creating a Control File 25
- Control File Limits 25
- Typeformats 29
- Dataformats 32
- FROM myTable 35
- FROM T1, T2 35
- WHERE T1.A = T2.A 35
- INFO = NULL 38
- EMP_ID = identity loader 39
- FIRSTNAME = FIRST_NAME 39
- Comments 44
- Supported Data Types 45
- 6 Control File Options 47
- 48 Control File Options 48
- 50 Control File Options 50
- 52 Control File Options 52
- 54 Control File Options 54
- 7 Load and Extract Operations 57
- Stopping the Client 58
- The Transporter Job 58
- Sources and Targets 59
- Parallel Streams 59
- Requirements 61
- 8 Data Processing 63
- Delimited Data 64
- Interpreted as ...Input Data 65
- New York, NY“New York, NY” 65
- Not “quoted”Not “quoted” 65
- Delimited Data 65 65
- 66 Data Processing 66
- 9 Troubleshooting 67
- 68 Troubleshooting 68
- Control File Metadata Tables 69
- 70 Troubleshooting 70
- A Control File Examples 73
- 78 Control File Examples 78
- 84 Control File Examples 84
- 86 Control File Examples 86
- 88 Control File Examples 88
- 90 Control File Examples 90
- 92 Control File Examples 92
- 94 Control File Examples 94
- 96 Control File Examples 96
- Control File Editor 97
- Control File Generator 99
- Error Message and Behavior 100
- Packaging 100
- C Global Options Table 101
- D Reserved Keywords 103
- 108 Index 108
Verwandte Produkte und Handbücher für Software Hp Neoview Release 2.3 Software
(99 Seiten)
(37 Seiten)
(120 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.035 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern