Category: DB2 on i

Optimizing journal bundle sizes in commitment-control applications – The hard way or the easy way

I was reviewing the wait signature of an IBM i batch application the other day using IBM iDoctor, and noticed that the job spent a significant portion of its time in Journal Wait status. Journal waits happen when an application

Posted in DB2 on i, IBM i, Journaling, Performance, Performance Tagged with: , , , , ,

Setting the Session Date Format in IBM DB2 for i (and AS/400, and iSeries)

Apparently in DB2 for Linux/Unix/Windows, the date format is a system-wide setting, and is not controlled at the session level. I’m not a DB2 LUW expert, so don’t take my word on that! IBM DB2 for i offers more flexibility.

Posted in DB2 on i, DB2 on i ADO.NET, DB2 on i DRDA, DB2 on i Embedded SQL, DB2 on i JDBC, DB2 on I ODBC, DB2 on i OLEDB, IBM i, IBM i Access For Windows