DABroker

Transcription

1 DABroker

2 P DABroker(64) OS:Windows Server 2003 x64 Edition Windows Server 2008 Windows Server 2008 R2 Windows Server 2012 Windows Server 2012 R2 Windows XP x64 Edition Windows Vista Windows 7 Windows 8 Windows 8.1 P-1M DABroker(64) OS:AIX 5L AIX V6.1 AIX7.1 P DABroker(64) OS:Red Hat Enterprise Linux AS4 AMD64&EMT64Red Hat Enterprise Linux ES4 AMD64&EMT64Red Hat Enterprise Linux 5 AMD64&EMT64Red Hat Enterprise Linux 5 Advanced Platform AMD64&EMT64Red Hat Enterprise Linux Server 6 64-Bit x86_64 Readme CORBA Object Management Group HP-UX Hewlett-Packard Development Company, L.P. IBM AIX International Business Machines Corporation Linux Linus Torvalds Microsoft Microsoft Corporation Microsoft SQL Server Microsoft Corporation ODBC Microsoft Corporation Oracle Java Oracle Corporation Red Hat Red Hat, Inc. UNIX The Open Group Windows Microsoft Corporation Windows Server Microsoft Corporation X/Open The Open Group X/Open X/Open CAE Specification System Interfaces and Headers Issue4 C202 ISBN Copyright (C) July 1992 X/Open Company Limited IEEE Std (C) 1990 Institute of Electrical and Electronics Engineers Inc. IEEE std /D12 (C) 1990 Institute of Electrical and Electronics Engineers Inc.

3 All Rights Reserved. Copyright (C) 2009, 2014, Hitachi, Ltd.

4 ( ) DABroker HiRDB XA Oracle12c ( ) DABroker Oracle11g R2 HiRDB V

5 P DABroker(64) P-1M DABroker(64) P DABroker(64) DABroker 1 DABroker DABroker DABroker 2 DABroker DABroker DABroker 3 DABroker UNIX UNIX DABroker DABroker 4 DABroker Windows Windows DABroker DABroker 5 DABroker DABroker 6 DABroker DABroker 7 DABroker A DABroker I

6 DBPARTNER2 Client DBPARTNER2 Client WWW HITSENSER OLAP HITSENSER5 Web WWW OLAP HiRDB Version HiRDB Version HiRDB HiRDB HiRDB Version 8 UAP HiRDB Version 9 UAP HiRDB HiRDB HiRDB Version 8 SQL II

7 HiRDB Version 9 SQL HiRDB RETCODE HiRDB Database Connection Server Database Connection Server Database Connection Server Database Connection Server XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD E2 SQL XDM E2 XDM/RD E2 SQL XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD E XDM E2 XDM/RD IDP E XDM E2 XDM/RD E XDM E2 XDM/RD E2 RD VOS3 XDM/RD XDM E2 XDM/SD ACE3 E ACE3 E VOS3 XDM/SD RDB1 E RDB1 E III

8 RDB1 E2 EQL VOS1 RDB1 E2 PDM II E VOS1 PDM II E2 VOSK DBPARTNER Library VOSK DBPARTNER Library SQL/K VOSK RDB VOSK SQL/K TPBroker TPBroker Developer's Kit - Extension for C TPBroker Object Transaction Monitor TPBroker IV

9 { } 1 {A B C} A B C V

10 < > n { } AA B C B C A B B A B 1 A B CA B C C A={B C D} A A=B 1 n < > A Z a z < > A Z < > < > 0 9 < > < >. + - < > < > < > < > 2 VI

11 AIX 5L AIX UNIX AIX V6.1 AIX V7.1 HP-UX 11.0 HP-UX HP-UX 11i HP-UX 11i V2 HP-UX 11i V3 Red Hat Enterprise Linux AS4(AMD64&EMT64) Red Hat Linux Red Hat Enterprise Linux ES4(AMD64&EMT64) Red Hat Enterprise Linux 5(AMD64&EMT64) Red Hat Enterprise Linux 5 AdvancedPlatform(AMD64&EMT64) Red Hat Enterprise Linux Server 6(64-Bit x86_64) Application Programming Interface Common Object Request Broker Architecture DABroker API CORBA DABroker VII

12 DABroker for Java TM DABroker for Java DABroker for Java TM Version 2 DABroker Driver for Java TM Technology DABroker for Java TM Version 2 DABroker for Java Version 2 DABroker Driver for Java TM Technology DABroker for Java TM Version 2 Extension Extension DABroker Driver Optional Package for Java TM Technology Graphical User Interface HiRDB Version 7 GUI HiRDB HiRDB Version 8 HiRDB Version 9 HITSENSER5 Standard for Cosmicube HITSENSER5 HITSENSER5 Professional for Cosmicube HITSENSER5 Standard for RDB HITSENSER5 Professional for RDB HITSENSER5 Standard HITSENSER5 Professional Microsoft(R) SQL Server SQL Server Microsoft(R) Windows(R) XP Professional x64 Edition Windows XP Windows Microsoft(R) Windows Server(R) 2003,Standard x64 Edition Windows Server 2003 Microsoft(R) Windows Server(R) 2003,Enterprise x64 Edition Microsoft(R) Windows Server(R) 2003,Datacenter x64 Edition Microsoft(R) Windows Server(R) 2003 R2,Standard x64 Edition Microsoft(R) Windows Server(R) 2003 R2,Enterprise x64 Edition Microsoft(R) Windows Server(R) 2003 R2,Datacenter x64 Edition Microsoft(R) Windows Vista(R) Business Windows Vista Microsoft(R) Windows Vista(R) Enterprise Microsoft(R) Windows Vista(R) Ultimate Microsoft(R) Windows 7(R) Professional Windows 7 VIII

13 Microsoft(R) Windows 7(R) Enterprise Microsoft(R) Windows 7(R) Ultimate Microsoft(R) Windows 8(R) Pro Windows 8 Microsoft(R) Windows 8(R) Enterprise Microsoft(R) Windows 8.1(R) Pro Microsoft(R) Windows 8.1(R) Enterprise Microsoft(R) Windows Server(R) 2008 Standard Windows Server 2008 Microsoft(R) Windows Server(R) 2008 Enterprise Microsoft(R) Windows Server(R) 2008 Datacenter Microsoft(R) Windows Server(R) R Standard Microsoft(R) Windows Server(R) R Enterprise Microsoft(R) Windows Server(R) R Datacenter Microsoft(R) Windows Server(R) 2012 Standard Windows Server 2012 Microsoft(R) Windows Server(R) 2012 Datacenter Microsoft(R) Windows Server(R) 2012 R2 Standard Microsoft(R) Windows Server(R) 2012 R2 Datacenter On-Line Analytical Processing Open Database Connectivity Oracle10g OLAP ODBC ORACLE Oracle11g Oracle11g R2 Oracle12c User Application Program VOS3 XDM/RD E2 VOS3 XDM/SD E2 VOSK RDB World Wide Web UAP VOS3 XDM/RD VOS3 XDM/SD VOSK SQL/K WWW DBPARTNER DBPARTNER/Client DBPARTNER/Client DBPARTNER DBPARTNER2 Client DBPARTNER/Client32 DBPARTNER/Web DBPARTNER/Web DBPARTNER2 Web IX

14 DBPARTNER/Web for Windows NT KB 1KB1MB1GB1TB 1,024 1, , ,024 4 X

15 1 DABroker DABroker DBMS X/Open DTP XA DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker for Java DABroker for ODBC DBPARTNER HITSENSER DBPARTNER/Client DBPARTNER/Web HITSENSER HITSENSER5 Web DBPARTNER Library XDM/RD E DABroker DBPARTNER DABroker DABroker 35 i

16 2.3.2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker 36 3 DABroker UNIX DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD Database Connection Server DABroker DABroker DABroker HiRDB ORACLE Database Connection Server DABroker DABroker DABroker DABroker DABroker ii

17 3.9 DABroker (Database Connection Server DB ) ORACLE HP-UX AIX Red Hat Linux Oracle9i Oracle10g DABroker Windows DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD Database Connection Server DABroker DABroker Database Connection Server 135 iii

18 DABroker DABroker (Database Connection Server DB ) DABroker DABroker DABroker DABroker DABroker DABroker ID DBPARTNER DABroker DABroker DABroker DBPARTNER DABroker Database Connection Server XA 182 iv

19 UNIX Windows Windows DABroker / A v

20 1-1 DABroker DABroker DABroker Java JTS Applet Java Java Java ODBC ASP ODBC DBPARTNER/Client DBPARTNER/Web HITSENSER HITSENSER5 Web DBPARTNER Library XDM/RD E DBPARTNER DABroker DABroker DABroker for Java DABroker for ODBC DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker Database Connection Server (1) DABroker Database Connection Server (2) DABroker 115 vi

21 4-2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker Database Connection Server (1) DABroker Database Connection Server (2) 148 vii

22 3-1 DABroker DABroker Database Connection Server DABroker Oracle 10g R R Oracle 11g R R Oracle 10g R R (DABroker for Java Oracle8i ) Oracle 11g R R (DABroker for Java Oracle8i ) Oracle 10g R R Oracle 11g R R Oracle 10g R R (DABroker for Java Oracle8i ) Oracle 11g R R (DABroker for Java Oracle8i ) Oracle 10g R R Oracle 11g R R Oracle 10g R R (DABroker for Java Oracle8i ) Oracle 11g R R (DABroker for Java Oracle8i ) Oracle9i Oracle10g DABroker DATA ID 351 viii

23 7-3 DABroker ix

24

