As a DBA it is important to closely manage your space usage and understand the benefits that DB2’s architecture provides. This includes keeping data in partitioned tables equally distributed to gain the DB2 benefits of parallelism during query execution, ensuring tables are leveraging the benefits of DB2’s advanced compression algorithms, and taking advantage of DB2 LUW storage groups to ease space management. In this short video, Toad for DB2 development manager, Jeff Podlasek, demonstrates how Toad for DB2 allows you to quickly analyze partition balancing, compression and storage group usage.

About the Author

Jeff Podlasek

Jeff Podlasek is currently a Senior Software Development Manager for the Toad for DB2 products at Quest. Jeff has more than 20 years of software development experience. He has developed products and managed development teams working on DB2 tools since the 1980s. Jeff is a regular contributor in the Toad for IBM DB2 forums.

Start the discussion at forums.toadworld.com