NonStop S シリーズ・サーバー入門

Transcription

1 NonStop S NonStop S S J J -1

2 Document History Part Number Product Version Published N.A. February 1998 New editions incorporate any updates issued since the previous edition. A plus sign(+) after a release ID indicates that this manual describes function added to the base release, either by an interim product modification(ipm) or by a new product version on a.99 site update tape(sut). Ordering Information For manual ordering information: domestic U.S. customers, call ; international customers, contact your local sales representative. Document Disclaimer Export Statement Examples Information contained in a manual is subject to change without notice. Please check with your authorized Tandem representative to make sure you have the most recent information. Export of the information contained in this manual may require authorization from the U.S Department of Commerce. Examples and sample programs are for illustration only and may not be suited for your particular purpose. Tandem does not warrant, guarantee, or make any representations regarding the use or the results of the use of any examples or sample program in any documentation. You should verify the applicability of any example or sample program before placing the software into productive use. U. S.Government Customers FOR U.S. GOVERNMENT CUSTOMERS REGARDING THIS DOCUMENTATION AND THE ASSOCIATED SOFTWARE; These notices shall be marked on any reproduction of this data, in whole or in part. NOTICE: Notwithstanding any other lease or license that may pertain to, or accompany the delivery of, this computer software, the rights of the Government regarding its use, reproduction and disclosure are as set forth in Section of the FARS Computer Software-Restricted Rights clause. RESTRICTED RIGHTS NOTICE: Use, duplication or disclosure by the Government is subject to the restrictions as set forth in subparagraph(c)(1)(ii) of the Rights in Technical Data and Computer Software clause at DFARS RESTRICTED RIGHTS LEGEND: Use, duplication or disclosure by the Government is subject to the restrictions as set forth in paragraph(b)(3)(b) of the Rights in Technical Data and Computer Software clause at DAR (a). This computer software is submitted with restricted rights. Use, duplication or disclosure is subject to the restrictions as set forth in NASA FAR SUP (April 1985) Commercial Computer Software - Restricted Rights (April 1985). If the contract contains the Clause at Rights in Data General then the Alternate III clause applies. U. S Government Users Restricted Rights Use, duplications or disclosure restricted by GSA ADP Schedule Contract. Unpublished All rights reserved under the Copyright Laws of the United States J

3 ...vii...vii...ix...ix...ix...x...x NonStop S TSM...xxii OLTP OLTP OLTP J i

4 OLTP OLTP OLTP OLTP Pathway NonStop TUXEDO NonStop SQL/MP NonStop SQL/MP OLTP NonStop SQL/MP NonStop SQL/MP SQL/MP DSS TMF TMF ii J

5 NonStop SQL/MP TMF NonStop CPU Expand NonStop S NonStop S I/O J iii

6 7 7.1 SNA SNAX/XF SNAX/APN SNA SNAX/XF SNAX/APN SNA NonStop S... xii 2 NonStop S...xv 3 NonStop S... xvii 4 TSM...xix OLTP OLTP OLTP OLTP NonStop TS/MP iv J

7 NonStop SQL/MP SQL SQL (SQLCI) OLTP NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP TMF TMF TMF NonStop TS/MP NonStop SQL/MP NonStop TM/MP NonStop UNIX NonStop S Expand CPU I m alive Expand NonStop S NonStop S NonStop S I/O J v

8 NonStop S SNA SNA ATM x... xxii vi J

9 NonStop S S G J Introduction to Tandem NonStop S-Series Servers J vii

10 NonStop S ServerNet 1 NonStop K NonStop NonStop S NonStop K (OLTP) NonStop S OLTP OLTP NonStop S NonStop K UNIX NonStop S S (DSS) DSS OLTP NonStop TS/PM Pathway/TS Introduction to NonStop Transaction Processing NonStop S S NonStop S K Introduction to Tandem NonStop System NonStop J ix

11 NonStop 6 NonStop S 7 NonStop S 4 NonStop S NonStop S NonStop S TSM xi xv xvii xix NonStop S x J

12 NonStop S NonStop S NonStop S NonStop S 1 NonStop S J xi

13 1 NonStop S Reference G-Series Highlights and Migration Planning Guide NonStop S-Series Publications Note NonStop S-Series Server Description Manual NonStop S-Series System Console Back Panels Introduction to Tandem NonStop S-Series Servers Change Planning and Control G-Series Highlights and Migration Planning Guide NonStop S-Series Planning and Configuration Guide Installation G05.00 Software Installation and Upgrade Guide NonStop S-Series Hardware Installation Guide Operations and Support NonStop S-Series Operations Guide NonStop S-Series Hardware Support Guide NonStop S-Series Service Provider Supplement CDT 004.CDD xii J

14 G-Series Highlights and Migration Planning Guide G NonStop S G D D43 G02 G02 G03 G03 G04 G04 G05 G NonStop S-Series Publications Note NonStop S G05.00 NonStop S-Series Server Description Manual NonStop S NonStop S-Series System Console Back Panels NonStop S TSM CD-ROM NonStop S G-Series Highlights and Migration Planning Guide G NonStop S G xiii NonStop S-Series Planning and Configuration Guide NonStop S ServerNet (ServerNet SAN) NonStop S J xiii

15 G05.00 Software Installation and Upgrade Guide G NonStop S G05.00 NonStop NonStop S-Series Hardware Installation Guide NonStop S (TSM) NonStop S NonStop S-Series Operations Guide NonStop S NonStop S-Series Hardware Support Guide NonStop S (CRU) CRU CRU CRU CRU CRU NonStop S-Series Service Provider Supplement (CRU) 19 (FRU) CRU NonStop S NonStop S7000 NonStop S70000 NonStop S-Series Service Provider Supplement xiv J

16 NonSto S NonStop S NonStop S 2 NonStop S 2 NonStop S 5190/5194 Modular Tape Subsystem Manual 6740 ServerNet/FX Adapter Installation Guide 6760 ServerNet/DA Manual ServerNet/FX Adapter Configuration and Management Manual LAN Configuration and Management Manual SCF Reference Manual for the Kernel Subsystem SCF Reference Manual for the Storage Subsystem SWAN Concentrator Installation and Maintenance Guide Token Ring ServerNet Hardware Installation Guide WAN Subsystem Configuration and Management Manual 5190/5194 Modular Tape Subsystem Manual 5190/ / ServerNet/FX Adapter Installation Guide ServerNet/FX ServerNet/FX 6760 ServerNet/DA Manual 6760 ServerNet/DA Manual NonStop S 6760 ServerNet/DA J xv

17 ServerNet/FX Adapter Configuration and Management Manual NonStop S ServerNet/FX ServerNet/FX (SCF) Expand LAN Configuration and Management Manual NonStop S ServerNet LAN (SLSA) SLSA (SCF) NonStop S SLSA SCF Reference Manual for the Kernel Subsystem NonStop S (SCF) SCF NonStop S SCF Reference Manual for the Storage Subsystem NonStop S (SCF) SWAN Concentrator Installation and Maintenance Guide NonStop S ServerNet (SWAN) SWAN Token Ring ServerNet Hardware Installation Guide NonStop S ServerNet I/O WAN Subsystem Configuration and Management Manual NonStop S ServerNet (SWAN) WAN WAN (SCF) WAN SWAN xvi J

18 S NonStop S 3 NonStop S 3 NonStop S Stem Manual NonStop S-Series Planning and Configuration Guide Core Configuration Manuals DSM/SCM User s Guide Kernel- Managed Swap Facility (KMSF) Manual SCF Reference Manual for G-Series Releases System Generation Manual for G-Series Releases CDT 005.CDD J xvii

