HP NonStop G-Series Betriebsanweisung Seite 1

SQL/MX Connectivity Service Administrative Command ReferenceAbstractThis manual describes the ODBC administrative commands running in the HP NonStop™

What’s New in This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005viNew and Changed Information

Example Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-005A-4$Z3503 AVL 0,388 $ZTC0 21007 Mar 2

SQL/MX Connectivity Service Administrative Command Reference—526350-005Index-1IndexAADD commandobject DS 5-2object EVAR 6-3ALTER commandobject DS 5-8o

IndexSQL/MX Connectivity Service Administrative Command Reference—526350-005Index-2LLLeaving MXCS mode 1-4MMessages, error 1-7/1-9Mode command 2-12MXC

IndexSQL/MX Connectivity Service Administrative Command Reference—526350-005Index-3TSystem name, object syntax 2-6TTerminal prompt, MSCS 1-4Terminate

SQL/MX Connectivity Service Administrative Command Reference—526350-005viiAbout This ManualThis manual describes the administrative commands available

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005viiiRelated DocumentationProgramming ManualsSQL/MX Programming

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005ixRelated DocumentationThe NSM/web and Visual Query Planner he

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005xNotation ConventionsThis figure shows the manuals in the SQL/

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005xiGeneral Syntax NotationThis requirement is described under B

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005xiiNotation for Messages… Ellipsis. An ellipsis immediately f

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005xiiiNotation for MessagesNonitalic text. Nonitalic letters, nu

About This ManualSQL/MX Connectivity Service Administrative Command Reference—526350-005xivChange Bar NotationChange Bar NotationChange bars are used

SQL/MX Connectivity Service Administrative Command Reference—526350-0051-11 MXCS Architecture OverviewThe NonStop SQL/MX connectivity service (MXCS) i

Document History Part Number Product Version Published526350-001 MXCS ACL 1.0 April 2004526350-002 MXCS ACL 1.1 ABA August 2004526350-003 MXCS ACL 1.1

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-2Architecture OverviewConfigures a new installatio

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-3Architecture Overviewadministrative command, set M

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-4User Interface With MXCIUser Interface With MXCITh

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-5Software InstallationError messages describe the

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-6Complex System ConfigurationService A. Service A m

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-7Error Message OverviewAll MXCS objects can be view

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-8Error Message OverviewA multiple error message for

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-9Error Message OverviewSome error messages also sug

MXCS Architecture OverviewSQL/MX Connectivity Service Administrative Command Reference—526350-0051-10Error Message Overview

SQL/MX Connectivity Service Administrative Command Reference—526350-0052-12 MXCS Commands and ObjectsThis section describes:MXCS Administrative Comma

