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: 1219
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: 1219
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: 1609
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 IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts A sample of exit program for exit XMN... lind sh CICS 2 Mon Oct 03, 2016 5:07 pm
No new posts Need points to tune IMS Checkpoint Pr... satish.ms10 IMS DB/DC 2 Fri Sep 30, 2016 4:12 pm
No new posts ISPF program to set SCRNAME prino TSO/ISPF 5 Fri Sep 30, 2016 2:18 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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