Michigan DB2 Users Group (MDUG)

laurelsandwichSoftware and s/w Development

Nov 25, 2013 (3 years and 9 months ago)

106 views



Michigan DB2 Users Group (MDUG)

Quarterly Newsletter


September

200
8



Keeping members up to date on

changes in the DB2 Environment”

Last
Seminar
:
The last MDUG seminar was held on Thursday, June 12.
Details on the seminar and attendees feedback are

available in the News
for Member
s

section. Hopeful
ly you attended. If not the presentations are
still available online at:
www.mdug.org
.

Next
Seminar:

MDUG will be holding their third seminar of 2008 on
September, 18
th

at the
Hotel
Baronette in Novi. Direction
s to the hotel are
available on the MDUG web site;
www.mdug.org
.

There will be two session tracks in the morning. One track will focus on
z/OS topics;
the

second track will cover the new version of DB2 for LUW
along
with a general DB2 topic focusing on data privacy, growth, and
archiving.

In the afternoon there will be an overview of the
InfoSphere

Warehouse

presented by Duane Azarovitz of IBM.
Then
Ron Flannery of One Point
Solutions will present the main concepts o
f
InfoSphere

and
finally
Matthew
Wallace

will do a live demo of the

warehouse
product.

See the topic abstracts and speakers bio's for details of this information
-
filled MDUG meeting.

************************************************************************
**************

Membership cost:

The c
ost for a
ttendance at the seminar is covered by
your yearly membership
, with corporate membership providing for up to 5
attendees

per seminar
.
I
f you plan to attend the seminar,
you need to
reserve a
seat
, s
o

please m
ake sure to register early
.

Last date for
registering is

Friday,

September 12
th
.

See
Registrations

section for
details.

Memberships can be paid prior to the seminar or at the seminar.
Details
on

membership are provided in the Member News section of

the
newsletter.

**************************************************************************************

Group Support
:
We always have a
need for volunteers
. See News for
members for how
you can
help out.




********************************************
******************************************
Final 2008 Seminar
:

December 11

@
The
Crowne Plaza

Hotel (Novi)



MDUG is an affiliate of IDUG (the International DB2 User Group), and is chartered under the State of Michigan. It promotes t
he awareness of
DB2 i
n solving business problems by providing a non
-
profit forum for presenting new functionality, features, ideas, and usage of DB2. This
forum is used for communications among DB2 users in the Southeastern Michigan area, as well as bringing together others t
hrough out the
state.






Michigan DB2 Users Group

P.O. Box 2977

Southfield, MI 48037
-
2977



Board of Directors:


Stella Keesling

Finance Director

Comerica


Pat Townsend

Director of Speakers

Computer
Consultant Co.


Chuck Hill

Newsletter &
Evaluation

Form

Director

Ford Motor Co.


Nhon Do

Director Web Site Support

Ford Motor Co.


Carol Little

Group Coordination

Group & Membership Director

GreenStar Solutions


Mike McCarthy

Location Director &

Advisory
Support

IBM Corporation


Dave Mazza

Advisory Support

IBM Corporation


John Sheppard

Advisory Support

IBM Corporation


Bill Robbins

Advisory Support

BMC Software


Ron Flannery

Advisory Support

One Point Solutions




Founding Members:

IBM Corporation

Platinu
m T
echnology







MDUG


MDUG

-

2

-


September 2008

September 18, 2008

-

Seminar Agenda


8:15 am


9:00 am

Check In / Continental Breakfast


9:00 am


9:05 am

Welcome and Opening Remarks

Track 1


DB2
z/OS

Topics



9:05 am


10:
25

am

"
Jumping into DB2 Traces and Performance M
onitors
"


Speaker:

Chris Skelnik

(
TransUnion
)



10:
25

am


10:45 am

Break


10:45 am


12:00 pm

"Green Light Go! Building your own DBA Dashboard
"


Speaker:

Chris Skelnik

(
TransUnion)




Track 2


LUW &
Generic
DB2

Topic


9:
0
5

am



10
:
25

am
"
DB2
V9.5 for LUW

-

What's New and how to Upgrade
"


Speaker:

Glen

Sheffield
(
IBM Toronto Software Lab
)



10:25

am


10:45

am

Break


10:45

am



12:00
pm

"
A Deeper Look at IBM Optim

Test Data Management
a
nd


Data Privac
y
"


Speaker:

Dave
Proksch

(
IBM
)



12:00 pm


1:00 pm

Lunch


A
fternoon


Single Track Sessions


1
:0
0

pm



1
:
20

p
m

