I was struggling for fix an issue in SQL SERVER. My environment is Datastage 8.5 with SQL SERVER 2008.
Issue: Some of the job(s) keep on hanging / aborts with the error i mentioned in the subject. I was not able to find the reason for this and i raised a PMR and it is in progress. Meanwhile i found a workaround and i wish to share this! It may help others who is facing this issue.
If hangs: No useful information in the log
If fails:
Message Id: IIS-DSEE-MSSS-00001
Message: LND_MON_SITE_LANE_DATA,3: 01000 : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).
08S01 : [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.
Workaround:
1. Made the SQL SERVER EE stage to run in Sequential. - This will run, but very poor performance.
2. Create a cluster index in that table - Running fine with good performance
I am working with IBM to find the solution. Until i get the solution / until i update this thread, if any one face the same issue, please try this option.
If it worked, good luck
![Laughing :lol:](./images/smilies/icon_lol.gif)
Otherwise don't screw me
![Embarassed :oops:](./images/smilies/icon_redface.gif)