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