Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    155

    Unanswered: insert into -> rollback to savepoint

    Hallo everyone,

    I am running a sql code with INSERT INTO command. I am monitoring (with the tool DB2 Monitor) the run of the sql code. At the beginning it is stated:

    Code:
    executing
    At the moment it is stated:

    Code:
    rollback to savepoint
    Is it something normal? The "rows read" and "rows written" are not increasing anymore.

    Thank you.

    Regards,
    Ratna

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    probably something went wrong - look in appl.log or diag.log
    some info can be found at
    Progress monitoring of the rollback process
    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

  3. #3
    Join Date
    May 2012
    Posts
    155
    Hallo przytula_guy,

    I just came back from lunch. The rollback to savepoint is disappeared. The sql-code ist doing nothing now. Since it has stopped, I think I can not look at the appl.log or diag.log?

    Regards

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    rollback has finished..
    the diaglog file is located at db2 server and keeps all entries
    appl.log is the log created by the application if any..
    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

Posting Permissions

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