how can u find out the datastage job is running on how many
nodes
Answers were Sorted based on User's Feedback
Answer / sudheer
Go to tools and select configurations. Then we can select default.apt, then we will be able to see no. of nodes in that.
| Is This Answer Correct ? | 5 Yes | 1 No |
In datastage directory we can find the job running in how
many nodes.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / srikanth reddy m
Go to datastage Director. Select the logs options. In that select the configuration file. Click on it. It shows the no of
nodes available along with their node names.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / babu
Re: from the configuration tab it available in DS DEV, we
can click on that we saw the configuration file, for the
particular job how many nodes are present it will shows.
otherwise go to the DS Administrator there in environ ment
variables we can find the $APT_CONFIGFILE. there it will
shows how many nodes are working for the particular job.
| Is This Answer Correct ? | 2 Yes | 1 No |
We can check in DataSatge Log as well.
Configuration file name is assigned in run time for the environment variable: $APT_CONFIG_FILE
Log:
"Environment variable settings:
_=/usr/bin/nohup
ADMIN_TEMPLATE_VERSION=Version: 1.0; Version Date: 09/01/2014
APT_COMPILEOPT=-c -O -fPIC -Wno-deprecated -m64 -mtune=generic -mcmodel=small
APT_COMPILER=g++
APT_CONFIG_FILE=/iis/ut02/InformationServer/Server/Configurations/ut02cmb-1Node.apt
"
We can the mentioned file for the Node configuration.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nirupam
go to the DS Administrator there in environ ment
variables we can find the $APT_CONFIGFILE. there it will
shows how many nodes are working for the particular job.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the difference types of stages?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
Define Merge?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
what is the differeces between hash and modulus partition methods
Explain the ChangeApply stage?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how