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: 1224
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: 1224
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: 1638
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 Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm


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