Running Oracle for z/Linux as a Running Oracle for z/Linux as a Sysplex Guest Under z/OSSysplex Guest Under z/OS

Alexander Shmid, Doctor, Professor

EC-leasing Head of the Board of Directors,IIS, LLC CTO

www.ec-leasing.ruwww.iis-service.com

www.gs-s.com

17 April 2007

IIS

IISЕС- ЕС- GroupGroup is a System Integrator for Major is a System Integrator for Major Corporate CustomersCorporate Customers

Basic activity –to decrease Total Cost of Ownership (TCO) for corporate customers via architecture consolidation

TCO decreaseEC-leasing

EC-engineering

EC-leasing soft

EC-group in Russia

in USAGlobal System Services (GSS)

Interpretive Information Systems (IIS)

IBM BP in Russia, USA, Germany ORACLE BP in Russia

www.ec-leasing.ru

www.iis-service.comwww.gs-s.com

IIS

UNIX Servers Consolidation

Thin Clients Linux, Windows

Clients

Intel Servers

Intel Servers Consolidation

Functions Transfer to UNIX Servers

Functions Transfer to Intel Servers orUNIX-Servers

Linux – Bridge between UNIX

& Intel Servers

Client Unloading

3

Target ArchitectureTarget Architecture(Centralized with Virtualization, “Thin Clients”)(Centralized with Virtualization, “Thin Clients”)

zSeries pSerie

sxSeriesTivoli

Websphere WBI

MBRationalBDW

Data Stage

Static Resource Allocation,UNIX Workload

Enterprise ServersDynamic Resource Allocation,

Windows + Linux Workload

Dynamic Resource Allocation, zOS USS + Linux Workload

IISFrom any ORACLE to zSeries From any ORACLE to zSeries Oracle’s Consolidation IssuesOracle’s Consolidation Issues

BEFORE

AFTER78 centers

234 boxes

2 centers

4 boxes

zOS ORACLE

zLinux ORACLE

BOX OS DBMSHP HP-UX Oracle 8.1.7

pSeries AIX Oracle 8.1.7

SUN Solaris Oracle 9.2

DEC VMS Oracle 9.2

Intel Windows Oracle 10.2

Intel Linux Oracle 10.2

NCR NCR Unix Oracle 7

IISSome Problems to Port Oracle Some Problems to Port Oracle Applications to zOSApplications to zOS

zOSOracle 9.2

zLinuxOracle 10.2

DBMS Restrictions:∆zOS vs. zLinux

Unsupported in zOS Features & Functions:

IEEE Standard Floating Point Number Restrictions

Native compilation of Java or PL/SQLOracle External TablesOracle SchedulerOracle Streams (DBMS_FILE_TRANSFER

package not supported)Oracle Utilities (trace, dbnewid not supported)XML Database (WebDAV, HTTP, FTP access

not supported)

Generic Connectivity using ODBCOracle Data MiningOracle Dynamic Services ServerOracle HTTP ServerOracle Messaging GatewayOracle Real Application Cluster GuardOracle JSPOracle WorkflowOracle Workspace Manager

With problems

No problems

ORACLE 10.2 – Target 3Q2007

IISFunctional and Security Issues to Functional and Security Issues to Compare on zSeriesCompare on zSeries

FunctionalzOS – zLinuxOracle Functional Difference

List

SecurityzOS – zLinuxSecurity Difference List

Features zOS zLinuxAvailability from 8 hours to 5 minutes per year outages

Yes No

Disaster recovery: distance more than 1000 km, recovery time less than 15 minutes

Yes No

to zOSto zLinuxPORTABILITY, MAINTAINABILITY

SECURITY

DBMS Features zOS Oracle zLinux Oracle

IEEE Standard FP Number Restrictions - +Native compilation of Java or PL/SQL Agent - +Oracle External Tables - +Oracle Scheduler - +Oracle Streams -

(DBMS_FILE_TRANSFER)+

Oracle Utilities -(trace, dbnewid)

+

XML Database - (WebDAV, HTTP, FTP)

+

IISSolution with New Topology and Solution with New Topology and zLinux Image StatuszLinux Image Status

zOS zLinux 1 … zLinux n

LPAR 1 LPAR 2 … LPAR n

L 1 … L n  

VM zOS

LPAR 1 LPAR 2

Linux

Linux

Linux

Linux

Linux

Linux

zOS

(Virtual machines in zOS for execution of any guest systemUS patent № US 6,530,078 B1, DATE March 2003) Topology:

zLinux image- external to zOS

zLinux image – internal to

zOS(TASK)

I II

III

I II

Status: zLinux –zSeries image

zLinux -VM GUEST

zLinux –zOS TASK

I

II

III

zLinux 1 … zLinux n

zOS

Computer or LPAR

III

IISFrom z/OS to Oracle for z/LinuxFrom z/OS to Oracle for z/Linux

Mainframe

z/OS

zISX

z/Linux

OracleOracle client

SSHclient

Tn3270 client

ISX –Interpretive Space Executive

ISX creates zVirtual machine on zOS task level

IISUsing zOS Features for zLinux Using zOS Features for zLinux VirtualizationVirtualization

zLinux Feature / Status

ISX Feature / Status

zOS Feature

Console 3215 /Yes V 3215 / Yes zOS Console

ECKD DASD / Yes VECKD / Yes VSAM File

Tape / Yes V Tape / Yes VSAM File

CTC / Yes V CTC / Yes address space to address space

Printer / Yes V Printer / Yes Sysout

Ethernet / YesToken ring / Yes

V Ethernet / YesV TRN / Yes

address space to address space

IISGeneral Structure of SolutionGeneral Structure of Solution

TCP/IP

zOS DASDS VSAMs zLinux VDASDS

VSAMs zLinux VDASDS zOS DASDS

zOS local zOS remote

PPRC/XRC

Oracle

Oracle

zLinux

ISX A1 An... A1Oracle

Oracle

zLinux

ISX A1 An...

TCP/IP

Other Uses for zISXOther Uses for zISX

Mainframe

z/OS

zISX zISX zISX zISX

z/Linux z/OS VSE DPPX

Oracle IMS CICS LegacyApp

Multiple instances of ISX can be used run multiple systems which can exploit full

function and power of zOS

ISX –Interpretive Space Executive

INTERNET

Demo InvitationDemo InvitationIIS

с

Oracle

z/Linux

ISX

z/OS z/OS IP: 212.83.9.44

z/Linux IP: 212.83.9.22 Workstation

zLinux under zOS demo is at : http://www.ec-leasing.ru/lang/en/solutions.htmlGeneral Information: www.ec-leasing.ru, www.iis-service.com, www.gs-s.comFor assistance in the US, contact : manglin@gs-s.com (Monte Anglin)