PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

Improve performance of JDBC connectivity

Go down

Improve performance of JDBC connectivity

Post  maran on Mon Aug 03, 2009 9:18 pm

Users are complaining that their PC-based application, which
connects to the System i using JDBC, has gotten progressively slower when initially
connecting to the System i. The number of users for this application has been
increasing recently. The PC and Network support departments report no problems.
How can the time required for the users' JDBC jobs to start be decreased?

Posts : 442
Join date : 2009-07-24

View user profile

Back to top Go down

Re: Improve performance of JDBC connectivity

Post  sivakumar on Sun Sep 27, 2009 1:24 pm

Increase the "Initial number of jobs" and the "Additional number of jobs" for the QZDASOINIT prestart job.

QZDASOINIT is the jobname for the database SQL server jobs on the System i. These jobs are used to serve SQL to JDBC and ODBC client applications. The jobs run the default QUSRWRK subsystem. iSeries Nav jobs also use this job name when running a query through the SQL window in Operations Navigator.


Posts : 174
Join date : 2009-07-27
Age : 32
Location : Chennai

View user profile

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum