Sample connection and sign-on routines
The sample Db2 exit routines are provided in the source code as members of prefix.SDSNSAMP.
To
examine the sample connection routine, list or assemble member DSN3SATH.
To examine the sample sign-on routine, list or assemble member DSN3SSGN.
You must use the High Level Assembler to assemble them.
Change required for some CICS® users: You must change the sample sign-on exit routine (DSN3SSGN) before assembling and using it, if the following conditions are true:
- You attach to Db2 with an AUTH parameter other than AUTH=GROUP.
- You have the RACF® list-of-groups option active.
- You have transactions whose initial primary authorization ID is not defined to RACF
To change the sample sign-on exit routine (DSN3SSGN), perform the following steps:
- Locate the following statement in DSN3SSGN as a reference point:
SSGN035 DS OH BLANK BACKSCAN LOOP REENTRY
- Locate the following statement, which comes after the reference
point:
B SSGN037 ENTIRE NAME IS BLANK, LEAVE
- Replace the statement with the following statement:
B SSGN090 NO GROUP NAME... BYPASS RACF CHECK
By changing the statement, you avoid an abend with SQLCODE
-922. The routine with the new statement provides no secondary IDs
unless you use AUTH=GROUP.