This is how it works:

​

Our Database Specialists will complete the "DB2 for i Performance Check Up" complete. We will analyze your transactions, the information that is and is not offering the best performance and determine how they could be more efficient through the appropriate settings for DB2 for i.

 

Within the hours after our visit, you will receive a written report with the results of our Analysis of your database needs. It will include specific hardware and software recommendations that help optimize the performance of your applications.

​

Analysis:

​

• Recommendations of the Observations in the Performance Check for its execution.

• Changes to file parameters on which IBM recommends to improve its Performance

• Optimization of queries executed against the database that consume a lot of CPU resources (SQL or QUERY).

• Analysis of SQL statements that take a long time to execute, to improve them.

​

Additional services:

​

• On-site counseling is offered to train database staff in analyzing SQL statements and improving their performance.

• Courses are offered in DB2 for i, for creating DLLs and getting the best performance of the Database, failing to execute programming code lines.

• Courses are offered in the Operations Browser, in which the participant will learn how to use the Graphical screen to manage the iSeries and the Database.