We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to imrpove the performance of as/400 to allow maximum number of connections.

Answer Wiki

There is no maximun number of connections.
If your running the application now, then the question is are you have any performance issues? If you are, then you need to to the analysis to determine the cause and cure.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 5 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

It probably depends on how much and what kind of performance tuning has been done previously to your system. How many memory pools do you currently run with during a normal day's workload? And how many jobs would be actively running in *BASE on average under normal workload? (Including TCP/IP servers, host servers and everything else.)
Those questions are only meaningful in order to get a feeling for how far any previous performance tuning might have been done.
Tom

I think tom is referring to the performance when you start doing stuff though all those connections.
Yes, that's part of it. Mostly, performance analysis comes down to interpretation of measurements. Interpretation involves a set of assumptions that may or may not be true. The 'truth' values can be set correctly by some initial actions that are based on understanding what various performance measurements mean.
The fundamental starting point is with the initial system from IBM. It comes with a bunch of default values, all of which may be changed to adapt the system to a company's needs. Most are never changed even though they should be. IBM assigns default values that allow the system to handle essentially any kind of workload. But it's impossible to have a large set of default values that will all work well. "Working" isn't the equal of "working well".
Further, the default settings effectively make meaningful performance measurements impossible. They also make some performance features of the system ineffective. The QPFRADJ system value, for example, is largely useless as long as most work management attributes remain at their default settings.
In short, if the system hasn't been prepared for performance measurements, then measurements will be meaningless at best and actually misleading in many cases.
Various changes can be made to SQL statements to make them work better. Other changes can be made to the database structures to make SQL statements work better.
But there are many changes that can be made to the system itself to make the entire system work better, including measurements. If the system itself is tuned and it can give precise info about how it's running, extra stuff like tweaking SQL statements becomes almost obvious.
Tom

wt i will do Mam/Sir
I would suggest placing this all in a new question. It's possible that no one will see it because it seems to be stuck on the end of a mostly unrelated thread.
Create a question that describes the platform that your code runs on and the platform that contains the database. Include a description of the driver that you expect to be used. Add your code and the error as you did here. (When you paste code and use the {code} button, you need to mark the beginning AND the end of the code. You can either click the button once at the beginning and once at the end, or you can select/highlight the code and click the button once.)
Tom

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy