Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Produce Mainframe Dash Board Reports ... sdcarlson53 All Other Mainframe Topics 2 Thu Jan 05, 2017 11:01 pm
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
This topic is locked: you cannot edit posts or make replies. Urgent Mainframe Requirments (2-10 yr... Shankar779 Mainframe Jobs 0 Sun Nov 27, 2016 1:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us