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

209 6. DABroker ID DABroker KFDB303YM-I dabtcpdmn end. [xxxx] yyyy ID DABroker DABMAXBLOCKUSERS 2 DABroker 1 KFDB301YM-I DABroker dasysconf OTHERS DAB_DEMON_LOG_MODE=LIMITED DAB_DEMON_LOG_MODE UNIX 4.5.4Windows 185

210 6. DABroker 6.4UNIX UNIX DABroker 3.5.1(3) DABSQL_TRCSIZE (10) DABEXSQL_TRC_LINE ON OFF 3.5.1(3) DABSQL_TRCSIZE 0 ON 1 DABSQL_TRC_CONNECT CONNECT ON ON OFF ON OFF 186

211 6. DABroker 2 DABSQL_TRC_DISCONNECT DISCONNECT ON ON OFF ON OFF 3 DABSQL_TRC_COMMIT COMMIT ON ON OFF ON OFF 4 DABSQL_TRC_ROLLBACK ROLLBACK ON ON OFF ON OFF 5 DABSQL_TRC_PREPARE PREPARE ON ON OFF ON OFF SQL 187

212 6. DABroker 6 DABSQL_TRC_DESCRIBE DESCRIBE ON ON OFF ON OFF SQL SQL DESC_IN DESC_OUT 7 DABSQL_TRC_DECLARE DECLARE ON ON OFF ON OFF SELECT 8 DABSQL_TRC_OPEN OPEN ON ON OFF ON OFF 9 DABSQL_TRC_FETCH FETCH ON ON OFF ON OFF 188

213 6. DABroker 10 DABSQL_TRC_EXECUTE EXECUTE ON ON OFF ON OFF SQL 11 DABSQL_TRC_CLOSE CLOSE ON ON OFF ON OFF 12 DABSQL_TRC_CANCEL CANCEL ON ON OFF ON OFF 13 DABSQL_TRC_LOGGING LOGGING ON ON OFF ON OFF 189

214 6. DABroker LOGGING 14 DABSQL_TRC_LOGLESS LOGLESS ON ON OFF ON OFF LOGLESS 15 DABSQL_TRC_ATTACH ATTACH ON ON OFF ON OFF 16 DABSQL_TRC_ATTRGET ATTRGET ON ON OFF ON OFF 17 DABSQL_TRC_ATTRSET ATTRSET ON 190

215 6. DABroker ON OFF ON OFF 18 DABSQL_TRC_BIND BIND ON ON OFF ON OFF 19 DABSQL_TRC_CHARFORM CHARFORM ON ON OFF ON OFF 20 DABSQL_TRC_CHARID CHARID ON ON OFF ON OFF ID 191

216 6. DABroker 21 DABSQL_TRC_DEFINE DEFINE ON ON OFF ON OFF 22 DABSQL_TRC_DESALLOC DESALLOC ON ON OFF ON OFF 23 DABSQL_TRC_DESCANY DESCANY ON ON OFF ON OFF 24 DABSQL_TRC_DESFREE DESFREE ON ON OFF ON OFF 192

217 6. DABroker 25 DABSQL_TRC_DETACH DETACH ON ON OFF ON OFF 26 DABSQL_TRC_ENVCREATE ENVCREATE ON ON OFF ON OFF 27 DABSQL_TRC_ERRGET ERRGET ON ON OFF ON OFF 28 DABSQL_TRC_GETPIECE GETPIECE ON 193

218 6. DABroker ON OFF ON OFF HiRDB DABroker for Java HiRDB POSITION DABroker for Java HiRDB HiRDB DABroker for Java DABroker SQL SET POSITION 29 DABSQL_TRC_HDLALLOC HDLALLOC ON ON OFF ON OFF 30 DABSQL_TRC_HDLFREE HDLFREE ON ON OFF ON OFF 194

219 6. DABroker 31 DABSQL_TRC_LOBCLOSE LOBCLOSE ON ON OFF ON OFF BFILE 32 DABSQL_TRC_LOBLEN LOBLEN ON ON OFF ON OFF LOB HiRDB DABroker for Java LOB HiRDB LENGTH DABroker for Java HiRDB HiRDB DABroker for Java DABroker SQL SET LENGTH 33 DABSQL_TRC_LOBOPEN LOBOPEN ON 195

220 6. DABroker ON OFF ON OFF BFILE 34 DABSQL_TRC_LOBREAD LOBREAD ON ON OFF ON OFF LOB HiRDB DABroker for Java LOB HiRDB SUBSTR DABroker for Java HiRDB HiRDB DABroker for Java DABroker SQL SET SUBSTR 35 DABSQL_TRC_LOBWRITE LOBWRITE ON ON OFF ON OFF LOB 196

221 6. DABroker 36 DABSQL_TRC_PARAMGET PARAMGET ON ON OFF ON OFF 37 DABSQL_TRC_SESBEGIN SESBEGIN ON ON OFF ON OFF 38 DABSQL_TRC_SESEND SESEND ON ON OFF ON OFF 39 DABSQL_TRC_SETPIECE SETPIECE ON ON OFF ON OFF 197

222 6. DABroker 40 DABSQL_TRC_GETDIAG GETDIAG ON ON OFF ON OFF 41 DABSQL_TRC_AUTO_COMMIT_OFF AUTO COMMIT OFF ON ON OFF ON OFF AUTO COMMIT OFF 42 DABSQL_TRC_AUTO_COMMIT_ON AUTO COMMIT ON ON ON OFF ON OFF AUTO COMMIT ON 43 DABSQL_TRC_GET_INFO GET INFO ON 198

223 6. DABroker ON OFF ON OFF 44 DABSQL_TRC_SET_INFO SET INFO ON ON OFF ON OFF 45 DABSQL_TRC_EXECUTE_DIRECT EXECUTE DIRECT ON ON OFF ON OFF SQL # dabdbtrc [-u ID] [-p ] DABroker DBMS DBMS DABroker 199

224 6. DABroker DABroker -u ID ID -p DABroker DBPARTNER/Client DBPARTNER/Web ( DABroker ) DBPARTNER/Client DBPARTNER/Web PAPNAME UID=XXXXXXXX ID PAPNAME=XXXXXXX 200

225 6. DABroker -p 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 DBCSV Database Connection Server DATE / / TIME : :.n n n/100 EVT DABroker EVT CONNECT PREPARE DESCRIBE DECLARE OPEN FETCH CLOSE EXECUTE COMMIT ROLLBACK DISCONNECT CANCEL CONNECT SQL SQL SELECT SQL DISCONNECT DBMS 201

226 6. DABroker DABroker RETCODE DABroker DBMS 0 0 DABroker DBMS RETCODE RDA Link for Gateway RETCODE INFORMATION Fetch BLOCK COUNT XXX (SQL) SQL SQL 1 80 SQL {( SQL * 2) + 2 [ + ( SQL /73) -1] } * 80 SQL DABroker 202

227 6. DABroker DABroker DABroker DABroker DABroker DABroker 3.5 DABroker 4 * * *- DataBase Access Information (DRV) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* * * DABroker Connect ID : AAAAA(BBBBB) Process ID : CCCCC UserID : DDDDD Client Name : EEEEE (DB ) Lang Mode : GGGGG THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT HiRDB_CONNECTION_ID (SQL)SS SS 203

228 6. DABroker DRV DABroker HiRDB HiRDB Driver Oracle8i ORACLE8i Driver Oracle Call Interface 8i Oracle7 ORACLE7 Driver Oracle Call Interface 7 Database Connection Server DBS DABroker for Java Oracle8i Date YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn DABroker Connect ID Process ID ID UserID ID DABroker for Java ORACLE OS OS authority Client Name UAP (DB ) HiRDB PDHOST HiRDB PDHOST "Not Indicator" 204

229 6. DABroker PDNAMEPORT HiRDB PDNAMEPORT "Not Indicator" Oracle SQLNET Oracle "Not Indicator" Databease Connction Server Access DataBase Node Name DB VOS3 XDM RD E2 VOS3 XDM/RD E2 VOS3 XDM SD E2 VOS3 XDM/SD E2 VOS1 RDB1 E2 VOS1 RDB1 E2 VOS1 PDMII E2 VOS1 PDM2 E2 VOSK SQL/K VOSK SQL/K VOSK VOSK SPOOL Unknown DBMS "Not Indicator" Lang Mode THREAD-ID ID CID EVT DABroker 6.4.1, OFF ON GET_DIAG 205

230 6. DABroker ATTACH ATTRGET ATTRSET AUTOCOMOFF AUTO COMMIT AUTOCOMON AUTO COMMIT BIND CHARFORM CHARID ID DEFINE DESALLOC DESC_OUT SQL DESC_IN SQL DESCANY DESFREE DETACH ENVCREATE ERRGET EXECDIRECT SQL GET_DIAG GETINFO GETPIECE HDLALLOC HDLFREE LOBCLOSE BFILE LOBLEN LOB LOBOPEN BFILE LOBREAD LOB LOBWRITE LOB PARAMGET SESBEGIN SESEND SETINFO SETPIECE START-TIME YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn END-TIME YYYY/MM/DD hh:mm:ss.nnnnnn 206

231 6. DABroker YYYY MM DD hh mm ss nnnnnn RETCODE BLOCKCNT FETCH HiRDB_CONNECTION_ID (a)hirdb ID aaaa bbbbb cccc aaaa HiRDB/Paraller Server HiRDB/Single Server bbbbb aaaa cccc aaaa ID ID ID ID HiRDB HiRDB HiRDB HiRDB HiRDB_CONNECTION_ID ID CONNECT COMMIT ROLLBACK PREPARE EXECUTE DIRECT (b)hirdb XDM/RD E2 ID aaaa bbbbb cccc aaaa JOB bbbbb cccc HiRDB XDM/RD E Database Connection Server05-00 HiRDB_CONNECTION_ID ID CONNECT COMMIT ROLLBACK PREPARE EXECUTE DIRECT (SQL) SQL 207

232 6. DABroker 5 DABroker /spool/db_access spdb_xxxxxxxx_yyyyyyyy_ ZZZZZ.IIIIII HiRDB HiRDB Oracle8i Oracle8i Oracle7 Oracle7 Database Connection Server DBS DABroker for Java Oracle8i XXXXXXXX ID YYYYYYYY ZZZZZ ID IIIIII log logold 1 6 DABroker ( 6.4.3(5) ) 1, 208

233 6. DABroker 209

234 6. DABroker 6.5 Windows Windows DABroker ON 4.5.1(10) DABEXSQL_TRC_LINE ON ON 1 CANCEL DABSQL_TRC_CANCEL ON ON OFF ON OFF DBMS 2 CLOSE DABSQL_TRC_CLOSE ON ON OFF ON OFF 210

