Michigan DB2 Users Group (MDUG)

clutteredreverandData Management

Oct 31, 2013 (3 years and 8 months ago)

101 views





Michigan DB2 Users Group (MDUG)

Quarterly Newsletter

May 2013



Keeping members up to date on

changes in the DB2 Environment”

MDUG
seminar
s

usually
feature topics

for

DB2 for z/OS and DB2 for LUW
.

As m
any
companies
utilize
DB2 on
the
Z/OS and Linux,
UNIX
, and Windows platforms
, members are
encouraged to attend presentations
that focus on both or either platform

to expand their
knowledge of DB2 across the OS spectru
m as well as
many features are common across the
DB2 family.


The upcoming
all day
seminar

on
May 15
th

at the
Crowne Plaza

in Novi
, MI

features
two

outstanding speakers
.


The
two
morning sessions will be presented by

IBM DB2 for z/OS
specialist

Robert Ca
tterall
. The first session
will cover


DB2 for z/OS Stored Procedures
Update

.
T
he second session will
cover


Memory for MIPS: Leveraging Big Memory on System
z to Enhance DB2 CPU Efficiency

.


The two afternoon sessions will be presented by Willie
Favero

of IBM. Willie’s first presentation

will be

on the

topic “
Data Warehousing w
ith DB2 for
z/OS Best Practices
”.

The second session will be about “
A deep dive into the real workings of
the DB2 Analytics Accelerator for z/
OS”.

The

day
should

be
very
info
rmative for all.



T
O REGISTER
:

S
end an
email to
reservations@mdug.org

with your name, your
membership type

(Corp, Vendor or Ind.)
, and if appropriate the number and name of additional
attendees
.

Reservation

d
eadline is
on
Friday
May 10
th
,

but if there are still seats
available reservations will be taken
up until noon
on Tuesday
May 14
th
.


A
TTENDANCE

F
EES
:

For MDUG members, the cost for attendance at the seminar is covered
by the yearly membership fee
, so make

sure to renew before or at the seminar.

For Non
-
members
the cost

is $
55

at the seminar, payment in either cash or check. Credit cards are not

accepted at the door. Please see the Membership section below in regard to paying via credit
card for membershi
ps.


MOST REQUESTED TOPIC
:


Using DB2 Stored Procedures

w
as

the most requested topic
based on the

December

201
2

seminar
meeting evaluations
.


G
ROUP SUPPORT
:
There is always a

need for volunteers

to support the ongoing activities of
the Group. Each yea
r
MDUG

need
new

volunteers
a
s

board members
retire and move on.
Without volunteers the group will be unable to continue operations.
Please s
ee
News for
Members

on

how
you can
volunteer.


Remember to keep current with D
B2 via the IDUG web page;
www.idug.org
.

Presently
Se
minar Dates
for 2013
:


Ma
y 15,

2013
@
The
Crowne Plaza

(Novi)

August 14, 2013

@

Location TBD

October 13, 2013

@

Location TBD

November 20,
2013
@

The Crowne Plaza (
Novi)



MDUG is an affiliate of IDUG (
international

DB2 User Group), and is chartered under the State of Michigan. It promotes the awareness of DB2 in
solving business problems by providing a non
-
profit forum for presenting new functionality, features, i
deas, and usage of DB2. This forum is used
for communications among DB2 users in the Southeastern Michigan area, as well as bringing together others through out the sta
te.






Michigan DB2 Users Group

P.O. Box 2977

Southfield, MI 48037
-
2977



Board of Di rectors:


Carol Li ttl e

Group Coordinat ion

Group & Membership Direct or

GreenSt ar Solut ions


Stel l a Keesl i ng

Finance Direct or

Comerica


Chuck Hi l l

Newslet t er &
Evaluat ion
s

Direct or

Ford Mot or Co.


Nhon Do

Direct or Web Sit e Support

Ford Mot or Co.


Mi ke McCarthy

Locat ion Direct or &

Advisory Support

IBM Corporat ion


Dave Mazza

Advisory Support

IBM Corporat ion


Ron Fl annery

Advisory Support

One Point Solut ions


Mark Rader

Advisory Support

IBM Corporat ion


Foundi ng Members:

IBM Corporat ion

Plat inum T
echnology







MDUG


2

May 2013




May 15,

201
3

-

Seminar Agenda



8:15 am


9:00 am

Check In / Continental Breakfa
st




9:00 am


9:05 am

Welcome and Opening Remarks


9
:0
5

am



10:
20

am

"
DB2 for z/OS Stored Procedures Update
"


Speaker:



Robert Catterall
(
IBM
)


10
:
20

am



10
:
40

am

Break


10
:
40

a
m



1
1
:
55

a
m

"
Memory for MIPS: Leveraging Big Memory on System z to
Enhance DB2 CPU Efficiency



Speaker:


Robert Catterall
(
IBM
)



12
:
00

p
m


1
:
00

pm

Lunch



included as part of the seminar




1:00

pm


2:
15

pm


"
Data Warehousing w
ith DB2 for z/OS Best Practices
"



Speakers:
Willie Favero (IBM)



