Problem solved. It was caused by a join being done between 2 tables with different EBCDIC code pages. Thanks for the responses.
Jim McAlpine On Tue, Apr 28, 2009 at 4:46 PM, Jim McAlpine <[email protected]>wrote: > 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 [email protected] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
