Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Mainframe DB2 and DRDA Remote DB2 performance issue.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Mainframe DB2 and DRDA Remote DB2 performance issue.
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: 1013
Location: India

PostPosted: Tue Jan 05, 2010 12:06 pm    Post subject:
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    Post subject: Reply to: Mainframe DB2 and DRDA Remote DB2 performance issu
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SIGNAL ON HALT issue packerm CLIST & REXX 0 Fri Oct 20, 2017 6:56 pm
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts How do I create a mainframe monitorin... anjali.bisht All Other Mainframe Topics 4 Fri Sep 01, 2017 2:20 pm
No new posts Mainframe dataset split purushottam DFSORT/ICETOOL 13 Tue Aug 29, 2017 12:28 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us