GLOBAL TEMP TABLES (GTT) missing in strategy

Document ID : KB000011299
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Creating a RC/Migrator migration Strategy, on Level= Database the expected "GLOBAL TEMP TABLES (GTT)" are not included in the Analyze Strategy. Why? The "GLOBAL TEMP TABLES (GTT)" were previously created for this specific Database used within the RC/Migrator Strategy.

Answer:

There is no relationship with a GLOBAL TEMP TABLES (GTT) and a specific Database.

GLOBAL TEMP TABLES (GTT) do not depend on a specific Database, all Global Temporary Tables (GTT) are assigned to DSNDB06.SYSTSTAB only.