IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ASP3 in CICS DB2


IBM Mainframe Forums -> CICS
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Wed Aug 04, 2021 12:26 am
Reply with quote

Hello,

I have fifteen years of experience in mainframe principally in batch. I have to make a training for a training center to a group which is beginner in computing.

I follow the book IBM Mainframe Developper from Robert Wingate.

It's OK for batch and CICS but I have a problem to execute CICS DB2 : The coordinator system has indicated that the current unit of work is to be backed out. Transaction has been abnormally terminated with abend ASP3.

I read one post about it but no answer for me. I don't have a supervisor in the training center.

Can you tell what can cause it ? What I have to search ? A problem with the plan ?

In CICSA in SDSF I have this message for each crash :

ICH408I USER(CICSUSER) GROUP( ) NAME(??? )
LOGON/JOB INITIATION - USER AT TERMINAL NOT RACF-DEFINED
IRR012I VERIFICATION FAILED. USER PROFILE NOT FOUND.

Is-it the problem ?

thanks in advance
Back to top
View user's profile Send private message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Wed Sep 29, 2021 8:18 pm
Reply with quote

Anybody can help me on this problem ? Someone told me ASP3 can be many things. What I have to search ?
thanks
Back to top
View user's profile Send private message
dneufarth

Active User


Joined: 27 Apr 2005
Posts: 420
Location: Inside the SPEW (Southwest Ohio, USA)

PostPosted: Wed Sep 29, 2021 8:39 pm
Reply with quote

Code:

ICH408I USER(CICSUSER) GROUP( ) NAME(??? )
LOGON/JOB INITIATION - USER AT TERMINAL NOT RACF-DEFINED
IRR012I VERIFICATION FAILED. USER PROFILE NOT FOUND.


Consult your data security admin.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2026
Location: USA

PostPosted: Wed Sep 29, 2021 8:41 pm
Reply with quote

Please, read this info carefully. It is in plain English

Quote:
LOGON/JOB INITIATION - USER AT TERMINAL NOT RACF-DEFINED
IRR012I VERIFICATION FAILED. USER PROFILE NOT FOUND.
Back to top
View user's profile Send private message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Wed Sep 29, 2021 8:53 pm
Reply with quote

OK ! Can you tell me how I can create this profile ? There is nobody else me which work on the mainframe. Do you have a documentation to follow to create this profile ?

I think this profile is linked to DB2 because I can execute transaction without DB2 access.

Thanks !
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2026
Location: USA

PostPosted: Wed Sep 29, 2021 9:06 pm
Reply with quote

misterfisher wrote:
OK ! Can you tell me how I can create this profile ? There is nobody else me which work on the mainframe. Do you have a documentation to follow to create this profile ?

I think this profile is linked to DB2 because I can execute transaction without DB2 access.

Thanks !

According to this message:
Quote:
USER AT TERMINAL NOT RACF-DEFINED
there MUST be a person named RACF Administrator, or Security Officer, or whatever else.

Only administrators of your site are able to define, and re-define RACF profiles.

Looks like you are not given permissions to do some work on this system... 824.gif
Back to top
View user's profile Send private message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Thu Sep 30, 2021 12:03 pm
Reply with quote

I have the default user IBMUSER. From this page your www.ibm.com/docs/en/zos/2.4.0?topic=racf-logging-as-ibmuser-checking-initial-conditions
I can say I can access to the RACF options.But, from these options, I don't know how to make the missing link between the profile and the CICS DB2 crash...
Back to top
View user's profile Send private message
Joerg.Findeisen

Senior Member


Joined: 15 Aug 2015
Posts: 1263
Location: Bamberg, Germany

PostPosted: Thu Sep 30, 2021 12:26 pm
Reply with quote

Code:
ADDUSER (Add user profile)                                       
                                                                 
Purpose                                                         
                                                                 
Use the ADDUSER command to define a new user to RACF and         
establish the user's relationship to an existing RACF-defined   
group.                                                           
                                                                 
The command adds a profile for the new user to the RACF database
and creates a connect profile that connects the user to whichever
default group you specify.                                       
                                                                 
The user profile consists of a BASE segment and, optionally,     
other segments such as a TSO segment, a DFP segment, or an OMVS 
segment. You can use this command to define information in any   
segment of the user's profile.
Back to top
View user's profile Send private message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Thu Sep 30, 2021 12:33 pm
Reply with quote

Thank you Joerg.Findeisen. Is this Group the groupe I use when I define the group in CEDA ?
Back to top
View user's profile Send private message
misterfisher

New User


Joined: 02 Aug 2021
Posts: 6
Location: France

PostPosted: Mon Oct 04, 2021 10:23 pm
Reply with quote

From the message at the top, the USER I use when I go to CICS seems to be CICSUSER. My user is IBMUSER. I don't have to use CESN when I go to CICS. When I use CESN, I have the message "Security is not active. Sign-on cannot be active". Does this message means no RACF is needed to use CICS ? In this case, is RACF really the problem to use CICS DB2 ?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA

PostPosted: Tue Oct 05, 2021 9:03 pm
Reply with quote

Also make sure DB2ENTRY has an entry for the plan name.
DB2ENTRY resources
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CICS

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Calling an Open C library function in... CICS 1
No new posts How to 'Ping' a CICS region in JCL CICS 2
No new posts Parallelization in CICS to reduce res... CICS 4
No new posts How to avoid duplicating a CICS Web S... CICS 0
Search our Forums:

Back to Top