AS/400 Spool Data Base File

285 pts.
Tags:
AS/400
AS/400 Database File
AS/400 Spooled Files
Is it safe to delete the Spool Data Base File? Object:Q04079N011 Type:*FILE Attribute: PF Library: QSPL

Software/Hardware used:
as400

Answer Wiki

Thanks. We'll let you know when a new response is added.

Why? If you delete spool files from outqueues the system spoolfile cleanup routines will cleanup these spool file database files. If you query these you will see mulitple members that contain information and attributes of spooled files. If the spooled files are deleted the system will remove these qspl/q* files for you without damaging queues.

===========================================================

Although you don’t say what version/release you’re running of the operating system, we have to assume that you are reasonably current. It’s <b>possible</b> that deleting the file won’t cause serious damage, but I wouldn’t bet my career on it like you might be close to doing.

In earlier releases, it was possible to significantly affect the spooling subsystem simply by reading those files. IIRC, IBM has done work to limit the negative effects as new releases come out; but it is still unwise to attempt to manipulate the spooler database files directly. You should use the supplied interfaces for manipulating spool storage. The spooler subsystem maintains its locks and indexes for those files, and you don’t want to interfere with those.

If spool storage has become too large, review and use the RCLSPLSTG command.

Also, review and use the QRCLSPLSTG system value.

You might consider asking a question that describes why you are considering deleting this file. Answers might supply better procedures.

Tom

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • WoodEngineer
    As a rule of thumb, don't delete Q objects. They typically represent objects created by IBM that the system uses.
    6,530 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following