S W A R U G2008
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
will be on
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?
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
10:15 - 10:30 AM
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.
| Events |