235 6. DABroker 3 COMMIT DABSQL_TRC_COMMIT ON ON OFF ON OFF 4 CONNECT DABSQL_TRC_CONNECT ON ON OFF ON OFF 5 DECLARE DABSQL_TRC_DECLARE ON ON OFF ON OFF SELECT 6 DESCRIBE DABSQL_TRC_DESCRIBE ON 211

236 6. DABroker ON OFF ON OFF SQL 7 DISCONNECT DABSQL_TRC_DISCONNECT ON ON OFF ON OFF 8 EXECUTE DABSQL_TRC_EXECUTE ON ON OFF ON OFF SQL 9 FETCH DABSQL_TRC_FETCH ON ON OFF ON OFF 212

237 6. DABroker 10 LOGGING DABSQL_TRC_LOGGING ON ON OFF ON OFF LOGGING 11 LOGLESS DABSQL_TRC_LOGLESS ON ON OFF ON OFF LOGLESS 12 PREPARE DABSQL_TRC_PREPARE ON ON OFF ON OFF SQL 13 ROLLBACK DABSQL_TRC_ROLLBACK ON ON OFF ON OFF 213

238 6. DABroker 14 OPEN DABSQL_TRC_OPEN ON ON OFF ON OFF 15 ATTACH DABSQL_TRC_ATTACH ON ON OFF ON OFF DABroker for Java Oracle8i 16 ATTRGET DABSQL_TRC_ATTRGET ON ON OFF ON OFF 214

239 6. DABroker DABroker for Java Oracle8i 17 ATTRSET DABSQL_TRC_ATTRSET ON ON OFF ON OFF DABroker for Java Oracle8i 18 BIND DABSQL_TRC_BIND ON ON OFF ON OFF 19 CHARFORM DABSQL_TRC_CHARFORM ON ON OFF ON OFF 215

240 6. DABroker DABroker for Java Oracle8i 20 CHARID DABSQL_TRC_CHARID ON ON OFF ON OFF ID DABroker for Java Oracle8i 21 DEFINE DABSQL_TRC_DEFINE ON ON OFF ON OFF DABroker for Java Oracle8i 22 DESALLOC DABSQL_TRC_DESALLOC ON ON OFF ON OFF 216

241 6. DABroker DABroker for Java Oracle8i 23 DESCANY DABSQL_TRC_DESCANY ON ON OFF ON OFF DABroker for Java Oracle8i 24 DESFREE DABSQL_TRC_DESFREE ON ON OFF ON OFF DABroker for Java Oracle8i 25 DETACH DABSQL_TRC_DETACH ON ON OFF ON OFF 217

242 6. DABroker DABroker for Java Oracle8i 26 ENVCREATE DABSQL_TRC_ENVCREATE ON ON OFF ON OFF DABroker for Java Oracle8i 27 ERRGET DABSQL_TRC_ERRGET ON ON OFF ON OFF DABroker for Java Oracle8i 28 GETPIECE DABSQL_TRC_GETPIECE ON ON OFF 218

243 6. DABroker ON OFF HiRDB DABroker for Java HiRDB POSITION DABroker for Java HiRDB HiRDB DABroker for Java DABroker SQL SET POSITION 29 HDLALLOC DABSQL_TRC_HDLALLOC ON ON OFF ON OFF DABroker for Java Oracle8i 30 HDLFREE DABSQL_TRC_HDLFREE ON ON OFF ON OFF 219

244 6. DABroker DABroker for Java Oracle8i 31 LOBCLOSE DABSQL_TRC_LOBCLOSE ON ON OFF ON OFF BFILE DABroker for Java Oracle8i 32 LOBLEN DABSQL_TRC_LOBLEN ON ON OFF ON OFF LOB HiRDB DABroker for Java LOB HiRDB LENGTH DABroker for Java 220

245 6. DABroker HiRDB HiRDB DABroker for Java DABroker SQL SET LENGTH 33 LOBOPEN DABSQL_TRC_LOBOPEN ON ON OFF ON OFF BFILE DABroker for Java Oracle8i 34 LOBREAD DABSQL_TRC_LOBREAD ON ON OFF ON OFF LOB HiRDB DABroker for Java LOB HiRDB SUBSTR DABroker for Java 221

246 6. DABroker HiRDB HiRDB DABroker for Java DABroker SQL SET SUBSTR 35 LOBWRIT DABSQL_TRC_LOBWRITE ON ON OFF ON OFF LOB DABroker for Java Oracle8i 36 PARAMGET DABSQL_TRC_PARAMGET ON ON OFF ON OFF DABroker for Java Oracle8i 37 SESBEGIN DABSQL_TRC_SESBEGIN ON ON OFF 222

247 6. DABroker ON OFF DABroker for Java Oracle8i 38 SESEND DABSQL_TRC_SESEND ON ON OFF ON OFF DABroker for Java Oracle8i 39 SETPIECE DABSQL_TRC_SETPIECE ON ON OFF ON OFF DABroker for Java Oracle8i 40 GETDIAG DABSQL_TRC_GETDIAG ON 223

248 6. DABroker ON OFF ON OFF 41 AUTO COMMIT OFF DABSQL_TRC_AUTO_COMMIT_OFF ON ON OFF ON OFF AUTO COMMIT 42 AUTO COMMIT ON DABSQL_TRC_AUTO_COMMIT_ON ON ON OFF ON OFF AUTO COMMIT 43 GET INFO DABSQL_TRC_GET_INFO ON ON OFF ON OFF 224

249 6. DABroker 44 SET INFO DABSQL_TRC_SET_INFO ON ON OFF ON OFF 45 EXECUTE DIRECT DABSQL_TRC_EXECUTE_DIRECT ON ON OFF ON OFF SQL DABroker DABroker DABroker 225

250 6. DABroker DABroker DABroker DABroker 4.5 DABroker 4 * * *- DataBase Access Information (DRV) -* *- Date YYYY/MM/DD hh:mm:ss.nnnnnn -* * * DABroker Connect ID : AAAAA(BBBBB) Process ID : CCCCC UserID : DDDDD Client Name : EEEEE (DB ) Lang Mode : GGGGG THREAD-ID CID EVT START-TIME END-TIME RETCODE BLOCKCNT HiRDB_CONNECTION_ID (SQL)SS SS DRV DABroker HiRDB HiRDB Driver 226

251 6. DABroker Date Oracle8i ORACLE8i Driver Oracle Call Interface 8i Oracle7 ORACLE7 Driver Oracle Call Interface 7 ODBC3.0 ODBC30 Database Connection Server DBS DABroker for Java Oracle8i YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn DABroker Connect ID Process ID UserID ID ID DABroker for Java ORACLE OS OS authority Client Name UAP (DB ) HiRDB PDHOST HiRDB PDHOST "Not Indicator" PDNAMEPORT HiRDB PDNAMEPORT "Not Indicator" 227

252 6. DABroker Oracle SQLNET Oracle "Not Indicator" ODBC3.0 ODBC Data Source ODBC "Not Indicator" Databease Connction Server ODBC Key Word Access DataBase Node Name ODBC "Not Indicator" DB VOS3 XDM RD E2 VOS3 XDM/RD E2 VOS3 XDM SD E2 VOS3 XDM/SD E2 VOS1 RDB1 E2 VOS1 RDB1 E2 VOS1 PDMII E2 VOS1 PDM2 E2 VOSK SQL/K VOSK SQL/K VOSK VOSK SPOOL Unknown DBMS "Not Indicator" Lang Mode THREAD-ID ID CID EVT DABroker 4.5.1(9) DABSQL_TRCSIZE DABroker, 228

253 6. DABroker OFF ON GET_DIAG ATTACH ATTRGET ATTRSET AUTOCOMOFF AUTO COMMIT AUTOCOMON AUTO COMMIT BIND CHARFORM CHARID ID DEFINE DESALLOC DESC_OUT SQL DESC_IN SQL DESCANY DESFREE DETACH ENVCREATE ERRGET EXECDIRECT SQL GET_DIAG GETINFO GETPIECE HDLALLOC HDLFREE LOBCLOSE BFILE LOBLEN LOB LOBOPEN BFILE LOBREAD LOB LOBWRITE LOB PARAMGET SESBEGIN SESEND SETINFO SETPIECE START-TIME YYYY/MM/DD hh:mm:ss.nnnnnn 229

254 6. DABroker YYYY MM DD hh mm ss nnnnnn END-TIME YYYY/MM/DD hh:mm:ss.nnnnnn YYYY MM DD hh mm ss nnnnnn RETCODE BLOCKCNT FETCH HiRDB_CONNECTION_ID ID aaaa bbbb cccc aaaa HiRDB/Parallel Server HiRDB/Single Server bbbb aaaa cccc aaaa ID ID ID ID HiRDB HiRDB HiRDB HiRDB HiRDB_CONNECTION_ID ID XDM/RD HiRDB_CONNECTION_ID ID CONNECT COMMIT ROLLBACK PREPARE EXECUTE DIRECT (SQL) SQL (Windows QueryPerformance Counter) 5 DABroker spool db_access spdb_xxxxxxxx_yyyyyyyy_ ZZZZZ.IIIIII 230

255 6. DABroker HiRDB HiRDB Oracle8i Oracle8i Oracle7 Oracle7 ODBC3.0 ODBC30 Database Connection Server DBS DABroker for Java Oracle8i XXXXXXXX ID YYYYYYYY ZZZZZ ID IIIIII log logold 1 6 DABroker ( 6.5.2(5) ) 1, 231

256 6. DABroker DABroker DABroker Driver for Java(TM) Technology SQL DABroker 1 YYYY/MM/DD hh:mm:ss.ssssss TID=AAAA SS..SS YYYY/MM/DD hh:mm:ss.ssssss YYYY MM DD hh mm ss ssssss AAAA ID 16 SS...SS 232

257 6. DABroker 2 YYYY/MM/DD hh:mm:ss.ssssss PID=BBBB InitID=CCCC ConID=DDDD CName=EEEE DBID=FFFF CID=GGGG(HHHH,IIII) YYYY/MM/DD hh:mm:ss.ssssss "----/--/-- --:--: " YYYY MM DD hh mm ss ssssss BBBB ID 10 CCCC DABroker ID 16 DDDD 16 EEEE UAP FFFF ID 10 ID 1 HiRDB 2 Oracle7 4 VOS3 XDM/RD 5 VOS1 RDB1 E2 6 VOSK SQL/K 7 Oracle8i 68 VOS3 XDM/RD 69 VOS1 RDB1 E2 70 VOSK SQL/K 74 VOS3 XDM/SD 75 VOS1 PDM II E2 76 VOSK 233

