untitled

Similar documents
untitled

untitled

untitled

untitled

untitled

untitled

untitled

untitled

chapter1,2.doc

ORANGE FOR ORACLE V4.0 INSTALLATION GUIDE (Online Upgrade) ORANGE CONFIGURATION ADMIN O

Interstage5 SOAP서비스 설정 가이드

Interstage4 설치가이드

<C0CCBCBCBFB52DC1A4B4EBBFF82DBCAEBBE7B3EDB9AE2D D382E687770>

1

PCServerMgmt7

Microsoft Word - Server Guide-1.doc

Remote UI Guide

PowerPoint 프레젠테이션

Microsoft PowerPoint - Smart CRM v4.0_TM 소개_ pptx

Backup Exec

1217 WebTrafMon II

untitled

Connection 8 22 UniSQLConnection / / 9 3 UniSQL OID SET

Portal_9iAS.ppt [읽기 전용]

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,.,,,,,,,,,,,,.,...,. U.S. GOVERNMENT END USERS. Oracle programs, including any oper

Apache2 + Tomcat 5 + JK2 를 사용한 로드밸런싱과 세션 복제 클러스터링 사이트 구축

Analytics > Log & Crash Search > Unity ios SDK [Deprecated] Log & Crash Unity ios SDK. TOAST SDK. Log & Crash Unity SDK Log & Crash Search. Log & Cras

Solaris Express Developer Edition

10.ppt

J2EE & Web Services iSeminar

Corporate PPT Template

Orcad Capture 9.x

슬라이드 1


소개 TeraStation 을 구입해 주셔서 감사합니다! 이 사용 설명서는 TeraStation 구성 정보를 제공합니다. 제품은 계속 업데이트되므로, 이 설명서의 이미지 및 텍스트는 사용자가 보유 중인 TeraStation 에 표시 된 이미지 및 텍스트와 약간 다를 수

초보자를 위한 ADO 21일 완성

The Self-Managing Database : Automatic Health Monitoring and Alerting

untitled


Mobile Service > IAP > Android SDK [ ] IAP SDK TOAST SDK. IAP SDK. Android Studio IDE Android SDK Version (API Level 10). Name Reference V

Intro to Servlet, EJB, JSP, WS

Chap7.PDF

chapter4

FileMaker 15 ODBC 및 JDBC 설명서

vm-웨어-01장

본문서는 초급자들을 대상으로 최대한 쉽게 작성하였습니다. 본문서에서는 설치방법만 기술했으며 자세한 설정방법은 검색을 통하시기 바랍니다. 1. 설치개요 워드프레스는 블로그 형태의 홈페이지를 빠르게 만들수 있게 해 주는 프로그램입니다. 다양한 기능을 하는 플러그인과 디자인

untitled

untitled

No Slide Title

02 C h a p t e r Java

untitled

Intra_DW_Ch4.PDF

uFOCS


DocsPin_Korean.pages

PowerPoint 프레젠테이션

FileMaker ODBC 및 JDBC 가이드

목차 BUG offline replicator 에서유효하지않은로그를읽을경우비정상종료할수있다... 3 BUG 각 partition 이서로다른 tablespace 를가지고, column type 이 CLOB 이며, 해당 table 을 truncate

PowerPoint 프레젠테이션

thesis-shk

ETL_project_best_practice1.ppt

Oracle Database 10g: Self-Managing Database DB TSC

PRO1_09E [읽기 전용]

PowerPoint 프레젠테이션

교육2 ? 그림

28 THE ASIAN JOURNAL OF TEX [2] ko.tex [5]

MasoJava4_Dongbin.PDF

개요오라클과티베로에서 JDBC 를통해접속한세션을구분할수있도록 JDBC 접속시 ConnectionProperties 를통해구분자를넣어줄수있다. 하나의 Node 에다수의 WAS 가있을경우 DB 에서 Session Kill 등의동작수행시원하는 Session 을선택할수있다.

Domino Designer Portal Development tools Rational Application Developer WebSphere Portlet Factory Workplace Designer Workplace Forms Designer

MySQL-Ch10

User's Guide Manual

Analyst Briefing

Dialog Box 실행파일을 Web에 포함시키는 방법

rmi_박준용_final.PDF

PowerPoint

CD-RW_Advanced.PDF

Smart Power Scope Release Informations.pages

PowerPoint Presentation

초보자를 위한 C++

Copyright 2012, Oracle and/or its affiliates. All rights reserved.,,,,,,,,,,,,,.,..., U.S. GOVERNMENT END USERS. Oracle programs, including any operat

NoSQL

PRO1_04E [읽기 전용]

MySQL-Ch05

PowerChute Personal Edition v3.1.0 에이전트 사용 설명서

thesis

LXR 설치 및 사용법.doc

スライド タイトルなし

Assign an IP Address and Access the Video Stream - Installation Guide

PowerPoint 프레젠테이션

VOL /2 Technical SmartPlant Materials - Document Management SmartPlant Materials에서 기본적인 Document를 관리하고자 할 때 필요한 세팅, 파일 업로드 방법 그리고 Path Type인 Ph

1. efolder 시스템구성 A. DB B. apache - mod-perl - PHP C. SphinxSearch ( 검색서비스 ) D. File Storage 2. efolder 설치순서 A. DB (MySQL) B. efolder Service - efolder

MS-SQL SERVER 대비 기능

MAX+plus II Getting Started - 무작정따라하기

Cache_cny.ppt [읽기 전용]

UNIST_교원 홈페이지 관리자_Manual_V1.0

LCD Display

Sun Java System Messaging Server 63 64

MPLAB C18 C

FileMaker 15 WebDirect 설명서

Transcription:

FORCS Co., LTD 1

2 FORCS Co., LTD

FORCS Co., LTD 3

4 FORCS Co., LTD

FORCS Co., LTD 5

..,,..... 6 FORCS Co., LTD

,. Shell Command, Shell Command.,. Getting Started....,.. FORCS Co., LTD 7

WAS API, OZC, OZS, OZF. ᆞ.. API, UDS, USL, API API(Application Program Interface)... 8 FORCS Co., LTD

FORCS Co., LTD 9

. JAVA/XML JDBC/ODBC JVM (Java Virtual Machine) WAS onepoint,,. DB Pooling,,,, / 10 FORCS Co., LTD

. (Concurrent Mode),. CGI Non-DB UDS(User Data Store). Note UDS(User Data Store) JDBC ODBC NonDB UDS(User Data Store). UDS XML, EJB, Legacy Data. /,.. FORCS Co., LTD 11

UDS JDBC/ODBC Document Manager Data Manager Monitor User Access Manager Schedule Manager Cache Manager Log Manager Repository Manager UDS Non-database Source JDBC/ODBC /, NT Event Unix Syslog 12 FORCS Co., LTD

Windows FORCS Co., LTD 13

Web Server DBMS JRE(Java Runtime Environment) 1.1.X Windows NT/2000, Linux, HPUX, Solaris, AIX, Unixware, Mainframe Microsoft IIS(Internet Information Server), Web Server Apache, NCSE, CERN, Netscape Enterprise Server WebLogic, WebSphere, Oracle ias(internet Web Application Application Server), Fujitsu Interstage, NEC Server WebOTX J2EE WAS Oracle, Informix, Sybase, MSSQL Server, DB2 ODBC/JDBC DBMS 14 FORCS Co., LTD

License ozlicense.xml [License]. License License, IP,. IP License. ozcntrl.bat / ozcntrl.sh ozcntrl.bat/ozcntrl.sh JRE. Windows JVM, UNIX ozcntrl.sh JRE Path. ozcntrl.bat @echo off rem ----------------------------------------------------- rem rem OZ Contorl(OZA SHELL) rem rem rem This script file written and tested under Windows 2000 rem rem User should set following variables: rem rem JAVA_HOME - Determines the version of Java used to start rem OZ Server. This variable must point to the rem root directory of a JDK or JRE installation. rem for an up-to-date list of supported JVMs your platform. rem USER_CLASSPATH - Use this variable to append jar files or directories to rem the OZLIB. FORCS Co., LTD 15

rem MAX_MEMORY - Maximum memory used by OZ Server. (The unit is megabyte.) rem MIN_MEMORY - Minimum memory used by OZ Server. (The unit is megabyte.) rem rem ----------------------------------------------------- rem ----------------------------------- rem Set user-defined variables rem ----------------------------------- set JAVA_HOME=...JRE set MAX_MEMORY=256 set MIN_MEMORY=128 set JAVA_OPTION= set OZSERVER_HOME=.. set USER_CLASSPATH=%OZSERVER_HOME%uds set OZLIBALL=%OZSERVER_HOME%lib set OZJLIBALL=%OZSERVER_HOME%UniversalDriver rem ----------------------------------- rem OZ Main Class rem ----------------------------------- set OZLIB=%OZLIBALL%ozsfw35.jar;%OZSERVER_HOME%conf set OZLIB=%OZLIB%;%OZLIBALL%ozusl.jar rem ----------------------------------- rem for Servlet rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%servlet.jar rem ----------------------------------------------------- rem HTTPS/SSL Module rem ----------------------------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%jcert.jar set OZLIB=%OZLIB%;%OZLIBALL%jnet.jar set OZLIB=%OZLIB%;%OZLIBALL%jsse.jar rem ----------------------------------- rem Library for Logging rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%log4j.jar rem ----------------------------------- rem Library for XML rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%parser.jar set OZLIB=%OZLIB%;%OZLIBALL%xerces.jar 16 FORCS Co., LTD

