J06.07 Release Version Update Compendium

4 Database and Transaction Processing Products
Module File Caching for NonStop ODBC/MX and NonStop JDBC/T4
Drivers
The Module File Caching (MFC) feature shares the SQL/MX prepared statement plans among
the SQL/MX database connections. It helps in reducing the SQL/MX compilation time during
the steady state of the JDBC or ODBC application, thereby reducing resource consumption. MFC
uses disk files on the NonStop Open System Services file system for storing the compiled SQL/MX
prepared statement plans.
SQL/MX Enhancements
Enhanced mxexportddl Utility
The mxexportddl utility is used to export SQL/MX object metadata and table statistics, and save
them in the XML format. The mxexportddl utility enhancements include:
• Improved handling of dependency objects
• Options for selective import of tables and histograms
• Improved efficiency
New mximportddl Utility
A new utility, mximportddl, is introduced. The mximportddl utility is an OSS command-line
utility that replicates the DDL definition and statistics of SQL/MX objects. It is used to import:
• SQL/MX object metadata from an XML file for DDL replication
• SQL/MX table statistics from an XML file for statistics replication
TS/MP Version 2.4
The following new features are introduced in TS/MP Version 2.4:
• A new keyword, DOMAIN.
• A new command, ALTER-DOMAIN. This command performs an automated online upgrade
of domain-based Pathway applications.
• A synchronous upgrade feature. This feature is used to achieve zero downtime when older
and newer versions of the PATHMON server are not compatible with an upgraded SCOBOL
application. The following new CONTROL commands are used for the synchronous upgrade:
— CONTROL DOMAIN PARTITION and CONTROL DOMAIN UNDO PARTITION.
These commands are applicable when a domain is opened with a prior OPEN command.
Issue these commands to temporarily change the domain behavior.
— CONTROL TERM COUPLE and CONTROL TERM DECOUPLE. These commands are
used to direct sends from TERMs to a specific PATHMON for a given server.
• A new Pathsend API, SERVERCLASS_SENDL_, supports data transmission of up to 2MB.
You must install the latest file system released in J06.07, SPR ID T9055H07^AGN, to use the
new API.
• Serverclass parameter createdelay now accepts values in centi-seconds. The value of
centi-seconds must be in the range 0 to 16384.
• Server links (per CPU) limit is increased to 8191.
• Concurrent Pathsends (per CPU) limit is increased to 8191.
• A new HISTORY command introduced in PATHCOM and PDMCOM. It is used to display
previous commands.
• The ! command is introduced in PATHCOM. It is used to execute an existing command.
Module File Caching for NonStop ODBC/MX and NonStop JDBC/T4 Drivers 17