36

Objectives:
Present DB2 9 for z/OS features that provide DB2 database administrators new options to ensure continuous availability, better performance and enhanced security.

Outline:
Keeping the database available by online schema changes
Managing data growth with new tablespace structure
Safe, inobtrusive backups and fast, safe recoveries
Performing typical database administration tasks faster and more efficient
Making data more secure

Full Abstract:
DB2 9 for z/OS introduces numerous features to further enhance database availability, performance and security. Improved online schema and structure change operations, enhanced backup and recovery functions, new options to manage fast data growth and innovative security capabilities are only few of the features that affect the way DB2 database administrators perform their typical tasks.
This presentation focuses on the features that are particularly interesting to database administrators, but it is not limited to them. Application programmers and other DB2 users will find it helpful in getting most out of the latest DB2 release.

Objectives:
Introduces the audience to the scope and content of the Data Studio family of products, which provide support for database design, development, administration, deployment, and governance. Initially, Data Studio will support the IBM relational database products, but over time this will be expanded to include Oracle, SQL Server, MySQL, and other databases used in the enterprise.

Outline:
Overview of Data Studio offerings
Data Studio Developer specifics
Data Studio Administrator capabilities
Data Studio end-to-end monitoring
WebSphere management and monitoring capabilities

Full Abstract:
IBM Data Studio is a new integrated solution that helps IT organizations manage the life cycle of both the database and the applications that depend upon the database. This presentation will describe the capabilities of IBM Data Studio and the expected rollout of functionality over time. This will include database modeling/design, application development, database administration, performance monitoring, problem determination, and data governance.

Objectives:
The presentation describes how Datenzentrale uses a powerful, comprehensive DB2 for z/OS application performance analysis tool to optimize static and dynamic SQL.

Outline:
Monitor every SQL statement that is processed by our DB2 system(s), 24 hours a day
Collect static and dynamic SQL
Identifyresource-intensive application programs and SQL statements
Evaluate application performance at multiple levels of granularity
Show SQL exceptions and error conditions
Provide real-time and historical performance data
Minimize development costs by identifying poorly performing SQL during the application development cycle

Full Abstract:
n/a

Objectives:
Join Phil to hear what has been happening in DB2 tools development at CA and what we have planned for the near future

Outline:

Full Abstract:
Join Phil to hear what has been happening in DB2 tools development at CA and what we have planned for the future. As well as further support for DB2 9 we have also introduced new features and functions through the product maintenance stream.