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

    Unanswered: issue with current schema

    Hello,

    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
    Posts
    9
    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
    Location
    Jena, Germany
    Posts
    2,721
    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
  •