Pinned topic Running CLP commands locally (not on server)
we stiil evaluate DB2 10.1 LUW (Windows) together with the Data Studio 3.1.1.
The server runs on Windows 2008 R2. There is no SSH server (Cygwin does not work, IBMSSH is not supported)
Now, we have question using CLP commands ( EXPORT and IMPORT f.e.)
In the past (with the control center) we can run the following example script:
import from c:\import\table1.ixf of ixf lobs from c:\import modified by lobsinfile insert_update into table1;
insert into table3...;
In the Data Studio we must run the "import" as CLP job or put an "call admin_cmd" around.
The problem: with both options, the IXF-Files must be placed at the servers local filesystem. We unnable to run DB2 CLP command remotely.
The only option is to do that outside the Data Studio using db2cmd/db2 commands.
Why is it not possible to run CLP commands (wich are not need an admin server) remotely inside the Data Studio like the old Control Center ?
The other problem: If an developer export tables using the export menu option, the IXF also stored at the server's local file system. The developer has no rights to access the server's local file system. Some changes, like "alter table", let the "run ddl" command with the "save data" option produces export commands in the ddl script. These exports are stored at "ProgramData\IBM\DB2\DB2COPY1\DB2" at default. No one at the development dept. can access this.
The control center may run sql and some CLP commands (like import ans export) together in one script and store IXF's at remote PC's local file system.
We need this in the data studio.
Ivan_CA 270002NHNH52 PostsACCEPTED ANSWER
Re: Running CLP commands locally (not on server)2012-06-29T16:55:11Z in response to SystemAdminHi Matthias,
You already know how to extract/load data using the db server host as file repository. There are valid scenarios this is needed if you are a DBA or if the table is too large you don't want to bring the data to your client machine over the network. Also, it is not uncommon to have a directory in the server that is accessed and shared by developers that can be used for file sharing and other things.
If you want to extract table data into your client/data studio machine, you can still do it, you just need to use Data Studio's DSE extract (or load) feature.
1.Change your perspective to data (main menu - window - open perspective - data)
2.Expand DSE's tree until you find the table you want ( DSE - database - schemas - tables - <table name>)
3.Right-click on the table and choose: data - extract
4.Choose the output file (in your client machine: e.g. c:\temp\table1.del), and click Finish.
Hope this helps,
email@example.com 110000PWHD2 PostsACCEPTED ANSWER
Re: Running CLP commands locally (not on server)2013-08-23T13:08:27Z in response to Ivan_CA
This response didn't seem to answer the question at all. Like Matthias, I too want to be able to import ixf files and there doesn't seem to be any reasonable way to do that within IBM Data Studio. Is it possible, using IBM Data Studio, to import data to a remote database from a local ixf file? If so, how?
freda521 2700058T4N5 PostsACCEPTED ANSWER
Re: Running CLP commands locally (not on server)2013-08-26T00:56:25Z in response to firstname.lastname@example.org
Sorry, we don't support import local data to remote server in Data Studio currently, but we already support it in next version which will be released in a few mouths later.
Zahni 1200008MJS3 PostsACCEPTED ANSWER
Re: Running CLP commands locally (not on server)2014-01-03T14:05:11Z in response to SystemAdmin
Now, we had the year 2014. Is there any News about it ?
Please optionally use the local cli interface from db2 universal client to execute CLP scripts.
Like the old Control Center.
YuanFeng 2700030G5D59 PostsACCEPTED ANSWER
Re: Running CLP commands locally (not on server)2014-01-09T02:49:14Z in response to Zahni
In Data Studio 18.104.22.168, which is the latest release, you can export,import,load to local by right click the table object in object list.
See my screenshot.
We will continue to improve in the comming release.