Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2014 @ 10:28:35 GMT

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

Vipin Gupta wrote:

Thanks Vipin.

Just to add to the below, during this "When sessions were in ABORTING PHASE" for longtime, we have also received an alert "DBC running out of space".

However, we had enough perm space (around 1800GB) in the database.

We were actually running a DELETE statement on DBC.Acclogtbl which was highly skewed.

I think, as it was skewed, might be it was using more spool and DBC ran out of space and the sessions continued to be in Aborting state.

Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant

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