PX jobs not terminating

Rajesh_kr82 · Post by **Rajesh_kr82** » Thu Sep 07, 2006 1:41 pm

I ahve seen that sometimes PX jobs do not terminate at all. They just hang for hours and do not do anything. Status in the director is running all the time. because they do not return any type of return code the unix shell script never also hangs.

So how shall this kind of scenario be handled??

Rajesh

ray.wurlod · Post by **ray.wurlod** » Thu Sep 07, 2006 3:52 pm

By designing (a) so that they do finish and/or (b) that hang conditions are detected and managed.

panchusrao2656 · Post by **panchusrao2656** » Thu Sep 07, 2006 4:29 pm

We had the similar issue when there were bitmap indexes on the target table. Bitmap index was there on multiple columns with cardinality greater than 10000.

kumar_s · Post by **kumar_s** » Thu Sep 07, 2006 6:28 pm

panchusrao2656 - Do you mean to say, the waist time taken by the job is due to the post index building timing?

vmcburney · Post by **vmcburney** » Thu Sep 07, 2006 6:44 pm

Is there anything your job needs to do after it finishes processing data? Are there after-job routines? Is there anything on the after-sql tab? Are you doing a bulk load to a database? The database may need to rebuild indexes once the load is finished. Could the job be suffering database locking?

panchusrao2656 · Post by **panchusrao2656** » Mon Sep 11, 2006 8:20 am

Kumar,

As the cardinality is very high, i believe it is taking very long to partition the data virtually. In our case the loading method is Upsert.

I am not sure what was happening. Our data modeler experimented by adding bitmap index to the target table.

Kumar, can you tell us whether datastage supports bitmap index or not.