15 Oracle on SQ Server

15.1 Concepts

The SQ server line is a line of BS2000/OSD business servers, which are based on x86-64 architecture. Oracle Database 11g supports this innovative line of SQ servers, for example, SQ200, and the BS2000 operating system OSD/XC.

Oracle Database 11g Release 2 for SQ Server runs in native x86-64 mode in the BS2000 partition of the SQ 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 SQ 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 x86-64 mode for the SQ Server line.

15.2 Definitions

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

15.3 Product Set

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

15.4 Hardware Requirements

• SQ Server, for example SQ200

• Main memory: at least 1024 MB

• Disk Space: Total static Oracle Database non-database requirements are approximately 2500 MB in the BS2000 file system and a minimum of 400 MB in the POSIX file system.

  The staging library for the installation requires about 2500 MB in the BS2000 file system.

• Database Space: No difference to /390 edition of Oracle

15.5 Software Requirements

The following table lists the software requirements:

15.6 Address Space Limit

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

15.7 Installing Oracle Database Software

Refer to Chapter 3, " Oracle Database Installation and Deinstallation".

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

15.9 Upgrade and Migration

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

15.10 Administration

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

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

15.11 Oracle application programs

Oracle for SQ 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 SQ Servers only in /390 mode.

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

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

15.12 openUTM Product Set

The openUTM product set of Oracle Database 11g Release 2 (11.2) for SQ Server requires openUTM V6.0 and higher.

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 BS2000/OSD ).