[IQUG] How many rows updated...

Cathy.Pearce at Euroclear.com Cathy.Pearce at Euroclear.com
Wed Dec 14 10:04:33 MST 2016


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/5fd79f98/attachment.html>


More information about the IQUG mailing list