Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Any help on this error .

    D:\SGILL\JunLi>db2 insert into client (GIVEN_NAME) values ('00000')

    DB21034E The command was processed as an SQL statement because it was not a

    valid Command Line Processor command. During SQL processing it returned:

    SQL0901N The SQL statement failed because of a non-severe system error.

    Subsequent SQL statements can be processed. (Reason "parent in 1-1 rel.

    already has child".) SQLSTATE=58004


    db2 v9.5 FP4 CLIENT is view on CLIENT_IDV view which is further view on CLIENT_NEW table.

    Regards

  2. #2
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963
    This SQLCODE might occur when distributed commit processing
    encounters an error. In this case, all servers in the unit of work that
    support distributed two-phase commit backed out the unit of work. If a
    server that does not support distributed two-phase commit has updates in
    the unit of work, that server must be queried to determine if its updates
    were committed or backed out.

    Finally, this error might occur during commit if post-processing cannot be
    completed because of an update that changes the partition of a row.
    Resource unavailable problems can prevent the post-processing from
    completing. The existence of held cursors can prevent the post-processing
    from completing. Commit is failed. The transaction is aborted.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Looks like a db2 bug

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Yes, a SQL0901 is pretty much always a DB2 bug.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jan 2010
    Location
    USA
    Posts
    1

    Exploiting my broadband and High Definition cable TV

    A comrade of mine announced my high definition transmission depended upon how durable my digital cable tv signal was. I've bought a comcast cable television package that bundles my high-speed internet and digital cable tv with High definition channels together. My picture is terrific, i do not feel it could be significantly better. Still does any one know if there is any truth to what my buddy claims.

    SIGNATURE:

    __________________________________________________ __________
    comcast bundle deals for existing customers | comcast discount codes

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    PMR has been registered.

    Thanks for replies

Posting Permissions

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