set OZLIB=%OZLIB%;%OZLIBALL%crimson.jar rem ----------------------------------- rem Library for XML Store rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%dtdparser12.jar rem ----------------------------------- rem Repository File Sysgtem DB rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%hsqldb.jar rem ----------------------------------- rem USL Jar for USL rem ----------------------------------- set OZLIB=%OZLIB%;%OZLIBALL%OZUSLServerSession.jar set OZLIB=%OZLIB%;%OZLIBALL%OZUSLServerDES128.jar rem ----------------------------------- rem JDBC Driver for Oracle rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%classes12.zip rem ----------------------------------- rem JDBC Driver for Mysql (3.0.14) rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%mysql.jar rem If your version of oracle is 7 and rem its character set is DBCS, rem then delete 'rem' of next line rem set OZLIB=%OZLIB%;%OZLIBALL%ijava.jar rem ----------------------------------- rem JDBC Driver for Informix rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%ifxjdbc.jar rem ----------------------------------- rem JDBC Driver for Syabse rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%jconn2.jar rem ----------------------------------- rem JDBC Driver for MSSQL rem ----------------------------------- rem set OZLIB=%OZLIB%;%OZLIBALL%jkjdbc2.jar set OZLIB=%OZLIB%;%OZJLIBALL%msbase.jar set OZLIB=%OZLIB%;%OZJLIBALL%msutil.jar FORCS Co., LTD 17

set OZLIB=%OZLIB%;%OZJLIBALL%mssqlserver.jar rem ----------------------------------- rem JDBC Driver for IBM DB2 rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%db2java.zip set OZLIB=%OZLIB%;%OZJLIBALL%db2jcc.jar set OZLIB=%OZLIB%;%OZJLIBALL%db2jcc_license_cisuz.jar set OZLIB=%OZLIB%;%OZJLIBALL%db2jcc_license_cu.jar rem ----------------------------------- rem JDBC Driver for Uni-SQL rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%unisqljdbc10.jar rem ----------------------------------- rem JDBC Driver for SAP rem ----------------------------------- set OZLIB=%OZLIB%;%OZJLIBALL%sapjco.jar rem ----------------------------------- rem USER_CLASSPATH rem ----------------------------------- set OZLIB=%OZLIB%;%USER_CLASSPATH% set JAVA_OPTION= if not "%1" == "-start" goto notstart set JAVA_OPTION= %JAVA_OPTION% -Xms%MIN_MEMORY%m - Xmx%MAX_MEMORY%m :notstart %JAVA_HOME%binjava %JAVA_OPTION% -cp %OZLIB% oz.admin.shell.server.ozashell %1 %2 %3 %4 %5 %6 %7 %8 %9 ozcntrl.sh #!/bin/sh #----------------------------------------------------- # # OZ Contorl. # # This script file written and tested under HP-UX # # User should set following variables: # 18 FORCS Co., LTD

# JAVA_HOME - Determines the version of Java used to start # OZ Server. This variable must point to the # root directory of a JDK or JRE installation. # for an up-to-date list of supported JVMs your platform. # USER_CLASSPATH - Use this variable to append jar files or directories to # the OZLIB. # MAX_MEMORY - Maximum memory used by OZ Server. (The unit is megabyte.) # MIN_MEMORY - Minimum memory used by OZ Server. (The unit is megabyte.) # JAVA_OPTIONS - On some platforms, certain java command-line options are # recommanded when running OZ Server. # #----------------------------------------------------- # ----------------------------------- # Set user-defined variables # ----------------------------------- JAVA_HOME=../../jre USER_CLASSPATH= MAX_MEMORY=256 MIN_MEMORY=128 JAVA_OPTION=-hotspot OZSERVER_HOME=.. OZLIB=.:$OZSERVER_HOME/conf OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozsfw35.jar # ----------------------------------- # for User Data Set classes # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/ozusl.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/hsqldb.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/servlet.jar # ----------------------------------- # for User Data Set classes # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/uds # ----------------------------------- # Library for Logging # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/log4j.jar # ----------------------------------- # Library for XML FORCS Co., LTD 19

# ----------------------------------- #OZLIB=$OZLIB:$OZSERVER_HOME/lib/jaxp.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/parser.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/crimson.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/xerces.jar # ----------------------------------- # USL Jar for USL # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/OZUSLServerSession.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/OZUSLServerDES128.jar # ----------------------------------- # JDBC Driver for MSSQL # ----------------------------------- #OZLIB=$OZLIB:$OZSERVER_HOME/lib/jkjdbc.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/msbase.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/msutil.jar OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/mssqlserver.jar # ----------------------------------- # JDBC Driver for Oracle # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/classes12.zip # If your version of oracle is 7 and # its character set is KOREAN(KSC5601), # then delete '#' of next line # OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/ijava.jar # ----------------------------------- # JDBC Driver for Informix # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/ifxjdbc.jar # ----------------------------------- # JDBC Driver for Syabse # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/jconn2.jar # ----------------------------------- # JDBC Driver for IBM DB2 # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/db2java.zip # ----------------------------------- # JDBC Driver for Uni-SQL # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/unisqljdbc10.jar 20 FORCS Co., LTD

# ----------------------------------- # JDBC Driver for SAP # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/UniversalDriver/sapjco.jar # ----------------------------------- # HTTPS/SSL Module # ----------------------------------- OZLIB=$OZLIB:$OZSERVER_HOME/lib/jcert.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jnet.jar OZLIB=$OZLIB:$OZSERVER_HOME/lib/jsse.jar # ----------------------------------- # USER CLASSPAATH # ----------------------------------- if [ "$USER_CLASSPATH"!= "" ]; then OZLIB=$OZLIB:$USER_CLASSPATH fi if [ "$1"!= "-start" ]; then JAVA_OPTION= else JAVA_OPTION="$JAVA_OPTION -ms$min_memory"m JAVA_OPTION="$JAVA_OPTION -mx$max_memory"m fi echo "" echo $OZLIB echo "" $JAVA_HOME/bin/java $JAVA_OPTION -classpath $OZLIB oz.admin.shell.server.ozashell $1 $2 $3 $4 $5 $6 $7 $8 $9 ozcntrl ". ". ozcntrl.bat/ozcntrl.sh. ozcntrl.bat/ozcntrl.sh ". ". FORCS Co., LTD 21

. UNIX Windows. Windows JRE SUN JRE 1.3.1. bin chk_version.bat chk_version.sh InstallService.bat ozcntrl.bat ozcntrl.sh ozencrypted.bat OZServer.ini OZService.exe ozservice_create.bat ozstart.bat ozstart.sh ozstop.bat ozstop.sh Profile.exe server.ico Service.bat ServiceManager.exe StartService.bat (.bat) (.sh) NT (.bat) (.sh) ID NT Service (.bat) (.sh) (.bat) (.sh) NT,,, 22 FORCS Co., LTD

StopService.bat UninstallService.bat NT user.cif None cache cache_dm cachemngr.propertie s databind.properties db.properties DB dbtmpl.properties DBMS JDBC log.properties monitor.properties Monitor conf ozserver.properties repository.properties sap.properties SAP spmgr.properties srmngr.properties uslmngr.properties (, PKI ) xml.properties XML expand OZMBAServer.dll ASP db.properties.dataso urce db.properties.db2 db.properties.informi x db.properties.mssql db.properties DBMS db.properties.odbc conf/ sample db.properties.oracle db.properties.sybas e db.properties.unisql db.properties.user repository.properties.odbc repository.properties repository.properties DBMS.oracle lib crimson.jar XML FORCS Co., LTD 23

dtdparser120.jar XML hsqldb.jar Builtin jcert.jar jnet.jar jsse.jar J2EE (HTTP/SSL ) JRE 1.3.X log4j.jar NTEventLogAppend er.dll Windows NT DLL ozsfw35.jar OZUSLServerDES1 28.jar OZUSLServerSessi USL on.jar parser.jar XML servlet.jar USL J2EE xerces.jar XML Xerces license ozlicense.xml Logs monitor.log Monitor server.log repository_files scheduled_data UniversalDri ver db_file.data Builtin db_file.properties db_file.script Builtin query.log classes12.jar Oracle 8i, 9i JDBC Driver classes12.zip db2java.jar IBM DB2 JDBC Driver db2java.zip db2jcc.jar db2jcc_license_ IBM DB2 JDBC Type 8 cisuz.jar (DB2 8 ) db2jcc_license_cu.j ar ifxjdbc.jar Infomix JDBC Driver ijava.jar Oracle 7i JDBC Driver jconn2.jar Sybase ASE JDBC Driver jkjdbc.jar MSSQL 97 JDBC 24 FORCS Co., LTD

jt400.jar msbase.jar mssqlserver.jar msutil.jar mysql.jar sapjco.jar sapjcorfc.dll unisqljdbc10.jar unsqljdbc205.zip IBM JT400 JDBC MSSQL 2000 JDBC Mysql JDBC SAP UniSQL JDBC : 'UniversalDriver' JDBC, RDB JDBC. JDBC. bin chk_version.bat chk_version.sh ozcntrl.bat ozcntrl.sh (.bat) (.sh) (.bat) (.sh) cache cache_dm ID ozencrypted.bat None user.cif conf cachemngr.properties databind.properties db.properties dbtmpl.properties DB DBMS JDBC FORCS Co., LTD 25

log.properties monitor.properties repository.properties sap.properties spmgr.properties srmngr.properties uslmngr.properties xml.properties Monitor SAP (, PKI ) XML db.properties.datasou rce db.properties.db2 db.properties.informix db.properties.mssql db.properties.odbc db.properties DBMS conf/ sample db.properties.oracle db.properties.sybase db.properties.unisql db.properties.user repository.properties.o dbc repository.properties.o repository.properties DBMS racle license ozlicense.xml logs monitor.log server.log Monitor repository_files SilverStream UniversalDri ver db_file.data Builtin db_file.properties db_file.script query.log Builtin servlet.java SilverStream servlet.xml (WAS ) classes12.jar classes12.zip Oracle 8i, 9i JDBC Driver db2java.jar db2java.zip IBM DB2 JDBC Driver db2jcc.jar IBM DB2 JDBC Type 8 26 FORCS Co., LTD

