In the table schema all fields are varchar.
The DB is based on AL32UTF8
The CCSID of the broker is 5348
In the queue it looks as 1208 546 and Message data is human readable.
I don't know what DataCaptureStore/ODBC Driver are based on
From DB Logs
INSERT INTO IIBDBA.WMB_MSGS (WMB_MSGKEY,HAS_BITSTREAM,HAS_EXCEPTION,HAS_USERDATA,EVENT_TYPE,EVENT_NAME,EVENT_SRCADDR, BROKER_NAME,BROKER_UUID,EXGRP_NAME,EXGRP_UUID,MSGFLOW_NAME,MSGFLOW_UUID,APPL_NAME,APPL_UUID, LIBRARY_NAME,LIBRARY_UUID,NODE_NAME,NODE_TYPE,DETAIL,TERMINAL_NAME,KEY_FLD_1_NM,KEY_FLD_2_NM,KEY_FLD_3_NM, KEY_FLD_4_NM,KEY_FLD_5_NM,EVENT_TIMESTAMP,LOCAL_TRANSACTION_ID,PARENT_TRANSACTION_ID,GLOBAL_TRANSACTION_ID)VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30)
Part1 of the insert statement looks okay.
Part2, The parameters look like garbage
I will try to get access to ODBC Trace logs
------------------------------
Matthias Jungbauer
------------------------------
Original Message:
Sent: Wed February 10, 2021 08:32 AM
From: Francois Brandelik
Subject: IIB10 Monitoring - DataCaptureStore - not consuming?
Is Oracle trying to identify hex values as characters? Did the data get saved with the correct CCSID for the DB?
------------------------------
Francois Brandelik
Original Message:
Sent: Tue February 09, 2021 11:48 AM
From: Matthias Jungbauer
Subject: IIB10 Monitoring - DataCaptureStore - not consuming?
At the Oracle server it looks like garbage
------------------------------
Matthias Jungbauer
Original Message:
Sent: Tue February 09, 2021 05:18 AM
From: Matthias Jungbauer
Subject: IIB10 Monitoring - DataCaptureStore - not consuming?
I made progress.
What helped was
https://github.com/DAVEXACOM/IIB-FEM/blob/master/FEMScripts/RnRsetup/IIB%20configurable%20service%20and%20monitoring.txt
mqsichangeflowmonitoring TESTNODE -c active -e default -j
Now the messages are getting consumed.
------------------------------
Matthias Jungbauer
Original Message:
Sent: Mon February 08, 2021 06:29 PM
From: Yvonne McGinnis
Subject: IIB10 Monitoring - DataCaptureStore - not consuming?
Matthias,
Did you see the following link? It breaks it down by operating system. See if this helps.
https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bj23076_.html
Yvonne
------------------------------
Yvonne R. McGinnis
DevOps (hopeful), Systems Administration
Obama Foundation, Chicago
Chicago Cato, Illinois
773-886-5579
Original Message:
Sent: Sun February 07, 2021 04:06 PM
From: Matthias Jungbauer
Subject: IIB10 Monitoring - DataCaptureStore - not consuming?
Hello
Maybe you can help me with something.
I would like to put iib events into an Oracle DB.
https://www.ibm.com/support/knowledgecenter/SSMKHH_10.0.0/com.ibm.etools.mft.doc/bj28420_.html
Somewhere I'm missing something.
I have created the DataCaptureSource with the topic.
And a DataCaptureStore with the queue - SYSTEM.BROKER.DC.RECORD and dataSourceName IIB.
What do I need next, so that the Store goes into the Database?
mqsicvp does not complain about the datasource.
mqsicvp TESTNODE -n IIB
BIP8299I: User 'IIB' from security resource name 'IIB' will be used for the connection to datasource 'IIB'.
BIP8270I: Connected to Datasource 'IIB' as user 'IIB'. The datasource platform is 'Oracle', version '11.02.0020'.
------------------------------
Matthias Jungbauer
------------------------------