Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Getting RLCP abend in CICS online program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
sathiyendran.erulan

New User


Joined: 04 Mar 2009
Posts: 11
Location: chennai

PostPosted: Sat Sep 15, 2012 1:19 am    Post subject: Getting RLCP abend in CICS online program
Reply with quote

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.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Sep 15, 2012 1:43 am    Post subject:
Reply with quote

Hello,

I suspect your query has used more cpu than permitted.
Back to top
View user's profile Send private message
saikalyan

New User


Joined: 01 Sep 2012
Posts: 1
Location: india

PostPosted: Sat Sep 15, 2012 5:41 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Eshwar CICS

New User


Joined: 18 May 2011
Posts: 47
Location: India

PostPosted: Sun Sep 16, 2012 7:18 am    Post subject: Reply to: Getting RLCP abend in CICS online program
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Sep 16, 2012 8:31 am    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 1 Thu Jan 19, 2017 1:31 am
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts INDEPENDENT CICS TS 4.1 MRO REGION UP... Kyle Carroll CICS 0 Wed Dec 14, 2016 6:55 pm
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us