space problem

From: Swapna_P <Swapna_P_at_satyam.com>
Date: Thu, 3 Aug 2000 17:16:05 +0530
Message-Id: <10578.113719@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFFD40.63EC9610
Content-Type: text/plain

Hello,
Every month end after we run our production we execute a set of sqls for various purposes like for eg to generate reports,the report sizes are usually pretty huge.
And even though i find df -k .(space check) to be sufficient it comes out saying a lot like this...(am i over looking something?? i might since iam new into DBA side)

ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data file system full
(2 block
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data f ile system full (2 block
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information :/salary/data file system full (2 block
extent)ptx/EFS:40:vTVERS:efs:vx_nospace
:ees_information:/salary/data file system full (2 block extent)ptx/EFS:40:vTVER

can anybody through some light on this or can u suggest a more useful solution than deleting the files and cleaning up the used path everytime. TIA,
Swapna

------_=_NextPart_001_01BFFD40.63EC9610
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>space problem</TITLE>
</HEAD>
<BODY>

Hello,
 Every month end after we run =
our production we execute a set of sqls for various purposes like for = eg to generate reports,the report sizes are usually pretty = huge.

And even though i =
find df -k = .(space check) to be = sufficient it comes out saying a lot like this...(am i over looking = something?? i might since iam new into DBA side)

ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/= data file system full 
 (2 block =
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data = f
 ile system full (2 block =
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information
 :/salary/data file system =
full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace
 :ees_information:/salary/data file system full (2 block = extent)ptx/EFS:40:vTVER


can anybody through some =
light on this or can u suggest a more useful solution than deleting the = files and cleaning up the used path everytime.

TIA,
 Swapna
Received on Thu Aug 03 2000 - 06:46:05 CDT