HP Neoview Release 2.4 Software manuals

Hp Neoview Release 2.4 Software User Manual (124 pages)

Brand: Hp | Category: Software | Size: 1.10 MB |

English

Table of contents

HP Part Number: 514030-001

1

Published: April 2009

1

Edition: Release 2.4

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

8

About This Document

9

Neoview Customer Library

10

HP Encourages Your Comments

11

General Syntax Notation

11

Publishing History

13

1 Overview

15

Client Components

16

Installation Requirements

17

Installing Transporter

17

The Transporter API

20

3 Functions and Features

21

22 Functions and Features

22

4 Security

23

Creating a Control File

25

Control File Limits

25

Typeformats

29

— backslash (\\)

32

“%D:%H:%M:%D”

34

“%H:%M:%D:%S”

34

Dataformats

35

FROM myTable

38

FROM T1, T2

38

WHERE T1.A = T2.A

38

INFO = NULL

41

Comments

47

Supported Data Types

48

6 Control File Options

49

50 Control File Options

50

Encoding For A Load Job

52

Encoding For An Extract Job

52

54 Control File Options

54

56 Control File Options

56

58 Control File Options

58

60 Control File Options

60

7 Load and Extract Operations

61

Stopping the Client

62

The Transporter Job

63

Sources and Targets

63

Parallel Streams

63

Requirements

65

8 Data Processing

69

Delimited Data

70

Interpreted as ...Input Data

71

New York, NY“New York, NY”

71

Not “quoted”Not “quoted”

71

Delimited Data 71

71

72 Data Processing

72

9 Troubleshooting

73

Job Recovery

74

Control File Metadata Tables

76

A Control File Examples

79

84 Control File Examples

84

90 Control File Examples

90

92 Control File Examples

92

94 Control File Examples

94

96 Control File Examples

96

98 Control File Examples

98

100 Control File Examples

100

102 Control File Examples

102

104 Control File Examples

104

Control File Editor

107

Setting the Default Folder

108

Validating a Control File

108

Control File Generator

109

Optional Arguments

110

Error Message and Behavior

111

Packaging

111

C Global Options Table

113

XX“url” (page 60)

114

XX“user” (page 60)

114

114 Global Options Table

114

D Reserved Keywords

115

E Transporter Exit Codes

117

Glossary

119

122 Index

122

Hp Neoview Release 2.4 Software User Manual (160 pages)

Brand: Hp | Category: Software | Size: 3.32 MB |

English

Table of contents

HP Part Number: 597527-001

1

Published: March 2010

1

Table of Contents

3

4 Table of Contents

4

Table of Contents 5

5

6 Table of Contents

6

Table of Contents 7

7

8 Table of Contents

8

Learn About This Document

9

Resources on the Web

11

Send Feedback to HP

11

Part Number: 597527-001

12

1 Install and Start HPDM

13

Start the HP Database Manager

14

Use Menu Bar Commands

15

Exit the HP Database Manager

15

2 Connect and Disconnect

17

Disconnect From a System

18

Log On and Off

19

Use the Systems Tool

19

Add a System

20

Use the Add System Dialog Box

21

Edit a System

22

Add a System Like

23

Remove a System

23

Test a System

23

3 Navigate HPDM

25

Use the Navigation Tree Pane

27

Understand My Other Systems

28

Use the Right Pane

29

Use the My Favorites Pane

30

Create a Favorite

31

Use a Favorite

31

View a List of Favorites

31

Add a Favorite to a Folder

31

See the HPDM Header

32

Customize HPDM Windows

32

Manage Windows

32

Sort and Move Data Columns

35

Clone a Tab

36

Export Data

36

Save Data to a Spreadsheet

37

Export Data to a Browser

37

Use the System Message Tab

37

Create a System Message

38

Clone the System Message Tab

39

View Event Messages

40

5 Manage Database Objects

47

Attributes Tab

48

Tables Tab

48

Materialized Views Tab

48

Materialized View Groups Tab

48

Views Tab

49

Procedures Tab

49

Synonyms Tab

49

Privileges Tab

50

Schema Size

50

Columns Tab

51

Primary Key Tab

52

Hash Key Tab

52

Unique Constraints Tab

52

Foreign Keys Tab

52

Partitions Tab

53

Usage Tab

53

Statistics Tab

54

Tables Summary

55

Table Indexes Summary

57

60 Manage Database Objects

60

Materialized Views Summary

63

Members Tab

66

Parameters Tab

69

Show DDL

74

Viewing Sampled Statistics

76

6 Use the System Monitor

77

About the Timeline Tab

79

About the Hybrid Tab

80

82 Use the System Monitor

82

Change a Color Option

85

7 Respond to Alerts

87

Understand Alerts

88

Get Information About Alerts

89

Control the Refresh of Alerts

93

Update an Alert

95

Update Multiple Alerts

96

Make Notes About an Alert

96

About the Console Tab

97

About System Offender

99

For example:

101

Get Pstate Information

104

