Docstoc

install

Document Sample
install Powered By Docstoc
					                              Release 1302
  Vet Status Codes/Interface File Changes/
                    New Campus Address/
              Default values for Employee
Organization Home Phone Disclosure Code

       INSTALLATION INSTRUCTIONS




                                        September 1, 2000
                              Revised (September 26, 2000)




                           Information Systems & Computing
                                       Office of the President
                                      University of California
                                              Final
                                   Revised September 26, 2000




Introduction


This document provides installation instructions for release 1302. Please review these instructions
carefully before proceeding with the installation.




                                                                                                      1
                                             Final
                                  Revised September 26, 2000




Installation Sequence


1. Alter EDB and HDB using the RC/MIGRATOR.


   RC/Migrator strategies R1302U in the ANALYSIS PDS can be used to perform the DB2 changes,
   or the environments may be updated using the DDL members which were also provided. In any
   event, the provided DDL members should be installed into production so that they will be
   available when needed in the future. You should also be aware that the strategies do not
   provide for local changes to referenced objects.

   If you do not wish to use the RC/Migrator strategies, skip this step and continue with step 2.

   a) Modify ANALYSIS member R1302U by replacing “*AUTHID*” with the appropriate
      campus value, and replacing databases “PPPEDB”, and “PPPHDB” with the name of the
      actual databases to be updated.

   b) Use RC/Migrator to execute the strategies.

   c) Skip steps 2 through 9 and continue with step 10.

2. Install the following new DDL’s to ALTER the tables PPPBAS and PPPPER.

   a) TBBAS05A
   b) TBPER14A

3. Install the following new DDL’s after replacing *AUTHID* with campus Authid.

   a)   IXEAD00C
   b)   TBEAD00C
   c)   TSEAD00C
   d)   PPPVEAD1
   e)   PPPVEAD2
   f)   PPPVZEAD



                                                                                                    2
                                            Final
                                 Revised September 26, 2000

4. Modify the following DDL’s. Replace *AUTHID* with campus Authid and make any local campus
   modifications.

   a)   TBBAS00C
   b)   TBBAS05A
   c)   PPPVBAS1
   d)   PPPVZBAS
   e)   TBPER00C
   f)   TBPER14A
   g)   PPPVPER1
   h)   PPPVPER2
   i)   PPPVZPER

5. Alter the PPPPER table by executing the Alter statement TBPER14A.

6. Alter the PPPBAS table by executing the Alter statement TBBAS05A.

7. Create the EAD Table:

   a) Create the PPPEAD Table Space by executing DDL member TSEAD00C.

   b) Create the PPPEAD Table by executing DDL member TBEAD00C.

   c) Create the index to Table PPPEAD by executing DDL member IXEAD00C.

8. Drop the following views.

   a)   PPPVPER1_PER
   b)   PPPVPER2_PER
   c)   PPPVZPER_PER
   d)   PPPVBAS1_BAS
   e)   PPPVZBAS_BAS
   f)   PPPV690A_PER – Obsolete
   g)   PPPV690B_CMP – Obsolete
   h)   PPPV690C_PAY - Obsolete

9. Create views using the following DDL’s:


                                                                                          3
                                            Final
                                 Revised September 26, 2000


      DDL Members                   View            View Created?

    PPPVBAS1                PPPVBAS1_BAS
    PPPVEAD1                PPPVEAD1_EAD
    PPPVEAD2                PPPVEAD2_EAD
    PPPVPER1                PPPVPER1_PER
    PPPVPER2                PPPVPER2_PER
    PPPVZBAS                PPPVZBAS_BAS
    PPPVZEAD                PPPVZEAD_EAD
    PPPVZPER                PPPVZPER_PER

10. Modify and install the following COPYMEMBERS:


     Copylib Members        Installed?

    CPFDXECP
    CPFDXSTA
    CPWSEPTR
    CPWSRBAS
    CPWSRPER
    CPWSXECP
    CPWSXICE
    CPWSXSTA
    CPWSXTBI

   Modify and install the following local campus specific Copylib members. Do not overlay local
   values with Base values.


     Copylib Members        Installed?

                                                                                                  4
                                 Final
                      Revised September 26, 2000


Copylib Members   Installed?

CPWSXIDC




                                                   5
                                             Final
                                  Revised September 26, 2000


11. Install the following new COPYMEMBERS:


     Copylib Members         Installed?

    CPLNKEAD
    CPWSREAD

12. Modify and install the following INCLUDE members:


      Include Members        Installed?

    PPPVPER1
    PPPVPER2
    PPPVZPER
    PPPVZBAS
    PPPVBAS1

13. Install the following new INCLUDE members:



      Include Members        Installed?

    PPPVEAD1
    PPPVEAD2
    PPPVZEAD

14. CICS Map Generation:

   a) Install the source code member listed in the following table:

   b) Use SDF II option 6 to generate the BMS macro and the COBOL data structure.

   c) Assemble the BMS macros to produce the physical map description used by CICS/BMS.
                                                                                          6
                                           Final
                                Revised September 26, 2000



       Map Name           DGIPNL           Installed?        Generated   Assembled?
                          Member

    PPEPD10             PPEPD10
    PPEADD0             PPEADD0
    PPIADD0             PPIADD0
    PPIBA10             PPIBA10
    PPIBA20             PPIBA20
    PPHPER0             PPHPER0
    PPIGEN0             PPIGEN0
    PPIPER0             PPIPER0

15. Bind Members:

   a) Install the following new Bind members.


       Bind Members         Installed?

    PPEADUTL
    PPEADUTW
    PPOT1302
    PPWIADD

   b) Modify and install the following Bind members:


       Bind Members         Installed?

    PPP040
    PPP050
    PPP080

                                                                                      7
                                              Final
                                   Revised September 26, 2000


       Bind Members            Installed?

    PPP120
    PPP130
    PPP170
    PPP250
    PPP700
    PPP750

16. COBOL Program Installation

   At UCOP, all COBOL programs pass through the DB2 pre-compiler, whether or not the program
   contains embedded SQL, to resolve INCLUDE references. Your site may have different
   requirements.

   Note: "DUAL" programs must be compiled twice and linked into batch and online libraries
   ("LOADLIB" and "OLOADLIB" respectively). "CICS" programs must be CICS pre-compiled and
   compiled once and linked into OLOADLIB. "BATCH" programs must be compiled once and
   linked into the batch LOADLIB only.

   a) Install, compile and link the new programs listed in the following table.


      PROGRAM               DB2 Pre-                Compile             Package   Done?
                            Compile                                      Bind?

    PPEADCHG             No                 Batch                     No
    PPEADFET             No                 Dual                      No
    PPEADUPD             Yes                Dual                      No
    PPEADUTL             Yes                Dual                      Yes
    PPEADUTW             Yes                Dual                      Yes
    PPEC125              Yes                Dual                      No
    PPOT1302             Yes                Batch                     No

                                                                                          8
                                          Final
                               Revised September 26, 2000


   PROGRAM                DB2 Pre-              Compile               Package         Done?
                          Compile                                      Bind?

 PPWEADD              No                CICS                       No
 PPWIADD              Yes               CICS                       Yes
Table 1

b) Modify, install, compile and link the modified programs listed in the following table.


 PROGRAM             DB2 Pre-         Compile                    Package          Done?
                     Compile                                     Bind?

 PPAPEUFE            Yes              CICS                       Yes
 PPAPEULF            Yes              CICS                       No
 PPAPEUPU            Yes              CICS                       Yes
 PPAPEUSR            Yes              CICS                       Yes
 PPAPHRKS            Yes              CICS                       Yes
 PPBASFET            Yes              Batch                      No
 PPBASHST            No               Batch                      No
 PPBASUPD            Yes              Batch                      No
 PPDXPERS            Yes              Dual                       Yes
 PPDXRHDR            Yes              Dual                       Yes
 PPDXSTN2            Yes              Dual                       Yes
 PPDXSTND            Yes              Dual                       Yes
 PPHRMGR             Yes              CICS                       Yes
 PPIDXHST            Yes              Batch                      No
 PPKEYCHD            Yes              Dual                       Yes
 PPP050              Yes              Batch                      No
 PPP130              Yes              Batch                      No
                                                                                              9
                                         Final
                              Revised September 26, 2000


 PROGRAM            DB2 Pre-         Compile                   Package       Done?
                    Compile                                    Bind?

 PPP690             Yes              Batch                     No
 PPP711             Yes              Batch                     No
 PPP770             Yes              Batch                     No
 PPP861             Yes              Batch                     No
 PPPERCHG           No               Batch                     No
 PPPERFET           No               Dual                      No
 PPPERUPD           No               Dual                      No
 PPPERUTL           Yes              Dual                      Yes
 PPPERUTW           Yes              Dual                      Yes
 PPSTARPT           No               Batch                     No
 PPWEPD1            No               CICS                      No
 PPWHPER            Yes              CICS                      Yes
 PPWIBA1            Yes              CICS                      Yes
 PPWIBA2            Yes              CICS                      Yes
 PPWIGEN            Yes              CICS                      Yes
 PPWIPER            Yes              CICS                      Yes

c) Compile and link the unmodified programs listed in the following table.



 PROGRAM            DB2 Pre-         Compile                   Package       Done?
                    Compile                                    Bind?

 PPACTFET           No               Dual                      No
 PPAPDXKS           Yes              CICS                      Yes
 PPAPEHKS           Yes              CICS                      Yes
                                                                                     10
                             Final
                  Revised September 26, 2000


PROGRAM    DB2 Pre-     Compile                Package   Done?
           Compile                             Bind?

PPAPEIKS   Yes          CICS                   Yes
PPAPTFKS   Yes          CICS                   Yes
PPAWRFET   No           Dual                   No
PPAXDFET   No           Dual                   No
PPBELFET   No           Dual                   No
PPBENFET   No           Dual                   No
PPBKCFET   No           Dual                   No
PPBNDFET   No           Dual                   No
PPBRSFET   No           Dual                   No
PPCMPFET   No           Dual                   No
PPDBLFET   No           Dual                   No
PPDEPFET   No           Dual                   No
PPEARFET   No           Dual                   No
PPEBTFET   No           Dual                   No
PPEDBDET   Yes          Dual                   Yes
PPEDBFET   No           Dual                   No
PPEDBFMB   No           Dual                   No
PPEDBFRB   No           Dual                   No
PPEDBNIL   No           Dual                   No
PPEDBUPD   No           Dual                   No
PPFADFET   No           Dual                   No
PPFBAFET   No           Dual                   No
PPFCBFET   No           Dual                   No

                                                                 11
                                              Final
                                   Revised September 26, 2000


     PROGRAM             DB2 Pre-        Compile                Package   Done?
                         Compile                                Bind?

     PPFNAFET            No              Dual                   No
     PPFNWFET            No              Dual                   No
     PPHONFET            No              Dual                   No
     PPLCNFET            No              Dual                   No
     PPLOFFET            No              Dual                   No
     PPLSCFET            No              Dual                   No
     PPLVAFET            No              Dual                   No
     PPNDCFET            No              Dual                   No
     PPP120              Yes             Batch                  No
     PPP127              Yes             Batch                  No
     PPPAYFET            No              Dual                   No
     PPPCCFET            No              Dual                   No
     PPPCMFET            No              Dual                   No
     PPPPAFET            No              Dual                   No
     PPSPPFET            No              Dual                   No

