Operating System/400, 5769-SS1 509
Operating System/400, 5769-SS1
• New trace and logging support makes it easy to find errors in your macro.
• New built-in functions make it a snap to use Net.Data to send e-mail, generate browser
cookies, and manipulate Net.Data tables.
Threadsafe Functions and Facilities
Multi-threaded programming support continues to be enhanced in V4R4. The database
definition language (DDL) APIs, CL commands, and SQL DDL are threadsafe. With this
support, you can create or delete tables and add or remove members in a multi-threaded
program. DDM files using TCP/IP are also threadsafe. User-defined functions (UDF), a new
database function for V4R4, use threads as part of their implementation.
The QSYS.LIB, QOPT, and QLANSRV file systems are threadsafe. All objects that reside in
those file systems can be accessed from within a multi-threaded application. ILE COBOL
runtime is threadsafe.
DB2 Universal Database for AS/400
With the introduction of V4R4, DB2 for AS/400 is renamed DB2 Universal Database for
AS/400. Performance and functional enhancements to DB2 Universal Database for AS/400
improve the processing of business intelligence queries. Here are some of these
improvements:
• The hash group by algorithm improves the performance of grouping queries for a large
number of groups.
• The performance of grouping MIN and MAX functions is improved with a suitable
index, if available, to determine the minimum or maximum value of a query.
• The hash join algorithm is enhanced to implement some types of subqueries resulting
in improved performance.
• Derived tables and common table expression support allow complex business
intelligence queries to be written without the use of views.
• Support for expressions in the GROUP BY and ORDER BY is also added.
• The QAQQINI file support allows the system administrator to set query specific options
(query time limit and query degree) in a source file similar to QAQQINI file support
used by PC applications. This aids in setting query options for client/server-based
applications.
The following enhancements to DB2 Universal Database for AS/400 were added on
29 October 1999, by installing the 1999 Database Enhance Pak or Group PTF SF99104.
• Large Object Support
With the addition of large objects (LOBs), DB2 Universal Database for AS/400 can store
and manipulate data fields much larger than the current limits. An AS/400 record with
To Next Page
Loading...
Need help?
General