"
Using IBM
InfoSphere

Warehouse 9.5 Edition to Integrate

Data and Easily Build and Manage DB2
-
based Data

Warehouses
"


Speaker:

Ron Fl
annery

(
One Point Solutions)


1
:
20

pm



2
:
15

p
m

"
Overview of Cognos
T
echn
ologies

and how they can be
used

with
DB2

LUW,
S
ystem i, and
M
ainframe
"


Speaker:

Duane Azarovitz (IBM)



2
:
15

pm


2
:
30

pm

Break


2
:
30

pm


3
:
45

pm

"
Cognos

Warehouse D
emo
"


Speaker:

Matthew Wallace

(Cognos)



MDUG


MDUG

-

3

-


September 2008

Presentation Abstracts


Jumping into DB2 Traces and Performance Monitors

This presentation is an introduction to DB2 Traces and Performance Monitors. You will get
an overview of the different traces that are avai
lable, and how to manage them. You will
also see the information that most DB2 performance monitors can display, and find out
how to use that information to help tune your applications and system. Various real
-
life
performance examples and tuning scenarios

will also be presented.


Green Light Go! Building your own DBA Dashboard

In most shops, DBAs need to access a variety of monitors, tools, and reports to get a feel
for how their DB2 for z/OS systems are running.

Given the complexity of DB2, finding the
pertinent information you need can be overwhelming, time
-
consuming, and sometimes
feels like trying to find a needle in a haystack.

Frustrated by these issues, we decided to
create our own DBA Dashboard.

This web
-
enabled portal pulls together existing
in
formation about applications, subsystems, DASD, DB2 internals, and more.

Written
using PHP and DB2, and complete with built
-
in charting tools, the Dashboard presents just
the information we deem important to troubleshoot, trend, monitor, and better manage

our
DB2 z/OS systems.

This presentation will describe what we did, why we did it, and how
you can do the same, along with plenty of examples of the Dashboard in action.


DB2
V9.5 f
or Linux,
UNIX
, and Windows
-

What's New and how to Upgrade

DB2 9.5 for LU
W raises the bar on advanced database capabilities.

An overview of the
new DB2 9.5 features and benefits will be discussed, including enhancements to XML,
Compression, Workload Management,

Security,

Autonomics, Performance, and

Application Development.

G
uidance for an easy upgrade from earlier versions of DB2 to

DB2 9.5 will also be presented.


A Deeper Look at IBM Optim Test Data Management and Data Privacy

Optim

Test Data Management and Data Privacy provides the end user with the ability to
create right

sized test data sets within the concept of a logical business object, as well as
to de
-
identify personally identifiable information. This session will dive into how Optim
works to create these data sets and protect private information in a test and develo
pment
environment via a combination of lecture and demonstration.


Using IBM
InfoSphere

Warehouse 9.5 Edition to Integrate D
ata and

Easily B
uild

and
Manage DB2
-
based Da
ta
W
arehouses

This presentation uses the article from MDUG board member and president of

One Point
Solutions, Ron Flannery, to summarize the latest features in version 9.5 of IBM
InfoSphere

Warehouse and IBM
InfoSphere

Balanced War
e
house. These tools provide a DB2
-
based
solution to create, manage, and implement data integration strategies wit
h IBM's DB2
-
based technology, which can organize and integrate data from System i, System z, and
numerous other sources. Ron's article can be found
a
t:

http://www.ibmdata
basemag.com/story/showArticle.jhtml?articleID=20990004



MDUG


MDUG

-

4

-


September 2008

Overview of Cognos techologies and how they can be used with DB2

LUW,
S
ystem
i, and
M
ainframe


A lot has changed since IBM bought Cognos. Find out how Cognos can integrate with a
variety of DB2 env
ironments, how performance can be optimized, and how to created an
integrated data environment, OLAP, reporting and dashboards.


Cognos

Warehouse Demo

A d
emo of Cognos and data integration, reporting,
dash boarding
, and OLAP from various
data sources

will
be presented
.

Find out via demo how simple it can be for Cognos and
Info
Sp
here War
e
house to create data flows and a wide variety of reports, dashboards,
and analytics.


Speaker
Biographies


Chris

S
kelnik

(
TransUnion
)


Chris Skelnik has 23 years of large sy
stem database development experience, the last 18
of which have been spent as a DB2 Database Administrator.

His background includes
application development and project management.

As a Sr. DBA at TransUnion, Chris is
part of a team responsible for mainta
ining and tuning one of the largest DB2 databases in
the world.

