S W A R U G2008

Board Members: 

Todd Bennett
Wells Fargo Bank

Randy Corum
Edward Jones

Sherry Topin
Previous Chairperson
Wells Fargo Bank

Dilip Chakrabarty
Vice Chairperson
Wells Fargo Bank


Ian Bjorhovde
Board Member

Steve Hunn
SWARUG Webmaster 
Lumension Security 
480 515-1498

Mike Leonard
IBM Liason
IBM Corporation
602 217-2795

Get on the Mailing List!

Our eMail is now on Yahoo Groups. This free service allows you to manage your own membership information. 


SWARUG needs you!

SWARUG continually needs assistance, especially with host sites and SIG group leaders.  If you are interested or would like more information, please contact 

Sherry Topin

Next Meeting

Our next meeting will be on
Thursday, May 8, 2008
8:30 AM - 3:00 PM at

Wells Fargo - Ocotillo
2600 South Price Road
Chandler, Arizona 85286


Please RSVP to 
Please RSVP to  Randy Corum, krcorum@yahoo.com


The Impact of Regulatory Compliance on Database Administration 

Governmental regulations are increasing in number, and many of them impact the way organizations must treat their data. Sarbanes-Oxley, HIPAA, BASEL II, and more make the news, but what do they mean to a DBA? And what steps do we need to take to be in compliance? 

This presentation will offer an overview of the regulations and their impact on database administration. Topics to be discussed include:

* What are the Regulations?
* Compliance Issues
* Long-term Data Retention
* Database Auditing
* Database Security and Data Encryption
* Data Masking
* Additional DBA Concerns 

Data Gathering for DB2 Performance Tuning and Health Checks 

This presentation deals with what data should be gathered for DB2 health check and performance tuning on a regular basis on a System z platform. Many installations do not gather all of the data necessary to adequately troubleshoot issues, usually after the problem has occurred.   

The presentation will examine settings which need to be in place for DB2, Workload Manager (WLM), and the Systems management Facility (SMF).  It will show nondisruptive techniques (other than a trace) for finding high CPU/high I/O DB2 objects. It will present introductory information on WLM for the DB2 person and what is important, touching on spreadsheet reporter. Finally, it will show cross-checking methods when trying to find DB2 bottlenecks. 

The introduction will describe the top 5 performance issues seen in most DB2 installations.  All techniques shown are totally non-invasive and will not effect system performance.



8:30 - 9:00 AM
Registration & Continental Breakfast

9:00 - 9:15 AM
SWARUG Business

9:15 - 10:15 AM
The Impact of Regulatory Compliance on Database Administration Part 1
Craig S. Mullins, NEON Enterprise Software

10:15 - 10:30 AM

10:30 - 12:00 PM
The Impact of Regulatory Compliance on Database Administration Part 2
Craig S. Mullins, NEON Enterprise Software

12:00 - 1:00 PM

1:00 - 3:00 PM
Data Gathering for DB2 Performance Tuning and Health Checks
Jeff M. Sullivan, IBM

Speaker BIOs

Craig S. Mullins, Data Management Strategist, NEON Enterprise Software

 Craig has more than two decades of experience in all facets of database systems development including developing and teaching DB2 and SQL Server classes, systems analysis and design, database and system administration, and data analysis and modeling.  He has worked with DB2 for z/OS and OS/390 since Version 1 and also has experience working with SQL Server, Sybase and IMS. Craig has worked in multiple industries including manufacturing, banking, commercial software development, education, research, utilities, and consulting.

Jeff M. Sullivan, Software Engineer, IBM 

Jeff has been involved with most facets of data processing from operations and telecommunications, to programming, to database administration and software installation. Jeff has over 25 years experience with IBM mainframe operating systems. His expertise is DB2 performance tuning and installation, DB2 and IMS Database Administration, and finding ways to work smarter and faster. 


  Don't get frustrated!


SWARUG strives to keep you current with the latest technology.

Please take a moment and complete our survey.

News | Events | LinksBylaws