whichdb

SQL/DS

discontinued

by IBM · since 1981 · also known as Structured Query Language/Data System, DB2 for VM and VSE, DB2 Server for VSE & VM

IBM's first commercial SQL database (1981) for VM and VSE mainframes, built from System R; later DB2.

relationaldatabase engineproprietarylegacy
Website Docs Compare Find similar

discontinued. The SQL/DS name was retired when IBM rebranded it DB2 for VM and VSE; the last major line, DB2 Server for VSE & VM 7.5, dates from 2007. Successor: IBM Db2.

Overview

SQL/DS shipped in 1981 as IBM's first commercial relational database and one of the first SQL products on the market, running on the VM/CMS and DOS/VSE mainframe operating systems and built on technology from the System R research prototype. When IBM released DB2 for MVS shortly after, the two lines coexisted for years, and SQL/DS was eventually rebranded DB2 for VM and VSE. The line continued as DB2 Server for VSE & VM, whose Version 7.5 appeared in IBM's VM product matrix in 2007. Today it is mostly of historical interest, plus the odd remaining z/VM or z/VSE shop; new workloads belong on current Db2.

Transactional apps (OLTP)

Strengths & trade-offs

Strengths

  • +Among the first commercially shipped SQL databases, proving relational ideas outside the lab
  • +Brought System R's SQL, cost-based optimizer and GRANT/REVOKE security into a product
  • +One code line served VM and VSE mainframe shops for decades

Trade-offs

  • −Only ran on IBM VM and VSE mainframe systems
  • −Product name retired and no new major versions since 2007
  • −Skills and tooling are scarce today

Great for

  • +History of SQL and relational databases
  • +Maintaining remaining z/VM or z/VSE applications

Think twice for

  • −Any new application
  • −Non-IBM platforms

Capabilities

Native or official first-party support · 5 of 25 tracked

✓Transactions
✓Joins
✓Secondary indexes
✓Durable persistence
✓Role-based access
–Full-text search
–Vector search
–Geospatial
–JSON
–Change data capture
–Triggers
–Stored procedures
–Materialized views
–TTL / expiry
–Pub/Sub
–Columnar storage
–In-memory
–Compression
–Encryption at rest
–Time travel
–Branching
–Online schema changes
–Streaming ingest
–Offline sync
–Runs in WebAssembly

Scale & consistency

Comfortable data size
Medium · ≤ 10 TB
Horizontal scaling
None
Multi-region
No
Transactions
Full ACID
Consistency
Strong
Schema
Strict
Architecture
Client server, Single node
Query languages
SQL

Deployment

Self-hosted Vendor-managed cloud Serverless Embedded Edge Kubernetes operator

Ecosystem

apis & protocolsEmbedded SQL

Alternatives to SQL/DS

Compare all→
IBM Db2Relational45.5

IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.

sql-ds vs ibm-db2 →
System RRelational4.5

IBM Research's 1970s relational prototype that produced SQL, cost-based optimization and modern transactions.

sql-ds vs system-r →
PostgreSQLRelational93.2

The extensible, standards-first open-source relational database.

sql-ds vs postgresql →
Progress OpenEdgeRelational20.4

Integrated RDBMS plus ABL 4GL application platform behind thousands of ERP and vertical business apps.

sql-ds vs progress-openedge →
MultigresRelational12.4

Alpha-stage, Vitess-inspired sharding, pooling and HA layer for unmodified PostgreSQL, led by Supabase.

sql-ds vs multigres →
NuoDBRelational12.3

Elastic distributed SQL with in-memory transaction engines and separate storage managers, owned by Dassault.

sql-ds vs nuodb →

SQL/DS FAQ

What is SQL/DS?

SQL/DS is a relational database by IBM, first released in 1981. SQL/DS shipped in 1981 as IBM's first commercial relational database and one of the first SQL products on the market, running on the VM/CMS and DOS/VSE mainframe operating systems and built on technology from the System R research prototype. When IBM released DB2 for MVS shortly after, the two lines coexisted for years, and SQL/DS was eventually rebranded DB2 for VM and VSE. The line continued as DB2 Server for VSE & VM, whose Version 7.5 appeared in IBM's VM product matrix in 2007. Today it is mostly of historical interest, plus the odd remaining z/VM or z/VSE shop; new workloads belong on current Db2.

Is SQL/DS open source?

No. SQL/DS is proprietary, closed-source software.

Does SQL/DS support ACID transactions?

Yes. SQL/DS supports full ACID transactions, with strong consistency.

Does SQL/DS scale horizontally?

SQL/DS does not scale horizontally; it runs on a single node, so you scale it up rather than out. It is comfortable at medium scale (≤ 10 TB).

How can I run SQL/DS?

You can self-host it.

What is SQL/DS best for?

SQL/DS is a strong fit for history of SQL and relational databases; and maintaining remaining z/VM or z/VSE applications. Think twice for any new application.

What are the best alternatives to SQL/DS?

Common alternatives to SQL/DS include IBM Db2, System R, PostgreSQL, Progress OpenEdge and Multigres. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.

Is SQL/DS still maintained?

SQL/DS is discontinued. The SQL/DS name was retired when IBM rebranded it DB2 for VM and VSE; the last major line, DB2 Server for VSE & VM 7.5, dates from 2007. Successor: IBM Db2.

How popular is SQL/DS?

SQL/DS ranks #471 of 844 databases on the WhichDB Score (2.6/100), and #147 among relational databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.