TFG 2012 Training Schedule

Posted by Kim May on January 2, 2012 under Authorized Training Partner, DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, Q-Replication. Tags: , , , , , , .

Instructor-led classroom training is the most effective and reliable way to develop new data management skills.  The Fillmore Group delivers a select group of public IBM authorized training courses in our state of the art classroom in Towson, Maryland.  Invest in yourself and join us for a class in 2012. 

A list of classes scheduled for the first half of 2012 is attached.  Please feel free to contact me with questions on our training offerings.  In addition to these classes TFG delivers private onsite classes, classes via distance learning, and custom training to meet specific needs.

First Half 2012 IBM Information Management Training Word

DB2 Connect Virtual Users Group – Security Webinar Recording 2011-10-18

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

The October 18, 2011 recording of the DB2 Connect Virtual Users Group “Addressing DB2 Connect Security Issues” by Adam Koile and Mary Ann Ritosa of IBM can be found here.

http://www.channeldb2.com/video/db2-connect-virtual-users-group-2011-10-18-addressing-db2-connect

DB2 Connect Virtual Users Group – Security

Posted by Frank Fillmore on October 18, 2011 under DB2 Connect, DB2 Education, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , , .

Adam Koile and Mary Ann Ritosa of IBM will be presenting “DB2 Connect & DB2 for z/OS Security” today (Tuesday, October 18, 2011) at 12:00 noon EDT for 90 minutes.  If you haven’t already registered, click on this link: https://www2.gotomeeting.com/register/692406922

The presentation materials can be downloaded here: DB2 Connect Virtual Users Group 2011-10-18

DB2 Connect VUG Meeting Registration

Posted by Kim May on October 11, 2011 under DB2 Connect, DB2 Education, DB2 for Linux Unix Windows, DB2 for z/OS, International DB2 Users Group (IDUG). Tags: , , , .

“Addressing DB2 Connect Security Issues”

The next meeting of the DB2 Connect Virtual Users Group will be held Tuesday, October 18th, from 12:00pm-1:30pm EDT.  Register to attend here

This presentation has been prepared for the DB2 Connect Virtual Users Group by IBM DB2 Connect technical support analyst Adam Koile, a subject matter expert in DB2 Connect security, and Mary Ann Ritosa, IBM DB2 for z/OS technical support.   Read More…

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 *Reschedule Date*

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

Just announced:  new date and time for Melanie Stopfer’s DB2 Connect Virtual Users Group presentation:  Thursday, May 19th from 12:00pm to 1:00pm EDT.  The session abstract and Melanie’s bio are below; the registration link will be posted here Monday.

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.