|
View previous topic :: View next topic
|
| Author |
Message |
Dilip Kumar Kar
New User
Joined: 07 Nov 2013
Posts: 3
Location: India
|
|
|
|
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.  Please advise. |
|
| Back to top |
|
 |
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
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 |
|
|
Dilip Kumar Kar
New User
Joined: 07 Nov 2013
Posts: 3
Location: India
|
|
|
|
| @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 |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1353
Location: Israel
|
|
|
|
Welcome.
DB2 is not my strongest point, but I guessed the experts were having a BBQ (or something like that)  |
|
| Back to top |
|
|
prasun dhara
New User
Joined: 01 Mar 2008
Posts: 49
Location: kolkata
|
|
|
|
| Agreed with marso .. There will be no problem if the correct dbrm is used during bind |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| 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 |
|
|
Dilip Kumar Kar
New User
Joined: 07 Nov 2013
Posts: 3
Location: India
|
|
|
|
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.  |
|
| Back to top |
|
|
|
|
