Dear Listers,
I have been archiving our NTE:Notifier Log records since the 15th of July using
RRR|Chive to move records from NTE:Notifier Log to an archive table. The
process has been smooth and quiet, but the Archive form has been eating up disk
space. Yesterday, we nearly ran out of disk space on our SAN and had to add an
emergency 200 GB of disk space.
I moved 250K Notification Logs from the original NTE:Notification Log (T587) to
the Notification Log Archive (T2057) yesterday. Those 250K records took up
nearly 6G of table space.
Growth (MB) Owner Type Segment Name Lob Parent
Tabl Lob Column
------------- ---------- --------------- -------------------------
--------------- -------------------------
2,954.77 ARADMIN LOBSEGMENT SYS_LOB0000426378C00018$$ T2057
C840000827
2,939.00 ARADMIN LOBSEGMENT SYS_LOB0000426378C00020$$ T2057
C840000820
156.77 ARADMIN LOBSEGMENT SYS_LOB0000084949C00022$$ T587
C1000000827
156.24 ARADMIN LOBSEGMENT SYS_LOB0000085002C00126$$ T590
C1000000827
154.55 ARADMIN LOBSEGMENT SYS_LOB0000053052C00021$$ T69
C18091
The question I have for the list is: has anyone else seen this out-of-control
growth when archiving records? Is this perhaps due to a write process that may
be sloppy? Is truncating LOBs the answer?
Jennifer Meyer
Remedy Technical Support Specialist
State of North Carolina
Office of Information Technology Services
Service Delivery Division ITSM & ITAM Services
Office: 919-754-6543
ITS Service Desk: 919-754-6000
[email protected]<mailto:[email protected]>
http://its.state.nc.us<http://its.state.nc.us/>
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
