Hello Everyone,

We are currently running DB2 on an AS400 V5R2. Recently, when using a web application (J2EE) we have been experiencing significant slowdowns. The consultants developing the system have asked where to find certain configs related to locks...the email is copied below...

------------------------------------------------------------

Thanks for the information earlier. I was hoping to find comparable
settings for some lock timeouts that are available in UDB. Some of the
settings that I would like to find (or their equivalents) are: Max
storage for lock list (4KB) (LOCKLIST), Interval for checking deadlock
(ms) (DLCHKTIME), Percent. of lock lists per appl. (%) (MAXLOCKS), Lock
timeout (sec)(LOCKTIMEOUT).

Do you know where we could make these type of settings changes for
iSeries DB2?

We have been able to update other isolation settings for some specific
transactions that we believe will address the root cause of these
issues, however, we don't want the record lock timeout to be so long
that it would hold up a user for over 2 minutes.

Let me know what you can find out. Thanks,

Pat
-------------------------------------------------------------------------------

I don't have any idea where these settings are located on an AS400 (iSeries) or if they even exist. Can anyone help to point me in the right direction? Thanks in Advance.

-Dave

Once i also looking for the same thing. In as400 and other main frames most of the parameters are handled by the system itself. Example there will not any settings for ur locklist.

May be you could find the deadlock related parameters...the best source is contach IBM

Hi,

I'm looking for the same things too (db2 health check report). I require to capture the all the configuration and status in the current DB2 v8.1 iSeries v5r3 environment. (eg: db configuration, allocated/used size of db/tables, memory pool & etc).

iSeries Navigator doesn't help a lot. (maybe i'm not familiar)

Trying google around, but cant get it. Any guidance since we are doing the same things. Please help..

all info should be in infocenter
http://publib.boulder.ibm.com/infoce...Frbafyjoin.htm

Thanks przytula_guy,

Wanted to understand deeply, DB2 in iSeries can still performance the normal LUW db2 configuration as well? or purely depends on iSeries configuration?

eg: Database Configuration Setup.

I'm very new is DB2, and 1st in DB2 iSeries. Hope you can share more. Sorry if i'm keep asking stupid question..

i can not help you in detail because db2 i/series is not my favorite
yes, db2 is part of o/s in i-series
I can not say if db cfg exists in db2/400
if it is - check infocenter - all info must be available there...
or do some reading in doc about db2/400 and fundamentals - see library...

Thanks przytula_guy, DB2 in iSeries really no that fun but i have to it.. no choice.. Have to read more and more.. Appreciate your advice.

there is no db cfg as such for iseries/db2, but there is an environment file QAQQINI, that can be used to control query processing either at global level or by profile(userid)...
here is the list of parameters in QAQQINI ,

http://publib.boulder.ibm.com/infoce...%2Fqryoptf.htm

Thanks amitrai4,

Was looking into this area (QAQQINI), wondering is there any different on iSeries v5r3.
1) I can't see the IBM i in the Application Administration (iSeries Navigator). Is it due to authorization access?

2) How do i grant my ID to QIBM_DB_SQLADM & QIBM_DB_SYSMON in iSeries v5r3? Or in v5r3 is in different way. Try looking in the v5r3 documents, but cant find any solution.

https://docs.google.com/open?id=0B5V...UwYTgzZWI2M2M0

https://docs.google.com/open?id=0B5V...MxMGQ0YmUyOTYx

I think QIBM_DB_SQLADM & QIBM_DB_SYSMON authorities has been introduced in v7r1, something similar to secadm in UDB. These are not available in v5r3.

Sysadmin can grant you access to modify QAQQINI file.

Thanks amitrai4,
Will try to configure with sysadm. basically i will create another user id to grant as sysadm to manage the QAQQINI. Understand that the SYSSEC don't have the rights to do that right?

sysadm is required.

Thanks amitrai4..