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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Improve performance of JDBC connectivity

2 posters

Go down

Improve performance of JDBC connectivity Empty Improve performance of JDBC connectivity

Post  maran 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?
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Improve performance of JDBC connectivity Empty Re: Improve performance of JDBC connectivity

Post  sivakumar 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.

sivakumar

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

Back to top Go down

Back to top

- Similar topics

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