Sample connection and sign-on routines

The sample Db2 exit routines are provided in the source code as members of prefix.SDSNSAMP.

Begin program-specific programming interface information.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:

  1. Locate the following statement in DSN3SSGN as a reference point:
    SSGN035   DS     OH         BLANK BACKSCAN LOOP REENTRY
  2. Locate the following statement, which comes after the reference point:
              B      SSGN037    ENTIRE NAME IS BLANK, LEAVE
  3. 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.End program-specific programming interface information.