Page 1 of 1

DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 2:55 pm
by Dietmar
Hi,

I have access to a z/OS running Db2 v12 and recently managed to get my first COBOL/Db2 program running. But I still get a warning at my bind step in the compile job
 DSN SYSTEM(DBCG)    
  BIND PLAN(DF01)-    
      MEMBER(FIRSTDB2)-
      QUALIFIER(DF)-  
      ENCODING(EBCDIC)-
      ACTION(REPLACE)  
  END                  


resulting in

DSNT226I  -DBCG DSNTBAP1 BIND WARNING FOR PLAN DF01
           THE MEMBER OPTION IS DEPRECATED AND    
           SUPPORT WILL BE REMOVED IN THE FUTURE  


This is no tragedy right now, but can anyone tell me how to do that bind in a way to make Db2 happy with RC0?

Unfortunately there is no administrator I could ask at my shop - I am the only one digging into such things at the moment.

thanks
Dietmar

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 4:38 pm
by prino
Dietmar wrote:Unfortunately there is no administrator I could ask at my shop - I am the only one digging into such things at the moment.

DB2 is an expensive product that isn't part of standard z/OS. Now why would a shop pay IBM for it if it's not used?

Ever thought about trying to open a manual? IBM makes all of its manuals on-line, even if you're running an ADCD version of z/OS...

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 5:06 pm
by prino
prino wrote:
Dietmar wrote:Unfortunately there is no administrator I could ask at my shop - I am the only one digging into such things at the moment.

DB2 is an expensive product that isn't part of standard z/OS. Now why would a shop pay IBM for it if it's not used?

Ever thought about trying to open a manual? IBM makes all of its manuals on-line, even if you're running an ADCD version of z/OS...

Because that's what you are doing, given that the earlier JCL showed that you're using a JCL which dates back to 2007!

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 5:56 pm
by Dietmar
FYI, I am trying to learn more about z/OS and things connected to it. I have been taking online courses which I paid for myself for the last months to get started on COBOL. The next step will probably be more JCL, which is noch so much of a problem for the question I actually asked. I have researched all sorts of stuff recently, unfortunately I did not compile a list of all handbooks and tutorials I read. I have no Idea from where the Job I am using dates from. The JCLs I compared were from an online course and various other tutorials I found. Those JCLs all look very similiar and probably have one common origin. The problem is that IBMs redbooks are often hard to read for people that are trying to get started without being able to pay for courses that cost thousands of Dollars for just one week. Very often manuals are written for people who already know how things work and are not so helpful for newbies, because they require all sorts of previous knowledge to be understood. This is quite demotivating at times. If researching on such stuff one ususally finds two kinds of answers. They are either "ask your admin" (as if inheriting a text file would be better than understanding how to write one in finite time), the other one is "RTFM you unworthy fool". Both is very very frustrating.

So - yes I have spent weeks if not months finding stuff in manuals. If it would have found something that helped I would not have asked here.

Besides - if you scroll to the very top of this page the subtitle reads "A Help & Support Forum for Mainframe Beginners". That's why I thought such kind of questions would be allowed here... :-( :-( :-(

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 6:00 pm
by prino
There's also a link "IBM Manuals" at the top of each page, and Db2 12 for z/OS Product Documentation is the third link provided by Google for a search on "db2 manuals".

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 6:09 pm
by Robert Sample
The message is telling you to remove the
     MEMBER(FIRSTDB2)-
because MEMBER is no longer supported. Removing that line would be the first step in getting to a zero condition code. There may be other things you need to do (since it's been 30 years since I last used DB2, I don't know for sure), but you didn't ask about them -- you asked about that one specific message.

Re: DSNT226I Bind Warning with member Option in DB2

PostPosted: Thu Jul 18, 2019 7:07 pm
by NicC