Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

AGGREGATOR default datatype

1520


What is the difference between informatica and datastage?

1300


How to perform incremental load in datastage?

1260


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2330


What are transforms and what is the differenece between routines and transforms?

1105


What is the project in datastage?

1165


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1466


What are the steps needed to create a simple basic datastage job?

1303


Explain the datastage parallel extender (px) or enterprise edition (ee)?

1278


What is apt_config in datastage?

1193


Difference between ‘validated ok’ and ‘compiled’ in data stage?

1347


Can you explain kafka connector?

1377


Explain entity, attribute and relationship in datastage?

1153


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3290


What are the types of hashed files in data stage

1146