Hp Neoview Release 2.4 Software Manuel d'utilisateur Page 53
- Page / 160
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click the Foreign Key tab in the right pane.
In the right pane, these attributes are displayed:
• Name: Name of the foreign key constraint.
• Foreign Table: Name of the foreign table.
• Local Column: Name of the local column of the foreign key.
• Foreign Column: Name of the foreign column of the foreign key.
• Enforced: Indicates if referential integrity is enforced.
Attributes Tab
To display the table attributes with the attribute name and value:
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
• Name: Name of the table.
• Log Inserts Only: A string value of “True” or “False.”
• Reorganize Enabled: A string value of “True” or “False.”
• Update Statistics Enabled: A string value of “True” or “False.”
• Last Updated Statistics: The string value of “Never” or a timestamp of the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Maximum Size: Maximum size in megabytes to which a table can grow. If maximum
size is 0, then the string “Determined by system” is displayed.
• Record Size: Row size in bytes in each logical record.
• Creation Time: Time and date when the table was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the table was last redefined. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Partitions Tab
To display the table partition information:
1. Select a Schema in the navigation tree and click the table name in the right pane, or open
the Tables folder and select a table name in the tree.
2. Click the Partitions tab in the right pane.
In the right pane, these attributes are displayed:
• Partition Number: The index number of the partition.
• Percent Allocated: The percentage full of the partition.
• Row Count: The current total number of rows in the partition.
• Max Size: The maximum size in bytes of the partition.
• Current EOF: The current data size of the partition in bytes.
Usage Tab
To display usage information defined on the table:
Display Tables and Their Properties 53
- 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
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.4 Software
(74 pages)
(58 pages)
(102 pages)
(259 pages)
(159 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.040 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels