Topic
  • 6 replies
  • Latest Post - ‏2014-01-09T02:49:14Z by YuanFeng
SystemAdmin
SystemAdmin
1632 Posts

Pinned topic Running CLP commands locally (not on server)

‏2012-06-29T09:06:45Z |
Hello,

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:

update table1...;
update table2...;

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.

Regards,

Matthias
Updated on 2012-06-29T16:55:11Z at 2012-06-29T16:55:11Z by Ivan_CA
  • Ivan_CA
    Ivan_CA
    52 Posts

    Re: Running CLP commands locally (not on server)

    ‏2012-06-29T16:55:11Z  
    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,

    Thanks,
    Ivan
  • j@us.ibm.com
    j@us.ibm.com
    2 Posts

    Re: Running CLP commands locally (not on server)

    ‏2013-08-23T13:08:27Z  
    • Ivan_CA
    • ‏2012-06-29T16:55:11Z
    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,

    Thanks,
    Ivan

    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
    freda521
    5 Posts

    Re: Running CLP commands locally (not on server)

    ‏2013-08-26T00:56:25Z  

    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?

    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.

  • j@us.ibm.com
    j@us.ibm.com
    2 Posts

    Re: Running CLP commands locally (not on server)

    ‏2013-08-26T16:39:51Z  
    • freda521
    • ‏2013-08-26T00:56:25Z

    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.

    Thank you for the reply.  I am very much looking forward to this being included in Data Studio.

  • Zahni
    Zahni
    15 Posts

    Re: Running CLP commands locally (not on server)

    ‏2014-01-03T14:05:11Z  

    Hello,

    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.

    Regards,

    Matthias Zahn

     

     

  • YuanFeng
    YuanFeng
    78 Posts

    Re: Running CLP commands locally (not on server)

    ‏2014-01-09T02:49:14Z  
    • Zahni
    • ‏2014-01-03T14:05:11Z

    Hello,

    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.

    Regards,

    Matthias Zahn

     

     

    In Data Studio 4.1.0.1, 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.

    Attachments