17. Bind the following Plans.


        Bind Plans              Done?

     PPOT1302
     PPP040
     PPP050
     PPP080
     PPP120

                                                                                  12
                                       Final
                            Revised September 26, 2000


      Bind Plans        Done?

   PPP127
   PPP130
   PPP170
   PPP250
   PPP360
   PPP390
   PPP400
   PPP410
   PPP420
   PPP690
   PPP700
   PPP711
   PPP742
   PPP743
   PPP744
   PPP750
   PPP770
   PPP861

18. CICS HELP

   a) Import revised CICS HELP anchors data from PAYDIST.R1302.HELPANCH (refer to
      sample JCL in PAYDIST.R1302.JCL(LOADANCH)).

   b) Import revised and new CICS HELP screen data from PAYDIST.R1302.HELPSCRN (refer
      to sample JCL in PAYDIST.R1302.JCL(LOADSCRN))


                                                                                    13
                                              Final
                                   Revised September 26, 2000

   c) Import the new CICS Data Dictionary Definitions from data in PAYDIST.R1302.HELPDDSE
      (Refer to sample JCL in PAYDIST.R1302.JCL(LOADDDSE)).

19. Processing Program Table entries are required for the following new programs and maps. The
    CICS Resource Definition Operations (RDO) are provided in the release CARDLIB member
    RDOPROD. Replace *GROUPID* with the campus group.

   a)   PPEADFET
   b)   PPEADUPD
   c)   PPEADUTL
   d)   PPEADUTW
   e)   PPEC125
   f)   PPWEADD
   g)   PPWIADD
   h)   PPEADD0 - map
   i)   PPIADD0- map

20. Security Considerations

   The RACF steps that need to be performed to implement security are:

   a) Define protected profiles as appropriate in the installation-defined resource class for the function
      code EADD.

   b) Permit READ access to EADD and IADD to the individual users or groups in Central and/or
      Departmental Office who are authorized to use the function.

21. Process Control Database (PCD) Updates

   Three PCD Tables must be updated.

   a) The new functions EADD and IADD must be added to the UC0CFN and UC0MNU Tables.
      The released UDB2PCD (UC0CFN, UC0MNU) can be loaded with RESUME to add these
      new functions. The JCL in PAYDIST.R1302.JCL(LOADPCD) sent with this release contains
      a step which converts the ‘REPLACE’ to RESUME in the $$LOAD member.

   b) The new data element 0345 must be added to the PPPHDE Table. The released UDB2PCD
      (PPPHDE) can be loaded with RESUME to add the new data element. The JCL in

                                                                                                      14
                                                Final
                                     Revised September 26, 2000

        PAYDIST.R1302.JCL(LOADPCD) sent with this release contains a step which converts the
        ‘REPLACE’ to RESUME in the $$LOAD member.

        An alternative method is to use the on-line function to manually enter the new data element into
        the PPPHDE table:

        The UHDE online function is not a UCROUTER based function, and must be accessed via the
        local transaction name. At UCOP, the transaction name is PPSA (Payroll/Personnel
        System Administration); your campus may have a different transaction name defined.
        See the Attachment at the end of this document for entering the proper data values on the
        UHDE screen.

22. Execute and verify the rest of the test plan, per supplied instructions.

23. Perform any desired additional campus testing.

24. Install Control Table (CTL) updates into production.

    Execute PPP010 to update the VSAM production Data Element Table, System Messages Table,
    Routine Definition Table, and Processing Group Table with the transactions supplied in the following
    release CARDLIB files.

    •   DETPROD

        Use the transactions in CARDLIB(DETPROD), or key from the provided facsimile UPAY553
        form. These transactions may be used both for testing and production, with the approval of your
        campus Payroll Manager.

    •   MSGPROD

        Use the transactions in CARDLIB(MSGPROD), or key from the provided facsimile UPAY554
        form. These transactions may be used both for testing and production, with the approval of your
        campus Payroll Manager.

    •   RTDPROD

        Use the transactions in CARDLIB(RTDPROD), or key from the provided facsimile UPAY804
        form. These transactions may be used both for testing and production, with the approval of your
        campus Payroll Manager.
                                                                                                    15
                                            Final
                                 Revised September 26, 2000


   •   PGTPROD

       Use the transactions in CARDLIB(PGTPROD), or key from the provided facsimile UPAY803
       form. These transactions may be used both for testing and production, with the approval of your
       campus Payroll Manager.

   Update the DB2 production tables by executing program PPP851 for Tables 06, 08, 36 and 37.

