MVSFORUMS.com

[priya]

Hi,
I have just started learning COBOL and DB2. I have a few basic doubts about user validation and authenticaion in mainframes. When we log on to a system we give a user id and password and logon to the system and then when we need to access DB2 tables I use the INSYNC utility. Now will the same user id and password that we give to log on to the system be taken for DB2 table priveleges validation?Is there any system tables that we can access to find out the priveleges?suppose if more than a single DB2 database resides in a system we do need access to each database seperatey rt?Also Where exactly in a COBOL-DB2 program do we mention that this is the database that we have to connect to so that the tables in the program can be queried and what about user-id and password for the database? I have switched from working in open systems to mainframes and I am generally trying to map whatever is there in open systems to mainframes.I know all these are very basic stuff but then I wanna get a clear picture. Can any of u guys help me understand this better?

Priya

[kolusu]

Priya,

Welcome to the world of mainframes. The userid and password you use to log on to the system may or may not let you access the DB2 Tables.

Most shops use the same user id for authenticaion for DB2 systems in the DEVELOPMENT side.But in production it is totally a different scenario.

The privileges of an user are stored in catalog table SYSIBM.SYSTABAUTH table which records privileges that users hold on tables and views.

check this link for a detailed explanation of SYSIBM.SYSTABAUTH table

There is another catalog table SYSIBM.SYSUSERAUTH table which records the system privileges that are held by users.

check this link for a detailed explanation of

SYSIBM.SYSUSERAUTH table

If there are more than 1 db2 subsystem , you need to access the them seperately unless both the subsystems are inter-connected

check this link for a detailed explanation of

1.Designing a DB2 database application

Developing your application

Testing an application program

I would recoomend you read this book for a better understanding of DB2 on mainframes.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH12/CCONTENTS?DT=20020826132826

Hope this helps...

cheers

kolusu