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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


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