Login:
Votes - , Average rating: ( )

User manual HP, model HP Integrity NonStop H-Series

Manafacture: HP
File size: 430.63 kb
File name:

Language of manual:enesfrptnn

The document is loading, please wait
The document is loading, please wait


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)

Reviews



Your review
Your name:
Please, enter two numbers from picture:
capcha





Category