258 6. DABroker GGGG Database Connection Server ID 10 HHHH,IIII 3 START-TIME EXEC-TIME TID COUNT REQ-CODE DATA YYYY/MM/DD hh:mm:ss.ssssss mmmm:ss.ssssss JJJJJJJJ KKKKKKKK LLLL MMMM NNNNNNNN OOOOOOOO PP..PP MMMM 3 NOW OLD SQL PRE SQL PREPARE EXE SQL EXECUTE FET1 SQL FETCH FET SQL FETCH CLS SQL CLOSE / CMT RBK START-TIME EXEC-TIME FET1 1 FET FETCH TID ID 16 CMT RBK COUNT16 FET SQL FET 0xFFFFFFFF 0 234

259 6. DABroker REQ-CODE LLLL / MMMM DATA NNNNNNNN 1 16 OOOOOOOO 2 16 PP..PP DATA (MMMM) (NNNNNNN) (OOOOOOO) (P..PP) PRE? SQL 16 EXE SQL? FET1 FET CLS 0 0 CMT RBK NOW OLD INSERT UPDATE DELETE /05/07 13:30: TID=4040 KFPA11561-E Specified authorization identifier has no connect privilege ----/--/-- --:--: PID=1296 InitID=701 ConID=0 CName=DABLIBAP DBID=1 CID=0(0,0) START-TIME EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 13:30: : NOW

260 6. DABroker 2 SQL 2004/05/07 13:30: TID=1812 KFPA11204-E Table/index HS5."A" not found in system 2004/05/07 13:30: PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0) START-TIME EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 13:30: : FFFFFFFF 1021 NOW select * from a2004/05/07 13:30: : OLD FETCH 2 SQL 2004/05/07 13:31: TID=1812 KFPA11204-E Table/index HS5."B" not found in system 2004/05/07 13:30: PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0) START-TIME EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 13:31: : e 1021 NOW select * from b 2004/05/07 13:30: : d 1004 OLD /05/07 13:30: : PRE SELECT * FROM "H 2004/05/07 13:30: : EXE /05/07 13:30: : a 1023 FET eb /05/07 13:30: : FET 0000c d 2004/05/07 13:30: : c 1024 CLS /05/07 13:30: : d 1004 CMT 2004/05/07 13:30: : RBK 4 FETCH 1 SQL 2004/05/07 13:31: TID=1812 KFPA11204-E Table/index HS5."C" not found in system 2004/05/07 13:30: PID=1752 InitID=701 ConID=10701 CName=DABLIBAP DBID=1 CID=1(0,0) START-TIME EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 13:31: : NOW select * from c 2004/05/07 13:31: : OLD /05/07 13:31: : PRE SELECT * FROM "H 2004/05/07 13:31: : EXE 236

261 6. DABroker /05/07 13:31: : FET d /05/07 13:31: : FET d d 2004/05/07 13:31: : CLS /05/07 13:31: : CMT 2004/05/07 13:31: : f 1005 RBK 5 INSERT? EXECUTE 2004/05/07 15:37: TID=1712 KFPA11313-E Number of variables not equal to number of parameters 2004/05/07 15:35: PID=584 InitID=701 ConID=10701 CName=Select_load DBID=1 CID=1(1,0) START-TIME 000 EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 15:37: : NOW /05/07 15:36: : OLD /05/07 15:35: : PRE INSERT INTO "HS 2004/05/07 15:36: : EXE CLOSE /05/07 16:00: TID=1040 KFDB010TD-E [RequestCode= ] 2004/05/07 15:58: PID=4164 InitID=701 ConID=10701 CName=Select_load DBID=1 CID=1(4,0) START-TIME EXEC-TIME TID COUNT REQ-CODE DATA 2004/05/07 16:00: : NOW /05/07 15:58: : OLD /05/07 15:58: : PRE SELECT * FROM "H2004/05/07 15:58: : EXE /05/07 15:58: : FET d /05/07 15:58: : FET d d 2004/05/07 15:58: : CLS

262 6. DABroker DABroker /spool DABroker dabevttrcerr1 dabevttrcerr2 dabevttrcerr1.lock dabevttrcerr1 512 dabevttrcerr1 dabevttrcerr2 dabevttrcerr

263 7 DABroker

264 DABroker UNIX /dev/console Linux /var/log HP-UX /var/adm/syslog/syslog.log AIX /var/adm/ras DABroker /spool/dabsv.log dabsv.logold Windows Windows DABroker spool dabsv.log dabsv.logold [DABroker] [ ] DABroker ID 240

265 KFDBnnnnn m KFDBnnnnn m ID KFDB DABroker nnnnn DABroker DABroker DABroker Q ID DABroker 241

266 7. DBMS * Windows 1 DABroker Windows DABroker 4.5 DABroker 7-1 DABTMP DABSVLOGSIZE DABDBA_TIMEOUT DABSELECTCOLCNT DABSELECTINFCNT DABORACLE_TYPE DABSQL_HiRDB_DICTIONARY_DATATYPE DAB_HIRDB_DBINF_ESC DABSQL_TRCSIZE DABSQL_TRC_CANCEL DABSQL_TRC_CLOSE DABSQL_TRC_COMMIT DABSQL_TRC_CONNECT DABSQL_TRC_DECLARE DABSQL_TRC_DESCRIBE DABSQL_TRC_DISCONNECT DABSQL_TRC_EXECUTE dabsv.log ORACLE HiRDB HiRDB CANCEL CLOSE COMMIT CONNECT DECLARE DESCRIBE DISCONNECT EXECUTE 242

267 DABSQL_TRC_FETCH FETCH DABSQL_TRC_LOGGING LOGGING DABSQL_TRC_LOGLESS LOGLESS DABSQL_TRC_PREPARE PREPARE DABSQL_TRC_ROLLBACK ROLLBACK DABSQL_TRC_OPEN OPEN DABSQL_TRC_ATTACH ATTACH DABSQL_TRC_ATTRGET ATTRGET DABSQL_TRC_ATTRSET ATTRSET DABSQL_TRC_BIND BIND DABSQL_TRC_CHARFORM CHARFORM DABSQL_TRC_CHARID CHARID DABSQL_TRC_DEFINE DEFINE DABSQL_TRC_DESALLOC DESALLOC DABSQL_TRC_DESCANY DESCANY DABSQL_TRC_DESFREE DESFREE DABSQL_TRC_DETACH DETACH DABSQL_TRC_ENVCREATE ENVCREATE DABSQL_TRC_ERRGET ERRGET DABSQL_TRC_GETPIECE GETPIECE DABSQL_TRC_HDLALLOC HDLALLOC DABSQL_TRC_HDLFREE HDLFREE DABSQL_TRC_LOBCLOSE LOBCLOSE DABSQL_TRC_LOBLEN LOBLEN DABSQL_TRC_LOBOPEN LOBOPEN DABSQL_TRC_LOBREAD LOBREAD DABSQL_TRC_LOBWRITE LOBWRITE DABSQL_TRC_PARAMGET PARAMGET DABSQL_TRC_SESBEGIN SESBEGIN DABSQL_TRC_SESEND SESEND DABSQL_TRC_SETPIECE SETPIECE DABSQL_TRC_GETDIAG GETDIAG DABSQL_TRC_AUTO_COMMIT_OFF AUTO_COMMIT_OFF

268 7. DABSQL_TRC_AUTO_COMMIT_ON DABSQL_TRC_GET_INFO DABSQL_TRC_SET_INFO DABSQL_TRC_EXECUTE_DIRECT DABCLIENT_TIMEOUT DABMAXUSERS DABDBANUMBER DABMAXBLOCKUSERS DABMAXPROCESS DABHIRDBA_BLOBBUFSIZE DABORADBA_LONGBUFSIZE DABODBC30_LONGBUFSIZE DABDBSDBA_BLOBBUFSIZE DABLANGMODE DABKEEPALIVE DABIPCONVERT DABTCP_TRCSIZE DAB_DBS_HOST DAB_DBS_PORT DAB_DBS_SEND_BUFFER_SIZE DAB_DBS_RECEIVE_BUFFER_SIZE DAB_XA_ERROR AUTO_COMMIT_ON GET_INFO SET_INFO EXECUTE_DIRECT BLOB (HiRDB) LONG (ORACLE) LONG (ODBC3.0) BLOB (Database Connection Server) TCP/IP IP IP (Database Connection Server ) (Database Connection Server ) (Database Connection Server ) (Database Connection Server ) XA DABroker 3 244

269 DABroker Database Connection Server DB 245

270 KFDB001CM-E [errno=xxxx] Cannot allocate memory area because of insufficient memory. [errno=xxxx] XXXX: DABroker KFDB002CM-E [XXXX() errno= YYYY] An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS KFDB003CM-E An error occurred during the making of a socket for the Connection-Multi function. OS (socket) 246

271 7. KFDB004CM-E [errno=xxxx] An error occurred during the start of a Connection-Multi communication thread. [errno=xxxx] XXXX: KFDB005CM-E [damcinitproc() errno=xxxx] An error occurred during process initialization. [damcinitproc() errno=xxxx] XXXX: KFDB006CM-E [errno=xxxx] An error occurred during the opening of a named pipe. [errno=xxxx] XXXX: 247

272 7. KFDB007CM-E [errno=xxxx] An error occurred during the closing of a named pipe. [errno=xxxx] XXXX: KFDB008CM-E [errno=xxxx] An error occurred during communication of a named pipe. [errno=xxxx] XXXX: KFDB009CM-I [XXXX] The Connection-Multi communication thread will terminate. Cause:[XXXX] XXXX: CANCEL_REQUEST TERM_REQUEST 248

273 7. KFDB010CM-E The Connection-Multi communication process will terminate. kill KFDB011CM-E [XXXX] An error occurred during the start of a Connection-Multi receive thread. [XXXX] XXXX: KFDB012CM-E [XXXX] A system error occurred in the connected server system. [XXXX] XXXX: 249

274 7. DBMS KFDB013CM-E [XXXX] A system error occurred during Connection-Multi communication processing. [XXXX] XXXX: DBMS KFDB001CS-E dabcmstart Invalid argument. Usage:dabcmstart dabcmstart KFDB002CS-E DABroker A valid definition does not exist. The DABroker Connection-Multi function will terminate. DABroker DABroker MCONMAX 250

275 7. MCONPROC KFDB003CS-I DABroker Initialization processing of the DABroker Connection-Multi function has finished. DABroker DABroker Windows DABroker [ ] UNIX DABroker dabcmstart KFDB004CS-I DABroker mode=normal Termination processing of the DABroker Connection-Multi function has started. mode=normal DABroker DABroker Windows DABroker [ ] UNIX DABroker dabcmstop KFDB005CS-I DABroker mode=forced Termination processing of the DABroker Connection-Multi function has started. mode=forced DABroker DABroker 251

276 7. Windows DABroker [ ] UNIX DABroker dabcmstop -f KFDB006CS-I DABroker mode=planned Termination processing of the DABroker Connection-Multi function has started. mode=planned DABroker DABroker Windows DABroker [ ] UNIX DABroker dabcmstop -p KFDB007CS-E DABroker The DABroker Connection-Multi function is terminating in the planned termination mode. Connection is not possible. Database Connection Server DABroker DABroker DABroker Databse Connection Server KFDB008CS-E [XXXX][MCONMAX=YYYY,MCONPROC=ZZZZ] 252

277 7. The number of virtual connections exceeds the maximum that can be connected. Connection is not possible. [XXXX] [MCONMAX=YYYY,MCONPROC=ZZZZ] XXXX: YYYY: ZZZZ: (DABroker MCONMAX*MCONPROC) DABroker MCONMAX MCONPROC KFDB009CS-E DABroker The DABroker Connection-Multi function is already running. DABroker DABroker DABroker Windows DABroker [ ] UNIX DABroker dabcmstart KFDB010CS-E DABroker :[XXXX] The user does not have authorization to execute the load module of the DABroker Connection-Multi function. Name:[XXXX] XXXX: 253

278 7. DABroker DABroker UNIX DABroker dabsetup DABroker KFDB011CS-E DABroker :[XXXX] The DABroker Connection-Multi function cannot start because there are too many symbolic links. Name:[XXXX] XXXX: DABroker DABroker KFDB012CS-E DABroker :[XXXX] A load module of the DABroker Connection-Multi function was not found. Name:[XXXX] XXXX: DABroker DABroker UNIX DABroker dabsetup DABroker 254

279 7. KFDB013CS-E DABroker :[XXXX] The DABroker Connection-Multi function cannot start because of insufficient memory. Name:[XXXX] XXXX: DABroker KFDB014CS-E DABroker The user does not have authority to execute the DABroker Connection-Multi function. DABroker DABroker DABroker DABroker DABroker Windows DABroker Administrators UNIX DABroker DABroker KFDB015CS-E :XXXX The Connection-Multi communication processing terminated abnormally. Cause:XXXX XXXX: 255

280 7. kill KFDB016CS-E DABroker :XXXX The DABroker Connection-Multi function terminated abnormally. Cause:XXXX XXXX: kill DABroker DABroker DABroker UNIX DABroker $DABROKER/spool ($DABROKER DABroker ) (DABroker "core" ) KFDB018CS-W [XXXX][MCONMAX=AAAA,MCONPROC=BBBB,MCONPOOL=CCCC,MRSVPOOL=DDDD] The number of users exceeds the maximum that can be executed. [XXXX][MCONMAX=AAAA,MCONPROC=BBBB,MCONPOOL=CCCC,MRSVPOOL=DDDD] XXXX: AAAA: BBBB: CCCC: DDDD: DABroker 256

281 7. (DABroker MCONMAX*MCONPROC) DABroker KFDB020CS-E DABroker The DABroker Connection-Multi function cannot start. DABroker DABroker DABroker KFDB022CS-I DABroker Termination processing of the DABroker Connection-Multi function has finished. DABroker KFDB023CS-E The Connection-Multi communication process cannot start. KFDB024CS-E DABroker 257

282 7. The DABroker Connection-Multi function is starting. Connection is not possible. Database Connection Server DABroker Database Connection Server KFDB025CS-E DABroker The DABroker Connection-Multi function is terminating. Connection is not possible. Database Connection Server DABroker DABroker DABroker Database Connection Server KFDB026CS-E DABroker The DABroker Connection-Multi function is terminating in the forced termination mode. Connection is not possible. Database Connection Server DABroker DABroker DABroker Database Connection 258

283 7. Server KFDB027CS-E DABroker The DABroker Connection-Multi function is not running. Connection is not possible. Database Connection Server DABroker DABroker Database Connection Server KFDB028CS-E The DABroker Connection-Multi function communication process cannot start. Connection is not possible. Database Connection Server Database Connection Server KFDB029CS-E The virtual connection-allocation failed. Connection is not possible. Database Connection Server 259

284 7. Database Connection Server KFDB100CS-E (XXXX() errno=yyyy) An error occurred in a system call. (XXXX() errno=yyyy) XXXX: ( ) YYYY: ( ) OS DABroker KFDB101CS-E Required memory cannot be obtained. DABroker DABroker KFDB210CS-E [XXXX] =YYYY Invalid data was received. [XXXX] Error code=yyyy XXXX: YYYY: 260

285 7. KFDB211CS-E [XXXX] The processing request cannot be accepted because a specified Connection-Multi-name is invalid. [XXXX] XXXX: DABroker 2 1 KFDB213CS-E DABroker [XXXX] The processing request cannot be accepted because the DABroker Connection-Multi function is terminating in the planned termination mode. [XXXX] XXXX: DABroker DABroker DABroker 261

286 7. KFDB300CS-W services [XXXX][DBSPORT=YYYY] The services name and port number are not listed in the "services" file. [XXXX][DBSPORT=YYYY] XXXX: YYYY: services KFDB301CS-W hosts IP [XXXX][DBSHOST=YYYY] The host name and IP address are not listed in the "hosts" file. [XXXX][DBSHOST=YYYY] XXXX: YYYY: hosts KFDB001DB-E Required memory cannot be obtained. ErrInfo XXXX XXXX 262

287 7. KFDB002DB-E RDBMS ErrInfo XXXX The request sequence for the RDBMS is invalid. ErrInfo[XXXX] XXXX RDBMS RDBMS KFDB003DB-E ErrInfo XXXX() errno=yyyy An error occurred in a system call. ErrInfo[XXXX() errno=yyyy] XXXX YYYY OS OS KFDB004DB-I DBMS DBMS processing was canceled. DBMS DBMS 263

288 7. KFDB005DB-E DABroker XXXX A data attribute that is not supported by DABroker was found. [XXXX] XXXX (16 ) (XXXX) DABroker DABroker KFDB006DB-E DBMS DBMS user DBMS=XXXX system DBMS=YYYY nodename=zzzz The specified DBMS differs from the connected DBMS. user DBMS=XXXX system DBMS=YYYY nodename=zzzz XXXX DBMS YYYY DABroker DBMS ZZZZ RD DBMS DBMS DBMS KFDB007DB-E DABroker DABroker does not support tables containing multivalue columns and array columns. DABroker 264

289 7. KFDB011DB-E DBMS nodename=xxxx SQLCODE=YYYY Info=[ZZZZ] An error occurred in the connected DBMS. nodename=xxxx SQLCODE=YYYY Info=[ZZZZ] XXXX RD YYYY DBMS SQL ZZZZ DBMS SQL DBMS DBMS KFDB012DB-E DBMS nodename=xxxx SQLCODE=YYYY IPADDR=ZZZZ An error occurred in the connected DBMS. nodename=xxxx SQLCODE=YYYY IPADDR=ZZZZ XXXX RD YYYY DBMS SQL ZZZZ IP DBMS DBMS KFDB013DB-E DBMS 32 The permission identifier, password or DBMS information specified by the user exceeded 32 bytes. 265

