Authorization groups and related issues for DB2 (on ADCD)
Posted: Fri Aug 30, 2019 3:44 pm
Hello again.
I am not fully grasping the configurations needed in order to make DB2 work over ADCD (Z/OS 1.10).
Which are the default groups that should be present in the MF and which member/s connected to them?
In the DB2 docs it refers to a group named DBADM I guess, also I have a DB2 group, only SYSADM is member but somehow when submitting jobs DSNTEJ0 and DSNTEJ1, which esentially wipe up clean and re-create the Sample Database/s for DB2 9, it does not complete due to authorization issues both for SYSADM, IBMUSER. If I remember correctly logging with SYSOPR is not solving this problem either.
I wish somehow could lead me on a "kind of mini-tutorial" on the checklist and group/permissions needed. We're talking the Sample databases, this is not evidently a production system of any kind -I'm just learning MF and DB2 by myself-, so I can't make sense of the fact that I can't even (re)create the Sample datasets for this instance.
Kind regards and thanks in advance for any hint/help.
I am not fully grasping the configurations needed in order to make DB2 work over ADCD (Z/OS 1.10).
Which are the default groups that should be present in the MF and which member/s connected to them?
In the DB2 docs it refers to a group named DBADM I guess, also I have a DB2 group, only SYSADM is member but somehow when submitting jobs DSNTEJ0 and DSNTEJ1, which esentially wipe up clean and re-create the Sample Database/s for DB2 9, it does not complete due to authorization issues both for SYSADM, IBMUSER. If I remember correctly logging with SYSOPR is not solving this problem either.
I wish somehow could lead me on a "kind of mini-tutorial" on the checklist and group/permissions needed. We're talking the Sample databases, this is not evidently a production system of any kind -I'm just learning MF and DB2 by myself-, so I can't make sense of the fact that I can't even (re)create the Sample datasets for this instance.
Kind regards and thanks in advance for any hint/help.