Articles & Content
Topic: 2009 EU
Subtopic: DB2 for z/OS
DATE: 2009-10-6 (08:30 - 09:30)
SPEAKERS: Zeljen Stanic (CA)
DDF is the DB2 UDB for z/OS transaction manager for distributed database connections. Cheaper z/OS mainframe IP network hardware has led to growing volumes of TCP/IP traffic to and from your z/OS DB2 systems. Why should you - a DB2 expert - care about TCP/IP? Because a network-centric perspective of your DB2 DDF activity can complement the value of your DB2-specific tools by helping with DB2 problem determination. Mainframe network management products can do tasks like measuring DDF traffic throughput, raising alarms on DDF connection problems, tracing DDF TCP/IP packets, and formatting the traced DRDA conversations. Mainframe IP network data can help you answer DB2 questions like these:- What remote hosts do all my DB2 connections come from? (and what are the busiest connections right now?)- Is the rate of DB2 connection requests causing system stress?- Which DB2 subsystem has the most IP traffic?- What network interfaces is IP traffic from this DB2 flowing
EXP. LEVEL: Beginner,Intermediate
Discover what remote hosts do all my DB2 connections come from? (and what are the busiest connections right now?)
Discover which DB2 subsystem has the most IP traffic?What network interfaces is IP traffic from this DB2 flowing over?
Find out how can I match a DDF connection to its LUOW ID, thread and enclave information?
Does it look like z/OS DB2 could be to blame for this slow end-to-end response time or is it a network problem?
Finally, are best practices being followed with DB2 password encryption, client accounting, and commit processing?
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.