[teiid-issues] [JBoss JIRA] (TEIID-3837) AS400 deployVDB

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3837?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13132255#comment-13132255 ] 

Ramesh Reddy commented on TEIID-3837:
-------------------------------------

[~mtawk] this should have been a forum question, not a jira :(

I believe the metadata download from your AS400 is taking long time considering the large number of tables. If you already have the schema, you can define the tables inside your dynamic vdb, so that you can avoid the load of the metadata. See one of our DDL based Dynamic VDB examples

> AS400 deployVDB
> ---------------
>
>                 Key: TEIID-3837
>                 URL: https://issues.jboss.org/browse/TEIID-3837
>             Project: Teiid
>          Issue Type: Feature Request
>            Reporter: Mark Tawk
>            Assignee: Steven Hawkins
>
> I'm using Teiid 8.11.3 and db2i translator, 
> I'm connecting to an AS400 DB containing around 1000 tables, the deployvdb remained running for 2 hours and it did not finish.
> Is there a way to speed up the deployvdb treatment? or to know more details on the vdb deployment progress?
> I'm able to fetch the DB information schema via a jdbc connection and it is not taking that much time.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)