17 May 2012 — Show descriptions | Hide descriptions

• Get the most from the DB2 HADR standby database

  Learn how to make applications on a standby database run more effectively, such as enabling the Read on Standby feature, using Uncommitted Read isolation level, and making short LOBs inline so that they can be accessed on the standby database.

• Test drive DB2 10.1 using a virtual appliance

  See how you can extract, deploy, and run a DB2 virtual appliance to explore the new features in the DB2 10.1 release without having to install and configure the software in a production environment.

• Use concurrent I/O to improve DB2 database performance

  Learn the differences between the I/O mechanisms available with UNIX and Linux file systems, and see how concurrent I/O technology can be used in an IBM DB2 environment to improve database performance.

• Configure automatic maintenance in DB2 for Linux, UNIX, and Windows using IBM Data Studio

  Learn to configure automatic maintenance capabilities in DB2 for performing database backups, keeping statistics current, and reorganizing tables and indices.

• System Administration Certification exam 919 for Informix 11.70 prep, Part 5: Informix backup and restore

  Learn about utilities and commands to manage your Informix database backup and restore processes, including ON-Bar, ontape, archecker, dbimport, and dbexport. Also learn how to monitor your backups and perform problem determination when necessary.

• DB2 Text Search, Part 4: High-availability setups with DB2 Text Search

  Learn to properly configure a standby system for text search and make it accessible to text-search index collections.

• DB2 Text Search, Part 3: What to consider when planning text index backups

  Learn how database objects and text-search indices relate, and get recommendations to plan and implement comprehensive backup and recovery procedures.

• Use optimization profile in DB2 for Linux, UNIX, and Windows stored procedure

  Modify the default execution plan of SQL statements in stored procedures to better tune your SQL and debug your applications without changing the database settings.

• Restricting database connections using trusted contexts in DB2 for Linux, UNIX, and Windows

  Protect databases against unauthorized access or misuse by authorized database users. Learn to mitigate risks by ensuring that users are allowed to connect only from a list of trusted hosts known to be secure.