I am trying to get DB2 interaction from ISPF.

I'm evaluation the capabilities of RD&T at our site and really have no mainframe experience.  Lots of x86 and AS/400 experience but z/os is new.  I've been playing with RD&T for a little over a month and learned a lot about z/os and have done some customization with a lot of trial and error.  I have networking up, LU customization, even changed the Telnet login panel. 

I'm at the point where I want to get DB2 up and running and do some playing with that.  I IPL'd the system with DB startup parameter so DB2 is up and running.

In ISPF there are no references to DB2 and searching around there are examples of different DB2 options.  I copied some members from the ADCD libraries to the USER library and have been working trying to customize them.  I got to the point where I can display DB2 V10, DB2ADM, QMF V10 which were part of the DSNEPRIA member.  Selecting any of the options generates errors.  Selecting SPUFI under the DB2 V10 option generates "IKJ56500I COMMAND DSNESC01 NOT FOUND" .  I've seen various sites that talk a log of z/os jargon, but we're not at that level. 

I'm looking for some document that can lead me in the right direction.  I thought that RD&T was sort of developer friendly out of the box...

Any information is appreciated.

Thanks in advance.

Hi John,

So I assume you are using one of the z/OS ADCD's that was shipped with RD&T.  If you look in the ADCD.**.PROCLIB dataset (** will vary depending on the edition you are using), there should be some DB2 TSO LOGON PROCS that are available for use.  In my case I have DBSPROCA and DBSPROCB. 

On the TSO/E LOGON screen if you change the procedure to this PROC it should load all the necessary libraries needed to use SPUFI.  Once logged in, and on the SPUFI panels, you may need to go to the DB2 defaults and modify the values to point to the right DB2 subsystem.

Regards,

Rick

Thanks Rick.

Finally got it.  Came across a SYSADM userid in the documentation that had the proper access and actually defaulted to the DBSPROCA.  Our mainframe is outsourced, so there are no real deep system programmers here.  I have a heavy AS/400 systems background so I defaulted to trying to figure this all out.  The goal is to get some development off the mainframe down to RD&T to save $$$.  The good thing is I'm enjoying figuring out all this mainframe stuff, the bad thing is it can get very confusing.  My next task is to configure a DB2 subsystem to match one of our development subsystems from the mainframe.  I finally got to the right panels, now need to figure out the right options.

Thanks.