25 1 DABroker DABroker UNIX Windows DABroker 1.1 DABroker 1.2 DABroker DBPARTNER HITSENSER5 1

26 1. DABroker 1.1 DABroker DABroker DBMS DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DBMS DBMS DBMS DBMS DBMS DABroker DBMS DABroker DABroker SQL DBMS 2

27 1. DABroker 1-1 DABroker X/Open DTP XA DBMS TPBroker OTS(Object Transaction Services) DABroker X/Open DTP XA HiRDB ORACLE 3

28 1. DABroker 1.2 DABroker DABroker DABroker 2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker TCP/IP DABroker 1-2 (1) (4) (1) (2) 1.3 (3) (6) 1.4 DBPARTNER HITSENSER5 4

29 1. DABroker 1-2 DABroker 1 WWW WWW DABroker 1-3 (7) (14) WWW (13) (14) (7) (12) WWW (7) (12) 1.3 (13) (14) 1.4 DBPARTNER HITSENSER5 LAN 5

30 1. DABroker DABroker 1-3 (15) (15) 1.4 DBPARTNER HITSENSER5 1-3 DABroker 2 6

31 1. DABroker DABroker DABroker(64) DABroker for Java JDBC Java DABroker for ODBC ODBC DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker API GUI DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DBMS ORACLE Oracle10g Oracle11g Oracle12c HiRDB SQL Server Windows ODBC3.0 Database Connection Server DABroker DABroker for Java DABroker for Java TM Version 2 DABroker Driver for Java TM Technology 7

32 1. DABroker DABroker for ODBC HITSENSER5 HITSENSER5 1 RDBMS ORDBMS DABroker RDBMS Relational DBMS ORACLE HiRDB SQL Server 2 DABroker Database Connection Server Database Connection Server VOS3 XDM/RD VOS3 XDM/SD VOSK SQL/K VOS1 PDMII E2 VOS1 RDB1 E2 VOSK DABroker DBPARTNER TPBroker OTS(Object Transaction Services) Java JTS (Java TM) DABroker X/Open DTP XA DABroker(64) JavaJTS 1 Java JTS a Java JTS DBMS Java JTS (Java TM) 8

33 1. DABroker HiRDB ORACLE Java TM DABroker Java TM Java JTS b Java JTS Java JTS Java TM Java TM 9

34 1. DABroker DBMS XA DABroker for Java Version 2 Extension JTA JNDI DABroker Java TM 10

35 1. DABroker 1.3 DABroker DABroker DABroker for Java DABroker for Java JDBC JDBC JDBC JDBC Java JDK1.2 java.sql DABroker for Java JDBC DABroker for Java OS Java Applet Applet Applet Applet Extension JDBC2.0 JNDI Java Naming and Directory InterfaceJTS Java Transaction Service JTA Java Transaction API DABroker for Java Version 2 1 DABroker for Java DABroker for Java a DABroker for Java JDBC Applet WWW Applet WWW 11

36 1. DABroker DABroker JDBC b JDBC DABroker for Java JDBC JDBC JDBC c Applet GUI Applet Applet DB DB SQL GUI SQL DB Java d DABroker for Java DABroker for Java DABroker for Java WWW DABroker for Java a WWW Applet Java Applet WWW Java Applet

37 1. DABroker 1-5 Applet b DABroker for Java JDBC

38 1. DABroker 1-6 Java c DABroker for Java JDBC

39 1. DABroker 1-7 Java d Java TM Extension JNDI Java Application JNDI Java Application DABroker

40 1. DABroker 1-8 Java DABroker for ODBC DABrker for ODBC DABroker ODBC ODBC API ODBC DBMS 16

41 1. DABroker DABroker for ODBC ODBC ODBC DABroker for ODBC DABroker(64) DABroker for ODBC 1 DABroker for ODBC DABroker for ODBC ODBC 3.0 DABroker for ODBC ODBC 3.0 DABroker for ODBC ODBC 3.0 DABroker for ODBC 2 DABroker for ODBC DABroker for ODBC WWW ODBC DABroker for ODBC DABroker for ODBC DABroker DABroker for ODBC a WWW ASP DABroker for ODBC WWW ODBC ASP WWW ASP Microsoft Internet Information Server Active Server Pages

42 1. DABroker 1-9 ODBC ASP b DABroker for ODBC

43 1. DABroker 1-10 ODBC 19

44 1. DABroker 1.4 DBPARTNER HITSENSER5 DABroker API GUI DBPARTNER HITSENSER5 DBPARTNER DBPARTNER/Client DBPARTNER/Web WWW HITSENSER5 HITSENSER5 Professional HITSENSER5 Standard HITSENSER5 for Cosmicube HITSENSER5 for RDB HITSENSER5 Web WWW DBPARTNER Library XDM/RD E2 HITSENSER5 HITSENSER5 XDM/RD E2 XDM/RD E DBPARTNER/Client DBPARTNER/Client GUI DBPARTNER/Client 20

45 1. DABroker DBPARTNER/Client DBPARTNER/Client DBPARTNER/Client DBPARTNER/Client DBPARTNER/Web DBPARTNER/Web WWW DBPARTNER/Web DBPARTNER/Web HTML WWW DBPARTNER/Web

46 1. DABroker 1-12 DBPARTNER/Web HITSENSER5 HITSENSER5 GUI HITSENSER5 HITSENSER5 HITSENSER

47 1. DABroker 1-13 HITSENSER HITSENSER5 Web HITSENSER5 Web WWW HITSENSER5 Web HITSENSER5 Web HTML WWW HITSENSER5 WWW HITSENSER5 Web

48 1. DABroker 1-14 HITSENSER5 Web DBPARTNER Library DBPARTNER Library API DBPARTNER Library VOSK DABroker

49 1. DABroker 1-15 DBPARTNER Library XDM/RD E2 XDM/RD E2 XDM/RD E2 VOS3 XDM/RD E2 DABroker

50 1. DABroker 1-16 XDM/RD E2 26

51 2 DABroker DABroker UNIX Windows DABroker 27

52 2. DABroker 2.1 DABroker

53 2. DABroker 2-2 DABroker DABroker DABroker DABroker DABroker API

54 2. DABroker DBPARTNER DABroker DBPARTNER DABroker 2-4 DBPARTNER 30

55 2. DABroker 2-4 DBPARTNER DABroker 1 DABroker 1 DABroker 1 1 DABroker 31

56 2. DABroker DABroker 1 UNIX 3.4 DABroker Windows 4.5 DABroker 5.2 DBPARTNER 32

57 2. DABroker 2.2 DABroker SQL DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD SQL TPBroker OTS Java JTS (Java TM) TPBroker Java TM DABroker TPBroker Java TM 33

58 2. DABroker DABroker TPBroker TPBroker OTS 34

59 2. DABroker 2.3 DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker 2-6 DABroker DABroker DABroker API DABroker for Java DABroker for Java DABroker Java API java.net Java RMI Java Remote Method Invocation DABroker for Java Applet DABroker 2-7 DABroker for Java 2-7 DABroker for Java DABroker for ODBC DABroker for ODBC DABroker ODBC DABroker for ODBC LAN DABroker 2-8 DABroker for ODBC 35

60 2. DABroker 2-8 DABroker for ODBC DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker TCP/IP 36

61 3 DABroker UNIX UNIX DABroker DABroker DABroker 3.5 DABroker 3.6 DABroker 3.7 DABroker 3.8 DABroker 3.9 DABroker (Database Connection Server DB ) ORACLE 37

62 3. DABroker UNIX 3.1 DABroker DBMS DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DABroker DABroker DABroker 38

63 3. DABroker UNIX 3-1 DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD 3-2 DABroker (3) 3-2 DABroker 39

64 3. DABroker UNIX 3-2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD 40

65 3. DABroker UNIX 3.2 DABroker DABroker DABroker DABroker DABroker HiRDB ORACLE DABroker DBMS DBMS 1.2 DABroker DABroker DBMS DABroker DABroker Hitachi PP Installer /opt/dabroker 3-1 DABroker DABroker 3-1 DABroker /opt/dabroker < > /bin < > /dabsetup /dabstart /dabstop /dabstat /dabcltrc /dabdbtrc /dabcmstart /dabcmstop /dabcmstat DABroker DABroker DABroker DABroker 41

66 3. DABroker UNIX /lib < > libdajavac.sl /obj < > /AGT < > /AGTGRP < > /msg < > /sample < > /conf /dasysconf /dadbenv /damconenv DABroker <DABroker > /spool <DABroker > /patch_dab < > /.dabrokerenv <DABroker > /.HTC_2340.inf <DABroker > DABroker DABroker DABroker DABroker dabsetup DABroker DABroker 3.2.3(1) DABroker DABroker DABroker DABroker DABroker DABroker DABroker DABroker HP-UX SHLIB_PATH OS DABroker DABroker /lib SHLIB_PATH DABroker HiRDB HiRDB /opt/ 42

67 3. DABroker UNIX HiRDB_P/client/libORACLE ORACLE 64 libclntsh.sl SHLIB_PATH AIX LD_LIBRARY_PATH LIBPATH OS DABroker DABroker /lib LD_LIBRARY_PATH LIBPATH DABroker HiRDB HiRDB /opt/ HiRDB_P/client/libORACLE ORACLE 64 libclntsh.a LD_LIBRARY_PATH LIBPATH Red Hat Linux LD_LIBRARY_PATH OS DABroker DABroker /lib LD_LIBRARY_PATH DABroker 1 DABroker 1. DABroker UNIX OS ID OS DABroker DABroker DABroker DABroker ORACLE ID 3 2. DABroker DABroker DABroker DABroker 3. DABroker dabsetup dabsetup DABroker DABroker DABroker DABroker dabsetup DABroker dabsetup 3.2.3(1)(a) DABroker 43

68 3. DABroker UNIX DABroker DABroker /opt/dabroker a DABroker dabsetup # dabsetup [-d ] dabsetup DABroker dabsetup dabsetup OS DABroker dabsetup DABroker DABroker -d DABroker DABroker -d DABroker DABroker /opt/ DABrokerdabsetup DABroker DABroker DABroker dabsetup DABroker 44

69 3. DABroker UNIX dabsetup DABroker /opt/dabroker DABrokerDABroker /opt/dabroker dabsetup /opt/dabroker DABroker dabsetup DABroker dabsetup DABroker DABroker DABroker dabsetup DABroker DABroker dabsetup DABroker DABroker dabsetup DABroker dabsetup dabsetup dabsetup DABroker DABroker DABroker dabsetup DABroker dabsetup DABroker dabsetup DABroker DABroker dabsetup DABroker dabsetup DABroker DABroker 45

70 3. DABroker UNIX DABroker dabsetup OS rm dabsetup dabsetup DABroker dabsetup 46

71 3. DABroker UNIX 3.3 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD /etc/services DABroker Database Connection Server /etc/ services DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD /etc/services TCP/IP DABroker DABROKER_SV XXXXX/tcp DABROKER_SV DABroker XXXXX tcptcp/ip XXXXX DABroker NIS Network Information Service NIS NIS NIS DABroker IP Database Connection Server Database Connection Server DABroker Database Connection Server 3.9 DABroker (Database Connection Server DB ) DABroker DAB_DBS_PORT

72 3. DABroker UNIX /etc/services Database Connection Server Database Connection Server ( ) DBCSV DBCSV 40179/tcp 3.9 DABroker (Database Connection Server DB ) DABroker DAB_DBS_PORT Database Connection Server ( ) 48

73 3. DABroker UNIX 3.4 DABroker DABroker DABroker DABroker 3.5 DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DABroker DABroker DABroker DABroker DABroker DABroker DABroker /opt/dabroker/sample/dasysconf DABroker DABroker /conf DABroker DABroker DABroker DAB OTHERS DAB DABroker DABroker 49

74 3. DABroker UNIX OTHERS DBMS DABroker HiRDB ORACLE 2 export DABTMP = /tmp/dab DABTMP='/tmp/da b' DABTMP = /tmp/dab; $ 3 DABroker DABroker 50

75 3. DABroker UNIX 3.5 DABroker DABroker DABroker DABroker for Java Version 2 DABroker DABORADBA_LONGBUFSIZE DABHIRDBA_BLOBBUFSIZE DABDBSDBA_BLOBBUFSIZE DABroker HiRDB HiRDB ORACLE ORACLE Database Connection Server Database Connection Server DABroker DABroker DAB_LANG LANG HP-UX ja_jp.sjis AIX Red Hat Linux C 3.5.1(1) DAB_LANG LANG 51

76 3. DABroker UNIX DABTMP /tmp 1 DABSQL_TRCSIZE DABSELECTCOLCNT 0 0, DABSELECTINFCNT 0 0, DABORACLE_TYPE ORACLE (6) DABORACLE_TYPE ORACLE DABSQL_HiRDB_ DICTIONARY_ DATATYPE HiRDB C M C DABSVLOGSIZE DABroker 64 ( ) 0, ( ) DABXA_LOG_ERROR XA ON ON OFF DABEXSQL_TRC_LINE ( ) DAB_HIRDB_DBINF_ES $ % & * + - / :? 1 DABroker READ WRITE 2 DABroker 1 DAB_LANG LANG HP-UX ja_jp.sjis AIX C Red Hat Linux C 52

77 3. DABroker UNIX HP-UX ja_jp.sjis SJIS ja_jp.euc ja_jp.ujis ja_jp.eucjp EUC C ASCII UTF-8 UTF-8 AIX Ja_JP Ja_JP.IBM-932 Ja_JP.IBM-943 SJIS ja_jp ja_jp.ibm-eucjp EUC C ASCII UTF-8 UTF-8 Red Hat Linux ja_jp ja_jp.ujis japanese japanese.euc ja_jp.eucjp Ja_JP EUC C ASCII UTF-8 UTF-8 SJIS 3-4 DABroker SJIS EUC ASCII UTF-8 HiRDB ORACLE VOS3 XDM/RD VOS3 XDM/SD VOSK SQL/K VOS1 RDB1 E2 VOS1 PDM II E2 VOSK DABroker DABroker 53

78 3. DABroker UNIX DABroker for Java DAB_LANG JDBC DABroker for JavaTM Version 2 DABroker Driver for JavaTM Technology ENCODELANG DABroker EUC ASCII UTF-8 7. ( ) 2 DABTMP DABroker /tmp DABroker READ WRITE DABroker /tmp OS /tmp 3 DABSQL_TRCSIZE dabdbtrc 0 DABroker /spool/db_access XXXXX db_xxxxx

79 3. DABroker UNIX DABroker -1 4 DABSELECTCOLCNT DBMS SQL DBMS DBMS SQL SQL HiRDB ORACLE DBMS 0 0 DBMS SQL DBMS 5 DABSELECTINFCNT DBMS SQL DBMS

80 3. DABroker UNIX DBMS SQL SQL HiRDB ORACLE DBMS 0 0 DBMS SQL DBMS 6 DABORACLE_TYPE ORACLE ORACLE 101 Oracle10g R Oracle10g R Oracle11g R Oracle11g R Oracle12c R DABSQL_HiRDB_DICTIONARY_DATATYPE HiRDB C M C HiRDB M MVARCHAR C VARCHAR HiRDB 56

81 3. DABroker UNIX SQL 8 DABSVLOGSIZE DABroker DABroker DABroker /spool/dabsv.logdabroker /spool/dabsvdemon.log dabsv.logold dabsvdemon.logold 9 DABXA_LOG_ERROR XA ON ON OFF ON OFF XA XA DABroker spool db_xainfo.log XA (db_xainfo.log) XA 57

82 3. DABroker UNIX 10 DABEXSQL_TRC_LINE $ % & * + - / :? 1 DABroker for Java 58

83 3. DABroker UNIX DABroker DABroker DABCLIENT_TIMEOUT DABDBA_TIMEOUT DABKEEPALIVE TCP/IP 3600( ) ( ) 1800( ) ( ) OFF ON OFF DABTCP_TRCSIZE DABMAXUSERS 10 ( ) ( ) DABDBANUMBER 20 ( ) ( ) DABMAXBLOCK USERS 1 1 ( ) ( ) DABMAXPROCESS 10 ( ) ( ) DABORADBA_ LONGBUFSIZE ORACLE LONG LONGRAW 4096 ( ) ( ) DABHIRDBA_ BLOBBUFSIZE HiRDB BLOB 4096 ( ) ( ) DABDBSDBA_ BLOBBUFSIZE Database Connection Server BLOB 4096 ( ) ( ) DABIPCONVERT IP ON ON OFF 59

