| Oracle® Database Release Notes 10g Release 2 (10.2) for IBM z/OS (OS/390) Part Number B25389-01 |
|
| View PDF |
| Oracle® Database Release Notes 10g Release 2 (10.2) for IBM z/OS (OS/390) Part Number B25389-01 |
|
| View PDF |
Release Notes
10g Release 2 (10.2) for IBM z/OS (OS/390)
B25389-01
April 2006
This document contains important information that was not included in the platform-specific or product-specific documentation for this release. Unless stated otherwise, the information in this document applies equally to z/OS, and z/OS.e.
It contains the following topics:
This document may be updated after release. To check for updates to this document and to view other product-specific release notes, see the Documentation section on the OTN Web site:
http://oracle.com/technology/documentation
For additional information about this release, go to the Install CD-ROM, open the file welcome.html, and click the ReadMe tab. This provides access to the readme files.
The following sections contain updates to the Oracle Database 10g documentation:
The Text Telephone (TTY) phone number for non-technical support is listed incorrectly in several documents. The correct phone number is 1.800.464.2330.
This release of Oracle10g for IBM z/OS (OS/390) does not include support for the following features and functions. Existing customers should also consult Oracle10g Enterprise Edition System Administration Guide for z/OS for unsupported features or functions that should be taken into consideration during a migration or upgrade.
Automated Storage Manager
Cross Platform Transportable Tablespaces
Generic Connectivity using ODBC
HTML_DB
Oracle Data Mining
Oracle Dynamic Services Server
Oracle HTTP Server
Oracle Internet Directory
Oracle Messaging Gateway
Oracle Real Application Cluster Guard
Oracle Java Server Pages
Oracle Personalization
Oracle Ultra Search
Oracle Workflow
Oracle Workspace Manager
The following is a list of known restrictions to this release of Oracle Database on IBM z/OS:
Non-repudiation of Advance Queuing messages sent across a firewall using Internet Document Access Protocol (IDAP) is not supported in this release.
Oracle database files on IBM z/OS are implemented as VSAM linear data sets. IBM does not provide a space release function for VSAM data sets, so using ALTER DATABASE...RESIZE to make a database file smaller has no effect. Database files can be resized larger, both manually (with ALTER) and automatically as they fill (when a tablespace is defined with AUTOEXTEND).
No support is available currently for automatically recalling IBM z/OS data sets that are used by the Oracle server if they have been migrated to other media by IBM's DFSMShsm, or a similar product. This applies to the VSAM linear data sets (LDS) comprising the database, and to non-VSAM data sets such as parameter files. All such data sets must be on disk in their original form at the time that they are opened by the server.
To use 10g Release 2 (10.2) Client with a C program, you must complete the following steps:
Ensure that the C for z/OS V1R2 compiler is installed, instead of or addition to the C for OS390 V2R10.
Recompile all OCI programs using the C for z/OS V1R2 compiler with the ENUM(INT) option.
Note:
Refer to z/OS V1R2.0 C/C++ Compiler and Run-Time Migration Guide for additional information about this issue.The following is a list of restrictions that apply to the IEEE standard floating point numbers:
The new BINARY_DOUBLE and BINARY_FLOAT database data types are not supported for client applications running on z/OS.
This restriction applies to both customer-written applications and Oracle tools and utilities on z/OS. Attempts to store or fetch these types from a client program running on z/OS will produce unpredictable results with both local and remote Oracle10g servers.
Use of z/Architecture Binary Floating Point (BFP, also known as IEEE 754 floating point) in Oracle applications running on z/OS is not supported.
This restriction means that customer-written Oracle applications cannot bind or define host variables that are BFP types in an Oracle SQL statement. This restriction also affects tools and utilities: both SQL*Loader and the server External Table feature cannot load file data that is BFP.
Traditional System/370 floating point data (now known as Hexadecimal Floating Point or HFP) remain supported, as in the past.
The following java methods are not supported with the JavaVM:
java.lang.Runtime.exec()
java.lang.System.load()
java.lang.System.loadLibrary()
java.lang.System.mapLibraryName()
java.nio.channels.
Native compilation of Java or PL/SQL programs is not supported.
The following sections contain issues that affect Oracle Enterprise Manager Intelligent Agent:
Oracle10g Database for IBM z/OS supports only a minimal set of system statistics and these may not reflect the actual performance of the system.
Configuration of the Agent must be done manually. The Oracle Enterprise Manager Configuration Assistant is not supported with this release.
Oracle10g Database for IBM z/OS (OS/390) supports database startup and shutdown from the console. Before you can use this feature, the OSDI rdbms and net subsystem must be active.
Oracle10g Database for IBM z/OS (OS/390) does not support the iSQL*Plus interface from the console.
Currently, Oracle10g Database for IBM z/OS (OS/390) only ships with the Oracle Enterprise Manager Agent. Oracle Enterprise Manager Grid Control Console is not supported, though this release does support a remote Oracle Enterprise Manager Grid Control Console. This is because the repository for this console must not reside on a z/OS platform.
External Tables is an Oracle feature that allows you to process non-Oracle operating system files as Oracle database tables. On IBM z/OS, the External Tables feature is limited to accessing files in the HFS and zFS file systems.
Oracle JDBC OCI drivers are supported for a limited subset of features. When you use a feature that is not supported, an error is returned with a message displayed to state that the feature is not supported. The Database character set needs to be WE8EBCDIC1047 or similar.
The following sections contain issues affecting Oracle OLAP:
Dynamically linking options into the Oracle kernel as part of the Oracle Universal Installer installation is not supported in this release. If you choose the OLAP optional feature, then after the Oracle Universal Installer installation is complete, you must complete the following task manually to link the required code into Oracle:
Set your $ORACLE_HOME and $ORACLE_HLQ_PDS.
Do this by running the ENV file in your ORACLE_HOME location. For example:
cd $ORACLE_HOME/server/rdbms make -f ins_rdbms.mk olap_on make -f ins_rdbms.mk ioracle
A backup copy of the oracle executable is kept automatically in $ORACLE_HOME/server/rdbms/bin. It is named oracleO.
(Optional) Allocate a temporary AUTHLOAD to hold the new Oracle executable.
The final stage of the relink make attempts to copy the new Oracle executable into your AUTHLOAD, provided the link is successful. To allocate a temporary AUTHLOAD:
Allocate your new AUTHLOAD, using the same attributes as the current AUTHLOAD
Set the ORACLE_HLQ_PDS environment variable to point to this new HLQ.
Refer to the Oracle OLAP documentation to run the OLAP installation scripts.
At a minimum, you will need to run the script $ORACLE_HOME/olap/admin/olap.sql.
If you use ARCHIVE mode with Oracle Real Application Clusters (RAC), then you must either set the LOG_ARCHIVE_FORMAT/DEST values, or make sure that each instance within the Oracle Real Application Clusters cluster is in a separate subsystem and uses the same OSDI service name for each instance. Failure to do so will cause database recovery to fail, due to an inability to find archive log files.
For Oracle Security Server, an Oracle10g server or client on IBM z/OS cannot be a participant in an Oracle security connection. However, an Oracle database server on IBM z/OS can be the security repository.
The following configuration assistants for Oracle Universal Installer are not supported:
Database Configuration Assistant (dbca)
Enterprise Manager Configuration Assistant (emca)
The utilities Oracle Trace and dbnewid are not available.
Additional utilities are also not available with this release. For a complete list of unavailable utilities, refer to the documents Oracle Database Installation Guide for IBM z/OS (OS/390), and Oracle Database System Administration Guide for IBM z/OS (OS/390).
The following parts of the XML Developers Kit are not supported:
XML Class Generator for Java and C++
Propagation from object queues with BFILEs is not supported in Oracle Database 10g.
If you upgrade an Oracle9i database to Oracle Database 10g release 1, Oracle Flashback features using a timestamp may fail. To work around this problem, enter the following SQL script from the Oracle Database 10g database:
SQL> DELETE FROM smon_scn_time WHERE orig_thread <> 0; SQL> COMMIT;
This issue is tracked with Oracle bug 3994270.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
TTY Access to Oracle Support Services
Oracle provides dedicated Text Telephone (TTY) access to Oracle Support Services within the United States of America 24 hours a day, seven days a week. For TTY support, call 800.446.2398.
Oracle Database Release Notes, 10g Release 2 (10.2) for IBM z/OS (OS/390)
B25389-01
Copyright © 1996, 2006, Oracle. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited.
The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose.
If the Programs are delivered to the United States Government or anyone licensing or using the Programs on behalf of the United States Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software—Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs.
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
The Programs may provide links to Web sites and access to content, products, and services from third parties. Oracle is not responsible for the availability of, or any content provided on, third-party Web sites. You bear all risks associated with the use of such content. If you choose to purchase any products or services from a third party, the relationship is directly between you and the third party. Oracle is not responsible for: (a) the quality of third-party products or services; or (b) fulfilling any of the terms of the agreement with the third party, including delivery of products or services and warranty obligations related to purchased products or services. Oracle is not responsible for any loss or damage of any sort that you may incur from dealing with any third party.