db2jcc_license_ (DB2 8 ) cisuz.jar db2jcc_license_cu.jar ifxjdbc.jar Infomix JDBC Driver ijava.jar Oracle 7i JDBC Driver jconn2.jar Sybase ASE JDBC Driver jkjdbc.jar MSSQL 97 JDBC jt400.jar IBM JT400 JDBC msbase.jar mssqlserver.jar MSSQL 2000 JDBC msutil.jar mysql.jar Mysql JDBC sapjco.jar sapjcorfc.dll SAP unisqljdbc10.jar unsqljdbc205.zip UniSQL JDBC WEB-INF web.xml URL WEB_INF/ HelloWorld.class classes ozserver.properties WEB_INF/ lib crimson.jar dtdparser120.jar hsqldb.jar jcert.jar jnet.jar jsse.jar log4j.jar NTEventLogAppender.dll ozsfw35.jar OZUSLServerDES12 8.jar OZUSLServerSession.jar parser.jar xerces.jar XML XML Builtin J2EE (HTTP/SSL ) JRE 1.3.X Windows NT DLL USL XML XML Xerces : 'UniversalDriver' JDBC, RDB FORCS Co., LTD 27

JDBC. JDBC. Windows. [bin] ozstart.bat. ozstop.bat. UNIX [bin] ozstart.sh ozstop.sh. ozstart.bat / ozstart.sh ozstart.bat ozstart.sh Windows UNIX. ozcntrl.bat ozcntrl.sh. ozstart.bat @echo off rem ----------------------------------------------------- rem rem OZ Server Start-up File rem rem This batch file written and tested under Windows 2000 rem check your path indicate <JAVA_HOME>\bin rem rem ----------------------------------------------------- ozcntrl.bat -start %1 28 FORCS Co., LTD

ozstart.sh # ----------------------------------------------------- # # OZ Server Start-up File # # This batch file written and tested under UNIX(HP-UX) System # check your path indicate <JAVA_HOME>/bin # # -----------------------------------------------------./ozcntrl.sh -start Windows. Windows. JAVA CLASSPATH. { }\bin\ozservice_create.bat OZServer.ini. { }\bin\installservice.bat { }\bin\uninstallservice.bat. FORCS Co., LTD 29

OZServer.ini [[JAVA] BIN=..\..\JRE\bin\java.exe OPTION=-Xms128m -Xmx256m -cp ARGS=oz.admin.shell.server.OZAShell -start PATH=C:\Program Files\FORCS\OZ XStudio\OZDServer\bin [CLASS]..\lib\ozsfw35.jar;..\conf\;..\lib\servlet.jar;..\lib\jcert.jar;..\lib\jnet.jar;..\lib\jsse.jar;..\lib\log4j.jar;..\lib\parser.jar;..\lib\xerces.jar;..\lib\crimson.jar;..\lib\dtdparser12.jar;..\lib\OZUSLSe rversession.jar;..\lib\ozuslserverdes128.jar;..\lib\hsqldb.jar;..\universaldriver\classe s12.zip;..\universaldriver\mysql.jar;..\universaldriver\ifxjdbc.jar;..\universaldriver\jcon n2.jar;..\universaldriver\msbase.jar;..\universaldriver\msutil.jar;..\universaldriver\mss qlserver.jar;..\universaldriver\db2java.zip;..\universaldriver\db2jcc.jar;..\universaldrive r\db2jcc_license_cisuz.jar;..\universaldriver\db2jcc_license_cu.jar;..\universaldriver\u nisqljdbc10.jar;..\uds\ @echo off InstallService.bat rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem %1 - ( ) rem %2 - rem - OZ OZService.exe. rem ---------------------------------------------------------------------- rem ServiceManager.exe %1 /i %2 %1 ServiceManager.exe OZServer /i " C:\Program Files\Forcs\OZ XStudio\OZServer\bin\OZService.exe" OZServer rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem InstallService OZServer D:/OZSource/NTService/OZService.exe rem ---------------------------------------------------------------------- @echo off UninstallService.bat rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- 30 FORCS Co., LTD

rem %1 - ( ) rem ---------------------------------------------------------------------- rem ServiceManager.exe %1 /u ServiceManager.exe OZServer /u rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem UninstallService OZServer rem ---------------------------------------------------------------------- { }\conf\ozserver.properties path.oz.server.home. { }\bin\installservice.bat { }\bin\uninstallservice.bat OZService.exe. { }\bin\installservice.bat. { }\bin\uninstallservice.bat. [] [] []. OZServer. [ ]. FORCS Co., LTD 31

OZServer [ ]. 32 FORCS Co., LTD

WAS. WAS " WAS - WAS ". WAS. FORCS Co., LTD 33

34 FORCS Co., LTD

ozserver.properties xml.properties log.properties db.properties cachemngr.properties monitor.properties uslmngr.properties repository.properties spmgr.properties srmngr.properties dbtmpl.properties FORCS Co., LTD 35

.,. ozserver.properties [Daemon] {OZ_HOME}\conf\ozserver.properties [Servlet] {OZ_HOME}\WEB-INF\classes\ozserver.properties.. ozserver.properties #------------------------------------------- # Main configuration of ozserver/ozservlet #------------------------------------------- server.portnumber=8003 path.oz.server.home=.. path.license.file=%oz_home%/license/ozlicense.xml path.xml.properties.file=%oz_home%/conf/xml.properties path.log.properties.file=%oz_home%/conf/log.properties path.securitypolicy.properties.file=%oz_home%/conf/spmgr.properties path.connpool.properties.file=%oz_home%/conf/db.properties path.cache.properties.file=%oz_home%/conf/cachemngr.properties path.monitor.properties.file=%oz_home%/conf/monitor.properties path.repository.properties.file=%oz_home%/conf/repository.properties path.usl.properties.file=%oz_home%/conf/uslmngr.properties path.schedule.properties.file=%oz_home%/conf/srmngr.properties path.dbinfotemplate.properties.file=%oz_home%/conf/dbtmpl.properties path.sapclient.properties.file=%oz_home%/conf/sap.properties %OZ_HOME% ozserver.properties path.oz.server.home. 36 FORCS Co., LTD

ozserver.properties ozserver.properties server.portnumber ( ) TCP/IP. : 8003 path.oz.server.home. (/ ) path.license.file path.xml.properties.file path.log.properties.file path.securitypolicy.properties.file path.connpool.properties.file path.cache.properties.file path.monitor.properties.file path.repository.properties.file path.usl.properties.file path.schedule.properties.file path.dbinfotemplate.properties.file path.sapclient.properties.file. xml.properties. log.properties. spmgr.properties. db.properties. cachemngr.properties. monitor.properties. repository.properties. uslmngr.properties. srmngr.properties. dbtmpl.properties. sap.properties. FORCS Co., LTD 37

xml.properties [Daemon/Servlet] {OZ_HOME}\conf\xml.propeties xml. xml.properties ----------------------------------------------- # Configuration of XML parser used by OZ Server #----------------------------------------------- #SYSTEM_DEFAULT Setting sax.parser=sun dom.parser=sun ################################################ # # parser List # - followings are able to used in SAX and DOM # ---------------------------------------------- # # SUN : parser.jar # CRIMSON : crimson.jar # XERCES : xerces.jar # SYSTEM_DEFAULT : javax.xml.parsers.documentbuilderfactory. sax.parser dom.parser. XML. SUN CRIMSON XERCES SYSTEM_DEFAULT 38 FORCS Co., LTD

log.properties [Daemon/Servlet] {OZ_HOME}\conf\log.properties log, 'LOG4OZ' 'LOG4J', log CONSOLE(), FILE, NT Event, UNIX Syslog. 'LOG4OZ' "BUILTIN_LOGGING_CONSOLE", " BUILTIN_LOGGING_FILE", 'LOG4J' "Set Prioritylog Level", "Appender CONSOLE", "Appender ROLLING_FILE", "Appender NT Event", "Appender syslog". HTTP. log.properties #----------------------------------------------------------- # configuraion of OZ logging system (LOG4OZ) #----------------------------------------------------------- # #USE_BUILTIN_LOGGING_ENGINE=true #BUILTIN_LOGGING_CONSOLE=true #BUILTIN_LOGGING_CONSOLE.CharSet= # #BUILTIN_LOGGING_FILE=true #BUILTIN_LOGGING_FILE.CharSet= #BUILTIN_LOGGING_FILE.LOCATION=%OZ_HOME%/logs/server_oz.log FORCS Co., LTD 39

#BUILTIN_LOGGING_FILE.APPEND=true #BUILTIN_LOGGING_FILE.MaxBackupIndex=5 #BUILTIN_LOGGING_FILE.MaxFileSize=1MB #BUILTIN_LOGGING_FILE.ImmediateFlush=true #----------------------------------------------------------- # configuraion of OZ logging system (LOG4J) #----------------------------------------------------------- # # Set Prioritylog level # # DEBUG, INFO, ERROR Priority=DEBUG # # appender CONSOLE # Console. # CONSOLE.Type=Stdout CONSOLE.Layout=%r [%t] %p %c{1} %x - %m%n CONSOLE.Async=false # # appender ROLLING_FILE # File. # MaxFileSize. # #. # MaxBackupIndex. # # Layout : # Append : # ImmediateFlush : # false #. # CharSet :. # ROLLING_FILE.Type=RollingFile ROLLING_FILE.Layout=%d{ISO8601} [%t] %-5p %c{1} %x - %m%n ROLLING_FILE.File=%OZ_HOME%/logs/server.log ROLLING_FILE.Append=true ROLLING_FILE.MaxBackupIndex=5 ROLLING_FILE.MaxFileSize=1MB ROLLING_FILE.ImmediateFlush=true # 40 FORCS Co., LTD

# appender NT Event # NT. # #NT_EVENT.Type=NTEvent #NT_EVENT.Layout=%r %p %c{1} - %m%n #NT_EVENT.Threshold=ERROR # # appender syslog # Unix syslog. # #SYSLOG.Type=Syslog #SYSLOG.Layout=[OZ] %r %p %c{1} - %m #SYSLOG.Threshold=ERROR #SYSLOG.SyslogHost=127.0.0.1 #SYSLOG.Facility=USER #SYSLOG.FacilityPrinting=false #------------------------------------------------ # configuraion of HTTPStore Logging #------------------------------------------------ #HTTPSTORE_LOG_FILE=MANUAL (AUTO/MANUAL/NONE) # HTTPSTORE_LOG_FILE.LOCATION=%OZ_HOME%/logs (Directory Name) #-------------------------------------------------------------------------------------------------- # Instance ( ) #-------------------------------------------------------------------------------------------------- #MultiInstance=false #WASName= #WASVersion= log.properties LOG4OZ LOG4OZ. USE_BUILTIN_LOGGING _ENGINE true : LOG4OZ false : LOG4OZ, LOG4J BUILTIN_LOGGING_CO NSOLE Console. true : Console false : Console FORCS Co., LTD 41

Console (IBM BUILTIN_LOGGING_CO NSOLE.CharSet 'CP500' ).. BUILTIN_LOGGING_FI LE BUILTIN_LOGGING_FI LE.CharSet BUILTIN_LOGGING_FI LE.LOCATION BUILTIN_LOGGING_FI LE.APPEND BUILTIN_LOGGING_FI LE.MaxBackupIndex BUILTIN_LOGGING_FI LE.MaxFileSize BUILTIN_LOGGING_FI LE.ImmediateFlush 'BUILTIN_LOGGING_FILE.LOCATION'. (IBM 'CP500' ).... Backup.... LOG4J Set Prioritylog level priority log Level. [ERROR] : log level, log. [INFO] : [ERROR] level log log. [DEBUG] : [INFO] [ERROR] level log log. 42 FORCS Co., LTD

Appender. CONSOLE.Type, 'stdout'. CONSOL E CONSOLE.Layou t CONSOLE.Async. [Log Layout].. 'true', 'false'. appender - ROLLING_FILE. Type ROLLING_FILE. Layout ROLLING_FILE. File Rolling File 'RollingFile'. Log. [Log Layout]. Log. ROLLING _ FILE ROLLING_FILE. Append ROLLING_FILE. MaxBackupIndex ROLLING_FILE. MaxFilesize ROLLING_FILE. ImmediateFlush Log. true. Backup.... FORCS Co., LTD 43

Log Windows NT Event Lib NTEventLog Appender.dll WINNT\SYSTEM32. NT Event NT_Event.Type NT_Event.Layout Log NT Event 'NTEvent'.. [Log Layout]. Prioritylog level NT_Event.Thresh. Prioritylog old level. ERROR/INFO/DEBUG Unix Syslog appender - SYSLOG.Type SYSLOG.Layout 'Syslog'.. [Log Layout]. syslog - SYSLOG.Thresh old SYSLOG.Syslog Host SYSLOG.Facility Priorityloy level Syslog. Prioritylog level. ERROR/INFO/DEBUG Syslog Unix IP. Syslog. 'KERN', 'USER', 'MAIL', 'DAEMON', 'AUTH', 'SYSLOG', 'LPR', 'NEWS', 'UUCP', 'CRON', 'AUTHPRIV', 'FTP', 'LOCAL1', 'LOCAL2', 'LOCAL3', 'LOCAL4', 'LOCAL5', 'LOCAL6', 'LOCAL7'. 44 FORCS Co., LTD

appender syslog SYSLOG.Facility true log Message - Printing Facility. HTTP HTTP HTTP ODI, ODI HTTP,. HTTP. 'MANUAL'. HTTPSTORE_LOG _FILE MANUAL AUTO NONE HTTP., HTTP. HTTP., HTTPSTORE_LOG _FILE.LOCATION., '%OZ_HOME%/logs'.. HTTP,, HTTP. HTTP " " HTTP. 'HTTPSTORE_LOG_FILE=AUTO' HTTP. 'OZ_HTTPSTATMENT.LOG.#' '#' 1. FORCS Co., LTD 45

Log Layout Character c d m n p r t % OZServer module category name. Category name %c{2}. ) %c oz.server.servlet %c{1} servlet %c{2} server.servlet. log4j (ABSOLUTE, DATE, ISO8601).. [Example] [ %d{dd MM yyyy HH:mm:ss,SSS} ] [ 18 04 2001 18:39:29,777 ] main INFO ozserver OZServer... [Example] [ %d{iso8601} ] [ 2001-04-18 18:39:29,777 ]main INFO ozserver OZServer... log message OZServer event event. ) %d{iso8601} [%t] %5p %c{1} %x%m 20020816 09:56:23,203[Handler 1] INFO MessageHandler C "\n". New Line log. message log level (INFO, DEBUG, ERROR ). %p ) %d{iso8601} [%t] %5p %c{1} %x%m 20020816 09:56:23,203[Handler 1] INFO MessageHandler millisecond event. [Example] [%r] [2994] main INFO oz.server OZServer... Thread event. [Example] [%t] 59485 [Thread2] INFO oz.server Received a message %. [Example] %% 46 FORCS Co., LTD

