IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  DB2 indexes management

    Posted Tue November 24, 2020 04:54 AM

    Hello.

    I was tasked with moving indexes to dedicated tablespace. It seems to be reasonable but the more I read the bigger my suspicion is that it may be pointless.

    So here are my questions:

    1. Is it possible to easily move index to another tablespace?
    2. Is it possible to get a SQL DDL for all indexes on a table?
    3. Does this make sense to move the indexes to dedicated tablespace?

    The trick here is I dont have sql which creates the indexes. They are created by application setup so its not easy to just drop them and recreate in another tablespace.

    Any hints?





    #Support
    #SupportMigration
    #IBMi


  • 2.  RE: DB2 indexes management

    Posted Fri November 27, 2020 06:36 AM

    Hello.

    I was tasked with moving indexes to dedicated tablespace. It seems to be reasonable but the more I read the bigger my suspicion is that it may be pointless.

    So here are my questions:

    1. Is it possible to easily move index to another tablespace?
    2. Is it possible to get a SQL DDL for all indexes on a table?
    3. Does this make sense to move the indexes to dedicated tablespace?

    The trick here is I dont have sql which creates the indexes. They are created by application setup so its not easy to just drop them and recreate in another tablespace. https://9apps.ooo/

    Any hints?

    issue got solvedd





    #Support
    #SupportMigration
    #IBMi


Related Content