Abend in Non-DB2 programs calling DB2 Programs

srikar tenali · New User Joined: 07 Feb 2007 Posts: 22 Location: hyderabad

I have coded a DB2 subroutine which is called by different programs. i am facing problems in running these.
1. An IMS program calling a DB2 program. Though the program is running without any abend but the SQL statements in Subroutine are returning a code -922.
2. A cobol program calling DB2 program. I used IKJEFT01 to run this program with the calling program name and called program plan details. Its abending with code U0201.

What more steps do i need to take care in running these jobs?

Thanks in advance,
srikar

dick scherrer · Posted: Sat Aug 02, 2008 10:10 pm

Hello,

At the top of the page is a link to "IBM Manuals". Among these is the DB2 Messages & Codes that you want to learn to use. The -922 is easily found using the search feature in that manual (the yellow flashlight/tubelight). If you find something that is not clear, post what you found and your question about what you found (the -922 is a security/authorization problem).

The U0201 is a User abend. You need to look at whatever raised this abend and learn why the abend was issued. This is not a system standard abend, but specific to the code that raised the abend.

Terry Heinze · Posted: Mon Aug 04, 2008 9:56 pm

I've encountered one exception to the Uxxxx messages. IMS sometimes issues these, but they all fall within a particular range. See your IMS manuals.