9 Work With Data Grids

113

Copy Data-Grid Information

114

Customize the Data Grid

116

Search the Data Grid

116

10 Use the SQL Whiteboard

117

Understand Parameter Prompts

119

Execute Highlighted Text

119

Reuse a Connection

120

Highlight SQL Syntax

120

Manage the Layout of Panes

120

Related Topics

121

Learn About NCI

123

Locate the NCI Program

123

Launch NCI

123

Set Auto Logon Options

123

12 Manage Disk Space

125

126 Manage Disk Space

126

About the Monitoring Tab

128

View the System Overall

131

View the System Detail

132

View the System Detail 133

133

View SQL Objects

135

View the SQL Objects Detail

136

View Table Growth

140

By Table Tab

141

DescriptionField or Option

143

View Table Growth 143

143

About the Configuration Tab

144

About the General Tab

145

Space Reference Settings

146

About the Advanced Tab

147

Inventory Options

148

Update Space Reference Tables

148

Glossary

151

152 Glossary

152

154 Index

154

156 Index

156

158 Index

158

Hp Neoview Release 2.4 Software User Manual (70 pages)

Brand: Hp | Category: Software | Size: 1.15 MB |

English

Table of contents

HP Part Number: 546008-001

1

Published: April 2009

1

Table of Contents

3

4 Table of Contents

4

Table of Contents 5

5

About This Document

7

HP Encourages Your Comments

8

HP Database Manager

9

Customizing HPDM Windows

11

About Box

11

Exit the HP Database Manager

11

2 The Systems Tool

13

14 The Systems Tool

14

Edit System

15

Add System Like This

16

Remove System

16

Clear Password for System

16

Test System

16

3 Navigating HPDM

17

Right Pane

18

Right Pane 19

19

4 Managing Database Objects

21

Attributes Tab

22

Tables Tab

23

Materialized Views Tab

23

Materialized View Groups Tab

23

Views Tab

23

Procedures Tab

24

Synonyms Tab

24

Privileges Tab

24

Displaying Schema Size

25

26 Managing Database Objects

26

Columns Tab

27

Primary Key Tab

27

Hash Key Tab

27

Unique ConstraintsTab

27

Foreign Keys Tab

28

Partitions Tab

28

Usage Tab

29

Statistics Tab

29

Displaying Tables Summary

30

36 Managing Database Objects

36

40 Managing Database Objects

40

Members Tab

45

Parameters Tab

47

48 Managing Database Objects

48

Show DDL

53

54 Managing Database Objects

54

Viewing Sampled Statistics

56

5 Using the SQL Whiteboard

59

Statement List Pane

60

Statement Pane

60

Statement Details Pane

61

Reusing a Connection

61

Loading and Saving in SQL

62

Highlighting Syntax

62

Managing the Layout

62

Locating the NCI Program

63

Launching NCI

63

Auto Logon Options

63

7 Performing HPDM Operations

65

Communicating System Messages

66

Overview Area

66

System Message Tab

66

Navigation

66

Cloning 67

67

8 Glossary

69

Glossary

69

Hp Neoview Release 2.4 Software User Manual (128 pages)

Brand: Hp | Category: Software | Size: 0.99 MB |

English

Table of contents

HP Part Number: 621366-001

1

Published: May 2010

1

Table of Contents

3

4 Table of Contents

4

Table of Contents 5

5

List of Figures

6

List of Tables

7

List of Examples

8

About This Document

9

Notation Conventions

10

Notation Conventions 11

11

Related Documentation

12

• Connectivity

13

• Reference

13

Publishing History

14

HP Encourages Your Comments

14

1 Introduction

15

16 Introduction

16

Installation

17

Obtaining Prepackaged Queries

17

Starting the Repository

17

3 Repository Views

19

ODBC Session Data

33

Processing Node Statistics

38

Process Statistics

40

Table Statistics

47

Disk Statistics

50

EMS Events

53

Management

55

SPACE_Q_CATALOG_SIZE_VW1

62

SPACE_Q_DISK_FULL_VW1

62

SPACE_Q_OBJECT_GROWTH_VW1

63

SPACE_Q_PARTITION_FULL_VW1

63

SPACE_Q_SYSTEM_DETAILS_VW1

63

SPACE_Q_SYSTEM_TOTAL_SIZE_VW1

63

SPACE_Q_TABLES_BY_SCHEMA_VW1

64

SPACE_Q_TABLE_FULL_VW1

64

SPACE_Q_TABLE_SIZE_VW1

64

SPACE_Q_TOP_10_TABLE_SIZE_VW1

65

Overview

67

0030';

72

Sample Query Result

82

Releases of the Repository

83

Query Statistics for R2.4 SP1

85

New Fields in QUERY_STATS_VW1

117

New Fields in SQL_TEXT_VW1

117

New Space Management Views

117

Glossary

125

Hp Neoview Release 2.4 Software User Manual (94 pages)

Brand: Hp | Category: Software | Size: 5.15 MB |

