DELAWARE VALLEY DB2 USERS GROUP
_____________________________________________________________________________
MEETING DATE:
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
_____________________________________________________________________________
Jim Sinisgalli,
_____________________________________________________________________________
_____________________________________________________________________________
10:45 - 12:00 Second AM Session
TBD
_____________________________________________________________________________
_____________________________________________________________________________
_____________________________________________________________________________
_____________________________________________________________________________
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:
September/October, 2007
Casual Dress
Message from the chair:
Princeton
Softech will sponsor our June 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
Hirsh (610)
578-2747 hshirsch@us.ibm.com
Controlling Data Growth Through Database Archiving in a DB2 Environment
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
TBD
Speaker:
TBD
Demo
In
this demonstration, we will provide an overview of the best practices and basic
principles of database archiving, test data management and subsetting and data
masking. This will include both technical and business information and is recommended
for both business and technical persons.
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.