Skip to main content

queries limit on dbd in vertica version 8.1

  • November 21, 2017
  • 3 replies
  • 9 views

sreeblr
Forum|alt.badge.img+2

I am trying to run DBD in comprehensive mode from admintools. However it takes only 100 queries. Is there any setting to increase number of queries that can be used>?

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • November 21, 2017

Hi,

When using DBD in Vertica 8.1.x, there is a hard limit of 100 queries is a query file for an "incremental" design:

See (8.1.x):
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DBD/DesignQueries.htm

But for comprehensive designs, there should not be a limit:

From the 8.1.x doc:

Note: Although there is no hard limit to the number of queries or tables you can provide as input to a comprehensive design, Database Designer is limited by system resources, concurrent loads, and query/schema complexity. Micro Focus recommends that you limit the design input to 100 queries.

See (8.1.x):
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/GettingStartedGuide/Tutorial/Step5CreateAComprehensiveDesign.htm


sreeblr
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • December 13, 2017

not sure it takes more than 100 queries.


sreeblr
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • December 18, 2017

i checked from management console and admintools it takes 100 queries max. Can we change setting to take more than 100 ?