Interested to Buy Any Domain ? << Click Here >> for more details...
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
- 3 Answers
- 7530 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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]#
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is orabulk stage?
What is staging variable?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How do you import and export data into datastage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Define project in datastage?
EXPLAIN SCD
What is the difference between in process and inter process?
how to delete one row in target dataset
What is active and passive stage?
What are the different type of jobs in datastage?
What is process model?
What a datastage macro?
What are the differences between datastage and informatica?
