Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Posts
    16

    Unanswered: changing schema db2 9.5 for windows

    Hello,

    I am a n00b here. So, question how do I change the schema of a database? Currently, I login to windows as administrator and I want to change the schema to admin. I have also added the admin user to my windows users group. I beleive admin also belongs to the db2admin group..

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What do you mean to change the schema of a database?

    Andy

  3. #3
    Join Date
    Sep 2008
    Posts
    16
    owner/creator?

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    There are two new system supplied stored procs to do this

    ADMIN_COPY_SCHEMA
    ADMIN_DROP_SCHEMA

    You can search the doc or google to get input parms. The only problem I found is that it does not reset the sequences or identity columns to the same value as the old schema.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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