Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to get a pass ticket created using the DB2 Administrative Task scheduler.

user-idxokJun 22 2023

Hi ,

We are DB2 Z/OS V12 FL510 and are applying Goldengate Version 19.1.0.0.230418 . We have had to install the DB2 Administrative Task scheduler for this patch. Our DB2 Administrative task scheduler address space is DBL1ADMT .

Our DB2 Z/OS security is managed by RACF.

We have installed the stored procedures OGGIFI00.OGGINITB and OGGIFI00 OGGTASKM .

Goldengate is able to create the task in the DB2 Administrative Task scheduler :

Task                               Task                                 Task    Task                    

Cmd Name Description Last Modified Creator Userid Type SSID
OGG_MEMORY_MGR_ID_12321272_092411_ 2023-06-22-15.29 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_17367422_070941_ 2023-06-22-14.37 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_20185424_059546_ 2023-06-22-15.15 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_21823932_139151_ 2023-06-22-14.56 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_26411400_066291_ 2023-06-22-14.00 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_7602616_072006_D 2023-06-22-14.51 GGMGRT DFLTUID PROC
OGG_MEMORY_MGR_ID_9961980_376951_D 2023-06-22-15.11 GGMGRT DFLTUID PROC

However each task has failed with : DSNA691I DSNA6THD THE ADMIN SCHEDULER DBL1ADMT CANNOT GENERATE A PASSTICKET FOR TASK

We have set the authority for generating a pass ticket to the user id of DBL1ADMT , and we have tried the Goldengate user id. But to no avail.

The Owner of the Stored procedures is the Goldengate userid.

We are not seeing any RACF messages , and the SYSOUT for DBL1ADMT says : IRRSPK00: EDC5000I No error occurred. (errno2=0x00000000) .

Have any of you had this issue ? Any suggestions would be most welcome.

Regards,

        Ron
Comments
Post Details
Added on Jun 22 2023
1 comment
549 views