Home Cezary Opacki

Cezary Opacki

Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it

You are what you write, one might say; and by that I mean that you will linger on in the memory of future generations based on what you achieve and create. The creation of this site has been a journey of self-discovery through which I have come closer to finding my calling and my true self. Finally, I’m learning about who I am. I can only hope that what I write here will be of interest and use to others.

Have fun,

Cezary Opacki

It is common to use the shell command redirection in PowerCenter. The feature allows one to use the ldapmodify command to load data to LDAP. To achieve this it is necessary to create an LDIF flat file. Some data in the file must be in UTF-8 code page and Base64 encoded.

The Data Queue & CDC Connector for i5/OS is a real time connector. Below I present Change Data Capture solution for i5/OS(AS/400) which does not stop in case of table structure alteration as table structures are discovered in real time.  

  • v1m2r2 version of the connector is featured with:
    • change data capture for i5/OS. It means Power Center can read online changes from i5/OS (as/400) database.
    • data queue connector for keyed, FIFO and LIFO data queue.
    • the connector is used to develop replication worflows.


PowerExchange for Websphere MQ returns RFH2 message in binary format. Convert the RFH2 message in binary format to something readable by mapping transformations.



These tools enable one to develop mapping, which reads requests through the “PowerExchange for Websphere MQ” connector and sends replies, if required to temporary, dynamic queues. Messages are exchanged in RFH2 format, which is compliant with JMS. Source queues and queue managers are defined by PowerExchange for MQ connector. Target queues and queue managers are dynamically calculated in the mapping.   


The most likely reason for the following error in "Domain logs":

Service Process [IS_ascii] output error [ERROR: Unexpected condition at file:[..\utils\pmmetrics.cpp] line:[2111]. Application terminating. Contact Informatica Technical Support for assistance.].

The article discusses some issues regarding an upgrade from PowerCenter 9.0 to 9.0.1. The rules seem to apply every PowerCenter version.


It is worth to notice a paragraph in the MQ Series configuration file located in folder <MQ Series Installation folder>\conv\table\ccsid.tbl

It is said as follows:

Migrating java transformation from MQ 6.x to MQ 7.0 requires some changes in the java code. Selected ones are listed below:

All terms used in the article are explained in “PowerExchange for LDAP User Guide”.

The example shows how to send rows to a LDAP target where the Parent_Group represents the DN which is to be changed.

PowerExchange on the as/400 site runs job DTLLST3. Since version 9.0.0 two threads are executed under the job. This makes the job multithreaded. In a multithreaded job, some os/400 functions, called "not thread safe", end with escape exception.

Page 2 of 4