Before joining TransUnion, Chris spent many years as a consultant, working
with various clients on database design, SQL coding, and performance and tuning issues,
both system wide and applica
tion specific.

Chris is a frequent IDUG presenter, and has
presented at the IBM Tech Conference and various DB2 User Groups across the country.



Glen

Sheffield

(
IBM Toronto Software Lab
)

Glen has over 25 years experience with IBM, and has been part of th
e DB2 team in the
Toronto Lab since 1992.

Glen has held many key technical and management positions
over this period, with extensive experience in the data warehouse area. Glen's current role
is that of a "DB2 Evangelist"

where he helps customers understa
nd the value and benefits
of IBM's DB2 technology.


Dave

Proksch

(
IBM
)

Dave Proksch is a Sr. Software IT Specialist at IBM with over 18 years experience with
database technology such as Informix, DB2, IMS and Oracle.

He specializes in the
development and
tuning of databases and their associated applications.

Dave is a
graduate of Central Michigan University.


Ron

Flannery

(One Point Solutions)


Ron Flannery is president and founder of One Point Solutions, an IBM Business Partner
focused entirely on selli
ng and servicing Informix, DB2 UDB, and IBM BI/data warehouse
solutions. A former member of the International Informix Users Group board of directors,
Flannery is the lead author of the popular Informix Handbook (Prentice Hall, 2000) and the
driving force
behind various DB2, Informix, and data warehouse initiatives at One Point.




MDUG


MDUG

-

5

-


September 2008


Duane

Azarovitz

(
IBM)

Duane

from IBM has over 10 years experience helping organization

improve business
performance through the evaluation, selection

and implementation of Busin
ess

Intelligence and Performance Management solutions. Prior to the Cognos, Duane was a
Cognos

employee for
many

years, focused on businesses of all sizes through
ou
t
Michigan.

Duane was also the organizer and strong advocate of the Cognos user groups
in G
rand Rapids and Southeast Michigan
.


Matthew

Wallace

(Cognos)


Matthew Wallace is a Sr. IT Specialist with Cognos, an IBM Company.

As

such, Matt is
responsible for working with clients to understand their

business requirements.

Matt has
over thirteen yea
rs of experience in the

enterprise software industry in various roles,
including Business

Intelligence, ETL, Data Quality and Profiling, Professional Services and

software Pre
-
Sales.


************************************************************************
*******************************

Presentation Handouts
:

M
any

of the seminar presentations should be available in Soft copy prior to the seminar
and will be posted on the MDUG web site as they are made available. These
presentations
should

be downloaded an
d 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.


S
eminar Details
:

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. The cost for non
-
members
is $80

and covers
the
continental breakfast and lunch. Annual membership forms are available at the
seminar, or
you can
download a copy from the MDUG website.


Maps and directions to the Doubletree 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 o
nly.
Reservations for the seminar will close as of the end of day on
September 12
th

(Friday
before the seminar). Seating may be limited, so please respond early to guarantee
yourself
a spot.

MDUG


MDUG

-

6

-


September 2008


News for Members
:


1.

Future
Seminar Feedback from
June

200
8

Evalu
ations:



# Responses/Topic


23

Advanced SQL


20

DRDA and DB2 Connect



19

Stored Procedures


16

DB2 For Application Programmers


14

DB2 for System Programmers


13



Performance Tips for DB2 w/CICS


11


Data Warehouse Using DB2


10


DB2 Web Connec
tivity


10

XML DB Design and Pure XML


9


Tools for Managing DB2 Systems


7



DB2 Page Internals


6



DB2 Disaster Recovery


5




Analytical Processing with DB2


3

Implementing DB2 for z
-
Linux


2



DB2 UDB for non
-
OS/390 Platform


2


z/OS Certi
fication

Training


1

Using DB2 with PeopleSoft & SAP


1

DB2 Vn New Release Features



Advanced SQL, DRDA and DB2 Connect, and Stored Procedures

w
ere

rated the
most
-
requested future topic
s
.


Overall speaker's ratings seemed higher than in

past meetings
.


2.

June

2008

Seminar Speakers Feedback


Rating based on a scale of 1


5 with 5 as the highest rating.


Akira Shibamiya



DBM1 Virtual/Real Storage C
hange from DB2 for z/OS V7 to V and


Ziip Offload



Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

4.40

4.38

4.48

4.50

4.46

4.56




MDUG


MDUG

-

7

-


September 2008


Akira Shibamiya



DB2 9 for z/OS Select, Insert, Update, Delete SQL Application


Performance

Topic
Value

Session
Content

Speaker

Material
C
overed

Handouts

Visuals