English

Table of contents

HP Part Number: 586321-001

1

Published: September 2009

1

Table of Contents

3

4 Table of Contents

4

Table of Contents 5

5

6 Table of Contents

6

Learn About This Document

7

Intended Audience

8

Related Documentation

8

Resources on the Web

9

Send Feedback to HP

9

2 Use the Workspace

17

Create a New Workspace

18

Start a Workspace

18

Save a Workspace Layout

19

Close a Workspace

19

Open a Workspace

19

The Workspace At a Glance

19

Rename a Workspace

20

Lock a Workspace

20

Set Workspace Options

20

Add Another Workspace

21

22 Use the Workspace

22

3 Use the Workspace Toolbox

23

24 Use the Workspace Toolbox

24

Timeline Controller

25

4 Use the Neoview Pane

27

Adjust Time Settings

28

Delete Tools and Graphs

28

Add a Customized View

28

Rename a Customized View

28

Delete a View

28

Other Tasks on Graphs

29

5 Use the Live View Pane

31

Configure Live View Options

32

Customize the Live View

32

Kill Queries

32

Actions on Live View Queries

33

Notification Bubbles

33

Pause the Display

33

Thresholds and Alerts

33

34 Use the Live View Pane

34

Workspaces Tab

35

Conditions Tab

35

Running Threshold Rules

36

Monitoring Queries

37

Time-Based Metrics

39

Rate-Based Metrics

40

Compile-Time Metrics

40

Run-Time Metrics

41

Miscellanous Facts

43

Rule Warnings

43

Per-Table Statistics

43

Get Query Text

44

46 Use the Live View Pane

46

Services Details Log File

47

Neoview WMS Configuration

48

WMS Configuration Dialog

48

Managing Services

49

Add a New WMS Service

50

Alter an Existing WMS Service

52

Delete a WMS Service

53

Start a WMS Service

53

Managing Rules

54

Add a New Connection Rule

56

Example:

57

Add a New Compilation Rule

58

Add a New Execution Rule

59

Alter Existing Rule

61

Delete a Rule

61

Associate Rules to Services

61

Managing Admin Roles

62

Save/Export WMS Configuration

63

Character Set Support

64

6 Use the Triage Space Pane

65

Triage Space Settings

66

Query Candlestick Graph

67

Triage Space Button Panel

68

Filter the Queries

68

Dimensions:

69

Identifiers:

69

Triage Space Data Grid

70

Triage Space Query Details

70

• Type: Metrics

71

• Type: Miscellaneous

72

• Type: Time

72

DescriptionField

73

7 Use the Query Workbench

75

Query List

76

SQL Text

77

Statistics

78

Query Workbench Query Details

78

Operator Groups

79

Process Boundaries

80

Execute Output

82

Improve File Scan Performance

83

9 Keyboard Shortcuts

87

88 Keyboard Shortcuts

88

Glossary

89

90 Glossary

90

92 Index

92

More products and manuals for Software HP

Models	Document Type
Scripting Tools for Windows PowerShell	User Manual HP Scripting Tools for Windows PowerShell User Manual, 25 pages
Insight Diagnostics Software	User Manual HP Insight Diagnostics Software User Manual, 41 pages
XC System 3.x Software	User Manual HP XC System 3.x Software User Manual, 118 pages
Insight Management Agents	User Manual HP Insight Management Agents User Manual, 175 pages
Neoview Release 2.5 Software	User Manual HP Neoview Release 2.5 Software User Manual, 142 pages
Neoview Release 2.3 Software	User Manual HP Neoview Release 2.3 Software User Manual, 74 pages
Microsoft Operations Manager Software	User Manual HP Microsoft Operations Manager Software User Manual, 116 pages
Insight Management WBEM Providers	User Manual HP Insight Management WBEM Providers User Manual, 46 pages
Smart Update Manager	User Manual HP Smart Update Manager User Manual, 130 pages
Unified Extensible Firmware Interface	User Manual HP Unified Extensible Firmware Interface User Manual, 79 pages
Scalable Visualization Array Software	User Manual HP Scalable Visualization Array Software User Manual, 48 pages
ProLiant Support Pack	User Manual HP ProLiant Support Pack User Manual, 44 pages
Identity Driven Manager Software Series	User Manual HP Identity Driven Manager Software Series User Manual, 200 pages
SmartStart-Software	User Manual HP SmartStart-Software User Manual, 29 pages
Access Control	User Manual HP Access Control User Manual, 14 pages
XC System 2.x Software	User Manual HP XC System 2.x Software User Manual, 154 pages
OneView for Microsoft System Center	User Manual HP OneView for Microsoft System Center User Manual, 41 pages
Insight Control Software for Linux	User Manual HP Insight Control Software for Linux User Manual, 288 pages
Insight Diagnostics Software	User Manual HP Insight Diagnostics Software User Manual, 45 pages
Scalable Visualization Array Software	User Manual HP Scalable Visualization Array Software User Manual, 62 pages

HP devices