MVSFORUMS.com

djf · Beginner Joined: 06 Feb 2007 Posts: 68 Topics: 27

Hello.

We are trying (in vain) to get DB2 Distributed working. This has to do with having a client running on a PC and having DDF running on the mainframe.

I CANNOT find anything that tells us what to do end-to-end.

Right now, I am trying to get DB2 working in conjunction with WLM.
There is a SYSPROC called DSNWZP which is supposed to run in a WLM environment.

I created the needed procs in SYS1.PROCLIB for the WLMENV1,2,3,5 environments.

I go into DB2 interactive and say Start proc(DSNWZP)
It says ok.
But nothing happens. No started tasks fire up, no error return codes from DB2, nothing.

This is, imho, a very, very poorly documented item. I can't find any documentation that even tells me what to expect. I admit to being a DB2 rookie and a WLM novice, but this shouldn't be that hard to understand.

jsharon1248 · Posted: Tue Nov 11, 2008 12:33 pm Post subject:

This is not my area of expertise, but I do recall numerous conversations with DBA's about DB2 Connect. I think you need to purchase DB2 Connect and install it to provide connectivity between platforms when you're running z/OS. I'm not sure what DSNWZP is, so I don't know what you're trying to accomplish with that.

djf · Beginner Joined: 06 Feb 2007 Posts: 68 Topics: 27

Thanks.

Amazingly, I got it working. Here is what we needed:

DB2 Connect gets installed and configured on the client side.

But the z/OS image needs a few things that barebones DB2 doesn't have.

You need to have "DB2 Administration Server" installed and turned on. This is JDB811D fmid.
This task runs as a Unix Daemon under USS, and the setup, which is probably cake to a eunuch, was a bit daunting for me.

You need to have RRS running, this is Remote Recovery Services. Runs as a started task. It is it's own subsystem. You will need to define z/OS logger files for it.

Finally you need to create the started tasks and needed items for the DB2 WLM applications. I was frustrated because the WLM stuff wasn't working, but it won't even get to that point unless you have RRS installed and running.

Have fun! I sure did...

jsharon1248 · Posted: Wed Nov 12, 2008 4:44 pm Post subject:

dif

Thanks for providing the resolution.