Pohlen Mailinglist

my colleague told me that his customer has migrated from DB2/VM to
DB2 UDB 8.2 on zLinux. The connection is established using DRDA.
The batch perfomance is good, but online suffers. My colleague has
figured out that if he does a connect to the database and keeps it
open, online response time is good. It seems that the cics
transaction(s) closes the connection completely and DB2 flushes all
buffers to disk, if there is no remaining open connection. The next
transaction start must apparently read all the data from disk
again. If there is an open connection kept as mentioned, DB2 does
not do that. Is there any setting which can be customized to change
the behaviour?

>
> Hi listers,
>
> my colleague told me that his customer has migrated from
DB2/VM to DB2 UDB 8.2 on zLinux.
> The connection is established using DRDA. The batch perfomance
is good, but online suffers.
> My colleague has figured out that if he does a connect to the
database and keeps it open, online
> response time is good. It seems thatthe
cicstransaction(s)closes the connection
> completelyand DB2 flushes all buffersto disk, if there is no
remaining open connection. The
> next transaction start must apparently read all the data from
disk again. If there is an open
> connection keptas mentioned, DB2 does not do that. Is there
any setting which can be
> customized to change the behaviour?
>
> Thanks in advance for any ideas.
>
> Mit freundlichen Grüßen / best regards
>
> Franz Josef Pohlen

>
> Hi listers,
>
> my colleague told me that his customer has migrated from
DB2/VM to DB2 UDB
8.2 on zLinux.
> The connection is established using DRDA. The batch perfomance
is good,
but online suffers.
> My colleague has figured out that if he does a connect to the
database and
keeps it open, online
> response time is good. It seems thatthe
cicstransaction(s)closes the
connection
> completelyand DB2 flushes all buffersto disk, if there is no
remaining
open connection. The
> next transaction start must apparently read all the data from
disk again.
If there is an open
> connection keptas mentioned, DB2 does not do that. Is there
any setting
which can be
> customized to change the behaviour?
>
> Thanks in advance for any ideas.
>
> Mit freundlichen Grüßen / best regards
>
> Franz Josef Pohlen