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. At the “Choose a Source Database” page, in 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)
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, as you do it with other object types.
If you have additional questions regarding the migration of Logical files from DB2 AS400, please contact our support team: firstname.lastname@example.org