2.3.2 Dropped table space recovery DB2 RE does not recover a dropped table space that has tables with indexes or LOB/Long data in a separate table space. Table 2-4 lists the assets that are required for a dropped table space recovery. Table 2-4 Dropped table space recovery assets Recovery Asset Versioning Repository Comment Versioning Repository must have been run after object created or if any DDL changes on tables in the table space, including authorizations. Full offline database or table space backup. Take as frequently as your current recovery strategy dictates. Versioning Repository is up-to-date when the backup is taken. Must be available if rolling forward beyond backup. An up-to-date ALID saves time during recovery and might also provide extra recovery path options. If not current, it is updated automatically during the log analysis phase of recovery. Database or table space backup Database log records ALID