Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2012
    Posts
    177

    Unanswered: Getting error in the db2 update statement

    Hi all,

    In our setup db2 V9.7 with fixpack 4, using partitioned database.

    Facing issues in the update statement Getting the error like:

    SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
    query is an empty table. SQLSTATE=02000

    How to overcome this issue?

    Thanks,
    laxman.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Did you read the DB2 documentation for what SQL0100W means? You can also type in:
    db2 ? SQL0100W
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2012
    Posts
    177
    Hi Marcus,

    Thanks for your reply.

    I had googled for the mentioned error:

    WARNING:-

    SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
    query is an empty table. SQLSTATE=02000

    RESOLUTION :-
    --------------

    Question
    --------

    How can I ask Apply to ignore the SQL0100W warning messages that are returned by stored procedure?

    Answer
    -------

    The column ACCEPT_SQLSTATES in the ASN.IBMSNAP_SUBS_STMTS table can be set to sqlstate '02000' to inform Apply that sql0100w is an acceptable value. If ACCEPT_SQLSTATES is not set, then the IBMSNAP_APPLYTRAIL and IBMSNAP_APPLYTRACE tables will contain entries of this message. If too many of these messages are returned, DB2 logs might also fill up.

    For DB2, this message will not get logged in the db2diag.log file if the diaglevel is set to 3 and not 4.


    How to overcome this error?

    Thanks,
    laxman.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    are you serious ?
    if you do not know what this means, or why this is happening, you should NOT touch DB2 at all..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  5. #5
    Join Date
    Sep 2012
    Posts
    177
    Guy,

    Thanks for your reply.

    Diaglevel is in default level 3.

    How to apply this:
    The column ACCEPT_SQLSTATES in the ASN.IBMSNAP_SUBS_STMTS table can be set to sqlstate '02000' to inform Apply that sql0100w is an acceptable value. If ACCEPT_SQLSTATES is not set, then the IBMSNAP_APPLYTRAIL and IBMSNAP_APPLYTRACE tables will contain entries of this message. If too many of these messages are returned, DB2 logs might also fill up.

Posting Permissions

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