<HTML>
<HEAD>
<META content="text/html; charset=iso-8859-2" http-equiv=Content-Type>
<META content="OPENWEBMAIL" name=GENERATOR>
</HEAD>
<BODY bgColor=#ffffff>
<font size="2">
<br />
<b>---------- Forwarded Message
-----------</b>
<br />
From: "Oracle OpenVMS Engineering" <replies@oracle-mail.com>
<br />
To: fodor31@gamma.ttk.pte.hu
<br />
Sent: 17 May 2017 12:07:36 -0400
<br />
Subject: Oracle Database on OpenVMS and Oracle Rdb May, 2017 Newsletter
<br />
<br />
<div align="center"><font color="#333333" face="Arial, Helvetica, sans-serif" size="1"><a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=213970&elqTrackId=4d737c1bb9604c9baf0113a812379b8b&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank" style="color: rgb(31, 79, 130);"><u>View</u></a> this message in a Web
browser</font></div>
<table width="614" border="0" cellspacing="0" cellpadding="0" align="center">
<tbody>
<tr>
<td style="border-width: 1px; border-style: solid; border-color: rgb(192, 192, 192);" valign="top" align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td valign="top" align="left" bgcolor="#FF0000" style="padding-left: 21px;"><a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=1446&elqTrackId=2d7a5c7b36a3456e96b604ccdb8e1236&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><img src="http://www.oracleimg.com/us/dm/oralce-white-1947910.gif" alt="Oracle
Corporation" width="123" height="30" border="0" /></a></td>
</tr>
<tr>
</tr>
<tr>
<td valign="top" align="left" style="padding-left: 20px; padding-right: 20px;">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51); padding-right: 20px; padding-top: 20px;" valign="top" align="left">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td align="right" style="font-family: Arial, Helvetica, sans-serif; font-size: 12px; color: rgb(51, 51, 51);">May,
2017
<br />
<br /></td>
</tr>
</tbody>
</table>
Dear
Customers,
<br />
<br />
I am writing to tell you some news of interest to Oracle
customers running on the OpenVMS platform. In this update, we have information
covering the 2017 Oracle Database on OpenVMS and Oracle Rdb Technical Forums,
product shipments so far this year, certifications, and Oracle Rdb Training.
<br />
<br />
<b>Forum News: <font color="#FF0000">Save the
Date!</font></b>
<br />
<br />
The 2017 Forums schedule has been posted online. The dates and
locations
are:
<br />
<br />
<b>September 28-29, Nashua, NH,
USA
<br />
October 9-10, Stockholm,
Sweden
<br />
October 12-13, Vienna,
Austria
<br />
October 16-17, London, United
Kingdom
<br />
October 19-20, Paris,
France
<br />
October 23-24, Utrecht,
Netherlands
<br />
November 8-9, Redwood Shores, CA,
USA
<br />
December 4-5, Sydney, Australia
</b>
<br />
<br />
Remote attendance for all Forums will be available for those
who can't join us in
person.
<br />
<br />
For more information
see:
<br />
<a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=19053&elqTrackId=972726200b0c4c70b8ae8303c650584a&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>http://www.oracle.com/technetwork/database/database-technologies/rdb/community/index-101986.html</u></font></a>
<br />
<br />
When registration opens for these events you will register
from this same
link.
<br />
<br />
<b>Recent
Releases:
<br />
<br />
Oracle 11.2.0.4 Patch Set Updates (DB
PSU)
<br />
<br />
11.2.0.4.170418DBPSU</b>
<br />
<br />
PSU 11.2.0.4.161018 (*) was released in April, 2017. This is
the 7th PSU we have released since shipping 11.2.0.4 on OpenVMS July, 2015.
PSU's are cumulative. Newer ones supersede older ones. In addition to security
enhancements, new fixes were made in the areas of Advanced Queuing, Enterprise
Manager, Oracle Multimedia, SQL*Plus and XML
Database.
<br />
<br />
To download the PSU from My Oracle Support (MOS, <a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=20830&elqTrackId=09898ab464e6478893611e5e91dd8ef8&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>https://support.oracle.com</u></font></a>) search for patch
id 24732075
<br />
<br />
(*) As of November 2015, the version numbering for new Patch
Set Updates, and Security Patch Updates for Oracle Database has a new format.
This new format replaces the numeric 5th digit of the bundle version with a
release date in the form YYMMDD:
<br />
<br />
<b>Oracle Rdb
7.3.2.1</b>
<br />
<br />
Oracle Rdb 7.3.2.1 shipped in March, 2017. This release
includes new product features as well as fixes for a variety of problems. More
specifically, problems fixed include corrections for wrong results, poor
performance, access violations, hangs, RMU/CONVERT, SQL errors, statistics
collection and after image journaling to name a few.
<br />
<br />
The new features include: <font style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">
<ul>
<li>Certification on OpenVMS 8.4â2 from VMS Software Inc.
and Integrity i4 systems from
HPE</li>
<li>Support for an RMU/SHOW AFTER_JOURNAL [NO]CHECKPOINT
Qualifier</li>
<li>Remote Engine Error
Logging</li>
<li>MEDIAN Aggregate Function added to
SQL</li>
<li>New RMU/BACKUP/AFTER_JOURNAL [NO]SPACE_CHECK
Qualifier</li>
<li>New Options to SET SQLDA
Statement</li>
<li>New RMU Set Statistics
Command</li>
<li>Multi−Aggregate Index
Optimization</li>
<li>Support for the Old DPB Format when using ALTER
DATABASE</li>
<li>LogMiner State Now in AIJ Options
File</li>
<li>New RDM$LOGMINER_STATE
Symbol</li>
<li>New /[NO]MBX_ASYNCH Qualifier for
RMU/UNLOAD/AFTER</li>
<li>New /PAGE_NUMBER Qualifier for RMU/DUMP and
RMU/DUMP/BACKUP</li>
<li>New Information Table
RDB$SESSION_PRIVILEGES</li>
</ul>
</font> A full description of all the enhancements made in
this release and the problems fixed can be found in the release notes. We are
also now in the process of incorporating details on these new features into the
SQL Reference and RMU Reference
manuals.
<br />
<br />
You can download the kit from My Oracle Support under patch
numbers 25682708 for the Itanium kit and 25682686 for the Alpha
kit.
<br />
<br />
<b>Oracle Rdb 7.3.2.0 Update
4</b>
<br />
<br />
Also in March, a special image kit for Oracle Rdb Release
7.3.2.0, Update 4, was made available on My Oracle Support under the patch set
numbers 25800744 (Itanium) and 25800717
(Alpha).
<br />
<br />
This Update 4 kit fixed a problem where the distribution of
List of Byte Varying (Blob) data across partitioned storage areas was
incorrectly favoring the first storage area. More specifically, the FILL
RANDOMLY clause of the LIST storage map would not distribute LIST OF BYTE
VARYING columns
uniformly.
<br />
<br />
Full details along with the details on other problems fixed in
this kit from the prior three 7.3.2.0 update kits are shown in the release
notes.
<br />
<br />
<b>Oracle SQL/Services and OCI Services for Oracle Rdb Release
7.3.2.3</b>
<br />
<br />
Oracle SQL/Services and OCI Services for Oracle Rdb release
7.3.2.3 was shipped in March. In this version, enhancements were made to the
SQL Services Client Kit and to OCI Services. Bug fixes were also made for OCI
Services.
<br />
<br />
In the SQL/Services Client Kit, the SQLSRV$DYNAMIC sample
application was enhanced to prompt users to specify an alternative port number
when TCP/IP is specified as the network transport. A value of 0 (the default)
specifies that the default SQL/Services dispatcher port of 118 will be used.
Otherwise, the value specifies the alternate port number to be
used.
<br />
<br />
In OCI Services, two new features were added: <font style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">
<ul>
<li>A new information table has been added to Oracle Rdb.
RDB$SESSION_PRIVILEGES holds privilege information for the current user’s
session and can be added by a database administrator by executing the
INFO_TABLES.SQL script as described in the Oracle Rdb documentation. Once
created in the database OCI Services will add a new data dictionary table
SESSION_PRIVS that references this new table. A query on the SESSION_PRIVS table
from an Oracle OCI application, such as SQL Developer, now returns the
user’s current set of
privileges.</li>
<li style="margin-top: 7px;">Oracle Rdb now more closely
emulates the Oracle Database when naming computed columns. Thanks to a new SET
SQLDA command in Rdb 7.3.2.1, Rdb can now specify to OCI Services the name of
the column mapped as closely as possible to the names generated by the Oracle
Database.
</li>
</ul>
</font> A number of OCI Services bug fixes were also made in
this kit. These included problems with incorrect values sometimes stored in Date
columns, an improper update across a dblink, improper execution of certain
Select statements, wrong value insertions and a timestamp format
issue.
<br />
<br />
The Oracle SQL/Services and OCI Services for Oracle Rdb kit is
available on My Oracle Support under patch numbers 25690890 for OpenVMS Itanium
and 25690878 for OpenVMS
Alpha.
<br />
<br />
The 7.3.2.3 Oracle SQL/Services Client APIs kits are available
on MyOracleSupport as patchset numbers 25690909 (HP-UX 64-bit), 25690917 (Linux
32-bit), 25690927 (Linux 64-bit), 25690929 (Microsoft Windows 32-bit) and
25690939 (Microsoft Windows
64-bit).
<br />
<br />
Details on all the above kits are available in their
corresponding release
notes.
<br />
<br />
<b>Oracle ODBC Driver for Rdb
3.3.2.5</b>
<br />
<br />
The Oracle ODBC Driver for Rdb 3.3.2.5 was released in March.
This is a maintenance release that fixes invalid results returned under certain
circumstances: <font style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">
<ul>
<li>Memory allocation failures and invalid results returned
if API call includes the "REMARKS"
column</li>
<li>Incorrect value returned for
SQLGetInfo(SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2)</li>
<li>SQLGetDiagField (SQL_DIAG_CURSOR_ROW_COUNT) now returns
SQL_SUCCESS with a value of -1 instead of
SQLError</li>
<li>SQLGetDiagField no longer returns -100 on record
0</li>
<li>SQLGetDiagField now returns a 64 bit result as needed
for SQL_DIAG_CURSOR_ROW_COUNT and
SQL_DIAG_ROW_COUNT</li>
</ul>
</font> The Oracle ODBC Driver for Rdb 3.3.2.5 kit can be
downloaded from My Oracle Support: Patch 25829812 (32-bit) and Patch 25829827
(64-bit).
<br />
<br />
<b>Oracle JDBC for Rdb Release 7.3.4.2 - In Beta
Test</b>
<br />
<br />
This version of Oracle JDBC for Rdb was developed to work with
Java 8 which is now available for production use from HPE (see <a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=214139&elqTrackId=09a6b89254ab42c7ab44fc860b4696d3&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>https://www.hpe.com/global/java/download/ivms/1.8.0/jdk8.0_down.html</u></font></a>
). We are in the later stages of beta testing now. If you are interested in
testing Oracle JDBC for Rdb Release 7.3.4.2 with Java 8 please contact us at <a href="mailto:infordb_us@oracle.com"><font color="#1f4f82"><u>infordb_us@oracle.com</u></font></a>.
<br />
<br />
<b>Oracle Rdb Connectivity Manager (ORCM) 7.3.2 â In Beta
Test</b>
<br />
<br />
Oracle Rdb Connectivity Manager (ORCM) is a graphical user
interface (GUI) that provides a server management utility from any platform
where Java is available, to manage SQL/Services and JDBC servers running on
OpenVMS server systems. This latest version of the ORCM brings a suite of new
features, including: <font style="font-family: Arial, Helvetica, sans-serif; line-height: 20px;">
<ul>
<li>a new RMU Menu
category</li>
<li>the ability to display RMU Statistics from the
tool</li>
<li>a fast and easy way to identify differences between
database
schemas</li>
<li>external tool
enhancements</li>
</ul>
</font> If you are interested in testing these new
capabilities please contact us at <a href="mailto:infordb_us@oracle.com"><font color="#1f4f82"><u>infordb_us@oracle.com</u></font></a>.
<br />
<br />
<b>Certifications:</b>
<br />
<br />
<b>Oracle
Database:</b>
<br />
<br />
Oracle Database 11.2.0.4 and 10.2.0.5 on Itanium were
certified in March on the VMS Software Inc (VSI) OpenVMS 8.4-2L1 release on
Intel Itanium i2 and i4 Integrity servers. The certification is listed on My
Oracle Support on the ‘hp Itanium OpenVMS Certification Matrix’ (Doc
ID 377470.1)
page.
<br />
<br />
<b>Oracle
Rdb:</b>
<br />
<br />
Oracle Rdb 7.3.1.3 and 7.3.2.0 were certified in March on
OpenVMS 8.4-2L1 on Intel Itanium i2 and i4 Integrity servers. The same versions
were also certified on the VSI’s Alpha version of 8.4-2L1 which shipped
for production use in February. Look for the latest Oracle Rdb certification
updates on the My Oracle Support article entitled ‘RDBPROD: Comprehensive
Rdb Versions and Compatibility Matrix’ (MOS Doc ID
66729.1).
<br />
<br />
<b>Oracle CODASYL
DBMS:</b>
<br />
<br />
Oracle CODASYL DBMS 7.3.1.0 was certified in April on OpenVMS
8.4-2L1 on Intel Itanium i2, i4 Integrity servers and Alpha. Look for the latest
Oracle CODASYL DBMS certification updates on the My Oracle Support article
entitled ‘RDBPROD: Comprehensive CODASYL DBMS Versions and Compatibility
Matrix’ (MOS Doc ID
66767.1).
<br />
<br />
<b>Oracle Message
Queue:</b>
<br />
<br />
<b>Oracle Message Queue (OMQ) V5</b> has been certified on
OpenVMS 8.4-2 from VSI. To see the full list of OMQ versions certified on
OpenVMS go to <a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=213969&elqTrackId=29ed72383c694b5bb973a15aba807d10&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>http://docs.oracle.com/cd/E17973_01/platforms/mqplatforms/mqplats/mqplats.html#wp1087062</u></font></a>
<br />
<br />
<b>Oracle Rdb
Training:</b>
<br />
<br />
Oracle Rdb training is provided by our training partner JCC
Consulting. For an overview of the training offered, go to <a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=92675&elqTrackId=03d37a187e4f468b927a61ac6e9f9565&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>http://jcc.com/services/training</u></font></a>. Courses can
be customized for delivery at customer sites or other public venues. The course
schedule is established based on expressed needs and all courses are given by
experienced seminar leaders who are also experts on the topics. To indicate your
needs, please go to <a href="http://app.response.oracle-mail.com/e/er?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&s=1973398186&lid=92676&elqTrackId=a3c1956988c446fa9a2980bf6eef1993&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1" target="_blank"><font color="#1f4f82"><u>http://jcc.com/seminar-request</u></font></a> and/or talk
with JCC speakers at the
Forums.
<br />
<br />
<b>Questions?</b>
<br />
<br />
If you have any product questions, please contact Oracle
Support or send us an email at <a href="mailto:infordb_us@oracle.com"><font color="#1f4f82"><u>infordb_us@oracle.com</u></font></a>.
<br />
<br />
Best
Regards,
<br />
Kevin
Duffy
<br />
Senior Director, Software
Development
<br />
Oracle Database on
OpenVMS
<br />
Oracle Rdb
Engineering
<br />
<br />
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table width="614" border="0" align="center" cellpadding="0" cellspacing="0">
<tbody>
</tbody>
</table>
<table align="center" border="0" cellpadding="0" cellspacing="0" class="ftr-devicewidth" width="614">
<tbody>
<tr>
<td>
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td align="left" class="rs-ftr-lr" style="padding: 30px 20px;" valign="top">
<table border="0" cellpadding="0" cellspacing="0" class="rs-ftr" width="100%">
<tbody>
<tr>
<td align="center" valign="top"><a class="tmpLink" href="http://www.oracle.com/us/corporate/index.html?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&elqTrackId=3f9ee5e2f9f84c04b94e96c0024c93fe&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1&elqCampaignId=58086" target="_blank"><img alt="Integrated Cloud Applications and Platform Services" border="0" class="rs-ftr-logo" height="40" src="http://www.oracleimg.com/us/dm/o-corp-tagline-1-line-3112743.png" style="display: block;" width="350" /></a></td>
</tr>
<tr>
<td align="center" class="line-sp" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: rgb(31, 79, 130); word-break: break-all;"><a href="https://www.oracle.com/us/legal/privacy/index.html?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&elqTrackId=c156e512f85b45dfb0e3f974e8f12786&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1&elqCampaignId=58086" style="font-family: Arial, Helvetica, sans-serif; color: rgb(31, 79, 130); text-decoration: none; word-break: break-all; white-space: nowrap;" target="_blank">Terms of Use and Privacy</a> <span style="color: rgb(102, 102, 102);">|</span> <a href="https://oracle.ethicspointvp.com/custom/oracle/dp/en/form_data.asp?elq_mid=78914&sh=18618262112231291524123113&cmid=DEVT160708P00021&elqTrackId=da5e716ae6604da0ab2340745d60fb7e&elq=cb68fab9a18742a9bcf6f90733fb0d27&elqaid=78914&elqat=1&elqCampaignId=58086" style="font-family: Arial, Helvetica, sans-serif; color: rgb(31, 79, 130); text-decoration: none; word-break: break-all; white-space: nowrap;" target="_blank">Contact
Us</a></td>
</tr>
<tr>
<td align="center" style="font-family: Arial, Helvetica, sans-serif; font-size: 13px; color: rgb(43, 43, 43); padding-bottom: 10px; padding-top: 10px;">You are
receiving this communication as a result of your current relationship with
Oracle Support. Designated Support contacts may not unsubscribe from receiving
Oracle Critical Patch Update, System and Contract communications. However, if
you believe you have received these messages in error, please contact: <a href="mailto:MOS-Privacy_US@oracle.com" style="text-decoration: none; word-break: break-all; white-space: nowrap;"><span style="color: rgb(31, 79, 130);">
MOS-Privacy_US@oracle.com</span></a>.
<br />
<br />
Copyright © 2017, Oracle and/or its affiliates. All rights
reserved.
<br />
Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL -
E-mail Services, Redwood Shores, CA 94065, United
States</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<img src="http://app.response.oracle-mail.com/e/FooterImages/FooterImage1?elq=cb68fab9a18742a9bcf6f90733fb0d27&siteid=1973398186" alt="" border="0" width="1" height="1" />
<br /><b>------- End of Forwarded Message
-------</b>
<br />
<br />
<br />Fodor Zsuzsa
<br />
<br />
--
<br />
Pécsi Tudományegyetem Természettudományi Kar (<a href="http://www.ttk.pte.hu/" target="_blank">http://www.ttk.pte.hu</a>)
<br />
<br />
</font>
</BODY>
</HTML>