Answer / tkm

1) Perform a bulk load into the target load.
2) If bulk load is already there, check whether the indexes (if any) in the target table are disabled or not.
3) Maybe you can check the configuration file to check how many nodes it is using and switch to a different configuration file having more number of nodes.

Answer / datastage4you

You can try to put a copy stage with force=True propertly. It can inhance the performance

http://goo.gl/atN4AT
www.datagenx.net

Answer / anchalthakran

Check the DataStage Director job log for jobs which do not show job run statistics and confirm whether the following variable is defined:
APT_NO_JOBMON
If APT_NO_JOBMON is defined and set to value of 1 or true, then it will disable job monitoring and process metadata reporting for parallel jobs.

Confirm the JobMonApp process is up and running:
ps -ef | grep JobMonApp

default ports for JobMonApp is : 13400 and 13401

Both ports must be in listen state.

if you are getting this error: Failed to connect to JobMonApp on port 13401" please restart this service.

[root@ibmiis9 ~]# cd /opt/IBM/InformationServer/Server/PXEngine/
[root@ibmiis9 PXEngine]# export APT_ORCHHOME=`pwd`
[root@ibmiis9 PXEngine]# cd java/
[root@ibmiis9 java]# ./jobmoninit stop
JobMonApp has been shut down.
[root@ibmiis9 java]# ./jobmoninit start
JobMonApp has been started.
[root@ibmiis9 java]#

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---

what is combinability and non combinability?

2 Answers  

---

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,

---

What is "fatal error/rdbms code 3996" error?

0 Answers  

---

Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)

3 Answers   HSBC,

---

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---