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

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.

Top