Re: Not enough space on temporary disk - why not?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Tue, 14 Mar 2006 09:39:00 -0800, Jerry Whittle
<JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Please post the SQL of the query and the approximate number of records in any
tables involved.

Also have you compacted and repaired your database lately? How big is it
before and after compacting?

Size before:
------------
code.mdb - 1,338,924 KB
data.mdb - 94,360 KB

Size after:
-----------
code.mdb - 792,472 KB
data.mdb - 69,996 KB

------------
SELECT DISTINCT
tblCXLIB_UT420AP.UTCSID AS [Cust ID],
tblCXLIB_UT420AP.UTLCID AS [Loc ID],
tblCXLIB_UT420AP.UTSVC AS Svc,
tblCXLIB_UT420AP.UTRBCM AS BRComp,
tblCXLIB_UT420AP.UTCHGT AS ChgType,
tblCXLIB_UT420AP.UTTTYP AS TransType,
tblCXLIB_UT420AP.UTTDSC AS TransDesc,
tblCXLIB_UT420AP.UTTMM AS [Trans MM],
tblCXLIB_UT420AP.UTTDD AS [Trans DD],
tblCXLIB_UT420AP.UTTYY AS [Trans YY],
tblCXLIB_UT420AP.UTTAMT AS [Trans Amt],
tblCXLIB_UT420AP.UTUNPD AS [Amt Unpaid],
tblCXLIB_UT420AP.UTRCCD AS [Rec Code],
tblCXLIB_UT420AP.UTAGE AS [Age Code],
tblCXLIB_UT420AP.UTEXTD AS [ExPmt Plan],
tblCXLIB_UT420AP.UTPPRI AS PostAuth,
tblCXLIB_UT420AP.UTBILM AS [Bill MM],
tblCXLIB_UT420AP.UTBILD AS [Bill DD],
tblCXLIB_UT420AP.UTBILY AS [Bill YY],
tblCXLIB_UT420AP.UTRJUR AS Juris,
tblCXLIB_UT420AP.UTRCLS AS [Rate Class],
tblCXLIB_UT420AP.UTRIO AS [In-Out],
tblCXLIB_UT420AP.UTRMSZ AS [Mtr Size],
tblCXLIB_UT420AP.UTREDY AS [Effect YY],
tblCXLIB_UT420AP.UTREDM AS [Effect MM],
tblCXLIB_UT420AP.UTREDD AS [Effect DD],
tblCXLIB_UT420AP.UTRSW AS Season,
tblCXLIB_UT420AP.UTPEMM AS [Period MM],
tblCXLIB_UT420AP.UTPEYY AS [Period YY],
tblCXLIB_UT420AP.UTGREF AS [Gen Refer#],
tblCXLIB_UT420AP.UTCHCN AS [Chrgd Cons],
tblCXLIB_UT420AP.UTADCH AS [Adj Chg Typ],
tblCXLIB_UT420AP.UTBBFL AS [Budget Flag],
tblCXLIB_UT420AP.UTDMCN AS [Dmd Consump],
tblCXLIB_UT420AP.UTDPNO AS [Unique Dep#],
tblCXLIB_UT420AP.UTUSER AS [User Name],
Now() AS [Timestamp]

INTO
tblAnnRptFY05a_EL_cons IN
'D:\Projects\AS400\UtilityBilling\As400_Finance_data.mdb'

FROM
tblAnnRptFY05a_EL LEFT JOIN tblCXLIB_UT420AP ON
(tblAnnRptFY05a_EL.[Cust ID] = tblCXLIB_UT420AP.UTCSID) AND
(tblAnnRptFY05a_EL.[Loc ID] = tblCXLIB_UT420AP.UTLCID);
------------

I'm querying a DB2 db on an AS/400. Something I do all the time. Admittedly,
in this case I'm going to get back a lot of data, a year's worth of trans for
all active customers. (Roughly 18k customers * 8 trans/cust (approx) * 12
months.)
.

Relevant Pages