DB2 for System i (iSeries, AS/400)

Posted by Frank Fillmore on June 9, 2011 under DB2 Connect, DB2 for i. Tags: , , , .

Jim Tonchick had this recent post on DB2-L in response to a query from Dan Luksetich regarding DB2 for iSeries:

>> Yep, we’re out here.  But this forum is mostly for z/OS and LUW.  There are some iSeries forums, but DB2 is not the main focus. 

>> DB2 for iSeries is IBM’s best kept secret.  Every iSeries lpar has DB2 by default.  It comes with the operating system as the default file manager.  Even though it is on every instance of the i5 operating system, it is not covered by IBM at the OnDemand Conference or at IDUG’s conferences.  Even the IBM’s DB2 Family web site does not mention it (http://www-01.ibm.com/software/data/db2/).  You have to do to the IBM System i software path to find it (http://www-03.ibm.com/systems/i/software/db2/).  That’s a shame because DB2 for iSeries fits into the the DB2 family very well and can be a part of a distributed DRDA based application.

>> I attended IDUG NA 2011 in May and asked around why DB2 for iSeries was not even mentioned let alone represented.  The answers I received ranged from “not our target market” to “DB2 runs on the iSeries?”.  I’m glad to see someone in the industry finally take notice.

I agree that this member of the DB2 “family” is neglected.  For those of you who have been attending the DB2 Connect Virtual Users Group, DB2 Connect enables Distributed Relational Database Architecture (DRDA) between System i and DB2 for Linux, Unix, Windows because System i is EBCDIC-based (as is z/OS).

There’s a great manual for explaining the duality (split personality?) of DB2 for System i: “DB2 Universal Database for iSeries Database Performance and Query Optimization”.  It discusses the legacy Classic Query Engine (CQE) as well as the more-DB2-like SQL Query Engine (SQE).

There are also Redbooks

  • “OnDemand SQL Performance Analysis Simplified on DB2 for i5/OS in V5R4” (SG24-7326)
  • “SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries” (SG24-6654)
  • “Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS” (SG24-6598)

Finally there’s “SQL Reference for Cross-Platform Development” which takes the place of FREDS (Formal Register of Existing Differences of SQL – believe it or not!).  This manual compares the SQL dialects for

  1. Version 9 of DB2 for z/OS
  2. Version 6.1 of DB2 for IBM i
  3. Version 9.5 of DB2 for the Linux, UNIX and Windows Platforms

JCC Trace Formater for DB2 Connect and DB2 for LUW

Posted by Frank Fillmore on May 20, 2011 under DB2 Connect, DB2 for Linux Unix Windows, DB2 for z/OS. Tags: , .

The Java Call Control (JCC) trace formater referenced in Melanie Stopfer’s DB2 Connect presentation for the Virtual Users Group is available for download.  jcctraceformater  Instructions are contained in the Readme file.

Upcoming DB2 Connect Training – June 21 (2 seats left!)

Posted by Frank Fillmore on May 19, 2011 under DB2 Connect, DB2 Education, DB2 for z/OS. Tags: , , , .

The next section of IBM Authorized Training course “DB2 Connect 9 to DB2 for z/OS DRDA Implementation with TCP/IP” will begin on Tuesday, June 21.  The course will be held at our Towson, MD USA classroom.  For full details on course topics and enrollment, click here.

DB2 Connect Virtual Users Group – “Help Me, Help You – DRDA Connections to DB2 for z/OS”

Posted by Frank Fillmore on May 19, 2011 under Authorized Training Partner, DB2 Connect, DB2 Education, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

Many thanks to Melanie Stopfer of IBM for a terrific presentation today for the DB2 Connect Virtual Users Group.  There were over 225 attendees from around the world.

Obviously channeling Jerry Maguire, “Help Me, Help You – DRDA Connections to DB2 for z/OS” was a great survey of the tools and techniques useful for determining bottlenecks and other problems within a Distributed Relational Database Architecture (DRDA) topology.  Here are Melanie’s presentation materials: db2-connect-virtual-users-group-stopfer-05-19-11

We hope to have Melanie join us again for future topics like “You.  Connect.  Me.” and “You had me at SQL30081N”.

DB2 Connect VUG – Melanie Stopfer

Posted by Kim May on May 13, 2011 under Uncategorized. Tags: , , , , .

Registration for Melanie Stopfer’s DB2 Connect Virtual Users Group meeting, scheduled for this coming Thursday, May 19th at 12:00pm EDT, is available now.  Please click here to join us.

Upcoming Training Classes

Posted by Kim May on April 21, 2011 under Authorized Training Partner, DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, InfoSphere. Tags: , , , , , , , , .

The Fillmore Group’s Frank Fillmore has been delivering training classes on IBM’s behalf for so many years that the team here at TFG has the drill down cold:  get the IBM enrollment reports once or twice a week and figure out which classes are likely to run, advertise the ones that look promising, then cross our fingers and hope the enrollment is sufficient to be able to notify the students that class is ON!!

From there it is off to the store to stock up on sodas and treats for Donna and planning on a weekend in the classroom to do the lab set-up for Frank (sorry, Frank!)  When everything is set and the students arrive, Frank goes into delivery mode and somehow stays focused in spite of lab malfunctions, power outages and jetlagged students.   

Over the past two years we’ve seen class enrollment going up, just a bit.  I hope that as you read this you will give some thought to the benefits of IBM Information Management training.  We work really hard to deliver a great experience to everyone who comes to Towson for a class.  We have Information Server (DX447), DataStage (DX444) and DB2 Connect (CF602) classes coming up.

DB2 Connect VUG Date and Time Announced

Posted by Kim May on March 30, 2011 under DB2 Connect, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , , , .

IBM DB2 Connect expert Melanie Stopfer’s Presentation, “Help Me, Help You – DRDA Connections to DB2 for z/OS” will be delivered to the DB2 Connect Virtual Users Group on Tuesday, April 27th, from 12:00pm-1:00pm EDT.  All are welcome to join us for this webinar.  Register here.

Abstract:
Do you want to better understand and tune your remote DRDA connections to DB2 z/OS? Are you looking for tips to make your life easier?  Melanie will present analogies and insider advice to help improve performance, availability, reliability, and usability. The goal is to provide you with an arsenal of tips you can use in various remote DRDA distributed to DB2 z/OS situations.  Come learn new DB2 Connect and JDBC Universal Driver tips and tricks that you need to know.

Read More…

DB2 Connect Virtual Users Group – Melanie Stopfer

Posted by Kim May on March 18, 2011 under DB2 Connect, DB2 Education, International DB2 Users Group (IDUG), Uncategorized. Tags: , , , , , .

IBM’s Melanie Stopfer has volunteered to present at the next DB2 Connect VUG session.  Melanie’s presentation is titled, “Help Me, Help You, Remote DRDA Connections to DB2 z/OS“.    The session abstract and objectives are below, along with Melanie’s bio.  I hope you will join us!

Abstract:
Do you want to better understand and tune your remote DRDA connections to DB2 z/OS? Are you looking for tips to make your life easier?  Melanie will present analogies and insider advice to help improve performance, availability, reliability, and usability. The goal is to provide you with an arsenal of tips you can use in various remote DRDA distributed to DB2 z/OS situations.  Come learn new DB2 Connect and JDBC Universal Driver tips and tricks that you need to know.

Read More…

Virtual Users Group “DB2 Connect: History, Today’s Functionality, and What’s Next”

Posted by Frank Fillmore on December 14, 2010 under DB2 Connect, DB2 Education, DB2 for i, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

Curt Cotner presents DB2 Connect from a technical, historical perspective.  In his presentation Curt explains how DB2 Connect evolved as a technical solution, describes the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt looks at what the future holds for DB2 Connect.  Curt covers best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

db2-connect-history-dec-2010

Also, we would like to thank everyone for volunteering.  We are hoping to have three meetings a year and will be posting them through the IDUG website.  A special thanks to Michael McBride for all of this assistance with the website.

Please feel free to invite your friends and colleagues to join the Virtual Users Group!  Contact Blaire Crowley at blaire.crowley@thefillmoregroup.com for details.

DB2 Connect Virtual Users Group Inaugural Meeting on December 14

Posted by Frank Fillmore on November 24, 2010 under DB2 Connect, DB2 for i, DB2 for Linux Unix Windows, DB2 for VSE&VM, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , .

“DB2 Connect, History, Today’s Functionality, and What’s Next”

Tuesday, December 14, 2010 from 11:30 a.m. to 1:00 p.m. (US) Eastern Standard Time

IBM Fellow Curt Cotner will present DB2 Connect from a technical, historical perspective.  In his presentation Curt will explain how DB2 Connect evolved as a technical solution, describe the changes to DB2 Connect and why organizations should consider eliminating the gateway.  Curt will finish the presentation with a look at what the future holds for DB2 Connect.  Curt will cover best practices for moving from three-tier DB2 Connect topology using a gateway to the recommended two-tier architecture so attendees can begin to figure out how to get their organization from here to there.

The presentation will be delivered online via GoToWebinar.  Click here to register.