PH41968: PRODUCTIVITY-AID SAMPLE PROGRAMS CURRENT PACKAGESET ENHANCEMENT

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Productivity-aid sample programs CURRENT PACKAGESET enhancement
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 12 for z/OS users of DSNTEP2, DSNTEP4,                   *
  * DSNTIAUL and DSNTIAD.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * This APAR provides a new parameter for                       *
  * DSNTEP2, DSNTEP4, DSNTIAUL and DSNTIAD                       *
  * that can be used to assign a value to                        *
  * the CURRENT PACKAGESET special                               *
  * register.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  DSNTEP2 and DSNTEP4 are sample dynamic SQL programs that can be
  used to issue dynamic SQL statements. DSNTIAUL is a sample
  application that is used primarily to unload data from Db2
  tables to an externalized format. DSNTIAD is a sample program
  that can issue any dynamic SQL statements, except for SELECT
  statements.
  This APAR provides a new parameter PKGSET(collection) to the
  above 4 programs:
  PKGSET(collection) specifies that the program implicitly
  executes a SET CURRENT PACKAGESET statement to assign a value
  to the CURRENT PACKAGESET special register before processing
  the dynamic SQL statements in SYSIN. 'collection' specifies
  the value to be assigned, it can be up to 40 characters. Db2
  will use the value as collection ID of the package that will be
  used to execute SQL statements. For example:
    RUN PROGRAM(DSNTIAUL) PLAN(DSNTIAUL) -
       PARMS('SQL,PKGSET(COL1)')
    RUN PROGRAM(DSNTEP2) PLAN(DSNTEPC1) -
       PARMS('/ALIGN(MID) PKGSET(COL2)')
  Alternatively, for DSNTEP2 and DSNTEP4 only, you can use the
  --#SET PKGSET collection
  control statement in your SQL statement stream. For example:
  --#SET PKGSET M503TEP2
  CREATE TABLESPACE SEGTS1...
  CREATE TABLE TB1 IN SEGTS1...
  --#SET PKGSET M508TEP2
  ALTER TABLESPACE SEGTS1 MOVE TABLE TB1 TO TABLESPACE PBGTS1..
  

Problem conclusion

Temporary fix

Comments

• New parameter PKGSET(collection) has been added to DSNTEP2,
  DSNTEP4, DSNTIAUL and DSNTIAD.
  NEW control option PKGSET has been added to the control
  statements of DSNTEP2 and DSNTEP4.
  

APAR Information

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

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

  UI79341

Modules/Macros

• DSN@EP4L DSN@EP2L DSNTIAUL DSNTEP2L DSNTEP4L DSNTEP4  DSNTIAD
  DSNTEP2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI79341

     UP22/02/23 P F202

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.