Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Toronto, Canada

    Unanswered: how to rename schema?

    db2 v8.2 on AIX 5/db2 v9.5 on AIX 6
    We need to change schema for abt 200 db2 tables (containing data) from AAA to BBB.

    db2move seem like a good idea but it's working only between databases and it does not copy indexes.

    Looks like admin_copy_schema does it within same database, but I need to copy tables data and rename indexes schemas as well. How and can I use it for this purpose? I guess we would have to drop existing packages and recreate them for new schema as this is a condition for this API.

    The database is on v8.2 now so I am thinking we might have to wait till we upgrade to v9.5 and then do it.

    Any thoughts?
    Last edited by MarkhamDBA; 07-08-09 at 17:31.
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  2. #2
    Join Date
    Jul 2009
    Create all objects in the new schema, then copy data. Packages will have to be re-bound.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts