MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Package Bind - 805 issue

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Tue Dec 09, 2008 4:01 am    Post subject: Package Bind - 805 issue Reply with quote

Hi,

I am working on a db2 and pl1 application.In my team we all use a common lib for object code,loadlib and dbrmlib.We have a common DB2 qualifier and owner where everyone in the team has access to it.The problem is many times the team members gets -805 error for many modules.When they compile,link edit and bind, their problem is solved , but it is throwing -805 for other users.Here is the bind jcl used.Any solution for this problem is appreciated...


Code:

//TRNGBND  JOB CLASS=1,REGION=0M,                                     
//             MSGLEVEL=1,                                             
//             MSGCLASS=1,                                             
//             NOTIFY=&SYSUID,                                         
//             SCHENV=DB2@DSNG
//*********************************************************************
//         JCLLIB ORDER=TRG.DEV.PROCLIB                         
//*********************************************************************
//*                       BIND DB2 PACKAGE                             
//*********************************************************************
//BINDPKG  EXEC PGM=IKJEFT01                                           
//DBRMLIB  DD  DSN=R10.DEV.DBRMLIB,DISP=SHR                         
//SYSTSIN  DD  *                                                       
  DSN SYSTEM(DSNG)                                                     
                                                                       
  BIND PACKAGE(TRG9) CURRENTDATA(NO) -                             
  MEMBER(MT001A00) ACTION(REPLACE) -                                   
  VALIDATE(BIND) RELEASE(COMMIT) ISOLATION(CS) -                       
  OWNER(TRG9) QUALIFIER (TR2) EXPLAIN(NO)                       
           
                                       
//DATAIN  DD  *                                                       
,PACKAGE       ,TRG9 ,TRG9.MT001A00           ,RETENPD365,TRG9
//SYSTSPRT DD  SYSOUT=*
//SYSPRINT DD  SYSOUT=*
//AUDIT    DD  SYSOUT=*
//SYSRECD  DD  SYSOUT=*
/***************************
//*                         
//*  BIND DB2 PLAN           
//*                         
//IKJEFT0  EXEC PGM=IKJEFT1B,DYNAMNBR=20       
//SYSTSIN DD *               
  DSN SYSTEM(DSNG)           
                             
  BIND PLAN (VJDSNG) -     
  ACTION(REPLACE) -         
  RETAIN -                   
  VALIDATE (BIND) -         
  ISOLATION (CS) -           
  ACQUIRE (USE) -           
  RELEASE (COMMIT)   -       
  OWNER(TRG9) -           
  CURRENTDATA(NO)    -       
  QUALIFIER(TR2) -       
  PKLIST( -                 
  *.TRG9.* , -           
  *.PROD.*       -         
 ) -                         
 EXPLAIN (NO)               
/*               


thanks,
vj
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Wed Dec 10, 2008 3:38 am    Post subject: Reply with quote

In which order do you do your program preparation process:
- precompile, compile, link, bind or
- precompile, compile, bind, link ?

Only the second version gives you a valid combination of load modules and DB2 packages, since sometimes a bind fails, but the already changed load module is used, than with the old version of the package.

regards
Christian
Back to top
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Wed Dec 10, 2008 3:50 am    Post subject: Reply with quote

Czerfas,

Thanks for the reply.We use to do the first option(precompile, compile, link, bind).So this is causing the problem?Let me try the second option as you have mentioned and let you know the results....


cheers,
vj
Back to top
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Thu Dec 11, 2008 4:28 am    Post subject: Reply with quote

Hi,

Still the -805 problem exists even though trying the second sequence....Any other suggestions?
Back to top
View user's profile Send private message
vjkumk
Beginner


Joined: 28 Sep 2005
Posts: 98
Topics: 33

PostPosted: Sat Dec 13, 2008 10:20 am    Post subject: Reply with quote

hi,
finally the problem has been figured out.One of our guy at onsite was using a different package list ,that was causing the problem.

problematic statement:
PKLIST( -
*.TRG9.* , -
*.PROD.* -
) -

cheers,
vjkumk
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group