290 7. DBMS 32 DBMS KFDB017DB-E ErrInfo XXXX The specified table attribute is incorrect. ErrInfo[XXXX] XXXX 1 ` 2 3 KFDB018DB-E ErrInfo XXXX YYYY ZZZZ The specified input parameter is incorrect. ErrInfo XXXX YYYY ZZZZ XXXX YYYY ZZZZ 266

291 7. KFDB019DB-E ErrInfo XXXX YYYY The specified output parameter is incorrect. ErrInfo[XXXX, YYYY] XXXX YYYY KFDB020DB-E DBMS ErrInfo XXXX Incorrect version of the DBMS. ErrInfo[XXXX] XXXX DBMS DBMS KFDB021DB-E SQL ErrInfo XXXX YYYY The specified multiple SQL execution is incorrect. ErrInfo[XXXX,YYYY] XXXX SQL YYYY SQL 267

292 7. SQL KFDB024DB-E DBMS NULL XXXX You cannot specify NULL in the? parameter because of a limit of the connected DBMS. [XXXX] XXXX NULL NULL KFDB025DB-E HiRDB ORACLE =XXXX Not prepared to connect to HiRDB or ORACLE. Error code=xxxx XXXX OCI OCI -1 xaoenv -2 xaosvcctx -3 OCIHandleAlloc -4 OCISvcCtxToLda 1. OTS 2. HiRDB TPBroker(OTS) 1. OTS DABroker OTS 2. TPBroker HiRDB TPBroker HiRDB TPBroker HiRDB 268

293 7. KFDB026DB-E KFDB026DB-EORACLE OCI =XXXX =YYYY The error occurred by the OCI function of ORACLE.Function name=xxxx return code=yyyy XXXX OCI YYYY OCI OCI XXXX Oracle Call Interface KFDB030DB-E ODBC DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in an ODBC access. DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ WWWW XXXX SQL DABroker YYYY SQLSTATE ZZZZ ( ) ODBC DBMS KFDB031DB-E ODBC SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in an ODBC access. SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ 269

294 7. XXXX SQL DABroker YYYY SQLSTATE ZZZZ ( ) ODBC DBMS KFDB032DB-E ODBC ErrInfo=XXXX A request parameter is invalid for ODBC access. ErrInfo=XXXX XXXX ODBC KFDB040DB-E DABroker ODBC DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in a DABroker ODBC access. DATASOURCE NAME=WWWW SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ WWWW XXXX SQL DABroker YYYY SQLSTATE ZZZZ ( ) DABroker ODBC 270

295 7. DBMS KFDB041DB-E DABroker ODBC SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ An error occurred in a DABroker ODBC access. SQL CODE=XXXX SQLSTATE=YYYY MESSAGE TEXT=ZZZZ XXXX SQL DABroker YYYY SQLSTATE ZZZZ ( ) DABroker ODBC DBMS KFDB042DB-E DABroker ODBC ErrInfo=XXXX A request parameter is invalid for DABroker ODBC access. ErrInfo=XXXX XXXX DABroker ODBC KFDB043DB-E ODBC Driver [XXXX] DABroker does not support the ODBC Driver version.[xxxx] 271

296 7. XXXX:ODBC Driver ODBC Driver ODBC Driver KFDB044DB-E DBMS [XXXX] DABroker does not support the DBMS. [XXXX] XXXX DBMS DBMS KFDB045DB-E DBMS DBMS user DBMS=XXXX system DBMS=YYYY The specified DBMS differs from the connected DBMS. user DBMS=XXXX system DBMS=YYYY XXXX DBMS YYYY DABroker DBMS DBMS DBMS DBMS KFDB050DB-E [DABroker.libdaTCPS] Loading ErrInfo[XXXX] A loading error occurred in [libdatcps]. ErrInfo[XXXX] 272

297 7. XXXX Database Connection Server DABroker KFDB051DB-E [XXXX,YYYY] DABroker does not support the connected server system. [XXXX,YYYY] XXXX YYYY DBMS KFDB052DB-E [XXXX] A system error occurred in the connected server system. [XXXX] XXXX DBMS KFDB053DB-E DABroker DBMS [XXXX] A system error occurred in the DABroker DBMS driver. [XXXX] XXXX 273

298 7. DBMS DBMS KFDB054DB-E Processing was canceled because a timeover occurred. (DBSTIMER DABDBA_TIMEOUT) KFDB060DB-E XA [XXXX] An XA request error occurred. [XXXX] XXXX XA XA KFDB070DB-E [XXXX] There is a data type which is different in element of arrangement.[xxxx] XXXX HiRDB 274

299 7. KFDB071DB-E [XXXX] The size of data is over the effective range of character data. [XXXX] XXXX KFDB101DB-E Memory is insufficient for processing. KFDB001EC-E dabstop -p -f -c IP Invalid argument. Usage:dabstop[-p -f -c IP-address_or_host-name] dabstop 275

300 7. KFDB002EC-E DABroker DABroker is not running. DABroker KFDB003EC-E DABroker DABroker is starting. The command is canceled. dabstop DABroker KFDB004EC-E DABroker DABroker is terminating. The command is canceled. dabstop DABroker KFDB005EC-E DABroker DABroker is terminating in the planned termination mode. The command is canceled. dabstop DABroker KFDB006EC-E DABroker 276

301 7. DABroker is terminating in the forced termination mode. The command is canceled. dabstop DABroker KFDB007EC-E dabstop dabstop has been executed from another terminal. dabstop KFDB008EC-E DABroker The user does not have authorization to stop DABroker. DABroker Administrators DABroker Administrators KFDB009EC-E DABroker cannot terminate because of current processing. The command is canceled. dabstop DABroker f -P 277

302 7. KFDB010EC-E -c The client processing specified by the -c option was not found. dabstop -c dabstat KFDB011EC-E -c IP An incorrect IP address or host name is specified with the -c option. IP IP KFDB012EC-E DABroker DABroker is starting. DABroker KFDB013EC-E DABroker DABroker is terminating. 278

303 7. DABroker KFDB014EC-E DABroker DABroker is terminating in the planned termination mode. DABroker KFDB015EC-E DABroker DABroker is terminating in the forced termination mode. DABroker KFDB016EC-E DABroker cannot terminate because of current processing. DABroker DABroker DABroker 2 DABroker 279

304 7. 3 [DABroker KFDB017EC-E The specified client processing was not found. 1 DABroker 2 DABroker KFDB101EC-E : dabcmstop [-p -f] Invalid argument. Usage:dabcmstop [-p -f] dabcmstop KFDB102EC-E DABroker The DABroker Connection-Multi function is not running. DABroker 280

305 7. KFDB103EC-E DABroker The DABroker Connection-Multi function is starting. The command is canceled. dabcmstop DABroker KFDB104EC-E DABroker The DABroker Connection-Multi function is terminating. The command is canceled. dabcmstop DABroker KFDB105EC-E DABroker The DABroker Connection-Multi function is terminating in the planned termination mode. The command is canceled. dabcmstop DABroker KFDB106EC-E DABroker The DABroker Connection-Multi function is terminating in the forced termination mode. The command is canceled. 281

306 7. dabcmstop DABroker KFDB107EC-E dabcmstop dabcmstop has been executed from another terminal. dabmcstop KFDB108EC-E DABroker The user does not have authorization to stop the DABroker Connection-Multi function. DABroker Administrators DABroker Administrators KFDB109EC-E The DABroker Connection-Multi function cannot terminate because of current processing. The command is canceled. dabcmstop DABroker f -p 282

307 7. KFDB110EC-E -c This virtual connection is not specified with the -c option. dabcmstop -c dabcmstat KFDB111EC-E -d This communication demon is not specified with the -d option. dabcmstop -d dabcmstat KFDB112EC-E DABroker The DABroker Connection-Multi function is starting. DABroker KFDB113EC-E DABroker 283

308 7. The DABroker Connection-Multi function is terminating. DABroker KFDB114EC-E DABroker The DABroker Connection-Multi function is terminating in the planned termination mode. DABroker KFDB115EC-E DABroker The DABroker Connection-Multi function is terminating in the forced termination mode. DABroker KFDB116EC-E The DABroker Connection-Multi function cannot terminate because of current processing. DABroker DABroker

309 7. KFDB117EC-E This specified virtual connection does not exist. [DABroker ] DABroker KFDB002LC-E :dabcltrc -c IP Invalid argument. Usage:dabcltrc [-c IP-address_or_host-name] dabcltrc KFDB003LC-E Memory became insufficient during execution of a utility program. KFDB004LC-E DABroker DABroker is not starting. 285

310 7. DABroker DABroker DABroker KFDB005LC-E IP Communication information with the specified IP address or host name cannot be traced. IP IP KFDB001LM-E XXXX()error=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS KFDB001MM-E XXXX The DABroker environment definition file was not found. [XXXX] XXXX DABroker 286

311 7. DABroker DABroker /conf DABroker DABroker KFDB002MM-E XXXX The environment definition is incorrect. [XXXX] XXXX 1. DABroker DABroker 2. KFDB003MM-E LINE=XXXX YYYY The environment definition is incorrect. LINE=XXXX [YYYY] XXXX YYYY DABroker DABroker DABroker KFDB004MM-E DABroker is not installed. 287

312 7. DABroker DABroker DABroker KFDB005MM-E XXXX errno=yyyy An error occurred in a system call. [XXXX errno=yyyy] XXXX YYYY XXXX OS KFDB006MM-E System call error occured. [XXXX errno=yyyy] XXXX YYYY XXXX OS KFDB007MM-E The message file could not be opened. [XXXX errno=yyyy] 288

313 7. XXXX YYYY DABroker ID OS DABroker LANG DAB_LANG C OS locale C AIX 5L LC_FASTMSG false DABroker DABroker KFDB008MM-E An error occurred in a system call during output of XXXX. [YYYY errno=zzzz] XXXX YYYY ZZZZ syslog OS KFDB009MM-E XXXX Required memory cannot be obtained. XXXX XXXX DABroker 289

314 7. DABroker KFDB010MM-E LINE=XXXX YYYY The connection database definition is incorrect. LINE=XXXX [YYYY] XXXX YYYY KFDB011MM-E XXXX The user does not have authority to access the environment definition file. [XXXX] XXXX DABroker DABroker DABroker KFDB012MM-E XXXX DABroker does not have authority to access the connection database definition file. [XXXX] XXXX 290

315 7. KFDB013MM-E LINE=XXXX YYYY The database-type-name is duplicated. LINE=XXXX [YYYY] XXXX YYYY KFDB014MM-E LINE=XXXX YYYY The database name is duplicated. LINE=XXXX [YYYY] XXXX YYYY KFDB015MM-E XXXX YYYY The [XXXX] was not found. [YYYY] 291

316 7. XXXX YYYY KFDB016MM-E LINE=XXXX YYYY The Connection-Multi definition is incorrect. LINE=XXXX [YYYY] XXXX: YYYY: KFDB017MM-E XXXX The user does not have authority to access the Connection-Multi definition file. [XXXX] XXXX DABroker 292

317 7. KFDB018MM-E LINE=XXXX [YYYY] The Connection-Multi-name is duplicated. LINE=XXXX [YYYY] XXXX: YYYY: KFDB019MM-E XXXX The directory was not found. DABroker will use the default directory. [XXXX] XXXX 1. DABroker DABroker DABroker KFDB020MM-E XXXX The directory was not found. [XXXX] XXXX 293

318 7. 1. DABroker DABroker 3. KFDB001NM-E XXXXYYYY An error occurred in a system call. (Error function:xxxx, error code:yyyy) XXXX YYYY GetLastError Windows KFDB002NM-E DABroker DABroker ( XXXX YYYY An abnormality occurred during DABroker processing. DABroker terminates. (File name:xxxx, Line number:yyyy) XXXX YYYY DABroker 294

319 7. KFDB003NM-E DABroker Memory became insufficient during DABroker processing. DABroker KFDB004NM-E DABroker The environment is incorrect. Re-install DABroker. DABroker DABroker KFDB005NM-E DABroker An error occurred during DABroker initialization processing. DABroker (dabsv.log) 295

320 7. 3. KFDB101NM-E XXXX YYYY An error occurred during service controlled processing. (Error code 1:XXXX, error code 2:YYYY) XXXX YYYY GetLastError DABroker 4. 1 Windows KFDB102NM-E Memory became insufficient during service controlled processing. DABroker KFDB103NM-I DABroker DABroker service has started. DABroker DABroker 296

321 7. DABroker KFDB104NM-Q DABroker Do you want to terminate the DABroker service? DABroker DABroker DABroker KFDB105NM-E DABroker XXXX DABroker cannot start because a DABroker service parameter is invalid. (Error code:xxxx) XXXX GetLastError DABroker DABroker DABroker KFDB151NM-E XXXX YYYY An error occurred during service controlled processing. (Error code 1:XXXX, error code 2:YYYY) XXXX YYYY GetLastError DABroker 297

322 DABroker 4. Windows KFDB152NM-E Memory became insufficient during service controlled processing. DABroker DABroker KFDB153NM-I DABroker The DABroker Connection-Multi function service has started. DABroker DABroker DABroker KFDB154NM-Q DABroker Do you want to terminate the DABroker Connection-Multi function service? DABroker DABroker 298

323 7. DABroker KFDB155NM-E DABroker XXXX The DABroker Connection-Multi function cannot start because a DABroker service parameter is invalid. (Error code:xxxx) XXXX GetLastError DABroker DABroker DABroker KFDB201NM-E The directory is invalid. KFDB202NM-E The entered numerical data is outside the range. 299

324 7. KFDB203NM-Q IP XXXXYYYY The client processing was canceled. IP address:xxxx host name:yyyy XXXX IP YYYY KFDB204NM-E XXXX The registry name XXXX is too long. XXXX XXXX 1,024 XXXX 1,024 KFDB205NM-E XXXX DABroker DABroker found a non-supported data type in the registry name XXXX. XXXX 300

325 7. XXXX DABroker KFDB206NM-E XXXX YYYYZZZZ DABroker failed to get the value of registry name XXXX. (Error function:yyyy, error code:zzzz) XXXX YYYY ZZZZ GetLastError DABroker DABroker 1. DABroker Windows DABroker KFDB207NM-E XXXX YYYYZZZZ DABroker failed to update the value of registry name XXXX. (Error function:yyyy, error code:zzzz) XXXX YYYY ZZZZ GetLastError 301

326 7. DABroker DABroker 1. DABroker Windows DABroker KFDB211NM-E DABroker An environment definition cannot be updated because DABroker is running. DABroker DABroker DABroker KFDB213NM-E The user does not have authority to execute the environment setting utility. Administrators Administrators KFDB214NM-E 302

327 7. The type of information to be acquired is not specified. KFDB215NM-E DABroker Cannot update because DABroker is running. DABroker DABroker DABroker KFDB216NM-W DABroker Cannot update because DABroker is running. DABroker DABroker DABroker KFDB217NM-W DABroker Cannot update because the DABroker Connection-Multi function is running. DABroker DABroker 303

328 7. DABroker KFDB250NM-I The trace has been output. KFDB251NM-I The trace to be output was not found. 1 KFDB252NM-E An error occurred during output processing for the communication-trace. 304

329 7. KFDB253NM-E An error occurred during output processing for the access-trace. KFDB302NM-E You specified an invalid database type. KFDB002RC-E :dabdbtrc [-u ID] [-p ] Invalid argument. Usage:dabdbtrc [-u user-id][-p program-name] dabdbtrc KFDB003RC-E Memory became insufficient during execution of a utility program. 305

330 7. KFDB001RM-E XXXX()error=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS KFDB001RR-E ID The access-trace for the database that has the specified user ID could not be found. ID ID KFDB002RR-E The access-trace for the database that has the specified program name could not be found. 306

331 7. KFDB003RR-E ID The access-trace for the database that has the specified user ID or program name could not be found. ID ID KFDB001SC-E :dabstat Invalid argument. Usage:dabstat dabstat KFDB002SC-E DABroker DABroker is not running. DABroker DABroker 307

332 7. Windows DABroker UNIX DABroker dabstat KFDB003SC-E DABroker DABroker is starting. The command is canceled. dabstat DABroker KFDB004SC-E DABroker DABroker is terminating. The command is canceled. dabstat DABroker KFDB005SC-I DABroker DABroker is terminating in the planned termination mode. DABroker DABroker DABroker Windows DABroker UNIX DABroker dabstat KFDB006SC-E DABroker DABroker is terminating in the forced termination mode. The command is canceled. 308

333 7. dabstat DABroker KFDB007SC-E DABroker DABroker is starting. DABroker DABroker KFDB008SC-E DABroker DABroker is terminating. DABroker DABroker KFDB009SC-E DABroker DABroker is terminating in the forced termination mode. DABroker DABroker KFDB101SC-E dabcmstat Invalid argument. Usage:dabcmstat dabcmstat 309

334 7. KFDB102SC-E DABroker The DABroker Connection-Multi function is not running. DABroker DABroker Windows DABroker [DABroker ] UNIX DABroker dabcmstat KFDB103SC-E DABroker The DABroker Connection-Multi function is starting. The command is canceled. dabcmstat DABroker KFDB104SC-E DABroker The DABroker Connection-Multi function is terminating. The command is canceled. dabcmstat DABroker 310

335 7. KFDB105SC-I DABroker The DABroker Connection-Multi function is terminating in the planned termination mode. DABroker DABroker DABroker Windows DABroker [DABroker ] UNIX DABroker dabcmstat KFDB106SC-E DABroker The DABroker Connection-Multi function is terminating in the forced termination mode. The command is canceled. dabcmstat DABroker KFDB107SC-E DABroker The DABroker Connection-Multi function is starting. DABroker DABroker KFDB108SC-E DABroker 311

336 7. The DABroker Connection-Multi function is terminating. DABroker DABroker KFDB109SC-E DABroker The DABroker Connection-Multi function is terminating in the forced termination mode. DABroker DABroker KFDB001SM-E XXXX()errno=YYYY An error occurred in a system call. [XXXX() errno=yyyy] XXXX YYYY OS KFDB002SM-E shmget()errno=xxxx Shared memory cannot be obtained. [shmget() errno=xxxx] XXXX OS (shmget) 312

337 7. KFDB003SM-E shmctl()errno=xxxx Shared memory cannot be deleted. [shmctl() errno=xxxx] XXXX OS (shmctl) KFDB004SM-E semget()errno=xxxx The semaphore cannot be obtained. [semget() errno=xxxx] XXXX OS (semget) KFDB005SM-E semctl()errno=xxxx The semaphore cannot be deleted. [semctl() errno=xxxx] XXXX OS (semctl) 313

338 7. KFDB006SM-E Memory is insufficient during execution of a utility program. KFDB001TD-E [XXXX errno=yyyy] An error occurred in a system call. [XXXX errno=yyyy] XXXX YYYY XXXX OS KFDB002TD-E Memory is insufficient. 314

339 7. KFDB003TD-E CursorId=XXXX The specified cursor is being used, or it is not initialized. [CursorId=XXXX] XXXX KFDB004TD-E CursorId=XXXX The cursor value is invalid. [CursorId=XXXX] XXXX 1 64 KFDB005TD-E ErrorCode=XXXX Invalid data was received. [ErrorCode=XXXX] XXXX DABroker 315

340 7. KFDB006TD-E XXXX The required parameter was not found, or the parameter value is invalid. [XXXX] XXXX USER ID ID RD NODE NAME RD TABLE TYPE ABSTRACT KIND ABSTRACT NAME DATASOURCE ODBC3.0 KFDB007TD-E RequestCode=XXXX DABroker does not support the specified function. [RequestCode=XXXX] XXXX DABroker / KFDB008TD-E ErrorCode=XXXX An error occurred in the system. [ErrorCode=XXXX] XXXX DABroker 316

341 7. KFDB009TD-E ResponseSize=XXXX The request size of reply data is invalid. [ResponseSize=XXXX] XXXX KFDB010TD-E [RequestCode=XXXX-YYYY] A sequence error of the request code occurred. [RequestCode=XXXX-YYYY] XXXX YYYY / KFDB011TD-E DABroker does not support the specified database. 317

342 7. KFDB012TD-E SQL The specified SQL is incorrect. SQL : SQL KFDB013TD-E ErrorCode=XXXX An error occurred in the database access library. [ErrorCode=XXXX] XXXX DABroker KFDB015TD-E 318

343 7. KFDB016TD-E ErrorCode=XXXX A database access error occurred. [ErrorCode=XXXX] XXXX DBMS DBMS KFDB030TD- Processing was canceled. KFDB031TD- Processing cannot be canceled because it has already ended KFDB032TD-E (DataType=XXXX) A data type that the client does not support was found. (DataType=XXXX) XXXX 319

344 7. DABroker KFDB033TD-E Not connected to the database. KFDB034TD-E XXXX The user does not have authorization to delete the specified file. File:XXXX XXXX KFDB035TD-E XXXX The specified file was not found. File:XXXX XXXX 320

345 7. KFDB036TD-E XXXX unlinkerrno YYYY DABroker failed to delete the specified file. File:XXXX [unlink() errno=yyyy] XXXX YYYY unlink() unlink() unlink() KFDB037TD-E XXXX The area for sending information to the client was insufficient. Cause=XXXX XXXX 1. EXT-CMD <Prepare> 2. EXT-CMD <Fetch> PROCEDURE PREPARE 321

346 7. 4. PROCEDURE EXECUTE 5. PROCEDURE-PARAMETER 6. PROCEDURE-RESULT 7. EXT-CMD <EXECUTE> 52+4 KFDB040TD-E XXXX The specified database type definition was not found. Database-type-name:XXXX XXXX KFDB041TD-E XXXX YYYY 322

347 7. The specified database definition name was not found. Database-type-name:XXXX database-name:yyyy XXXX YYYY KFDB042TD-E XXXX YYYY The specified Connection-Multi definition name was not found. Database-type-name:XXXX database-name:yyyy XXXX YYYY KFDB043TD-E XXXX YYYY The distributed-definition-name was not found in the specified database name definition. Database-type-name:XXXX database-name:yyyy XXXX YYYY 323

348 7. KFDB044TD-E IP XXXX YYYY The host name or the IP address was not found in the specified Connection-Multi definition. Database-type-name:XXXX database-name:yyyy XXXX YYYY IP KFDB045TD-E XXXX YYYY The service name or port number not was found in the specified Connection-Multi definition. Database-type-name:XXXX database-name:yyyy XXXX YYYY 324

349 7. KFDB046TD-E XXXX YYYY The Connection-Multi name was not found in the specified database name definition. Database-type-name:XXXX database-name:yyyy XXXX YYYY KFDB047TD-E XXXX YYYY The specified database type in the database type definition differs from the database type in the connection request from the client. Database-type-name:XXXX database-name:yyyy XXXX YYYY KFDB048TD-E ID XXXX YYYY The user ID was not found in the specified database name definition. Database-type-name:XXXX database-name:yyyy 325

350 7. XXXX YYYY ID KFDB049TD-E ErrInfo[XXXX] Memory is insufficient during data processing. ErrInfo[XXXX] XXXX KFDB001TJ-E JNI function (XXXX) failed. LINE YYYY XXXX JNI YYYY JNI Throw KFDB002TJ-E Handle of dayd_control is NULL. LINE XXXX XXXX 326

351 7. (dayd_control()) NULL Throw KFDB003TJ-E Invalid handle. LINE XXXX XXXX Java I/F Throw KFDB004TJ-E Local storage allocation failed. Throw KFDB005TJ-E Invalid argument. LINE XXXX XXXX Java I/F Throw 327

352 7. KFDB006TJ-E Invalid calling sequence. LINE XXXX XXXX Java I/F Throw KFDB007TJ-E Storage allocation failed. DBMS Throw KFDB008TJ-E jbytearray of send data is NULL. LINE XXXX XXXX Java I/F NULL Throw KFDB009TJ-E Size of receive buffer is under 0. LINE XXXX XXXX Java I/F 328

353 7. Throw KFDB010TJ-E The size of the received data is over the buffer size. LINE:XXXX XXXX Java I/F Throw KFDB011TJ-E jbytearray of receive buffer is NULL. LINE XXXX XXXX Java I/F NULL Throw KFDB012TJ-E Invalid response information. LINE XXXX XXXX Throw 329

354 7. KFDB013TJ-E Invalid status. LINE XXXX XXXX Java I/F Throw KFDB014TJ-E Error outbreak. LINE XXXX XXXX Java I/F Throw KFDB015TJ-E Invalid response information status. LINE XXXX XXXX Java I/F Throw KFDB016TJ-E dayd_control failed. LINE XXXX XXXX dayd_control return 330

355 7. Throw KFDB017TJ-E Invalid environment. XXXX XXXX Java I/F DABroker Throw DABroker KFDB001TM-E services DABroker (DABROKER_SV) The services name and port number(dabroker_sv) of DABroker are not listed in the "services" file. services DABroker services DABROKER_SV XXXXX/tcp XXXXX DABroker NIS NIS KFDB002TM-E socket() errno=xxxx The socket cannot be opened. [socket() errno=xxxx] XXXX OS (socket) 331

356 7. KFDB003TM-E bind() errno=xxxx The address cannot be allocated to the socket. [bind() errno=xxxx] XXXX OS (bind) DABroker LAN DABroker KFDB004TM-E listen() errno=xxxx An error occurred when a requested connection was accepted. [listen() errno=xxxx] XXXX OS (listen) KFDB005TM-E accept() errno=xxxx An error occurred when a connection was established. [accept() errno=xxxx] XXXX OS (accept) 332

357 7. KFDB006TM-I XXXX A connection is established. [XXXX] XXXX IP KFDB007TM-I XXXX A connection is released. [XXXX] XXXX IP KFDB008TM-E Incorrect version of the client program. KFDB009TM-E IPADDR=XXXX Cannot connect the database because of insufficient memory. IPADDR=XXXX 333

358 7. XXXX IP IPADDR=XXXX DABroker KFDB010TM-E =XXXX IPADDR=YYYY Invalid data was received. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB011TM-E =XXXX IPADDR=YYYY An error occurred during communication processing. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB012TM-E =XXXX IPADDR=YYYY 334

359 7. A sequence error occurred during sending or receiving of data. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB013TM-E DABroker IPADDR=XXXX The processing request cannot be accepted because DABroker is terminating in the planned termination mode. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABroker DABroker DABroker KFDB014TM-I TCP/IP XXXXIPADDR=YYYY The TCP/IP communication thread is terminated. Cause:[XXXX] IPADDR=YYYY XXXX CANCEL_REQUEST TERM_REQUEST YYYY IP IPADDR=XXXX 335

360 7. TCP/IP Windows DABroker DABroker UNIX DABroker -f dabstop Windows DABroker DABroker UNIX DABroker -c IP dabstop KFDB016TM-E IPADDR=XXXX A timeout occurred during the wait for the request from the client. DABroker releases the connection. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABCLIENT_TIMEOUT DABCLIENT_TIMEOUT KFDB017TM-E IPADDR=XXXX 336

361 7. A timeout occurred during the wait for termination of the database access. DABroker releases the connection. IPADDR=XXXX XXXX IP IPADDR=XXXX DABroker DABDBA_TIMEOUT DABDBA_TIMEOUT KFDB018TM-E IPADDR=XXXX The connection was forcibly released. IPADDR=XXXX XXXX IP IPADDR=XXXX KFDB019TM-E IPADDR=XXXX The connection was forcibly released. IPADDR=XXXX XXXX IP IPADDR=XXXX TCP/IP 337

362 KFDB020TM-E =XXXX IPADDR=YYYY The database access process terminated abnormally. Error code=xxxx IPADDR=YYYY XXXX YYYY IP IPADDR=YYYY KFDB021TM-E TCP/IP [XXXX] The TCP/IP communication process terminated. Cause:[XXXX] XXXX TCP/IP kill KFDB022TM-W XXXXIPADDR=YYYY The cancel processing request cannot be accepted. [XXXX] IPADDR=YYYY XXXX 338

363 7. YYYY IP IPADDR=YYYY DABroker KFDB023TM-E DBMS XXXX=YYYY IPADDR=ZZZZ The specified DBMS environment variable is incorrect. [XXXX] IPADDR=YYYY XXXX YYYY ZZZZ IP IPADDR=ZZZZ DBMS KFDB001TR-E Memory became insufficient during collection of a trace of communication with a client. 339

364 7. KFDB002TR-E Disk space became insufficient during collection of a trace of communication with a client. KFDB003TR-E XXXX()errno=YYYY An error occurred in a system call during collection of a trace of communication with a client. [XXXX() errno=yyyy] XXXX YYYY OS DABroker KFDB001YM-E dabstart [-t] [-a] Invalid argument. Usage:dabstart [-t] [-a] dabstart DABroker 340

365 7. KFDB003YM-I DABroker DABroker initialization processing has finished. DABroker DABroker Windows DABroker DABroker UNIX DABroker dabstart KFDB004YM-I DABroker mode=normal DABroker termination processing has started. mode=normal DABroker DABroker Windows DABroker DABroker UNIX DABroker dabstop KFDB005YM-I DABroker mode=forced DABroker termination processing has started. mode=forced DABroker Windows DABroker DABroker UNIX DABroker -f dabstop 341

366 7. KFDB006YM-I DABroker mode=planned DABroker termination processing has started. mode=planned DABroker DABroker Windows DABroker DABroker UNIX DABroker -p dabstop KFDB007YM-E DABroker DABroker is terminating in the planned termination mode. A client cannot be connected. DABroker DABroker DABroker DABroker DABroker KFDB008YM-E DABMAXUSERS=XXX The number of clients exceeds the maximum that can be connected. A client cannot be connected. [DABMAXUSERS=XXXX] XXX DABroker DABMAXUSERS 342

367 7. DABroker DABroker DABMAXUSERS KFDB009YM-E DABroker DABroker is already running. DABroker DABroker DABroker Windows DABroker DABroker UNIX DABroker dabstart KFDB010YM-E DABroker [XXXX] The user does not have authority to execute the load module of DABroker. Name:[XXXX] XXXX DABroker DABroker UNIX DABroker dabsetup DABroker KFDB011YM-E DABroker 343

368 7. [XXXX] DABroker cannot start because there are too many symbolic links. Name:[XXXX] XXXX DABroker DBMS DBMS DABroker KFDB012YM-E DABroker [XXXX] A load module of DABroker was not found. Name:[XXXX] XXXX DABroker DABroker UNIX DABroker dabsetup DABroker KFDB013YM-E DABroker [XXXX] DABroker cannot start because of insufficient memory. Name:[XXXX] XXXX 344

369 7. DABroker KFDB014YM-E DABroker The user does not have authority to execute DABroker. DABroker DABroker DABroker DABroker DABroker Windows DABroker Administrators UNIX DABroker DABroker KFDB015YM-E TCP/IP XXXX The TCP/IP communication process terminated abnormally. Cause:[XXXX] XXXX TCP/IP kill 345

370 7. KFDB016YM-E DABroker [XXXX] DABroker terminated abnormally. Cause:[XXXX] XXXX kill DABroker DABroker DABroker UNIX DABroker $DABROKER/spool $DABROKER DABroker (DABroker core KFDB019YM-E [DABMAXPROCESS=XXXX] The number of users exceeds the maximum that can be executed. A client cannot be connected. [DABMAXPROCESS=XXXX] XXXX DABroker DABroker DABMAXPROCESS DABroker DABroker DABMAXPROCESS KFDB020YM-E DABroker 346

371 7. DABroker cannot start. DABroker DABroker DABroker KFDB021YM-E DABDBANUMBER=XXX The number of database accesses exceeds the maximum that can be executed. Database access is not possible. [DABDBANUMBER=XXXX] XXX DABroker DABDBANUMBER DABroker DABDBANUMBER KFDB022YM-I DABroker DABroker has terminated. DABroker KFDB023YM-E TCP/IP The TCP/IP communication process cannot start. TCP/IP 347

372 7. DABroker DABroker KFDB100YM-E XXXX() errno=yyyy An error occurred in a system call. [XXXX() errno=yyyy] XXXX ( ) YYYY ( ) OS DABroker KFDB301YM-I Clean up. {xxx,yyy,zzz}, {sss} xxx yyy zzz sss DABroker

373 7. KFDB302YM-I dabtcpdmn {xxx} start. [yyyy] xxx dabtcpdmn yyyy ID KFDB303YM-I dabtcpdmn end. [xxxx] yyyy ID KFDB310YM-I Thread stack size = xxxx yyyy xxxx xxx yyyy DABPTHREAD_STACK_SIZE is undefined. 349

374 7. DABPTHREAD_STACK_SIZE DABPTHREAD_STACK_SIZE=aaa aaa DABPTHREAD_STACK_SIZE 55 KFDB0101YM-E Required memory cannot be obtained. DABroker DABroker 350

375 DABroker DABroker ID DABroker ID 7.3 KFDBxxxyz-E aabbxxx aa bb xxx ID y 7-2 y ID z 7-2 z ID xxx KFDB001DB-E ID ID y z A 1 01 B 2 02 C 3 03 D 4 04 E 5 05 F 6 06 G 7 07 H 8 08 I 9 09 J K L M N O P Q

376 7. ID y z R S T U V W X Y Z

377 DABroker DABroker DABroker CANCEL DBMS DABroker CANCEL CANCEL DABroker DBMS DABroker DABroker DABroker / / Commit 1005 Rollback

378 7. / SQL 1022 SQL 1023 SQL 1024 SQL 1035 SQL 1036 BLOB BLOB CLOB BFILE 1041 Commit 1042 Commit 1050 XA

379 7. / OS OS errno OS 7-5 errno dlopen 2 ENOENT DABroker dup 23 ENFILE 24 EMFILE fcntl 23 ENFILE 24 EMFILE fork 11 EAGAIN 12 ENOMEM DABroker 355

380 7. errno malloc 12 ENOMEM mkdir 13 EACCESS DABroker 28 ENOSPC open 2 ENOENT 13 EACCES 17 EEXIST 23 ENFILE 24 EMFILE semget 28 ENOSPC semop 22 EINVAL DABroker DABroker shl_load 8 ENOEXEC DBMS DABroker DABroker DBMS 356

381 7. errno shmat 22 EINVAL DABroker DABroker DABroker shmget 22 EINVAL DABroker DABroker 28 ENOSPC write 5 EIO 14 EFAULT 27 EFBIG 28 ENOSPC DABroker DABroker DABroker DABroker DABroker DABroker OS DABroker DABroker 357

382 7. errno chmod, closecreat, dup, execv, fork, gethostbyaddr, gethostbyname, lseek, lockf, open, read, select, semctl, semget, semop, shmat, shmctl, shmdt, shmget, signal, sigsetmask, stat, write 22 EINVAL LoadLibrary(pdtxa_switch_y) errno=xxxx 2 GetProcAddress(pdtxa_switch _y) errno=xxxx dlopen LoadLibrary shl_findsym XXXX dlopen LoadLibrary shl_findsym dlsym GetProcAddress XXXX dlsym GetProcAddress OS OS 358

383 7. 3 XXXX rtncode=yyyy XA XXXX "xa_open" "xa_close" "xa_start" "xa_end" "xa_prepare" "xa_commit" "xa_rollback" "xa_forget" "xa_recover" YYYY DBMS 4 LoadLibrary(xaosw) errno=xxxx 5 GetProcAddress(xaosw) errno=xxxx dlopen LoadLibrary shl_findsym XXXX dlopen LoadLibrary shl_findsym dlsym GetProcAddress XXXX dlsym GetProcAddress OS OS 359

384

385 A 361

386 A A API Application Programming Interface BLOB DABroker (Binary Large Object) LOB(Large Object) UDT ORACLE LONG ODBC BLOB CORBA Common Object Request Broker Architecture OMG Object Management GroupCORBA ORB Object Request Broker IIOP Internet Inter-ORB Protcol OTS Object Transaction Service Database Connection Server Database Connection Server DABroker VOS3 XDM/RD VOS3 XDM/SD VOSK SQL/K VOS1 PDMII E2 VOSK DBMS Data Base Management System HiRDB ORACLE SQL Anywhere SQL ServerVOS3 XDM/RD VOS1 RDB1 E2 VOSK SQL/K VOS3 XDM/SD VOS1 PDMII E2 VOSK VOS1 RDB1 E2 DBPARTNER/Client DABroker / GUI DBPARTNER/Web DABroker 362

387 A DBPARTNER Mobile DABroker DBPARTNER Mobile-Client DBPARTNER Mobile-Server DBPARTNER Mobile DTP Distributed Transaction Processing X/Open DTP TM Transaction ManagerRM Resource Manager UAP AP Application Program HITSENSER5 for Cosmicube Cosmicube MOLAP HITSENSER5 for RDB ROLAP HITSENSER5 Professional HITSENSER5 HITSENSER5 HITSENSER5 Standard IP HITSENSER5 JDBC Java JDBC ODBC DABroker for Java JDBC DABroker JDBC Open DataBase Connectivity Microsoft Corp. ODBC API OS DBMS DBMS ODBC 363

388 A OTS CORBA TCP/IP Transmission Control Protocol/Internet Protocol TPBroker DOD ARPANET TCP/IP CORBA ORB OTS DABroker DABroker for ORB TPBroker Web Page Generator CORBA HTML CORBA X/Open DTP XA X/Open XA DTP Distributed Transaction ProcessingTM Transaction Manager RM Resource Manager X/Open XA DABroker Windows [DABroker ] UNIX dabdbtrc DABroker UAP TCP/IP 364

389 A DBMS TCP/IP DBMS DABroker DABroker Java Application DABroker Java JNI Java Native InterfaceJNI Java Application DABroker CORBA 365

390 A 366

391 [DABroker ] 121 [ ] A API 362 Applet 11 ASP 17 ATTACH 214 ATTACH 190 ATTRGET 214 ATTRGET 190 ATTRSET 215 ATTRSET 190 AUTO COMMIT OFF 224 AUTO COMMIT ON 224 AUTO COMMIT ON 198 B BIND 215 BIND 191 BLOB 362 C CANCEL 210 CANCEL 189 CHARFORM 215 CHARFORM 191 CHARID 216 CHARID 191 CLOSE 210 CLOSE 189 COMMIT 211 COMMIT 187 CONNECT 211 CONNECT 186 CORBA 362 D DAB_DBS_HOST 67 DAB_DBS_PORT 67 DAB_DBS_RECEIVE_BUFFER_SIZE 67 DAB_DBS_SEND_BUFFER_SIZE 67 DAB_HIRDB_DBINF_ESC 58 DAB_LANG 52 DABCLIENT_TIMEOUT 60 dabcltrc 81 dabcmstart 94 dabcmstat 95 dabcmstop 94 DABDBA_TIMEOUT 60 DABDBANUMBER 62 DABDBSDBA_BLOBBUFSIZE 64 dabdbtrc 199 DABEXSQL_TRC_LINE DABHIRDBA_BLOBBUFSIZE 63 DABIPCONVERT 64 DABKEEPALIVE 61 DABMAXBLOCKUSERS 62 DABMAXPROCESS 63 DABMAXUSERS 62 DABORACLE_TYPE 56 DABORADBA_LONGBUFSIZE 63 DABroker 2 DABroker for Java 11 DABroker for ODBC 16 DABroker 42 DABroker 121 DABroker 157 DABroker

392 DABroker DABroker 54 DABroker 138 DABroker 69 DABroker 44 DABroker 49 DABroker 49 DABroker 35 DABroker 159 DABroker DABroker 41 DABroker 43 DABroker DABroker 78 DABroker 80 DABroker 42 DABroker 49 DABroker 51 DABroker 57 DABroker DABroker 172 DABSELECTCOLCNT 55 DABSELECTINFCNT 55 dabsetup 44 DABSQL_HiRDB_DICTIONARY_DATATY PE 56 DABSQL_TRC_ATTACH 190 DABSQL_TRC_ATTRGET 190 DABSQL_TRC_ATTRSET 190 DABSQL_TRC_AUTO_COMMIT_OFF 198 DABSQL_TRC_AUTO_COMMIT_ON 198 DABSQL_TRC_BIND 191 DABSQL_TRC_CANCEL 189 DABSQL_TRC_CHARFORM 191 DABSQL_TRC_CHARID 191 DABSQL_TRC_CLOSE 189 DABSQL_TRC_COMMIT 187 DABSQL_TRC_CONNECT 186 DABSQL_TRC_DECLARE 188 DABSQL_TRC_DEFINE 192 DABSQL_TRC_DESALLOC 192 DABSQL_TRC_DESCANY 192 DABSQL_TRC_DESCRIBE 188 DABSQL_TRC_DESFREE 192 DABSQL_TRC_DETACH 193 DABSQL_TRC_DISCONNECT 187 DABSQL_TRC_ENVCREATE 193 DABSQL_TRC_ERRGET 193 DABSQL_TRC_EXECUTE 189 DABSQL_TRC_EXECUTE_DIRECT 199 DABSQL_TRC_FETCH 188 DABSQL_TRC_GET_INFO 198 DABSQL_TRC_GETDIAG 198 DABSQL_TRC_GETPIECE 193 DABSQL_TRC_HDLALLOC 194 DABSQL_TRC_HDLFREE 194 DABSQL_TRC_LOBCLOSE 195 DABSQL_TRC_LOBLEN 195 DABSQL_TRC_LOBOPEN 195 DABSQL_TRC_LOBREAD 196 DABSQL_TRC_LOBWRITE 196 DABSQL_TRC_LOGGING 189 DABSQL_TRC_LOGLESS 190 DABSQL_TRC_OPEN 188 DABSQL_TRC_PARAMGET 197 DABSQL_TRC_PREPARE 187 DABSQL_TRC_ROLLBACK 187 DABSQL_TRC_SESBEGIN 197 DABSQL_TRC_SESEND 197 DABSQL_TRC_SET_INFO 199 DABSQL_TRC_SETPIECE 197 DABSQL_TRCSIZE 54 dabstart 77 dabstat 80 dabstop 78 DABSVLOGSIZE 57 DABTCP_TRCSIZE 61 DABTMP 54 DABXA_LOG_ERROR 57 dasysconf 121 Database Connection Server 362 Database Connection Server

393 Database Connection Server 181 Database Connection Server 135 Database Connection Server 66 Database Connection Server 67 Database Connection Server 67 Database Connection Server BLOB Database Connection Server 74 Database Connection Server 91 Database Connection Server IP 91 DBHOST 71 DBMS 362 DBNAME DBPARTNER DBPARTNER DBPARTNER/Client DBPARTNER/Web DBPARTNER Library DBPARTNER Library DBPARTNER Mobile 363 DBPARTNER 30 DBPARTNER DABroker 181 DBSHOST 91 DBSPORT 91 DBSTIMER 92 DECLARE 211 DECLARE 188 DEFINE 216 DEFINE 192 DESALLOC 216 DESALLOC 192 DESCANY 217 DESCANY 192 DESCRIBE 211 DESCRIBE 188 DESFREE 217 DESFREE 192 DETACH 217 DETACH 193 DISCONNECT 212 DISCONNECT 187 DTP 363 E ENVCREATE 218 ENVCREATE 193 ERRGET 218 ERRGET 193 EXECUTE 212 EXECUTE DIRECT 225 EXECUTE DIRECT 199 EXECUTE 189 F FETCH 212 FETCH 188 G GETDIAG 223 GETDIAG 198 GET INFO 224 GET INFO 198 GETPIECE 218 GETPIECE 193 H HDLALLOC 219 HDLALLOC 194 HDLFREE 219 HDLFREE 194 HiRDB 126 HiRDB UNIX58 HiRDB

394 HiRDB BLOB HiRDB 65 HiRDB 126 HITSENSER HITSENSER HITSENSER5 for Cosmicube 363 HITSENSER5 for RDB 363 HITSENSER5 Professional 363 HITSENSER5 Standard 363 HITSENSER5 Web 23 I IP IP J Java JTS 8 Java JTS 9 Java TM 8 JDBC 363 JDBC 363 L LANG 52 LOBCLOSE 220 LOBCLOSE 195 LOBLEN 220 LOBLEN 195 LOBOPEN 221 LOBOPEN 195 LOBREAD 221 LOBREAD 196 LOBWRIT 222 LOBWRITE 196 LOGGING 213 LOGGING 189 LOGLESS 213 LOGLESS 190 M MCONMAX 92 MCONPOOL 92 MCONPROC 92 MRSVPOOL 93 N NLS_LANG 66 O ODBC 363 ODBC3.0 LONG 132 OPEN 214 OPEN 188 ORACLE_HOME 66 ORACLE_SID 66 ORACLE 97 ORACLE LONG LONGRAW 63 ORACLE LONG 131 ORACLE 65 ORACLE 73 OTS P PARAMGET 222 PARAMGET 197 PDCLTPATH 65 PDHOST 65 PDNAMEPORT 65 PDSQLTRACE 65 PDSWAITTIME 65 PDUAPERLOG 65 PREPARE 213 PREPARE 187 R ROLLBACK 213 ROLLBACK

395 S services 47 SESBEGIN 222 SESBEGIN 197 SESEND 223 SESEND 197 SET INFO 225 SET INFO 199 SETPIECE 223 SETPIECE 197 T TCP/IP 364 TCP/IP TPBroker 364 W Web Page Generator 364 WWW 5 X X/Open DTP XA 364 XA 182 XA 129 XA UNIX57 XDM/RD E2 25 XDM/RD 7 36 XDM/RD DABroker DABroker UNIX58 Windows Windows123 /

396 ORACLE Database Connection Server 67 Database Connection Server IP UNIX 186 Windows

397 libdajavac.sl DBMS ID Windows