Software Products Overview

Database Integrity Tools for the iSeries (DBiTools) are a suite of software products from DBiTools.com. These tools operate as an integrated tool set library or stand alone products.

DBiTools address issues found in IT departments both large and small.

• Difficulties in understanding complex business rules and intra-related data
• Management assumes data integrity but very few compliance metrics
• Few iSeries shops use referential integrity to enforce data relationships
• Orphan records are tip of the iceberg with many possible points of failure
• Not possible to measure compliance without external definition of rules
• Most rules are buried inside application programs and not readily accessible
• Few proactive controls in place to locate or measure non compliant data
• End users are primary means for discovering non compliant data
• Many (if not most) application related issues are due to non compliant data
• Controlling multiple database environments and keeping them in sync
• Controlling test environment, test scenarios and debugging tools
• Controlling impact of database changes
• Controlling object-source synchronization
• The need to get more done in less time at higher quality

Features found in dynamic SQL tools: SQLDBi - SQLJOBi - WRKRCDi

• Quickly access data from command line and CL programs
• Ease of inserting and supplying variables into these SQL statements
• Excellent security and performance functionality, includes query governor controls
• Log files and audit trails with record counts and timings
• Extraordinary ability to manipulate data with built in protections
• SQL minimizes file level check issues verses using RPG alternatives
• Capabilities far beyond Query/400 and SQL/400