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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts SNMP trap from Mainframe bipinpeter Compuware & Other Tools 6 Wed Apr 26, 2017 3:05 pm
This topic is locked: you cannot edit posts or make replies. Mainframe Opening in Allianz India- T... Rajesh Gopinathan Mainframe Jobs 0 Wed Apr 19, 2017 11:33 am
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 7 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm


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