Articles & Content

Archives

Data Studio is the 'Easy Button' to Manage your Databases (I12)

Topic: 2009 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2009-5-15 (08:00 AM - 09:00 AM)
SPEAKERS: Deb Jenson (IBM)

Are you a DB2 Developer or DBA that spends too much time writing SQL code or DDL scripts? Are you tired of having to constantly monitor database activity to ensure high performance and availability? Is looking up DB2 SQL syntax getting old? Wouldn’t it be great if the new, inexperienced database developer or DBA could be up and running in days rather than weeks?If you answered "yes" to any of the questions above, IBM has your "easy" button with Data Studio. Data Studio offers a complimentary set of software designed to ease the everyday tasks associated with managing DB2. With an easy to use front-end and a powerful range of supported developer and DBA tasks, Data Studio can be your "easy" button. In this presentation we’ll discuss and provide brief hands-on demos of the most common tasks developer and DBAs perform on a daily basis. Attendees of this presentation will have a good understanding of Data Studio and a jump start in how to perform these activities.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Learn how to quickly develop grammatically correct SQL statements, without having to lookup SQL syntax or table definitions.

Learn how to debug SQL procedures to quickly determine if the right results sets are being returned.

See how easy it is to spot performance or availability issues without having to run complex scripts.

Learn how quick it is to create or alter database objects without requiring manual scripting.

Build a script to perform nightly maintenance tasks such as backup, runstats, or reorg with just a click of the mouse.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.