HP NonStop G-Series Guide de l'utilisateur Page 98
- Page / 103
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Example Commands and Objects
SQL/MX Connectivity Service Administrative Command Reference—526350-005
A-2
This example starts MXCI and verifies that the service started properly:
mxci
Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface 2.0
(c) Copyright 2003 Hewlett-Packard Development Company, LP.
>>mode mxcs;
CS>info service $as;
-- INFO SERVICE \ODBC.$AS Report
PName State SPid TCP/IP PN Port Last Updated Type
$AS STOP 1,386 $ZTC0 21000 Mar 26 13:37 AS
$Z3445 AVL 1,394 $ZTC0 21001 Mar 26 13:37 CFG
This example creates the DS and uses options that are not optimal for normal use. For
example, its CpuList option limits the servers to running on CPU 0 and 1. It also
starts statistic recording that can reduce performance, fill the logs, and disable idle
server and idle connection timeouts. After starting the servers, they are persistent and
do not end. You can configure the DS without starting a service by using an asterisk (*)
for the service name, which connects it directly to the database. Regardless of how the
DS is created, all existing services immediately see the DS. This DS is created in the
stopped state:
CS>add ds Test_DSN, MaxServer 5, IdleServer 3, InitServer 2, IdleTimeout
+>NO_TIMEOUT, ConnTimeout NO_TIMEOUT, InitPri 140, CpuList '0 1',
+>SQLExecDirectStat, SQLFetchStat, SQLPrepareStat;
-- ADD DS \ODBC.$AS.TEST_DSN Successful
This example adds EVARs to the DS definition:
CS>add evar "ESTIMATED COST", type rmp, limit 500, action stop;
-- ADD EVAR \ODBC.$AS.TEST_DSN.ESTIMATED COST Successful
CS>add evar timeout, value 'reset';
-- ADD EVAR \ODBC.$AS.TEST_DSN.TIMEOUT Successful
This command produces an error because of a misspelled EVAR name:
CS>add evar sratch_disks, value '$data01, $data02, \ODBC.$data03';
-- ADD EVAR \ODBC.$AS.TEST_DSN.SRATCH_DISKS Failed
*** ERROR[15408] Lower layers failed to perform action requested.
*** ERROR[15310] SUBSYSTEM: SQL error from LowLayer, library call
CFGSetEnvironmentValues failed.
*** ERROR[15202] LOWLAYER 1: *** ERROR[2050] SRATCH_DISKS is not the name of any
DEFAULTS table attribute.*** ERROR[8822] Unable to
prepare the statement.
These examples complete adding EVARs and displaying the results:
CS>add evar scratch_disks, value '$data01, $data02, \ODBC.$data03';
-- ADD EVAR \ODBC.$AS.TEST_DSN.SCRATCH_DISKS Successful
CS>add evar EMP, type define, value 'CLASS MAP, FILE $DATA01.PERSNL.EMPLOYEE';
-- ADD EVAR \ODBC.$AS.TEST_DSN.=EMP Successful
CS>info ds, detail;
-- INFO DS \ODBC.$AS.TEST_DSN Report, detailed
Name: \ODBC.$AS.TEST_DSN
CpuList: 0,1
InitPri...........................140 CurrentState..................STOPPED
ConnectedServers....................0 AvailableServers....................0
LastStateChg.............Dec 31 18:00 LastUpdate...............Mar 26 13:39
IdleServer..........................3 IdleTimeout................NO_TIMEOUT
MaxServer...........................5 ConnTimeout................NO_TIMEOUT
InitServer..........................2 StartAutomatic....................OFF
Trace.............................OFF SQLPrepareStat.....................ON
ConnInfoStat......................OFF SQLExecuteStat....................OFF
- SQL/MX Connectivity 1
- Service Administrative 1
- Command Reference 1
- Document History 2
- Legal Notices 3
- SQL/MX Connectivity Service 5
- Administrative Command 5
- Reference 5
- 3. Object Service Commands 6
- 4. Object Server Commands 6
- 5. Object DS Commands 6
- 6. Object EVAR Commands 7
- 7. Object User Commands 7
- Example Commands and Objects 8
- What’s New in This Manual 10
- New and Changed Information 10
- About This Manual 11
- Related Documentation 12
- Notation Conventions 14
- General Syntax Notation 15
- Notation for Messages 16
- Change Bar Notation 18
- 1 MXCS Architecture Overview 19
- Architecture Overview 20
- MXCS Architecture Overview 21
- User Interface With MXCI 22
- General Features 22
- Software Installation 23
- Complex System Configuration 23
- Error Message Overview 25
- 2 MXCS Commands and Objects 29
- MXCS Object Types 30
- Command Termination 31
- Fields or Tokens in Commands 32
- Command Syntax Case 33
- Object Name Components 33
- MXCS Commands and Objects 34
- DS Name and EVAR Name 35
- Default Object Name 35
- Command Size Limit 36
- Empty Quoted Strings 36
- Command Caveats 37
- Security 38
- Example MXCS Configuration 38
- Related Commands 39
- MXCI Mode Command 40
- Session Variables 40
- MXCI Comment 40
- 3 Object Service Commands 41
- INFO SERVICE 42
- Examples—INFO SERVICE 43
- START SERVICE 44
- STOP SERVICE 45
- Considerations—STOP SERVICE 46
- Example—STOP SERVICE 46
- VERSION SERVICE 47
- Object Service Commands 48
- Example—VERSION SERVICE 48
- 4 Object Server Commands 49
- INFO SERVER 50
- Considerations—INFO SERVER 51
- Output Report—INFO SERVER 51
- Example—INFO SERVER 51
- Object Server Commands 52
- STOP SERVER 53
- Example—STOP SERVER 54
- 5 Object DS Commands 55
- TMD_Default_DataSource" 56
- Object DS Commands 57
- Considerations—ADD DS 60
- Examples—ADD DS 61
- ALTER DS 62
- Considerations—ALTER DS 66
- Examples—ALTER DS 66
- DELETE DS 68
- Example—DELETE DS 69
- Considerations—INFO DS 71
- Examples—INFO DS 71
- START DS 74
- Considerations—STOP DS 76
- Examples—STOP DS 76
- 6 Object EVAR Commands 77
- EVAR Order 78
- ADD EVAR 79
- Considerations—ADD EVAR 80
- Example—ADD EVAR 80
- ALTER EVAR 82
- Considerations—ALTER EVAR 83
- Example—ALTER EVAR 84
- DELETE EVAR 85
- Considerations—DELETE EVAR 86
- Example—DELETE EVAR 86
- INFO EVAR 87
- Considerations—INFO EVAR 88
- Example—INFO EVAR 88
- Object EVAR Commands 90
- 7 Object User Commands 91
- ADD USER 92
- ALTER USER 93
- DELETE USER 94
- INFO USER 95
- Object User Commands 96
- Considerations—INFO USER 96
- This example stops the DS: 100
- TACL prompt by entering: 100
- Special Characters 103
Produits connexes et manuels pour Logiciel HP NonStop G-Series
Logiciel HP B6960-96008 Manuel d'utilisateur
(396 pages)
(396 pages)
Logiciel HP rp7410 Guide de l'utilisateur
(266 pages)
(266 pages)
Logiciel HP 11i Manuel d'utilisateur
(113 pages)
(113 pages)
Logiciel HP 41B Manuel d'utilisateur
(44 pages)
(44 pages)
Logiciel HP P6350 Manuel d'utilisateur
(316 pages)
(316 pages)
Logiciel HP CD52ce Manuel d'utilisateur
(109 pages)
(109 pages)
Logiciel HP -UX SNAplus2 Manuel d'utilisateur
(398 pages)
(398 pages)
Logiciel HP D2D2502i Manuel d'utilisateur
(178 pages)
(178 pages)
Logiciel HP Firewall Series Manuel d'utilisateur
(119 pages)
(119 pages)
Logiciel HP tc4400 Guide de l'utilisateur
(86 pages)
(86 pages)
Logiciel HP PROCURVE 2520 Manuel d'utilisateur
(544 pages)
(544 pages)
Logiciel HP 1.x Livre blanc
(16 pages)
(16 pages)
Logiciel HP B6960-90078 Manuel d'utilisateur
(856 pages)
(856 pages)
Logiciel HP 2600-PWR Manuel d'utilisateur
(418 pages)
(418 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.336 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels