I think I found the problem... In my ADCD system the are two versions of DB2 installed, but only V12 is running. The rexx looks at the linklist to see if SDSNLOAD is there, and if not, Find it in APF. SDSNLOAD of version 11 is first in APF... I'll remove the first one and try again.
*| **Itschak Mugzach | Director | SecuriTeam Software **|** IronSphere Platform* *|* *Information Security Continuous Monitoring for Z/OS, zLinux and IBM I **| * *|* *Email**: [email protected] **|* *Mob**: +972 522 986404 **|* *Skype**: ItschakMugzach **|* *Web**: www.Securiteam.co.il **|* On Thu, Feb 4, 2021 at 6:10 PM Mike Bell <[email protected]> wrote: > -805 means the version of dsnrexx that you are running doesn't match what > is in DB2. either wrong DB2/DSNREXX or DSNREXX wan't installed. > > Mike > > On Thu, Feb 4, 2021 at 8:47 AM Binyamin Dissen <[email protected] > > > wrote: > > > On Thu, 4 Feb 2021 16:17:59 +0200 ITschak Mugzach <[email protected]> > > wrote: > > > > :>the DB2-L group seems to be inactive, so i am asking here... > > > > :>I have a rexx program that calls stored procedures and gets -805. the > > :>complete details below. I followed the instructions in the manual and > ran > > :>the SQLs recommended but haven't found the one with the correlation-id > > :>printed. I also ran the bind of DSNREXX severa times. > > > > :>SQLCODE=-805 > > :>SQLERRMC=DALLASC..DSNREXX.0E4C9F4F04F3F1F2.DSNREXX.03 > > :>SQLERRP =DSNXEPM > > :>SQLSTATE=51002 > > > > Are you sure that you are connecting to the correct DB2? > > > > -- > > Binyamin Dissen <[email protected]> > > http://www.dissensoftware.com > > > > Director, Dissen Software, Bar & Grill - Israel > > > > > > Should you use the mailblocks package and expect a response from me, > > you should preauthorize the dissensoftware.com domain. > > > > I very rarely bother responding to challenge/response systems, > > especially those from irresponsible companies. > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > > > > -- > Mike > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