4.62



4.55

4.52

4.67

4.44

4.59


Rob Williams



DB2 Design Patterns


Solutions
to Common Design Errors



Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

4.40

4.00

4.13

4.25

2.00

3.75


Rob Williams



A Simp
le Approach to DB2 Index Redesign



Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

4.40


4.50

4.58

4.40

4.09

4.29


Bill Arledge



Ins and Outs of Distributed Processing in DB2 for z/OS



Topic
Value

Session
Content

Speaker

Material

Covered

Handouts

Visuals

4.03




3.97

4.17

4.24

4.00

4.28


Bill Arledge



Demystifying the Dynamic SQL Statement Cache

Topic
Value

Session
Content

Speaker

Material
Covered

Handouts

Visuals

4.38



4.39

4.48

4.41

4.25

4.43



3.

MDUG Membership

Membership
s are
annual
from January through December. Memberships can not be prorated. All members
receive an email distribution of the quarterly newsletter announcing upcoming seminars when an email
address(s) is/are supplied. Quarterly seminar information is
also available on the MDUG web site at

www.mdug.org
.

Individual Membership

-

$130

annual membership fee

Individuals qualified to be members are those who are employees of organizations that have licensed the
DB2 pro
duct, or have licensed a copy of DB2. The membership can not be transferred during the year. The
following are
SOME

of the benefits included in an annual Individual membership:

-

Covers attendance at quarterly MDUG meetings.

-

Free attendance to the MDU
G Vendor Tools Fair (if one is held).

-

Discount Certificates for the Annual International DB2 Users Group (IDUG) conferences.

MDUG


MDUG

-

8

-


September 2008


Group Memberships

Corporate

-

$520

annual membership fee

Corporate members must either have licensed DB2, or have individual
s in the employment of a corporation
with a licensed copy of DB2, and have paid the annual membership fee. Corporation memberships cover up
to any 5 (five) employees of that corporation at each quarterly meeting. The following are
SOME

of the
benefits i
ncluded in an annual Corporate membership:

-

Covers attendance at each quarterly MDUG meeting for up to 5 (five) individuals.

-

Free attendance to the MDUG Vendor Tools Fair (if one is held).

-

Discount Certificates for the Annual International DB2 Users Group
(IDUG) conferences.

Shared Individual

-

$180

annual membership fee

This membership

level

allows for a group of individuals to share an annual membership. However, only one
individual can attend a specific MDUG seminar under the membership. Individuals

qualified to be members
are those who are employees of organizations that have licensed the DB2 product, or have licensed a copy of
DB2. The following are
SOME

of the benefits included in an annual Shared Individual membership:

-

Covers attendance for on
e individual at each quarterly MDUG meeting.

-

Free attendance to the MDUG Vendor Tools Fair (if one is held).

-

Discount Certificates for the Annual International DB2 Users Group (IDUG) conferences.

Vendor Membership


-

$620

annual membership fee

Vend
or membership is available to vendors, with the concurrence of the MDUG board, who provide tools
related to the Data Base market, and who have paid the annual Vendor membership fee. The following are
SOME

of the benefits included in a Vendor membership:

-

Covers attendance fee for up to 5 (five) individuals at quarterly MDUG meetings.

-

A reduced price to the Vendor Tools Fair (if one is held).

-

The ability to distribute product information at MDUG meetings (with prior Board approval).


MDUG accepts paym
ent in cash or check only.
Sorry
No credit card
s.



All memberships

are

continent on payment of the annual membership fee
.


The
membership
form can be downloaded from the
MDUG web site
www.mdug.org

by
clicking on

the
Membership and Fees
,

then
click
ing

on the left side of the
Home Page
.


Inquiries on
the status of
corporate/company memberships should be sent to the MDUG
email box at
admin@mdug.org
.






MDUG


MDUG

-

9

-


September 2008



5.
Visit our W
ebsite

Please take a few minutes to visit our website (
www.mdug.org
) and give us your
feedback. We are trying to make the website more useful to MDUG members.

Send
your feedback to
admin@mdug.org
.



We are also making plans to enhance the Web site. If you have ideas or would like to
help out, please send your ideas, etc. to
admin@mdug.org
.


6.

Group Support
:
The group has always had a
need for volunteers to assist in the
operation of the User Group.
Although we have a dedicated set of volunteers supporting
the group presently, we are always open to a new set of hands to help out. You can
volunteer by sending an email
with your contact

information
to
admin@mdug.org

asking
where you can help
out

or just that you want to discuss volunteering with someone on the
board. Someone will call you back to discuss how you can
help out.