what details do i need to know in order to connect to an IBM iSeries (AS/400) database/platform?
OS type? DB2 version/type???
we are currently using “the green screen” TN5220 and RPG.
i would like to explore Servoy and hopefully commit our company to use it.
Optimally: the right JDBC driver and connect strings
otherwise: db2/udb version, database name, ip-address, username, password
On as/400 mostly UDB (formerly known as DB/2) is used. In some cases Oracle, and in some cases non relational legacy databases.
Ok, latest info
Iseries Server (AS/400): DB2 version 5.3 for Iseries
iam using the JTOPEN (JT400.jar) driver.
i can see all the files (tables)…but browsing records is super slow and lags sometimes to a complete halt.
please advise.
My advise would be to speak to IBM support and ask them what the best way is to connect to the iseries using JDBC. Most application servers use JDBC so they should have quite some knowledge on this topic and how to make it fast. If possible please share your results here.
