Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2003 @ 14:36:41 GMT

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

Subj:   Re: Out of spool spcae on disk
From:   Lewis, Huw

If you are running a heavily-skewed query and it has caused your machine to run out of available spoolspace on a vproc, then you may well have allocated individual users too much spoolspace. Allocating a ton of spoolspace just to ensure queries get through is not necessarily the best way to manage your system, as it can let poor (skewing or bad product join) queries get through, with their associated impact on other users.

Possibly, you have a lot of users active at a point in time, and they are using all the spool available in an even fashion, with a skew from one user causing the problem, but it needn't necessarily be a massive skew in this case.

Another possible explanation is that the number of cylinders available for spool is small, and you have some degradation of space utilised per cylinder (both determined from Showspace utility). Running Showspace on a regular basis (it has no system impact) will allow you to get an idea of the disk utilisation on your system. If you also collect total spool usage at the same time, you will get a good feel for what the problem is. If the average utilisation per cylinder is dropping over time, then you can look at Freespace percentages, usually on your larger or more frequently updated tables. If the number of cylinders being used by spool is large, then concurrent user activity is causing your problem, and the only real solution is more disk, as constraining your users tends to be a bad idea. If the number of Free Cylinders (i.e. available for spool) is low when the system is quiet, then you either need to reduce your Freespace percentage or need more disk. Some combination of these issues is likely.

You can run a Packdisk utility to restore free space. Running Packdisk on a regular basis is usually an indication that your machine is approaching its limits in terms of perm space, or that you need to play around with your free space percentages, possibly on a table-by- table basis.

Refer to the Teradata Utilities Volume 1 manual (A-K) for the Ferret utility, from within which Showspace and Packdisk can be run.

  <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: 27 Dec 2016