Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Nov 2005 @ 11:39:00 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Out of spool and OLAP functions
 
From:   Anomy.Anom

<-- Anonymously Posted: Wednesday, November 23, 2005 03:27 -->

We are experiencing the symptoms of 2 'SQL related' problems currently with v2r5.1.2.21:

A 3610 error on simple nested join queries (workaround is to enter command: 'diagnostic nonestedjoin on for session') and is fixed in DR91883 in release v2r5.1.2.25.

An 'user spool skew' problem causing users to encounter 'no more spool space' errors that never occurred for certain queries that ran fine on v2r5.0.3. We are currently working with NCR to confirm that this is the same problem fixed in DR 99497 (TDBMS 5.1.2.28, not yet certified).


Hope this helps.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023