DSXchange

Hi All

I had a chance to look into Datastage job issue.

ISSUE: Job is simply hanging. (Some day this job will not give any issue)

Job Design:
Seq file --> TFM --> SQL Server Enterprise stage (Append mode).

When i ran the job it is simply in running status in Datastage.
In SQL Server the query went to suspended mode.

Now other jobs are running at the time and not one is using the Database.

In log no information captured.

Changes made in the job level:

Option 1:
Changed the SEQ file stage to Dataset stage
Dataset --> TFM --> SQL Server Enterprise stage (Append mode).

Option 2:
Seq file --> TFM --> SQL Server Enterprise stage (Append mode).
(Changed the Execution mode from parallel to sequential in SQL Server Enterprise stage)

In both options job ran successfully.

Now what I need to know is why the job is hanging when it is running using sequential file, Parallel mode in SQL Server Enterprise stage?
(Seq file --> TFM --> SQL Server Enterprise stage (Append mode).)

Datastage 8.1 in Windows (32 bit)
SQL Server 2008 R2 (64 bit) in different server

It will be great if any help me in this to trace / freeze the issue.


Thanks in Advance
DS User

Hi All

Found the result for this issue.

SQL Server 2008 R2 is not a supported version for 8.1 Information Server.

Confirmed with IBM.

Regards
DS User