1 2 Previous Next 16 Replies Latest reply on May 10, 2021 2:00 AM by Bibek Sahoo

    PWX 10.2 CDC no changed MVS DL rows returned

    Jorma Tirkkonen New Member

      Why PWX CDC Realtime do not return any changed MVS DL/1 segment rows even no errors on logs?

       

      Windows Server 2012 R2 Side

      - Informatica 10.2 HF2 / Power Center

      - PowerExchange 10.2 HF2

       

      MVS IMS DL & DB2 zOS

      - PowerExchange 10.2 HF2

       

      Mapping access method: IMS ODBA

      Registration type Synchronous, no Condense, saved without errors for CDC mappings

       

      Extraction group, Database Row Test: CAPXRT

      select * from d2imsb.bl22cdc_BL22

      Succeed without error but returns no rows even changes are made into DL segments

       

      MVS log example:

       

      PWXEDM172597I Reader initialized STC08045A0000046 at 2019.241 15:34:38.00, RC=0000, RSN=00000000

      PWXEDM172791I Reader STC08045A0000046 filter list has 1 entries

      PWXEDM172591I Reader STC08045A0000046 data transfer starts at 0000000000000000

      PWXEDM172591I Reader STC08045A0000046 data transfer   ends at 00000000AA380000

      PWXEDM172592I Reader STC08045A0000046 data transfer ended. 58 records selected,  0 records filtered.

      PWXEDM172591I Reader STC08045A0000046 data transfer starts at 00000000A7F80000

      PWXEDM172668I Reader STC08045A0000047 connected

      PWXEDM172597I Reader initialized STC08045A0000047 at 2019.241 15:34:42.24, RC=0000, RSN=00000000

      PWXEDM172791I Reader STC08045A0000047 filter list has 1 entries

      PWXEDM172591I Reader STC08045A0000047 data transfer starts at 0000000000000000

      PWXEDM172591I Reader STC08045A0000047 data transfer   ends at 00000000AA380000

      PWXEDM172592I Reader STC08045A0000047 data transfer ended. 58 records selected,  0 records filtered.

      PWXEDM172591I Reader STC08045A0000047 data transfer starts at 00000000A7F80000

       

       

      At PC Designer Power Exchange CDC/SQ import succeed ok for all registered mappings

       

      Continuous WF and CDC Realtime Session runs without errors or warnings from DL1 to DB2 zOS

       

      Session log example:

       

      Severity Timestamp Node Thread Message Code Message

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-04584 CAPXRT Application <BL22CDC_wf> CAPX type <CC> Extract map <d2imsb.bl22cdc.bl22> source type <IMS> After images No CDEP IO]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-21605 Connection selected CHANGES found from covr< > tag< IMSIMSBBLBL22100000> type< IMS> int< FALSE> method< CONN_NAME>.]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-21605 Connection selected LRAP found from covr< CHANGES> tag< > type< > int< TRUE> method< CONN_OVR>.]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-04565 Regn tag IMSIMSBBLBL22100000 sequence 0000000000000000000000000000000000000000 PowerExchange Logger 00000000000000000000000000000000]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-09970 CAPI i/f: Changed 1 sources to earliest sequence token]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-09959 CAPI i/f: Earliest UOW restart tokens: Sequence=0000000000000000000000000000000000000000 PowerExchange Logger=D7E7D3C24040EFFFFFFFFFFFFFFFFFFF]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-09950 CAPI i/f: Connect OK. Sources = 1 ]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-09957 CAPI i/f: Read times out after 2 seconds ]

      INFO 29.8.2019 15:34:38 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-09967 CAPI i/f: End of log for time 19/08/29 15:34:37 reached]

       

      Severity Timestamp Node Thread Message Code Message

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10783 CAPI: INFO: Monitor messages begin (2019/08/29 15:39:38).]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10740 CAPI: INFO: Interval return counts: no data 151, commits 0, inserts 0, updates 0, deletes 0.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10741 CAPI: INFO: Interval subordinate read counts: no data 0, commits 8, inserts 0, updates 0, deletes 0, backouts 0.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10742 CAPI: INFO: Interval resource maximums: Memory cache 0 KB, Spill files 0, Concurrent UOWs 0.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10745 CAPI: INFO: No data returned since the start of this extraction.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10743 CAPI: INFO: No noteworthy transactions.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10749 CAPI: INFO: + Current subordinate sequence number 00000000AA3800000000.]

      INFO 29.8.2019 15:39:39 node01 READER_1_1_1 PWXPC_10091 [INFO] [PWX-10784 CAPI: INFO: Monitor messages end (2019/08/29 15:39:38).]

        1 2 Previous Next