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 number
JR37207
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-07-14
Closed date
2010-08-27
Last modified date
2010-08-27
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
27 August 2010