DELAWARE VALLEY DB2 USERS GROUP
_____________________________________________________________________________
MEETING DATE: Friday, November
9th 2007
LOCATION: Dave & Buster’s
STARTING TIME:
REGISTRATION:
COST: ADVANCE REGISTRATION: MEMBERS $20, NON-MEMBERS $30
WALK IN
REGISTRATION: MEMBERS $50,
NON-MEMBERS $60
_____________________________________________________________________________
AGENDA
Joe
Carola, Chairperson DVDUG
_____________________________________________________________________________
09:15 -10:30 Controlling Data
Growth through Database Archiving
Jim Sinisgalli,
_____________________________________________________________________________
_____________________________________________________________________________
10:45 - 12:00 How to make DB2 Encryption PCI Compliant
Ulf T. Mattsson, Chief Technology Officer - Protegrity
Corporation
_____________________________________________________________________________
12:00 - 01:00 LUNCH: Sponsored
by
_____________________________________________________________________________
01:00 - 01:30 Product Demo:
PCI Module for Informix and DB2 Demo
_____________________________________________________________________________
_____________________________________________________________________________
01:45 - 03:30 Managing Test Data Effectively
Jim Sinisgalli,
_____________________________________________________________________________
The
DELAWARE VALLEY DB2 USERS GROUP reserves the right to change the agenda without
notice.
Visit our Web
Site for the latest information @ www.dvdug.org
Mark your
calendars for the next meeting:
Mar 15 or 22, 2008
Casual Dress
Message from the chair:
Princeton
Softech will sponsor our November session and will present and provide some
cost effective topics on managing DB2 data storage. Our keynote speaker from Princeton Softech,
Jim Sinisgalli, will first discuss database archiving, a topic that has become
more important to us all as our continual explosion of databases on Tier-1
storage become more and more expensive to maintain. As our users increase their demand for more
and more data, for longer periods of time to meet auditor and government
requirements, archiving presents an alternative that pushes the data that is
not needed for every day access to a more cost effective tier, and reduces the
cost of purchasing additional Tier-1 (expensive) storage. In our afternoon session, Jim will also
discuss efficient and effective ways of managing test data. Princeton Softech will also provide lunch and
Product demos.
REMINDER: PRE-REGISTRATION IS HIGHLY ENCOURAGED!! In an effort to better plan for handouts and
food, we are urging the membership to please try to pre-register for our
sessions.
See you at
Dave & Busters!
Joe Carola
BOARD OF DIRECTORS
Chairperson Joe Carola (610) 219-8328 joseph.carola@siemens.com
Vice-Chair Rachel Murawski (570) 200-1558 rachel.murawski@bcnepa.com
Program Anne Stout (609) 520-5240 anne.stout@dowjones.com
Newsletter Tom Orner (215) 238-6872 tomorner@netscape.net
Membership Stan Katinsky skatinsky@comcast.net
Arrangements Mark
Weichman (856) 346-5752 mcweichman@comcast.net
Secretary Mike Piontkowski (610) 326-9529 michael_piontkowksi@compuserve.com
John Brady (610) 993-8700 ext 309 jjbdvdug@comcast.net
Treasurer Denise Walters (610) 219-6556 denise.walters@siemens.com
Bill Saunders (215) 625-5892 bill.saunders@attglobal.net
Website Joseph Mako (610) 359-6766 joseph.mako@siemens.com
IBM Liaison: Linda
Snow (610) 578-2367 lindasnow@us.ibm.com
Howie
Hirsch (732)-926-2362 hshirsch@us.ibm.com
Keynote Presentation
Jim Sinisgalli,
Information is the most valuable
asset in business today. Information is
required for all revenue generating transactions. As businesses expand, the number of data
transactions subsequently grows as well.
A best practice for controlling this data growth is to implement
database archiving, a key component of enterprise data management. Database archiving enables you to archive and
remove historical, inactive data from the production database, and save that
data to more cost-effective and appropriate storage media. This reduces the
amount of data on your Tier 1 production environment, improving performance
immediately as well as reducing the cost of purchasing additional expensive
storage. Database archiving maintains
the “business and technical context” of the archived data, so that the company
can easily research and retrieve the required for responding to a customer
inquiry or audit request. Further,
disaster recovery as well as upgrades and migrations can all be performed
quicker and more efficiently.
Speaker:
Jim Sinisgalli is Director of
Product Line Management for Princeton Softech where he is responsible for
product line life cycle and strategic planning for Princeton Softech Optim™,
helping customers manage enterprise data for their mission critical
applications. Jim has over 15 years experience in the design and delivery of
enterprise software applications in diverse market segments and has held
various roles in development, marketing, project management and implementation
capacities.
Second Morning Presentation
How to make DB2 Encryption PCI Compliant
Ulf T. Mattsson, Chief Technology
Officer - Protegrity Corporation
Legacy mainframe applications form
the foundation of the IT infrastructure at many companies. About 70 percent of
the world's data resides on mainframes. And 85 percent of all business
transactions are processed on these machines. Many organizations have
front-ended and networked their machines to create a "new" mainframe
that's fully IP-networked and supported by Web-enabled data stores and
services. However, security that
protects networks and servers from external threats overlooks the need to
protect databases from potential threats from inside the firewall. With the
increased demand for data privacy and security, the need for data encryption
has moved to the forefront of technology concerns.
The technical challenges
associated with encryption include application changes, performance overhead,
and the difficulties of managing the encryption keys. DB2 and the zSeries(r) platform provides the
basis for
meeting these challenges with the
help of both hardware, software and third party products. This presentation, based on a white paper
written by our speaker, will review solutions that are PCI compliant and that
provide separation of duties, audit, central key management and column level
granularity.
Speaker:
Ulf created the initial
architecture of Protegrity's database security technology, for which the
company owns several key patents. His extensive IT and security industry
experience includes 20 years with IBM as a manager of software development, and
a consulting resource to IBM's Research and Development organization in the
areas of IT Architecture and IT Security.
Demo
Attendees to this demo will see
data masking in action. Data elements such as credit cards, names, and
addresses will be masked to ensure sensitive information remains
protected. Using data masking, confidential information remains protected
in Non-Production environments such as Testing, Development, and Backup.
Afternoon Presentation
Managing Test Data Effectively in a DB2 Environment and Data Privacy in
the DB2 Testing Environment
Jim Sinisgalli,
Reliable applications come from
reliable testing – and realistic test data plays a key role. Many organizations
clone or copy production environments to create test data – a time consuming
and expensive approach. Subsetting data enables you to extract the business
objects or transactions you need to create targeted test scenarios. You can
extract data from a single database or across multiple related databases and
platforms. After migrating data into the target environment, you can view
multiple related tables in a single display. Then you can easily edit your test
data to force error and boundary conditions needed to verify exception
handling. Reusable processing definitions help you speed iterative testing
tasks and ensure complete coverage. Finally,
learn how to sufficiently validate results.
You can compare results from a single database table or across sets of
multiple related tables. Make it easy to identify and resolve application
problems cost-effectively – before they impact your customers.
Gartner suggests that 70 percent
of data breaches are internal to corporations.
Many organizations today focus only on implementing strategies to
protect data in the production environment, while leaving the testing
environment vulnerable. In this
session, learn about appropriate strategies for removing, masking and
transforming data that can be used to identify individuals in your testing
environment. Understand how you can
create contextually accurate but fictionalized data to produce accurate test
results and support compliance with local, state, national, international and
industry-based privacy regulations.
MEETING REGISTRATION
Complete the registration form below and send it with a
check made out to:
P.O.
Pre-registration fee is $20 for members and $30 for
non-members.
Walk-in registration fee is $50 for members and $60 for
non-members.
Advance registration is strongly encouraged. Please note that no telephone registrations
or requests for confirmation will be honored.
DELAWARE VALLEY DB2 USERS GROUP MEETING REGISTRATION FORM
November
9th, 2007 PLEASE REGISTER
IN ADVANCE!
Name: _____________________________________________ Title: __________________________________
Firm: _____________________________________________ Phone: __________________________________
Address:
____________________________________________ E-Mail:
__________________________________
____________________________________________
___
This is a new title, firm, address or phone number. Can we release your
name/address to other sources?
___
Member $20.00 ___ Non-member $30.00 Yes____ No
____
Payment
Enclosed: $ ______
NO TELEPHONE RESERVATIONS WILL BE
ACCEPTED - WE CANNOT BILL YOUR COMPANY
Questions for Q & A session?
________________________________________________________________
_________________________________________________________________
Topic for Future Session:
____________________________________________________________________
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
PLEASE DO NOT SEND MEETING REGISTRATIONS TO
DAVE & BUSTER’s
FREE
PARKING IN THE GARAGE UNDER DAVE AND BUSTERS
Directions to Dave & Buster’s
Dave & Buster’s
Phone (215) 413-1951, Fax (215) 413-1957
Dave
& Buster’s is located on Pier 19 North on
Dave and
Buster’s!! FREE PARKING IN THE
GARAGE UNDER DAVE AND BUSTERS
Our
new location continues to be a big success, and we thank you all for your
comments and input on making it even better.
D&B has been very agreeable and accommodating in addressing
everything we have asked for. When you
arrive in the morning for the meeting, the parking gates are up and unattended,
so just drive in and park. If you are challenged
when you arrive at the main entrance (not the entrance in the garage) to get
into the building, be sure to mention the Delaware Valley DB2 User Group, and
you should be admitted promptly.
Driving Directions:
From the
North or South, use the
From the
Schuykill Expressway (I-76)
Take Interstate 676 to Interstate
95 South to Exit 20 (
From
Take Interstate 676 across the
Door-to-door directions are available on the Dave &
Buster’s
FREE PARKING:
Parking in the Dave & Buster’s lot is free on weekdays, as long as you
enter before
Public transportation:
Market-Frankford
“El” (Blue Line) (runs about every 10 minutes)
*
Connect with the Blue Line from SEPTA Regional Rail lines at Suburban Station (15th-17th & JFK) *
To
Go down stairs to street level.
Turn right on
Walk about one and a half blocks to
Turn right and proceed down
Phlash (from Center city and other points of interest)
Stops right in front of Dave & Buster’s (stop #14 on the route)
Bus #25 (runs up and down
North bound – stops right in front of Dave & Buster’s
DELAWARE VALLEY DB2 USERS GROUP - MEMBERSHIP APPLICATION
FORM
YES! Enter my membership in the Delaware Valley
DB2 Users Group
Name: ___________________________________________________________
Title: ____________________________________________________________
Company: ____________________________________________________________
Address: ____________________________________________________________
Telephone: (____)__________________________ Date: _______________________
E-Mail: _______________________________
Return this
completed membership form and your $35 individual membership fee payable to
Delaware Valley DB2 Users Group to:
DELAWARE VALLEY DB2 USERS GROUP
P.O.