IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Mainframe DB2 and DRDA Remote DB2 performance issue.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Tue Jan 05, 2010 10:47 am
Reply with quote

Hi,


Good Day to all. We are doing some testing on migratiating the ZOS DB2 to mid range AIX UDB. This is typically a cost cutting measure. We were successfull with the testing but the results does not look that good.

We did the testing to select 90k records from mainframe db2 and with remote DRDA connection.


Code:
Mainframe DB2
-------------

CPU    0MIN 03.98
0.45 MINUTES EXECUTION TIME
DB2 version 9 on ZOS




Code:
DRDA Connection and Remote DB2
------------------------------

CPU    0MIN 24.40
7.92 MINUTES EXECUTION TIME 
DB2 version 9.7 on AIX



We havent used any performance measurement tools like STROBE or Omegamon and have tested the case for a batch program.

here the execution time can be justified by the CPU time is a matter of concern as the data is almost the same 90k records.

Is anybody having a clue why this is so or any pointers to any documents will be really helpful.


Thanks,
Syam
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Tue Jan 05, 2010 12:06 pm
Reply with quote

Hi skkp2006,

Quote:
Is anybody having a clue why this is so

Quote:
We havent used any performance measurement tools like STROBE or Omegamon and have tested the case for a batch program.

You have given the answer yourself, you should try using performance tools in both zOS & DB2 UDB for AIX and compare the results and find where the differences are, i guess this can be a starter for the whole tuning process.

Sushanth
Back to top
View user's profile Send private message
skkp2006

New User


Joined: 14 Jul 2006
Posts: 93
Location: Chennai,India

PostPosted: Tue Jan 05, 2010 12:19 pm
Reply with quote

Hi Sushanth,

Yes, we are gonna configure the performance measurement tools. We will try to EXPLAIN the SQL's also for both the scenario's.

I was looking at some configuration parameters to finetune or someone who is some previous experience on this DRDA Remote DB2 configuration.

Thanks,
Syam
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Remote Unload of CLOB Columns DB2 6
No new posts exploiting Z16 performance PL/I & Assembler 2
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
Search our Forums:

Back to Top