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
 

 

DB2 Bind without any Program changes!

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

New User


Joined: 07 Nov 2013
Posts: 3
Location: India

PostPosted: Sun Mar 30, 2014 4:49 pm    Post subject: DB2 Bind without any Program changes!
Reply with quote

Hi Guys, I have accidentally performed a DB2 bind plan for an unchanged CICS Program. Will this affect the execution of the program? Will there be a time-stamp error?
I am currently not able to check into my CICS region. icon_confused.gif Please advise.
Back to top
View user's profile Send private message

Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1235
Location: Israel

PostPosted: Sun Mar 30, 2014 6:20 pm    Post subject: Reply to: DB2 Bind without any Program changes!
Reply with quote

Hello and welcome to the Forum,

Quote:
Will this affect the execution of the program?
DB2 uses table information to build its access path to the data. Many factors are taken into account: statistics are up-to-date, table has changed a lot since last bind, new index etc.
So, maybe your program will run faster now, maybe not.
Quote:
Will there be a time-stamp error?
It should be OK, as long as you have used the correct DBRM and the correct options.
Back to top
View user's profile Send private message
Dilip Kumar Kar

New User


Joined: 07 Nov 2013
Posts: 3
Location: India

PostPosted: Sun Mar 30, 2014 10:27 pm    Post subject: Reply to: DB2 Bind without any Program changes!
Reply with quote

@Marso: Thank you for taking your time to reply on a Sunday! Its Assuring to know that there will not be any problem with program execution. ( As you mentioned I'm also Hoping everything turns out good concerning the bind options.)
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1235
Location: Israel

PostPosted: Mon Mar 31, 2014 6:49 pm    Post subject:
Reply with quote

Welcome.
DB2 is not my strongest point, but I guessed the experts were having a BBQ (or something like that) icon_razz.gif
Back to top
View user's profile Send private message
prasun dhara

New User


Joined: 01 Mar 2008
Posts: 49
Location: kolkata

PostPosted: Thu Apr 03, 2014 11:32 pm    Post subject: Reply to: DB2 Bind without any Program changes!
Reply with quote

Agreed with marso .. There will be no problem if the correct dbrm is used during bind
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1742
Location: NY,USA

PostPosted: Fri Apr 04, 2014 4:23 am    Post subject:
Reply with quote

Quote:
Will this affect the execution of the program?


As Marso said, it could be really better or may go worst , so if you have any tools like OMEGAMON then check the stats of that transaction and see MIPS/MSU/CPU and that will answers the question.
Back to top
View user's profile Send private message
Dilip Kumar Kar

New User


Joined: 07 Nov 2013
Posts: 3
Location: India

PostPosted: Fri Apr 04, 2014 3:04 pm    Post subject: Reply to: DB2 Bind without any Program changes!
Reply with quote

Thank you Guys for the valuable insights, as you all mentioned, I checked under CICS and there was no issue with the program execution its running fine. And it seems I used the correct bind options. icon_smile.gif
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 Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm


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