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 Posts
Re: Running CLP commands locally (not on server)2012-06-29T16:55:11ZThis is the accepted answer. This is the accepted answer.Hi 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,
firstname.lastname@example.org 110000PWHD2 Posts
Re: Running CLP commands locally (not on server)2013-08-23T13:08:27ZThis is the accepted answer. This is the accepted answer.
- Ivan_CA 270002NHNH
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 Posts
Re: Running CLP commands locally (not on server)2013-08-26T00:56:25ZThis is the accepted answer. This is the accepted answer.
- email@example.com 110000PWHD
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.
firstname.lastname@example.org 110000PWHD2 Posts
Zahni 1200008MJS16 Posts
Re: Running CLP commands locally (not on server)2014-01-03T14:05:11ZThis is the accepted answer. This is the accepted answer.
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 2700030G5D81 Posts
Re: Running CLP commands locally (not on server)2014-01-09T02:49:14ZThis is the accepted answer. This is the accepted answer.
- Zahni 1200008MJS
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.