problem with environment setting

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

1. Your system is overloaded. You are asking it to do too much. Also, you're probably reacting to single snapshot - every process takes it in turn to sleep awaiting its turn on the CPU, if it's not waiting for something else such as disk I/O requests. In fact, there can be no more than N processes actually executing at any one time if you have N CPUs or CPU-equivalents.

2. You have not checked thoroughly enough. Somehow, somewhere, your data contains eight columns and your metadata only four. Find it, perhaps using the debugger, and fix it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

1. Agree. Sleep != Hang. Post your system specifics - operating system and number of CPUs primarily. RAM too if you know.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply