Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DB2 MQT access issue

Status
Not open for further replies.
dinesh2017

dinesh2017

Programmer
Dec 13, 2017
1
0
0
US
HI,

We have created an MQT with data initially deferred and refresh deferred condition. There is a view on top of this MQT .
So when we refresh this MQT the view gets locked for select every time until the refresh gets completed.
Is there any way we can tackle this?

 
Sort by date Sort by votes
You're in the wrong forum, Accpac hasn't used DB2 in 10 years.

Sage 300 Whisperer
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mydcba
  • Locked
  • Question
open APPYM table with MS Access
Replies
4
Views
124
DjangMan
DjangMan
jsh8286
  • Locked
  • Question
Can Not Access Database 49153
Replies
1
Views
66
DjangMan
DjangMan
johnny9864
  • Locked
  • Question
I have an issue in the .Net library AP Sage300 (Version 2019)
Replies
1
Views
56
DjangMan
DjangMan
ravazz
  • Locked
  • Question
Restrict User to only access one Sage company 1
Replies
9
Views
55
DjangMan
DjangMan
2ManyHats
  • Locked
  • Question
SHIPMENT ENTRY CAUSING ISSUES WITH OPEN ORDER REPORT
Replies
6
Views
52
2ManyHats
2ManyHats

Part and Inventory Search

Sponsor

Back
Top