Are You a Vendor? Claim Your Listing
Take control of your product listings. Add verified information, showcase updates, and unlock a Claimed Vendor badge across the directory.
Claim Your Listing NowProduct Overview
The StarSQL architecture centers around the ODBC and JDBC drivers, which act as the primary interfaces for applications. These drivers communicate with the DB2 server using TCP/IP. The StarSQL Configuration Manager is a central component for managing data sources and driver settings.
The drivers translate ODBC and JDBC calls into DB2-compatible SQL statements. , the Windows registry for ODBC). The drivers support standard SQL syntax, allowing for SELECT, INSERT, UPDATE, and DELETE operations.
The drivers also handle data type conversions between the application and the DB2 database. Security is managed through DB2's authentication and access control mechanisms. Monitoring and logging are supported through the drivers and DB2's native tools.
The StarSQL Configuration Manager provides a GUI for managing data sources and driver settings. The drivers are designed for high performance and minimal overhead, ensuring efficient data access. The drivers support various connection pooling options to optimize resource utilization.
Frequently Asked Questions
Related Products
Similar Products
Adabas SQL Gateway
ActiveAdabas SQL Gateway provides SQL access to ADABAS databases, enabling integration with various client applications. Key components include the Gateway Server, which handles SQL requests,...
View Details →Administrative Assistant for DB2
SupportedAdministrative Assistant for DB2 is a comprehensive suite designed to enhance the efficiency and reduce the complexity of DB2 database administration on z/OS. The product...
View Details →Alter for DB2
SupportedAlternatives available
Alter for DB2 simplifies the process of modifying Db2 resources on z/OS. The tool's architecture centers around an ISPF interface, which interacts with Db2 to...
View Details →Application Recovery Tool for IMS and DB2
Not SupportedAlternatives available
Application Recovery Tool for IMS and DB2 was designed to provide consistent recovery points for both IMS and Db2 databases. The architecture comprised components for...
View Details →Application Restart Control for DB2
SupportedARC/DB2 and AR/VR are designed to enhance the reliability and efficiency of batch processing in Db2 environments on z/OS. The primary function is to provide...
View Details →apX IMS Server
ActiveapX IMS Server is a critical component for integrating modern applications with legacy IMS databases on z/OS. The core architecture includes the apXchange-MVS interface, the...
View Details →Help Improve This Directory
Notice outdated information? Have insights about this product? Help the mainframe community stay informed with accurate, current data.
Are You a Vendor? Claim Your Listing
Take control of your product listings. Add verified information, showcase updates, and unlock a Claimed Vendor badge across the directory.
Claim Your Listing Now