PDI Data Quality for Mainframe
Profile 100 million mainframe rows in a 30-minute window — from one Linux server, one config file, zero host installs. The mainframe does the counting; you get an audit-ready DAMA scorecard.
make smoke harness · 8-core, 256 GB Azure instance · 2 TB SSDThe most critical data is the data quality tools can't reach.
The oldest, most business-critical data in the enterprise lives on the mainframe. Moving 100 million rows off-host just to count nulls is slow, expensive, and risky. The solution inverts that: the counting runs where the data lives.
Aggregates run on the host
Row counts, nulls, distincts, and length bounds are computed by the engine that owns the data, via one aggregate statement. One result row crosses the wire — not 100 million.
Streams only what must move
Only the profiled columns travel, in 10,000-row array fetches, under read-only/UR isolation — no locks on production workloads.
High-performance linear-time validation
Emails (RFC 5322 subset), phones (E.164 + NANP tiering), URLs against the live IANA TLD list, IDs, and junk or placeholder values — scored on the Linux side across all cores.
DAMA scorecard, audit trail included
Completeness, Validity, Uniqueness, and Consistency per column — plus a rule-level audit trail with registry IDs and the exact SQL shipped to the host. Text and CSV, identical across all six datastores.
Six stores, one motion.
The same preset that profiles a Db2 table profiles an IMS segment or an Adabas file — using the vendor connectivity your shop already licenses.
| Datastore | Access from Linux | Pushdown |
|---|---|---|
| Db2 for z/OS | Db2 Connect / DRDA | Full — DRDA work is zIIP-eligible under IBM's processing rules |
| Db2 for i | IBM i Access ODBC | Full |
| CA Datacom | Datacom Server SQL | Full |
| CA IDMS | IDMS Server SQL Option | Aggregates |
| Adabas | Adabas SQL Gateway (CONNX) | Aggregates |
| IMS | ODBM / IMS Connect | Streamed |
Proof in five minutes, on a laptop.
make smoke
The full pipeline runs on generated data with no mainframe access required — the scorecard, the tiered phone logic, and junk detection, live in front of your team.
Verify the throughput yourself
The same command is the throughput proof point. The 800K rows/sec-per-core figure was measured on an 8-core, 256 GB Azure instance with 2 TB SSD — and your team can re-run it on your own hardware.
Available per data-quality assessment
The solution is licensed as a one-time purchase per profiling assessment: one complete profiling run across your declared datastores, tables, and rule chains, producing the full DAMA scorecard and audit trail. Pricing is scoped to the assessment during a demo.
make smoke demonstration requires nothing from your environment.Let your mainframe grade its own data.
A demo runs the full pipeline in front of your stewards in five minutes — no host access needed.
Request a demo