untitled

Size: px

Start display at page:

Download "untitled"

せとかかやぬま
4 years ago
Views:

1 IBM i 2010 IBM i Power Systems Revision 3.0

2 IBM IBM IBM IBM IBM IBM IBM AIX International Business Machines Corporation AIX 5L International Business Machines Corporation AIX 6 International Business Machines Corporation AIX 7 International Business Machines Corporation IBM International Business Machines Corporation UNIX The Open Group PowerPC International Business Machines Corporation POWER4 International Business Machines Corporation POWER5 International Business Machines Corporation POWER6 International Business Machines Corporation POWER7 International Business Machines Corporation IBM System International Business Machines Corporation IBM eserver International Business Machines Corporation Power Systems International Business Machines Corporation pseries International Business Machines Corporation BladeCenter International Business Machines Corporation IBM i5/os International Business Machines Corporation Intel, Pentium Intel Corporation Linux Linus Torvalds Copyright International Business Machines Corporation All rights reserved. 2

3 (rev. 1.0) (rev. 2.0) V2 (rev 3.0) IBM i Open Application Server 3

4 1. OSS IBM i 2. Zend Server Community Edition for IBM i 3. Zend Server Community Edition IBM i IBMiDB2_API i5 MYSQL 4. OSS XOOPS Cube Legacy SugarCRM(CE) 5. IBM i OSS 4

5 . (OSS) IBM i 1. IBM i IBM i AIX Zend PHP 5. Zend Server 6. OSS IBM i PowerSystems 7. RPG PHP 5

6 1-1. IBM i 7.1 DB2 XML Open Access for RPG RPG Zend Server AIX SSD Solid State Drives SSD PowerHA IBM i 7.1 IBM i 6.1 Systems Director IBM i 6

7 1-2. IBM i AIX 1 TB = = AIX IBM i AIX TL TL6 V5R4 5.3 TL3 V5R3 5.2 TL0,

8 1-3. LAMP Web IBM i LAMP Linux IBM i OS Apache Web MySQL DB 11M PHP 6.4M 20M IBM i AIX Apache 2 PHP 5.2 MySQL PASE PASE() - AIX IBM i. DB2/400 IBM i RPG / COBOL DB2 for i Power Systems IBM i SLIC 8

com Zend Platform Zend Studio for i Eclispe Rational

9 1-4. Zend PHP Zend Server Community Edition(CE) for i IBM i 7.1, 6.1, 5.4 zend.com Zend Core Zend Server for i zend.com Zend Platform Zend Studio for i Eclispe Rational Developer for Power OS Apache FastCGI Apache IBM i RSTLICPGM 9

10 IBM i PHP Zend Server Community Edition for i Zend Core IBM i 7.1, 6.1, 5.4 Zend US zend.com Zend Server for i Zend Platform Zend Server Community Edition zend.com Zend IBM i SWMA 6 OSS 10

11 1-5. Zend Server Zend Core Zend Server Community Edition Zend Core Zend Server CE Native installation Certified PHP DB2 Drivers Bundled MySQL DB & Drivers + Web-based administrator Debugger interface + Bytecode acceleration Zend Framework IBM i Toolkit Caching API Java connector Performance via Fast CGI Software updates & hot fixes Technical support Zend Platform Zend Server Zend Platform Zend Server Native installation Certified PHP DB2 Drivers Bundled MySQL DB & Drivers + Web-based administrator Debugger interface + Bytecode acceleration + Zend Framework IBM i Toolkit 5250 Bridge Caching API + Java connector Application monitoring + Performance via Fast CGI Page Caching Code tracing Job Queue + Software updates & hot fixes Technical support IBM i 11

12 1-6. OSS IBM i PowerSystems OSS+Power Systems (IBM i) IBM i (i5/os) / OSS TIMI DB2 for i Web Java IBM Power Systems Java 64bit RISC POWER OS * OS OS :$3,130 OSS+IA / OSS Web * NW WINDOWS H/W S/W :$10, *IDC Paper: The Business Value of IBM System i in Mid-Sized Business Deployments, July 2007 ** IBM White paper IBM System i IBM IT

