Thanks for the feedback.

what I understood from your email is that you installed DB2 client on the machine and used the ODBC connection string when configuring the linked server.

so...

I got the following error when I tried to connect:

could not obtain the schema rowset for OLE DB provider 'UNKNOWN'. The Provider supports the interface, but returns a failure code...

I have tried to execute the listed stored procedure. the procedure does execute and the file is created but with no data in it (0 KB)