Re: Blocking Excessive API Calls?

The question was raised if there was something on the iSeries that would block excessive calls to a API.

The web server, using ODBC and SQL Stored Procedures, is making these calls to retrieve SKU/ITEM information from the iSeries. From what they are telling me, they get about 20 updates and everything stops.


> On 11/02/2021 4:59 PM Nathan Andelin <[email protected]> wrote:
> 
>  
> Jay,
> 
> The way you're asking your question, and the way you're describing your web
> service seems confusing to me. "Blocking Excessive API Calls?"; although
> ended with a question mark, that sounds more like a statement. What
> software do you suspect might be "blocking" your API calls? Your external
> HTTP server? Your PHP server? An external router? What server is doing the
> logging that you're referring to?
> 
> If we assume that you're referring to your HTTP server and the logs
> generated by it, then I would assume that the logs are showing HTTP
> "requests"; Not "updates" to the database. Are you saying that only 20
> requests appear in the log? That's such a small amount, that it begs the
> question, what do you mean by "excessive". Some HTTP sites process
> thousands of requests per second. Are you asking about an HTTP
> configuration directive that restricts the number of requests?
> 
> Nathan.
> 
> 
> 
> 
> 
> 
> On Tue, Nov 2, 2021 at 11:51 AM Jay <[email protected]> wrote:
> 
> > How does one check to see if a system is blocking excessive API calls?
> >
> > We have a PHP-based external WEB server that places calls to SQL stored
> > procedures via ODBC. One call runs several times during the night to update
> > the WEB version of the master item file. Several thousand records.
> >
> > Right now, it appears the routine is running, but the web server only sees
> > about 20 actual updates.
> >
> > I've gone through all of the logs and have not found anything about
> > blocking the calls.
> > --
> > This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> > list
> > To post a message email: [email protected]
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/web400
> > or email: [email protected]
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/web400.
> >
> >
> -- 
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/web400
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/web400.
-- 
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.