PK74330: NEW PROCEDURE SET_CLIENT_INFO

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• New Procedure SET_CLIENT_INFO
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 users who need a DB2 stored          *
  *                 procedure to set the client special          *
  *                 registers.                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: There is a need for a common DB2        *
  *                      procedure which will allow an           *
  *                      application to change the client        *
  *                      special registers on the DB2 server.    *
  *                      Currently, the WLM_SET_CLIENT_INFO      *
  *                      procedure is available only to DB2 for  *
  *                      Linux, UNIX, and Windows and DB2 for    *
  *                      iSeries, as an alternative to the       *
  *                      sqleseti() API.                         *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  There is a need for a common DB2 procedure which will allow
  an application to change the client special registers on the
  DB2 server. Currently, the WLM_SET_CLIENT_INFO procedure is
  available only to DB2 for Linux, UNIX, and Windows and DB2
  for iSeries, as an alternative to the sqleseti() API.
  

Problem conclusion

Temporary fix

Comments

• The SYSPROC.WLM_SET_CLIENT_INFO procedure has been added.
  This procedure allows the caller to set client information
  associated with the current connection at the DB2 for z/OS
  server, changing the following DB2 for z/OS client special
  registers:
    - CURRENT CLIENT_ACCTNG
    - CURRENT CLIENT_USERID
    - CURRENT CLIENT_WRKSTNNAME
    - CURRENT CLIENT_APPLNAME
  
  Note: The existing behavior of the CLIENT_ACCTNG register is
    unchanged. It will continue to get its value from the
    accounting token for DSN requesters, and from the accounting
    string for SQL and other requesters.
  In DB2 Version 8, SYSPROC.WLM_SET_CLIENT_INFO requires
  new-function mode.
  
  Procedure definition:
       CREATE PROCEDURE SYSPROC.WLM_SET_CLIENT_INFO
         ( IN    CLIENT_USERID      VARCHAR(255)
         , IN    CLIENT_WRKSTNNAME  VARCHAR(255)
         , IN    CLIENT_APPLNAME    VARCHAR(255)
         , IN    CLIENT_ACCTSTR     VARCHAR(255)
         )
         PARAMETER CCSID EBCDIC
         EXTERNAL NAME DSNADMSI
         LANGUAGE C
         PARAMETER STYLE SQL
         COLLID DSNADMSI
         WLM ENVIRONMENT WLMENV
         ASUTIME NO LIMIT
         STAY RESIDENT YES
         PROGRAM TYPE SUB
         SECURITY USER
         COMMIT ON RETURN NO
         DYNAMIC RESULT SET 0;
  
  The procedure resides within the SYSPROC schema.
  
  Procedure parameters:
  
  CLIENT_USERID
    An input argument of type VARCHAR(255) that specifies the
    user ID for the client. If NULL is specified, the value
    remains unchanged. If an empty string (") is specified, the
    user ID for the client is reset to the default value, which
    is blank. If the value specified exceeds 16 bytes, it is
    truncated to 16 bytes. If the value specified is less than 16
    bytes, it is padded on the right with blanks to a length of
    16 bytes.
  
  CLIENT_WRKSTNNAME
    An input argument of type VARCHAR(255) that specifies the
    workstation name for the client. If NULL is specified, the
    value remains unchanged. If an empty string (") is specified,
    the workstation name for the client is reset to the default
    value, which is blank. If the value specified exceeds 18
    bytes, it is truncated to 18 bytes. If the value specified
    is less than 18 bytes, it is padded on the right with blanks
    to a length of 18 bytes.
  
  CLIENT_APPLNAME
    An input argument of type VARCHAR(255) that specifies the
    application name for the client. If NULL is specified, the
    value remains unchanged. If an empty string (") is specified,
    the application name for the client is reset to the default
    value, which is blank. If the value specified exceeds 32
    bytes, it is truncated to 32 bytes. If the value specified
    is less than 32 bytes, it is padded on the right with blanks
    to a length of 32 bytes.
  
  CLIENT_ACCTSTR
    An input argument of type VARCHAR(255) that specifies the
    accounting string for the client. If NULL is specified, the
    value remains unchanged. If an empty string (") is specified,
    the accounting string for the client is reset to the default
    value, which is blank. If the requester is DB2 for z/OS,
    and the value specified exceeds 142 bytes, it is truncated
    to 142 bytes. Otherwise, if the value specified exceeds
    200 bytes, it is truncated to 200 bytes.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK46551 UK46552

Modules/Macros

• DSN@DMSI DSNADMSI DSNARA00 DSNDQMDA DSNLTCM1
  DSNLTDSR DSNLTRB1 DSNLXSRM DSNTIJNX DSNTIJSG DSNTINS1 DSNTINS3
  DSNXERD  DSN3ERD0 HDB8810J HDB9910J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK46551

     UP09/05/28 P F905

• R910 PSY UK46552

     UP09/05/28 P F905

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.