Commonly used parameters

binujnair2 · Post by **binujnair2** » Thu Oct 22, 2009 12:18 am

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

gssr · Post by **gssr** » Thu Oct 22, 2009 1:24 am

It was user specified and hence you can use your own parameters for DB connection. The commonly used are DataSource,Username, PassWord,HostName etc..

ArndW · Post by **ArndW** » Thu Oct 22, 2009 2:20 am

$APT_CONFIG_FILE
$APT_DISABLE_COMBINATION

should be in every PX job. The latter can be removed once the job debugging is finished.

chulett · Post by **chulett** » Thu Oct 22, 2009 6:42 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 22, 2009 3:58 pm

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.

vinnz · Post by **vinnz** » Mon Oct 26, 2009 6:05 pm

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