19 NonStop S-Series Planning and Configuration Guide NonStop S xiii DSM/SCM User s Guide (DSM/SCM) DSM/SCM NonStop S Kernel-Managed Swap Facility (KMSF) Manual (KMSF) KMSF TNS/R TNS NSKCOM KMSF NonStop SCF Reference Manual for G-Series Releases G (SCF) SCF SCF SCF System Generation Manual for G-Series Releases SYSGENR G CONFTEXT SYSGENR NonStop S xviii J

20 TSM TSM (TSM) NonStop S 4 TSM 4 TSM Printed Manual TSM Configuration Guide CD-ROM Based TSM Online User Guide Online TSM Configuration Application Online Help TSM EMS Event Viewer Application Online Help TSM Low-Level Link Application Online Help TSM Notification Director Application Online Help TSM Service Application Online Help CDT 006.CDD TSM Configuration Guide (TSM) NonStop S TSM TSM NonStop S J xix

21 TSM Online User Guide (TSM) TSM TSM TSM TSM Configuration Application online help TSM Configuration Application online help (TSM) TSM TSM EMS Event Viewer Application online help TSM EMS Event Viewer Application online help EMS (TSM) (EMS) TSM Low-Level Link Application online help TSM Low-Level Link Application online help (TSM) Windows TSM TSM NonStop S TSM Notification Director Application online help TSM Notification Director Application online help (TSM) TSM Service Application online help TSM Service Application online help (TSM) Windows TSM NonStop TSM NonStop S xx J

22 NonStop S Guardian User s Guide Open System Services Programmer s Guide (OSS) NonStop S Introduction to NonStop Transaction Processing Introduction to NonStop Transaction Manager/PM (TM/MP) NonStop TM/MP Introduction to NonStop SQL/MP NonStop SQL/MP Introduction to Tandem Networking and Data Communications for NonStop S-Series Servers 7 SNAX Introduction to SNA Capabilities of Tandem NonStop Systems IBM (SNA) J xxi

23 NonStop S-Series Planning and Configuration Guide NonStop S ServerNet (ServerNet SAN) NonStop S NonStop S-Series Server Description Manual NonStop S NonStop S TSM 2 NonStop S TSM 2 (1/4) G-Series Highlights and Migration Planning Guide NonStop S-Series Publications Note NonStop S-Series Server Description Manual NonStop S-Series System Console Back Panels Introduction to Tandem NonStop S-Series Servers G-Series Highlights and Migration Planning Guide xxii J

24 2 (2/4) 5190/5194 Modular Tape Subsystem Manual 6740 ServerNet/FX Adapter Installation Guide 6760 ServerNet/DA Manual DSM/SCM User s Guide G05.00 Software Installation and Upgrade Guide G-Series Highlights and Migration Planning Guide NonStop S-Series Hardware Installation Guide NonStop S-Series Planning and Configuration Guide Token Ring ServerNet Hardware Installation Guide TSM Configuration Guide G-Series Highlights and Migration Planning Guide NonStop S-Series Planning and Configuration Guide SCF Reference Manual for G-Series Releases SCF 6740 ServerNet/FX Adapter Installation Guide ServerNet/FX Adapter Configuration and Management Manual 6760 Server/NetDA Manual LAN Configuration and Management Manual SCF Reference Manual for the Kernel Subsystem SCF Reference Manual for the Storage Subsystem SWAN Concentrator Installation and Maintenance Guide WAN Subsystem Configuration and Management Manual J xxiii

25 2 (3/4) 5190/5194 Modular Tape Subsystem Manual 6740 ServerNet/FX Adapter Installation Guide 6760 ServerNet/DA Manual NonStop S-Series Hardware Installation Guide Token Ring ServerNet Hardware Installation Guide DSM/SCM User s Guide G05.00 Software Installation and Upgrade Guide NonStop S-Series Planning and Configuration Guide Kernel-Managed Swap Facility (KMSF) Manual SCF Reference Manual for G-Series Releases System Generation Manual for G-Series Releases 6740 ServerNet/FX Adapter Installation Guide ServerNet/FX Adapter Configuration and Management Manual 6760 ServerNet/DA Manual LAN Configuration and Management Manual SWAN Concentrator Installation and Maintenance Guide Token Ring ServerNet Hardware Installation Guide WAN Subsystem Configuration and Management Manual xxiv J

26 2 (4/4) NonStop S-Series Planning and Configuration Guide TSM Configuration Application online help TSM Configuration Guide TSM Notification Director Application online help TSM Online User Guide 5190/5194 Modular Tape Subsystem Manual NonStop S-Series Operations Guide TSM EMS Event Viewer Application online help TSM Low-Level Link Application online help TSM Notification Director Application online help TSM Online User Guide TSM Service Application online help NonStop S-Series Hardware Support Guide NonStop S-Series Operations Guide NonStop S-Series Service Provider Supplement TSM Configuration Application online help TSM EMS Event Viewer Application online help TSM Low-Level Link Application online help TSM Online User Guide TSM Service Application online help J xxv

27 1 1 OLTP NonStop S NonStop /MP NonStop TS/MP NonStop SQL/MP NonStop /MP NonStop TM/MP 5 6 NonStop S 7 NonStop S OLTP NonStop S (DSS) DSS OLTP DSS 1.1 OLTP ATM 1-1 OLTP J 1-1

28 1 1-1 Host Computer Transaction Entry Application Database Updates Database CDT 004.CDD OLTP 1-2 \NY \SF \CH \MO OLTP OLTP J

29 1 1-2 \SF \MO \CHI \NY Sales \MO Sales Sales Sales CDT 001.CDD 1.2 OLTP 1-1 OLTP OLTP OLTP NonStop S J 1-3

30 1 1.3 OLTP OLTP 24 ATM ATM OLTP I/O OLTP OLTP 1.4 A 5 5 CPU J

31 1 OLTP 1.5 OLTP OLTP 1.6 OLTP OLTP OLTP ATM ID J 1-5

32 1 TPS OLTP 1 OLTP : Transactions Per Minute Time of Day CDT 002.CDD OLTP OLTP J

33 1 1.7 OLTP OLTP 4 A B A B OLTP J 1-7

34 1 1-4 OLTP San Francisco Chicago New York Kansas City CDT 003.CDD 1.8 OLTP NonStop S J

35 1 IBM DEC Sun NonStop S S-Series IBM System SNAX/XF TCP/IP Local Area Network Local Area Network DEC HP IBM Terminals UNIX Workstations CDT 009.CDD NonStop S UNIX DEC Hewlett-Packard IBM 7 1 OLTP OLTP IBM J 1-9

36 1 1.9 OLTP OLTP OLTP OLTP 1-6 MS-DOS Windows NT (PC) UNIX Macintosh ATM 1-6 Workstation Personal Computer Applications Database Terminal ATM CDT 006.CDD OLTP OLTP J

37 1 OLTP PC OLTP PC OLTP PC OLTP PC (GUI) OLTP OLTP PC OLTP PC PC PC 1-7 GUI GUI PC PC PC OLTP OLTP PC J 1-11

38 1 1-7 Sales Order Account Number: Item Number: Description: Price Each: Quantity: Total Amount: OK Cancel UNIX UNIX UNIX OLTP UNIX UNIX OLTP 1.10 OLTP J

39 1 1-8 OLTP Business Operations Business Systems Business Data (Distributed) Maintains Customer and Corporate Financial Data Corporate Headquarters System Accounts Payable/Receivable Application Financial Data Communication Lines Customers and Salespersons Call in Orders or Inquire About Customer Orders Regional Sales Office System Sales Order Application Local Customer Data Order Data Communication Lines Maintains Inventory Files and Ships Customer Orders Regional Warehouse System Inventory Control Application Shipment Data Inventory Data CDT 005.CDD J 1-13

