Getting RLCP abend in CICS online program

sathiyendran.erulan · New User Joined: 04 Mar 2009 Posts: 11 Location: chennai

While performing any of the below query getting RLCP abend in CICS screen.
select count(*) into l-nbr-cnt from cust_data where cust_nbr between 100000000 and 999999999 and substr(char(cust_nbr),6,4='4907' and cust_type in (' ','0'); OR
select count(*) into l-nbr-cnt from cust_data where cust_nbr between 100000000 and 999999999 and mod(cust_nbr,10000)=4907 and cust_type in (' ','0');

cust_nbr declared as decimal(9,0) in table and cobol equivalent used in code that PIC s9(9) comp-3.
05 l-nbr-count pic s9(4) comp-4.

Expected output is to retrieve all the cust_nnr ending with 4907.

Please advice me to resolve this abend.

dick scherrer · Posted: Sat Sep 15, 2012 1:43 am

Hello,

I suspect your query has used more cpu than permitted.

saikalyan · New User Joined: 01 Sep 2012 Posts: 1 Location: india

Dick is correct,

If CPU limit exceed you will get RLCP :CPU utilization exceeded.

If Db2 resouce limit exceeds then you will get RLDB :DB2® requests exceeded.

You can split up the query or tune it based on your requirement.

Eshwar CICS · New User Joined: 18 May 2011 Posts: 47 Location: India

There are different tools to monitor CICSregion ex: Omegamon.
CICS Resource-Limiting Abend Codes (ex: RLCP) indicates that transaction exceeded the resource threshold(CPU limit in this case). These threshold limits are set by monitoring tool(s).

Usually these limits are not changed on application programmer's request.So better fine tune your query or think of alternative ways of handling the requirement.

If there is no scope to fine tune your query / no alternative way, then talk to your CICS system people to see if they can revisit this limit.

dick scherrer · Posted: Sun Sep 16, 2012 8:31 am

Hello,

I personally suggest looking for a different approach to the requirement. Rarely, if evr, should system limits be increased for one problem situation.

How well does the query run in batch?