DB2z stage

Bill_G · Post by **Bill_G** » Mon Mar 08, 2010 4:36 pm

Has anyone configured this stage to work with IBM's BatchPipes for z/OS?

I want to read in mulitple streams of data from BatchPipes and was curious if this stage is a viable option.

TIA

Bill_G · Post by **Bill_G** » Tue Mar 09, 2010 9:13 am

Looking at the stage, it appears that the BatchPipe option is only available when using the DB2Z stage as a target.

Would anyone know how to read data from IBM's BatchPipe program?

DSguru2B · Post by **DSguru2B** » Tue Mar 09, 2010 12:19 pm

I was, recently, in talks with IBM hoping to have the z load stage for server. Alas, its only for enterprise edition. But in my conversations with them, I discovered that in order to use the batch pipes option, you need to install and configure batch pipes on the mainframe.

Bill_G · Post by **Bill_G** » Tue Mar 09, 2010 12:22 pm

Is it also your understanding that DB2Z can only be used with BatchPipes while using DB2Z as a target stage? Not as a source?

Have you been successful in configuring another stage to use BatchPipes as a source?

DSguru2B · Post by **DSguru2B** » Tue Mar 09, 2010 12:24 pm

I was not able to get the plugin as I mentioned in my previous post. Its only for enterprise edition. My current shop only has server edition.
What does the manual say about it? The best advise to you would be to get in touch with IBM. They will be able to tell you for sure.

Bill_G · Post by **Bill_G** » Tue Mar 09, 2010 1:52 pm

I was hoping the docmentation was lacking and that there was a workaround that would allow the use of this stage to source a batch pipes feed. However IBM confirmed that is not the case. You can only use this stage to source directly from DB2 z/OS tables. Batch Pipes is supported if using this stage (DB2Z) as a target.

I have asked IBM if there is another method to source Batch Pipes (FTP maybe?). I'll post back with any work around I find in case it benefits someone else.

Thanks for your time.

Bill

sun rays · Post by **sun rays** » Mon Mar 15, 2010 8:28 am

This stage is a mess if used with batchpipes option for loading data. It's way too compicated and many things go wrong while loading. Some of these issues don't even have any fixes as of now. As an example, if you have any RI constraints or FK violation during the build index phase of your load, then it simply aborts saying unable to open DCB sysmap.... This is just one such issue. Again this is when you use this tage as a target.