40 1 2 OLTP OLTP 1.11 OLTP OLTP 1-9 OLTP OLTP 1 IBM DEC OLTP OLTP J

41 1 1-9 OLTP Host Computer Transaction Entry Application Functions Business Growth CDT 007.CDD J 1-15

42 DSS NonStop S NonStop SQL/MP NonStop ODBC Server NonStop SQL/MP NonStop SQL/MP NonStop ODBC Server 1-10 Operational Systems Central NonStop S-Series Server Local data NonStop ODBC Server NonStop SQL/MP Local data Data Warehouse Local data CDT 008.CDD J

43 1 DSS OLTP DSS DSS DSS DSS OLTP DSS DSS 3-9 NonStop SQL/MP DSS PC NonStop S DSS 3-14 SQL/MP DSS J 1-17

44 2 2 (OLTP) 2.1 OLTP NonStop S OLTP NonStop S TUXEDO Pathway OLTP NonStop S OLTP NonStop S OLTP OLTP OLTP 2-1 OLTP J 2-1

45 2 2-1 OLTP Data Integrity: NonStop TM/MP TP Monitor Environment: Several choices Transaction Services: NonStop TS/MP Operating System Services: NonStop Kernel Database Access: NonStop SQL/MP Enscribe Core Services CDT 010.CDD J

46 2 2.2 OLTP TP OLTP NonStop S NonStop S NonStop S NonStop S NonStop S Pathway NonStop TUXEDO OLTP 2-18 NonStop TS/MP OLTP J 2-3

47 2 2.3 OLTP OLTP NonStop S NonStop S NonStop S NonStop S OLTP 2.4 OLTP OLTP 2-2 (PC) ATM Macintosh NonStop S J

48 2 2-2 Transaction Entry Database Access CDT 011.CDD 2.5 OLTP 2-3 OLTP OLTP 2-3 Client: Performs workstation-oriented functions Requests information on user's behalf Server: Performs database-oriented functions Provides information service to user Client Server CDT 012.CDD J 2-5

49 2 PC Macintosh NonStop S 2-4 OLTP 2-4 Graphical User Interface Host Computer Client Presentation Application Server Application Data management CDT 018.CDD J

50 2 NonStop S UNIX MS-DOS OS/2 Microsoft Windows Microsoft Windows NT Macintosh Pathway UNIX Pathway NonStop TUXEDO Pathway (API) NonStop S J 2-7

51 2 2-5 Screen Presentation and Data Entry Order Entry Network Access Transaction Processing Environment NonStop TS/MP Routing to Servers Servers Order Entry CDT 013.CDD NonStop /MP NonStop TS/MP NonStop TS/MP 2-9 NonStop S (API) API API NonStop S NonStop TUXEDO TUXEDO (ATMI) API Pathway (RSC) API API API Pathway Pathway ATM POS API API Introduction to NonStop Transaction Processing NonStop TUXEDO RSC API COBOL C C J

52 2 2.7 OLTP NonStop TS/MP NonStop TS/MP NonStop TS/MP 1 PATHMON PATHMON NonStop TS/MP 1 LINKMON LINKMON Pathway/XM NonStop TS/MP Pathway Pathway/XM J 2-9

53 2 2-6 NonStop TS/MP Order Entry Transaction Processing Environment Credit Check Customer Database Order Entry NonStop TS/MP Build Order Order Database Order Entry Update Inventory Inventory Database CDT 014.CDD 2-6 COBOL85 C C++ FORTRAN BASIC TAL ptal NonStop TUXEDO Pathway 2-7 OLTP NonStop TUXEDO API Pathway RSC API NonStop TUXEDO J

54 2 2-7 Clients Using NonStop TUXEDO API NonStop S-Series Server TUX2PWY Translation Server Pathway Application Servers PWY2TUX Translation Server TUXEDO Application Servers Clients Using RSC API CDT 020.CDD OLTP OLTP 1 NonStop S OLTP J 2-11

55 2 2-8 Order Entry Order Entry Transaction Processing Environment Processor 1 Credit Check Customer Database Order Entry Processor 2 Build Order Order Database Processor 3 Update Inventory Inventory Database CDT 015.CDD NonStop S NonStop TUXEDO (WSL) NonStop TUXEDO NonStop TUXEDO (WSH) J

56 2 2-9 Order Entry Order Entry Order Entry WSH LINKMON Processor 1 WSL Credit Check 1 Processor 2 Customer Database LINKMON Build Order Order Database Processor 3 Order Entry Order Entry Order Entry WSH LINKMON Update Inventory Credit Check 2 Inventory Database CDT 016.CDD LINKMON LINKMON NonStop TS/MP 1 NonStop S J 2-13

57 Order Entry Network Node Order Entry NonStop TS/MP Credit Check Customer Database Order Entry Transaction Processing Environment Build Order Order Database Shipment Status Network Node Shipment Status NonStop TS/MP Relieve Inventory Inventory Database Shipment Status Transaction Processing Environment CDT 017.CDD NonStop TS/MP J

58 2 NonStop TS/MP NonStop TS/MP 2.11 OLTP NonStop TS/MP PATHMON Pathway/XM Pathway/XM J 2-15

59 OLTP OLTP 2-11 NonStop TS/MP 2-11 Workstations Adminstrative Interface NonStop TS/MP PATHMON LINKMON Servers Servers Dynamic reconfiguration of online environment Add or redistribute servers through the PATHMON process Manage communication links between clients and servers through the LINKMON process CDT 019.CDD OLTP PATHMON LINKMON PATHMON OLTP LINKMON Pathway PATHMON OLTP NonStop TUXEDO NonStop TUXEDO NonStop TS/MP NonStop TS/MP Pathway/XM J

60 OLTP OLTP OLTP Pathway Pathmaker Pathmaker Pathmaker Pathway (POET) Microsoft Windows Windows NT Pathway Pathway POET KaseWork CASE:W Microsoft Visual BASIC Pathway POET POET OLTP OLTP Pathway PATHMON Pathway/XM NonStop TUXEDO NonStop TUXEDO J 2-17

61 OLTP OLTP PATHMON NonStop S NonStop TS/MP OLTP Introduction to NonStop Transaction Processing 2.14 Pathway NonStop TUXEDO Pathway Pathway Pathway (RSC) Pathway RSC RSC NonStop S RSC MS-DOS UNIX Macintosh Windows Windows NT OS/ J

62 2 Pathway/TS NonStop S Pathway Pathway/TS SCREEN COBOL API Pathway/TS LINKMON (TCP) Pathway RSC Pathway Pathway Pathway (GDSX) ATM POS Pathway Pathway/XM NonStop TS/MP Pathway/TS Pathway/XM NonStop TS/MP Pathway/ TS Pathway (API) GDSX Pathway Introduction to NonStop Transaction Processing NonStop TUXEDO NonStop TUXEDO BEA Systems TUXEDO TUXEDO TUXEDO OLTP TUXEDO TUXEDO (ATMI) TUXEDO API NonStop S 24 CPU CPU J 2-19

63 2 Pathway NonStop TUXEDO TUXEDO Pathway Pathway TUXEDO TUXEDO API WINDOWS 3.1 WINDOWS 95 WINDOWS NT SUN Solaris SUN OS/2(32- ) Macintosh HP/UX AIX Open System Services S4000 TUXEDO API TX XATMI XA XAP-TP TxRPC X/Open NonStop S TUXEDO TUXEDO NonStop TS/ MP NonStop TM/MP J

