QZDASOINIT Memory Allocation

225 pts.
Tags:
AS/400
iSeries
Java
QZDASOINIT
We are using jt400 to connect to the iSeries from a Java based application deployed to an IBM app server. This translates to database server jobs (QZDASOINIT) for the connections. Is there a standard/benchmark/minimum amount of memory on the iSeries that we need to consider for sizing? For example, max concurrent database server job connections from the external application is 100 users, how does that translate to the amount of memory on the iSeries that we need to allocate/purchase as part of said integration?

Software/Hardware used:
IBM i, Websphere Application Server

Answer Wiki

Thanks. We'll let you know when a new response is added.
You could always check with your IBM service rep to see if what you have is sufficient for your intended plans. If they think it’s inadequate they will make a recommendation on addition memory.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Another thing you may want to consider is the timeout setting. To cut down on the start up resources the connection will remain active for a given time. We have lots of these QZDASOINIT jobs active at one time
    102,670 pointsBadges:
    report
  • Jpjawili
    Thank you Todd. Yes that is also one of our considerations, along with the keepalive settings of the iSeries. We had this problem before in one of our clients where a firewall between the app server and the iSeries kills of the jdbc connections after 1 hour. Keepalive resolved that for us.
    225 pointsBadges:
    report
  • ToddN2000
    We have no performance issue with our set up. Our situation varies a bit. We have between 50 and 75 QZDASOINIT jobs running at any given time. Currently our memory is 31488.00 (M) when using the command WRKSHRPOOL. We are currently on V7R3M0.
    102,670 pointsBadges:
    report
  • Jpjawili
    Thanks. Our configuration is a bit complicated, we have several applications on a number of app server connecting to the iSeries core application. We are looking at around 2600 peak concurrent users for all the applications. I was hoping to get some guidelines (IBM redbooks doesn't seem to have a hard/definitive guide) on how to properly size the memory requirements on the iSeries for the said connections. I am currently looking at the Temporary storage used value of the Display Job Run Attributes for the QZDASOINIT jobs. I know that iSeries architecture uses a single level storage concept. so it seems not all of the temporary storage is actually memory/RAM utilization, most could well be allocated from the disk itself. Aside from the temporary storage allocation of the job, are there other metrics that i could use as a baseline for memory allocation needed by my database server jobs?
    225 pointsBadges:
    report
  • Jpjawili
    Upon further checking, the temporary storage indicated in Display Job Run Attributes is actually auxiliary storage i.e. disk storage, not main storage i.e. main memory. So looks like this figure could not be used as a baseline for memory requirements for each database server job.
    225 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: