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
 

 

For every sql statement will there be a path

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
shammiullah

New User


Joined: 13 Jun 2005
Posts: 24

PostPosted: Wed Jan 11, 2006 6:45 am    Post subject: For every sql statement will there be a path
Reply with quote

hi,
1.in the dbrm path will be set along with timestamp for the sql statements.during bind plan an optimal path iss chosen.my ques is for every sql statement will there be a path or for all the sql statements only 1 path will b there.

2.actually in which part does the timestamp mismatch occur.during precompilation stage timestamp is set for sql codes in dbrm and modified source program.does the timestamp mismatch occur while the precompilation stage itself or at some other process like bind or execution stage.

thanks..............
Back to top
View user's profile Send private message

nikyojin

New User


Joined: 05 Oct 2005
Posts: 94

PostPosted: Wed Jan 11, 2006 9:26 am    Post subject: Re: db2 ques
Reply with quote

Hi,
1) For each Sql statement encountered an optimal path is chosen.

2) The timestamp mismatch is observed during the execution stage.The timestamp mismatch occurs due to the following reason.
On Compilation the current Timestamp is associated with the DBRM.Later when the DBRM is bound to a package or plan the current timestamp is also associated with the same.
If any changes are made in the DBRM the recmpilation is done during which the original Timestamp gets replaced with the latest one.If such a source program is directly executed without rebinding to the plan or package, Timestamp mismatch occurs.
Back to top
View user's profile Send private message
prakash271082

New User


Joined: 09 Sep 2005
Posts: 53

PostPosted: Wed Jan 18, 2006 1:34 am    Post subject: Re: For every sql statement will there be a path
Reply with quote

Hi,
One small suggestion. If you are not concerned with environment, you counld quote LEVEL parameter to avoid such TIMESTAMP Mismatch ( -818 ) error during BIND / RUN phase.
It does do the TIMESTAMP, Authorization checks and other relevant checks either during BIND or during RUN phase depending on VALIDATE parameter in your DB2 BIND JCL.
Hope this helps....
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts COBOL DB2 - CALL statement - high CPU... TS70363 DB2 15 Sun Sep 11, 2016 6:07 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
This topic is locked: you cannot edit posts or make replies. Updating value of key using rewrite s... ParminderKumar COBOL Programming 4 Thu Aug 04, 2016 12:46 am
No new posts Inspect statement spoorni COBOL Programming 5 Mon Jun 06, 2016 9:53 pm


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