DSXchange

You would issue the catalog commands on the engine server.

The node name would be the hostname of your repository server and the ip address would be that of your repository server. The port or service name would be whatever DB2 is listening on.

Mike

To see what you have catalogued currently:
Mike

Your original error looks like a library path issue to me (before the database catalog even comes into play).

Just to make sure we cover the obvious first: You have installed a DB2 client instance on your engine computer. Yes?

Mike

I believe you will need to catalog both the remote node and the remote database on your engine computer. Check the DB2 command documentation in the knowledge center for the exact syntax and command options. It should look something like this: db2 catalog tcpip4 node <node name> remote <ip address> s...

And the change capture stage expects unique keys on both of its input links.

You won't get a warning or fatal error if there are duplicate keys, but the generated change_code may be inaccurate.

For debugging purposes, check for duplicate keys on each input link.

Mike

arvind_ds wrote:error querying the PMR|3.txt table.

Special character in your text file name?

Try escaping the special character: PMR\|3.txt

Mike

I used to use a mainframe utility program called FileAid to view mainframe COBOL datasets in ISPF a long time ago. It would format data into human readable form using the COBOL copybook. I would be surprised if you couldn't find some kind of open source equivalent to do something similar on a window...

Do you have all of the patches for your version?

I was prepping for an 11.3.1 installation at the beginning of the year and there were several patches related to SAP that were needed post-installation.

Mike

This warning is pretty straight forward. It's just telling you that the restart run is using different parameter values than the original run. The first entry of a job log will tell you what parameter values are being used in a run. To eliminate the warning make sure the restart run uses the same va...

The character set encoding that the web service is using will determine how many bytes are used to encode that particular character. It would be 3 bytes in UTF-8 (a variable width character set). It would be 2 bytes in UTF-16 (a fixed width character set). You will have to use transform functions th...

Seems to me that BASIC isn't needed. I would think the parallel transform functions listed by qt_ky should give you what you need.

Mike

Your schema file does not describe your data file contents. You've defined all fixed-width strings. Are you sure you want to do that for a delimited file?

Mike

Always best to check Appendix B of the Parallel Job Developer's Guide for currently available built-in transform functions. Having said that though, I don't recall any. If you can afford to use a BASIC transformer in a parallel job or a BASIC routine in a job sequence, I'm pretty sure there are BASI...

It seems like the CFF stage has done all of the work for you. Sounds to me like your binary input has been converted to a signed integer. In that case, low values (all bits off) will have an integer value of 0, and high values (all bits on) will have an integer value of -1.

Mike

I think Craig is sort of on the right track with this... I vaguely recall running into something similar a long time back (version 8.7 I think). At the time it seemed like a timing bug. My issue was resolved when I unchecked the "Log Warnings for activities..." in one of the job sequences....