Results 1 to 8 of 8
  1. #1
    Join Date
    May 2003
    Location
    Hong Kong
    Posts
    25

    Unanswered: Cannot create database on a mapped drive

    I am using DB2 9 DataWarehouse Edition, on a Win Server 2003 Service Pack 2 64bit edition.

    I want to create a database on a mapped drive. For testing, I simply shared a folder from c:, then mapped it as e:. Then I used Control Center to create a new standard database. The generated command is as follow:

    CREATE DATABASE TESTMAP AUTOMATIC STORAGE YES ON 'E:\storage' DBPATH ON 'E:\' USING CODESET UTF-8 TERRITORY TW COLLATE USING SYSTEM PAGESIZE 4096;

    I got the error message SQL1052N:
    SQL1052N The database path "E:\" does not exist.




    Then I tried to use e: only for storage path, and use c: for db path:

    CREATE DATABASE TESTMAP AUTOMATIC STORAGE YES ON 'E:\' DBPATH ON 'C:\' USING CODESET UTF-8 TERRITORY TW COLLATE USING SYSTEM PAGESIZE 4096;

    I got the error message SQL1051N:
    SQL1051N The path "E:\" does not exist.



    I released the access right (Full Control) of the shared folder and e: to EVERYONE. I set the DB2 global registry parameter DB2_CREATE_DB_ON_PATH to YES. But none of these helped.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    this is not supported - and I even think that backup to shared drive is not supported also.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Sep 2004
    Posts
    24
    How did you install sucessfully the Datawarehouse Edition Ver. 9
    on a Windows Server 2003 64 Bit?

    An IBM´ler tryed it about 6 hours without success!

    Can you give me some advice how to install?

    Is your Query Patroller running? (or the Mining functions?)

  4. #4
    Join Date
    May 2003
    Location
    Hong Kong
    Posts
    25
    Quote Originally Posted by anwyuta
    How did you install sucessfully the Datawarehouse Edition Ver. 9
    on a Windows Server 2003 64 Bit?

    An IBM´ler tryed it about 6 hours without success!

    Can you give me some advice how to install?

    Is your Query Patroller running? (or the Mining functions?)
    Sorry, ours was also installed by an IBM staff. I don't know much about how he did it.

    We haven't tested the mining functions yet. But if you just ask whether the Query Patroller is running or not, then yes, the Windows service "DB2 Query Patroller" can be started.

  5. #5
    Join Date
    Sep 2004
    Posts
    24
    Ok...thanks for your answer.

    Last Question: Did you install the 64 Bit Version (of DB2)
    on your Windows 64 Bit Machine?

    I know that the 32 Bit stuff will work but make no sense on a
    64 Bit hardware.

    Maybe we can give the 64 Bit installation a new try if it works for you.

    regards
    anwy

  6. #6
    Join Date
    May 2003
    Location
    Hong Kong
    Posts
    25
    Quote Originally Posted by anwyuta
    Last Question: Did you install the 64 Bit Version (of DB2)
    on your Windows 64 Bit Machine?
    We are using 64bit DB2. As you said, it would be meaningless otherwise.

    But, a bit off topic, now we face another problem: the Business Objects Enterprise does not support 64bit Windows....... so we might have to switch back to 32bit after all......sigh....

  7. #7
    Join Date
    Sep 2004
    Posts
    24
    Thanks for your answer.

    The installation on a 64 Bit machine is very important for me.
    Can you please tell me the exactly Version of the DB2 you use (DB2 and/or DB2 DWE because a 64 Bit Datawarehouse Edition is not available) ?
    It might help me at next installation-try

    Tanks in advance.
    anwy

  8. #8
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by Lapson
    But, a bit off topic, now we face another problem: the Business Objects Enterprise does not support 64bit Windows....... so we might have to switch back to 32bit after all......sigh....
    Why do you think so? Just run your 32-bit application against a 64-bit DB2 server.
    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
  •