RE: Spool file SQL failing on R&D LPAR

Rob, Chuck,

Same error after running RCLSPLSTG DAYS(*NONE) ASPGRP(*ALL)

Based on the message/recovery actions-reason code 01 -

Should I create QSPL0002/ QASPOUTQ?

Recovery . . . : Do one of the following based on the reason code shown,
and try the request again:
01 - Change the library name with an appropriate override file command, or
create a library (CRTLIB command) and a file with the appropriate name.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, July 05, 2017 11:05 AM
To: Midrange Systems Technical Discussion
Subject: RE: Spool file SQL failing on R&D LPAR

Do you still get the error since running the RCLSPLSTG?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 07/05/2017 11:02 AM
Subject: RE: Spool file SQL failing on R&D LPAR
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Rob,

Yes, I do have 2 asps on R&D.
QSPL0002 is referencing ASP 02 correct?

*NONE Request 07/05/17 10:58:13.653637
QWTSCSBJ *N QCMD QSYS 0195
Message . . . . : -RCLSPLSTG
DAYS(*NONE) ASPGRP(*ALL)
CPC330E Completion 00 07/05/17 10:58:13.656171 QSPRCSTG
QSYS 05D7 QCMD QSYS 01C8
Message . . . . : Unused storage
for 0 spooled files was reclaimed from
SYSBAS.
CPC34A7 Completion 00 07/05/17 10:58:13.656378 QSPRCSTG
QSYS 05D7 QCMD QSYS 01C8
Message . . . . : Unused storage
for 0 spooled files was reclaimed.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Wednesday, July 05, 2017 10:56 AM
To: Midrange Systems Technical Discussion
Subject: RE: Spool file SQL failing on R&D LPAR

Also, are you running multiple ASPs? I wonder about that QSPL0002


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 07/05/2017 10:52 AM
Subject: RE: Spool file SQL failing on R&D LPAR
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Try RCLSPLSTG DAYS(*NONE)


Rob Berendt