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
 

 

REFRESH statement on MQT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
charanmsrit

New User


Joined: 25 Oct 2007
Posts: 80
Location: Australia

PostPosted: Wed Sep 10, 2014 8:24 am    Post subject: REFRESH statement on MQT
Reply with quote

Hi,

DB2 is not my expertise and i am looking for some help on MQT's on system Z. we have never used MQT's in our shop. After reading some IBM manuals i am drawn into using MQT as a result table to derive data from 3 very large tables. the result table is expected to be very small and I need to refresh the MQT at the beginning of an ad-hoc application batch processing. i am thinking of executing the REFRESH statement using utility program DSNTIAD. Does the job/step wait till the MQT is completely refreshed or will it complete after issuing the REFRESH statement to DB2?? I am assuming that it will wait and provide me the result via RC.
The MQT will be created as SYSTEM MAINTAINED and REFRESH DEFERRED. Do you guys see any issue with this approach?

Thanks in advance
Charan
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Sep 10, 2014 10:40 am    Post subject:
Reply with quote

Approved
Back to top
View user's profile Send private message
charanmsrit

New User


Joined: 25 Oct 2007
Posts: 80
Location: Australia

PostPosted: Thu Sep 11, 2014 3:26 pm    Post subject:
Reply with quote

Hi Sushant,

Does the job/step wait till the MQT is completely refreshed or will it complete after issuing the REFRESH statement to DB2??

Thanks
Charan
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Sep 12, 2014 8:20 am    Post subject:
Reply with quote

Hi Charan,

Quote:
Does the job/step wait till the MQT is completely refreshed

Yes

Regards,
Sushanth
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 -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