What is purpose of $APT_RECORD_COUNT and $OSH_PRINT_SCHEMAS?

ratuldey · Post by **ratuldey** » Thu Aug 02, 2007 3:19 pm

DataStage Edn. 7.5x2
OS : Windows 2003 Server

Hi,
Could anyone please elaborate what is the purpose off setting custom values to the 2 environmental variables-
$APT_RECORD_COUNT
$OSH_PRINT_SCHEMAS

And how does these affect the Job Log in the DataStage Director?

Regards,
Ratul.

ArndW · Post by **ArndW** » Thu Aug 02, 2007 3:34 pm

I know those two are documented in the Programmer's or Advanced Programmer's guide! The APT_RECORD_COUNT variable will, when set, make the actual record counts for all nodes and stages get written to the log file. I've found this quite useful for debugging. The OSH_PRINT_SCHEMAS does the same thing for all schemas used.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 02, 2007 4:07 pm

Each causes additional entries to be logged. APT_RECORD_COUNT causes each player process to log an entry showing the number of records it processed. It does this as part of its shutdown processing.

OSH_PRINT_SCHEMAS causes each player process to log an entry showing the actual record schema it used. This can be useful to diagnose the impact of using runtime column propagation.