+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 20

Db2 tables consistency check

  1. 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



  2. Re: Db2 tables consistency check

    "Stefano" wrote in message
    news:bf5kuk$bej3k$1@ID-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?



  3. Re: Db2 tables consistency check

    "Stefano" wrote in message
    news:bf5kuk$bej3k$1@ID-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?



  4. 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" wrote in message
    news:KMsRa.2566$lf1.195030@news.uswest.net...
    > "Stefano" wrote in message
    > news:bf5kuk$bej3k$1@ID-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?
    >
    >




  5. 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" wrote in message
    news:KMsRa.2566$lf1.195030@news.uswest.net...
    > "Stefano" wrote in message
    > news:bf5kuk$bej3k$1@ID-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?
    >
    >




  6. Re: Db2 tables consistency check

    db2dart is the consistency checking tool.

    "Stefano" wrote in message
    news:bf5o35$bhoqm$1@ID-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" wrote in message
    > news:KMsRa.2566$lf1.195030@news.uswest.net...
    > > "Stefano" wrote in message
    > > news:bf5kuk$bej3k$1@ID-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?
    > >
    > >

    >
    >




  7. Re: Db2 tables consistency check

    db2dart is the consistency checking tool.

    "Stefano" wrote in message
    news:bf5o35$bhoqm$1@ID-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" wrote in message
    > news:KMsRa.2566$lf1.195030@news.uswest.net...
    > > "Stefano" wrote in message
    > > news:bf5kuk$bej3k$1@ID-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?
    > >
    > >

    >
    >




  8. Re: Db2 tables consistency check

    use db2dart

  9. Re: Db2 tables consistency check

    use db2dart

  10. 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



+ Reply to Thread
Page 1 of 2 1 2 LastLast