authorization check on DB2 objects

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

authorization check on DB2 objects

Post by Krishna » Sun Mar 29, 2009 11:48 pm

When is the authorization check on DB2 objects done - at BIND time or run time?

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

Post by Krishna » Sun Mar 29, 2009 11:48 pm

At run time.

Shivankoo
Member
Posts: 14
Joined: Mon Dec 13, 2010 4:15 pm

Post by Shivankoo » Wed Nov 21, 2012 8:20 am

Hi,
To add to it the DB2-VALIDATE parameter will decide that the authorization has to be checked at run time or bind time.
If VALIDATE(RUN)-Will check the authorization at run time and if
VALIDATE(BIND)-Will check authorization at bind time.
Please correct me if I am wrong.
Thanks and Regards
Shivankoo Sharma

//EMPIRE EXEC PGM=WIFE
//SYSIN DD DSN=VARSHA.ME.HOME,DISP=SHR
//SYSOUT DD DUMMY

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Wed Nov 21, 2012 9:23 pm

Please correct me if I am wrong.
Why post a "correction" if you are not sure?

Suggest you run a few experiments and post back here when you are sure. . .
Have a good one

Shivankoo
Member
Posts: 14
Joined: Mon Dec 13, 2010 4:15 pm

Post by Shivankoo » Wed Nov 21, 2012 10:24 pm

Sure this time :-)
Thanks and Regards
Shivankoo Sharma

//EMPIRE EXEC PGM=WIFE
//SYSIN DD DSN=VARSHA.ME.HOME,DISP=SHR
//SYSOUT DD DUMMY

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Wed Nov 21, 2012 11:22 pm

Thank you :)
Have a good one

academyindia4

Topic deleted by Admin

Post by academyindia4 » Sat Jan 30, 2016 11:24 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others