Hp Integrity NonStop J-Series Instrukcja Użytkownika Strona 57
- Strona / 110
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
2. In the right pane, click Partitions.
The following details appear:
• Partition Number: — The index number of the partition.
• System: — The name of the NonStop system where this partition is located.
• Name: — The partition name that is created by the system.
• File: — The physical file where the partition is located.
• Percent allocated: — The percentage of the partition used.
• Row count: — The number of rows in the partition.
• Rows Inserted Since Last Update Stats: — The number of rows inserted after the Update
Statistics command was last run.
• Rows Deleted Since Last Update Stats: — The number of rows deleted after the Update
Statistics command was last run.
• Rows Updated Since Last Update Stats: — The number of rows updated after the Update
Statistics command was last run.
• Primary Extents: — The size of primary extent in pages.
• Secondary Extents: — The size of secondary extents in pages.
• Max Extents: — The maximum number of extents.
• Allocated Extents: — The number of extents allocated.
• Max Size: — The maximum size of the partition.
• Current EOF: — The space used in the partition.
Viewing information on related objects
To view information on related objects:
1. In the navigation tree, select the table.
2. In the right pane, click Related Objects.
The following details appear:
• Relationship: — This property specifies the relationship of the table with the object. The
available values for this field are Uses, Used By, and Has.
• Related Object Type: — This property specifies the type of the related object. The available
values are Table and View.
• Related Object Name: — This property specifies the three-part ANSI object name. The
object name is hyperlinked to the related object.
• Metadata UID: — The internal UID number of the related object.
• Creation Time: — The time and date when the related object was created. The time and
date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
• Redefinition Time: — The time and date when the related object was last redefined. The
time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing DDL information of a table
To view DDL information related to the table:
1. In the navigation tree, select the table.
Viewing table properties 57
- Release 3.2 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- 6 Contents 6
- About this guide 7
- Related documentation 8
- • Migration guides 9
- • Data management guides 9
- • Online help 9
- Notation Conventions 10
- HP encourages your comments 11
- 1 Introduction to MXDM 12
- MXDM functional flow 13
- 14 Introduction to MXDM 14
- Supported version of SQL/MX 15
- Prerequisites 15
- Installing MXDM 16
- Uninstalling MXDM 16
- Uninstalling MXDM 17 17
- Starting up MXDM 18
- Adding a system 18
- Connecting to a system 19
- Disconnecting from a system 21
- Using the Systems Tool 21
- Editing a system definition 23
- Copying a system definition 23
- Removing a system 24
- Testing a system definition 24
- Exiting MXDM 25
- 4 Navigating MXDM 26
- MXDM banner 27
- Using the MXDM menus 27
- Using the File menu options 28
- Using the Edit menu options 28
- Using the Tools menu options 28
- Using the MXDM toolbar 29
- Selecting an area 30
- Using the My Favorites pane 32
- Using the navigation tree 33
- Using the right pane 35
- Figure 9 Window controls 37
- Working with data grids 40
- Working with data grids 41 41
- Copying data grid information 42
- Customizing the data grid 42
- Searching the data grid 43
- Copying data 44
- Copying data to a browser 45
- 6 Viewing database objects 47
- Viewing catalog attributes 48
- Viewing catalog registrations 48
- Viewing schemas 49
- Viewing schema attributes 50
- Viewing schema views 51
- Viewing schema procedures 51
- Viewing table properties 52
- Viewing table properties 53 53
- Viewing hash key properties 54
- Viewing check constraints 55
- Viewing unique constraints 55
- Viewing table attributes 55
- 56 Viewing database objects 56
- Viewing table properties 57 57
- 58 Viewing database objects 58
- Viewing table properties 59 59
- 60 Viewing database objects 60
- Viewing table properties 61 61
- 62 Viewing database objects 62
- ◦ Delete 63
- ◦ Insert 63
- ◦ Select 63
- ◦ Update 63
- Viewing attributes of a view 66
- 68 Viewing database objects 68
- ◦ CONTAINS SQL 69
- ◦ MODIFIES SQL DATA 69
- ◦ READS SQL DATA 69
- 70 Viewing database objects 70
- 72 Viewing database objects 72
- 74 Viewing database objects 74
- 7 Managing MXCS objects 76
- Stopping an MXCS server 78
- Viewing MXCS Services 78
- Starting up an MXCS service 79
- Stopping an MXCS service 80
- Viewing data sources 81
- Creating a data source 82
- Using General Properties 83
- About DEFINEs 85
- About SETs 86
- Creating a data source 87 87
- If-Locked 88
- Priority 88
- Copying a data source 89
- Starting up a data source 90
- Stopping a data source 90
- Updating a data source 91
- Deleting a data source 91
- Viewing MXCS user permissions 92
- Adding an MXCS user 93
- Editing MXCS user permissions 94
- Deleting an MXCS user 94
- Deleting an MXCS user 95 95
- Interface 96
- Setting Auto Logon options 97
- A Using the SQL Whiteboard 98
- Statement List pane 99
- Statement pane 100
- Page mode 101
- Statement Details pane 102
- Reusing a connection 103
- Highlighting the SQL syntax 104
- Managing the layout of panes 104
- Glossary 105
- 106 Glossary 106
- 108 Index 108
- 110 Index 110
Powiązane produkty i podręczniki dla Sprzęt komputerowy Hp Integrity NonStop J-Series
(110 strony)
(82 strony)© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.025 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji