IBM Db2 for IBM i consulting services are currently being prepared and will be available soon.
Back to Services
IBM i Practice
Five focused services. Two free entry points. Decades of IBM i expertise — from a free health check and PTF readiness assessment through to SQL modernisation, performance optimisation, and security hardening.
Services A and B are complete, actionable tools — not teasers. No registration. No system access required. Your team gets real findings before any paid engagement begins.
Service A
A profile-driven online scorecard assessing your IBM i database environment across six domains, with adaptive weighting for your environment type — OLTP, batch, mixed, or analytical. Security domain weight rises to 35% for compliance contexts. Takes 15–20 minutes. No system access required.
What you get: Scored health report with overall rating (Critical / Attention Required / Good / Excellent), domain-by-domain breakdown with highest-risk findings, and a ranked action list. Downloadable as PDF.
Paid upgrades: Remote deep-dive (Tier 2) · Full IBM i environment assessment (Tier 3)
Book a free discovery callService B
IBM i 7.6 requires Power10 or newer hardware. IBM i 7.4 extended support ends April 2026. Two tools in one: an online PTF currency questionnaire and a downloadable SQL script that queries your system directly for PTF group status against IBM recommended levels.
What you get: PTF currency rating (Current / Minor Gap / Significant Gap / Critical Gap) and OS upgrade readiness rating (Go / Go with Preparation / Hardware Upgrade Required First).
Paid upgrades: OS upgrade planning (Tier 2) · PTF remediation · Full OS + hardware refresh (Tier 3)
Book a free upgrade callFixed-price Tier 2 and project-based Tier 3 engagements. Every paid service starts from a free self-service tool — you arrive with real data, we arrive with real answers.
Service C
Incremental DDS-to-SQL modernisation — converting physical files, logical files, OPNQRYF, and RPG/COBOL native I/O to modern SQL. DDS and SQL objects coexist throughout, so existing programs keep running at every stage. No big-bang cutover required.
Free lead-in: DDS Inventory & Modernisation Scope Script — runs in IBM i ACS, produces a complete object inventory with modernisation priority scores. Takes 5–15 minutes.
Sub-services available individually · Full programme: 6–24 months in 3-month tranches
Request scopingService D
IBM i has some of the most sophisticated SQL performance tooling of any relational platform — SQL Plan Cache, Index Advisor, Performance Data Investigator, Visual Explain — and most organisations have never used them. We read the data these tools produce and fix the problems they reveal.
Free lead-in: SQL Plan Cache Collection Script — extracts top-50 SQL statements, Index Advisor recommendations, and statistics currency in a single 10-minute ACS run. No elevated authority required.
Tier 2: Diagnostic report (fixed price) · Tier 3: Full optimisation engagement (project-based)
Request scopingService E
IBM i's object authority model is simultaneously its greatest security strength and, when misconfigured, a source of audit findings other platforms would not generate. *PUBLIC *ALLOBJ, ungoverned adopted authority chains, and security levels below 40 are common findings. We fix them systematically.
Free lead-in: Security domain of the Health Assessment Scorecard surfaces the highest-risk authority findings before any paid engagement.
Tier 2: Authority audit & report (fixed price) · Tier 3: Full hardening project (project-based)
Request scopingEvery paid engagement starts from a free self-service tool. You arrive with real data; we arrive with real answers.
Available on our website. Immediate results for your DBA team.
A consultant analyses your tool output alongside data you provide. No direct system access required.
Full end-to-end delivery with direct system access, hands-on execution, and before/after measurement.
Tell us which service interests you, or share your scorecard or collection script output. We will respond within one business day to schedule a free 30-minute discovery call.