PostgreSQL as the source does not support BIT (Data type )
We use CDC as the main real-time synchronization tool. However, when a postgresql database is encountered, when there are BIT data type tables in the table, the table cannot be copied using cdc. As a result, many data on the production line cannot...
Virtual Table Name should be longer than 50 characters.
When creating Virtual tables we decided as standard to maintain the default Target Virtual Table Name that is build as follow: ConncectionName_Schema_Tablename In some cases this turns out to be longer than 50 chars. and when trying to create it s...
When DB2 writes a message to the DB2 Log, DB2 could also optionally write the contents of the message to a new IBM Catalog Table SYSIBM.DB2_Messages or a user defined table.
WHY THIS IS A GOOD IDEA Many of our DB2 subsystems and members remain active for several months or more. Searching for a DB2 Message can take a long time in SDSF when analysing and diagnosing problems. Having all of the DB2 Messages in a Table mak...
3 months ago
in Db2 for z/OS
1
Not under consideration
We use various COGNOS components, which are however to be seen as parts of an overall product. Reports, framework manager packages, TM1 cubes, etc. are interdependent and must be handled accordingly.In concrete terms, this means that consistency m...
Add Supported Source and Targets to CloudSQL and AlloyDB on GCP
I have a Client need to InfoSphere Change Data Delivery (v11.4) support at this time a Solutions CloudSQL(Postgre v13) and AlloyDB (Postgre v14), in this case the client need to replicate the IBM AS400 DB2 in preference with AlloyDB Solution. Has ...
TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube
The Bedrock data copy TI process is the most basic requirement for a in memory solution. The highest priority would be to achieve this outcome. The following additional requirements would be nice to have on top of the basic requirement: 1. The abi...
In customer setups we usually have to define "system queries" to be used by jobs, case investigation, hyperlinks. It is a very common scenario when users change such queries to perform some searches and break the system setup- hyperlinks showing e...
Users do not get prompted that their session may be about to time out. Adding a warning similar to Bank websites that warn you your session is about to end. We could for example provide the user the opportunity to save work, extend the session, or...
Most modern application providing import features do have a simulation option that enable to check what lines / data cannot be integrated because of rules. This enable the users to correct the import without changing the content (e.g. : the lines ...