DB2 Install Next Steps: Part 1

Tuning DB2 LUW systems, databases, and applications can be sometimes a long drawn out research effort requiring examination of every variable involved. Sometimes the key to the performance is examining the DB2 LUW system installation, its configuration, and the database configuration. This why I call this blog “DB2 Install Next Steps” because if the SYSADMIN . . . → Read More: DB2 Install Next Steps: Part 1

Criteria for Determining the Commit Scope Performance (part 3)

Last week was Part 2 of the discussion on DB2 Commit Scope considerations (found here) which followed Part 1 from the week before (here). This week the DB2 commit scope programming discussion continues with DB2 SQL considerations. The following addresses some of the DB2 SQL web and batch program requirements and considerations for . . . → Read More: Criteria for Determining the Commit Scope Performance (part 3)

Criteria for Determining the Commit Scope performance (part 2)

Last week was part 1 of the discussion on DB2 Commit Scope considerations found here. This week the DB2 commit scope programming considerations discussion continues with batch process considerations. The following addresses some of the program requirement discussions that are needed to determine the best DB2 commit scope practices for achieving the best performance . . . → Read More: Criteria for Determining the Commit Scope performance (part 2)

Criteria for Determining the Commit Scope Performance (Part 1)

A couple of weeks ago I discussed three critical programming performance criteria, where I talked about the importance of DB2 commit scope, data integrity, and programming languages. This brought in some interesting email comments/questions about what DB2 commit scope criteria needs to be evaluated and what factors come into consideration. The evaluation of a . . . → Read More: Criteria for Determining the Commit Scope Performance (Part 1)