This is an old revision of the document!



Ispirer Home Page Request SQLWays

How To Collect Information About Logical Files

To collect information about logical files from our DB2 database, we need to have DDS file for each logical file that should be assessed. And on the “Choose a Source Database” page, on the “Advanced” window, we need to specify a path to a folder where these DDS files are located on the machine where the assessment tool is running.

Our tool will read information about objects extracted from DB2 database, and when the tool will see that the object is a Logical File, it will check the folder with DDS files and will try to read the structure of this logical file from the appropriate DDS file.

Here you can find a step by step guide on how to extract the DDS files for logical files that should be converted:
How to Extract Logical and Physical Files From DB2 iSeries (AS400)


Please note:
If you are using DB2 iSeries 7.2 version or higher, you don't need to extract the DDS files and provide a path to them. You just need to specify logical files for assessment on the “Specify Database Objects” page, like you do it with other object types.



If you will have additional questions regarding the migration of Logical files from DB2 AS400, please contact our support: support@ispirer.com


Ispirer Home Page Request SQLWays


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.