In the meanwhile, I tried creating a DTS package using OLE DB Provider for DB2 servers & used the DSN I created earlier, & it let me transfer data from sql server to udb yipppppppee!
Thanks for all your help!