InfoSphere Optim

InfoSphere Optim

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Back to discussions
Expand all | Collapse all

Access Definition for (25,000+ tables)

  • 1.  Access Definition for (25,000+ tables)

    Posted Wed March 27, 2019 12:10 PM
    Edited by System Admin Fri January 20, 2023 04:36 PM
    Anyone ever connect to a native optim source database with over 25,000+ tables that the Access Definition had to read? Wondering if there is a limit here... I've processed as many as 12,000 tables but I've come across a larger Oracle DB source with 25,000+ tables and the Optim Access Definition does not seem to be able to handle it.  It won't complete the read to be able to even Add the Tables. 

    FYI, The Oracle source is a beast with tons of available resources. No end users. No connections other than Optim. No network limitations. Optim has been optimized with parallel processing and database threads. 

    As always, I've submitted ticket. Just reaching out to the group for their experience here.

    EDIT: 

    The limit is 24,000 tables.  Support shared the info. 

    https://www.ibm.com/support/knowledgecenter/SSMLNW_11.3.0/com.ibm.nex.optimd.common.doc/04acdefs/opcommon-c-access_definitions.html



    ------------------------------
    Danny Lankford
    Advanced IT Specialist
    3M
    St Paul MN
    ------------------------------
    #InfoSphereOptim
    #Optim


Related Content