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.
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
What is size of a transaction and an array means in a datastage?
why do u need the IOS upgradation in a FC switch
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the benefits of datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the sortmerge collector?
What are the functionalities of link partitioner?
What are stage variables?
Can you filter data in hashed file?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Differentiate between Join, Merge and Lookup stage?
Describe routines in datastage? Enlist various types of routines.
How to implement complex jobs in data stage?
On which Dimension Table you implemented SCD Type in your Project
What is the difference between informatica and datastage?