If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > CPU time issue for DRDA

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-25-08, 19:39
ramesh jampala ramesh jampala is offline
Registered User
 
Join Date: Mar 2007
Posts: 15
CPU time issue for DRDA

Hi,

We have DB2 v7.1 on Mainframe. UDB v9.5 on AIX. I established DRDA communication from Mainframe to AIX. COBOL-DB2 program is present on Mainframe. I did following testing for CPU utilization.

1. Run Batch COBOL DB2 Program on Mainframe inserting 1Million records into Mainframe DB2 Table. It took around 35sec of CPU on Mainframe.

2. Run Batch COBOL DB2 Program on Mainframe inserting same 1Million records into AIX UDB Table(The Table structure is same as Mainframe DB2 Table). It took 150 Sec of CPU time on Mainframe. This CPU time is not AIX CPU but its Mainframe CPU time.


In the Second case, since database operations are carried out on AIX, i expected Mainframe CPU time for above batch program to be much lesser than the first case. But results are different.

Can someone tell me what is going wrong here for CPU? What componet could be consuming more CPU time in the second case.

Thanks
Ramesh
Reply With Quote
  #2 (permalink)  
Old 04-29-08, 01:25
ramesh jampala ramesh jampala is offline
Registered User
 
Join Date: Mar 2007
Posts: 15
Any clue on this could be helpful........

Thanks
Reply With Quote
  #3 (permalink)  
Old 04-29-08, 02:32
guyprzytula guyprzytula is offline
Registered User
 
Join Date: Jun 2006
Posts: 471
are you using VSE for mainframe ?
there is an improvement in latest release for this (le routines in assembler.. tcpip buffering..)
__________________
Best Regards, Guy Przytula
DB2 UDB LUW certified V6/7/8
Reply With Quote
  #4 (permalink)  
Old 04-29-08, 13:14
ramesh jampala ramesh jampala is offline
Registered User
 
Join Date: Mar 2007
Posts: 15
Hi,

we are not using VSE OS but we are using Z/OS.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On