DB2 for i Services
DB2 for i has changed so dramatically over the past few years that many IBM i aficionados find it daunting to keep up with - let alone use - all of its new capabilities.
After learning about new DB2 techniques at the RPG & DB2 Summit and SQL for i Spotlight, several attendees have asked us for assistance in taking their own database capabilities from now to WOW! by optimizing their use of SQL and SQE.
So we turned to the best DB2 for i experts we know - our friends on IBM's DB2 for i team - to help us structure and deliver the most advanced, up-to-date, cost-effective database services available.
- DATABASE MODERNIZATION / REENGINEERING
Obtain a sound and appropriate plan to move select DDS objects to DDL so that core DB foundational items, such as Identity columns, can be added to the data model. This important first step positions your team to move to data-centric processing, where DB2 does more of the work, you do less coding, and the database itself enforces both data and relational integrity.
- IBM i QUERY MODERNIZATION
Take 5, 10, 20-year-old QUERY/400 definitions and re-engineer them to breathe new life into your valuable reports and underlying information. Empower your users with powerful analytics delivered through dashboards and web-based visualization from a browser or mobile device. Avoid the security risks and hassle of using QUERY to extract data to the PC for manipulation by users. You CAN achieve a single version of the truth.
- REMOTE DATABASE ENGINEERING SERVICE (aka Rent-a-DBA)
This retainer-based service allows your organization to have scheduled, as-you-need-it access to world-class expertise on data modeling, database implementation, data-centric processing, SQL performance and more. It's like having a team of DB2 for i experts on staff to advise on tactical issues and strategic planning - but without the expense and overhead. Rent-a-DBA helps your IT staff improve productivity, meet your business requirements faster and reduce risk…affordably.
- SQL PERFORMANCE ASSESSMENT
Time for your annual check-up? Embrace the concept of continuous improvement by calling on an expert to evaluate SQL performance from a "top n" perspective. We'll help you ensure that best practices are in place to support SQL queries, plus identify opportunities and provide recommendations to improve performance and scalability.
- CUSTOM SERVICES
Whatever your database need, we can identify the leading expert in that area to help you achieve your business objectives.
Contact us to learn how we can help move your team forward with confidence under the tutelage of the world's most knowledgeable DB2 for i experts - and we mean that quite literally.