Page 1 of 1

DS Engine Problem

Posted: Mon Feb 12, 2007 11:08 am
by Raftsman
We re-installed DataStage PX and cannot get any jobs to run. We get the following error (which is not much). Could someone please explain what the problem may be. Thanks

Starting Job IBQ_Create_Seq_TIAXSCT.
PASSWORD = ********
Attempting to Cleanup after ABORT raised in stage IBQ_Create_Seq_TIAXSCT.
Job IBQ_Create_Seq_TIAXSCT aborted.

Posted: Mon Feb 12, 2007 11:43 am
by ArndW
How about telling us what kind of a stage "IBQ_Create_Seq_TIAXSCT" is? Do server jobs run? Does a job without that kind of a stage run?

Posted: Mon Feb 12, 2007 1:41 pm
by Raftsman
The process reads a DB2 table and creates a dataset file. That all. When viewing the DB2 table, we can see the input. The transformer stage substrings the data and it passes the data for dataset creation. This job worked previously. We are currently re-install the software.

Posted: Mon Feb 12, 2007 1:48 pm
by ArndW
Do you get additional information in the log entry for "from previous run" when you reset the job? You did state in the first entry that you can't get any jobs to run - is that right? Perhaps you could try a server job that reads a sequential file and outputs to a sequential file (or even the same job in PX) - it might have something to do with your DB2 connection settings that changed during the re-install or even libraries or different paths in the dsenv file

Posted: Tue Feb 13, 2007 7:15 am
by Raftsman
Cleanup and Re-installation of the product fixed the problem. We think it was corrupt files that cause the error.