EPC - 863

Date : 18 October 2010

EPC863 Highlights

Get this EPCDownload EPC863 via the LANSA Support Portal
Product Visual LANSA and LANSA for iSeries
Version11 SP5
Pre-Requisite DetailsEPC845
Related ProductsNone
Full Distribution InV12
Special Notes

All Version 11 SP5 Visual LANSA EPCs include updates that must be applied to Windows and System i systems (Independent Visual LANSA development environments only require the Windows updates). Failure to upgrade both sides of a development environment will render the Host Monitor and Super Server applications inoperable. Attempting to use the Host Monitor and Super Server applications without having applied the EPC to both sides of a development environment will generate an EPC mismatch error.

Make a full backup of your LANSA environment on each platform to which this EPC will be applied.

System i Specific Special Notes The System i instructions are expedited procedures that assume a sound knowledge of i5/OS.
You should use a user profile that is QSECOFR, part of the QSECOFR group, or, has *ALLOBJ and *SECADM special authorities.
You must end the web server and run the LANSA for the Web cleanup program before applying this EPC.
You must end the Listener and Host Monitor if active.
You must end the LANSA Integrator server if it has been used with the LANSA system to be updated.
User ActionsThe following CCS items require user action:

  0132415 IBM i: Select of CLOB field fails with SQL0452 or MCH3601 on second loop
  0137874 Allow DEFINE_DB_SERVER to support modifying the RRN path
  0138555 Using CHAR fields in WITH_KEY parameters causes performance degradation
  0138966 FUNX output attribute only writes first 7 characters when updated from function
  0139237 LANSA Communications terminates in JPN for 2=Review/Change for SOCKET
  0139365 Update pointer lost on return from child function in parent
  0139399 DBCS values in Alpha Literal variables not shown correctly debugging iSeries
  0139426 Files that contain rules or code comparing against *ZERO behave incorrectly
  0140410 iSeries: ODBC column length less than returned field size on DELETE or UPDATE
  0141155 Fatal Error (0977) - Incorrect use of SQLDA: cannot set the number of columns

See below for details.

Document Updates This EPC does not contain updates to any guides.
The latest guide updates are available at http://www.lansa.com/support/docs/update.htm
Hotfixes The following Hotfixes will be replaced by this EPC:
Windows:
EPC838HF-090703
EPC838HF-090716
EPC838HF-090727 
EPC845HF-090812
EPC845HF-090812a
EPC845HF-090827
EPC845HF-090904
EPC845HF-090910
EPC845HF-090922
EPC845HF-090925
EPC845HF-091001
EPC845HF-091006
EPC845HF-091007
EPC845HF-091009
EPC845HF-091014
EPC845HF-091016
EPC845HF-091022
EPC845HF-091105
EPC845HF-100111
EPC845HF-100721
EPC848HF-091211
EPC848HF-100112
EPC848HF-100113
EPC848HF-100121
EPC848HF-100203
EPC848HF-100208
EPC848HF-100224
EPC848HF-100301
EPC848HF-100302
EPC848HF-100310
EPC848HF-100326
EPC848HF-100420
EPC848HF-100607
EPC848HF-100607a
EPC848HF-100608
EPC849HF-100406
EPC849HF-100603

IBM i:
EC838P06
EC838P07
EC838P08

EC845P01
EC845P02
EC845P03
EC845P04
EC845P05
EC845P06
EC845P07
EC845P08
EC848P01
EC848P02
EC848P03
EC848P04
EC848P05
EC848P06
EC848P07
EC848P08
EC848P09

Instructions to install the EPC

EPC863 includes software to be installed on a IBM i machine and on a Windows machine. These instructions describe the installation and use of all delivered items.

  1. Download EPC863.EXE file from the Web site or email.
  2. Unzip (double click) EPC863.EXE. These files will be extracted:

Instructions provided for:

Yes LANSA for iSeries
Yes IBM i Web Server (multi-tier)
Yes Visual LANSA

 

Detailed changes

  EPC863 includes these changes:    [Click here to Show table...]

  EPC863 supersedes EPC848 which included these changes:    [Click here to Show table...]

Affected objects

   Windows Components:    [Click here to Show table...]

 

   IBM i Components:    [Click here to Show table...]

Install Instructions

Instructions for installing on IBM i

These instructions have been abbreviated for experienced LANSA users. If you need further assistance to install the EPC, full instructions are available in the Technical Resources of the LANSA web site at www.lansa.com/support/notes/epc.

  1. Sign on with QSECOFR user profile, part of the QSECOFR group or a user profile that has *ALLOBJ and *SECADM special authorities.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_pgmlib/x_lansa) before applying this EPC
  3. You need exclusive use of the LANSA system before applying the EPC. To check for active users refer to Appendix C How to check for Active Users in the Installing LANSA on System i guide for instructions.
  4. End the Listener, Host Monitor and Web Server for the LANSA system and run the LANSA for the Web cleanup program.
  5. Move the unzipped file EPC863 to an IFS folder on the System i. ( e.g. /LANSA_pgmlib/tmp
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = FULL_LANSA_SYSTEM 
  7. Run the command LOADEPC with the following parameters:

    pgmlib/LOADEPC and press command 4 (F4) to prompt the command (can be run in batch)

    EPC number . . . . . . . . . . . > 863

    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . . e.g. /LANSA_pgmlib/tmp/epc863

    Apply this EPC to . . . . . . . FULL_LANSA_SYSTEM
    LANSA program library . . . . . pgmlib

  8. Save and then delete the backout library (iiiEPCnn where iii = 1st three characters of the LANSA pgm library and nn is sequence number) created by the install. The contents of the library may be used to backout this EPC and return your system to its previous state.
  9. Sign off and then on again before commencing the next installation, e.g.:

Instructions for users of iSeries Web Server (multi-tier)

The command LOADEPC is now available in the LANSA web server Admin library. Use the following instructions.

  1. If you haven't installed or upgraded LANSA for the Web on the Web Server, do so before proceeding with step 2.
  2. Backup all the LANSA folders, system libraries and ALL the LANSA IFS objects (LANSA_admlib/x_lansa) before applying this EPC
  3. End the Web Server and run the LANSA for the Web cleanup program. Refer to 13.5.6 Clean Up Systems in the LANSA Online documentation for cleanup instructions.
  4. Display your current library list. If QTEMP is not shown, then add it to your library list using the ADDLIBLE (add library list entry) command.
  5. Move the unzipped file EPC863 to an IFS folder on the System i. ( e.g. /LANSA_admlib/tmp/epc863)
  6. For this EPC use the following options:
    1. Install the EPC from = *IFS
    2. Apply this EPC to = LANSA_WEB_SERVER 
  7. Run the command LOADEPC with the following parameters:

    admlib/LOADEPC and press command 4 (F4) to prompt the command (can be run in batch)

    EPC number . . . . . . . . . . . > 863

    Install the EPC from . . . . . . > *IFS
    IFS Path and object name . . . . e.g. /LANSA_admlib/tmp/epc863

    Apply this EPC to . . . . . . . LANSA_WEB_SERVER
    LANSA web server admin lib . . . . . admlib

  8. Save and then delete the backout library (iiiEPCnn where iii = 1st three characters of the LANSA pgm library and nn is sequence number) created by the install. The contents of the library may be used to backout this EPC and return your system to its previous state.
  9. Sign off and then on again before commencing the next installation, e.g.:

 

Instructions for installing on Windows

  1. Recommend that a backup be done of all LANSA folders and your LANSA database before applying this EPC.
  2. Stop using the LANSA development environment and stop all currently executing LANSA applications.
  3. Double-click on AllEPCs.exe.
  4. Select the "Setup" button or "Cancel" if you do not want to proceed.
  5. If you have multiple configurations installed, Select the configuration to which the EPC is to be applied.
  6. If you are prompted to reboot your pc - please reboot.
  7. To view details of the installed EPCs:
    1. sign into LANSA
    2. view the Help menu
    3. Product Information option
    4. then select the Installation Details tab
    5. expand the Installation/ EPC Summary
    6. review the last entries

2010 LANSA