DB2 UDB API Stage
Moderators: chulett, rschirm, roy
DB2 UDB API Stage
Hi,
When using DB2 UDB API stage gives the following error and aborts :
"DB2_UDB_API_0,0: Fatal Error: Fatal: SQLFetch: Error retrieving results from server. "
Only succeeds when try several time
When using DB2 UDB API stage gives the following error and aborts :
"DB2_UDB_API_0,0: Fatal Error: Fatal: SQLFetch: Error retrieving results from server. "
Only succeeds when try several time
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Job started at: 3/30/2006 1:49:42 PMray.wurlod wrote:How long between the stage starting and the error message appearing? How busy is DB2 doing other things? How busy is the DataStage machine? ...
Error Received at: 3/30/2006 1:50:45 PM
How busy is DB2 doing other things? Not much
How busy is the DataStage machine? Not much
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
Try running this job alone in the server.
What is the operation performed, it is select operation?
If so do the same from the command prompt, measure the time taken for that.
How complex is the query?
Where is the database situated?
What is the operation performed, it is select operation?
If so do the same from the command prompt, measure the time taken for that.
How complex is the query?
Where is the database situated?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Hi Kumar,
Its a simple select query and there is no problem when trying to run from command promt even doing a "view data " from the stage is also no problem.
Its a simple select query and there is no problem when trying to run from command promt even doing a "view data " from the stage is also no problem.
kumar_s wrote:Try running this job alone in the server.
What is the operation performed, it is select operation?
If so do the same from the command prompt, measure the time taken for that.
How complex is the query?
Where is the database situated?
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
Yes it is a remote database, and there is no chances that somebody else is using that.I would like to add that my fellow developers are also facing the same problem.
kumar_s wrote:Is it a remote database?
Try to write into a Sequential file directly.
Was there any other user accessing the same table. There can be the possibility of lock.
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
Structure of the job is like:
DB2 UDB API---->Transformer-------->Dataset
But my colegues are using different structure and have DB2 UDB API in it and they are also facing the same problem
DB2 UDB API---->Transformer-------->Dataset
But my colegues are using different structure and have DB2 UDB API in it and they are also facing the same problem
kumar_s wrote:So have you tried to loading the table directly into a sequential file?
What is the structure of the job?
Om Prakash
"There are things that are known, and there are things that are unknown, and in between there are doors"
"There are things that are known, and there are things that are unknown, and in between there are doors"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Is there any additional error message (specifically a DB2 error code) in the job log? If you reset the aborted job, is there an event logged "from previous run..." containing diagnostic information?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A very full &PH& directory can extend the startup time to such an extent that some timeouts begin to come into the picture. The dreaded code -14 (failed to start within one minute) can also occur under this circumstance. Keep your &PH& directories cleaned of old entries.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.