13 1-7. RPG PHP System i Network RPG Java RPG PHP RPG PHP RPG PSSR Monitor / On-Error Array SugarCRM MediaWiki Zend PHP IBM i 13

14 2. Zend Server Community Edition for IBM i Zend Server CE for IBM i Version Windows Installer 3. PHP Zend Server 6. MySQL Zend ServerMySQL 14

15 2-1. IBM i LAN 1399 IBM i QSECOFR ( QSECOFR( ) QCCSID 1399 MKDIR DIR( /usr/local ) /usr/local IBM i OS 7.1 PTF Portable App Solutions Environment QSHELL IBM HTTP SERVER FOR I IBM Portable Utilities for i OpenSSH, OpenSSL, zlib *BASE *BASE SS1 5770SS1 5770DG1 5733SC1 5733SC1 *COMPATIBLE *COMPATIBLE *COMPATIBLE *INSTALLED *INSTALLED V7R1M0 V7R1M0 V7R1M0 V7R1M0 V7R1M0 IBM iwindows PC Web (Internet Explorer Firefox ) IBM i TCP/IP Windows PC TCP/IP 15

16 2-2. Zend Server CE for IBM i Zend Server CE for IBM i Zend ( Sign in Login REGISTER Create a new accountregister Registration Finish Zend ( Downloads Downloads Zend Server Community Edition Download Zend Server CE Downloads Zend Server CE for IBM i download page Zend Server CE for IBM i DownloadsZend Server 16

17 2-3. PHP ZendServer PHP5.3-IBM-i-Windows-Installation.zip setup.exe IBM i Welcome IBM i IP ID(QSECOFR) 17

18 2-4. ( ) ENDTCPSVR SERVER(*HTTP) HTTPSVR(ZENDSVR) Zend Server Apache EDTF STMF( /www/zendsvr/conf/fastcgi.conf ) Server SetEnv= CCSID=819 SetEnv= LANG=en_US ( ) EDTF STMF( /usr/local/zendsvr/etc/php.ini ) 510 default_charset default_charset = UTF- 8 1 STRTCPSVR SERVER(*HTTP) HTTPSVR(ZENDSVR) Apache Zend Server GO ZENDSVR/ZSMENU 5. Service Management menu Zend Server for IBM i Service Menu 2. Stop Zend Server Subsystem 1. Start Zend Server Subsystem 18

19 2-5 Zend Server Zend Server i IP):10088/ZendServer Welcome Welcome Zend Server Dashboard 2http://(IBM i IP):10088/ZendServer Zend Server 19

20 2-6 MySQL MySQL CHGJOB CCSID(37) GO ZENDSVR/ZSMENU 6. MySQL Management menu MySQL MySQL EDTF STMF( /usr/local/mysql/bin/my.cnf ) default-character-set=utf8 skip-character-set-client-handshake 2 CHGAUT OBJ( /usr/local/mysql/bin/my.cnf ) USER(*PUBLIC) DTAAUT(*RX) MySQL ENDSBS SBS(ZMYSQL) STRSBS SBSD(ZMYSQL/ZMYSQL) MySQL 20

21 3. Zend Server Community Edition IBM 1. IBM i 2. MySQL 21

22 3-1. IBM i Zend PHP Zend Server Community Edition for i PHP PHP IBM i CALL CALL php RPG DB2 DB2/400 (DTAARA) (DTAQ) (MSGQ) DB2 API DB2 for i * Zend Core for i * 22

23 3-2. MySQL DB2 for i IBMDB2I MySQL DB2 for i MySQL DB2 for i MySQL CREATE TABLE ALTER TABLE MyISAM InnoDB Memory MySQL Cluster Other IBMDB2I (DB2 for i) NEW 23

24 3-2-1.MySQL DB2 for i IBM i MYSQL IBM i RPG/COBOL /CLP PHP DB2 for i DB2i MySQL IBM i Windows Linux PC IBM i PASE MySQL on IBM i Windows Linux DB2 MySQL DB2 for i IBM i DB2 for i IBM i (CL RPG DB2 SQL ) IBM i OSS 24

25 MyISAM InnoDB IBMDB2I Read/Write - -DB2 for i - -Read, DB2 IBM i IFS IFS IBM i 25

3-2-3.IBM i IBMDB2I IBM i IBM i 5.4 PTF IBMDB2IPTF PTF (APARII14442) IBMWeb http://www- 912.ibm.

26 3-2-3.IBM i IBMDB2I IBM i IBM i 5.4 PTF IBMDB2IPTF PTF (APARII14442) IBMWeb ibm.com/n_dir/nas4apar.NSF/b6c9b771e38b5ea c00079d110/67d e e2003c6d4a?OpenDocument 26

27 3-2-4.MySQLIBMDB2I MySQL 1. call qp2term PASE 2. cd /QOpenSys/usr/local/mysql/mysql MySQL 3. bin/mysql u root MySQL 4. MySQL install plugin ibmdb2i soname ha_ibmdb2i.so ; show plugins; 27

28 3-2-5.IBMDB2I IBMDB2I create table TABLE001 (COL1 char(20), COL2 int) engine=ibmdb2i ; IBMDB2I IBMDB2I MySQL my.cnf /etc/my.cnf # Created at installation. [mysqld] datadir = /QOpenSys/usr/local/mysql/data user = MYSQL default_storage_engine = ibmdb2i CREATE TABLEengine= 28

29 3-2-6.MySQL CRTLF CREATE INDEX IBM i CRTPF CREATE TABLE IBM i / LF / PF IBM i IBMDB2I MySQL on IBM i MySQL CREATE TABLE CREATE INDEX MySQL IBM i MySQL DB2 MySQL 29

30 3-2-7.IBM i IBM i MySQL IBM i MySQL MySQL RNMOBJ RENAME CHGPF ALTER TABLE IFS DBCS UTF-16 DBCS IBM i UTF-16 (CCSID 1200) UTF-16 ILE RPGRPG/400(OPM) 30

31 IBM i create table db1.sales (orderno int) engine=ibmdb2i; db1 sales IBM i DSPFFD FILE( db2mysql / tbl1 ) MySQL /QOpenSys my.cnf datadir = /QOpenSys/usr/local/mysql/data /QOpenSys MySQL IBM i 31

32 . OSS 1. XOOPS Cube Legacy IBM i 2. SugarCRM(CE) 5.2 -IBM i 32

33 4-1. XOOPS Cube Legacy IBM i XOOPS Cube Legacy ( ) 3. XOOPS URL 33

34 Zend Server Community Edition (CE) for IBM i Zend Server Zend Server Community Edition (CE) for IBM i PHP5.2 Zend Server CE MySQL IBM i QSECOFR ( ) Windows PC 5250 ( ) QSECOFR 5250 ( ) 1399( ) CFGTCP 12. TCP/IP CHGTCPDMN IBM i CFGTCP 10. TCP/IP ADDTCPHTE IBM i ( [bar] FQDN[ foo.bar.com] ) PC (Windows) IBM i IP IBM iwindows PC Web (Internet Explorer Firefox ) 34

35 XOOPS Cube Legacy XOOPS Cube Legacy XOOPS Cube ( sourceforge Package_Legacy_2_1_8.zip 35

36 XOOPS (1/3) XOOPS Cube Legacy ( Package_Legacy_2_1_8.zip) IBM i /www/zendsvr/htdocs/ FTP 5250QSECOFR ( ) CALL PGM(QP2TERM) cd /usr/local jar xvf Package_Legacy_2_1_8.zip cd Package_Legacy cp -r./html /www/zendsvr/htdocs/cube cp -r./extras/extra_languages/ja_utf8/html/* /www/zendsvr/htdocs/cube MySQL XOOPS ( xoops xoopsdb xoops ) 5250QSECOFR ( ) CALL PGM(QP2TERM) cd /usr/local/mysql bin/mysql create database xoopsdb; grant all on xoopsdb.* to 'xoops'@'localhost' identified by 'xoops'; quit; 36 MySQL 5250EDTF STMF( /usr/local/mysql/bin/my.cnf ) sql-mode=no_auto_value_on_zero (1 ) (;) EDTF ENDSBS SBS(ZMYSQL) STRSBS SBSD(ZMYSQL/ZMYSQL) MySQL

37 XOOPS (2/3) i ):10088/cube/install/index.php ja_utf8 URL URL XOOPS Cube 2 37

38 XOOPS (3/3) XOOPS Cube ID 5250QSECOFR ( ) CALL PGM(QP2TERM) rm -r /www/zendsvr/htdocs/cube/install XOOPS i ):10088/cube/ XOOPS /www/zendsvr/htdocs/cube/mainfile.php 5250QSECOFR ( ) CALL PGM(QP2SHELL) PARM( /QOpenSys/bin/chmod 644 /www/zendsvr/htdocs/cube/mainfile.php ) F5 (GMT+9:00) 38

39 4-2 SugarCRM (CE) 5.2 -IBM i SugarCRM SugarCRM / SugarCE 5.2.0k 3. SugarCRM 4. SugarCRM URL 39

40 Zend Server Community Edition (CE) for IBM i Zend Server Zend Server Community Edition (CE) for IBM i PHP5.2 SugarCRM Community Edition (CE) 5.2 PHP 5.2 ( ) Zend Server CE MySQL IBM i QSECOFR ( ) Windows PC 5250 ( ) QSECOFR 5250 ( ) 1399( ) PC (Windows) IBM i IP IBM iwindows PC Web (Internet Explorer Firefox ) 40

41 SugarCRM(SugarCE) SugarCE SugarCRM ( DOWNLOAD SugarCE 5.2.0k 41

42 SugarCE (1/4) PHP i IP):10088/ZendServer SugarCE Server Setup Directives Resource Limits memory_limit 128M( ) Server Setup Extensions ON( ) 5250QSECOFR ( ) EDTF STMF( /usr/local/zendsvr/etc/php.ini ) 600 upload_max_filesize = 2M ; 1 upload_max_filesize = 20M 1241 [mbstring] [FrontBase] (1284) mbstring.language = Japanese mbstring.internal_encoding = UTF-8 mbstring.http_input = auto mbstring.http_output = pass mbstring.detect_order = auto mbstring.substitute_character = none 42

43 SugarCE (2/4) MySQL Sugar 5.0 sugarcrmuser sugarcrmdb QSECOFR ( ) CALL PGM(QP2TERM) 1. cd /usr/local/mysql 2. bin/mysql 3. CREATE DATABASE `sugarcrmdb` DEFAULT CHARACTER SET utf8; 4. GRANT ALL PRIVILEGES ON sugarcrmdb.* TO sugarcrmuser@localhost 5. IDENTIFIED BY '11111'; 6. quit; SugarCE ( SugarCE-Full-5.2.0k-Ja.zip) IBM i /www/zendsvr/htdocs/ FTP 5250QSECOFR ( ) CALL PGM(QP2TERM) Chmod 1. cd /www/zendsvr/htdocs 2. jar xvf SugarCE-Full-5.2.0k-Ja.zip 3. find./sugarce-full-5.2.0k-ja -type d -exec chmod 775 {} ; 4. cd SugarCE-Full-5.2.0k-Ja 5. chmod 777 config.php 6. chmod 777 config_override.php 7. chmod -R 777 cache/* cache 8. chmod -R 777 custom/* custom 9. chmod -R 777 data/* data 10.chmod -R 777 modules/* modulesmkdir./tmp 11.chmod 777 tmp 43

44 SugarCE (3/4) SugarCE 5250QSECOFR ( ) EDTF STMF( /www/zendsvr/htdocs/sugarce-full-5.2.0k-ja/index.php ) 3 ini_set( session.save_path, /www/zendsvr/htdocs/sugarce-full-5.2.0k-ja/tmp/ ); EDTF STMF('/www/zendsvr/htdocs/SugarCE-Full-5.2.0k-Ja/install.php') Apache URL 5250QSECOFR ( ) EDTF STMF( /www/zendsvr/conf/httpd.conf ) <Directory /www/zendsvr/htdocs/sugarce- Full-5.2.0k-Ja> Options FollowSymLinks Order deny,allow Allow from all </Directory> <Location /Sugar> Order deny,allow Allow from all </Location> 44 Alias /Sugar /www/zendsvr/htdocs/sugarce-full-5.2.0k-

45 SugarCE (4/4) Apache/PHP/MySQL 5250QSECOFR ( ) Apache/PHP/MySQL ENDTCPSVR SERVER(*HTTP) HTTPSVR(ZENDSVR) ENDSBS SBS(ZENDSVR) OPTION(*IMMED) ENDSBS SBS(ZMYSQL) OPTION(*IMMED) GO MENU(ZENDSVR/ZSMENU) Zend Server for IBM i Setup Menu 5. Service Management menu 1. Start Zend Server Subsystem 5. Start Apache server instances ( ) 3. Work with Zend Server subsystems Zend QHTTPSVR (Apache HTTP) F12=Cancel 6. MySQL Management menu 1. Start MySQL subsystem F3 2 WRKACTJOB QHTTPSVRZENDSVR ZENDSVRI5_COMD ZS* ZMYSQLZMYSQLD 45

46 SugarCE i IP):10088/Sugar/ ( ) MySQL SugarCRMID (admin) ( ) 10. Sugar 5.2.0k SugarCE SugarCE admin SugarCE Asia/Tokyo (GMT+9) Sugar IBM i SugarCE SugarCE 46

47 IBM i OSS 47

48 IBM i Open Application Server (OSS) (IPA) 22 4 OSS OSS OSS Web 50% OSS OSS OSS10% 15% 22% IDC 09/7/ % -OSS 48

49 IBM i Open Application Server (OSS) (IPA) 22 4 OSS 49 OSS

50 OSS 50 IA

51 IBM i Open Application Server 14 CPU 1 CPU Model 720 Model 520 4U TCO OSS Model 710 2U 14 CPU I/O - OS -Zend PHP IBM

52 IBM STSS OSS IBM Zend Server IBM SWMA Zend Server STSS Zend Server SWMA Zend Server CE 3 MySQL DB2 ISE * * IBM i Open Application Server IBM i IBM SWMA IBM-US New IBM STSS Zend Server Zend New IBM 52

53 OS (i OS e-commerce: oscommerce EC-Cube CRM: Sugar CRM CMS: XOOPS ordpress PukiWiki phpmyadmin PHP / JAVA / C / C++ /Perl / Ruby /COBOL/RPG.CL My SQL Websphere ApplicationServer HTTP :Apache IBM i Power Systems IBM-STSS IBM SWMA

(STSS) 24 365 1. 24 365 2. 3. / DB 4. 5. 6. 7.

54 (STSS) / DB H/W H/W iseries/pseries/xseries/zseries, *1 *1 H/W S/W (SWMA,PA) Support Line PA,SWMA 54

55 OSS IBM i Zend Server Community Edition(CE) for IBM i SugarCRM Community Edition(CE) 5.1 IBM i XOOPS Cube Legacy 2.1 IBM i MYSQL for IBM i

untitled

untitled OSS IBM i IBM i OSS - TCOOSS - ERP: Compiere e-commerce: oscommerce CRM: Sugar CRM CMS: XOOPS BI: Pentaho My SQL PASE PHP / JAVA / perl / Ruby IFS Tomcat IBM i POWER Apache DB2 Websphere Application Server