Are you on Oracle with ITSM 7.0 or earlier? The Email Message Body (1000000827) and Notification Text (1000000820) fields are unlimited length (0) in NTE:Notifier Log. In ITSM 7.6 they reduced those fields to 3964 to solve the Oracle issue (the filter NTE:NTS:AuditLog_900_PNTL truncates both fields in the push fields action), but that created one for me while using rrrchive to move records from production (7.1/7.0) to future production (7.5/7.6). I actually had to increase Email Message Body from 3964 to 0 in order to move my data, but I am on SQL Server 2008 so it should not be a problem for me.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, July 28, 2010 11:56 AM To: arslist@ARSLIST.ORG Subject: RRR|Chive SAN Disk Space issues ** 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 jennifer.me...@nc.gov<mailto:jennifer.me...@nc.gov> 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. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
