sql-server-2012db2migrationdb2-luwsql-server-2012-datatools

No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found

I migrated a schema of DB2 v9.1.700.855 to SQL Server 2012 using the tool "SSMA (Microsoft SQL server migration Assistant) for DB2", I can establish a connection, but it shows an error :"Error occurred while collecting data". I checked the log file and it shows the below message

No authorized routine named "GETVARIABLE" of type "FUNCTION" having compatible arguments was found.

How can I resolve this error?

Solution

  • IBM DB2 Session variables have no direct equivalent in SQL Server. You will have to look up the GETVARIABLE command, see what information is being retrieved, and find the SQL Server equivalent (if any).