KB Article 14897
2014/10/06

Close
X
Contact Tech Support

 Email Tech Support
 (250) 655-1766
 [7:30 - 5:00 PST]
Your Meeting ID will be Provided by a Rep.
Tech Support
Tech Support Home
Software Updates
Knowledge Base Search
Recent KB Articles
Product FAQs
Code Samples
Documentation
Tech Blog
System Requirements
Installation Instructions
Support Testimonials
Contact us to...
Create a Ticket
Request a Free Demo
Suggest a New Feature
Submit Feedback
Upload a Large File
Other Services
Software Training
Professional Services

Files in XL_WEBSPT are taking up large amounts of space due to deleted records. Is it safe to reorganize these files?

Product: WebSmart ILE Type: Frequently Asked Question

If you've had WebSmart on your system for a long time, you may end up with large numbers of deleted records in the PW_SVARF, PW_SESSF and/or PW_TRNF files. Early versions of WebSmart did not install these files with REUSEDLT(*YES), resulting in deleted records being left in the files.

It is safe to reorganize these files, however you may want to end your WebSmart Apache server before doing so as any programs that attempt to create or use smurfs will fail during reorganization. After reorganizing the files, we recommend changing them to reuse deleted records to prevent the same thing from happening again.

Run the following CL commands to reorganize and change your files:

ENDTCPSVR SERVER(*HTTP) HTTPSVR(WEBSMART)
RGZPFM FILE(XL_WEBSPT/PW_SVARF)
RGZPFM FILE(XL_WEBSPT/PW_SESSF)
RGZPFM FILE(XL_WEBSPT/PW_TRNF)
CHGPF FILE(XL_WEBSPT/PW_SVARF) REUSEDLT(*YES)
CHGPF FILE(XL_WEBSPT/PW_SESSF) REUSEDLT(*YES)
CHGPF FILE(XL_WEBSPT/PW_TRNF)  REUSEDLT(*YES)
STRTCPSVR SERVER(*HTTP) HTTPSVR(WEBSMART)

Note that your HTTP server name may differ.

Keywords: reorganize physical file member, re-use deleted records, smurf file, session variable file, session file, transaction file

Rate This Article

Did this example help you to achieve your goal?
 Yes  No  Don't Know

Enter additional comments below.   If you want to hear back from us, include your contact information.

Email Address:
Comments:
Please enable JavaScript in order to rate this page.