Poor performance when browsing DB2 for z/OS objects in Toad, indexes are populated slowly (4373926)

Poor performance when browsing DB2 for z/OS objects in Toad, indexes are populated slowly

Poor performance when browsing DB2 for z/OS objects in Toad, indexes are populated slowly

User-defined indexes on specific system catalog tables can improve performance when you are browsing DB2 for z/OS objects in Toad. The following link contains the DDL for indexes that can optimize Toad performance on your DB2 for z/OS subsystem. Keep in mind that the creation of these indexes is a recommendation only. The indexes can have different results in different environments, depending on the number of DB2 objects and the amount of data involved. To create these indexes, edit and run the DDL contained in the below attached file.

ToadDB2zOSIndexes