DataStage job hangs
Posted: Sat Apr 17, 2010 11:19 am
Hello,
I have a job which hangs when it is kicked off. I can't see much info in the log to see where it is hanging. The job is stuck at this step:
main_program: APT configuration file: /dsinst001/IBM/InformationServer/Server/Configurations/config2x.apt
{
node "node1"
{
fastname "ttstsza8011"
pools ""
resource disk "/dstemp001/is8/Datasets" {pools ""}
resource scratchdisk "/dstemp001/is8/Scratch" {pools ""}
}
node "node2"
{
fastname "ttstsza8011"
pools ""
resource disk "/dstemp001/is8/Datasets" {pools ""}
resource scratchdisk "/dstemp001/is8/Scratch" {pools ""}
}
}
The job is sourcing from an Oracle table and loading another Oracle table. I don't have the privileges to check if there is a table lock. Is there a way to know if it is indeed stuck at the source query or at some other steps?
Cheers!
I have a job which hangs when it is kicked off. I can't see much info in the log to see where it is hanging. The job is stuck at this step:
main_program: APT configuration file: /dsinst001/IBM/InformationServer/Server/Configurations/config2x.apt
{
node "node1"
{
fastname "ttstsza8011"
pools ""
resource disk "/dstemp001/is8/Datasets" {pools ""}
resource scratchdisk "/dstemp001/is8/Scratch" {pools ""}
}
node "node2"
{
fastname "ttstsza8011"
pools ""
resource disk "/dstemp001/is8/Datasets" {pools ""}
resource scratchdisk "/dstemp001/is8/Scratch" {pools ""}
}
}
The job is sourcing from an Oracle table and loading another Oracle table. I don't have the privileges to check if there is a table lock. Is there a way to know if it is indeed stuck at the source query or at some other steps?
Cheers!