DSNT226I Bind Warning with member Option in DB2



IBM's flagship relational database management system

DSNT226I Bind Warning with member Option in DB2

Postby Dietmar » Thu Jul 18, 2019 2:55 pm

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
Dietmar
 
Posts: 7
Joined: Tue Apr 30, 2019 1:42 pm
Has thanked: 3 times
Been thanked: 0 time

Re: DSNT226I Bind Warning with member Option in DB2

 

Re: DSNT226I Bind Warning with member Option in DB2

Postby prino » Thu Jul 18, 2019 4:38 pm

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...
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 591
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 26 times

Re: DSNT226I Bind Warning with member Option in DB2

Postby prino » Thu Jul 18, 2019 5:06 pm

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!
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 591
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 26 times

Re: DSNT226I Bind Warning with member Option in DB2

Postby Dietmar » Thu Jul 18, 2019 5:56 pm

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... :-( :-( :-(
Dietmar
 
Posts: 7
Joined: Tue Apr 30, 2019 1:42 pm
Has thanked: 3 times
Been thanked: 0 time

Re: DSNT226I Bind Warning with member Option in DB2

Postby prino » Thu Jul 18, 2019 6:00 pm

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".
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 591
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 26 times

Re: DSNT226I Bind Warning with member Option in DB2

Postby Robert Sample » Thu Jul 18, 2019 6:09 pm

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.
Robert Sample
Global moderator
 
Posts: 3624
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 267 times

Re: DSNT226I Bind Warning with member Option in DB2

Postby NicC » Thu Jul 18, 2019 7:07 pm

The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2941
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 134 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post