RE: RE: amy_m05_s020_mart_extract taking way too long aft er upgrade of TEDW 1.1 to 1.2

Has anyone tried resetting AMY to fix similar problems to this ? From the
support pages, it seems resetting AMX and AMY has been used to resolve
issues of missing data, but there seems to be no mentioned of helping when
data collection takes to long.

Funny thing it says that resetting means that the first time it runs it will
take longer ... lol ... it already takes more than 2 days !!

This problem occurs for TDW 1.2, and when patched to TDW 1.2 FP02.  However
it only became a problem after going from TDW 1.1 FP03, ITM 5.1.1 FP06.

Best regards

David Weir

>  -----Original Message-----
> From:         owner-tme10@xxxxxxxxxxxxxxxx@ING-MM   On Behalf Of
> <Marcel.Booms@xxxxxxxxxxx>
> Sent: Monday, 8 November 2004 7:48 PM
> To:   tme10@xxxxxxxxxxxxxxxx
> Subject:      [tme10] RE: amy_m05_s020_mart_extract taking way too long
> after upgrade of    TEDW 1.1 to 1.2
> 
> 
> Hi David,
> I recently discovered that AMY is taking way too long to complete. Indeed,
> every time it's the update twg.extract_control statement which can take
> several hours to complete.
> If you have any new information, let me know.....
> Env: TEDW 1.2, ITM 5.1.1 FP6, ITM for Databases.
> Regards,
> Marcel Booms
>        -----Oorspronkelijk bericht-----
>       Van:    owner-tme10@xxxxxxxxxxxxxxxx
> [mailto:owner-tme10@xxxxxxxxxxxxxxxx <mailto:owner-tme10@xxxxxxxxxxxxxxxx>
> << File: mailto:owner-tme10@xxxxxxxxxxxxxxxx
> <mailto:owner-tme10@xxxxxxxxxxxxxxxx>  >> ]  Namens Weir, David
>       Verzonden:      donderdag 4 november 2004 5:58
>       Aan:    'tme10@xxxxxxxxxxxxxxxx'
>       Onderwerp:      amy_m05_s020_mart_extract taking way too long after
> upgrade of TEDW 1.1 to 1.2
> 
>       Hi
> 
>       Environment:
> 
>       TEDW 1.1
>       ITM 5.1.1 FP6
> 
>       Upgraded to
> 
>       TEDW 1.2
> 
>       The process amy_m05_s020_mart_extract process now taking over 50
> hours, instead of less than 1 hour after upgrade.
> 
>       Noted from log some times, these long elapse times, always for
> twg.extract_control.  Any suggestions ?  Will be upgrading to ITM 5.1.2
> FP01.
> 
>       amy_m05_s020_mart_extract 
> 
>        ========================
>         = Script file line #  : 242
>         = Exec at Source DS   : TWH_CDW (IBM DB2)
>         = SQL Statement       : "update twg.extract_control set
> extctl_to_intseq = ( select VALUE(max_value,-1) from AMY.ve_STG_CPU_HR )
> where extctl_source= 'TWG.MSMT' and extctl_target= 'AMY.STG_CPU_HR' and
> exists ( select max_value from AMY.ve_STG_CPU_HR )"
> 
>         = Elapsed Time        : 07:31:46.453
>         = Rows Modified       : 1
>         = Successful Execution: No Errors
>         ========================
> 
>       = Script file line #  : 1059
>         = Exec at Source DS   : TWH_CDW (IBM DB2)
>         = SQL Statement       : "update twg.extract_control set
> extctl_to_intseq = ( select VALUE(max_value,-1) from AMY.ve_STG_MEMORY_HR
> ) where extctl_source= 'TWG.MSMT' and extctl_target= 'AMY.STG_MEMORY_HR'
> and exists ( select max_value from AMY.ve_STG_MEMORY_HR )"
> 
>         = Elapsed Time        : 03:43:55.532
>         = Rows Modified       : 1
>         = Successful Execution: No Errors
>         ========================
> 
>        ========================
>         = Script file line #  : 1286
>         = Exec at Source DS   : TWH_CDW (IBM DB2)
>         = SQL Statement       : "update twg.extract_control set
> extctl_to_intseq = ( select VALUE(max_value,-1) from AMY.ve_STG_NETWORK_HR
> ) where extctl_source= 'TWG.MSMT' and extctl_target= 'AMY.STG_NETWORK_HR'
> and exists ( select max_value from AMY.ve_STG_NETWORK_hr )"
> 
>       Best regards
> 
>       David Weir
> 
>       IMPORTANT NOTICE
>       This communication including any file attachments is intended solely
> for the use of the individual or entity to whom it is addressed. If you
> are not the intended recipient, or the person responsible for delivering
> this communication to the intended recipient, please immediately notify
> the sender by e-mail and delete the original transmission and its
> contents. Any unauthorised use, dissemination, forwarding, printing, or
> copying of this communication including any file attachments is
> prohibited.
> 
>       It is your responsibility to scan this communication including any
> file attachment for viruses and other defects. To the extent permitted by
> law, ING and its associates will not be liable for any loss or damage
> arising in any way from this communication including file attachments.
> 
> -----------------------------------------------------------------
> ATTENTION:
> The information in this electronic mail message is private and
> confidential, and only intended for the addressee. Should you
> receive this message by mistake, you are hereby notified that
> any disclosure, reproduction, distribution or use of this
> message is strictly prohibited. Please inform the sender by
> reply transmission and delete the message without copying or
> opening it.
> Messages and attachments are scanned for all viruses known.
> If this message contains password-protected attachments, the
> files have NOT been scanned for viruses by the ING mail domain.
> Always scan attachments before opening them.
> -----------------------------------------------------------------
>

<<application/ms-tnef>>