0

Hi I am getting SQL error -30080 while running a select query on datastage, on google I cannot fing SQL error -30080, can you provide me the reason

mustaccio
  • 18,234
  • 16
  • 48
  • 57
salesforce beginner
  • 11
  • 1
  • 5
  • Will you please give some more detail about your error? – Nilesh Nov 05 '14 at 10:46
  • May be referencing the product manual could help? http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.codes/src/tpc/n30080.dita?lang=en – mustaccio Nov 05 '14 at 12:43
  • @Lafada what other details i can give you ? – salesforce beginner Nov 06 '14 at 06:05
  • @mustaccio it is for ql state 08001 ,but for me sql state is 40506 – salesforce beginner Nov 06 '14 at 06:09
  • SQL1476N The current transaction was rolled back because of error "-30080". SQLSTATE=40506 – salesforce beginner Nov 06 '14 at 06:09
  • You need to ask the DBA to examine the Db2-server diagnostics around the same time as the message you got (SQL1476N, -30080, sqlstate 40506). You need to find the real underlying error that caused the sqlstate 40506. The diagnostics location depends on the operating-system on which the Db2-server runs (Z/Os, i-series, Unix/Windows), missing from your question. Once you know the underlying cause you can then get the correct person to address the issue. – mao Oct 06 '17 at 06:37

1 Answers1

1

SQL30080N A communication error “” occurred sending or receiving data from the remote database.

40506: The current transaction was rolled back because of an SQL error.

Cristian
  • 548
  • 6
  • 8