ESTIMATED CARDS EXCEEDED
Davage, Marcus
I've a batch Rexx which runs every night, reading input data from DB2 into a
stem variable, writing the stem variable to SYSIN, calling DSNTEP2 to
execute SYSIN, reading the SYSPRINT into another stem variable, and writing
the stem to DB2.
Sometimes there's a lot to process, other times there's nothing. When
there's a lot, I get:
ŁHASP375 FGA001P0 ESTIMATED CARDS EXCEEDED
Why? What is generating this? Where? When? What can I do to stop it? It's
not causing a problem, but I'm fussy!
Regards,
Marcus Davage
-----------------------------------------------------------------------------------------------------------------------
This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
evolvebank.com is a division of Lloyds TSB Bank plc.
Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in
England, number 2065. Telephone No: 020 7626 1500
Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
No: 0131 225 4555
Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
Personal Investment Authority and represent only the Scottish Widows
and Lloyds TSB Marketing Group for life assurance, pensions and
investment business.
Members of the UK Banking Ombudsman Scheme and signatories to the UK
Banking Code.
-----------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX
Stephen E. Bacher
>Why? What is generating this? Where? When? What can I do to stop it? It's
>not causing a problem, but I'm fussy!
Add the following to your JCL stream:
/*JOBPARM CARDS=nnnn
where nnnn is the maximum number (in thousands, IIRC) of cards that you
expect to generate.
You might need the same thing for SYSOUT lines:
/*JOBPARM LINES=nnnn
- seb
Brozewicz Robert F
defining output limits. hope that helps. btw, they can be changed via the $t
command.
> -----Original Message-----
> From: Davage, Marcus [SMTP:Marcus...@LLOYDSTSB.CO.UK]
> Sent: Tuesday, June 19, 2001 6:49 AM
> To: TSO-...@VM.MARIST.EDU
> Subject: ESTIMATED CARDS EXCEEDED
>
> Hi, Rexxers,
>
> I've a batch Rexx which runs every night, reading input data from DB2 into
> a
> stem variable, writing the stem variable to SYSIN, calling DSNTEP2 to
> execute SYSIN, reading the SYSPRINT into another stem variable, and
> writing
> the stem to DB2.
>
> Sometimes there's a lot to process, other times there's nothing. When
> there's a lot, I get:
> ŁHASP375 FGA001P0 ESTIMATED CARDS EXCEEDED
> Why? What is generating this? Where? When? What can I do to stop it? It's
> not causing a problem, but I'm fussy!
>
> Regards,
> Marcus Davage
>
>
> --------------------------------------------------------------------------
> ---------------------------------------------
> This e-mail is intended only for the above addressee. It may contain
> privileged information. If you are not the addressee you must not copy,
> distribute, disclose or use any of the information in it. If you have
> received it in error please delete it and immediately notify the sender.
>
> evolvebank.com is a division of Lloyds TSB Bank plc.
> Lloyds TSB Bank plc, 71 Lombard Street, London EC3P 3BS. Registered in
> England, number 2065. Telephone No: 020 7626 1500
> Lloyds TSB Scotland plc, Henry Duncan House, 120 George Street,
> Edinburgh EH2 4LH. Registered in Scotland, number 95237. Telephone
> No: 0131 225 4555
>
> Lloyds TSB Bank plc and Lloyds TSB Scotland plc are regulated by the
> Personal Investment Authority and represent only the Scottish Widows
> and Lloyds TSB Marketing Group for life assurance, pensions and
> investment business.
>
> Members of the UK Banking Ombudsman Scheme and signatories to the UK
> Banking Code.
> --------------------------------------------------------------------------
> ---------------------------------------------
>
> ----------------------------------------------------------------------
> For TSO-REXX subscribe / signoff / archive access instructions,
> send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX
*****************************************************************
DISCLAIMER: The information contained in this e-mail may be confidential
and is intended solely for the use of the named addressee. Access, copying
or re-use of the e-mail or any information contained therein by any other
person is not authorized. If you are not the intended recipient please
notify us immediately by returning the e-mail to the originator.
Isaac Yassin
DSNTEP2 output can be a real killer as it adds a lot of staff around the
data (headers, box lines ,,,), moreover it forces you to analyze the output
in your rexx.
I have 2 suggestions:
1. Print from DSNTEP2 to a file with enough space ....
2. Use DSNTIAUL instead (this will affect changes in the SQL command to get
the numeric data in char format instead of binary. Again - the output should
go into a file.
Isaac Yassin
DBMS & IT Consultant
yas...@bezeqint.net
----- Original Message -----
From: "Davage, Marcus" <Marcus...@LLOYDSTSB.CO.UK>
To: <TSO-...@VM.MARIST.EDU>
Sent: Tuesday, June 19, 2001 12:49 PM
Subject: ESTIMATED CARDS EXCEEDED
Hi, Rexxers,
I've a batch Rexx which runs every night, reading input data from DB2 into a
stem variable, writing the stem variable to SYSIN, calling DSNTEP2 to
execute SYSIN, reading the SYSPRINT into another stem variable, and writing
the stem to DB2.
Sometimes there's a lot to process, other times there's nothing. When
there's a lot, I get:
#HASP375 FGA001P0 ESTIMATED CARDS EXCEEDED