Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DB2 for z/OS Version 9 - problem with unicode conversion

34 views
Skip to first unread message

Jim McAlpine

unread,
Apr 28, 2009, 11:51:38 AM4/28/09
to
cross posted to IBM-MAIN and DLB2-L

I've just converted one DB2 system to DB2 Version 9 NFM and I'm getting a
problem which manifests itself as huge CPU usage in CICS/DB2 transactions.
These applications work perfectly in DB2 Version 8 on the same z/OS 1.7
system. In DB2 Version 9 the transactions typically use over a minute of
CPU time compared to 0.2 secs on DB2 Version 8. When I profile the V9
transactions, 30% of the CPU time is spent in cross memory and 70% in module
CUNMUNI. I've trolled IBM and Google and can't find anything relating to
problems with CUNMUNI. Has anyone seen anything like this before.

Jim McAlpine

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to list...@bama.ua.edu with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html

Schlueter, Edward

unread,
Apr 28, 2009, 12:06:24 PM4/28/09
to
Jim,

What is you CICS level? Have you applied PK33403/UK05667?
Doc relates to DB2 v8 NEWFUN, but is a CPU issue in CUNMUNI.

http://www-01.ibm.com/support/docview.wss?rs=1083&context=SSGMGV&q=&uid=swg1PK33
403&loc=en_US&cs=utf-8&lang=en+en

Ed Schlueter

Jim McAlpine

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Anheuser-Busch InBev Email Disclaimer www.ab-inbev.com

Jim McAlpine

unread,
Apr 28, 2009, 12:15:15 PM4/28/09
to
On Tue, Apr 28, 2009 at 5:04 PM, Schlueter, Edward <
Edward.S...@anheuser-busch.com> wrote:

> Jim,
>
> What is you CICS level? Have you applied PK33403/UK05667?
> Doc relates to DB2 v8 NEWFUN, but is a CPU issue in CUNMUNI.
>
>
> http://www-01.ibm.com/support/docview.wss?rs=1083&context=SSGMGV&q=&uid=swg1PK33
> 403&loc=en_US&cs=utf-8&lang=en+en
>
> Ed Schlueter
>
>
>
>

Thanks for the response but we are CICS/TS 2.2.

Jim McAlpine

unread,
Apr 29, 2009, 11:33:22 AM4/29/09
to
Problem solved. It was caused by a join being done between 2 tables with
different EBCDIC code pages. Thanks for the responses.

Jim McAlpine

0 new messages