Re: Max spool entries 10,000 per JOB??

[John Myers <jmyersmm@xxxxxxxxxx>]

Tim,

Read the message carefully.  It does not say that you have reached the
number of records written to file QSYSPRT.  It DOES say that your job has
opened a print file (QSYSPRT) 10,000 times.  In OS/400, there is a
limitation on the number of times a spool file can be opened in the job.
That limitation is 10,000.  You will need to logically break the list into
several portions for processing.

ps:  Are you one of those guys who puts all the $hit on my fax machine???

John Myers
IBM Certified Specialist - AS/400 Technical Solutions
Strategic Business Systems, Inc.
300 Lake Street, Suite B, Ramsey, NJ 07446  USA
E-mail: mailto:jmyers@sbsusa.com   Phone: +1 (201) EASY 400   x131
Web:    http://www.sbsusa.com      Fax:   +1 (201) 327-6984

Instant AS/400 Web Guestbooks & Internet Surveys - WebSurvey/400
     http://www.sbsusa.com/internet/inpuzsvy.htm

Prove that your shipment got there - Proof of Delivery!
     http://www.sbsusa.com/docmgmt/dmsol4u.htm




At 05:37 AM 2/3/99 -0500, you wrote:
>
>Hello All,
>We have a job that runs daily and sends individual prints (spool
>entries) to an OUTQ which is directed to a Faxing utility to perform the
>Fax.  Lately this job will exceed 10,000 spool entries during its daily
>run, and error out.
>I am getting this message (CPF4167 below) that says the number of spool
>entries cannot exceed 10,000 per job.  I have checked the QSYSPRT *prtf
>and it says *NOMAX,  what am I missing?
>Thanks in advance,
>
>===== error message. ======================
>
>CPF4167    Escape                  40
>02/01/99   08:33:49   QSPIERRS       QSYS        0028     BIL023RL
>IMP
>Message . . . . :   Job cannot create any more spooled files.
>
>Cause . . . . . :   An attempt was made to create more than the maximum
>number (9,999) of spooled files for the job, or there is no room
>remaining in the job structure to create the file. Recovery  . . . :
>For a job in an interactive environment, sign off and then sign on
>again. For a job in a batch environment, divide the job so that fewer
>files are opened in one job.
>
>===== view of the outq. ====================
>
>                              Work with Output Queue
>
>Opt       File                File Nbr                  Number
>Date           Time
>               QSYSPRT             9990                 233230
>02/02/99       08:30:47
>               QSYSPRT             9991                 233230
>02/02/99       08:30:47
>               QSYSPRT             9992                 233230
>02/02/99       08:30:47
>               QSYSPRT             9993                 233230
>02/02/99       08:30:48
>               QSYSPRT             9994                 233230
>02/02/99       08:30:48
>               QSYSPRT             9995                 233230
>02/02/99       08:30:50
>               QSYSPRT             9996                 233230
>02/02/99       08:30:51
>               QSYSPRT             9997                 233230
>02/02/99       08:30:52
>               QSYSPRT             9998                 233230
>02/02/99       08:30:52
>
>
>«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
>Tok2YaLatR!
>Tim & Dana Truax and ... Caleb 5 yrs!
>Home web page- http://members.xoom.com/truax
>«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
>And justice is turned back, And righteousness stands far away; For truth
>has stumbled in the steet,
>And uprightness cannot enter.   Isaiah 59:14  ....Gee! sound familiar
>america?
>«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
>
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

John Myers
Strategic Business Systems, Inc.
300 Lake Street, Suite B, Ramsey, NJ 07446  USA
E-mail: mailto:jmyers@sbsusa.com   Phone: +1 (201) 327-1780 x131
Web:    http://www.sbsusa.com      Fax:   +1 (201) 327-6984

Systems supporting the distribution operations of Motor Vehicle manufacturers
    http://www.sbsusa.com/motorveh/mvhome.htm

Instant AS/400 Web Guestbooks & Internet Surveys - WebSurvey/400
     http://www.sbsusa.com/internet/inpuzsvy.htm 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---