64 3 3 NonStop SQL/MP Enscribe NonStop SQL/MP Pathway TUXEDO NonStop SQL/ MP DSS TP Enscribe NonStop SQL/MP NonStop SQL/MP Introduction to NonStop SQL/MP Enscribe Enscribe Programmer s Guide (DBMS) DBMS DBMS DBMS 3.1 NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP SQL NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP OLTP NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP SQL OLTP J 3-1

65 3 OLTP DBMS SQL NonStop SQL/MP DBMS NonStop SQL/MP 3.2 NonStop SQL/MP 3-1 NonStop SQL/MP EMPLOYEE DEPARTMENT JOB EMPLOYEE JOB JOBCODE EMPLOYEE DEPARTMENT DEPTNUM SQL SELECT (EMPNUM) NonStop SQL/ MP SALARY DEPTNAME JOBDESC J

66 3 3-1 NonStop SQL/MP JOB TABLE JOBCODE JOBDESC MANAGER ASSEMBLER DEPARTMENT TABLE DEPTNUM DEPTNAME MGR RPTDEPT LOCATION 1000 FINANCE CHICAGO 1500 PERSONNEL CHICAGO CHICAGO EMPLOYEE TABLE EMPNUM FNAME LNAME DEPTNUM JOBCODE SALARY 1 ROGER GREEN JERRY HOWARD JESSICA CRINER CDT 021.CDD 3.3 NonStop SQL/MP 3-2 EMPLOYEE DEPARTMENT J 3-3

67 EMPLOYEE TABLE EMPNUM FNAME LNAME DEPTNUM JOBCODE SALARY 1 23 ROGER JERRY GREEN HOWARD JESSICA CRINER DEPARTMENT TABLE DEPTNUM DEPTNAME MGR RPTDEPT LOCATION 1000 FINANCE CHICAGO 1500 PERSONNEL CHICAGO VIEW CHICAGO FNAME LNAME DEPTNAME JERRY HOWARD FINANCE ROBERT WHITE PERSONNEL ROGER GREEN CORPORATE CDT 022.CDD VIEW1 3-2 FNAME LNAME DEPTNAME OLTP Jerry Howard SELECT DEPTNAME FROM VIEW1 WHERE FNAME = "JERRY" AND LNAME = "HOWARD"; J

68 3 3.4 NonStop SQL/MP NonStop SQL/MP EMPLOYEE EMPNUM LNAME FNAME NonStop SQL/MP NonStop SQL/MP 3.5 NonStop SQL/MP ANSI SQL NonStop SQL/MP CREATE ALTER DROP SELECT INSERT DELETE UPDATE SQL OLTP 3-3 EMPLOYEE SELECT NonStop SQL/MP (DEPTNUM) 4000 (FNAME) (LNAME (EMPNUM) J 3-5

69 3 3-3 SQL EMPLOYEE TABLE EMPNUM 1 23 FNAME ROGER JERRY LNAME GREEN HOWARD DEPTNUM JOBCODE SALARY JESSICA CRINER SELECT FN A M E,LNAM E,EM PNUM FROM EM PLOYEE WHERE DEPTNUM = 4000; FN A M E LNAM E EM PNUM RO GER TERRY GREEN LEE CDT 023.CDD 3-3 CEO CEO CEO 3-3 EMPLOYEE CEO 1 SELECT NonStop SQL/MP SQL 1 UPDATE DELETE NonStop SQL/MP SQL SQL EMPLOYEE 5 EMPLOYEE J

70 3 SQL UPDATE C EXEC SQL DECLARE salary_bonus CURSOR FOR UPDATE employee SET salary = salary * 1.05 WHERE CURRENT OF CURSOR salary_bonus; 3.6 NonStop SQL/MP SQLCI (SQL Conversational Interface) SQL 3-4 SQLCI SQLCI SQLCI 3-4 SQL (SQLCI) SQLCI CDT 024.CDD 3-4 SELECT SQLCI SELECT SQLCI SQLCI J 3-7

71 3 EMPLOYEE 4000 OUT_REPORT $S.#PRINT; SET list_count 0; SELECT fname, lname, empnum FROM employee WHERE deptnum = 4000; REPORT TITLE "Employee List, Dept 4000"; DETAIL fname HEADING "Employee Name", lname NOHEAD, empnum HEADING "Number"; LIST ALL; 3.7 NonStop SQL/MP SQL TAL (Transaction Application Language) COBOL85 C SQL NonStop SQL/MP NonStop SQL/MP SQL C SQL EMPLOYEE 5 UPDATE UPDATE SQL UPDATE EXEC SQL SQL UPDATE EXEC SQL UPDATE employee SET salary = salary WHERE CURRENT OF CURSOR salary_bonus; 3.8 NonStop SQL/MP OLTP NonStop SQL/MP OLTP SQL TAL COBOL85 C SQL NonStop SQL/ MP 3-5 OLTP NonStop SQL/MP J

72 3 3-5 OLTP NonStop SQL/MP Client Program Server Program The server program contains NonStop SQL/MP statements. CDT 025.CDD NonStop SQL/MP OLTP Pathway NonStop TUXEDO NonStop SQL/MP OLTP NonStop SQL/MP 3.9 NonStop SQL/MP NonStop SQL/MP PC NonStop ODBC Server ODBC (DSS) PC 3-6 PC NonStop SQL/MP NonStop ODBC Server J 3-9

73 3 3-6 NonStop SQL/MP Adjust_Salary Employee name: Graphical User Interface Percentage increase: OK Cancel Tandem Host Client program with ODBC calls ODBC Server NonStop SQL/MP CDT 071.CDD NonStop ODBC Server Microsoft ODBC (Open Database Connectivity) NonStop SQL/MP Microsoft ODBC Windows Windows NT PC API NonStop ODBC Server ODBC API CORE SQL NonStop SQL/MP NonStop ODBC Server PC ODBC (GUI) ODBC ODBC API NonStop SQL/MP NonStop SQL/MP NonStop ODBC Server ODBC API NonStop ODBC ODBC SQL NonStop ODBC Server Microsoft Sybase SQL Server API SQL Server ODBC PC J

74 NonStop SQL/MP NonStop SQL/MP SQL NonStop SQL/MP SQL ANSI ISO COBOL85 C ANSI SQL 3.11 NonStop SQL/MP SQL NonStop SQL/MP NonStop SQL/MP NonStop S 3-7 NonStop SQL/MP 3-7 NonStop SQL/MP 4n Transactions Per Second 3n 2n n Number of Processors CDT 026.CDD J 3-11

75 3 3-7 NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP NonStop SQL/MP OLTP 3-8 NonStop SQL/MP NonStop S 3-8 A B C NonStop SQL/MP A A B 6000 C A J

76 3 3-8 NonStop SQL/MP Customer Numbers: Customer Numbers: CDT 027.CDD 3.13 NonStop SQL/MP SQL SQL TABLES VIEWS INDEXES SQL PROGRAMS NonStop SQL/MP SQL SQL SQL SQL SQL SQL J 3-13

77 3 NonStop SQL/MP COMMENT SQL SQL COMMENTS 3.14 SQL/MP DSS (DSS) PC NonStop SQL/MP 3-9 NonStop SQL/MP PC DSS 1-15 DSS DSS DSS No Stop SQL/MP DSS (MDAM) (KSMJ) SQL NonStop SQL/MP (ESP) 1 DSS J

78 3 NonStop SQL/MP I/O DataLoader/MP NonStop SQL/MP NonStop SQL/MP ESP NonStop SQL/MP ESP J 3-15

79 4 4 NonStop TS/MP OLTP NonStop SQL/MP OLTP NonStop /MP NonStop TM/MP NonStop TM/MP TMF TMF TMF 4.1 TMF TMF OLTP J 4-1

80 4 4-1 $5000 $50 $1000 $4000 $ Money-Transfer Transaction Database Records Savings Balance Checking Balance Transaction Begins $5000 $50 Savings Account Debited $1000 $4000 $50 Failure Point Checking Account Credited $1000 $4000 $1050 Transaction Ends $4000 $1050 CDT 028.CDD $1000 $1000 TMF TMF 4-1 TMF $5000 $ J

81 4 $4000 $1050 TMF 4.2 TMF OLTP TMF TMF 1 BEGIN TRANSACTION END TRANSACTION TMF BEGIN TRANSACTION Read stock record from inventory database. Enough stock? Write order detail record to sales order database. Need to reorder? Issue purchase order to purchase order database. Update stock record in inventory database. END TRANSACTION BEGIN TRANSACTION END TRANSACTION TMF TMF TMF TMF J 4-3

82 4 4-2 TMF Order Entry System Databases BEGIN TRANSACTION Read stock record. Enough stock? Write order detail record. Need to reorder? Issue purchase order. Update stock record. END TRANSACTION Sales Office Headquarters Warehouse CDT 029.CDD TMF BEGIN TRANSACTION END TRANSACTION END TRANSACTION TMF NonStop S TMF 1 Expand TMF 1 TMF J

83 4 4.4 TMF 4-3 TMF TMF TMF 4-3 Order Entry System Databases Mirrored Audit Trail Update #1 Begin Locked Sales Office Before After Update #2 Locked Headquarters Update #3 Locked Warehouse CDT 030.CDD 4-3 TMF J 4-5

84 4 TMF TMF TMF 4.5 TMF TMF 4-4 END TRANSACTION END TRANSACTION TMF 2. TMF 3. TMF J

85 4 4-4 Databases Mirrored Audit Trail Begin Unlocked Sales Office Before After End Commit Unlocked Headquarters Unlocked Warehouse CDT 031.CDD TMF 4.6 TMF TMF TMF TMF 4-5 TMF J 4-7

86 4 4-5 Databases Mirrored Audit Trail Begin Stock shortage Commit Recover volumes. Report shortage. Log additional orders until stock replenished. Unlocked Sales Office Unlocked Headquarters Before After Unlocked Warehouse CDT 032.CDD 4-5 TMF TMF TMF J

87 4 $1500 $500 $2000 TMF ($2000) ($1500) TMF TMF TMF 4.7 TMF TMF J 4-9

88 4 TMF TMF TMF TMF J

89 4 4-6 TMF Databases Sales Office Audit Trail Headquarters Audit Trail Warehouse Power Outage Warehouse Power Restored Audit Trail CDT 033.CDD 4.8 TMF J 4-11

90 4 4-7 TMF Databases Online Dump Sales Office Audit Trail Audit Trail Dumped Headquarters Audit Trail Last Online Dump Catastrophe! Dual Media Failure Warehouse Warehouse Database Restored Audit Trail Audit Dump Tape CDT 034.CDD TMF 1. A D B J

91 4 A6 QOH D7 QOH B9 QOH TMF A6 QOH D7 QOH B9 QOH NonStop SQL/MP TMF TMF OLTP TMF TMF TMF NonStop TS/MP NonStop SQL/MP OLTP Pathway NonStop TUXEDO NonStop TS/ MP NonStop SQL/MP NonStop TM/MP J 4-13

92 4 4-8 NonStop TS/MP NonStop SQL/MP NonStop TM/MP NonStop TS/MP Pathway NonStop SQL/MP Microsoft Windows PoetBeginTransaction PoetEndTransaction TMF POET POET Pathway EXEC SQL C NonStop SQL/MP 4-8 OLTP (RDF) RDF TMF RDF J

93 4 4-8 NonStop TS/MP NonStop SQL/MP NonStop TM/MP Update Salary Bonus Rate: Salary Range High: Low: Accept/Display Data OK Cancel Client Program Send Requests Return Replies Server Program Update Data Select Data Business Data Data Dictionary /* Begin Transaction */ PoetBeginTransaction(...)... Display dialog box Accept data to update database:bonus rate, low salary, high salary... /* Send message to server */ PoetSendToService (...,reply_messages, service_name, msg_buffer, buffer_size Process reply_messages... /* End Transaction */ PoetEndTransaction (...) EXEC SQL DECLARE salary_bonus CURSOR FOR SELECT empnum, salary FROM employee WHERE salary BETWEEN :num_low AND :num_high FOR UPDATE OF salary;... Receive msg.bonus, msg.high-sal, msg.low_sal Send reply... num_low = msg.low_sal; num_high = msg.high_sal; EXEC SQL OPEN salary_bonus;... EXEC SQL FETCH salary_bonus INTO:emp.empnum, :emp.salary;... EXEC SQL UPDATE employee SET salary=salary+(salary*msg.bonus_rate) WHERE CURRENT OF CURSOR salary_bonus;... Branch back to fetch next row... EXEC SQL CLOSE salary_bonus;... Microsoft Windows Program With POET Calls C Program With Embedded SQL Statements CDT 035.CDD J 4-15

94 5 NonStop 5 NonStop NonStop SQL/MP NonStop TM/MP OLTP OLTP NonStop NonStop Expand NonStop S NonStop S NonStop S NonStop S OLTP 5.1 NonStop OLTP NonStop S Guardian (OSS) NonStop API 5-1 NonStop OLTP (NonStop TS/MP NonStop SQL/MP NonStop TM/MP) J 5-1

95 5 NonStop 5-1 NonStop Portable Applications Guardian Applications OSS Environment: Tools Utilities Application Program Interface Guardian Environment: Tools Utilities Application Program Interface NonStop Kernel CDT 036.CDD API Guardian Guardian API API J

96 5 NonStop Guardian OLTP Guardian NonStop UNIX UNIX UNIX UNIX OSS 5-2 UNIX 5-2 UNIX / (root directory) /sub1 /sub2 /sub1/sub1a /sub1/file1 /sub2/file2 /sub2/file3 /sub2/file4 /sub1/sub1a/file5 /sub1/sub1a/file6 CDT 072.CDD 5-2 /sub1/sub1a/file5 file5 sub1a sub1a sub1 sub J 5-3

97 5 NonStop OSS UNIX vi ( ) man ( ) cp ( ) ls ( ) grep ( ) awk ( ) OSS UNIX OSS NonStop OLTP Guardian Guardian OSS API NonStop OLTP 5.2 NonStop 5-3 I/O 1 ServerNet (SAN) ServerNet NonStop S SAN ServerNet I/O SAN I/O J

98 5 NonStop 5-3 NonStop S CPU 0 CPU 1 CPU 2 CPU 3 Planned CPU 4 Dual ServerNet Fabrics ServerNet Adapter ServerNet Adapter ServerNet Adapter Disks LAN CDT 101.CDD CPU 0 CPU 1 I/O ServerNet I/ O NonStop S NonStop S NonStop S S NonStop S J 5-5

99 5 NonStop NonStop S Expand Expand NonStop S 5.4 I/O I/O I/ O 5-4 CPU 1 CPU 2 CPU 0 I/O J

100 5 NonStop 5-4 CPU 0 CPU 1 CPU 2 Disk Process User Process Terminal Process Dual ServerNet Fabrics ServerNet Adapter ServerNet Adapter ServerNet Adapter CDT 102.CDD 5.5 OLTP J 5-7

101 5 NonStop OLTP OLTP PC OLTP OLTP A B A B A A B 5-5 A J

102 5 NonStop 5-5 Create a Process Allocate Disk Space A (Requester) (Server) Processor Monitor (Requester) (Server) Disk Process CDT 039.CDD J 5-9

103 5 NonStop PC I/O I/O 5.7 NonStop S S Expand 5-6 NonStop S ServerNet 5-6 CPU 0 CPU 1 CPU 2 CPU 3 P1 P3 P5 P7 P2 P4 P6 P8 File System File System File System File System Message System Message System Message System Message System Dual ServerNet Fabrics CDT 103.CDD A B Expand J

104 5 NonStop 5-7 Expand System A System B CPU 0 CPU 1 CPU 0 CPU 1 P1 P2 P3 P4 P5 P6 P7 P8 File System File System File System File System Message System Message System Expand Network Connection Message System Message System Dual ServerNet Fabrics Dual ServerNet Fabrics CDT 104.CDD P1 P8 I/O P1 P8 I/O I/O P8 4. I/O P8 ServerNet I/O 5. P8 P1 6. P1 7. P1 P1 P8 ServerNet J 5-11

105 5 NonStop 5.8 NonStop S NonStop S I m alive CPU NonStop S NonStop S S 1. I m alive 2. I m alive 3. I m alive I m alive J

106 5 NonStop 5-8 CPU I m alive I'm Alive CPU 0 I'm Alive I'm Alive I'm Alive CPU 1 I'm Alive I'm Alive CPU 2 I'm Alive I'm Alive I'm Alive CDT 042.CDD I m alive J 5-13

107 5 NonStop 5-9 CPU 0 CPU 1 CPU 0 CPU 1 CPU 0 (CPU 0) 5-9 CPU 0 CPU 1 CPU 2 Primary Disk Process Backup Disk Process Checkpoint Messages to Backup Dual ServerNet Fabrics ServerNet Adapter ServerNet Adapter CDT 105.CDD J

108 5 NonStop 5.9 NonStop S NonStop S 16 NonStop S NonStop S 5.10 Expand NonStop S Expand Expand Expand J 5-15

109 5 NonStop Expand Expand NonStop Expand 255 NonStop Expand Expand 5-10 Expand A E Expand A-B B- D D-E A-C C-D D-E A-B A-C (bps) J

110 5 NonStop 5-10 Expand B bps bps A D bps bps C 9600 bps E CDT 044.CDD 5.11 NnStop Expand NonStop OSS Guardian Expand J 5-17

111 5 NonStop 5-11 Expand 5-11 Local System Remote Systems \MOON \JUPITER \EARTH \EARTH.$TERM \SATURN \NEPTUNE \NEPTUNE.$DATA CDT 045.CDD 5-11 NonStop (\) \EARTH \NEPTUNE PS Text Edit (TEDIT) TEDIT 1. \NEPTUNE 2. \EARTH \NEPTUNE 5. TEDIT \SATURN PS Text Format (TFORM) TFORM \NEPTUNE \SATURN TFORM PS Mail \SATURN \SATURN J

112 6 NonStop S 6 NonStop S NonStop NonStop NonStop Expand NonStop S NonStop S 6.1 NonStop S 6-1 A A B B Expand 6-1 NonStop S System A System B CPU 0 CPU 1 CPU 0 CPU 1 A B' B A' C' D D' C File System File System File System File System Message System Message System Expand Network Connection Message System Message System Dual ServerNet Fabrics Dual ServerNet Fabrics CDT 106.CDD J 6-1

113 6 NonStop S 6-2 NonStop S S ServerNet 6-2 NonStop S CPU 0 CPU 1 CPU 2 CPU 3 Dual ServerNet Fabrics ServerNet Adapter ServerNet Adapter ServerNet Adapter Disks CDT 107.CDD 6-2 ServerNet I/O ServerNet ServerNet I/O ServerNet ServerNet ServerNet I/O NonStop J

114 6 NonStop S 6.2 NonStop S NonStop S NonStop S Processor 0 Processor 1 Primary Process Checkpoint Messages Backup Process Mirrored Disk Volumes CDT 047.CDD ServerNet J 6-3

115 6 NonStop S ServerNet ServerNet ServerNet NonStop 2 16 CPU I/O ServerNet ServerNet ServerNet ID 6-4 CPU 0 CPU 1 CPU 2 CPU 3 ServerNet Interface ServerNet Interface ServerNet Interface ServerNet Interface X Y Y X X Y Y X ServerNet Y Fabric ServerNet X Fabric J

116 6 NonStop S X Y X Y CPU CPU 0 X 5 Y ServerNet CPU ServerNet ServerNet ServerNet ServerNet ServerNet X Y CPU ServerNet ServerNet 6 ASIC ServerNet CPU ServerNet ServerNet I/O NonStop S-Series Server Description Manual ServerNet ServerNet J 6-5

117 6 NonStop S I/O I/O I/O ServerNet I/O CPU 0 CPU 1 ServerNet Interface ServerNet Interface X Y X Y ServerNet Y Fabric ServerNet X Fabric ServerNet Addressable Controller (SAC) ServerNet Addressable Controller (SAC) SCSI Bus SAC SAC SAC SAC CDT 109.CDD ServerNet CPU ServerNet ServerNet (SAC) SAC SCSI LAN ATM I/O SAC I/O I/O ServerNet ServerNet J

118 6 NonStop S 6-5 SAC I/O SAC SAC SCSI I/O SeverNet X 4 SeverNet Y 1 SCSI SAC SAC 3 6 SAC SAC X Y I/O I/O ServerNet J 6-7

119 6 NonStop S 6-6 Any Input to Any Output Full Duplex CDT110.CDD OLTP NonStop S I/O ServerNet J

120 6 NonStop S NonStop S ServerNet I/O AC AC AC NonStop 5-12 CPU NonStop S I m alive (ECC) ECC J 6-9

121 6 NonStop S I m alive 6.3 NonStop S NonStop S NonStop S 16 Expand 16 Expand NonStop S J

122 6 NonStop S 6-7 NonStop S Relative Performance Number of Processors CDT 055.CDD 6.5 NonStop S NonStop S NonStop SQL/MP Enscribe J 6-11

123 6 NonStop S I/O I/O I/O NonStop S Expand NonStop S NonStop S NonStop S Expand A G H P Q Z 6-8 PART PARTFILE J

124 6 NonStop S 6-8 \SYSA.$VOL1 \SYSB.$VOL2 \SYSC.$VOL3 PART.PARTFILE ALLEN BAKER DAVIS EDWARDS GOMEZ PART.PARTFILE HAN KELLEY LOTHAR NYQUIST PARIS PART.PARTFILE QUINCY ROX VARIO WEST ZIP CDT 063.CDD J 6-13

125 7 7 NonStop S OLTP NonStop S Expand SNA IBM Expand IBM NonStop S NonStop S OSI TCP/IP X.25 (LAN) UNIX IBM Digital Equipment Corporation (DEC) Cray Hewlett-Packard (HP) SNAX/XF SNAX/APN NonStop S NonStop S SNA 7.1 SNA SNAX/XF (SNA) IBM SNA ATM POS SNA J 7-1

126 7 SNAX (SNAX/XF) NonStop S SNA SNA SNAX/XF SNA SNAX/XF IBM SNAX/XF 7.2 SNAX/XF NonStop S SNA 7-1 SNA (SDLC) NonStop S IBM 3270 IBM IBM ATM SNAX/XF NonStop S SNA Expand NonStop S SNAX/XF SNA 7-1 A1 SNAX/XF NonStop S SNAX/XF IBM ATM A2 A1 NonStop S SNAX/XF IBM 3270 A3 Expand NonStop S SNAX/XF Expand NonStop S SNAX/XF IBM SNA SNAX/XF SNA NonStop S SNA SNAX/XF IBM NonStop S J

127 7 7-1 SNA A1 A2 Expand SNAX/XF SDLC Communications Line SNA Controller IBM ATM Device IBM 3270 Terminal IBM Printer CDT 058.CDD J 7-3

128 7 7.3 SNAX/XF NonStop S SNA SNAX/XF SNA SNAX/XF SNA Host Expand Expand SDLC Expand Expand SNAX/XF SNAX/XF SNA Controller Devices SNA Controller Devices SNA Controller Devices CDT 059.CDD 7-2 SNA NonStop S Expand SNA NonStop S Expand NonStop S SNA SNA SNAX/XF Expand SNAX/XF SNA SNA A2 NonStop S SNA SNA SNA NonStop S NonStop S SNA SNA NonStop S SNA SNA SNA J

129 7 7.4 SNAX/XF NonStop S SNA SNA SNA SNAX/XF Expand NonStop S SNA Expand SNAX/XF SDLC SNA Host A2 CDT 060.CDD 7-3 NonStop S SNAX/XF NonStop S A1 SNA A2 Expand SNAX/XF 2 NonStop S A1 SNA A J 7-5

130 7 SNAX/XF SNA SNA NonStop S SNA NonStop S IBM 7.5 SNAX/APN SNAX/XF NonStop S SNA SNA SNA SNA SNA PC IBM (APPN) SNA SNA SNA PC AS/400 PS/2 SNA SNA SNAX (SNAX/APN) SNAX (SNAX/APC) APPN SNAX/APN NonStop S SNA SNAX/XF SNA SNAX/APN NonStop S SNA SNA SNAX/APN PC AS/400 SNAX/APN APPN SNAX/ APN NonStop S APPN NonStop S SNA SNAX/APN SNA SNA J

131 7 SNAX/APC APPN LU 6.2 IBM APPC LU 6.2 SNA SNAX/APC SNAX/APN APPN LU A1 IBM A2 LU 6.2 SNAX/APC SNAX/APN 7-4 IBM AS/400 A1 A2 LU 6.2 Peer-to-Peer APPC APPN CDT 077.CDD 7-5 NonStop S IBM AS/400 IBM 3270 NonStop S SNA J 7-7

132 7 7-5 IBM System/38 IBM PS/2 A1 IBM AS/400 IBM 3270 Terminal A5 A2 IBM Mainframe A4 IBM 3270 Terminal A3 SNAX/APN CDT 078.CDD SNAX/APN APPN NonStop NonStop S APPN J

133 7 7.6 SNA SNAX/XF SNAX/APN SNA NonStop S SNAX/XF SNA NonStop S IBM NonStop S SNAX/ APN NonStop S SNA NonStop S IBM SNAX/XF SNAX/APN NonStop S IBM NonStop S SNA OLTP SNA NonStop S SNA 7-6 ATM Expand NonStop S ATM NonStop S ATM IBM ATM ATM SNA NonStop S NonStop S Expand SNA SNA IBM SDLC NonStop S IBM ATM SNA IBM A ATM IBM B ATM ATM J 7-9

134 7 7-6 SNA ATM Mortgage Payment Application IBM System A ATM Application SNAX/XF SNA Controller ATM Terminals ATM Application SNAX/XF SNAX/XF ATM Activity Analysis Application ATM Application Expand SNA Controller ATM Terminals IBM System B SNAX/XF SNA Controller ATM Terminals CDT 061.CDD J

135 7 7-6 SNAX/XF ATM SNAX/XF ATM NonStop S SNA NonStop S OLTP ATM ATM 7-6 IBM A SNA SNA SNA ATM SNA ATM SNA NonStop S SNA SNAX/XF NonStop S ATM IBM B ATM SNA NonStop S ATM ATM SNAX/XF ATM 7.7 SNAX/XF SNAX/APN SNAX/XF SNAX/APN SNA SNA (line-at-a-time) 3270 SNA 3270 SNA SNA ATM POS SNA SNALU SNA J 7-11

136 7 7.8 SNA SNA SNAX/ XF SNAX/APN Product Guide SNAX (SNAX/HLS) SNA Exchange/SNA SNA (RJE) EM3270 IBM PC NonStop S IBM SNA J

137 API (API) CPU (CPU) DBMS (DBMS) Enscribe record-at-a-time NonStop SQL/MP Expand Expand Guardian (Guardian environment) NonStop Guardian (API) GUI (GUI) I/O (I/O process) IPB I/O Guardian I/O (IPB) LAN (LAN) LINKMON (LINKMON process) NonStop ODBC (NonStop ODBC Server) NonStop SQL/MP NonStop TM/MP Microsoft ODBC Microsoft Sybase SQL Server NonStop SQL/MP NonStop SQL/MP NonStop /MP NonStop TS/MP NonStop /MP J -1

138 NonStop TUXEDO (NonStop TUXEDO transaction processing environment) BEA Systems TUXEDO (API) NonStop SQL/MP NonStop TS/MP NonStop TM/MP NonStop (NonStop Kernel) NonStop NonStop (NonStop Kernel message system) Expand NonStop NonStop /MP (NonStop TS/MP: NonStop Transaction Services/MP) NonStop Pathway NonStop TS/MP PATHMON LINKMON PATHCOM Pathsend Pathway/XM NonStop TS/MP Pathway/TS Pathway/TS Pathway/XM NonStop /MP (NonStop TM/MP: NonStop Transaction Manager/MP) (OLTP) NonStop TM/MP TMF (TMF) OLTP OSS (OSS) PATHCOM PATHMON Pathway/XM PATHCOM Pathway/XM PXMCFG PXMCOM PATHMON (PATHMON process) Pathway/XM TCP TERM SERVER Pathway/XM PATHMON SuperCTL J

139 Pathway/TS NonStop Guardian OLTP Pathway/TS Pathway/TS TCP SCREEN COBOL SCREEN COBOL (SCUP) NonStop TS/MP NonStop /MP (NonStop TS/MP) Pathway/XM Pathway/XM NonStop TS/MP Pathway/TS Pathway/XM Pathway NonStop /MP (NonStop TS/MP) Pathway/TS Pathway (POET: Pathway Open Environment Toolkit) Pathway Pathway (Pathway transaction processing environment) Guardian Pathway Pathway NonStop TS/MP Pathway/TS TCP SCREEN COBOL NonStop TM/MP GDSX RSC POET Pathway RISC (RISC) RSC (RSC) SAC ServerNet (SAC) SAN (SAN) ServerNet (ServerNet adapter) ServerNet (SBI) (CRU) ServerNet (SAC: ServerNet addressable controller) ServerNet ID I/O SAC (PMF) I/O (IOMF) ServerNet ServerNet (ServerNet node) ServerNet (SAC) ServerNet (ServerNet SAN) J -3

140 ServerNet ID (ServerNet node ID) ServerNet (ServerNet SAN) ServerNet ID ID ServerNet ID ServerNet ID ServerNet ID ServerNet (ServerNet packet) ServerNet (ServerNet SAN) ServerNet 32 (CRC) I/O ServerNet (ServerNet fabric) I/O ServerNet ServerNet X Y ServerNet (ServerNet router) ServerNet (ServerNet SAN) ServerNet (ASIC) ServerNet NonStop S ServerNet 6 ServerNet SNA SNA (SNA product family) SQL IBM (SNA) (SQL) TCP/IP (TCP/IP) TMF (TMF subsystem) (TMF) (application) (API: application programming interface) API NonStop J

141 (heterogeneous network (portability) (interoperability) (API) (API) (API) (intelligent device) (IDS) (RSC) Pathsend Pathway (ATM) POS Guardian (response time) (audit trail) (audit records) NonStop /MP (open systems architecture) (OSS: Open System Services) NonStop OSS OSS OSS OSS OSS API UNIX (OLTP: online transaction processing) J -5

142 (expandability) (client) (client/server model) (GUI: graphical user interface) (SQL: structured query language) (commit) (server) (server class) (service) (1) (2) NonStop PXMCFG J

143 (SAN: System area network) Expand I/O SAN ServerNet ServerNet Expand (SNA: Systems Network Architecture) IBM (centralized processing) (RISC: reduced instruction-set computing) (scalability) (throughput) (consistency) 1 NonStop (Tandem NonStop Kernel) (terminal) NonStop K S I/O (checkpoint message) (CPU: central processing unit) CPU CPU J -7

144 (linear expandability) (communications controller) (communications protocol) (data integrity) (database) (DBMS: database management system) NonStop SQL/MP Enscribe DBMS (database consistency) (disk process) (dual ported) NonStop /MP I/O ServerNet I/O ServerNet I/O (TCP/IP: Transmission Control Protocol/Internet Protocol) TCP/IP TCP/IP (power-fail delay) J

145 (power-fail interrupt) (homogeneous network) (transaction) (TMF) (Transaction Management Facility (TMF) subsystem) NonStop TM/MP NonStop /MP (NonStop TM/MP) (TP) (transaction processing (TP) monitor) NonStop TUXEDO Pathway (transaction backout) TMF (network) (node) (backout) Expand (SAN) (backup process) (parallelism) Expand J -9

146 (file system) (file recovery) (fabric) (1) Guardian (API) (2) ServerNet (fault tolerance) (load balancing) (primary process) (program) NonStop (process) (process management) (process pair) (processor) (1) Guardian (2) PATHMON Guardian 2 16 (CPU) J

147 (IPB: interprocessor bus) (protocol) (distributed application) (distributed processing) (distributed data) (distributed database) NonStop S NonStop ServerNet TCP/IP SCSI ATM LU 6.2 (1) (2) (concurrency) (volume recovery) NonStop /MP NonStop TM/MP I/O (MFIOB: multifunction I/O board) SCSI/Ethernet ServerNet (SAC) ServerNet ServerNet (SEB) (SMB) ServerNet ServerNet (multiprocessor system) (mirrored disk) J -11

148 (message system) NonStop (ride-through power backup) AC (requester) Guardian (requester-server model) Expand (RSC: Remote Server Call) (link) (link management) (router) Microsoft Windows MS-DOS OS/2 Pathway Guardian NETBIOS TCP/IP Pathway Guardian NonStop /MP NonStop TUXEDO Pathway ServerNet (LAN: local area network) (wormhole routing) J

149 , 7-11 A API (API) 2-8 APPC 7-7 APPN 7-6 B BEGIN TRANSACTION 4-3, 4-4 C COBOL COMMENT SQL 3-14 C C 3-8 D DELETE SQL 3-5 DSS E EM Enscribe 3-1 Exchange/SNA 7-12 EXEC SQL 3-7 Expand 5-17 SNA 7-2/7-11 G GDSX 2-19 Guardian 5-1 GUI 1-11 H NonStop S 6-10 I IBM 7-1 INSERT, SQL 3-5 L LINKMON 2-9, 2-16 M Macintosh OLTP 1-10 N NonStop SQL/MP 3-1/3-14 NonStop TM/MP 4-13 OLTP , NonStop TUXEDO (ATMI) 2-19 NonStop TUXEDO 2-3, 2-10, 2-12, 2-19 NonStop NonStop /MP (NonStop TS/MP) J -1

150 NonStop /MP (NonStop TM/MP) OLTP 4-3, O ODBC (Open Database Connectivity) Server 3-10 OSS 5-1 P Pathmaker 2-17 PATHMON 2-9, 2-15, 2-16 Pathway (POET) 2-17 Pathway 2-3, 2-10, 2-15, 2-18 PC 2-6 POET 2-17 ptal 2-10 R RSC ( ) 2-8, 2-18 S SAC ServerNet SAN ( ) 5-4 SCREEN COBOL 2-19 SCSI 6-7 SDLC 7-2 SELECT SQL 3-4, 3-6 ServerNet ServerNet I/O 5-4, ServerNet (SAC) SCSI ServerNet 6-6 ServerNet ID 6-4 ServerNet 6-5 ServerNet 6-5/ , ServerNet SNA ( ) LU Expand 7-2/ , 7-12 SNA SNALU 7-11 SNAX/APC 7-7 SNAX/APN 7-6 SNAX/HLS 7-12 SNAX/XF / SQLCI 3-7 SQL 3-13 SQL 3-1, 3-5 Systems Network Architecture (SNA) SNA ( ) T TAL 2-10, 3-8 TAL 3-8 TP 2-3 TUXEDO NonStop TUXEDO (ATMI) NonStop TUXEDO J

151 U UNIX 1-12, 5-3, 5-4 UPDATE SQL 3-5, 3-6, 3-7 NonStop SQL/MP 3-1, 3-7, 3-8 NonStop TM/MP , /7-6 (API) APPC 7-7 Guardian 5-1 NonStop TUXEDO 2-8 ODBC 3-10 OSS 5-1 RSC 2-8 SCREEN COBOL 2-19 (DSS) 1-15/1-17, 3-9, 3-14/ , 7-1 NonStop SQL/MP 3-11 OSS 5-3 NonStop SQL/MP (OSS) (OLTP) 1-1, , 4-9/ NonStop SQL/MP J -3

152 OLTP I/O (GDSX) 2-19 NonStop SQL/MP 3-6 SQL , /2-7 (GUI) 1-11 SNAX/XF 7-4 C 3-8 COBOL C ptal 2-10 TAL 2-10, (SQL) 3-1, 3-5 DELETE 3-5, 3-6 INSERT 3-5 SELECT 3-5, 3-6, 3-7 UPDATE 3-5, 3-6, NonStop TUXEDO 2-10 Pathway NonStop 5-5 (SAN) , , SNAX/XF 7-4, , 4-1, , 7-11 Pathway/TS OLTP 1-11 NonStop SQL/MP , 6-4, 6-8 NonStop TM/MP 4-2 OLTP , 1-7 NonStop SQL/MP 3-13 NonStop SQL/MP (DDL) NonStop SQL/MP / /3-2 SNAX/XF J

153 ServerNet 6-4 ServerNet 6-7 NonStop SQL/MP 3-5, NonStop TM/MP , NonStop TUXEDO 2-3, 2-10, 2-12, 2-19 Pathway 2-3, 2-10, , / ServerNet 6-4, (PC) NonStop SQL/MP 3-9 OLTP , / NonStop SQL/MP 3-1, 3-11 OLTP NonStop SQL/MP , ServerNet ServerNet 5-4 NonStop S 6-3/6-10 I/O 6-7 OLTP , , 5-13, 6-3 NonStop SQL/MP 3-8 SNAX/APN 7-11 SNAX/XF OLTP 1-2, , , , 4-9/ J -5

154 I/O , 6-4, , , OLTP 2-4 OLTP I/O Pathway 2-19 (RSC) 2-8, ServerNet NonStop SQL/MP 3-7 NonStop SQL/MP 3-9 OLTP J