Log Date Format Symbol Meaning Presentation Example G Era designator Text AD y Year Number 2001 M Month Text & Number May & 05 d Day Number 05 h Hour in am/pm (1~12) Number 12 H Hour in day (0~23) Number 0 m Minute Number 30 s Second Number 55 S Millisecond Number 978 E Day in week Text Tuesday D Day in year Number 189 F Day of week in month Number 2 (2nd ) w Week in year Number 27 W Week in month Number 2 a Am/pm marker Text PM k Hour in day (1~24) Number 24 K Hour in am/pm (0~11) Number 0 z Time zone Text Pacific Standard Time ' Escape for text Delimiter " Single quote sign Literal ' ) "yyyy.mm.dd G 'at' hh:mm:ss z" 2001.04.24 AD at 18:25:30 PDT "EEE, MMM d, "yy" Wed, July 10, '96 "h:mm a" 12:08 PM FORCS Co., LTD 47

Instance MultiInstance WASName WASVersion Instance Instance true, false. ex) MultiInstance=true WAS. ex) WASName=WebLogic WAS. ex) WASVersion=7.1 : Instance, WAS WebLogic7.x, WebLogic8.x. 48 FORCS Co., LTD

db.properties [Daemon/Servlet] {OZ_HOME}\conf\db.properties. DB Pool, DB Connection Pool.. aliasename.fieldname = value aliasename : fieldname : db.properties vendor driver url props dsn serveraddress portno sid servername dbname user DBMS. (odbc, oracle, informix, sybase. mssql ) JDBC. JDBC URL. JDBC connection property String. (User/Password ) ODBC... Oracle SID.... FORCS Co., LTD 49

password maxconns initconns timeout. DB Connnection. DB Connection. Maxconns Connnection.(:) monitor log session id sessionquery. "monitor.properties". true ConnectionPool connection doconnectioncheck test query connection. testquerystring doconnectioncheck=true. DBMS db.properties Oracle oracle_example.vendor=oracle oracle_example.serveraddress=127.0.0.1 oracle_example.portno=1521 oracle_example.sid=orcl oracle_example.user=oz oracle_example.password=oz oracle_example.maxconns=20 oracle_example.initconns=5 oracle_example.timeout=5 Informix informix_example.vendor=informix informix_example.serveraddress=127.0.0.1 informix_example portno=1526 informix_example.servername=ozserver informix_example.dbname=sysutils informix_example.user=informix informix_example.password=informix informix_example.maxconns=20 informix_example.initconns=5 informix_example.timeout=5 50 FORCS Co., LTD

MSSQL Server mssql_example.vendor=mssql mssql_example.serveraddress=127.0.0.1 mssql_example.portno=1433 mssql_example.dbname=newintra mssql_example.user=sa mssql_example.password= mssql_example.maxconns=20 mssql_example.initconns=5 mssql_example.timeout=5 ODBC odbc_example.vendor=odbc odbc_example.dsn=odbc_example odbc_example.user= odbc_example.password= odbc_example.maxconns=5 odbc_example.initconns=2 odbc_example.timeout=5 db2 db2_example.vendor=db2 db2_example.serveraddress=127.0.0.1 db2_example.portno=1344 db2_example.dbname=db2 db2_example.user=db2admin db2_example.maxconns=20 db2_example.initconns=5 db2_example.timeout=5 sybase Sybase_example.vendor=sybase Sybase_example.serverAddress=127.0.0.1 Sybase_example.dbName=master Sybase_example.portNo=2343 Sybase_example.user=sa Sybase_example.password=sybase Sybase_example.maxconns=20 Sybase_example.initconns=5 Sybase_example.timeout=5 FORCS Co., LTD 51

unisql unisql_example.vendor=unisql unisql_example.serveraddress=127.0.0.1 unisql_example.dbname=demodb unisql_example.portno=44300 unisql_example.user= unisql_example.password= unisql_example.maxconns=20 unisql_example.initconns=5 unisql_example.timeout=5 User Custom DBMS user_example1.vendor=user user_example1.driver=org.gjt.mm.mysql.driver user_example1.url=jdbc:mysql://ip/test user_example1.props=user=oz;password=oz user_example1.user=oz user_example1.maxconns=20 user_example1.initconns=5 user_example1.timeout=5 Data Source JNDI ds_example.vendor=oracle ds_example.serveraddress=127.0.0.1 ds_example.portno=1521 ds_example.sid=forcs815 ds_example.user=scott ds_example.password=tiger ds_example.maxconns=5 ds_example.initconns=0 ds_example.timeout=5 # # Set JDBC Driver using JNDI. # com.forcs.jdbc.jndijdbcdriver is provided by FORCS # in order to use DataSource. # ds_example.driver=com.forcs.jdbc.jndijdbcdriver # # URL Naming Rule # forcs:<jndi_context_factory_name>:<user>:<password>:<jndi_source_name> # forcs:<jndi_context_factory_name>:<jndi_source_name> 52 FORCS Co., LTD

