Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2013
    Posts
    3

    Unanswered: change the name of DB2 schema

    I have two DB2 schemas: S1 og S2. Backend in my RAD7.5 uses S1, but I need now S2.
    How can I change the schema name in my java program?
    Thank in Advanced!

    ILHE
    Last edited by ilhe; 07-25-13 at 04:06. Reason: fail title

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is the purpose - please be specific
    do you want to rename the schema in the db ?
    depending on the platform/version : have a look at official doc
    IBM DB2 9.7 for Linux, UNIX and Windows Information Center
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jul 2013
    Posts
    3
    One scheme is for test and another is for production(this is not my idea).
    I use Websphere RAD7.5 for Development. There is S1 scheme in backend and I need there S2.
    I use SEARCH FILE in project and can see on two places that S1 is in use (in properties), but it is not visible in GUI to edit it and change to S2. In database is nothing to change.
    Thanks!
    ilhe

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    so - in db nothing to change -->>> this problem is for another forum.. nothing todo with DB2.....
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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