Search found 614 matches

by kollurianu
Wed May 25, 2011 9:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Node constraint in a Grid Env
Replies: 2
Views: 1394

Node constraint in a Grid Env

Hi All,

Currently we have Grid Eniv , so looking inputs for the following question?

What will be the execution flow of the job in GRID Env if you have specified node constraint inside the job? Basically how node constraint works in GRID Env?

Thanks in advance.Any inputs greatly appreciated.
by kollurianu
Mon May 23, 2011 2:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Datasets.
Replies: 1
Views: 1293

Reading Datasets.

Hi All, I 've following questions on datasets. 1) if a dataset is created in GRID Env with 8 compute nodes and 1 partition configuration, can we read that (in another job) with 2 compute node 1 partition configuration? If yes ,how it works? 2)Can we read a dataset that is created in GRID Env using n...
by kollurianu
Tue May 17, 2011 10:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset error..
Replies: 4
Views: 2246

Even when I delete the dataset from the designer..do we have to export the value of APT_CONFIG_FILE to the config file that was used to write the dataset..?

Could anyone please elaborate on this..

Thanks in advance.
by kollurianu
Mon May 16, 2011 1:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset error..
Replies: 4
Views: 2246

Use (set APT_CONFIG_FILE to) the same configuration file as the one that was used to write the Data Set. ... Hi Ray .. Thanks for your response.. but to set APT_CONFIG_FILE to the same one ?Is it thru the export command.. could you please let me the steps exactly to "Set" it.. Thank you a...
by kollurianu
Fri May 13, 2011 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dataset error..
Replies: 4
Views: 2246

dataset error..

Hi All, When I am trying to delete the dataset from the designer ie; Tools-->Dataset Management .. I am getting the following error .. The open files limit is 1024; raising to 10240. Error when checking operator: No partitions of the /abc.ds are accessible from the nodes in the configuration file. w...
by kollurianu
Mon Nov 29, 2010 12:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

You will need to talk with your UNIX administrator. It seems that either "rsh" is not installed or not in your path, likewise will most likely be the case for "ssh" as well. Once you sort out getting this command working (with or without adding userid/password) then you can impl...
by kollurianu
Wed Nov 24, 2010 2:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

try executing "rsh YourRemoteHostName ls -al" at the command line while logged into the system under the DataStage id. Does it work? If not, what is the error message? Thanks Arnd for your response. I just tried with actual hostname .."rsh abc.def.com ls -al" and below is the er...
by kollurianu
Tue Nov 23, 2010 11:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

The command would be "rsh" or "ssh" and the exact syntax depends on your flavour of UNIX. Your userid must also be granted rsh or ssh priveleges on the remote machine so you will need to speak with your sysadm to ensure that permission is granted. Thanks Arnd for a quick respons...
by kollurianu
Tue Nov 23, 2010 11:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

in pull mode you can't execute remote commands so you will have to "ssh" the delete command some other way in your job. Either as an after-job shell call or from the calling job sequence. Thanks for the response Arnd ! In my job sequencer , I've first job as SFTP job , which would pull th...
by kollurianu
Mon Nov 22, 2010 11:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

Another way of doing this is to run sftp -b (Batch mode) In the batch file you can write a get/mget followed by a rm Thanks narsimha for your response , could you please elaborate how this can be done in an FTP enterprise stage as I am using an FTP enterprise stage to pull the files (SFTP) from rem...
by kollurianu
Mon Nov 22, 2010 11:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

I am doing SFTP in FTP enterprise stage , so is there a way to perform rsh or ssh to delete the file on the remote server.

Thanks in advance.
by kollurianu
Mon Nov 22, 2010 10:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

SFTP allows shelling out on the local host and executing commands. Thus, if your sftp is "push" then it will work, if you "pull" the files then you will need to do something else, perhaps "rsh" or "ssh" to execute the delete command. Thanks for your response ...
by kollurianu
Mon Nov 22, 2010 10:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sftp ing the files and deleting files on remote server.
Replies: 17
Views: 15109

Sftp ing the files and deleting files on remote server.

Hi all ,

After SFTP'ing the source files successfully to the local server , how to delete files from the remote server ? Any inputs greatly appreciated.

Thanks in advance.
by kollurianu
Thu Nov 18, 2010 4:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SFTP syntax
Replies: 3
Views: 3975

Re: SFTP syntax

I am trying SFTP and I am getting following error in the director FTP_Enterprise_0: uri is having invalid syntax. uri : ftp://abc.bbbbb.com[:24]//folder/abc.txt can someone provide me the syntax? And how to find out what SFTP port number. Thanks in advance. It worked and the syntax used is as below...
by kollurianu
Thu Nov 18, 2010 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SFTP syntax
Replies: 3
Views: 3975

SFTP syntax

I am trying SFTP and I am getting following error in the director

FTP_Enterprise_0: uri is having invalid syntax. uri : ftp://abc.bbbbb.com[:24]//folder/abc.txt

can someone provide me the syntax?

And how to find out what SFTP port number.

Thanks in advance.