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
 

 

Code AL during Insert

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
mubashir.surury

New User


Joined: 29 Sep 2005
Posts: 23
Location: Pune

PostPosted: Wed Dec 20, 2006 11:28 am    Post subject: Code AL during Insert
Reply with quote

Hi Everyone,

I am getting Status Code AL when I am trying to insert some data into my database.Access method is HDAM.and I am trying to insert into the root segment.....Can anyone please let me knoe the solution for this......

thanks in advance...

Regards,
Mubashir
Back to top
View user's profile Send private message

Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 3:11 pm    Post subject:
Reply with quote

This is what the manual (and Abend assist) tell:
Quote:
AL
Explanation:
You get this status code if you:

Issue a message call in a batch program.
Issue a ROLB, ROLS, or SETS call from a batch program under one of the following conditions:
The system log is not on DASD.
The system log is on DASD, but dynamic backout has not been specified using the BKO execution parameter.
Programmer Response:
For cause 1, correct the program so that message calls in a batch program are not issued. For cause 2, either change the program or put the log on DASD with BKO specified on the execution parameter.



You may find the explanation of all status codes over here and you might consider installing Abend assist if you haven't done so yet icon_wink.gif
Back to top
View user's profile Send private message
mubashir.surury

New User


Joined: 29 Sep 2005
Posts: 23
Location: Pune

PostPosted: Wed Dec 20, 2006 3:21 pm    Post subject: Re: Code AL during Insert
Reply with quote

HI Bitnueker,

thanks for the prompt reply............my program is a batch program.......For cause 2 i have tried both the solution(i.e. Logfile on DASD and BKO parm enabled).But yet the result has not changed..........How ever I dont understand
Quote:
Issue a message call in a batch program.

Can Anyone please let me know what can be done......
I just want to insert some rows into 2 level database......the standard EMPLOYEE and SALARY example........

Thanks in advance........
-Mubashir
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 3:57 pm    Post subject:
Reply with quote

You don't understand the part of issuing a message call in a batch program? Check that you insert with the correct PCB. Is your PSB by accident TP in which case an IO-PCB is generated if not declared. Although you may have not declared the IO-PCB in your program it might still be addressed while you think you addressed the DB. If you've got a dump you can find the DLI/call-statistics there.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm


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