What is purpose of $APT_RECORD_COUNT and $OSH_PRINT_SCHEMAS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ratuldey
Participant
Posts: 33
Joined: Fri Jul 13, 2007 4:50 pm

What is purpose of $APT_RECORD_COUNT and $OSH_PRINT_SCHEMAS

Post by ratuldey »

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.
Last edited by ratuldey on Thu Aug 02, 2007 9:07 am, edited 1 time in total.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

For Server jobs? I doubt they would have any effect.

ps: 7.5x2 was a special Windows only release. You either have 7.5.2 on UNIX or 7.5x2 on a Windows server. And if the latter, then I suspect you actually have a PX question...
-craig

"You can never have too many knives" -- Logan Nine Fingers
ratuldey
Participant
Posts: 33
Joined: Fri Jul 13, 2007 4:50 pm

Post by ratuldey »

You are correct.
I had mistakenly selected the version as Server Edn 7.5x2 on UNIX.
Actually it is a Parallel Edition running on Windows 2003 server and version is 7.5x2.
I have corrected it.

Thanks,
Ratul.
----------------------------------------------
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply