Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2007
    Posts
    15

    Unanswered: 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

  2. #2
    Join Date
    Mar 2007
    Posts
    15
    Any clue on this could be helpful........

    Thanks

  3. #3
    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

  4. #4
    Join Date
    Mar 2007
    Posts
    15
    Hi,

    we are not using VSE OS but we are using Z/OS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •