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

COOLGEN - DB2. -927 error while initiating IMS transaction


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

New User


Joined: 14 Mar 2021
Posts: 3
Location: USA

PostPosted: Mon Mar 22, 2021 10:55 pm
Reply with quote

Hi,

I am getting -927 SQLCODE while initiating IMS transaction. The program compilation is successful.

I have used the control card with ENABLE option both (*) and ENABLE (IMSMPP), both times the compilation and BIND is successful.

But not sure if there could be any other reason for having this -927 error.

FYI-We are using COLLGEN through which the code is generated and compiled. it would be great if some one can suggest a solution.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1586
Location: Andromeda Galaxy

PostPosted: Tue Mar 23, 2021 1:07 am
Reply with quote

Have you link-edited things correctly ?
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Tue Mar 23, 2021 1:24 am
Reply with quote

Welcome!
Please copy paste the code and use code tags instead of uploading the pictures or a documents.
-927 THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND

Contact DBA.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 704
Location: Whitby, ON, Canada

PostPosted: Wed Mar 24, 2021 5:31 pm
Reply with quote

If the program is running under IMS, you have to ensure that the IMS/Db2 language interface program DFSLI000 is used.
Back to top
View user's profile Send private message
meetraju2020

New User


Joined: 14 Mar 2021
Posts: 3
Location: USA

PostPosted: Fri Mar 26, 2021 4:27 am
Reply with quote

After checking the link edit process, I found some warning messages and the link edit output is as shown in the attached document.

I was not able to figure out whether the warning messages 711 and 712 are related to any problem with system modules?

Can any one suggest your understanding.

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10766
Location: italy

PostPosted: Fri Mar 26, 2021 4:40 am
Reply with quote

I feel that it is unreasonable to expect people go over a 6000 lines listing to find out what is going on

the best road is to forcefully ask your support
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


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

PostPosted: Fri Mar 26, 2021 5:25 am
Reply with quote

meetraju2020, It is suggested to avoid any uploads but to copy paste specific errors using code tags to avoid spacing and other security concerns one may have. Such issues usually handled by DBAs . Did you reach out to them even once as I asked before ?
Back to top
View user's profile Send private message
meetraju2020

New User


Joined: 14 Mar 2021
Posts: 3
Location: USA

PostPosted: Fri Mar 26, 2021 5:28 am
Reply with quote

I can understand it is Lengthy text, hereby I am pasting the area of warning messages

EW2322I 1220 120 INCLUDE SYSLIB(TIRMAINI)
IEW2322I 1220 121 INCLUDE SYSLIB(DFSLI000)
IEW2480W A711 EXTERNAL SYMBOL DSNWLI OF TYPE LD WAS ALREADY DEFINED AS A SYMBOL OF TYPE LD IN SECTION DSNELI.
IEW2482W A712 THE ORIGINAL DEFINITION WAS IN A MODULE IDENTIFIED BY DDNAME APPLOAD. THE DUPLICATE DEFINITION IS IN
SECTION DFSLI000 IN A MODULE IDENTIFIED BY DDNAME SYSLIB.
IEW2480W A711 EXTERNAL SYMBOL DSNHLI OF TYPE LD WAS ALREADY DEFINED AS A SYMBOL OF TYPE LD IN SECTION DSNELI.
IEW2482W A712 THE ORIGINAL DEFINITION WAS IN A MODULE IDENTIFIED BY DDNAME APPLOAD. THE DUPLICATE DEFINITION IS IN
SECTION DFSLI000 IN A MODULE IDENTIFIED BY DDNAME SYSLIB.
IEW2322I 1220 122 INCLUDE SYSLIB(TIRLILOD)

Hope this will be helpful

Thanks and Regards,
Rajkumar Nerella
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1104
Location: Dublin, Ireland

PostPosted: Fri Mar 26, 2021 1:29 pm
Reply with quote

Quote:
IEW2480W A711 EXTERNAL SYMBOL DSNWLI OF TYPE LD WAS ALREADY DEFINED AS A SYMBOL OF TYPE LD IN SECTION DSNELI.
IEW2482W A712 THE ORIGINAL DEFINITION WAS IN A MODULE IDENTIFIED BY DDNAME APPLOAD. THE DUPLICATE DEFINITION IS IN
SECTION DFSLI000 IN A MODULE IDENTIFIED BY DDNAME SYSLIB.


I think the clue is in these messages. You have specified that you want to include DFSLI000 from SYSLIB but the entry-point(s) in that module clash with an already-included module as identified in a module in APPLOAD. It is probable that the module identified by ddname APPLOAD contains a non-IMS language interface module.

Garry
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 -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SOC7 error with DFSORT DFSORT/ICETOOL 9
No new posts problem in select max when executing ... IMS DB/DC 6
No new posts Starting a remote transaction using a... CICS 0
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Error 0C1 Reason Code 1 with branch i... PL/I & Assembler 3
Search our Forums:

Back to Top