[IQUG] How many rows updated...

Baker, Chris c.baker at sap.com
Wed Dec 14 10:16:47 MST 2016


The update is a bulk update not row-by-row, so changes to the records are applied as a bulk operation.  As  it is not allowed to complete, then the whole update is rolled back.

Chris

Chris Baker | Platform Architect | STIG | Customer Innovation & Enterprise Platform | SAP
T +1 416-226-7033<tel:+1%20416-226-7033> | M +1 647-224-2033<tel:+1%20647-224-2033> | TF +1 866-716-8860<tel:+1%20866-716-8860>
SAP Canada Inc. 4120 Yonge Street, Suite 600, Toronto, M2P 2B8<x-apple-data-detectors://17/1>
c.baker at sap.com<mailto:c.baker at sap.com> | www.sap.com<http://www.sap.com/>

https://sap.na.pgiconnect.com/I826572
Conference tel: 1-866-312-7353,,9648565377#<tel:1-866-312-7353,,9648565377%23>

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Cathy.Pearce at Euroclear.com
Sent: Wednesday, December 14, 2016 12:05 PM
To: iqug at iqug.org
Subject: [IQUG] How many rows updated...

Hi All,

Trying to assess the impact of a user update statement impact.

It was run without the where clause ;-(
But killed by the user within  a few seconds.

IQmsg log shows:
I. 12/14 15:29:53. 0000515973 Update Started:
I. 12/14 15:29:53. 0000515973 PF_PAR_SEC_BAL
I. 12/14 15:29:56. 0000515973 [20897]:  100000 Rows, 3 Seconds
I. 12/14 15:29:57. 0000515973 [20897]:  200000 Rows, 1 Seconds
I. 12/14 15:29:58. 0000515973 [20897]:  300000 Rows, 1 Seconds
I. 12/14 15:29:59. 0000515973 [20897]:  400000 Rows, 1 Seconds
I. 12/14 15:30:01. 0000515973 [20897]:  500000 Rows, 2 Seconds
I. 12/14 15:30:02. 0000515973 [20897]:  600000 Rows, 1 Seconds
I. 12/14 15:30:03. 0000515973 [20897]:  700000 Rows, 1 Seconds
I. 12/14 15:30:04. 0000000000 Cancellation request received:  SA connHandle: 25063  SA connID: 6  IQ connID: 0000515973  User: devps
I. 12/14 15:30:04. 0000515973 Exception Thrown from slib/s_run.cxx:800, Err# 0, tid 909 origtid 909
I. 12/14 15:30:04. 0000515973    O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16

I can't find an rollback message.  Will these updates have been committed?

We are trying to assess the damage!

Thanks,
Cathy


For info:  from user sql log:
=,<,25063,PREPARE,update "o_gdwh_fct"."PF_PAR_SEC_BAL"   set "SEC_NOM_VL" = ("SEC_NOM_VL"/1833),   "SEC_EUR_NOM_VL" = ("SEC_EUR_NOM_VL"/1833),   "SEC_USD_NOM_VL" = ("SEC_USD_NOM_VL"/1833),   "SEC_MKT_VL" = ("SEC_MKT_VL"/1833),   "SEC_EUR_MKT_VL" = ("SEC_EUR_MKT_VL"/1833),   "SEC_USD_MKT_VL" = ("SEC_USD_MKT_VL"/1833),   "SEC_ADJ_MKT_VL" = ("SEC_ADJ_MKT_VL"/1833),   "SEC_EUR_ADJ_MKT_VL" = ("SEC_EUR_ADJ_MKT_VL"/1833),   "SEC_USD_ADJ_MKT_VL" = ("SEC_USD_ADJ_MKT_VL"/1833)
=,>,25063,PREPARE,393422
+1,<,25063,COMMIT
+3,>.,25063
+1,<,25063,EXEC,393422
+1359,E,25063,-299,Statement interrupted by user
=,>,25063,EXEC
+2,<,25063,DROP_STMT,393422
=,>,25063,DROP_STMT
=,<,25063,VALIDATE_STMT,262344
=,>,25063
+1,<,25063,COMMIT
+15,>.,25063
+1,<,25063,OPEN,262344
+9,>,25063,OPEN,196815
+519,<,25063,CLOSE,196815
=,I,25063,0,2,0,NOSCROLL*+READONLY+HOLD
+20,>,25063,CLOSE
+1,<,25063,CACHED_DROP_STMT,262344
=,>,25063
=,<,25063,PREPARE,rollback work
=,>,25063,PREPARE,393424
+1,<,25063,COMMIT
+4,>.,25063
+1,<,25063,EXEC,393424
=,>,25063,EXEC

This e-mail message, including any attachments transmitted with it, is

CONFIDENTIAL and may contain legally privileged information. This message is

intended solely for the use of the individual or entity to whom it is addressed. If

you have received this message in error, please notify us immediately and delete

it from your system. Please visit our website to read the full disclaimer

http://www.euroclear.com/site/public/disclaimer" and for Euroclear Group company

information https://www.euroclear.com/en/about/our-structure/Corporate-details.html


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20161214/140ce7a3/attachment-0001.html>


More information about the IQUG mailing list