[IQUG] How many rows updated...

Cathy.Pearce at Euroclear.com Cathy.Pearce at Euroclear.com
Thu Dec 15 01:33:49 MST 2016


Hi Chris,

Thanks.

That confirms our findings.

Cathy



From:   "Baker, Chris" <c.baker at sap.com>
To:     "Cathy.Pearce at Euroclear.com" <Cathy.Pearce at Euroclear.com>, 
"iqug at iqug.org" <iqug at iqug.org>
Date:   14/12/2016 17:16
Subject:        RE: [IQUG] How many rows updated...



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 | M +1 647-224-2033 | TF +1 866-716-8860
SAP Canada Inc. 4120 Yonge Street, Suite 600, Toronto, M2P 2B8
c.baker at sap.com | www.sap.com
 
https://sap.na.pgiconnect.com/I826572
Conference tel: 1-866-312-7353,,9648565377#
 
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
 


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/20161215/fbbc35bf/attachment.html>


More information about the IQUG mailing list