Category Archives: Databases

DB2: Finding and adding indices

By | February 8, 2017
0 Comment

DB2 has a very powerful tool (db2advice) to determine necessary indices for your DB2 database. Having a good index can have a very big boost in performance in any application. If working with high throughput systems it is crucial to have the right index. Note that my databse user is db2inst1 and database name MMS.… Read More »

DB2 Sqlcode: -964, Sqlstate: 57011 (transaction log for the database is full)

By | February 8, 2017
1 Comment

I got this error while doing some performance tests on a high volume system using DB2. This is the usual unintuitive error that IBM likes to give to the users đŸ™‚ IN plain English this means that “The transaction log for the database is full.” This appears when you have to execute UPDATE or INSERT… Read More »