Professional Web Applications Themes

db2dart and SQLERROR - IBM DB2

HI all, some days ago i've ask infos about db2dart use. Now, i've tried to run db2dart <dbname> /DB on my Linux server (running db2 7.1 enterprise server) but I always get sql error SQL1031N. I've tried to setup db with command: db2 catalog database xyz as xzy on /home/db2inst1/db2inst2/NODE0000/SQL00001 DB20000I The CATALOG DATABASE command completed successfully. DB21056W Directory changes may not be effective until the directory cache is refreshed. db2stop db2 start db2 list database directory Database 1 entry: Database alias = xyz Database name = xyz Local database directory = /home/db2inst1/db2inst2/NODE0000/SQL00001 Database release level = 9.00 Directory entry ...

  1. #1

    Default db2dart and SQLERROR

    HI all,

    some days ago i've ask infos about db2dart use. Now, i've tried to run
    db2dart <dbname> /DB on my Linux server (running db2 7.1 enterprise server)
    but I always get sql error SQL1031N.

    I've tried to setup db with command:

    db2 catalog database xyz as xzy on /home/db2inst1/db2inst2/NODE0000/SQL00001
    DB20000I The CATALOG DATABASE command completed successfully.
    DB21056W Directory changes may not be effective until the directory cache
    is refreshed.

    db2stop
    db2 start

    db2 list database directory

    Database 1 entry:

    Database alias = xyz
    Database name = xyz
    Local database directory = /home/db2inst1/db2inst2/NODE0000/SQL00001
    Database release level = 9.00
    Directory entry type = Indirect
    Catalog node number = -1


    db2dart xyz /DB

    SQL1031N The database directory cannot be found on the indicated file
    system.
    SQLSTATE=58031



    What's the bug?


    Thanks


    Stefano



    Stefano Guest

  2. #2

    Default Re: db2dart and SQLERROR

    Are you running EEE (multi-partition / multi-node) - there was a bug a
    long time back when db2dart had to be run from the catalog node on some
    EEE Unix flavours (HP for sure, and I think Linux as well).

    Stefano wrote:
    > HI all,
    >
    > some days ago i've ask infos about db2dart use. Now, i've tried to run
    > db2dart <dbname> /DB on my Linux server (running db2 7.1 enterprise server)
    > but I always get sql error SQL1031N.
    >
    > I've tried to setup db with command:
    >
    > db2 catalog database xyz as xzy on /home/db2inst1/db2inst2/NODE0000/SQL00001
    > DB20000I The CATALOG DATABASE command completed successfully.
    > DB21056W Directory changes may not be effective until the directory cache
    > is refreshed.
    >
    > db2stop
    > db2 start
    >
    > db2 list database directory
    >
    > Database 1 entry:
    >
    > Database alias = xyz
    > Database name = xyz
    > Local database directory = /home/db2inst1/db2inst2/NODE0000/SQL00001
    > Database release level = 9.00
    > Directory entry type = Indirect
    > Catalog node number = -1
    >
    >
    > db2dart xyz /DB
    >
    > SQL1031N The database directory cannot be found on the indicated file
    > system.
    > SQLSTATE=58031
    >
    >
    >
    > What's the bug?
    >
    >
    > Thanks
    >
    >
    > Stefano
    >
    >
    >
    Blair Adamache Guest

  3. #3

    Default Re: db2dart and SQLERROR


    "Blair Adamache" <badamache2muchspam.> wrote in message
    news:bgbthi$9im$1hanover.torolab.ibm.com...
    > Are you running EEE (multi-partition / multi-node) - there was a bug a
    I don't know anything about it....I don't know if I run EEE system
    > long time back when db2dart had to be run from the catalog node on some
    > EEE Unix flavours (HP for sure, and I think Linux as well).
    It's possible to upgrade to solve this bug? maybe to db2 7.2?

    Thanks

    Stefano


    Stefano Guest

  4. #4

    Default Re: db2dart and SQLERROR

    I guess your database was cataloged to the wrong place.

    Stefano wrote:
    > HI all,
    >
    > some days ago i've ask infos about db2dart use. Now, i've tried to run
    > db2dart <dbname> /DB on my Linux server (running db2 7.1 enterprise server)
    > but I always get sql error SQL1031N.
    >
    > I've tried to setup db with command:
    >
    > db2 catalog database xyz as xzy on /home/db2inst1/db2inst2/NODE0000/SQL00001
    > DB20000I The CATALOG DATABASE command completed successfully.
    > DB21056W Directory changes may not be effective until the directory cache
    > is refreshed.
    >
    > db2stop
    > db2 start
    >
    > db2 list database directory
    >
    > Database 1 entry:
    >
    > Database alias = xyz
    > Database name = xyz
    > Local database directory = /home/db2inst1/db2inst2/NODE0000/SQL00001
    > Database release level = 9.00
    > Directory entry type = Indirect
    > Catalog node number = -1
    >
    > db2dart xyz /DB
    >
    > SQL1031N The database directory cannot be found on the indicated file
    > system.
    > SQLSTATE=58031
    >
    > What's the bug?
    >
    > Thanks
    >
    > Stefano
    Fan Ruo Xin Guest

Similar Threads

  1. SQlerror while updating/deleting
    By Student-Kav in forum Coldfusion Database Access
    Replies: 4
    Last Post: November 8th, 02:38 PM
  2. #14254 [Com]: SQLERROR -439
    By shai at shai dot org in forum PHP Development
    Replies: 1
    Last Post: September 16th, 02:48 PM
  3. error from db2dart
    By xixi in forum IBM DB2
    Replies: 2
    Last Post: August 12th, 04:17 PM
  4. DB2DART SYNTAX
    By radhika in forum IBM DB2
    Replies: 0
    Last Post: July 18th, 07:54 PM
  5. WHENEVER SQLERROR does'nt always work
    By Sybrand Bakker in forum Oracle Server
    Replies: 5
    Last Post: June 30th, 04:38 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