# # DataSource of WebLogic ds_example.url=forcs:weblogic.jndi.wlinitialcontextfactory:<datasource Name> # DataSource of WebSphere ds_example.url=forcs:com.ibm.websphere.naming.wsninitialcontextfactory:<dataso urce Name> # DataSource of Jeus ds_example.url=forcs:jeus.jndi.jeuscontextfactory:<datasource Name> # DataSource of iplanet # Notice : DataSource Name include "jdbc/" in case of iplanet # ex) jdbc/ecfcds ds_example.url=forcs:com.netscape.server.jndi.rootcontextfactory::<datasource Name> # DataSource of JRUN ds_example.url=forcs:jrun.naming.jruncontextfactory:<datasource Name> cachemngr.properties [Daemon/Servlet] {OZ_HOME}\conf\cachemngr.propeties.. cachemngr.properties ### ### Configuraion of Cache Manager ### Last Modified : Tue Jul 29 13:31:39 GMT+09:00 2003 ### CACHE_FILE_PATH = %OZ_HOME%/cache/ CACHE_DM_FILE_PATH = %OZ_HOME%/dm_cache/ FORCS Co., LTD 53

repository.active=true repository.memorycachevalidtime=1200 repository.diskcachevalidtime=0 repository.freememorypercentage=0 datamodule.report.active=true datamodule.report.memorycachevalidtime=1200 datamodule.report.diskcachevalidtime=0 datamodule.report.freememorypercentage=0 datamodule.application.active=true datamodule.application.memorycachevalidtime=1200 datamodule.application.diskcachevalidtime=0 datamodule.application.freememorypercentage=0 cachemngr.properties CACHE_FILE_PATH CACHE_ DM_FILE_PATH //.active //.memorycachevalidtime //.freememorypercentage //.diskcachevalidtime.. 'true/false'... (:). 54 FORCS Co., LTD

FORCS Co., LTD 55

monitor.properties [Daemon/Servlet] {OZ_HOME}\conf\monitor.properties. monitor.properties #------------------------------------------- # configuraion of OZ Trasaction Monotior log #------------------------------------------- # # OZ 3.0. #. # # # Whether log or not # MONITOR.Active=true MONITOR.File=%OZ_HOME%/logs/monitor.log MONITOR.MaxBackupIndex=5 MONITOR.MaxFileSize=1MB MONITOR.ImmediateFlush=true monitor.properties File MaxBackuplndex MaxFileSize ImmediateFlush Log. Backup.... csv 56 FORCS Co., LTD

.. MARK THR_ID TIME F_MEM T_MEM S_CODE S_STATUS S_PARAMS C_IP DB_SS E_TIME MARK. start, end THR_ID ID. (int) TIME. 1970 1 1 0 Millisecond (long), (int) F_MEM. : byte T_MEM JVM. : byte S_CODE S_STATUS... (int) : 9001 : 9002 S_PARAMS. C_IP IP. DB_SS DBMS ID. E_TIME. 1970 1 1 0 Millisecond (long), (int) alias.sessionquery = "[DB Query]" <infomix> SELECT DBINFO(\"sessionid\") FROM SysTables WHERE TabID = 1 <mssql> FORCS Co., LTD 57

select @@spid <oracle> SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid') <sybase> select @@spid // Repository CREATE USER = 100; DELETE USER = 101; CHECK USER PWD = 102; UPDATE USER PWD = 103; DISABLE USER LOGIN = 104; ENABLE USER LOGIN = 105; ISENABLE USER LOGIN = 106; UPDATE USER DESCRIPTION = 107; GET USER DESCRIPTION = 108; GET GROUPID USER = 109; GET USERID NAME = 110; UPDATE GROUPID USER = 111; GET USER LIST = 112; CREATE GROUP = 113; DELETE GROUP = 114; UPDATE USER GROUPADMIN = 115; IS USER GROUPADMIN = 116; UPDATE UPPER GROUPID = 117; GET USER LIST GROUP = 118; GET GROUP LIST GROUP = 119; CREATE ITEM = 120; DELETE ITEM = 121; GET ITEM = 122; GET CATEGORYID ITEM = 123; GET GROUPID ITEM = 124; UPDATE CATEGORYID ITEM = 125; UPDATE GROUPID ITEM = 126; GET ITEM LIST = 127; CREATE CATEGORY = 128; DELETE CATEGORY = 129; UPDATE UPPER CATEGORYID = 130; GET ITEM LIST CATEGORY = 131; 58 FORCS Co., LTD

GET CATEGORY LIST CATEGORY = 132; UPDATE ITEM USER AUTH = 133; UPDATE ITEM GROUP AUTH = 134; GET USER AUTH ITEM = 135 ; GET GROU AUTH ITEM = 136; GET ITEM LIST AUTH USER = 137; GET ITEM LIST AUTH GROUP = 138; GET USER LIST AUTH ITEM = 139; GET GROUP LIST AUTH ITEM = 140; GET ITEMID = 141; GET ITEM DATAINFO = 142; UPDATE USERNAME =143; UPDATE GROUPNAME = 144; UPDATE ITEMNAME = 145; GET ITEMPATH = 146; GET DIRECTITEM = 147; UPDATE CATEGORY USERAUTH = 148; UPDATE CATEGORY GROUPAUTH =149; GET USERAUTH CATEGORY = 150; GET GROUPAUTH CATEGORY = 151; GET CATEGORYLIST USERAUTH = 152; GET CATEGORYLIST GROUPAUTH = 153; GET USERLISTAUTH CATEGORY = 154; GET GROUPLISTAUTH CATEGORY = 155; UPDATE LOGINDEFAULT = 156; UPDATE CATEGORYNAME = 157; CREATE ITEMINDEX = 158; DELETE ITEMINDEX = 159; GET ITEMINDEX LIST = 160; FINDE ITEM ITEMINDEX = 161; UPDATE ITEM FILE = 162; CHECK OUT ITEM = 163; CHECK IN ITEM = 164; ROLLBACK ITEM = 165; UNDO CHECK OUT ITEM = 166; GET ITEM BYVERSION = 167; GET HISTORY LIST = 168; CLEAR HISTORY = 169; CHECK OUT USER = 170; GET CATEGORYINFO = 171; GET ITEMINFO = 172; GET USERNAME BYID = 173; FORCS Co., LTD 59

HAS SPECIFIC ITEM = 174; GET ITEMCOUNT IN CATEGORY = 175; LOGIN TO SERVER = 176; LOGIN TO SERVER FROM SCHEDULER = 177; GET ODI LIST = 178; GET CATEGORYID = 179; GET ITEMID WITH PATH = 180; UPDATE DIRECT ITEM FILE = 181; GET USERINFO = 182; UPDATE ITEM DESCRIPTION = 183; GET GROUPINFO = 184; CREATE CATEGORY WITH PATH = 185; CREATE ITEM WITH NAME = 186; GET DIRECT ITEMS = 187; LOGIN USER = 188; LOGOUT USER= 189; ISLOGIN USER = 190; GET ITEMLIST WITH PERMISSION USER = 191; GET CATEGORYLIST WITH PERMISSION USER = 192; GET ITEMLIST WITH PERMISSION GROUP = 193; GET CATEGORYLIST WITH PERMISSION GROUP = 194; GET CATEGORYLIST OVER VIEW IN ROOT = 195; GET DIRECT ITEM COMPRESSED = 196; GET ITEM LIST CATEGORY NAME = 197; GET ITEMLIST WITH PERMISSION USER CNAME = 198; GET ITEMLIST WITH PERMISSION GROUP CNAME = 199; // Datamodule GET DATAMODULE = 380; GET DEFAULT PARAMETER = 381; GET USDM = 382; GET APPLICATION DM = 383; // Connection Pool API GET POOL INFO = 400; GET POOL STATUS LIST = 401; GET POOL INFO LIST = 402; ADD POOL = 403 ; REMOVE POOL = 404 ; SAVE = 405 ; // Log API GET CONFIG = 406 ; CONFIGURE PROPERTY = 407 ; 60 FORCS Co., LTD

CONFIGURE STRING = 408 ; GET FILE APPENDER FILE = 409 ; SET PRIORITY = 410 ; // Server Info API GET VERSIONS = 411; GARBAGE COLLECT = 412; GET MEMORYINFO = 413; GET HANDLER COUNT = 414; GET MEMORY STATUS = 415; GET CUMULATED COUNT = 416; GET CUMULATED TIMER = 417; GET DYNAMIC INFOMATION = 418; DOWN MONITOR LOG = 419; // Cache API GET CACHE CONFIG = 420; SET CACHE CONFIG = 421; LOGAGENT TEST = 422; GET REALTIME LOG = 423; GET REALTIME MONITOR LOG = 424; DELETE CACHE DATA = 1100; // STOP SERVER STOP = 500; SERVER RESTART = 501; // Application DataModule GET DATAMODULE APP = 520; // Scheduler API GET SCHEDULED RESULT LIST = 600 ; REMOVE SCHEDULED RESULT = 601 ; REMOVE SCHEDULED RESULT LIST = 602 ; SET USDM = 603; // Repository API GET REPOSITORY CONFIG = 700; SET REPOSITORY CONFIG = 701; RELOAD REPOSITORY = 702; // DM Version GET DM VERSION = 800; // USL GET USL = 900; FORCS Co., LTD 61

USE USL = 901; uslmngr.properties [Daemon/Servlet] {OZ_HOME}\conf\uslmngr.properties User Security Logic.,. uslmngr.properties # oz3.0 USL configuration # # set whether use user security logic or not globaly # UseUserSecurityLogicVer30 = true # #set USL class name for each category. # # # for all category (root category) # #category.[/]_server=mypackage.myuslserverclassname #category.[/]_client=mypackage.myuslclientclassname category.[/]_server=oz.usl.ozuslserversample category.[/]_client=oz.usl.ozuslclient # # for a specific category & it's sub-categories # #category.[/some_category/secret_reports]_server=mypackage.myuslserverclas sname 62 FORCS Co., LTD

#category.[/some_category/secret_reports]_client=mypackage.myuslclientclassn ame # #set USL for none category related OZServer service # OZDefault_SERVER=oz.usl.OZUSLServerSample OZDefault_CLIENT=oz.usl.OZUSLClientSample uslmngr.properties UseUSerSecurityLogicVer30 OZDefault_SERVER OZDefault_CLIENT User Security Logic. USL. USL. [category1] USL category1_server. [category1] category 1_CLIENT. USL "API. User Security Logic". repository.properties [Daemon/Servlet] {OZ_HOME}\conf\repository.propeties Repository. '{OZ_HOME}\repository_files'. repository.properties ### ### Repository Properties ### Last Modified : Wed Oct 15 13:29:05 KST 2003 ### # RDB, BUILTIN, NONE REPOSITORY_TYPE = RDB REPOSITORY_FILE_PATH = %OZ_HOME%/repository_files/ #Item file save number per a directory FORCS Co., LTD 63

#Default value is 500 #The value must be lager than 0 REPOSITORY_ITEM_NUMBER_PER_DIRECTORY = 500 #History item's valid days ( The history item over the value of day is deleted, when check in the item ) #Default value is 30 #The 0 value is disable. REPOSITORY_HISTORY_ITEM_VALID_DAYS = 10 REPOSITORY_QUERY_MAXBACKUPINDEX = 5 REPOSITORY_QUERY_MAXFILESIZE = 1M REPOSITORY_QUERY_IMMEDIATEFLUSH = true # # DB alias in /conf/db.properties to use repository # # note: ignored if REPOSITORY_TYPE is BUILTIN # REPOSITORY_DB_ALIAS = mssql_test3 # # note: ignored if REPOSITORY_TYPE is BUILTIN and RDB repository.properties TYPE FILE_PATH ITEM_NUMBER_PER _DIRECTORY HISTORY_ITEM_VALID _DAYS QUERY_MAXBACKUPINDEX QUERY_MAXFILESIZE QUERY_IMMEDIATEFLUSH. RDB : DB RDB. BUILTIN : DB.(Hypersonic SQL DB ) NONE :.... BUILTIN DB. BUILTIN DB. BUILTIN DB. 'true'. 64 FORCS Co., LTD

db.properties Alias DB DB_ALIAS Repository. spmgr.properties [Daemon/Servlet] {OZ_HOME}\conf\spmgr.propeties. spmgr.properties user.multilogin= true user.sessiontimeout = 10 # Secure Level [ high / middle / low ] # default : low client_message_secure_level = low FORCS Co., LTD 65

spmgr.properties multilogin sesiontimout Secure Level.. (user.multilogin 'false' ). Client, Server. high Server Servlet Server. Client Exception Name, Server middle. Server Servlet Server. Client, Server low. Server Servlet Server. srmngr.properties [Daemon/Servlet] {OZ_HOME}\conf\srmngr.propeties SDM SDM. srmngr.properties # default : false use_scheduled_data=true # The path that scheduled data modules are stored. # default : %OZ_HOME%/scheduled_data datamodule_path=%oz_home%/scheduled_data 66 FORCS Co., LTD

srmngr.properties use_scheduled_data datamodule_path SDM. dbtmpl.properties [Daemon/Servlet] {OZ_HOME}\conf\dbtmpl.propeties DBMS JDBC dbtmpl.properties #---------------------------------------------- # Configuration of #---------------------------------------------- # Last Modified : Fri Jan 14 16:56:23 GMT+09:00 2005 db2.driver = COM.ibm.db2.jdbc.net.DB2Driver informix.driver = com.informix.jdbc.ifxdriver mssql.driver = com.microsoft.jdbc.sqlserver.sqlserverdriver odbc.driver = sun.jdbc.odbc.jdbcodbcdriver oracle.driver = oracle.jdbc.driver.oracledriver sybase.driver = com.sybase.jdbc2.jdbc.sybdriver unisql.driver = unisql.jdbc.driver.unisqldriver dbtmpl.properties FORCS Co., LTD 67

db2.driver db2java.zip COM.ibm.db2.jdbc.net.DB2Driver informix.driver ifxjdbc.jar com.informix.jdbc.ifxdriver mssql.driver mssqlserver.jar com.microsoft.jdbc.sqlserver.sqlserverdriver odbc.driver rt.jar sun.jdbc.odbc.jdbcodbcdriver oracle.driver classes12.zip oracle.jdbc.driver.oracledriver sybase.driver jconn2.jar com.sybase.jdbc2.jdbc.sybdriver unisql.driver unisqljdbc10.jar unisql.jdbc.driver.unisqldriver sap.properties [Daemon/Servlet] {OZ_HOME}\conf\sap.propeties SAP. SAP Connection Pool, SAP Connection Pool. : SAP UI. sap.properties ### ### Configuraion of SAP Connection Manager ### ### TYPE1 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.sysno= ### TYPE2 68 FORCS Co., LTD

#<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.r3name= #<alias>.group= ### TYPE3 #<alias>.client= #<alias>.user= #<alias>.password= #<alias>.language= #<alias>.host= #<alias>.sysno= #<alias>.gwhost= #<alias>.gwserv= ### TYPE4 #<alias>.gwhost= #<alias>.gwserv= #<alias>.tpname= ### TYPE5 #<alias>.gwhost #<alias>.gwserv #<alias>.tpname #<alias>.tphost sap.properties <alias> <alias>.client <alias>.user <alias>.password <alias>.language <alias>.host <alias>.sysno <alias>.r3name <alias>.group SAP. SAP. SAP. SAP. SAP. SAP. SAP. SAP.. FORCS Co., LTD 69

<alias>.gwhost <alias>.gwserv <alias>.tpname <alias>.tphost SAP. SAP. JCO ID.. databind.properties [Daemon/Servlet] {OZ_HOME}\conf\databind.propeties. databind.properties # unit : byte, default : 4096 byte, min : 256 byte ConcurrentFetchSize=256 # unit : count, default : 0 ConcurrentFirstRow=0 databind.properties ConcurrentFetchSize FetchType "Concurrent" Stream. byte, 4096, 256. :,. 70 FORCS Co., LTD

ConcurrentFirstRow FetchType "Concurrent"., 0. : 0. FORCS Co., LTD 71

72 FORCS Co., LTD

FORCS Co., LTD 73

. (, ).... ( )... API. "API. API"... (, ), (, ),,,.. HTML. 74 FORCS Co., LTD

.,. (To:, Cc:, Bcc: ) SMTP.. Command Line GUI API 3 rd party API. FORCS Co., LTD 75

Enterprise Manager Shell Commander TCP/IP XLS Scheduler Server PDF SMTP User OZD Task Task Task Task Task OZ Server OZ Servlet OZ Server SDM 76 FORCS Co., LTD

OS MS Windows NT 4.0, 2000 Server, 2003 Server Java JRE(JAVA Runtime Environment) 1.3. bin InstallService.bat ozencrypted.bat OZService.exe ozservice_create.bat Profile.exe Service.bat ServiceManager.exe StartService.bat StopService.bat OZScheduler.ini UninstallService.bat user.cif NT Service ID NT Service,,, NT Service NT Service NONE FORCS Co., LTD 77

conf expand external lib OZUSLClientSession.jar OZUSLServerDES128.jar J2EE (HTTPS/SSL ) JRE 1.3.X USL license ozlicense.xml logs repository ScheduledTask TempRepository viewer ozcreport.dll ozcviewer.exe ozexcel.dll ozjpdf417.dll ozpdf.dll OZUSLClientDes128.dll OZUSLClientSession.dll exe 2 PDF USL 78 FORCS Co., LTD

res charters.xml ozlang.dll viewer_error_msg.xml viewer_server_error _msg.xml )charters_ko_kr.xml )ozland_ko_kr.dll )viewer_error_msg_ko_kr.xml )viewer_server_error_msg_ko_kr.xml scheduler.bat scheduler.bat. scheduler.bat @echo off rem ----------------------------------------------------- rem rem OZ Sscheduler Start-up File rem rem This batch file written and tested under Windows 2000 rem check your path indicate <JAVA_HOME>\bin rem rem ----------------------------------------------------- rem ----------------------------------- rem OZ Scheduler Home rem ----------------------------------- set OZSCHEDULER_HOME=..\ rem ----------------------------------- rem JDK Path rem ----------------------------------- set JAVA_HOME=..\..\jre\bin if not "%OZSCHEDULER_HOME%" == "" goto start FORCS Co., LTD 79

