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

Code AL during Insert


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 3:11 pm
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
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: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 3:57 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts Insert header record with record coun... DFSORT/ICETOOL 14
No new posts Insert system time/date (timestamp) u... DFSORT/ICETOOL 5
Search our Forums:

Back to Top