84 3. DABroker UNIX DABroker READ WRITE 1 DABCLIENT_TIMEOUT DABroker DABroker 0 2 DABDBA_TIMEOUT( DABroker DABroker 0 Database Connection Server 0 60

85 3. DABroker UNIX 3 DABKEEPALIVE TCP/IP OFF ON OFF TCP/IP ON OFF 4 DABTCP_TRCSIZE dabcltrc DABroker / spool/dabcltrcxxxxx IP AAAAA trs2340_tcxxx.xxx.xxx.xxx DBPARTNER/Client trs2340_tcxxx.xxx.xxx.xxxaaaaa DBPARTNER/Client DABroker 61

86 3. DABroker UNIX -1 5 DABMAXUSERS DABDBANUMBER DABroker 7 DABMAXBLOCKUSERS ORACLE 1 ORACLE 1 1 DABroker 62

87 3. DABroker UNIX 8 DABMAXPROCESS DABroker 9 DABORADBA_LONGBUFSIZE ORACLE LONG LONGRAW ORACLE LONG LONGROW ORACLE DABroker 0 DBMS DABroker for Java Version 2 DABroker DABroker for Java Version 2 Oracle8i 10 DABHIRDBA_BLOBBUFSIZE HiRDB BLOB

88 3. DABroker UNIX HiRDB BLOB HiRDB DABroker 0 DBMS DABroker for Java Version 2 DABroker 11 DABDBSDBA_BLOBBUFSIZE Database Connection Server BLOB Database Connection Server BLOB DABroker 0 DBMS DABroker for Java Version 2 DABroker 12 DABIPCONVERT IP ON ON OFF 64

89 3. DABroker UNIX DABroker IP DABroker 3.8 DABroker ON IP OFF IP HiRDB HiRDB HiRDB PDHOST PDNAMEPORT HiRDB DABroker HiRDB UAP 1. PDCLTPATH 2. PDHOST 3. PDNAMEPORT HiRDB 4. PDSWAITTIME 5. PDSQLTRACE SQL 6. PDUAPERLOG ORACLE ORACLE 65

90 3. DABroker UNIX ORACLE ORACLE 1. ORACLE_HOME ORACLE 2. ORACLE_SID ORACLE 3. NLS_LANG Database Connection Server DABroker Database Connection Server DABroker Database Connection Server Database Connection Server DAB_DBS_HOST Database Connection Server IP localhost IP DAB_DBS_PORT Database Connection Server DAB_DBS_SEND_BUFFER_SIZE Database Connection Server 64 ( ) ( ) DAB_DBS_RECEIVE_BUFFER_S IZE Database Connection Server 64 ( ) ( ) 66

91 3. DABroker UNIX 1 DAB_DBS_HOST Database Connection Server IP localhost IP Database Connection Server Database Connection Server IP 2 DAB_DBS_PORT Database Connection Server Database Connection Server Database Connection Server 3 DAB_DBS_SEND_BUFFER_SIZE Database Connection Server Database Connection Server Database Connection Server 4 DAB_DBS_RECEIVE_BUFFER_SIZE Database Connection Server

92 3. DABroker UNIX Database Connection Server Database Connection Server DAB_DEMON_LOG_MODE LIMITED DABPTHREAD_STACK_SIZE HP-UX 68

93 3. DABroker UNIX 3.6 DABroker DABroker for ODBC DBPARTNER DABroker for Java Database Connection Server Database Connection Server OTS Java JTS (2) 3.6.1(4) 1 dadbenv DABroker /conf 2 69

94 3. DABroker UNIX 3 4 /opt/dabroker/sample/dadbenv 1. DABroker /conf

95 3. DABroker UNIX 3.6.2(1)(a) 23 2 DBTYPE= HiRDB Oracle Database Connection Server HIRDB ORACLE7 DBCONNECTSVR a Database Connection Server 23 2 HiRDB HiRDB DBHOST DBNAME DBHOST= HiRDB HiRDB PDHOST HiRDB HiRDB HiRDB 71

96 3. DABroker UNIX DBHOST= +HiRDB = + +HiRDB HiRDB DABroker DAB_HIRDB_DBINF_ESC DBHOST=@PDHOST=host@PDNAMEPORT=20000 HiRDB DABroker HiRDB DABroker PDUSER PDCLTAPNAME PDHOST PDNAMEPORT # " ' HiRDB DBHOST= +DABENVGRP=HiRDB DABroker DAB_HIRDB_DBINF_ESC DAB_HIRDB_DBINF_ESC DBHOST= DABENVGRP=XXXX HiRDB XXXX HiRDB DABroker HiRDB HiRDB DABroker PDUSER PDCLTAPNAME PDHOST PDNAMEPORT # " ' DBHOST= DABENVGRP=XXXX DBNAME= HiRDB HiRDB PDNAMEPORT DBHOST HiRDB HiRDB DBNAME=DAB_HIRDBENV 72

97 3. DABroker UNIX USRID= ID ID ID ID PASSWD= ID ORACLE DBNAME=ORACLE SQL*NET ORACLE USRID= ID ID ID ID PASSWD= ID Database Connection Server DBTYPE= VOS3 XDM/RD VOS3 XDM/SD VOSK SQL/K XDMRD XDMSD SQLK 73

98 3. DABroker UNIX VOS1 PDM II E2 VOS1 RDB1 E2 VOSK VOS1PDM RDB1 VOSKSPOOL DBNAME=Database Connection Server Database Connection Server (RD ) DBHOST= USERID SNDBUF= Database Connection Server ( ) RCVBUF= Database Connection Server ( ) USRID= ID ID ID ID PASSWD= ID HiRDB XDM/RD HiRDB VOS3 XDM/RD HiRDB 2 DBTIMER PASSWD 74

99 3. DABroker UNIX HiRDB DBDEF_HIR1 HiRDB CNDEF_HIRSV1 HiRDB CNDEF_HIRSV2 Database Connection Server DBDEF_DBS VOS3 XDM/RD CNDEF_XDM 2 HiRDB1 HiRDB2 HiRDB1 ORACLE1 HiRDB1 Table1 Table2 HiRDB1{ DBTYPE=HIRDB Table1{ 75

100 3. DABroker UNIX } HiRDB2{ } ORACLE1{ } } Table2{ } DBHOST='ITEMS' DBNAME='22200' DBHOST='STOCK' DBNAME='22200' DBTYPE=HIRDB database2{ DBHOST='EMPLOYEE' DBNAME='22200' } DBTYPE=ORACLE7 DB1{ DBHOST='CUSTOMERS' } 76

101 3. DABroker UNIX 3.7 DABroker DABroker DABroker DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker for Java WWW DABroker for ODBC DABroker DABroker /bin DABroker DABroker DABroker 5. DABroker DABroker DABroker DABroker DABroker 1 # dabstart [-t] DABroker DABroker -t TCP/IP -t -t 77

102 3. DABroker UNIX 2 DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD UNIX UNIX TCP/IP DABroker DABroker DABroker DBMS DABroker dabstat dabstat DABroker DABroker DABroker 1 # dabstop [-p -f -c IP ] DABroker DABroker 78

103 3. DABroker UNIX -p -f DABroker DABroker -c IP IP DABroker IP IP dabstat dabstat DABTCP_TRCSIZE DABSQL_TRCSIZE 0 SQL DABroker 79

104 3. DABroker UNIX 3.8 DABroker DABroker DABroker 5. DABroker dabstat dabcltrc dabdbtrc DABroker DABroker /bin $ dabstat DABroker dabstat DABroker STIME / / : : TIME : : CLIENT IP hosts IP batchno 80

105 3. DABroker UNIX 64 DABroker association * # dabcltrc [-c IP ] DABroker DABroker DABroker DABroker -c IP IP IPADDR=XXXXXXXX IP PROT=XXX TCP TCP/IP PAP-NAME=XXXXXX 81

106 3. DABroker UNIX DABroker DBPARTNER/Client DBPARTNER/Web HITSENSER5 DBPARTNER/Client DBPARTNER/Web HITSENSER5 DBPARTNER Library DBPARTNER Library XDM/RD XDM/RD DATE / / TIME : :.n n n/100 EVT DABroker PUT GET SIZE DATA aa aa <bb bb> cc cc,dd dd aa aa Connect Database Disconnect Database Disconnect Connection Commit Rollback LIST Table LIST Column LIST Index LIST Table Privileges LIST Column Privileges LIST PrimaryKey 82

107 3. DABroker UNIX EXT-CMD DataDivision Fetch Cancel Illegal Request Connection Result Error Result Cancel Error Cancel SQL Fetch Option File Delete Procedure List Prepare Procedure Procedure List Fetch Procedure Procedure List Close Procedure Procedure List Prepare Column Procedure List Fetch Column Procedure List Close Column Procedure Parameter Get Procedure Prepare Procedure Execute Procedure Resume SQL DBMS DBMS DBMS SQL SQL Resume bb bb LIST xxxxx EXT-CMD cc cc dd dd 80+ * 2 PUT GET * 36 PUT GET 83

108 3. DABroker UNIX 84

109 3. DABroker UNIX 3.9 DABroker (Database Connection Server DB ) Database Connection Server DBPARTNER 3.6 DABroker Database Connection Server Database Connection Server DABroker /opt/dabroker/sample/damconenv DABroker /conf

110 3. DABroker UNIX DABTMP = /tmp/dab 2 DABroker Database Connection Server IP DBSHOST Database Connection Server DBSPORT Database Connection Server DBSTIMER MCONMAX MCONPROC MCONPOOL MRSVPOOL 3-3 DBSHOST DBSPORT Database Connection Server DBSHOST Database Connection Server Database Connection Server Database Connection Server 86

111 3. DABroker UNIX Database Connection Server /etc/services MCONMAXMCONPROC MCONPOOL MRSVPOOL 1 DABroker Database Connection Server DABroker Database Connection Server Database Connection Server TCP/IP 1 TCP/IP DABroker Database Connection Server (1) 1TCP/IP 1 TCP/IP Database Connection Server DABroker DABroker TCP/IP TCP/IP DABroker 87

112 3. DABroker UNIX TCP/IP DABroker TCP/IP DABroker TCP/IP 1TCP/IP DABroker 1 TCP/IP = DABroker = 3-5 1TCP/IP 2 1 DABroker Database Connection Server DBPARTNER TCP/IP DABroker TCP/ IP DABroker DABroker Database Connection Server TCP/IP (MRSVPOOL)>0 DABroker (MRSVPOOL) =0 ( (MCONMAX) ) ( (MCONPROC) ) TCP/IP 1TCP/IP (MCONMAX) 88

113 3. DABroker UNIX 3-5 DABroker Database Connection Server (2) TCP/IP 3-4 TCP/IP MCONMAX 1TCP/IP 1 1 TCP/IP 1 TCP/IP DABroker 1TCP/IP (1) dabcmstart MCONPROC DABroker 1 1TCP/IP 89

114 3. DABroker UNIX 1. DABroker Database Connection Server Database Connection Server 2. 1 * 2 DABroker Database Connection Server 1 1 TCP/IP Database Connection Server ( ) TCP Database Connection Server MCONPOOL Database Connection Server MRSVPOOL 90

115 3. DABroker UNIX MCONPOOL DABroker TCP/IP Database Connection Server 1 1TCP/IP MRSVPOOL DABroker DABroker DABroker 1 1TCP/IP (MCONMAX) Database Connection Server < >DABroker DBSHOST=Database Connection Server IP Database Connection Server IP DABroker DAB_DBS_HOST( IP ) DBSPORT=Database Connection Server Database Connection Server Database Connection Server /etc/services 91

116 3. DABroker UNIX 3.3 DABroker DAB_DBS_PORT( ) DBSTIMER=Database Connection Server Database Connection Server MCONMAX= 1 Database Connection Server * (MCONPROC) (1) dabcmstart MCONPROC= 2 Database Connection Server DBPARTNER MCONPOOL= 2 Database Connection Server Database Connection Server 92

117 3. DABroker UNIX MRSVPOOL= 2 DABroker DABroker Database Connection Server * ( ) dbs01 dbs02 dbs01{ } dbs02{ } DBSHOST='host01' DBSPORT='5001' DBSTIMER=180 MCONMAX=2 MCONPROC=10 MCONPOOL=5 MRSVPOOL=3 DBSHOST='host02' DBSPORT='5002' DBSTIMER=180 MCONMAX=1 93

118 3. DABroker UNIX 3.10 (MCONMAX) 2 Database Connection Server DABroker DABroker DABroker /bin Red Hat Linux Database Connection Server Database Connection Server DABroker Disconnect 1 (dabcmstart) # dabcmstart DABroker 2 (dabcmstop) # dabcmstop [-f -p] 94

119 3. DABroker UNIX DABroker dabcmstop -f -p ( ) ( ) ( ) ID ID DABroker Database Connection Server 1 (dabcmstat) $ dabcmstat 95

120 3. DABroker UNIX CONNTIME USERTIME USERID ID STATUS USE POOL VCONID ID DMNID ID SVPROCID ID CMNAME USE 96

121 3. DABroker UNIX 3.11 ORACLE DABroker ORACLE ORACLE ORACLE ORACLE OCI OCI ORACLE make ORACLE DABroker ORACLE ORACLE ORACLE ORACLE UNIX Oracle12c Oracle12c HP-UX HP-UX ORACLE 1 ORACLE ORACLE DABroker ORACLE DABroker KFDB005MM-E [dlopen(/opt/dabroker/lib/libdao7101.sl ) errno=ld.sl.1: : : /opt/dabroker/lib/libdao7101.sl : ORACLE : ] Oracle10g R R libdao7101.sl Oracle11g R R libdao7111.sl DABroker for Java Oracle8i Oracle10g R R libdao8101.sl 97

122 3. DABroker UNIX DABroker for Java Oracle8i Oracle11g R R libdao8111.sl 2 ORACLE ORACLE /opt/dabroker DABroker /opt/dabroker DABroker /opt/dabroker 1. DABroker DABroker cd /opt/dabroker/lib Oracle10g R R libdao7101.sl Oracle11g R R libdao7111.sl DABroker for Java Oracle8i Oracle10g R R libdao8101.sl DABroker for Java Oracle8i Oracle11g R R libdao8111.sl 2. DABroker ORACLE 1 DABroker 2 DABroker 3 ORACLE OS DABroker ORACLE ORACLE OCI ORACLE OCI ORACLE OS 4 DABroker 98

123 3. DABroker UNIX 5 Oracle 10g R R /opt/dabroker/sample/oramake Oracle 10g R R PROGRAM = libdao7101.sl 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -l:libcl.sl -lpthread 3 ORALIB = -L $(ORACLE_HOME)/lib -l:libclntsh.sl 3 LDFLAGS= -b +s 4 OBJS= $(DABDIR)/obj/dacdcntl.o $(DABDIR)/obj/daO7101.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." $(LD) -o $(PROGRAM) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) echo "done Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R PROGRAM = libdao7111.sl 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -l:libcl.sl -lpthread 3 ORALIB = -L $(ORACLE_HOME)/lib -l:libclntsh.sl 3 LDFLAGS= -b +s 4 OBJS= $(DABDIR)/obj/dacdcntl.o $(DABDIR)/obj/daO7111.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." $(LD) -o $(PROGRAM) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) echo "done" DABroker for Java Oracle8i Oracle 10g R R

124 3. DABroker UNIX /opt/dabroker/sample/oramake Oracle 10g R R (DABroker for Java Oracle8i ) 1 PROGRAM = libdao8101.sl 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -l:libcl.sl -lpthread 3 ORALIB = -L $(ORACLE_HOME)/lib -l:libclntsh.sl 3 LDFLAGS= -b +s 4 OBJS= $(DABDIR)/obj/dacd8101.o $(DABDIR)/obj/daO8101.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." $(LD) -o $(PROGRAM) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) echo "done" DABroker for Java Oracle8i Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R (DABroker for Java Oracle8i ) 1 PROGRAM = libdao8111.sl 2 LIBS = -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -l:libcl.sl -lpthread 3 ORALIB= -L $(ORACLE_HOME)/lib -l:libclntsh.sl 3 LDFLAGS = -b +s 4 OBJS = $(DABDIR)/obj/dacd8111.o $(DABDIR)/obj/daO8111.a 5 all: $(PROGRAM) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." $(LD) -o $(PROGRAM) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) echo "done" 3. DABroker ORACLE 100

