This chapter describes features, which are specific to Oracle Database for BS2000/OSD SQ Server:
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.
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:
|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 SQ Server, but only in the slower
|Synonyms: "/390 edition of Oracle/BS2000"|
|Oracle for BS2000/x86-64:||BS2000 line of Oracle, which runs in native x86-64 mode in the BS2000 partition of the SQ Server.
This Oracle line cannot run in the Linux or Windows partition of the SQ Server.
This Oracle line cannot run on /390 CPU's.
"SQ edition of Oracle/BS2000"
"Oracle for SQ series"
"Oracle for Fujitsu BS2000/OSD (SQ series)"
"Oracle for SQ Server line"
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.
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
The following table lists the software requirements:
|Operating System||OSD/XC V4.1 or higher
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:|
|CCOBOL2000 V1.5 and higher|
|CPP as of V3.1|
|openUTM||openUTM V6.0 and higher|
|CRTE||CRTE V2.8 and higher|
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.
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
SUPER, or manually.
There are no differences to the /390 edition of Oracle for BS2000.
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:
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.
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).