2
:
15

pm



2
:
30

pm

Break


2
:
30

pm


3
:
45

pm

"
A deep dive into the real workings of the DB2 Analytics
Accelerator for z/OS



Speaker:



Willie Favero

(
IBM
)




Last Seminar
:
Feedback from the last MDUG seminar, held on Thursday,
December
6
th

is

available in the
News for Memb
ers

section of th
is

newsletter. Presentations are still
available online at:
www.mdug.org

under the

Past Seminars


s
ection.









MDUG


3

May 2013






Presentation Abstracts


Presentation #1:


DB2 for z/OS Stored Procedures Up
date


Abstract:

Stored procedures have been widely used for years in DB2 for Linux, UNIX, and Windows
application environments. On the mainframe side, adoption of the technology was initially
more limited, but it is becoming mainstream now, in part due
to the advent of native SQL
procedures, delivered with DB2 9 for z/OS and enhanced with DB2 10. This presentation will
lay out a vision of a modern DB2 data
-
serving system in which stored procedures play an
important role. It will also provide a review of
DB2 for z/OS stored procedure enhancements,
with a particular emphasis on the advantages of native SQL procedures. The presentation will
conclude with some hints, tips, and recommendations concerning stored procedure
development and management.


Presentati
on #2:


Memory for MIPS: Leveraging Big Memory on System z to Enhance DB2 CPU
Efficiency


Abstract:

System z server memory is getting bigger all the time (a zEC12 can be configured with 3 TB
of the stuff), and it's more and more common to find z/OS LPA
Rs with scores of gigabytes of
real storage; however, at many DB2 for z/OS sites mainframe memory is an under
-
utilized
resource, in that it's not leveraged for maximum performance benefit. In this session you'll get
information on how to use real storage t
o reduce DB2
-
related CPU consumption by 1) getting
your buffer pool house in order (i.e., getting the most out of your buffer pool configuration
without making it larger), 2) being bold
--

but not reckless
--

in asking for more memory for
DB2 buffer pools
to reduce I/O activity, and 3) using storage for threads, dynamic SQL, RID
processing, and sorting in a CPU
-
savvy way.


Presentation #
3
:



Data Warehousing with DB2 for z/OS Best Practices


Abstract
:

Data warehousing with DB2 for z/OS on System z is getti
ng a lot of interest today. However,
that interest is also generating a lot of questions. If you want to put your warehouse on System
z using DB2, or if you already have a warehouse on System z, you may want to know the Best
MDUG


4

May 2013




Practices that have been learne
d over the years. This presentation will help answer your
questions about doing warehousing on System z successfully. Some examples of what we will
be discussing are DB2s DSNZPARMs, buffer pools, table space choices, caching structures,
sorting, and utilit
y processing. We'll also examine query performance, SQL structure choices,
and SQL analysis along with looking at some of the tools available.


Presentation #
4
:


A deep dive into the real workings of the DB2 Analytics Accelerator for z/OS


Abstract
:

This
session discusses the IBM DB2 Analytics Accelerator V3 that enables a new class of
high speed business intelligence and analytic queries on System z. The innovative technology
within the DB2 Analytics Accelerator offers organizations the ability to integra
te business
insights into the fabric of their operational processes while accelerating queries, making
business insights more accessible to the front lines of business. This presentation discusses
what is new in Version 3 of the DB2 Analytics Accelerator,
how to implement it, how it really
works, and how to take advantage of it. The presentation is based on hands
-
on experience.




Speaker
Biographies

Robert

Catterall

(
IBM
)

Robert Catterall is an IBM DB2 for z/OS specialist. He started his IT career with IBM

in 1982,
and worked throughout the 1990s as a member of the Company's DB2 for z/OS National
Technical Support team. From 2000 to 2007, Robert worked as a database technology
strategist for CheckFree (now part of Fiserv). After working for three years as a
n independent
DB2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, a member of
IDUG's Speakers Hall of Fame, and was one of IBM's inaugural Information Champions. He
presents frequently at conferences, is a longtime columnist for IB
M Data Magazine, and blogs
about DB2 for z/OS at http://robertsdb2blog.blogspot.com/.



Willie

Favero

(IBM)


Willie Favero is currently the DB2 for z/OS SME working with the Data Warehouse on System
z Swat Team at IBM's Silicon Valley Lab. He has almost 4
0 years Mainframes experience,
with almost 30 years of that working with DB2. He frequently presents at major conferences
worldwide and local user groups, often publishes articles in national magazines, authors
Redbooks, and maintains one of the top DB2 b
logs on the Net
.









MDUG


5

May 2013








Presentation Handouts
:

S
eminar presentation

copies

will be made
be available in Soft copy
, as available,

prior
to the
seminar and will be posted on the MDUG web site as they are made available.
If posted, the
presentations
sh
ould

be downloaded and printed from the MDUG web site
www.mdug.org

and brought to the seminar as these speakers will not be bringing hard copies to the seminar.

Please check the web site for the presentations prior to
the seminar.


Seminar
Logistics
:

Seminar onsite