Legal Notices Copyright 2013 Hewlett-Packard Development Company L.P. Confidential computer software. Valid license from HP required for possession,

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-2MXCS Object TypesMXCS Object TypesMXCS objects that

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-3Valid Command and Object Type PairsValid Command an

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-4Fields or Tokens in CommandsFields or Tokens in Com

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-5General MXCS Administrative Command SyntaxGeneral M

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-6Object Name ComponentsGeneral syntax is: See indivi

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-7DS Name and EVAR Namegroupname is the group login n

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-8Command Size LimitBut the period is required in thi

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-9Command CaveatsCommand CaveatsUse care when specify

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-10SecuritySecurityMACL has two classes of commands:

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-11Related CommandsNonStop TCP/IP address (-TCP = dri

MXCS Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-0052-12MXCI Mode CommandMXCI Mode CommandThe MXCI MODE co

SQL/MX Connectivity Service Administrative Command Reference—526350-0053-13 Object Service CommandsThis section describes the MXCS administrative comm

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-2INFO SERVICEINFO SERVICEThis command displays the nam

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-3Output Report States—INFO SERVICEOutput Report States

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-4START SERVICESTART SERVICEThis command starts:The ta

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-5STOP SERVICESTOP SERVICEThis command, which executes

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-6Considerations—STOP SERVICEREASON text is a nonempty

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-7VERSION SERVICEVERSION SERVICEThis command returns ve

Object Service CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0053-8Example—VERSION SERVICEThis example does not connect

SQL/MX Connectivity Service Administrative Command Reference—526350-0054-14 Object Server CommandsThis object is the server to which the remote client

Hewlett-Packard Company—526350-005iSQL/MX Connectivity Service Administrative Command ReferenceIndex FiguresWhat’s New in This ManualManual Informati

Object Server CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0054-2INFO SERVERINFO SERVERThis command displays attributes

Object Server CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0054-3Considerations—INFO SERVERConsiderations—INFO SERVERI

Object Server CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0054-4Example—INFO SERVERDetailed report for a server connec

Object Server CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0054-5STOP SERVERSTOP SERVERThis command puts the server in

Object Server CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0054-6Example—STOP SERVERStopping a DS stops all servers it

SQL/MX Connectivity Service Administrative Command Reference—526350-0055-15 Object DS CommandsThis object is a server-side data source (DS) that repre

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-2ADD DSADD DSThis command adds one DS to the MXCS configura

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-3ADD DSexisting DS. The existing DS and the new one must ha

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-4ADD DSConnTimeout timeout-valis a keyword or the number of

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-5ADD DSNonexistent CPU numbers are not reported. Because a

ContentsSQL/MX Connectivity Service Administrative Command Reference—526350-005ii3. Object Service CommandsCommand Size Limit 2-8Single Quotes for Att

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-6Considerations—ADD DSStatistics are written to the collect

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-7Examples—ADD DS Examples—ADD DSThis example creates the DS

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-8ALTER DSALTER DSThis command is similar to the ADD DS comm

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-9ALTER DSIdleServer count is the lower limit on the availab

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-10ALTER DSInitPri [priority-val] is the initial system prio

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-11ALTER DSSQLExecuteStat [OFF] is a flag to turn ON, for th

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-12Considerations—ALTER DSrunning servers using this DS and

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-13Examples—ALTER DSpreserve its lowercase characters. If qu

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-14DELETE DS DELETE DSThis command removes one DS from the M

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-15Example—DELETE DSExample—DELETE DSThis example removes th

ContentsSQL/MX Connectivity Service Administrative Command Reference—526350-005iii6. Object EVAR Commands Examples—ADD DS 5-7ALTER DS 5-8Consideration

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-16INFO DSINFO DSThis command displays attributes of one or

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-17Considerations—INFO DSThe output report contains a column

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-18Examples—INFO DSName: \ODBC.$AS.Mixed Case DSN CpuList:

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-19Examples—INFO DS StartAutomatic Automatic DS s

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-20START DSSTART DSThis command starts one DS on one service

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-21STOP DSSTOP DSThis command stops one DS on all services o

Object DS CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0055-22Considerations—STOP DSDISCONNECTterminates the server but

SQL/MX Connectivity Service Administrative Command Reference—526350-0056-16 Object EVAR CommandsThis section describes the MXCS administrative command

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-2EVAR OrderEVAR OrderUse the INFO EVAR command to determi

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-3ADD EVARADD EVARThis command adds one EVAR to the DS def

ContentsSQL/MX Connectivity Service Administrative Command Reference—526350-005ivA. Example Commands and ObjectsDELETE USER 7-4Considerations—DELETE

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-4Considerations—ADD EVARPREFIX stringis the portion of th

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-5Example—ADD EVARrequired. Use of the specific service $A

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-6ALTER EVARALTER EVARThis command modifies one existing E

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-7Considerations—ALTER EVARPREFIX stringis the portion of

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-8Example—ALTER EVAROmitting all parameters causes an err

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-9DELETE EVARDELETE EVARThis command removes the named EVA

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-10Considerations—DELETE EVARConsiderations—DELETE EVARDE

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-11INFO EVARINFO EVARThis command displays the named EVAR

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-12Considerations—INFO EVARConsiderations—INFO EVARINFO E

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-13Example—INFO EVARCONTROL QUERY DEFAULT HIST_NO_STATS_UE

SQL/MX Connectivity Service Administrative Command Reference—526350-005vWhat’s New in This ManualManual InformationSQL/MX Connectivity Service Adminis

Object EVAR CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0056-14Example—INFO EVAR

SQL/MX Connectivity Service Administrative Command Reference—526350-0057-17 Object User CommandsThis section describes the MACL commands that are avai

Object User CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0057-2ADD USERADD USERThis command adds one user name and perm

Object User CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0057-3ALTER USERALTER USERThis command changes one user’s perm

Object User CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0057-4DELETE USERDELETE USERThis command deletes one user name

Object User CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0057-5INFO USERINFO USERThis command displays user names and p

Object User CommandsSQL/MX Connectivity Service Administrative Command Reference—526350-0057-6Considerations—INFO USER

SQL/MX Connectivity Service Administrative Command Reference—526350-005A-1AExample Commands and ObjectsThe appendix provides examples to:Start an MXC

Example Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-005A-2This example starts MXCI and verifies that the s

Example Commands and ObjectsSQL/MX Connectivity Service Administrative Command Reference—526350-005A-3SessionInfoStat......OFF SQLExe