Professional Web Applications Themes

Same Database on Same System - IBM DB2

Hi, I have two people that will be using the same system to do their DB2 testing, but I want each of them to have their own database. Can anyone step me through setting up two copies of the same database on the same system. I am running DB2 V6.1 on Windows 2000. I have created a second instance using db2icrt, but when I try to create the database it gives me the following message: SQL1005N The database alias "DBNAME" already exists in either the local database directory or system database directory. Thanks Ron...

  1. #1

    Default Same Database on Same System

    Hi,

    I have two people that will be using the same system to do their DB2
    testing, but I want each of them to have their own database. Can
    anyone step me through setting up two copies of the same database on
    the same system. I am running DB2 V6.1 on Windows 2000.

    I have created a second instance using db2icrt, but when I try to
    create the database it gives me the following message:

    SQL1005N The database alias "DBNAME" already exists in either the
    local database
    directory or system database directory.

    Thanks
    Ron
    Ron VanDerMaarel Guest

  2. #2

    Default Re: Same Database on Same System

    "Ron VanDerMaarel" <vdm1965> wrote in message
    news:1b5085f9.0309151156.3660e773posting.google.c om...
    > Hi,
    >
    > I have two people that will be using the same system to do their DB2
    > testing, but I want each of them to have their own database. Can
    > anyone step me through setting up two copies of the same database on
    > the same system. I am running DB2 V6.1 on Windows 2000.
    >
    > I have created a second instance using db2icrt, but when I try to
    > create the database it gives me the following message:
    >
    > SQL1005N The database alias "DBNAME" already exists in either the
    > local database
    > directory or system database directory.
    >
    > Thanks
    > Ron
    You don't need a separate instance, just another database in the same
    instance. You can backup one database, and then restore it using another
    database name. Then the client program accessing the database can use the
    alias to change the name back to the original name (if needed).

    But no computer (client or DB2 server) can have the same alias name in their
    database directory. Existing database definitions need to be uncatalogued.



    Mark A Guest

Similar Threads

  1. how to cerate database ,for alocal system
    By kumarsajja in forum Macromedia Flash Data Integration
    Replies: 6
    Last Post: July 12th, 01:14 PM
  2. Database "template1" does not exist in the system catalog.
    By Aaron Mark in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: January 11th, 05:56 AM
  3. Content management system using backend database
    By Scott in forum ASP Database
    Replies: 13
    Last Post: July 3rd, 10:55 PM
  4. any file system in database with gnu gpl license ?
    By German Aracil Boned in forum PERL Beginners
    Replies: 0
    Last Post: August 25th, 07:54 PM
  5. Replies: 1
    Last Post: July 7th, 03:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139