check in begins at 8:15 am and the seminar will begin at 9:00am. The cost of
the seminar is covered by
the
yearly membership fee, if you are a member, and includes a
continental breakfast and lunch. Th
e cost for non
-
members is $
55

and covers
attendance at
the seminar,
the
continental breakfast and lunch.


Maps and directions to the
Crowne Plaza

Hotel
are available at the MDUG web site:
www.mdug.org



Registrations
:


You can register yourself and/or your site/Company attendees by sending an email with your
full name, company name, and registration count (if making reservations from more then
yourself) to
reservations@mdug.
org
. Please include the name of all attendees in the email
message and the
type of membership
; corporate, individual or vendor
that you will be attending under
. Confirmation is available upon request only.
Early
registration
for the seminar
will be ta
ken until the end of the day on
May 10
th


(
Friday

before
the seminar).

Late registration until noon on Tuesday,
May 14
th
, if s
eating
is still available.
R
espond early to guarantee
yourself

a spot.



















MDUG


6

May 2013








N
ews for Members
:


1.

Seminar Fee
dback

(based on
16

eval
uations

turned in
)

from

the

December

2012

Evaluations

(used for Planning purposes)
:



# Responses

by Potential Future
Topic
s

5



Using Stored Procedures

4

DB2 Application Tuning

4




DB2 Experiences

4




DB2 Performance and Tuni
ng

4



New DB2 Releases

4

Supporting DB2

3


DB2 Disaster Recovery

3


DB2 Performance Tools

3

DB2 Programming/Application Dvlp

3

DB2 Utilities

2

DB2 Warehousing

1


DB2 Experiences

1

DB2 Interconnectivity

1

DB2 Supporting Software

1



DB2 Using C
ICS/IMS

0


Other (i.e. Test DB
-
Data Refreshes?;)

0

SQL



2.

December

201
2

Seminar Speakers Feedback

Rating based on a scale of 1


5 with 5 as the highest rating.



Ed Woods



Understanding, Monitoring and Managing z/OS Enclaves







Topic
Value

Sessi
on
Content

Speaker

Material
Covered

Handouts

Visuals

4.67

4.60

4.93

4.73

4.53

4.47







Ed Woods



Understanding the Impact of the Network on z/OS Performance

MDUG


7

May 2013




Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

4.63

4.50

4.88

4.56

4.
38

4.63







Shantan Kethireddy


Investing in Information Integration and Business Analytics on
DB2 for z/OS to Achieve a Competitive Advantage


































Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

3.57

4.25

4.25

4.00

4.13

4.13















3.

MDUG Membership

There are four types of memberships; Individual, corporate, vendor and shared.

Memberships are
annual
and run
from January through December

and allow for attendance at
all four seminars.
MDU
G accepts

payment
directly
in cash or check

and through the mail by
check.

Checks should be made payable to Michigan DB2 User Group (MDUG).
Credit
cards are accepted only through
PayPal
and must be coordinated with MDUG and cover the
additional cost of
processing. Contact
a
MDUG
Director
at a seminar or through

admin@mdug.org

for details.

All memberships are contin
g
ent on payment of the annual
membership fee




Membership forms along with membership details can be
downloaded from the MDUG web
site
www.mdug.org

by clicking on the
Membership and Fees
,

then
clicking on the left side of
the
Home Page
. Inquiries on the status of corporate/company memberships should be sent
to the MDU
G email box at
admin@mdug.org
email box at
admin@mdug.org
.
Invoices
for
2013 w
ere

being

sent to members on record for 201
2

in January 201
3
. If you or your
company
were not a me
mber in 2012, and you
need an invoice for
next

year, email MDUG at
admin@mdug.org
, and
one will be emailed to you
.



4
.

Group Support


Volunteers are the
heart of any non
-
pro
fit

group. Th
is is especially true

for
M
DUG. Without
volunteers to handle the affairs of the group,
the group
wouldn’t exist.
Group membership fees
only provide enough income to cover the costs for holding the seminars, and others things
such as the web site

and the

PO Box, which are requir
ed
for the group’s operation. There isn’t
enough income to pay someone to find speakers, pay bills, coordinate activities, etc.

As always MDUG needs more volunteers to keep operating.
Volunteering is a good way to
find out more about the group operations
and expand your

skills.
If you can volunteer to
support the group’s activities
next year, please let us know.
Many of the support activities can
be done from your home or desk and many do not take more then a few hours a month. Even
MDUG Board meetings
can be done from you
r

desk, as all meeting
s

are
held

via telecom

and
MDUG


8

May 2013




usually not more than once a month.
And supporting the group allows you to attend the
seminars at no cost.


A few of the areas where you
could

help out are:
supporting the web site,
taking reservations,
suggesting topics/speakers,
management of the group emails, group c
oordinat
ion
,
providing
onsite support
at the seminar
, handling evaluations,
and
speaker introductions
.

We hope you
will t
alk to one of the red ribbon wearers at the se
minar about how you
can
volunteer
or
send
an email
with your contact information
to
admin@mdug.org

asking where you can help
out

or
just that you want to discuss
v
olunteering with someone on the board.
We will get b
ack to you.