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
 

 

Bind failure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
ratnakumar

New User


Joined: 07 May 2009
Posts: 30
Location: Banglore

PostPosted: Fri Aug 03, 2012 7:20 pm    Post subject: Bind failure
Reply with quote

Hello,

I added logic to the existing CICS cobol db2 proram and moved the component to Endever. The component was successfully moved and gave the return code as zero. But if I check in the spool it says Bind was unsuccessful. At bind step RC is 12.

I am new to the CICS programing. So, I was checking with colleague and was told, If any modifications made to CICS cobol program we need to move corresponding map and macros the ED. Is that true? If yes, can anyone tell me how is that related.


- Ratna
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 03, 2012 7:32 pm    Post subject:
Reply with quote

probably because you did not move the dbrm.

was the bind failure part of the move,

or was the bind failure part of your original compilation of the program
at the previous endevor level?

or don't you know?

by the way, where is Banglore?
Back to top
View user's profile Send private message
Pandora-Box

Moderator


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

PostPosted: Fri Aug 03, 2012 7:59 pm    Post subject:
Reply with quote

Bind failed with what reason?

Did you get any SQLCODE at the Bind step? ( Also Experts correct me if Endevour returns the SQLCODE while bind when failed)

@Dick

Banglore is a Capital of an Indian state Karnataka that city is also known as Silicon valley of India
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 03, 2012 8:05 pm    Post subject:
Reply with quote

ok, I thought it was spelled Bangalore,
or are there two cities or are both spellings acceptable?
Back to top
View user's profile Send private message
ratnakumar

New User


Joined: 07 May 2009
Posts: 30
Location: Banglore

PostPosted: Fri Aug 03, 2012 8:07 pm    Post subject:
Reply with quote

The move to endevor test region was successful. I could see all components in Endevor test libraries (cobol code, CISC load, dbrm). So the DBRM is generated by ED and I believe ED should point to the DBRM location where it created.

And Bangalore is in India.
Back to top
View user's profile Send private message
Pandora-Box

Moderator


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

PostPosted: Fri Aug 03, 2012 8:15 pm    Post subject:
Reply with quote

Bangalore,Banglore,Blr,Bangaluru all is accepted icon_eek.gif

Quote:
So the DBRM is generated by ED and I believe ED should point to the DBRM location where it created.


I am sorry I dont understand that ED ??

Also did you check if DBRM is created ?

Are you trying to bind it via ENDEVOR ??? If you are sure the DBRM is created why not try bind the program through batch and execute the program??
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Fri Aug 03, 2012 8:15 pm    Post subject:
Reply with quote

ratnakumar wrote:
The move to endevor test region was successful. I could see all components in Endevor test libraries (cobol code, CISC load, dbrm). So the DBRM is generated by ED and I believe ED should point to the DBRM location where it created.

And Bangalore is in India.

Yes, Bangalore is in India, but where is Banglore where you are located? ;)
Back to top
View user's profile Send private message
ratnakumar

New User


Joined: 07 May 2009
Posts: 30
Location: Banglore

PostPosted: Fri Aug 03, 2012 8:16 pm    Post subject:
Reply with quote

@Pandora-Box
I dont see any SQLCODE at the BIND STEP. It just gave me the bind return code as 12
Back to top
View user's profile Send private message
ratnakumar

New User


Joined: 07 May 2009
Posts: 30
Location: Banglore

PostPosted: Fri Aug 03, 2012 8:22 pm    Post subject:
Reply with quote

@Pandora-Box

I just used the shortname for Endevor as ED. (what i usually refer with my colleagues).

Yes, I did checked and i see DBRM is generated by Endevor.

Actually, if i move a component to test in evdevor, it automatically compiles the program, generates the DBRM, Load lib and binds the component with DBRM generated.

I could do a manual bind, but am not sure what happens if i move the component in production (with bind failure in test region).
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 03, 2012 8:42 pm    Post subject:
Reply with quote

don"t want to be picky here, but:

the program is compiled at only one level - test.
the dbrm is also created here - output of pre-compiler.

as a module is promoted thru the different stages,
db2 programs are rebound - go thru a bind step
because each stage has its own db2 environment.

if the bind error occurs during the promotion process,
that means for some reason, the module was unable to successfully bind at the new level.

somewhere, someplace, the output of the promotion step is maintained.
within that output, contains the output generated by the bind step
and therein will you find the reason for the failure.

most endevor shops where i have worked maintain the spool output in the endevor LISTINGS ds.
(i can't remember how to get to that option,
but a little experimentation (or read the help for endevor)
and you can find it)
you will need to know the name of the LISTINGS ds for your project,
and to find that you will have to acquaint your self with the
documentation provided by your endevor support.

a typical reason for bind failure during promotion is
the table definition (DDL) at the next stage is not the same as that of the lower level.
this is often caused because the DDL has not been promoted to the next stage before the module.
or
as stated before,
the dbrm was not promoted.

now, if you are having a bind failure at the lowest stage (normally test)
then again the way to determine the problem is look at the LISTINGS ds.

one of the problems with the job that performs the GENERATION
(compile/link/bind)
of a module,
is that even though the bind fails,
the job requires an RC=0 inorder for the LISTINGS ds to be populated with the output.

a compile failure normally results in a JOB rc<>0
and as a result,
the spool output of the job is not migrated to the LISTINGS DS.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Sat Aug 04, 2012 9:13 am    Post subject:
Reply with quote

ratnakumar,

before you ask any more questions,
answer ours:

1. what stage is the program?

2. you need to look at more than just the first dsid of the JOB.
you have to look-at the output created by the bind,
where there will indeed be an sql code
as well as other information why the bind failed.

3. Unless it is a DDL error,
you will have to make changes to your sql
and go thru the generation process of you module once again.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Aug 04, 2012 9:49 am    Post subject:
Reply with quote

Hello,

Quote:
I just used the shortname for Endevor as ED. (what i usually refer with my colleagues).
Using a "shortname" is ok when the shortname is an industry standard (like IBM or JCL). It is best to Not use shortnames that originated locally.

As you have seen, basically no one here knew what your ED referred to. . .

fwiw
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts ALLOCATE REXX PDS to SYSPROC failure mambopras CLIST & REXX 4 Sat Apr 04, 2015 10:14 am
No new posts Related to BIND parameters in DB2 sivareddy123 ABENDS & Debugging 2 Fri Jan 30, 2015 4:12 pm
No new posts OPC/Tivoli OCL failure (line 1560) David Robinson IBM Tools 14 Mon Dec 01, 2014 7:13 am


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