Hp Integrity NonStop J-Series Instrukcja Użytkownika Strona 84
- Strona / 110
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
Table 22 General Properties options (continued)
DescriptionOptionGroup
Specifies the number of minutes that a client-server connection remains
idle before the MXCS server terminates the connection.
Connection Idle
Timeout
You must assign a value between 1 and 2,147,483,647. The system
default is 600 seconds.
You must select this option to collect statistics about the connection and
the session. Data source statistics are stored in the Event Monitoring Service
(EMS) log. The event ID is 21035.
Connection
Information
Session Statistics
You must select this option to collect statistics about individual SQL
statements. Data source statistics are stored in the EMS log. The event ID
is 21035.
Session Summary
Specifies the upper limit of the servers that can be operational for a service
on the data source.
MaximumNumber of Servers
The default is 1. The range is 0 to 32767.
0 specifies the system default that is determined by the system at run time.
If you use the default of 1000 ports for MXCS during installation, the range
is 1 through 997.
If you configure more than 1000 ports for MXCS, the value for Maximum
is the number of configured ports minus 3. In this case, the actual maximum
number of MXCS servers can sometimes be greater than the number of
ports configured.
Specifies the lower limit of the available idle MXCS servers that are
operational for a service on the data source.
Idle
The values range from 0 to 32767. The default is 0.
This value cannot exceed the maximum server value.
CAUTION: The sum of all the Idle values for a given system must not
exceed the number of ports specified when the MXCS service was started
up. HP recommends that this sum not exceed 200.
Specifies the suggested number of MXCS servers that each service starts
up when the data source is first started up.
Initial
The default is 0. The values range from 0 to 32767. This value cannot
exceed the maximum server value.
Specifies the priority assigned to a process started for this data source.
The values range from 1 to 199.
InitialProcess Priority
Specifies the priority of the MXOAS process when the servers are created.System Default
Specifies the processing nodes (CPUs) you want to use for this data source.CPU OrderCPU Utilization
Enter a list of CPU numbers, separated by commas. For example:
1,2,4,5,15.
Specifies that the SQL/MX software determines the CPU utilization
automatically.
System Default
Specifies the statistics about individual SQL statements.SQL StatementStatement Statistics
Specifies the statistics about SQLExecute.SQLExecute
Specifies the statistics about SQLPrepare.SQLPrepare
Specifies the statistics about SQLExecDirect.SQLExecDirect
Specifies the statistics about SQLFetch.SQLFetch
See “Adding and modifying the resource management policy” (page 85).AddResource
Management
84 Managing MXCS objects
- 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