Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 1303
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: 1303
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: 2039
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 How to find if segment is read in any... Priyanka AR IMS DB/DC 12 Thu Sep 20, 2018 1:34 pm
No new posts U0437 to execute IMS DC program Vkp321 IMS DB/DC 6 Wed Sep 19, 2018 8:39 pm
No new posts Send data from a CICS TS program to M... spiThingy CICS 2 Wed Aug 08, 2018 8:58 am
No new posts Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts In which program the FILE CONTROL wil... Poha Eater COBOL Programming 2 Thu Jun 28, 2018 9:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us