25. Execute PPP006 to update the following tables:

   a) Data Elements to Screen Table

       The transactions supplied for updating this table is in the following release CARDLIB file
       DESPROD, or key from the provided facsimile UPAY815 forms. These transactions may be
       used both for testing and production, with the approval of your campus Payroll Manager.

   b) Code Translation Table

       The transactions supplied for updating this table is in the following release CARDLIB file
       CTTPROD, or key from the provided facsimile UPAY814 forms. These transactions may be
       used both for testing and production, with the approval of your campus Payroll Manager.

26. JCL Changes

   a) Create JCL for the one-time program PPOT1302. Sample JCL is included in
      PAYDIST.R1302.JCL.

   b) Modify the JCL to run PPP130 as follows:

       The coded length associated with DD name of NRASTA has been changed to 260. Sample is
       included in PAYDIST.R1302.JCL.

   c) Modify the JCL to run PPP690 as follows:

       The coded length associated with DD name of ADDRFILE has been changed to 250. Sample
       is included in PAYDIST.R1302.JCL.

   d) Modify the JCL to run PPP711 as follows:
                                                                                                  16
                                             Final
                                  Revised September 26, 2000


       The coded length associated with DD name of EMPLO has been changed to 760. Sample is
       included in PAYDIST.R1302.JCL.

    e) Modify any JCL to load and unload the EDB by adding the new EDB table PPPEAD.

       Samples UNLDEDB and LOADEDB are included in PAYDIST.R1302.JCL.

27. Place new and modified objects in production.

28. Run the one-time program PPOT1302.

    This one-time program populates the new PPPEAD Table with data from the existing PPPCMP
    Table. The new Campus Work Address – Line 1 (EDB 0331) and Campus Work Address – Line
    2 (EDB 0332) will be populated with the Campus Room (EDB 0308) and Campus Building (EDB
    0309) respectively. Note that the new Campus Work Address data elements are not captured for
    history processing.

29. Follow local procedures to remove the following obsolete DDLs and Includes.

•   DDL

       PPPV690A
       PPPV690B
       PPPV690C

•   Include

       PPPV690A
       PPPV690B
       PPPV690C

30. Follow local procedures to remove the following obsolete History Data Elements:

    History Data Element Table - Follow local procedures to remove references on PPPHDE to the
    following obsolete History campus data elements:




                                                                                            17
                                      Final
                           Revised September 26, 2000

The UHDE online function can be used to obsolete the following data elements in the
PPPHDE Table. A value of ‘Y’ should be entered for the Obsolete Indicator field, and a
valid date should be entered for the Obsolete Date field.

 Data Element Number                       Removed?
 0307
 0308
 0309




                                                                                     18
                                        Final
                             Revised September 26, 2000


PPUHDE0-U0704              ERH Control Tables                       05/25/99 08:44:10
                               Data Element                          Userid: PAYJXQ


 A/D/C            : A
 Table Name       : PPPBAS
 Column Name      : WCE_VET_STATUS
                                               Accumulation Indicator : Y
 Data Type        : A                          Periodic Maint Indicator:
 Data Usage       : F
                                               Obsolete Indicator        :
 Field Length     : 1                          Obsolete Date             : 01/01/0001
 Decimal Places   :
                                               Purge Indicator         :
 PPS DET Number   : 0345                       Special Periodic Routine:



 ===>
 PF:              2-Cancel
 PF:                           9-MainMenu                              12-Exit

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:10/27/2011
language:English
pages:20