Atlanta Db2 Users,
Mark your calendars for our next meeting, it will be June the 8th at the IBM center where we have been having our meetings. We are working on the agenda right now so keep watch for another newsletter.
So, mark your calendars for our June 8th meeting and below are some other events you may be interested in…
Thanks, Ted & the ADUG board.
The following are a list of upcoming events: Thanks to Stan Muse of IBM for sending these meetings in.
April 10th: The Alabama Db2 Users groups next meeting is next week on the 10th of April and details are listed below
April 18th: ** COBOL Migration and Performance Tuning Workshop - Live in Chicago on April 18th!!**
April 18 - 19, 2018 - Markham, Ontario - Db2 for z/OS Wildfire Workshops for Cloud & Mobile Applications (CMDb21) = If interested please contact Stan Muse at SMUSE@US.IBM.COM
April 28 – May 3 - International Db2 Users Group – North America meeting Philadelphia Pennsylvania - https://www.idug.org/na2018 - hope to see you there.
May 15 - 16, 2018 - New York, NY - Db2 for z/OS Wildfire Workshops for Cloud & Mobile Applications (CMDb21) - If interested please contact Stan Muse at SMUSE@US.IBM.COM
June 19 - 20, 2018 - Chicago, IL - Db2 for z/OS Wildfire Workshops for Cloud & Mobile Applications (CMDb21) - If interested please contact Stan Muse at SMUSE@US.IBM.COM
7/24-7/27 McLean, VA Securing and Encrypting Network Traffic to z/OS Communications Server with Policy Agent If interested please contact Stan Muse at SMUSE@US.IBM.COM
8/21-8/24 Cincinnati, OH Securing and Encrypting Network Traffic to z/OS Communications Server with Policy Agent If interested please contact Stan Muse at SMUSE@US.IBM.COM
---------------- DETAILS ---------------------------
ALABAMA Db2 USER’S GROUP
APRIL 10, 2018
RSVP today to take advantage of training featuring Tony Andrews, Kai Stroh and Judy Nall.
LUNCH – Provided by UBS–HAINER
One attendee will win a free pass to attend IDUG Tech Conference in Philadelphia, PA April 29 - May 3.
Meeting Location : Aldridge Gardens
3530 Lorna Rd, Hoover, AL 35216
Reply or RSVP to :treasurer@alabamaDb2usersgroup.org
8:30 - 8:45 AM Registration, Continental Breakfast
8:45 - 9:15 Larry Long, Welcome and Opening Meeting Comments
9:15 - 10:30 Tony Andrews, Themis Inc .
“ Db2 Advanced Query Tuning with IBM Data Studio”
This presentation is designed for the Db2 development professional who desires to understand the fundamental issues associated with performance for Db2 SQL applications.
10:30 - 10:45 Break
10:45 - Noon Tony Andrews, Themis Inc .
“Advanced SQL and the Power of SQL Rewrites”
This session will cover a number of examples in writing queries different ways and break down the different processing of the queries within Db2.
Noon - 1:00PM LUNCH –Provided by UBS – HAINER – Thank You !!!!
1:00 - 2:15 Judy Nall, Computer Business International, Inc.
“North American IDUG Conference and Drawing Information”
This short session is about the North American IDUG conference.
“Interactive IBM Db2 11 Application Developer Workshop”
Do you have the answers to these Application Developer Questions? How well would you score on the Certification Exam? Let’s take some questions and work through the answersusing group discussion.
2:15 - 2:30 Break
2:30 - 3:45 Kai Stroh - USB-HAINER
“ Copy Smarter - Unload/Load, DSN1COPY and Beyond”
We will discuss setting up a refresh process for thousands of Db2 z/OS tables and the advantages and disadvantages of different utilities that copy Db2 data.
3:45 IDUG Drawing and Meeting Wrap-Up
SPEAKER: Kai Stroh, UBS-HAINER
Kai earned a Computer Science degree from the University of Darmstadt and is a mainframe software developer specializing in Db2 utilities for z/OS. He designs and builds innovative Db2 applications and utilities often working onsite or remotely with UBS’ international clients. He easily navigates his way around Db2 dumps and knows how to move data and definitions across Db2 versions, and this includes the unique in-house Db2 subsystems which each have their own little technical adaptations.
Presentation Extract : “ Copy Smarter - Unload/Load, DSN1COPY and Beyond”.
We will discuss setting up a refresh process for thousands of Db2 z/OS tables and the advantages and disadvantages of different utilities that copy Db2 data. The main focus will be on automating all the side tasks that DBAs usually need to do in addition to copying the data itself.
SPEAKER: Tony Andrews, Themis Inc.
Tony has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘Db2 SQL Tuning Tips for z/OS Developers’ published by Pearson Publishing IBM Press.
Presentation Extract: “Db2 Advanced Query Tuning with IBM Data Studio”
This presentation is designed for the Db2 development professional who desires to understand the fundamental issues associated with performance for Db2 SQL applications. Emphasis is placed on understanding optimization and the many access paths chosen by the optimizer, along with how to read and understand these access paths using the IBM Data Studio tool.
Performance related issues in the areas of database design, indexing, application SQL coding, and data statistics will be addressed.
Presentation Extract: “Advanced SQL and the Power of SQL Rewrites”
When trying to get a query to run more efficiently, we somehow need to get the current access path to change and execute differently. One way that often works is rewriting the query a different way. Many developers cannot think of different ways to rewrite queries, and sometimes there may not always be a different way to rewrite a query. But in SQL programming, we can never have enough examples of SQL code. This session will cover a number of examples in writing queries different ways and break down the different processing of the queries within Db2.
SPEAKER: Judy Nall, Computer Business International, Inc.
Judy H. Nall works with Computer Business International, Inc. and is an internationally recognized Db2 lecturer, consultant, writer and educator. She has been awarded a Gold Team membership by IBM. These individuals have demonstrated technical leadership, vast industry expertise, market knowledge and a strong digital presence. Gold Team Partners will align on strategy, priorities and initiatives to contribute to the collective benefit of clients. Judy is an IBM Data Champion for Analytics. IBM Champions demonstrate both expertise in and extraordinary support and advocacy for IBM technology, communities, and solutions.
Presentation Extract: “North American IDUG Conference and Drawing for Conference Pass"
A short presentation on the upcoming conference inPhiladelphia, Pennsylvania, April 29 - May 03, 2018. There will be a drawing at the end of the meeting for a free conference pass! There are some rules to qualify and we will take a look at those requirements.
Presentation Extract: “Interactive IBM Db2 11 Application Developer Workshop”
Test your knowledge! We have heard a lot about SQL today. Let’s use that information and begin to prepare for IBM certification. This is an interactive presentation where questions for IBM Db2 11 Application Developer for z/OS Certification Exam will be presented and we will work through the answers. Get your thinking hat ready!
** COBOL Migration and Performance Tuning Workshop - Live in Chicago on April 18th!!**
We will be hosting an Enterprise COBOL V6 migration workshop and debuting our new Performance Tuning Workshop live for customers in the Chicago area. With Enterprise COBOL V4.2 withdrawn from marketing on March 12th, clients are more motivated to plan their migration to Enterprise COBOL V6. These workshops will help them understand how best to plan their migrations and how to take advantage of advanced optimization technology in the COBOL V6 compiler to increase performance of business critical applications and reduce CPU usage. SMEs will be available to answer questions from audience.
What will be covered...... The Migration workshop will cover the latest IBM recommendations and best practices to help with your migration to Enterprise COBOL V6. The new Enterprise COBOL compiler has new capabilities to optimize code to take full advantage of IBM Z mainframes (including the latest z14), — to pprovide a significant CPU reduction for running business critical COBOL applications. This workshop will provide a technology overview of the COBOL v6 and information to help you plan for a successful migration. We will also share best practices from client engagements. The Performance Tuning Workshop will cover an overview of the advanced optimization technology shipped in COBOL v6 and how best to leverage it to improve the performance of your COBOL applications and reduce CPU usage. We will also discuss the advantages and drawbacks of optimization options. Confirm your spot in this live event. Get migration and performance tuning information and your questions answered directly from COBOL SMEs!
The migration workshop will be delivered by one of our highly knowledgeable COBOL experts - Tom Ross ("Captain COBOL"). Tom is a senior software engineer on the IBM COBOL development team. Tom has spent his entire 35 year career at IBM in COBOL development, working on the compiler and run-time libraries for every release of VS COBOL II, COBOL for OS/390 & VM, and Enterprise COBOL. Tom is an expert when it comes to understanding migration challenges for Enterprise COBOL and Language Environment on z/OS. Tom is also a frequent speaker at user groups and is the IBM representative for COBOL to SHARE.
The performance tuning session will be delivered by Iain Ireland. Iain has been at IBM for four years, working as a developer on the Enterprise COBOL code generator and optimizer. He has spent the past three years as the performance guru, working to make programs compiled by Enterprise COBOL run as fast as possible. Iain has a lot of experience on how to leverage the optimization technology in the COBOL V6 compiler to increase performance and reduce CPU.
What you will need to do..... 'Reply' to this email indicating your company name and the names of those who will be attending from your organization. There will be a limited number of seats available, so please confirm your attendance promptly if you want to secure a seat. Location details and start time will be forwarded a week before the workshop and will confirm your seat.
Audience: Customers, Business Partners and IBM
Duration: Approximately 3.0 hours (half-day)
Date: Wednesday, April 18th
Start Time: To be forwarded with seat confirmation
Confirm your attendance via email to firstname.lastname@example.org
For questions contact Robert Barrington at email@example.com
Securing and Encrypting Network Traffic to z/OS Communications Server with Policy Agent
Are you intimidated by all the security mandates requiring that data be securely transferred across your network?
Does your technical z/OS Communications Server Staff need to boost their confidence in implementing encrypted
transmissions to/from z/OS?
Could your z/OS Communications Server system programmers use a "jump start" in working with digital certificates
and deploying Secured Sockets Layer (or related technologies), IP Security (IP Filtering and VPNs), and Intrusion
If so, send them to the "no-tuition" offering of the hands-on workshop named "Securing and Encrypting
Network Traffic to z/OS Communications Server with Policy Agent", where they will perform these tasks successfully!
Enrollment is By Invitation Only - Only IBM representatives and Business Partners are allowed to enroll their invited
customers in this workshop. This is a STANDBY course and, as such, all students are initially placed in a PENDED
status until all steps below have been completed.
DO NOT DELAY!
Please read all the information in the attached flyer before requesting consideration for enrollment
and review the week's agenda for more detail. Do not request enrollment if you cannot attend the
FULL class, as there are only 18 seats available in this intensive lab class.
Note the following rules for enrollment:.
- We limit the number of customers to 3 from a single account.
- The attendees must be at an intermediate to advanced technical level. (See prerequisites in the attached Flyer.)
- Nominations are through IBM Marketing Representatives, Client Technical Support Representatives, and Business Partners only.
For Nomination/Enrollment procedures: Please see the attached FLYER.
Two classes to choose from:
7/24-7/27 McLean, VA
8/21-8/24 Cincinnati, OH
ADUG Meeting June 8th and Other Events
ADUG Meeting June 8th and Other Events - Grp 2 - Yep with the Attachment this time.
Hello every one,
The Atlanta Db2 Users Group has secured a date for the next meeting and it is June 8th.
IBM will again be hosting us, Thanks to IBM and Stan Muse for taking care of the logistics.
The attached PDF has several other meetings for your calendar. The two most immediate are the
Alabama Db2 Users group on April the 10th, and the IDUG Meeting April 28th - May 3rd in Philadelphia, Pennsylvania. Check them out and if you have peers or coworkers in Birmingham and who might be interested in the IDUG meeting, please forward the PDF.
Ted, Sue, Rhonda, Stan, Robert and Rodger