JR37207: RDBMS CODE 2646: NO MORE SPOOL SPACE DOES NOT GENERATE FATAL ABEND

APAR status

• Closed as program error.

Error description

• Error RDBMS code 2646: No more spool space is being generated
  but only as a Warning even though no data is processed.  Error
  should generate Fatal error abending job.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users using - Teradata Connector
  ****************************************************************
  PROBLEM DESCRIPTION:
  Teradata_Connector_1: RDBMS code 2646: No more spool space in
  TDSPMC01 is displaying as Warning in job log and job does not
  process any data. Error message is displayed/treated as a
  Warning and not a Fatal error.
  ****************************************************************
  RECOMMENDATION:
  Apply the patch JR37207
  ****************************************************************
  

Problem conclusion

• When an SQL-request is submitted & it fails, TDCC throws the
  error as fatal. Whereas when the request is submitted
  successfully, but could not process due to some issue from
  Database, is being displayed as a "warning",
  causing a concern for the errror: "RDBMS code 2646". Made the
  "RDBMS code 2646: No more spool space"
  warning as FATAL and thrown exception so that the job will abort
  from now,instead of displaying as Warning.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R810 PSN

     UP