Manafacture: HP
File size: 430.63 kb
File name:
![en en](/images/flag/s/en.gif)
![es es](/images/flag/s/es.gif)
![fr fr](/images/flag/s/fr.gif)
![pt pt](/images/flag/s/pt.gif)
![nn nn](/images/flag/s/nn.gif)
![]() |
Other manuals for this model:
manual abstract
Enabling the MXCS Service.................................................................................................27
Disabling the MXCS Service................................................................................................27
Displaying Server Status.....................................................................................................27
Stopping Servers................................................................................................................27
Managing Multiple MXCS Services......................................................................................27
Managing MXCS Server Data Sources.................................................................................27
Managing data sources..........................................................................................................28
Displaying Data Source Status.............................................................................................28
Creating and Configuring Server Data Sources......................................................................28
Configuring MXCS XA Data Source......................................................................................28
Reconfiguring Server Data Sources.......................................................................................29
Using Case-Sensitive table names....................................................................................30
Reconfiguring Character Sets..........................................................................................30
Starting MXCS Data Sources...............................................................................................30
Stopping MXCS Data Sources.............................................................................................30
Deleting MXCS Data Sources..............................................................................................31
Using MXCS with SQL/MP tables.............................................................................................31
Resource Management............................................................................................................31
Adding or Removing a Resource Management Policy..............................................................31
Resource Statistics...................................................................................................................32
Statement Statistics - Statements and Values...........................................................................32
SQL Statement..............................................................................................................32
SQLExecute..................................................................................................................33
SQLExecDirect..............................................................................................................33
SQLPrepare..................................................................................................................34
SQLFetch......................................................................................................................35
Session Statistics - Summaries and Values..............................................................................35
Example resource statistics output for three selected options.....................................................37
Param Caching..................................................................................................................38
Configuring SQLValues..................................................................................................38
Logging Format for SQL Values.......................................................................................38
Sample EMS Log for Select Query...................................................................................39
Table DDL....................................................................................................................39
Limitations of SQLValues ................................................................................................39
Reading SQLValue........................................................................................................40
Collecting Server Statistics...................................................................................................40
Configuring Statistics Collection......................................................................................40
Starting Statistics Collection............................................................................................40
Stopping Statistics Collection..........................................................................................40
Viewing Statistics..........................................................................................................41
Resource Statistics Event Message Format.........................................................................41
Session Statistics: Connection Information.........................................................................42
Session Statistics: Session Summary Information................................................................42
Statement Statistics: SQL Statement..................................................................................43
Statement Statistics: SQLExecute......................................................................................43
Statement Statistics: SQLExecDirect..................................................................................44
Statement Statistics: SQLPrepare......................................................................................45
Statement Statistics: SQLFetch.........................................................................................45
Tracing Server Activity........................................................................................................46
Configuring Server Tracing.............................................................................................46
Starting Server Tracing...................................................................................................46
Stopping Server Tracing.................................................................................................47
Viewing Trace Information..............................................................................................47
Example Server Trace Log for the Connect Function............................................................47
Trace Event Message Format...........................................................................................48
4
Contents
...Other models in this manual:
Desktops - HP Integrity NonStop J-Series (430.63 kb)