UniAccess ODBC Server for RDMS

Provides SQL access to Unisys RDMS databases for both Microsoft ODBC-compliant and non-ODBC Open Client applications

The UniAccess ODBC Server for RDMS 2200 (UAOS for RDMS) is an entry priced, simplified version of the UniAccess Transaction Server providing SQL access to Unisys RDMS databases for both Microsoft ODBC-compliant and non-ODBC Open Client applications. UAOS for RDMS is intended for Unisys RDMS users to begin building client/server applications without mainframe-based programming. Once integration with legacy systems, access to other mainframe databases, or use of mainframe-based programs via RPCs is required, customers may upgrade to the full UniAccess Transaction Server.

UniAccess RDMS

UAOS for RDMS includes the host based UARS transaction, the communication server (UACS), which routes and translates requests between clients and servers, and other core components, such as UACF. It also includes the UniAccess ODBC Driver and the UniAccess Distributed Transaction Coordinator. (Internally, the UniAccess ODBC Server makes use of the UniAccess Server-Library functions, but they are not accessible to the customer to enable RPC capability on the Unisys 2200.) These components, described below, act together to transform the Unisys 2200 into a Microsoft compatible server by performing the following functions:

  • establish and manage the client/server interaction
  • interoperate with client applications or SQL Servers using the TDS protocol
  • process client SQL language and ODBC catalog access requests
  • perform host-to-client datatype conversions
  • manage error, information, and security control

All of the client and server-side components listed below are packaged together, priced, and licensed under the product name of UniAccess ODBC Server for RDMS. With UAOS for RDMS, hundreds of industry leading SQL and Microsoft ODBC tools provide turnkey access to Unisys RDMS.

UniAccess Relational Service (UARS) is an OS 2200 transaction that accepts SQL language requests from clients, processes the requests using the RDMS 2200 interpretive SQL interface, and returns results to clients. It provides some essential preprocessing and postprocessing services, including some datatype and architecture conversions. In addition, UARS supports RDMS stored procedures and processes Catalog RPCs from the UniAccess ODBC Driver. UARS is an AIS-written TIP transaction, built with UniAccess Server-Library functions.

UniAccess Communication Server (UACS) on the OS 2200 mainframe, provides the communication link between UniAccess on the Unisys 2200 and all other Microsoft architectural components across the network. UniAccess interacts across the network using TCP/IP through either the Unisys DCP or HLC. UACS utilizes the Unisys TSAM communications interface, which is part of the Unisys CMS. The operations of UACS, as well as the other interoperability components of the architecture, are transparent to the user, so no programming or knowledge of its functions and protocols is required. UACS can handle large numbers of users, and multiple UACSs may run on a single host. UACS utilizes the MCB for scheduling transactions to allow existing transaction management and tuning capabilities to be utilized.

UniAccess Fixed-Gate (UAFG) is a system-wide shared sub-system that contains a number of core services essential to the UniAccess System. UAFG contains the UniAccess Data Manager (UADT) and the UniAccess Message Manager (UAMM) that manage user, remote server, message, and other information. It also contains the UniAccess Server-Library, used internally by UAOS for RDMS. The services provided by UAFG are transparent to the user.

UniAccess Distributed Transaction Coordinator (UADTC) extends Microsoft’s Windows distributed transaction capabilities to the Unisys OS 2200 environment. With the UADTC serving as a gateway between the Microsoft Distributed Transaction Coordinator (MS DTC) and the UniAccess System, OS 2200 distributed-transaction-enabled resources can be updated as part of an MS DTC-controlled transaction. UniAccess’ distributed transaction support uses proven transaction processing technology: it is robust despite system failures, process failures, and communication failures; and it exploits loosely coupled systems to provide scalable performance.

UniAccess ODBC Driver (UADriver) is the PC component that allows Microsoft ODBC-compatible client applications and tools to have ODBC access to OS 2200. The driver processes ODBC function calls from a wide variety of client tools, submits SQL and RPC requests to UniAccess server components, and returns results to the application. It works in conjunction with the Microsoft supplied Driver Manager, appearing to the application as one processing unit.

Please note that all the components required by UniAccess on a Microsoft Windows client or server system are bundled at no additional cost with UAOS for RDMS. With the licensing of the mainframe products, AIS provides a no-cost license to use these desktop components on an unlimited number of customer systems that are connected to the OS 2200 mainframes.