SWARUG Meeting: April 2, 2014
In an effort to try and attract both z/OS and LUW users, we are trying a new format for this meeting: We will have a 90-minute z/OS session from 10:30 - 12:00; lunch/networking from 12:00 - 1:00, followed by a 90-minute LUW session from 1:00 - 2:30. If you are only interested in the z/OS content, feel free to leave after lunch; if LUW is your cup of tea, you can show up at noon for lunch and then see the LUW session.
Update: IDUG is donating a full conference pass for the IDUG DB2 Technical Conference that is taking place in Phoenix from May 12-15 – this is a $2,000 value! We will be raffling giving this pass away to one of the attendees at the end of the meeting.
CA’s offices are located at 4343 N. Scottsdale Road, Suite 355, Scottdale, AZ 85251. We will be meeting in the Executive Meeting Room.
10:30 — “Using DB2 9 Native SQL Stored Procedures” (Bob Andresen, CA)
12:00 — Lunch / Networking
1:00 — “Automation Everywhere: A DB2 Scripting Roundup” (Fred Sobotka, FRS Consulting)
If you’d like to attend, please RSVP by sending an email to firstname.lastname@example.org that includes your name, email and the company that you work for.
— Ian Bjorhovde
Using DB2 9 Native SQL Stored Procedures
Native SQL stored procedures are new for DB2 9. They offer less overhead, are zIIP eligible and are easier to write, in short a win/win/win situation. We will cover the writing and definition of native SQL stored procedures and discuss the new capabilities for versioning these procedures. We will also cover the new SQLFORMAT option and new coding support for Extended GOTO and Nested compound statements. Next we will look at testing and debugging capabilities, including a sample Rexx exec to quickly verify the functionality of the new procedures quickly. Measuring and monitoring resource consumption will be covered. We will then cover deployment commands and migration from existing external SQL procedures to the new native SQL procedures. Finally we will discuss documentation resources that to learn more about native SQL stored procedures.
Automation Everywhere: A DB2 Scripting Roundup
- What will and won’t work with DB2 CLP and CLPPlus
- Demystifying classic UNIX tools, including Perl, sed, awk, and xargs
- Windows PowerShell with (or instead of) Cygwin
- Patterns for configuration management and rapid deployment
- Scripting considerations for monitoring local and remote DB2 resources
About Bob Andresen:
Robert Andresen is a Technology Specialist with CA. He has been working in performance management and monitoring for several software companies since 1997 and has been supporting mainframe systems since 1976 in various capacities including being a zOS/CICS/DB2 Systems Programmer.. He is a co-author of the IBM Redbook: Linux on IBM @server zSeries and S/390: System Management. He has presented at IDUG, CMG, the IBM zOS Conference and LinuxWorld as well as many local and regional user groups. He holds a degree in Mathematics from the Illinois Institute of Technology. He is certified as an IBM Certified Database Administrator, DB2 9 for z/OS, an IBM Certified SOA Associate and also is ITIL Foundation Certified. At CA he has been supporting their suite of DB2 for z/OS tools for the past year. His areas of expertise include z/OS, DB2, CICS, UNIX/Linux, Windows, Websphere MQ and Networking.
About Fred Sobotka:
Fred Sobotka is the President of FRS Consulting, an IBM business partner
specializing in DB2 performance tuning, pureScale clustering, XML
enablement, and Oracle to DB2 migrations. He is an IBM Gold
Consultant, an IBM Data Champion, and an award-winning IDUG speaker
who presents regularly at DB2 conferences across North America and