problems with sqlcode -1225 in AIX 5.2 + UDB DPF (parallel) environment

[peteh]

Hi All;
We have 2 open PMRs - one for AIX, one for DB2 relating to this
problem, but I thought I'd see if I could make any progress in the
group.

We just upgraded a 4 node/36 processor configuration to AIX 5.2. We are
at DB2 v8.1 (FP 5). We upgraded AIX one node at a time and began seeing
periodic SQLCode -1225 and swapping issues. All nodes are now upgraded
and we get more and more bouts where processes end in sqlcode -1225.
Clearly, there is some memory-related issue, but we are having real
trouble isolating the problem.

Any simiilar experiences and/or suggestions? Thanks!

Pete H

[Yasir]

peteh wrote:

Hi All;
We have 2 open PMRs - one for AIX, one for DB2 relating to this
problem, but I thought I'd see if I could make any progress in the
group.

We just upgraded a 4 node/36 processor configuration to AIX 5.2. We are
at DB2 v8.1 (FP 5). We upgraded AIX one node at a time and began seeing
periodic SQLCode -1225 and swapping issues. All nodes are now upgraded
and we get more and more bouts where processes end in sqlcode -1225.
Clearly, there is some memory-related issue, but we are having real
trouble isolating the problem.

Any simiilar experiences and/or suggestions? Thanks!

Pete H

Pete,
Tuning up maxuproc may help with this situation. maxuproc indicates max
number of processes allowed for a user id on the system. v8
architecture is quite different from v7, so it is possible that you
just have more processes. Also, rember that for DPF, if you have
logical nodes, then all proesses for all logicals on the given host are
created by the instance userid!
You can check the current setting with:
lsattr -El sys0
and modifiy it with:
chdev -l sys0 -a maxuproc=<new value>

Regards, Yasir.
IBM Toronto lab.