125 3. DABroker UNIX make B ORACLE_HOME ORACLE HOME export ORACLE_HOME DABDIR /opt/dabroker export DABDIR Oracle 10g R R make -f Oramake7101 Oracle 11g R R make -f Oramake7111 DABroker for Java Oracle8i Oracle 10g R R make -f Oramake8101 DABroker for Java Oracle8i Oracle 11g R R make -f Oramake ORACLE DABroker make ORACLE ORACLE make Oracle 10g R R cp libdao7101.sl /opt/dabroker/lib/libdao7101.sl Oracle 11g R R cp libdao7111.sl /opt/dabroker/lib/libdao7111.sl DABroker for Java Oracle8i Oracle 10g R R cp libdao8101.sl /opt/dabroker/lib/libdao8101.sl DABroker for Java Oracle8i Oracle 11g R R cp libdao8111.sl /opt/dabroker/lib/libdao8111.sl 5. DABroker ORACLE /opt/dabroker/lib DABroker AIX AIX ORACLE 101

126 3. DABroker UNIX 1 ORACLE ORACLE DABroker ORACLE DABroker KFDB005MM-E [dlopen(/opt/dabroker/lib/libdao7101.sl ) errno=ld.sl.1: : : /opt/dabroker/lib/libdao7101.sl : ORACLE : ] Oracle10g R R libdao7101.sl Oracle11g R R libdao7111.sl DABroker for Java Oracle8i Oracle10g R R libdao8101.sl DABroker for Java Oracle8i Oracle11g R R libdao8111.sl 2 ORACLE ORACLE /opt/dabroker DABroker /opt/dabroker DABroker /opt/dabroker 1. DABroker DABroker cd /opt/dabroker/lib Oracle10g R R mv libdao7101.alibdao7101.a_bk Oracle11g R R mv libdao7111.alibdao7111.a_bk DABroker ORACLE8i Oracle10g R R mv libdao8101.alibdao8101.a_bk 102

127 3. DABroker UNIX DABroker ORACLE8i Oracle11g R R mv libdao8111.alibdao8111.a_bk 2. DABroker ORACLE 1 DABroker 2 DABroker 3 ORACLE OS DABroker ORACLE ORACLE OCI ORACLE OCI ORACLE OS 4 DABroker 5 Oracle 10g R R /opt/dabroker/sample/oramake Oracle 10g R R PROGRAM = libdao7101.a 1 PROGRAM1= libdao7101.o 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -lpthreads -bglink:/lib/glink.o -bm:sre -bexpall 3 -bnoentry -lm -lc_r 3 ORALIB= -L $(ORACLE_HOME)/lib -lclntsh 3 LDFLAGS = -G 4 OBJS = /opt/dabroker/obj/dacdcntl.o 4 /opt/dabroker/obj/dao7101.a 5 all: $(PROGRAM) 103

128 3. DABroker UNIX 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM1) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) ar rv $(PROGRAM) $(PROGRAM1) rm -f $(PROGRAM1) echo "done" Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R PROGRAM = libdao7111.a 1 PROGRAM1= libdao7111.o 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -lpthreads -bglink:/lib/glink.o -bm:sre -bexpall 3 -bnoentry -lm -lc_r 3 ORALIB= -L $(ORACLE_HOME)/lib -lclntsh 3 LDFLAGS = -G 4 OBJS = /opt/dabroker/obj/dacdcntl.o 4 /opt/dabroker/obj/dao7111.a 5 all: $(PROGRAM) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM1) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) ar rv $(PROGRAM) $(PROGRAM1) rm -f $(PROGRAM1) echo "done" DABroker for Java Oracle8i Oracle 10g R R /opt/dabroker/sample/oramake Oracle 10g R R (DABroker for Java Oracle8i ) 1 PROGRAM = libdao8101.a 1 PROGRAM1= libdao8101.o 104

129 3. DABroker UNIX 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -lpthreads -bglink:/lib/glink.o -bm:sre -bexpall 3 -bnoentry -lm -lc_r 3 ORALIB= -L $(ORACLE_HOME)/lib -lclntsh 3 LDFLAGS = -G 4 OBJS = /opt/dabroker/obj/dacd8101.o 4 /opt/dabroker/obj/dao8101.a 5 all: $(PROGRAM) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM1) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) ar rv $(PROGRAM) $(PROGRAM1) rm -f $(PROGRAM1) echo "done" DABroker for Java Oracle8i Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R (DABroker for Java Oracle8i ) 1 PROGRAM = libdao8111.a 1 PROGRAM1= libdao8111.o 2 LIBS= -L /opt/dabroker/lib -ldacommon 3 LIBS1 = -lpthreads -bglink:/lib/glink.o -bm:sre -bexpall 3 -bnoentry -lm -lc_r 3 ORALIB= -L $(ORACLE_HOME)/lib -lclntsh 3 LDFLAGS = -G 4 OBJS = /opt/dabroker/obj/dacd8111.o 4 /opt/dabroker/obj/dao8111.a 5 all: $(PROGRAM) 105

130 3. DABroker UNIX 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM1) $(OBJS) $(LIBS) $(LIBS1) $(LDFLAGS) $(ORALIB) ar rv $(PROGRAM) $(PROGRAM1) rm -f $(PROGRAM1) echo "done" 3. DABroker ORACLE make B ORACLE_HOME ORACLE HOME export ORACLE_HOME DABDIR /opt/dabroker export DABDIR Oracle 10g R R make -f Oramake7101 Oracle 11g R R make -f Oramake7111 DABroker for Java Oracle8i Oracle 10g R R make -f Oramake8101 DABroker for Java Oracle8i Oracle 11g R R make -f Oramake ORACLE DABroker make ORACLE ORACLE make Oracle 10g R R cp libdao7101.sl /opt/dabroker/lib/libdao7101.sl Oracle 11g R R cp libdao7111.sl /opt/dabroker/lib/libdao7111.sl DABroker for Java Oracle8i Oracle 10g R R cp libdao8101.sl /opt/dabroker/lib/libdao8101.sl DABroker for Java Oracle8i Oracle 11g 106

131 3. DABroker UNIX R R cp libdao8111.sl /opt/dabroker/lib/libdao8111.sl 5. DABroker ORACLE /opt/dabroker/lib DABroker Red Hat Linux 1 ORACLE ORACLE DABroker ORACLE DABroker KFDB005MM-E [dlopen(/opt/dabroker/lib/libdao7101.sl ) errno=ld.sl.1 /opt/dabroker/lib/libdao7101.sl : ORACLE ] Oracle10g R R libdao7101.sl Oracle11g R R libdao7111.sl DABroker for Java Oracle8i Oracle10g R R libdao8101.sl DABroker for Java Oracle8i Oracle11g R R libdao8111.sl 2 ORACLE ORACLE /opt/dabroker DABroker /opt/dabroker DABroker /opt/dabroker 1. DABroker 107

132 3. DABroker UNIX DABroker cd /opt/dabroker/lib Oracle 10g R R mv libdao7101.a libdao7101.a_bk Oracle 11g R R mv libdao7111a libdao7111.a_bk DABroker for Java Oracle8i Oracle 10g R R mv libdao8101.a libdao8101.a_bk DABroker for Java Oracle8i Oracle 11g R R mv libdao8111.a libdao8111.a_bk 2. DABroker ORACLE 1 DABroker 2 DABroker 3 ORACLE OS DABroker ORACLE ORACLE OCI ORACLE OCI ORACLE OS 4 DABroker 5 Oracle 10g R R /opt/dabroker/sample/oramake Oracle 10g R R PROGRAM= libdao7101.so 2 LIBS = -L $(DABDIR)/lib -ldacommon 3 ORALIB=-L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/ rdbms/lib -lclntsh 108

133 3. DABroker UNIX 3 LDFLAGS = -ldl -lnsl -lpthread -G 4 OBJS = $(DABDIR)/obj/dacdcntl.o $(DABDIR)/obj/daO7101.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM) $(OBJS) $(LIBS) $(ORALIB) $(LDFLAGS) echo "done" Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R PROGRAM= libdao7111.so 2 LIBS = -L $(DABDIR)/lib -ldacommon 3 ORALIB= -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/ rdbms/lib -lclntsh 3 LDFLAGS = -ldl -lnsl -lpthread -G 4 OBJS = $(DABDIR)/obj/dacdcntl.o $(DABDIR)/obj/daO7111.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM) $(OBJS) $(LIBS) $(ORALIB) $(LDFLAGS) echo "done" DABroker for Java Oracle8i Oracle 10g R R /opt/dabroker/sample/oramake Oracle 10g R R (DABroker for Java Oracle8i ) 1 PROGRAM= libdao8101.so 2 LIBS = -L $(DABDIR)/lib -ldacommon 3 ORALIB= -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/ rdbms/lib -lclntsh 3 LDFLAGS = -ldl -lnsl -lpthread -G 4 OBJS = $(DABDIR)/obj/dacd8101.o $(DABDIR)/obj/daO8101.a 109

134 3. DABroker UNIX 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM) $(OBJS) $(LIBS) $(ORALIB) $(LDFLAGS) echo "done" DABroker for Java Oracle8i Oracle 11g R R /opt/dabroker/sample/oramake Oracle 11g R R (DABroker for Java Oracle8i ) 1 PROGRAM= libdao8111.so 2 LIBS = -L $(DABDIR)/lib -ldacommon 3 ORALIB= -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/ rdbms/lib -lclntsh 3 LDFLAGS = -ldl -lnsl -lpthread -G 4 OBJS = $(DABDIR)/obj/dacd8111.o $(DABDIR)/obj/daO8111.a 5 all:$(program) 5 $(PROGRAM): $(OBJS) echo "Linking $(PROGRAM)..." ld -o $(PROGRAM) $(OBJS) $(LIBS) $(ORALIB) $(LDFLAGS) echo "done" 3. DABroker ORACLE make B ORACLE_HOME ORACLE HOME export ORACLE_HOME DABDIR = /opt/dabroker export DABDIR Oracle 10g R R make -f Oramake7101 Oracle 11g R R make -f Oramake7111 DABroker for Java Oracle8i Oracle 10g R R

135 3. DABroker UNIX make -f Oramake8101 DABroker for Java Oracle8i Oracle 11g R R make -f Oramake ORACLE DABroker make ORACLE ORACLE make Oracle 10g R R cp libdao7101.sl /opt/dabroker/lib/libdao7101.sl Oracle 11g R R cp libdao7111.sl /opt/dabroker/lib/libdao7111.sl DABroker for Java Oracle8i Oracle 10g R R cp libdao8101.sl /opt/dabroker/lib/libdao8101.sl DABroker for Java Oracle8i Oracle 11g R R cp libdao8111.sl /opt/dabroker/lib/libdao8111.sl 5. DABroker ORACLE /opt/dabroker/lib DABroker Oracle9i Oracle10g Oracle9i Oracle10g DABroker Oracle9i TIMESTAMP(fractional_seconds_precision) TIMESTAMP(fractional_seconds_precision) WITH TIME ZONE TIMESTAMP(fractional_seconds_precision) WITH LOCAL TIME ZONE INTERVAL YEAR(year_precision) TO MONTH INTERVAL DAY(day_precision) TO SECOND (fractional_seconds_precision) DABroker 111

136 3. DABroker UNIX 3-21 Oracle10g DABroker BINARY_FLOAT BINARY_DOUBLE 112

137 4 DABroker Windows Windows DABroker DABroker DABroker 4.5 DABroker 4.6 DABroker 4.7 DABroker (Database Connection Server DB ) 4.8 DABroker 4.9 DABroker

138 4. DABroker Windows 4.1 DABroker DBMS DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD Database Connection Server Database Connection Server DABroker DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker DABroker 114

139 4. DABroker Windows 4-1 DABroker DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD 4-2 DABroker (2) 4-2 DABroker 115

140 4. DABroker Windows 4-2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker 4.4 DABroker 4.5 DABroker 4.6 DABroker 4.7 DABroker (Database Connection Server DB ) 116

141 4. DABroker Windows 4.2 DABroker DABroker DABroker DABroker DABroker HiRDB ORACLE HiRDB ORACLE SQL Server DABroker DBMS DBMS 1.2 DABroker DABroker DBMS Database Connection Server DABroker Windows DABroker 1. Administrators 2. DABroker Program Files HITACHI DABroker DABroker 117

142 4. DABroker Windows 5. DABroker 6. DABroker Path DABroker lib DABroker 1 DABroker 4-1 DABroker 4-1 DABroker DABroker bin lib AGT AGTGRP msg conf spool tmp patch_dab DABroker DABroker DABroker 118

143 4. DABroker Windows 4.3 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD [Windows ] SYSTEM32 DRIVERS ETC SERVICES DABroker Database Connection Server [Windows ] SYSTEM32 DRIVERS ETC SERVICES DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD [Windows ] SYSTEM32 DRIVERS ETC SERVICES TCP/IP DABroker DABROKER_SV XXXXX/tcp DABROKER_SV DABroker XXXXX tcptcp/ip XXXXX DABroker NIS Network Information Service NIS NIS NIS DABroker IP Windows DABroker DABroker Windows [Windows ] SYSTEM32 DRIVERS ETC HOSTS PC IP [Windows ] SYSTEM32 DRIVERS ETC NETWORKS 119

144 4. DABroker Windows Windows Database Connection Server Database Connection Server DABroker Database Connection Server 4.7 DABroker (Database Connection Server DB ) Database Connection Server Database Connection Server [Windows ] SYSTEM32 DRIVERS ETC SERVICES Database Connection Server Database Connection Server ( ) DBCSV DBCSV 40179/tcp DABroker Database Connection Server 4.7 DABroker (Database Connection Server DB ) Database Connection Server ( ) Windows DABroker DABroker Windows [Windows ] SYSTEM32 DRIVERS ETC HOSTS Database Connection Server IP [Windows ] SYSTEM32 DRIVERS ETC NETWORKS Windows 120

145 4. DABroker Windows 4.4 DABroker DABroker DABroker DABroker conf dasysconf DABroker 1 DABroker Windows Administrators 2 DABroker DABroker 1. DABroker 121

146 4. DABroker Windows DABroker 3. OK 122

147 4. DABroker Windows 4.5 DABroker DABroker for Java Version 2 DABroker HiRDB BLOB ORACLE LONG ODBC3.0 LONG Database Connection Server BLOB DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD Database Connection Server Database Connection Server DABroker DABTMP DABroker tmp DABroker SQL

