I'm new to db2 so I apologize if this is a dumb question (because it feels like it). Here's what I'm trying to do. I've got a db2 instance that I need to load data into from a SQL Server db. Right now I plop my data into a csv, FTP the file to the DB2 server, SSH into the server and then run an IMPORT FROM command from the command line. IMPORT reads from the file on the server loads quickly and life is beautiful.
My question is, is there a way to do this without SSHing into the DB2 machine and issuing the command there? Can I just connect to the db2 database on my machine and have my command tell the DB2 engine to look for the file on it's local machine instead of my machine?
e.g. IMPORT FROM 'db2servermachine/home/sdfsdfsd/file.csv' of DEL INSERT INTO my table blah. blah
When I run the import command from my machine it takes hundreds of times longer than when I run the import command on the DB2 instance's machine. Any help is appreciated!