|
View previous topic :: View next topic
|
| Author |
Message |
gschandu13
New User
Joined: 07 Jun 2005
Posts: 6
|
|
|
|
Hi
Can some please help me in resolving the below issue that I have been facing since yesterday. For the same program for different input I am getting the below errors. I have searched in form and could not get any solution.
I have compile and binded the program as it is db2 online program and also did NEW copy in ONLINE region.
*** SQL ERROR: 471-, TRANID: RY03
*** SQL ERROR: 904-,
Thanks,
Chandra. |
|
| Back to top |
|
 |
Garry Carroll
Senior Member
Joined: 08 May 2006
Posts: 1193
Location: Dublin, Ireland
|
|
|
|
| Quote: |
| *** SQL ERROR: 904-, |
SQL CODe -904 is resource unavailable. Suggests that something else is using the resource.
SQL code -471 - suggestion is to look for related DSNX9xx message on console.
Garry. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
you should have referred to the manual for the error messages.
both come with a reason code, which provides more explanation.
use the IBM LookAt site, which will provide you with the manual,
and page concerning the error messages.
then follow the instructions in the manual for finding the reason codes. |
|
| Back to top |
|
|
gschandu13
New User
Joined: 07 Jun 2005
Posts: 6
|
|
|
|
Hi,
I know what does -471 and 904 error description. But the problem there is error code that is displayed. I repaired with REPAIR for that particular table and it was successfull. But still I am getting the same error. The online program is using tables as well as on stored procedure. I tried all my options and posted.
Thanks,
Chandra. |
|
| Back to top |
|
|
|
|
