DB2 for i has been really improved since last years.
I think DB2400Dialect should be updated to implement two features :

• SEQUENCES instead of the actual emulation with a table
• LIMIT and OFFSET to increase performances