untitled

Transcription

1 FORCS Co., LTD 1

2 2 FORCS Co., LTD

3 FORCS Co., LTD 3

4 4 FORCS Co., LTD

5 FORCS Co., LTD 5

6 ..,, FORCS Co., LTD

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

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

9 FORCS Co., LTD 9

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

11 . (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

12 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

13 Windows FORCS Co., LTD 13

14 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

15 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. 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

16 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

17 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

18 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

19 # 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

20 # #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

21 # # 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

22 . UNIX Windows. Windows JRE SUN JRE 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

23 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

24 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

25 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

26 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

27 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

28 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. 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

29 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

30 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 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 off UninstallService.bat rem rem rem FORCS Co., LTD

31 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

32 OZServer [ ]. 32 FORCS Co., LTD

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

34 34 FORCS Co., LTD

35 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

36 .,. 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

37 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

38 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

39 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

40 #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

41 # 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= #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

42 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

43 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

44 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

45 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

46 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} ] [ :39:29,777 ] main INFO ozserver OZServer... [Example] [ %d{iso8601} ] [ :39:29,777 ]main INFO ozserver OZServer... log message OZServer event event. ) %d{iso8601} [%t] %5p %c{1} %x%m :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 :56:23,203[Handler 1] INFO MessageHandler millisecond event. [Example] [%r] [2994] main INFO oz.server OZServer... Thread event. [Example] [%t] [Thread2] INFO oz.server Received a message %. [Example] %% 46 FORCS Co., LTD

47 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" AD at 18:25:30 PDT "EEE, MMM d, "yy" Wed, July 10, '96 "h:mm a" 12:08 PM FORCS Co., LTD 47

48 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

49 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

50 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= 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= 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

51 MSSQL Server mssql_example.vendor=mssql mssql_example.serveraddress= 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= 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= 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

52 unisql unisql_example.vendor=unisql unisql_example.serveraddress= 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= 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

53 # # 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: ### CACHE_FILE_PATH = %OZ_HOME%/cache/ CACHE_DM_FILE_PATH = %OZ_HOME%/dm_cache/ FORCS Co., LTD 53

54 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

55 FORCS Co., LTD 55

56 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

57 .. 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 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 Millisecond (long), (int) alias.sessionquery = "[DB Query]" <infomix> SELECT DBINFO(\"sessionid\") FROM SysTables WHERE TabID = 1 <mssql> FORCS Co., LTD 57

58 select <oracle> SELECT sid FROM V$SESSION WHERE audsid = userenv('sessionid') <sybase> // 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

59 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

60 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

61 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

62 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

63 #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

64 #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

65 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

66 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

67 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: 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

68 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

69 #<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

70 <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

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

72 72 FORCS Co., LTD

73 FORCS Co., LTD 73

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

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

76 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

77 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

78 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

79 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. 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

80 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

81 commander.bat commander.bat commander. ". Shell Command". 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

82 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

83 ErrorNotifyToSender=true LeaveDataModuleWhenExportingReport=false MailFrom= SMTPServer= 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

84 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

85 # 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

86 #SYSLOG.SyslogHost= #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

87 .. 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

88 { }\bin\installservice.bat { }\bin\uninstallservice.bat. 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 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

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

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

91 FORCS Co., LTD 91

92 .,,,,,. 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

93 . 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

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

95 FORCS Co., LTD 95

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

97 () [] -> [ ] ( ) ' ' [ ]. IP URL.. TCP, URL HTTP. TCP IP. TCP TCP. HTTP URL. URL. ) FORCS Co., LTD 97

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

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

100 . JVM FORCS Co., LTD

101 .. []. FORCS Co., LTD 101

102 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' FORCS Co., LTD

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

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

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

106 ... - 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

107 .... [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

108 [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

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

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

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

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

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

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

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

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

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

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

119 [].. 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

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

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

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

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

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

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

126 [ ], 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

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

128 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] : (FromDate, ToDate) ' ' FromDate=$OZ.#D/yyyyMMdd 00:00:00/#D$ ToDate=$OZ.#D/yyyyMMdd 23:59:59/#D$ FromDate= :00:00 ToDate= :59: FORCS Co., LTD

129 : ' ' $OZ.#D/yyyyMMdd/#D$.xls xls : ' ' ReportName_$OZ.#D/yyyyMMdd/#D$.sdm ReportName_ sdm : PDF 1 '' pdf $OZ.#D/yyyyMMdd/#D+1$.pdf 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

130 $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 = $OZ.#P_ToDate = [ HTML ] PDF OZD, XLS Export HTML. [ ]. [HTML ] HTML. 130 FORCS Co., LTD

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

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

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

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

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

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

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

138 . 138 FORCS Co., LTD

139 FORCS Co., LTD 139

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

141 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

142 . 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

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

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

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

146 / /. / / FORCS Co., LTD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

162 ' ' [] 162 FORCS Co., LTD

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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