BWDB2UG
Home


Events


June 11, 2008
Meeting Agenda


Baltimore/Washington DB2 Users' Group

 

When?
Wednesday, June 11, 2008, 9:00AM-3:30PM (registration at 8:30)

Where?
Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900
                  

  Meeting Fees:  
  Pre-registered members: $20
  Pre-registered non-members: $30
  At-the-door for members: $30
  At-the-door for non-members: $40

Membership is based on company membership -- check to see if you are a member.

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

  

2) To pay by check, mail the check with attendee and company name to:

The Baltimore/Washington DB2 Users' Group
P.O. Box 18554
BWI Airport, Maryland  21240

All pre-registrations must be received by Friday, June 6, 2008. 

 

Meeting Schedule:

  8:30 – 9:00 Registration
 
  9:00 – 10:15 The Impact of Regulatory Compliance on Database Administration
  Craig Mullins, Neon
 
  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? 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
  •  IT Controls
  •  Long-term Data Retention
  •  Database Auditing
  •  Additional DBA Concerns
    		•
     
      10:15 – 10:30 Coffee Break
     
      10:30 – 11:45 Null & Void? Dealing with Nulls in DB2 for z/OS
      Craig Mullins, Neon
     
     

    Nulls are one of the most controversial aspects of SQL database systems. On the one hand, they seem to be useful as a means to record missing information; on the other hand, they introduce three-valued logic and other difficulties into our applications. This presentation will delve into the various aspects of nulls, show some of the problems presented by nulls, and give advice on how best to use/avoid them.

     
      11:45 – 12:45 Lunch provided by Neon Enterprise Software
      Product session given by Neon
     
      12:45 – 2:00 Performance Management and Capacity Planning
      Nghi Eakin, IBM Global Services
     
      This presentation introduces key SMF data which can be used to observe the various components in the z/OS environment in which DB2 operates. DB2 workload performance could be impacted by the performance of the supporting infrastructure (CPU, memory, Workload Manager policy, the IO subsystem, Coupling Facility, zIIP engine) and DB2 requesters (CICS, IMS, DDF, etc.). This presentation will show charts built from the SMF data of various customers' production environments to show the benefits of looking beyond DB2.
     
      2:00 – 2:15 Break
     
      2:15 – 3:30 Java Stored Procedures - Getting the Environment Ready
      John Lantz, Federal Reserve Board
     
      The Federal Reserve Board has recently enabled the development of Java stored procedures on the mainframe in their environment using the Development Center. This presentation goes through the steps to set up that environment. It will include the steps necessary from a system programmer perspective, the DBA perspective, as well as that of the application programmer. It will include some of the problems encountered so that you can avoid the same issues.
     

    To be added to our email notification list for events or to edit an existing email address, please fill out our contact list form.


           


    Directions to the Sheraton Columbia Hotel:

    From Baltimore and North
    Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.

    From Washington and South
    Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.

    For more information, contact one of the Board Members or Volunteers.

    (Board members and volunteers are employed by various companies. Their work and efforts to the BWDB2UG are strictly on a volunteer basis.  They will respond to phone calls by the next business day, if possible. If you do not get a response, please contact another board member.)

     

    Events           BWDB2UG home