This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 21%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMO%3C/text%3E%3C/svg%3E)
I successfully connected SSMA for DB2 to IBM i DB2 and can see schema names and tables in the DB2 Metadata Explorer. However, clicking on a table does not show the table column/field names and formats under the table tab on the right side. Why is this happening?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 81%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Same issue... have you figured out a work around? The tool worked fine back in May 2023.
@Marshall Owen / @Thoman If you are using Standard mode to connect to Db2i from SSMA, please try using Connection String mode. If you are still facing issue reach out to DL: mainframedatamod@microsoft.com
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 1%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Hi,
I'm having the same issue, we get following
Failed to retrieve data: Unable to show data for the unloaded table for the following reason:
Using: SSMA for DB2 v9.4 on Connection String mode and DBOLEDBv7
For testing, in SSMS v18.12.1, I've created a SQL Linked server using the same Connection String as in SSMA, for my big surprise I do get tables data.
So I conclude SSMA for DB2 v9.4 can't create a query that's do read data on DB2 tables.
Grtz
still no work around. tried connection string; same result. seems like the issue might be v9.4. any plans to look at the version and repair?
@Marshall Owen We have fixed this issue and working on testing this. Meanwhile you can drop a mail to our team : mainframedatamod@microsoft.com so that we can provide you appropriate guidance to progress further with using SSMA tool for Db2 to Azure SQL schema conversion.
no work around yet. tried connection string; same result. maybe it is a v9.4 issue. any fix out there we can apply?