echo Unable to determine the value of OZSCHEDULER_HOME. goto eof :start set OZSchLib=%OZSCHEDULER_HOME%\lib\ozsfw35.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\conf rem ----------------------------------- rem Library for HTTPS/SSL rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jcert.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jnet.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jsse.jar rem ----------------------------------- rem Library for Logging rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\log4j.jar rem ----------------------------------- rem Library for XML Parsing rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\crimson.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\parser.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\xerces.jar rem ----------------------------------- rem Library for Mailing rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\mail.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\activation.jar rem ----------------------------------- rem USL Jar for USL rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\OZUSLClientSession.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\OZUSLServerDES128.jar echo Loading OZScheduler... %JAVA_HOME%\java -cp %OZSchLib% oz.scheduler.main.ozscheduler %1 %2 :eof 80 FORCS Co., LTD

commander.bat commander.bat commander. ". Shell Command". commander.bat @echo off rem ----------------------------------------------------- rem rem OZ Scheduler Commander Start-up File rem rem This batch file written and tested under Windows 2000 rem check your path indicate <JAVA_HOME>\bin rem rem ----------------------------------------------------- rem ----------------------------------- rem OZ Scheduler Home rem ----------------------------------- set OZSCHEDULER_HOME=..\ rem ----------------------------------- rem JDK Path rem ----------------------------------- set JAVA_HOME=..\..\jre\bin if not "%OZSCHEDULER_HOME%" == "" goto start echo Unable to determine the value of OZSCHEDULER_HOME. goto eof :start set OZSchLib=%OZSCHEDULER_HOME%\conf set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\ozsfw35.jar rem ----------------------------------- rem Library for HTTPS/SSL rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jcert.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jnet.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\jsse.jar rem ----------------------------------- rem Library for Logging rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\log4j.jar FORCS Co., LTD 81

