Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: issue with current schema


    I want create some tables with schema "DB2ADMIN" in DB2 control center.

    So I do "db2admin stop" and "db2admin setid db2admin"
    and give current password and db2admin start

    when I open db2 control center, but SQL-Authorization-ID is not "db2admin"

    any one can help on this ?

  2. #2
    Join Date
    Mar 2010
    ok, I got it .

    choose your database and choose query, and give the command "set current schema = db2admin" and run it

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    I prefer to always qualify all objects with their schema name to make sure you don't run into problems if the SET CURRENT SCHEMA has been forgotten. Besides, there are other objects like UDFs, where different special registers (e.g. CURRENT FUNCTION PATH) are used for resolution.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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