0

I wanted to write some records say 10000 in database table but got sql error -904 after inserting some records say 2000. I deleted 25 records of old records and than run the program again and this time after inserting 2025 records I got the same error? How can I solve this problem?

mustaccio
  • 18,234
  • 16
  • 48
  • 57
Soraya
  • 29
  • 3
  • Please edit your question to add the "reason code", add the "resource type", add the "resource name" . These will determine your course of action. – mao Aug 10 '23 at 05:30
  • Unfortunately I cannot see these information since DSNTIAR utility returns return-code 4. How else I can see more information about this error? – Soraya Aug 10 '23 at 06:12
  • How are you invoking the DSNTIAR, how large is your message area, have you tried increasing it ? https://www.ibm.com/docs/en/db2-for-zos/11?topic=dsntiar-defining-message-output-area – mao Aug 10 '23 at 06:17
  • What does -904 error mean? – jarlh Aug 10 '23 at 08:27
  • Unavailable resource – Soraya Aug 10 '23 at 09:12

1 Answers1

0

The log of the MSTR adress space of the DB2 instance should show the "unavalable resource" message DSNT501I including the reason code and in case of deadlock/timeout message DSNT375I/DSNT276I will show the offending user/plan. If you can't access it yourself you could try contacting your DBA.

piet.t
  • 11,718
  • 21
  • 43
  • 52