Hp Neoview Release 2.4 Software User Manual download pdf (Page 137)

This figure shows a view of the SQL Objects Detail panel:

If you click the Filter Settings bar, you can:

• Select the columns to be displayed in the data grid.

• Enter the maximum number of rows to be viewed, default is 100000.

NOTE: In the filter options, the object name is required.

This figure shows the filter settings that you can select (by clicking on the check boxes) to be

displayed in the data grid:

View the SQL Objects Detail 137

1 2 ... 132 133 134 135 136 137 138 139 140 141 142 ... 159 160

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
Usage Tab 53
Partitions 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
Search the Data Grid 116
Customize 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

Comments to this Manuals

No comments

Hp Neoview Release 2.4 Software User Manual Page 137

Comments to this Manuals

Related products and manuals for Software Hp Neoview Release 2.4 Software