rem ----------------------------------- rem Library for XML Parsing rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\crimson.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\parser.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\xerces.jar rem ----------------------------------- rem Library for Mailing rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\mail.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\activation.jar rem ----------------------------------- rem USL Jar for USL rem ----------------------------------- set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\OZUSLClientSession.jar set OZSchLib=%OZSchLib%;%OZSCHEDULER_HOME%\lib\OZUSLServerDES128.jar %JAVA_HOME%java -classpath %OZSchLib% oz.admin.shell.scheduler.command %1 %2 %3 %4 %5 %6 %7 %8 %9 ozscheduler.properties path.oz.scheduler.home=.. SchedulerPort=9521 path.scheduler.file=%sch_home%/conf/scheduler_server.properties path.scheduler.license=%sch_home%/license/ozlicense.xml path.scheduler_log.file=%sch_home%/conf/scheduler_server_log.properties path.oz.scheduler.home SchedulerPort path.scheduler.file path.scheduler.license path.scheduler_log.file (Default : 9521) scheduler_server.properties ### ### ozschedluer_server.properties Infomation ### Last Modified : Wed Sep 21 14:33:14 KST 2005 ### 82 FORCS Co., LTD

ErrorNotifyToSender=true LeaveDataModuleWhenExportingReport=false MailFrom= SMTPServer=127.0.0.1 SMTPServerPort=25 ViewType=ActiveX //ActiveX, Applet, Sun1.3, NONE SMTPUserID= SMTPUserPassword= SMTPUserID_encrypted= SMTPUserPassword_encrypted= ExternalProgramFilePath=%SCH_HOME%/External RepositoryFileRootPath=%SCH_HOME%/Repository/ SchedulingInfoFilePath=%SCH_HOME%/ScheduledTask TempRepositoryFilePath=%SCH_HOME%/TempRepository ### End. ErrorNotifyToSender LeaveDataModuleWhenEx portingreport MailFrom SMTPServer SMTPServerPort ViewType Value : true / false Default : false SDM (Default : false) SMTP SMTP :,. ActiveX ActiveX () Applet Applet Sun1.3 NONE Applet : "NONE", API, OZD. FORCS Co., LTD 83

SMTP SMTPUserID ID : SMTP. SMTP SMTPUserPassword ID : SMTP. SMTP ID SMTPUserID_encrypted : SMTP, ID ID ID. SMTP ID : SMTP SMTPUserPassword,. Export ExternalProgramFilePath RepositoryFileRootPath SchedulingInfoFilePath TempRepositoryFilePath (*.ozs) (Default : SchedulerHome/ScheduledTask) scheduler_server_log.properties #------------------------------------------- # configuraion of OZ logging system #------------------------------------------- # # Set Prioritylog level # 84 FORCS Co., LTD

# DEBUG, INFO, ERROR Priority=DEBUG # appender CONSOEL # Console. # # CONSOLE.Type=Stdout CONSOLE.Layout=%r [%t] %p %c{1} %x - %m%n CONSOLE.Async=true # # appender ROLLING_FILE # File. # MaxFileSize. # #. # MaxBackupIndex. # # Layout : # Append : # ImmediateFlush : # false # #. # ROLLING_FILE.Type=RollingFile ROLLING_FILE.Layout=%d{ISO8601} [%t] %-5p %c{1} %x - %m%n ROLLING_FILE.File=%SCH_HOME%/logs/OZSchedulerMainLog.log ROLLING_FILE.MaxBackupIndex=5 ROLLING_FILE.MaxFileSize=1MB ROLLING_FILE.ImmediateFlush=true # # appender NT Event # NT. # #NT_EVENT.Type=NTEvent #NT_EVENT.Layout=%r %p %c{1} - %m%n #NT_EVENT.Threshold=ERROR # # appender syslog # Unix syslog. # #SYSLOG.Type=Syslog #SYSLOG.Layout=[OZ] %r %p %c{1} - %m #SYSLOG.Threshold=ERROR FORCS Co., LTD 85

#SYSLOG.SyslogHost=127.0.0.1 #SYSLOG.Facility=USER #SYSLOG.FacilityPrinting=false # # appender Scheduler Task result log # File. ResultLog.MaxBackupIndex=3 ResultLog.MaxFileSize=500KB Remove_Param_File=true., ResultLog. ResultLog.MaxBackupInd ex ResultLog.MaxFileSize Backup....param. true : /.param. Remove_Param_File false :.param..param. Default : true ". log.properties".., 86 FORCS Co., LTD

.. JRE. commander.bat. Commander.bat ". Shell Command".. OZService.exe. Windows. JAVA Classpath. { }\bin\ozservice_create.bat OZScheduler.ini. OZScheduler.ini [JAVA] BIN=..\..\jre\bin\java.exe OPTION=-Xms128m -Xmx256m -cp ARGS=oz.scheduler.main.OZScheduler PATH=C:\Program Files\FORCS\OZ XStudio--\OZScheduler\bin [CLASS]..\lib\ozsfw35.jar;..\conf;..\lib\jcert.jar;..\lib\jnet.jar;..\lib\jsse.jar;..\lib\log4j.jar;..\lib\crimso n.jar;..\lib\parser.jar;..\lib\xerces.jar;..\lib\mail.jar;..\lib\activation.jar;..\lib\ozuslclients ession.jar;..\lib\ozuslserverdes128.jar FORCS Co., LTD 87

{ }\bin\installservice.bat { }\bin\uninstallservice.bat. InstallService.bat @echo off rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem %1 - ( ) rem %2 - rem - OZ OZService.exe. rem ---------------------------------------------------------------------- rem ServiceManager.exe %1 /i %2 %1 ServiceManager.exe OZScheduler /i "C:\Program Files\Forcs\OZ XStudio\Scheduler\bin\OZService.exe" rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem InstallService OZServer D:/OZSource/NTService/OZService.exe rem ---------------------------------------------------------------------- @echo off UninstallService.bat rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem %1 - ( ) rem ---------------------------------------------------------------------- rem ServiceManager.exe %1 /u ServiceManager.exe OZScheduler /u rem ---------------------------------------------------------------------- rem rem ---------------------------------------------------------------------- rem UninstallService OZServer rem ---------------------------------------------------------------------- { }\conf\ozscheduler.properties 88 FORCS Co., LTD

path.oz.server.home. { }\bin\installservice.bat. [] - [] - []. OZScheduler ( ). OZSchedule 'OZScheduler ' ' '. FORCS Co., LTD 89

OZScheduler ( ). { }\bin\uninstallservice.bat. 90 FORCS Co., LTD

FORCS Co., LTD 91

.,,,,,. OS MS Windows NT 4.0, 2000 Server, 2003 Server CPU Pentium 300MHz, Pentium 500MHz Main Memory 128MB, 256MB HDD 10MB 92 FORCS Co., LTD

. bin conf OZEnterpriseManager.exe OZOptWiz_vc71.dll OZUSLClientDes128.dll OZUSLClientSession.dll MultiLanguageList.xml em.dll em_error_msg res.xml server_error_msg.xml viewer_parameter.xml server.conf USL FORCS Co., LTD 93

[] [OZ XStudio] - [OZ Enterprise Manager 3.5].. 94 FORCS Co., LTD

FORCS Co., LTD 95

, (pull down).....,,. 96 FORCS Co., LTD

() [] -> [ ] ( ) ' ' [ ]. IP URL.. TCP, URL HTTP. TCP IP. TCP TCP. HTTP URL. URL. ) http://www.oz.com/ozservlet FORCS Co., LTD 97

' ' [] [ ] [ ]. [] ' '. '' '' []. '' ''. 98 FORCS Co., LTD

....,,. FORCS Co., LTD 99

. JVM... 100 FORCS Co., LTD

.. []. FORCS Co., LTD 101

REPOSITORY_TYPE REPOSITORY_DB_ALIAS REPOSITORY_FILE_PATH REPOSITORY_ITEM_ NUMBER_PER_PATH REPOSITORY_HISTORY_ ITEM_VALID_DAYS REPOSITORY_ADD_ COMPRESSED_ITEM REPOSITORY_QUERY_MAX BACKUPINDE REPOSITORY_QUERY_MAX FILESIZE REPOSITORY_QUERY_IMMI DIATEFLUSH.(Builtin, RDB, NONE) db.properties Alias DB Repository..... 'true'. Builtin DB. Builtin DB. Builtin DB. 'true'... 102 FORCS Co., LTD

. CACHE_FILE_PATH DM_CACHE_FILE_PATH... [] [].. FORCS Co., LTD 103

[ ] [] [ ]... 'true/false'.. (:).. 104 FORCS Co., LTD

[ ] ( ).,....... FORCS Co., LTD 105

... - datamodule.report.[categoryname].[itemname].[fetchmode]. [ParameterName_1 = ParameterValue_1]..... [ParameterName_n = ParameterValue_n]. [DataSetName_1 = MaxRow_1].....[DataSetName_n = MaxRow_n]. [InvalidSetName_1].....[InvalidSetName_n].. datamodule.report [CategoryName] [ItemName].... [FetchMode] [ParameterName_1 = 'DM_CONCURRENT_FETCH' 'DM_BATCH_FETCH'. ParameterValue_1]... [ParameterName_n = [ = ]. ParameterValue_n] [DataSetName_1 = MaxRow_1] [ = ] 106 FORCS Co., LTD

.... [DataSetName_n = MaxRow_n] [InvalidSetName_1], ' ' ''. 'test1.odi' 'test1.odi' (/) ' DM_BATCH_FETCH', '', '' '', '' ''. datamodule.report.[/].[test1.odi].[dm_batch_fetch].[=''].[ =2004].[=100].[=100][] datamodule.application.[categoryname].[itemname]. [DataSetName].[DataSetNumber].[FetchMode]. [ParameterName_1 = ParameterValue_1]..... [ParameterName_n = ParameterValue_n]. [DataSetName_1 = MaxRow_1].....[DataSetName_n = MaxRow_n]. [MasterDataSetParameterName_1 = MasterDataSetParameterValue_1]..... [MasterDataSetParameterName _n = MasterDataSetParameterValue _n]... datamodule.applicatio n [CategoryName] [ItemName] [DataSetName] [DataSetNumber]...., FORCS Co., LTD 107