148 4. DABroker Windows 2 DABDBA_TIMEOUT Database Connection Server DABroker DABroker DBMS 0 3 DABSELECTCOLCNT DBMS SQL DBMS SQL Anywhere DBMS SQL SQL 124

149 4. DABroker Windows HiRDB ORACLE DBMS SQL DBMS 4 DABSELECTINFCNT DBMS SQL DBMS SQL Anywhere DBMS SQL SQL HiRDB ORACLE DBMS SQL DBMS 5 dabsv.logdabsvlogsize DABroker DABroker spool dabsv.log spool dabsvdemon.log 125

150 4. DABroker Windows dabsv.logold,dabsvdemon.logold 6 ORACLE DABORACLE_TYPE ORACLE10g ORACLE10g ORACLE11g ORACLE12c ORACLE 7 HiRDB DABSQL_HiRDB_DICTIONARY_DATATYPE C VARCHAR M C HiRDB M MVARCHAR C VARCHAR HiRDB SQL 8 HiRDB 126

151 4. DABroker $ % & * + - / :? 1 DABroker for Java 9 DABSQL_TRCSIZE DABroker DABroker spool db_access DABroker db_xxxxx XXXXX 4.9.2(3) DABroker 127

152 4. DABroker Windows 10 DABEXSQL_TRC_LINE OFF OFF ON OFFON OFF ON 4.5.1(11) (10) DABEXSQL_TRC_LINE ON

153 4. DABroker Windows 12 XA DABXA_LOG_ERROR ON ON OFF ON OFF XA XA DABroker spool db_xainfo.log XA (db_xainfo.log) XA DABCLIENT_TIMEOUT DABroker DABroker 0 129

154 4. DABroker Windows 2 DABMAXUSERS DABroker 3 DABDBANUMBER DABroker 4 1 DABMAXBLOCKUSERS ORACLE 1 ORACLE 1 1 Database Connection Server 1 DABroker 130

155 4. DABroker Windows 5 DABMAXPROCESS DABroker 6 HiRDB BLOB DABHIRDBA_BLOBBUFSIZE HiRDB BLOB HiRDB DABroker 0 DBMS DABroker for Java Version 2 DABroker 7 ORACLE LONG DABORADBA_LONGBUFSIZE

156 4. DABroker Windows ORACLE LONG ORACLE DABroker 0 DBMS DABroker for Java Version 2 DABroker DABroker for Java Version 2 Oracle8i 8 ODBC3.0 LONG DABODBC30_LONGBUFSIZE ODBC3.0 LONG DABroker 0 DBMS DABroker for Java Version 2 DABroker 9 Database Connection Server BLOB DABDBSDBA_BLOBBUFSIZE

157 4. DABroker Windows Database Connection Server BLOB DABroker 0 DBMS DABroker for Java Version 2 DABroker 10DABLANGMODE SJIS JIS SJIS JIS EUC EUC ASCII ASCII UTF-8 UTF-8 DABroker DABroker JIS EUC ASCII UTF-8 HiRDB ORACLE SQL Server VOS3 XDM/RD VOS3 XDM/SD VOS1 RDB1 E2 VOSK SQL/K VOS1 PDMII E2 VOSK 133

158 4. DABroker Windows DABroker DABroker DABroker for Java DAB_LANG JDBC DABroker for JavaTM Version 2 DABroker Driver for JavaTM Technology ENCODELANG DABroker EUC ASCII UTF TCP/IP DABKEEPALIVE OFF ON OFF ON OFF TCP/IP ON OFF 12 IP DABIPCONVERT ON ON OFF IP ON 134

159 4. DABroker Windows IP OFF IP 13 DABTCP_TRCSIZE DABroker DABroker spool dabcltrc DABroker XXXXXXXX.cmt XXXXXXXX.cmt_AA AA XXXXXXXX AA AA 4.9.2(2) DABroker Database Connection Server Database Connection Server 135

160 4. DABroker Windows 1 IP DAB_DBS_HOST localhost Database Connection Server IP 2 DAB_DBS_PORT 0 Database Connection Server [Windows ] SYSTEM32 DRIVERS ETC SERVICES Database Connection Server 3 DAB_DBS_SEND_BUFFER_SIZE Database Connection Server 4 DAB_DBS_RECEIVE_BUFFER_SIZE Database Connection Server DABroker OTHERS DABroker dasysconf DABroker conf 136

161 4. DABroker Windows 1 DAB_DEMON_LOG_MODE LIMITED

162 4. DABroker Windows 4.6 DABroker DABroker for ODBC DBPARTNER DABroker for Java Database Connection Server Database Connection Server OTS Java JTS DABroker [DABroker conf dabenv] 1 Administrators 2 1. DABroker 138

163 4. DABroker Windows HiRDB 139

164 4. DABroker Windows HiRDB < > HiRDB (DBHOST) (DBNAME) ID(USERID) (PASSWD) < > 23 2 < > 23 2 HiRDB ID 140

165 4. DABroker Windows HiRDB HiRDB HiRDB < > 1024 PDHOST IP PDNAMEPORT PDHOST PDNAMEPORT PDHOST PDNAMEPORT DABroker DABroker HiRDB HiRDB < > 30 2 DABroker ID ID DABroker 2 ORACLE (DBNAME) < > 23 2 < > 23 2 SQL*NET ORACLE 141

166 4. DABroker Windows ID(USERID) (PASSWD) ID ID ID DABroker 3 ODBC3.0 (DBHOST) ODBC (DBNAME) ID(USERID) (PASSWD) < > 23 2 < > 23 2 SQLServer SQL Server ODBC3.0 ; ODBC3.0 ID ID ID DABroker 142

167 4. DABroker Windows 4 Database Connection Server < > 23 2 < > 23 2 XDM/RD VOS3 XDM/RD XDM/SD VOS3 XDM/SD SQL/K VOSK SQL/K VOSKSPOOL VOSK RDB1 VOS1 RDB1 E2 VOS1PDM2 VOS1 PDMII E2 DABroker DBPARTNER (DBHOST) (DBNAME) ID(USERID) (PASSWD) (SNDBUF) (RCVBUF) 4.7 DABroker (Database Connection Server DB ) Database Connection Server RD ID Database Connection Server ( ) 4.7 DABroker (Database Connection Server DB ) DABroker Database Connection Server ( ) 4.7 DABroker (Database Connection Server DB ) DABroker 143

168 4. DABroker Windows ID ID DABroker 5 144

169 4. DABroker Windows 4.7 DABroker (Database Connection Server DB ) Database Connection Server DBPARTNER 4.6 DABroker Database Connection Server DABroker Database Connection Server 1 Database Connection Server 2 Database Connection Server (1)(2) 145

170 4. DABroker Windows Database Connection Server 1Database Connection Server IP Database Connection Server Database Connection Server Database Connection Server [Windows ] SYSTEM32 DRIVERS ETC SERVICES

171 4. DABroker Windows 1 DABroker Database Connection Server DABroker Database Connection Server Database Connection Server TCP/IP 1 TCP/IP DABroker Database Connection Server (1) 1TCP/IP 1 TCP/IP Database Connection Server DABroker DABroker TCP/IP TCP/IP DABroker TCP/IP DABroker TCP/IP DABroker TCP/IP 1TCP/IP DABroker 1 TCP/IP = DABroker = 4-5 1TCP/IP 2 1 DABroker Database Connection Server DBPARTNER TCP/IP DABroker 147

172 4. DABroker Windows TCP/ IP DABroker DABroker Database Connection Server TCP/IP >0 DABroker =0 ( ) ( ) TCP/IP 1TCP/IP 4-5 DABroker Database Connection Server (2) TCP/IP 4-4 TCP/IP TCP/IP 1 148

173 4. DABroker Windows 1 TCP/IP 1 TCP/IP DABroker 1TCP/IP DABroker 1 1TCP/IP 1. DABroker Database Connection Server Database Connection Server 2. 1 * 2 DABroker Database Connection Server 1 1 TCP/IP Database Connection Server ( ) TCP 149

174 4. DABroker Windows Database Connection Server 6 Database Connection Server 7 6 DABroker TCP/IP Database Connection Server 1 1TCP/IP 7 DABroker DABroker DABroker 1 1TCP/IP

175 4. DABroker Windows [DABroker conf damconenv] < > 151

176 4. DABroker Windows Database Connection Server Database Connection Server Database Connection Server Database Connection Server < >DABroker Database Connection Server DABroker Database Connection Server ( IP DAB_DBS_HOST) Database Connection Server Database Connection Server [Windows ] SYSTEM32 DRIVERS ETC SERVICES 4.3 DABroker Database Connection Server ( DAB_DBS_PORT) Database Connection Server

177 4. DABroker Windows Database Connection Server Database Connection Server DBPARTNER Database Connection Server Database Connection Server DABroker DABroker Database Connection Server

178 4. DABroker Windows 4.8 DABroker DABroker Windows Administrators 2 DABroker 1. DBMS 2. DABroker 3. DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD a DABroker b DABroker Windows DABroker Windows Administrators 2 DABroker 154

179 4. DABroker Windows 1. DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD 2. DABroker 3. DBMS 3 DABroker DABroker DABroker DABroker DABroker DABroker 4 a DABroker DABroker DABroker 155

180 4. DABroker Windows b DABroker 156

181 4. DABroker Windows 4.9 DABroker DABroker DABroker DABroker DABroker IP DABroker 1 Administrators DABroker DABrokerDABroker DABroker DABroker DABroker 2 DABroker DABroker 157

182 4. DABroker Windows IP IP 64 DABroker hosts [Windows ] SYSTEM32 DRIVERS ETC 3 DABroker 4.9.1(2) 1. DABroker 158

