For mainframe products: Does this run in an LPAR?

Supra SQL runs on z/OS and zVSE/VSEn platforms. It may run in an LPAR, depending on the specific z/OS configuration. It requires the presence of the operating system and related subsystems to function.

What infrastructure is required?

Supra SQL requires the underlying z/OS or zVSE/VSEn operating system, along with necessary system libraries and utilities. It may also require specific storage management configurations.

How is Supra SQL typically deployed?

Supra SQL is typically deployed on-premise within the organization's data center. It can be deployed in a cloud environment if the underlying z/OS or zVSE/VSEn systems are hosted in the cloud.

What level of technical expertise is required to implement it?

Implementing Supra SQL requires technical expertise in database administration, SQL, and the underlying z/OS or zVSE/VSEn environments. Familiarity with mainframe systems is essential.

What business problem does it solve?

Supra SQL solves the business problem of managing and accessing data in a structured and efficient manner. It enables organizations to build and maintain applications that rely on reliable data storage and retrieval.

What would happen if an organization did NOT use this product?

If an organization did not use Supra SQL or a similar RDBMS, they would likely face challenges in managing their data effectively. This could lead to data inconsistencies, inefficiencies in data access, and difficulties in building data-driven applications.

When is Supra SQL a good fit?

Supra SQL is a good fit for organizations that require a robust and reliable database management system, particularly those with existing investments in mainframe technology. It is suitable for applications that demand high performance and data integrity.

How does Supra SQL address security concerns?

Supra SQL provides security features to control access to data and protect it from unauthorized access. Specific authentication methods and access control models are used to ensure data security.

What specific authentication methods are supported?

Supra SQL likely supports authentication methods such as user IDs and passwords, as well as integration with external security systems like RACF or ACF2. The specific methods depend on the configuration and the underlying z/OS or zVSE/VSEn environment.

What access control model is used?

Supra SQL likely uses an access control model based on roles and privileges, allowing administrators to grant specific permissions to users or groups. This ensures that only authorized users can access sensitive data.

What ongoing operational requirements exist?

Ongoing operational requirements for Supra SQL include database monitoring, performance tuning, backup and recovery, and security management. These tasks require skilled database administrators and system programmers.

What are common implementation challenges?

Common implementation challenges for Supra SQL include integrating with existing mainframe applications, migrating data from other database systems, and ensuring adequate performance and scalability. Careful planning and testing are essential.

What administrative interfaces are available?

Administrative interfaces for Supra SQL likely include a command-line interface (CLI) and potentially a graphical user interface (GUI). These interfaces allow administrators to manage the database, configure parameters, and monitor performance.

Share Your Product Experience

Help the community by sharing your experience with mainframe products. Your insights help others make informed decisions.

Share Your Experience

Supra SQL

Cincom Systems Inc Active z/OS zVSE/VSEn

Databases

Vendor

Cincom Systems Inc

Product Overview

Supra SQL is a relational database management system (RDBMS) from Cincom, designed for platforms like z/OS and zVSE/VSEn. It provides the core functionality for storing, managing, and accessing data using SQL. The system's architecture typically includes components such as a data manager, query processor, and transaction manager.

These components communicate to handle data storage, retrieval, and manipulation. Supra SQL is deployed on-premise within the organization's data center, often running in an LPAR on z/OS. It requires the underlying operating system and related subsystems.

Integration with existing mainframe applications is crucial, often involving COBOL and Assembler programs. Alternatives include Db2 for z/OS and Datacom. Security is managed through access control models and authentication methods.

Monitoring and logging capabilities are essential for ongoing operations. Key architectural considerations include performance, scalability, and integration with enterprise ecosystems.

Frequently Asked Questions

What does Supra SQL do?

Supra SQL is a relational database management system (RDBMS). It provides the tools and infrastructure for storing, managing, and accessing data using SQL.

Is this a system, application, or tool?

Supra SQL is a system. It provides the core database functionality, including data storage, retrieval, and manipulation.

What types of organizations use this?

Organizations that require a robust and reliable database management system, particularly those with mainframe environments, would use Supra SQL. This includes enterprises in industries like finance, insurance, and government.

When should we consider Supra SQL?

A company should consider Supra SQL when they need a relational database system, especially if they have existing systems on z/OS or zVSE/VSEn platforms. It is also a good fit when needing to integrate with existing mainframe applications.

What are the alternatives to Supra SQL?

Alternatives to Supra SQL include Db2 for z/OS, Datacom, and other relational database systems. The choice depends on specific requirements, existing infrastructure, and cost considerations.

Related Products

More from Cincom Systems Inc

COBOL/XT

Not Supported

z/OS

Alternatives available

COBOL/XT is an early COBOL compiler that specialized in creating online, screen-oriented applications, primarily within the Environ/1 environment. It extended the COBOL language with specific...

Programming Language COBOL

View Details →

Environ/1

Not Supported

z/OS

Alternatives available

Environ/1 was a transaction processing system and terminal manager for the z/OS platform. It provided similar functionality to CICS, managing online transactions and terminal interactions....

Transactions

View Details →

MANTIS

Active

z/OSzVSE/VSEn

MANTIS is a programming language and application development environment designed for organizations needing robust application development, especially those with mainframe systems. It supports direct SQL...

Programming Language Application Development

View Details →

Supra PDM

Active

z/OSzVSE/VSEn

Supra PDM is a hierarchical database management system that provides a structured approach to data storage and retrieval. Developed by Cincom, it offers a solution...

Programming Language Databases

View Details →

Similar Products

Access Manager for CICS

Supported

by Oracle

z/OS

Access Manager for CICS provides a robust solution for integrating CICS applications with Oracle databases on z/OS. The product's architecture includes the CICS Interface, Oracle...

Databases Application Development

View Details →

Access Manager for IMS

Supported

by Oracle

z/OS

Access Manager for IMS provides a solution for integrating IMS applications with Oracle databases on z/OS. The primary components include the IMS Connect client, the...

IMS Databases

View Details →

ADABAS

Active

by Software AG

z/OSz/VMzVSE/VSEn

ADABAS is an inverted list database system designed for high-performance data management, particularly on z/OS, z/VM, and zVSE/VSEn platforms. Its architecture includes the ADABAS nucleus,...

Databases

View Details →

Artubus Connect

Active

by Artubus Software

z/OS

Artubus Connect offers a solution for accessing mainframe data sources (DB2, VSAM, IMS, QSAM) via ODBC, .NET, OLE/DB, and JDBC. The architecture comprises a z/OS-resident...

Legacy Application/Data Access Databases

View Details →

ASG-Bridge

Not Supported

by ASG Technologies

z/OS

Alternatives available

ASG-Bridge was designed to address data conversion challenges, particularly during database migrations. It provided a mechanism to transform data between an application and a database,...

Data Conversion Databases

View Details →