What steps are needed when installing PTFS RO77666 and RO78062?

Products

• PanAudit Plus
• Easytrieve Report Generator
• PAN/SQL

Issue/Introduction

What is needed besides receiving and applying PTFS RO77666 and RO78062 when installing them?

Environment

Release: EDBMSU00200-11.6-Easytrieve-Report Generator-Option for DB2-MSU
Component:

Resolution

answe For the PTFs RO77666 and RO78062, please:

1. Follow the extensive notes and instructions in the HOLD data:

    Before installing this PTF you must add the following DDDEF to your CA PanSQL 2.4 SMP/E definitions (for FMID CB2A240):

     (it is listed as GIMSMP JCL and control cards, but you may add it using any method you like to use.)

    The @...@ values below can be taken from your PanSQL install JCL jobs.

     //SMPZONE  EXEC PGM=GIMSMP,REGION=4096K,PARM='DATE=U'

     //SMPCSI   DD DISP=SHR,DSN=@CSI-DSN@

     //SMPPTS   DD DISP=SHR,DSN=@SMPPTS-HLQ@.SMPPTS

     //SMPTLIB  DD DISP=OLD,UNIT=@TLIB-UNIT@,VOL=SER=@TLIB-VOL@

     //SMPLOG   DD DUMMY

     //SMPLOGA  DD DUMMY

     //SMPOUT   DD SYSOUT=*

     //SMPPUNCH DD SYSOUT=*

     //SMPRPT   DD SYSOUT=*

     //SMPLIST  DD SYSOUT=*

     //SMPSNAP  DD SYSOUT=*

     //SYSPRINT DD SYSOUT=*

     //SYSUDUMP DD SYSOUT=*

     //SMPWRK1  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SMPWRK2  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SMPWRK3  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SMPWRK4  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SMPWRK5  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SMPWRK6  DD SPACE=(CYL,(1,1,5)),DCB=BLKSIZE=3120,UNIT=@WORK-UNIT@

     //SYSUT1   DD SPACE=(CYL,(5,1)),UNIT=@WORK-UNIT@

     //SYSUT2   DD SPACE=(CYL,(5,1)),UNIT=@WORK-UNIT@

     //SYSUT3   DD SPACE=(CYL,(5,1)),UNIT=@WORK-UNIT@

     //SYSUT4   DD SPACE=(CYL,(5,1)),UNIT=@WORK-UNIT@

     //SMPCNTL  DD *

       SET BDY(***PanSQL target zone***).

       UCLIN.

       ADD DDDEF(SCEELKED)

            DA   (***your.LE.SCEELKED.library***)

            SHR.

       ENDUCL.

       SET BDY(***PanSQL dlib zone***).

       UCLIN.

       ADD DDDEF(SCEELKED)

            DA   (***your.LE.SCEELKED.library***)

            SHR.

       ENDUCL.

     /*

    ************************************************************* ).

 ++DELETE  (DQSCGEN) SYSLIB(CB2ALLT).

 ++PROGRAM (DQSCGEN) DELETE DISTLIB(CB2ALLD).

 ++MOD (OMSCCTP2) DISTLIB(CB2ALLD).

++IMBED T193284 DATA1

 ++MOD (OMSCSQL2) DISTLIB(CB2ALLD).

 ++IMBED T193284 DATA2

 ++MOD (OMSMBDA)  DISTLIB(CB2ALLD).

 ++IMBED T193284 DATA3

 ++MOD (DQSCGEN)  DISTLIB(CB2ALLD).

 ++IMBED T193284 DATA4

 ++JCLIN CALLLIBS.

 ++IMBED T193284 DATA5

 ++ASSIGN   SOURCEID(CAP1503) TO (RO78062).

 

2. RECEIVE and APPLY these two PTFs

3. Run IJ3STGE1, CB2ACMDL, and SQLINST4 (if more than one subsystem is involved).

    These members are found in your highlevelqual.INSTALL.JCL library.