183 4. DABroker Windows 2. DABroker DABroker DABroker DABroker DABroker DABroker DABroker spool dabcltrc DABroker DBMS DBMS DABroker DABroker spool db_access DABroker DABroker DABroker DABrokerDABroker 159

184 4. DABroker Windows DABroker DABroker 2 DABroker IP IP IP IP 3. DABroker spool DABTT.TXT (3) 160

185 4. DABroker Windows IPADDR=XXXXXXXX IP PROT=XXX TCP TCP/IP PAP-NAME=XXXXXX DABroker DBPARTNER/Client DBPARTNER/Web DBPARTNER/Client DBPARTNER/Web DBPARTNER Library DBPARTNER Library XDM/RD XDM/RD DATE / / TIME : :.nn n/100 EVT DABroker PUT GET SIZE DATA aa aa <bb bb> cc cc,dd dd aa aa Connect Database Disconnect Database Disconnect Connection Commit 161

186 4. DABroker Windows Rollback LIST Table LIST Column LIST Index LIST Table Privileges LIST Column Privileges EXT-CMD SQL Fetch Option File Delete Cancel Illegal Request Connection Result Error Result Cancel Error Cancel Procedure(List Prepare Procedure) Procedure(List Fetch Procedure) Procedure(List Close Procedure) Procedure(List Prepare Column) Procedure(List Fetch Column) Procedure(List Close Column) Procedure(Parameter Get) Procedure(Prepare) Procedure(Execute) Procedure(Extended Execute) AUTO Commit OFF AUTO Commit ON SQL SQL SQL DBMS DBMS DBMS AUTO COMMIT AUTO COMMIT bb bb LIST xxxxx EXT-CMD cc cc dd dd 162

187 4. DABroker Windows 80+ * 2 PUT GET * 36 PUT GET 3 DABroker UAP ID UAP UAP DABroker DBPARTNER/Client DBPARTNER/Web ( DABroker ) DBPARTNER/Client DBPARTNER/Web ID ID ID ID UAP UAP ID ID 3. DABroker spool DABDT.TXT

188 4. DABroker Windows UID=XXXXXXXX ID PAPNAME=XXXXXXX [UAP ] DBNAME=XXXXXXX HiRDB HiRDB Version 7 HiRDB Version 8 HiRDB Version 9 ORACLE7 Oracle10g Oracle11g Oracle12c Oracle Call Interface 7 ORACLE8i Oracle10g Oracle11g Oracle12c Oracle Call Interface 8i ODBC3.0 SQL Server DBCSV Database Connection Server DATE / / TIME : :.nn n/100 EVT DABroker EVT CONNECT PREPARE DESCRIBE SQL SQL 164

189 4. DABroker Windows EVT DECLARE OPEN FETCH CLOSE EXECUTE COMMIT ROLLBACK DISCONNECT CANCEL LOGGING SELECT SQL DBMS DBMS DBMS HiRDB LOGLESS DBMS DBMS HiRDB AUTOCOMOFF AUTOCOMON AUTO COMMIT AUTO COMMIT 4.5.1(9) DABSQL_TRCSIZE RETCODE DABroker DBMS 0 0 DABroker DBMS RETCODE INFORMATION FETCH ORACLE BLOCK COUNT XXX (SQL) SQL SQL Server EVT PREPARE (SQL) ODBC:{SQLTables} 165

190 4. DABroker Windows (SQL) ODBC:{SQLColums} (SQL) ODBC:{SQLTablePrivileges} (SQL) ODBC:{SQLColumnPrivileges} (SQL) ODBC:{SQLStatistics} (SQL) ODBC:{SQLProcedures} (SQL) ODBC:{SQLProcedureColumns} (SQL) ODBC:{SQLPrimaryKeys} Database Connection Server EVT PREPARE (SQL) DBCSV:{SQLTable} (SQL) DBCSV:{SQLColumns} (SQL) DBCSV:{SQLTablePrivileges} (SQL) DBCSV:{SQLColumnsPrivileges} (SQL) DBCSV:{SQLStatistics} (SQL) DBCSV:{ProcedureList} (SQL) DBCSV:{ProcedureColumns} Database Connection Server XDM/RD SQL 1 80 SQL {( SQL * 2) + 2 [ + ( SQL /73) -1] } * 80 SQL

191 4. DABroker Windows Database Connection Server DABroker a Windows Administrators b DABroker DABroker Connection Multi Windows 2 a Windows Administrators b Database Connection Server 167

192 4. DABroker Windows DABroker Database Connection Server Database Connection Server DABroker c DABrokerDABroker DABroker DABroker DABroker Connection Multi ID ID DABroker Database Connection Server ID DABroker 168

193 4. DABroker Windows 1 Administrators DABroker DABroker DABroker DABroker 2 DABroker Database Connection Server TCP/IP ID ID ID 169

194 4. DABroker Windows USE POOL ID ID ID ID ID ID DABroker ID Database Connection Server 4.7 DABroker (Database Connection Server DB ) 170

195 5 DABroker DABroker 5.1 DABroker 5.2 DBPARTNER 171

196 5. DABroker 5.1 DABroker ID ID ID DBMS DABroker UNIX 3.6 DABroker Windows 4.6 DABroker DABroker 2 DBPARTNER HITSENSER5 DBPARTNER Library XDM/RD DABroker DABroker UNIX HiRDB ORACLE DABroker DABroker HiRDB HiRDB 172

197 5. DABroker ORACLE ORACLE 3 Database Connection Server Database Connection Server UNIX 3.6 DABroker Windows 4.6 DABroker UNIX 3.9 DABroker (Database Connection Server DB ) Windows 4.7 DABroker Database Connection Server DB 4 SQL Server(ODBC3.0) (Windows ) SQL Server(ODBC3.0) ODBC DABroker DBPARTNER DBPARTNER DABroker DBPARTNER 173

198 5. DABroker 5.2 DBPARTNER DABroker DBPARTNER DBPARTNER DABroker DBPARTNER DABroker DABMAXPROCESS 1 DABBLOCKUSERS DABMAXUSERS 1 DABroker UNIX 3.4 DABroker Windows 4.4 DABroker 174

199 6 DABroker DABroker UNIX Windows DABroker UNIX 6.5Windows

200 6. DABroker 6.1 DABroker 7. DABroker DABroker DABroker DABroker DBMS DBMS DABroker DABroker UNIX DABroker.HTC_2340.inf 1 DABroker a DABroker spool UNIX DABroker /spool/dabsv.log dabsv.logold 176

201 6. DABroker Windows DABroker spool dabsv.log dabsv.logold UNIX DABroker /spool/db_access Windows DABroker spool db_access UNIX DABroker /spool/dabcltrc Windows DABroker spool dabcltrc XA UNIX DABroker /spool/db_xainfo.log Windows DABroker spool db_xainfo.log UNIX DABroker /spool/dabsvdemon.log Windows DABroker spool dabsvdemon.log UNIX DABroker /spool/dabevttrcerr1 dabevttrcerr2 Windows DABroker spool dabevttrcerr1 dabevttrcerr2 UNIX 2GB Windows 4GB 177

202 6. DABroker b DABroker DABroker UNIX DABroker /conf/dasysconf Windows DABroker conf dasysconf UNIX DABroker /conf/dadbenv Windows DABroker conf dadbenv UNIX /opt/dabroker/.dabrokerenv UNIX DABroker /conf/damconenv Windows DABroker conf damconenv c UNIX dabdbtrc dabdbtrc Windows DABroker 4.9.2(3) UNIX dabcltrc dabcltrc

203 6. DABroker Windows DABroker 4.9.2(2) 2 a UNIX HP-UX /var/adm/syslog/syslog.log Linux /var/log AIX /var/adm/ras DABroker core b Windows Windows 3 XA XA XA XA UNIX DABroker /spool/db_xainfo.log Windows DABroker spool db_xainfo.log XA UNIX 3.4 DABroker Windows 4.4 DABroker 179

204 6. DABroker XA XA 180

205 6. DABroker 6.2 DABroker DABroker DBPARTNER DABroker DABroker DBPARTNER DBPARTNER DABroker DBPARTNER DBPARTNER DBPARTNER DABroker DBPARTNER Database Connection Server DABroker Database Connection Server TCP/IP Database Connection Server Database Connection Server DABroker Database Connection Server TCP/IP 181

206 6. DABroker XA XA XA XA UNIX DABroker /spool/db_xainfo.log Windows DABroker spool db_xainfo.log XA UNIX 3.4 DABroker Windows 4.4 DABroker XA XXXX/XX/XX XX:XX:XX.XXXXXX [XXX:XXX] ID ID [XXXX:FFFF] XXXX "call" "end" 182

207 6. DABroker FFFF XA rmid=rrrr RMID flags=ffff RMName="nnnn" RM xa_info="iiii" XA xa_open() xa_close() xid=[ffff:gggg:bbbb:dddd] XID ffff ID gggg ID bbbb dddd XID xa_open() xa_close() count=cccc xa_recover() return code = rrrr XA "end" UNIX DABroker /spool/dabsvdemon.log Windows DABroker spool dabsvdemon.log DABSVLOGSIZE 3.5 DABroker UNIX 4.5 DABroker Windows 183

208 6. DABroker ID DABroker KFDB301YM-I Clean up. {xxx,yyy,zzz}, {sss} xxx yyy zzz sss DABroker ID DABroker KFDB302YM-I dabtcpdmn {xxx} start. [yyyy] xxx dabtcpdmn yyyy ID 184