16 Oracle on SX Server

This chapter describes features, which are specific to Oracle Database for BS2000/OSD SX Server:

Concepts
Definitions
Product Set
Hardware Requirements
Software Requirements
Address Space Limit
Installing Oracle Database Software
Database Creation
Upgrade and Migration
Administration
Oracle application programs
openUTM Product Set

Concepts

The SX server line is a line of BS2000/OSD business servers, which are based on SPARC64 architecture. Oracle Database 10g supports this innovative line of SX servers, for example, SX150, and the BS2000 operating system OSD/XC.

Oracle Database 10g release 2 (10.2.0.2.25) for SX Server runs in native SPARC mode in the BS2000 partition of the SX Server. Programs running in this mode provide much better performance than programs running in /390 mode (= compatibility mode).

There are no differences in handling and administration compared to the "conventional" Oracle for BS2000 (on /390 systems). So the migration from conventional Oracle for BS2000 to Oracle for SX Server is very simple.

All products you know from the /390 edition of Oracle, for example, Oracle Net Services, SQL*Plus, Precompilers, are available in native SPARC mode for the SX Server line.

Definitions

Because there are two Oracle editions for BS2000, that is, one for the /390 series and one for the SX series, the following definitions are introduced to avoid confusion:

Oracle edition	Meaning
Oracle for BS2000/390:	BS2000 line of Oracle, which is running on systems with /390 CPU's (S Servers). This Oracle line can also run on SX Server, but only in the slower `/390` mode, also called compatibility mode.
	Synonyms: "/390 edition of Oracle/BS2000"
Oracle for BS2000/SPARC:	BS2000 line of Oracle, which runs in native SPARC mode in the BS2000 partition of the SX Server. This Oracle line can't run in the Solaris partition of the SX Server. This Oracle line cannot run on /390 CPU's.
	Synonyms: "SPARC edition of Oracle/BS2000" "Oracle for SX series" "Oracle for Fujitsu Siemens BS2000/OSD (SX series)" "Oracle for SX Server line"

Product Set

All products, which are available with the /390 edition of Oracle/BS2000 are also available with the SPARC edition. There are no differences in functionality between the products of these two Oracle/BS2000 editions.

The release number of the SPARC edition of Oracle Database 10g release 2 for BS2000/OSD is 10.2.0.2.25.

This Oracle Database release 10.2.0.2.25 is the Oracle Database software for the Oracle platform "Fujitsu Siemens BS2000/OSD (SX series)".

Hardware Requirements

SX Server, for example SX150
Main memory: at least 512 MB
Disk Space: Total static Oracle Database non-database requirements are approximately 700000 PAM pages. Dynamic requirements, such as SQL files, host language programs, and output spool files, depend on Oracle Database usage.
Database Space: No difference to /390 edition of Oracle

Software Requirements

The following table lists the software requirements:

Component	Requirement
Operating System	OSD/XC V1.2 as of correction package 2/2006 OSD/XC V2.1 as of correction package 2/2006 OSD/XC V3.0 Note that the BS2000/OSD subsystem POSIX should have been started.
Compilers	Though not required to run the Oracle Database, if high-level languages, such as C or COBOL, are used to interface to the Oracle Database, then the following compilers are supported:
	COBOL85 V2.3
	COBOL2000 as of V1.2
	CPP as of V3.1
openUTM	openUTM V5.3
CRTE	CRTE V2.5 as of correction package 2/2006
	CRTE V2.6 and higher

Address Space Limit

A user's address space should not be less than 512MB. Oracle recommends loading the SPARC version of BS2000 DSSM "CRTE-BASYS" (= CRTEBASP) to reduce memory requirements.

Installing Oracle Database Software

Refer to Chapter 3, " Installing Oracle Database Software".

Database Creation

The creation of a database works exactly as described in Chapter 4, " Creating and Upgrading a Database". You may create a database automatically, by BS2000 procedure INSTALL.P.SUPER, or manually.

There are no differences to the /390 edition of Oracle for BS2000.

Upgrade and Migration

Refer to Chapter 4, " Creating and Upgrading a Database".

Administration

There are almost no differences in administration compared to the /390 edition of Oracle Database. The only difference is that Oracle on SX server does not support executables ("phases"), but only LLMs. Therefore, you must start Oracle programs like SQLPLUS as follows:

/START-PROGRAM *MODULE($ORAC1020.ORALOAD.LIB,SQLPLUS,A,A)

Oracle application programs

Oracle for SX Server supports the same programming languages for Oracle application programs as the /390 edition of Oracle. There are Precompilers for C/C++ and Cobol.

Oracle application programs can run on SX Servers only in /390 mode.

Application programs have to be linked as described in the Oracle Database User's Guide for Fujitsu Siemens BS2000/OSD.

Application programs, which have been developed on /390 systems can run on SX Servers without any changes.

openUTM Product Set

The openUTM product set of Oracle 10.2 for SX Server requires openUTM V5.3.

There are no differences in developing Oracle Database/openUTM applications in comparison with the /390 edition of Oracle (refer to chapter "Using the Oracle Database under openUTM" in the Oracle Database User's Guide for Fujitsu Siemens BS2000/OSD ).