[FetchMode] [ParameterName_1 =.. 'DM_CONCURRENT_FETCH' 'DM_BATCH_FETCH'. ParameterValue_1]... [ParameterName_n = [ = ]. ParameterValue_n] [DataSetName_1 = MaxRow_1]... [DataSetName_n = [ = ]. MaxRow_n] [MasterDataSetParam etername_1 = MasterDataSetParame tervalue_1]... [MasterDataSetParam etername_n = MasterDataSetParame [ = ]. -. tervalue_n] 'test1.odi', 'test1.odi' 'MasterDatail', 'DM_CONCURRENT_FETCH', '', '' 0, ' ' '', '' ''. datamodule.application.[/masterdetail].[test1.odi].[ ].[0].[DM_CONCURRENT_FETCH].[=2004].[=100].[ ='Silver'] 108 FORCS Co., LTD

cachemngr.properties.... DB. [].,. FORCS Co., LTD 109

[]. "[ ]". [ ] []. DB. 110 FORCS Co., LTD

, alias.. IP. JDBC. : thin (ODBC ODBC DSN) DBMS.( SID) DBMS DB.... FORCS Co., LTD 111

DB Connection. DB Connection. Maxconns Connection.(:) db.properties. URL,. 112 FORCS Co., LTD

URL JDBC. JDBC URL. JDBC connection property string. FORCS Co., LTD 113

. [ ] [ ]. [].. "databind.properties" "ConcurrentFetchSize" "ConcurrentFirstRow". 114 FORCS Co., LTD

.... []. " FORCS Co., LTD 115

log.properties". -.. []. [] ().,. 116 FORCS Co., LTD

-.. [ ]. []. FORCS Co., LTD 117

.. [ ]. <Shift> <Ctrl> []. 118 FORCS Co., LTD

[].. 1) "server.log", "server.log.1", "server.log.2" test [] "test.log", "test.log.1", "test.log.2". 2) "server.log", "server.log.1", "server.log.2" [] "server.log", "server.log.1", "server.log.2". [ ]. [ ]... FORCS Co., LTD 119

(F5).,. [] -> [ ] ' ' [ ] (. []. ' ' ( ). 120 FORCS Co., LTD

' ' ' '. ' ' '' []... []. FORCS Co., LTD 121

. ErrorNotifyToSender ExternalProgramFilePath MailFrom RepositoryFileRootPath SMTPServer SMTPServerPort SchedulerPort SchedulinginfoFilePath TempRepositoryFilePath ViewType... Export. SMTP IP. SMTP...... 122 FORCS Co., LTD

..,,,,. FORCS Co., LTD 123

..,. WAITING, PAUSE. OZReportFile.. 124 FORCS Co., LTD

[] [ ]. [ ] (' ' ' '). FORCS Co., LTD 125

[ ], Fetch, Client DM, Server DM. - 'fetch_type' 'concurrent' 'client_dm_type' 'normal', 'normal' 'memory'. - 'scheduler_server.properties' 'ViewType=NONE'. :.. (,, PDF, OZD ) 1.. [] $OZ.#D//#D$ $OZ ~ $ :. #D/ ~ /#D :. :. []. Date Format. 126 FORCS Co., LTD

:. +_n_day (n_day : ) FORCS Co., LTD 127

Date Format G Year designator (Text) AD y Year (Number) 1996 (Text July & 07 (locale. M Month in year Number) ) d day in month (Number) 10 h hour in am/pm (1~12) (Number) 12 H Hour in day (0~23) (Number) 0 m Minute in hour (Number) 30 s Second in minute (Number) 55 S Millisecond (Number) 978 E day in week (Text) Tuesday(locale, '') D day in year (Number) 189 F day of week in month (Number) 2 (2nd Wed in July) w Week in year (Number) 27 W Week in month (Number) 2 a am/pm marker (Text) PM k hour in day (1~24) (Number) 24 K hour in am/pm(0~11) (Number) 0 z Time zone (Text) Pacific Standard Time ' Escape for text (Delimiter) ' '' Single quote (Literal) " [Example] 2002102 : (FromDate, ToDate) ' ' FromDate=$OZ.#D/yyyyMMdd 00:00:00/#D$ ToDate=$OZ.#D/yyyyMMdd 23:59:59/#D$ FromDate=20021002 00:00:00 ToDate=20021002 23:59:59 128 FORCS Co., LTD

: ' ' $OZ.#D/yyyyMMdd/#D$.xls 20021002.xls : ' ' ReportName_$OZ.#D/yyyyMMdd/#D$.sdm ReportName_20021002.sdm : PDF 1 '' pdf $OZ.#D/yyyyMMdd/#D+1$.pdf 20021001.pdf 2. ' ' ' = '.. $OZ.#P_ :. $OZ.#EXF_USER :. $OZ.#EXF_XLS :. $OZ.#EXF_OZD : OZD. $OZ.#EXF_PDF : PDF. $OZ.#EXF_CSV : CSV. $OZ.#EXF_HTML : HTML. $OZ.#EXF_JPG : JPG. $OZ.#EXF_PPT : PPT. $OZ.#EXF_SVG : SVG. FORCS Co., LTD 129

$OZ.#EXF_TEXT : TEXT. $OZ.#EXF_TIFF : TIFF. $OZ.#EXF_WORD : WORD. ) : $OZ.#EXF_DM = MyData.sdm $OZ.#EXF_XLS = MyExcel.xls $OZ.#P_FromDate = 20021001 $OZ.#P_ToDate = 20021002. [ HTML ] PDF OZD, XLS Export HTML. [ ]. [HTML ] HTML. 130 FORCS Co., LTD

..... ( '31 ' ) (, ) (,, ) ) 1 5 20 1,5,20 FORCS Co., LTD 131

( ) ) AM 1 30, PM 5 10 01:30, 17:10 SDM. [ ]. [ ] (.sdm). ( ''''' ( )' sdm..../../ ). 132 FORCS Co., LTD

. ". ".. [] [],. FORCS Co., LTD 133

[ ]. [ ] []. [].. 134 FORCS Co., LTD

[]. [ ]. [ ] ( ). []... []. FORCS Co., LTD 135

[ ]. [ ] ( ). []. []...... []. 136 FORCS Co., LTD

-.. [] (). []. FORCS Co., LTD 137

. 138 FORCS Co., LTD

FORCS Co., LTD 139

.,.,. / /, (, ). /, 140 FORCS Co., LTD

OS MS Windows NT 4.0, 2000 Server, 2003 Server CPU Pentium 300MHz, Pentium 500MHz Main Memory 128MB, 25MB HDD 10MB FORCS Co., LTD 141

. OZRepositoryManager.exe OZRepositoryManager.ini OZUSLClientDes128.dll OZUSLClientSession.dll USL MultiLanguageList.xml bin rm.dll res rm_error_msg. xml server_error_msg. xml 142 FORCS Co., LTD

[] [OZ XStudio] - [OZ Repository Manager 3.5].. FORCS Co., LTD 143

/ / / (pull down).... / /,. []. 144 FORCS Co., LTD

[File]. (Ctrl+R). (Ctrl+E). (Ctrl+F).... FORCS Co., LTD 145

/ /. / /..... 146 FORCS Co., LTD

... /, /.,. (Alt+0). (Alt+1),. (Alt+2). FORCS Co., LTD 147

,,.. [].. 148 FORCS Co., LTD

[] [ ] ( ). IP URL. TCP, URL HTTP. TCP IP. TCP TCP. HTTP URL. URL. FORCS Co., LTD 149

.. ' ' []. [] [ ] ( ). 150 FORCS Co., LTD

.., C:\Program Files\FORCS\OZ Product\OZ RepositoryManager. C:\Program Files\FORCS\ OZ Product\Repository. ' ' [] [ ] ( ) ' ' [ ]. [] [ ] ( ) ' ' [ ]. FORCS Co., LTD 151

,. Admin, " (/)". " (/)" [ ] ( ).. (:Company). 152 FORCS Co., LTD

[] ( ). 'admin'. [] ( ) ''. FORCS Co., LTD 153

'', 'admin' Admin. [ ] ( ). 154 FORCS Co., LTD

..... ' ' []. [] ( ). FORCS Co., LTD 155

'admin', Admin(Group Admin). [ ] (. ) ( ). 'user1'. 'admin'. [ ] ( ) 156 FORCS Co., LTD

.. [ ]. '' []. FORCS Co., LTD 157

[ ] ( ).. 'admin' Admin,, Admin, 'admin'. /,. 158 FORCS Co., LTD

,,. [ ] ( ). 'admin'. ' ' [ ]. FORCS Co., LTD 159

. ' ' ' ' &. [ ] ( ). ' '.. 160 FORCS Co., LTD

' ' [ ]. ' '. [] [ ]. ' '. [] ( ). FORCS Co., LTD 161

' '........ [] 162 FORCS Co., LTD

.,. 'admin'. [] ( ). ' '.. 'admin'.. [] FORCS Co., LTD 163

( )..,...... []. ' '. 164 FORCS Co., LTD

[] []. ' '.. [] ( ). []. [ ]. FORCS Co., LTD 165

[] []. ' '. [] ( ) ''.. ' ' ' ' 'admin' 166 FORCS Co., LTD

. [] ( ) ''... ' ' ' ' 'admin'. FORCS Co., LTD 167

()..,. /.... '' ' ',... 168 FORCS Co., LTD

[] ( ). ' '....... [] ( ). FORCS Co., LTD 169

. [] ( ). ' '.. 170 FORCS Co., LTD

.... [] ( ).. FORCS Co., LTD 171

.. [] ( ). ' '..... 172 FORCS Co., LTD

. []. [] ( ). ' '.. FORCS Co., LTD 173

.... [].. 174 FORCS Co., LTD

. [ ] ( ). ' '..... [ ]. FORCS Co., LTD 175

. [ ] ( ). ' '..... [ ]. 176 FORCS Co., LTD

. [ ] (. ).( ''.).( '' ). ( '' ) FORCS Co., LTD 177

/. [] ( ). / / /. / /. []. /. 178 FORCS Co., LTD

/.,,,. /,,,... /. [] ' '. / [], //. FORCS Co., LTD 179