SQLFetch() Error with ODBC connector

[smile.achieve]

I have a sql query in the below format

WITH temp1(col1,col2,col3) as
(

SELECT C1,C2,C3 FROM TABLE1

)

SELECT COUNT(COL1) AS STD,'CLS' AS CLASS1
UNION ALL
SELECT COUNT(COL2) AS HLM,'ABC' AS CLASS1

This query runs successfully on sqlserver and also this is wokring fine on datastage 8.1 sql connector. My problem is my job fails with following error


[IIS-CONN-000004]ODBC function"sqlfetch"
Code=0 Msg=[IBM[DataDirectOEM]][ODBC SQL
dbStatement:dbsFetch:FileCC_OdbcDBStatement.cpp
. Most of the times the job runs successfully.The job fails only some times with this error. Let me know where is fault with my code.

[sreewin7]

Hi Smile.

Can you please provide me at what ratio job is aborted with your given error.
As per my understanding , due to space issue or server may be down at the time of job executes.

Request you please re check and let us know.

Thanks
Sree

[smile.achieve]

Hi Sree,

I have set of jobs that are being executed simultaneously. I trigger all of them from autosys. Even I feel that there is an issue with space. The job mostly fails when other jobs also running. Other wise its absolutely fine.

Can you suggest another approach for the sql query which does not consume much memory. I have close to 40 columns in my original table