Page 1 of 1
Commonly used parameters
Posted: Thu Oct 22, 2009 12:18 am
by binujnair2
Hello,
Can someone throw some light on which all are the commonly used parameters(Best practices) in a DataStage project? Eg: - DB Connection for Source, Target, Lookup etc
Thanks Much
Posted: Thu Oct 22, 2009 1:24 am
by gssr
It was user specified and hence you can use your own parameters for DB connection. The commonly used are DataSource,Username, PassWord,HostName etc..
Posted: Thu Oct 22, 2009 2:20 am
by ArndW
$APT_CONFIG_FILE
$APT_DISABLE_COMBINATION
should be in every PX job. The latter can be removed once the job debugging is finished.
Posted: Thu Oct 22, 2009 6:42 am
by chulett
Agreed but I would leave it in, just make sure it's set to False. We typically include the 'dump score' one and another I can't think of at the moment, so they can be 'activated' when needed.
The generic answer to the parameter question is (in my mind) anything that could change from environment to environment or from run to run.
Posted: Thu Oct 22, 2009 3:58 pm
by ray.wurlod
As well as those two I always include APT_DUMP_SCORE (default False), because the score is one of the most useful diagnostic tools you have. The default value of APT_CONFIG_FILE I set to $PROJDEF.
Posted: Mon Oct 26, 2009 6:05 pm
by vinnz
We use APT_CONFIG_FILE at the project level and override at the job level to point to a different config, when required. APT_DUMP_SCORE is set to True at the project level as well.
Other parameters tweaked in the current project level setup (and may not apply to everyone) are the values of APT_MONITOR_TIME, APT_MONITOR_SIZE and APT_STRING_PADCHAR.
HTH