Author: Gary Patterson

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

Using IBM i Access for Windows with Windows 7 and Windows 2008

Only certain versions of IBM i Access for Windows (predecessor products include IBM iSeries Access for Windows and IBM AS/400 Client Access) are supported on Windows 7 and Windows 2008, and specific IBM Service Pack and Microsoft fixes required. There

Posted in IBM i, IBM i Access For Windows, Microsoft Windows, Microsoft Windows 2008, Microsoft Windows 7