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
 
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 WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts Suppress value reported by BREAK in D... Learncoholic DFSORT/ICETOOL 3 Wed Aug 16, 2017 6:03 pm
No new posts ON 2 AND EVERY 1 - Statement ??? UmeySan COBOL Programming 2 Tue Jul 25, 2017 1:20 pm
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm

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