Professional Web Applications Themes

Db2 tables consistency check - IBM DB2

Hi all, I want to know if there's an utility to check the consistency of tables in a DB2 db. I think i've got a broken table but i don't how can i solve this problem Thanks in advance Stefano...

  1. #1

    Default Db2 tables consistency check

    Hi all,


    I want to know if there's an utility to check the consistency of tables in a
    DB2 db. I think i've got a broken table but i don't how can i solve this
    problem


    Thanks in advance


    Stefano


    Stefano Guest

  2. #2

    Default Re: Db2 tables consistency check

    "Stefano" <stefanonextgen.it> wrote in message
    news:bf5kuk$bej3k$1ID-175458.news.uni-berlin.de...
    > Hi all,
    >
    >
    > I want to know if there's an utility to check the consistency of tables in
    a
    > DB2 db. I think i've got a broken table but i don't how can i solve this
    > problem
    >
    >
    > Thanks in advance
    >
    >
    > Stefano
    >
    Need DB2 version and operating system. Also, when you say broken table, do
    you mean referential constraints, or problems just querying the table by
    itself?


    Mark A Guest

  3. #3

    Default Re: Db2 tables consistency check

    DB2 personal edition 7.1 on Linux server. I don't know exactly the problem,
    the only thing I know is that sometimes when i query a table system hangs
    and put me out a TCP/IP error problem. The problem is only when i quering a
    defined table.


    Thanks

    Stefano

    "Mark A" <maswitchboard.net> wrote in message
    news:KMsRa.2566$lf1.195030news.uswest.net...
    > "Stefano" <stefanonextgen.it> wrote in message
    > news:bf5kuk$bej3k$1ID-175458.news.uni-berlin.de...
    > > Hi all,
    > >
    > >
    > > I want to know if there's an utility to check the consistency of tables
    in
    > a
    > > DB2 db. I think i've got a broken table but i don't how can i solve this
    > > problem
    > >
    > >
    > > Thanks in advance
    > >
    > >
    > > Stefano
    > >
    > Need DB2 version and operating system. Also, when you say broken table, do
    > you mean referential constraints, or problems just querying the table by
    > itself?
    >
    >

    Stefano Guest

  4. #4

    Default Re: Db2 tables consistency check

    db2dart is the consistency checking tool.

    "Stefano" <stefanonextgen.it> wrote in message
    news:bf5o35$bhoqm$1ID-175458.news.uni-berlin.de...
    > DB2 personal edition 7.1 on Linux server. I don't know exactly the
    problem,
    > the only thing I know is that sometimes when i query a table system hangs
    > and put me out a TCP/IP error problem. The problem is only when i quering
    a
    > defined table.
    >
    >
    > Thanks
    >
    > Stefano
    >
    > "Mark A" <maswitchboard.net> wrote in message
    > news:KMsRa.2566$lf1.195030news.uswest.net...
    > > "Stefano" <stefanonextgen.it> wrote in message
    > > news:bf5kuk$bej3k$1ID-175458.news.uni-berlin.de...
    > > > Hi all,
    > > >
    > > >
    > > > I want to know if there's an utility to check the consistency of
    tables
    > in
    > > a
    > > > DB2 db. I think i've got a broken table but i don't how can i solve
    this
    > > > problem
    > > >
    > > >
    > > > Thanks in advance
    > > >
    > > >
    > > > Stefano
    > > >
    > > Need DB2 version and operating system. Also, when you say broken table,
    do
    > > you mean referential constraints, or problems just querying the table by
    > > itself?
    > >
    > >
    >
    >

    Michael Bhola Guest

  5. #5

    Default Re: Db2 tables consistency check

    use db2dart
    cchattoraj Guest

  6. #6

    Default Re: Db2 tables consistency check

    You can use db2dart for the db2 udb version.
    In DB2 UDB V8.x, you also use INSPECT, which allow you do online check.
    Regards,
    FRX

    Stefano wrote:
    > Hi all,
    >
    > I want to know if there's an utility to check the consistency of tables in a
    > DB2 db. I think i've got a broken table but i don't how can i solve this
    > problem
    >
    > Thanks in advance
    >
    > Stefano
    Fan Ruo Xin Guest

  7. #7

    Default Re: Db2 tables consistency check


    Do you know of any place that explains the INSPECT utility a
    little bit more?



    thanks



    Mark


    --
    Posted via [url]http://dbforums.com[/url]
    mark_maz Guest

  8. #8

    Default Re: Db2 tables consistency check

    mark_maz <member4504dbforums.com> wrote in message news:<3353167.1063207000dbforums.com>...
    > Do you know of any place that explains the INSPECT utility a
    > little bit more?
    >
    >
    >
    > thanks
    >
    >
    >
    > Mark
    I would recommend : Philip K. Gunning 'DB2 UDB Handbook for Windows,
    Unix, and Linux', pages 170-174

    Another great book : Snow, Phan 'Advanced DBA Certification Guide and
    Reference
    for DB2 UDB v8 for Linux, Unix, and Windows', small explanations for
    INSPECT
    on pages 668-669.

    Birger
    Northsea Guest

  9. #9

    Default Re: Db2 tables consistency check

    Maybe you can find related information on the db2dart tool.
    INSPECT command implements some of the db2dart functionnalities.

    PM


    "mark_maz" <member4504dbforums.com> a écrit dans le message de
    news:3353167.1063207000dbforums.com...
    >
    > Do you know of any place that explains the INSPECT utility a
    > little bit more?
    >
    >
    >
    > thanks
    >
    >
    >
    > Mark
    >
    >
    > --
    > Posted via [url]http://dbforums.com[/url]

    PM \(pm3iinc-nospam\) Guest

Similar Threads

  1. Consistency from FCS to FMS
    By bigfish in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: December 21st, 01:06 AM
  2. Page Size Consistency
    By Copesq in forum Macromedia Dynamic HTML
    Replies: 3
    Last Post: February 5th, 07:30 PM
  3. Empty data tables - Check
    By CF_starter in forum Coldfusion Database Access
    Replies: 5
    Last Post: September 14th, 04:23 PM
  4. consistency with Max after export?
    By rjwolfe2 webforumsuser@macromedia.com in forum Macromedia Director 3D
    Replies: 1
    Last Post: January 7th, 11:36 AM
  5. Difference between Reorg e consistency check
    By Stefano in forum IBM DB2
    Replies: 0
    Last Post: July 22nd, 10:05 AM

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