EPC - 869

Date : 31 July 2011

EPC869 Highlights

EPC869 delivers enhancements and corrections to LANSA Integrator. The following are some of the most notable items:

IPv6 Support.
The new aXesTerminalService is designed to permit a JSM client application to connect to and interact with an aXes Terminal Server to navigate, populate and interrogate IBM i 5250 screens.
Improved handling of floating point values, particularly for Excel and SQL operations.
PDFSpoolFileService has been enhanced to improve host encoding selection and support for more fonts.
The XML bind services can now attach and detach binary or text files from specified XML nodes.
The ExcelReadService has performance and feature improvements:
- Template cell and column formatting;
- Cache of the last read and write sheet;
- New SET command has been added;
- New REMOVE commands has been added to remove rows or columns.
A range of useability and functional enhancements to LI Studio.
A range of incremental enhancements to supplied LI services.
A variety of updates to latest versions of various Java libraries used in LI Studio and LI Service implementations.

Refer to Detailed changes for more information about the changes delivered in this EPC.

Get this EPC	Download EPC869 via the LANSA Support Portal
Product	LANSA Integrator
Version	12
Pre-Requisite Details	Java: 1.4 Windows: supported versions of Windows as documented on our web-site. In particular refer to the web-site for the latest information concerning support for Microsoft Windows Vista. IBM i: i5/OS or IBM i at a release level supported by IBM - at time of writing, the earliest supported release was V5R4. The following PTFs must be applied before this EPC is applied: i5/OS Release / Required PTF V5R4M0 = MF40520 V5R4M5 = MF42655 Additional required PTFs for restoring Java programs created on V6R1 or later to an earlier release i5/OS Release / Required PTF V5R4M0 = SI27765 LANSA Integrator: Associated LANSA system (if installed): IBM i - V12 SP1. Windows - V12 SP1.
Related Products	LANSA for iSeries or Visual LANSA
Full Distribution In	N/A
Special Notes	If you are running custom services (services not provided with the LANSA Integrator product shipment), then you should re-test such services after applying the EPC. If your custom services do not work after applying the EPC, then you may need to re-compile the .class object for the services.
Document Updates	An updated version of the LANSA Integrator Guide is included. Once the EPC is applied, you need to ensure that the version of the guide shipped with the EPC is placed in the default LANSA documentation location as installed with Visual LANSA. This default location is ...\x_win95\x_lansa\execute\eng directory. You should manually copy the guide to this folder, replacing the existing version of the LANSA Integrator guide.

Description

EPC869 contains updates to IBM i and Windows components of LANSA Integrator.

Instructions to install the EPC

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

Download EPC869.EXE file from Web site or email.
Unzip (double click) EPC869.EXE. These files will be extracted:
- this document, EPC869.htm
- EPC869 - IBM i Save file
- EPC869w.exe - Windows install executable
- RFI_EPC869.exe - RFI install executable
- UA_EPC869.exe - Independent User Agent install executable
- LANSA093.chm - updated version of the LANSA Integrator Guide

Instructions provided for:

Yes	LANSA Integrator on IBM i
Yes	LANSA Integrator on Windows
No	LANSA Integrator on Linux
Yes	Additional Install notes

Detailed changes

EPC869 includes these changes [Click here to Show table...]

CCS id.	Description
0141474	Default XML encoding should be UTF-8 not LATIN-1 Change XML declaration readers to default to UTF-8 when the encoding attribute is missing from the XML declaration or the declaration does not exist.
0141488	Enhance PDFDocumentService to import all PDF files from a specified directory The element has a new directory attribute. All PDF files located in the specified directory will be imported into the PDF document.
0141720	Wizard dialog field input values are too restrictve for format code The XMLBindingWizard and SOAPWizard input dialog fields for assigning Java format code to a field is too restrictive. The allowable input values has been left open for a greater range of input characters.
0141791	Soap Wizard cannot double click to open field attributes of elements Allow mouse double click event to open edit dialog.
0141857	Enhance PDFDocumentService to fill form fields This feature allows PDF documents that contain Acrobat fields to be set using program field values.
0141858	Enhance SOAP/XML/JSON Wizards to generate RPGX sample code The SOAP/XML/JSON Wizards will now generate RPGX skeleton sample code.
0141896	Update 3rd party jar files XMLSchema to version 1.4.6 JGoodies L&F to version 2.3.1
0142287 0142323	Add support for message selectors to JMS services For JMS services it is now possible to receive particular messages using a message selector. Also additional property datatypes Short, Long, Double and Float are available when sending messages. Also ARCHIVE keywords have been added to the SEND and RECEIVE commands. An ARCHIVE command has been added to the JMSXMLBindService.
0142289	Add support for IPv6 to JSMProxy, RPGX and JSM BIFs Add support for IPv6 to JSMProxy, RPGX and JSM BIFs
0142365	Allow Studio to view PNG image files
0142366	Enhance JSM console server to use HTTP 1.1 protocol Enhance JSM console server to use HTTP 1.1 protocol
0142415 0142361	Add text file and binary file support to XMLBinding services It is how possible to send text and binary files with an XML document.
0142448	Handle BigDecimal scientific notation JDK 1.5 issues JDK 1.5 BigDecimal toString method sometimes returns values in scientific notation. Additional code has been added so only values in standard decimal notation are used.
0142453 0142491	XML Bind List and Fragment should not generate an empty element XML Bind List and Fragment should not generate an empty element if output empty node is unchecked
0142493	Add support for IPv6 literal address This enhancement allow IPv6 literal addresses to be used in the format [n:n:n:n]:port
0142506	Add IPv6 support to FTP services Add IPv6 support for the EPSV and EPRT subcommands.
0142589	Replace ZipService OCCURANCE keyword with OCCURRENCE Make OCCURANCE keyword obsolete and recommend the use of OCCURRENCE
0142590	Allow XMLBindingWizard fragments to be marked as multiple occurrence Currently the XMLBindingWizard detects if a fragment is multiple occurrence when multiple elemets occur in the sample XML. A new checkbox on the entiry edit dialog allows the fragment to be marked as mulitple occurrence. This helps in the type of generated sample code.
0142604	Get Studio to send SOAP server jar files to jar pending directory. Add logic to send SOAP Agent jar files to binding directory and by default SOAP Server jar files go to pending jar directory.
0142605	When viewing an X509 certificate include certificate policy information. When viewing an X509 certificate include certificate policy information.
0142611	Add new SET command to ExcelReadService The SET command allows a specified work sheet settings to be changed. The SET command includes the follwowing keywords. FREEZE to set the horizontal and vertical freeze. ORIENTATION to set the landscape or portrait orientation. GRIDS to show or hide grids. MARGIN to set top,bottom,left,right,header and footer margins. HEADER to set the header content. FOOTER to set the footer content.
0142613	Enhance Axis SOAP serializer to handle decimal numbers Because of JDK1.5 changes to the BigDecimal toString method. The Apache Axis serializer code needs to be enhanced to stop the creation of decimal values in scientific notation.
0142665	Enhance UserAgent to use HTTP/1.1 and basic, digest and ntlm authentication
0142667	Add UAGZIP support for HTTP inbound response services Allow HTTP inbound services to send back GZIP compressed content using the UAGZIP keyword on the SEND command.
0142698	Improve HTTPService BIND query string mechanism A new keyword QUERY-FORMAT controls how the query string keyword(value) pairs are parsed. A value of 1 is the original method and also the default value. A value of 2 allows the keyword value to be double quoted to protect ( and ) brackets with the keyword value.
0142712	Improve JSM HTTP server peformance and functionality
0142732	Change JSM Console and Studio authentication method The manager.properties console.authentication.{username} and studio.authentication.{username} authentication digest algorithm was changed. The new digest include the user, password and the realm value of JSM. If console and studio authentication is being used, then new digest values will need to be generated. Refer to LI documentation 2.4 Java Service Manager Console to use Studio to add authorized users.
0142734	Enhance TRANSFORM command of XMLParserService to accept XSL file path The TRANSFORM command of the XMLParserService provides a new XSLPATH() keyword which may be used as an alternative to the existing XSL() keyword to specify the XSL file path without needing to modify XMLParserService.properties.
0142741	Add support for temporary reply queues to JMS services This allows messages to be sent and a temporary reply queue specified to recieve the reply messages.
0142754	Allow ExcelReadService to use Template formats When cell values are being added to worksheet, the cell type and cell format from the template will be used if a DEFINE *CELLFORMAT does not exist.
0142758 0142764	Connection close The HTTP protocol response should include the Connection: close property
0142782	Improve ExcelReadService performance using a cache of the current Sheet The ExcelReadService will cache the last read and last write Sheet for quick reuse by the next read or write operation
0142841	Enhance SFTPService to use SECSH and SSH public key authentication Enhance SFTPService to use SECSH and SSH public key authentication. Enhance Studio to view SECSH and SSH public key files.
0142893	Enhance ExcelReadService to create cell types using field datatype Previous ExcelReadService WRITE command create general Label cells for all values. Now this service will create Number cells for numeric field values if the target cell is empty or blank and no current cell format exists.
0142921	Change SQL services to use prepared statements to obtain META data EDIDataSetSQLService, SQLService and SVFileService now use a prepared SQL statment to obtain column META data. Also support has been added for the new IBM datatype DECFLOAT.
0142981	Add SET PRINTAREA and REMOVE command to ExcelReadService Allow Excel printarea to be set. Add a REMOVE command to allow rows and columns to be removed.
0142982	Add commitment control to iSeries MQ BIFs Add new MQ_BEGIN, MQ_CMIT and MQ_BACK BIFs and enhance MQ_GET BIF to allow commitment control on get message operations.
0143022	Update Jsch to version 1.4.4 Update 3rd party Jsch to version 1.4.4
0143032 0142989	Add manager property to control PDF document file access method The manager property pdf.nomemorymap=true has been added to the manager.properties file. This is used to control whether the PDF services use RandomFileAccess or NativeIO memory mapped file access to read PDF documents. The iText static Document.plainRandomAccess field is set to true. If IFS journalling is being done on files, then FileChanel.map method will fail.
0143034 0142549	Add a simplify mime message feature to SMTPMailService Logic has been added that if a Mime message is mulitpart/mixed and only contains 1 body part that body part is text/plain then simplify the message to a top-level text/plain message. The simplify process can be enable via a property or SET keyword. SMTPMailService.properties simplify=yes SMTPMailService SET command keyword SET SIMPLIFY(YES)
0143044	Use Java Reflection API's to load 3rd party JMS classes To improve the flexability of handling 3rd party JMS classes, the loading of the Connection Factory classes is done using the Java Relection API's
0143070	Add support for TibcoMQ to JMS services A JMS vendor class for TibcoMQ has been added to the JMS services
0143071	Create a new FileQueueService The FileQueueService allows files to be sent and received using the JSMMQPUT,JSMDQPUT, JSMMQGET and the JSMDQGET programs
0143072	The PDFSpoolFileService was not including blank lines in the output page This problem has been fixed and blank lines are now included in the generated PDF page.
0143074	Improve the POP3MailService read text capability Replace the use of the StringTokenizer class to parse text lines, so blank lines are not missed.
0143095 0143093 0143396	XMLParserService cannot SET node value if text node does not exist Create a child text node if one does not exist.
0143112	Studio change duplicate/copy file to use - Copy(n) suffix name convention Previously when Studio duplicated a file the Copy of prefix was added to the new file name. Now a - Copy(n) suffix is used.
0143113	Add TibcoMQ support to UserAgent User Agent can now send and receive JMS messages from a Tibco MQ server
0143135	Enhance file service's LIST command to allow SORT and REVERSE options Enhance BASE64FileService, EDICatalogService, SVFileService, XMLBindFileService and XMLFileService LIST commands to allow SORT by name or modified time. Also a REVERSE keyword allows the list to be reversed.
0143163	Add Wrap Array option to SOAP Agent WSDL parsing options This option will add the -w option to the WSDL2Java command
0143191 0143133	SOAP Agent cannot set YearMonth and MonthData data types Fix SOAP Agent to be able set these datatypes using YYYYMM, YYYY-MM, MMDD and MM-DD lansa field values.
0143259	Allow PDF document table border color and cell border color to be specified New PDF XML table element attributes 'title-border-color', 'border-color' and 'cell-border-color' can be used to control the color of the table border and cell borders.
0143293	Improve PDFSpoolFileService font support The PDFSpooledFile service can use Host print transform or Copy to stream file to read and convert spooled files. Add more fonts that can be used by the PDFSpoolFileService. Also the PDFSpoolFileService will autodetect the necessary encoding. The default FONT has changed from COURIER to AUTO. The font COURIER1 has been removed. The ENCODING keyword has been changes to take the values HTP, CSF and IBM codepages in the format of Cp37, Cp297, etc... These new fonts require IBM and/or Microsoft fonts to be installed. Possible Fonts: AUTO COURIER COURIER2 COURIER3 COURIER4 MINCHO GOTHIC SIMNUN DFKAISB MINGLIU BATANG COURIERNEW MTSANSWT MTSANSWTIN MTSANSWTJ MTSANSWTJEA MTSANSWTK MTSANSWTKEA MTSANSWTME MTSANSWTSC MTSANSWTSCEA MTSANSWTTC MTSANSWTTCEA MTSANSWTTCTWEA THRNDWT THRNDWTJ THRNDWTK THRNDWTME THRNDWTSC *THRNDWTTC
0143337	IBM Java Toolbox version information is now printed to STDOUT.TXT When the JSM Manager starts the installed IBM Java Toolbox version information is printed to STDOUT.
0143431	Allow JSM server to only accept client connections from specified IP addresses A new JSM manager property 'tcp.client.address' can be used to control which JSM BIF clients can connect to the JSM Server. The property value is a comma separated list of IP addresses or the single value of *all.
0143630	Increase allowable length of JSM instance name from 30 bytes for IASP usage All dependant programs have been modified. Also the STRJSM program now submits the RUNJSM command instead of the RUNJSM program.
0143653	Increase remote address size from 15 to 45 for IPv6 support Increase the remote address fields in JSMADMEXT, JSMPXYEXT and JSMDRTEXT exit programs to match changes in JSMADMIN, JSMPROXY and JSMDIRECT programs
0143654	SOAP Agent and Server wizard solutions cannot be built on a Japanese locale PC When a SOAP Agent or SOAP Server solution is "built" in LI Studio on a Japanese PC, the compile step fails. The output window shown contains a Japanese message which says the equivalent of "Compile failed". This has been corrected by forcing the javac compiler to output verbose messages in English, allowing LANSA Integrator Studio to correctly interpret the outcome.
0143690	Enhance HTTPInboundJSONService to handle Cross-Orgin (CORS) requests Add the RESPONSE(EMPTY\|CORS) keyword to the SEND command to control the type of HTTP response. This will allow a HTTPInboundJSONService to respond to a prelight CORS OPTIONS request.
0143691 0144530 *	Enhance JSMADMIN, JSMPROXY and JSMDIRECT to handle IPv6 literal addresses Enhance JSMADMIN, JSMPROXY and JSMDIRECT to handle IPv6 literal addresses
0143701	Enhance PKIEditor to generate SSH public and private keys A menu option has been added to the PKIEditor tool to allow the generation of SSH public and private keys.
0143709	Enhance HTTPInboundXMLBindService to handle Cross-Orgin (CORS) requests Add the RESPONSE(EMPTY\|CORS) keyword to the SEND command to control the type of HTTP response. This will allow a HTTPInboundXMLBindService to respond to a prelight CORS OPTIONS request.
0143759	Add a new JSM service command SERVICE_SET to change service behaviour The SERVICE_SET command can be used to enable the clearing of trace files when the service ends. SERVICE_SET TRACE(*CLEAR)
0143847	Provide new aXesTerminalService The aXesTerminalService is designed to permit a JSM client application to connect to and interact with an aXes Terminal Server to navigate, populate and interrogate IBM i 5250 screens. Using the aXesTerminalService, an application can interact directly with existing IBM i 5250 applications running on the same or a different server system. The application can issue commands to perform such operations as: - connect (and logon) and disconnect the 5250 session - interrogate the values of current screen identifiers and field values - set the values of 5250 screen entry fields - send function keys such as ENTER and F3 - perform multiple operations with a single command by using aXes terminal operation scripts NB: The aXes Terminal Server is a separately licensed product. Additional software licence fees apply.
0143880	Enhance XMLWriterService to create text node using working list data The WRITE OBJECT(*TEXT) command can now use a single field working list to supply text data.
0143884	Enhance Studio and MapCompile to search Program Files (x86) directory for javac Studio and Composer will now search the Program Files Program Files (x86) directory for java.exe and javac.exe programs
0143917	Upgrade JavaMail to version 1.4.4 Upgrade JavaMail to version 1.4.4
0144052 0144037	Allow explicit quoting of CSV data by using the SVQUOTE keyword The SVFileService, OutboundSVListHandler, InboundSVListHandler and HTTPInboundSVService now support the WRITE command SVQUOTE ( NONE \| TEXT \| *ALL ) keyword to force quoting of values.
0144056	Enhance JSM service LIST command with SORT keyword Add file sorting capability to servcies with directory LIST commands. LIST SORT(NONE\|NAME\|MODIFIED) REVERSE(NO\|*YES)
0144189	SOAPServerService Axis register bean serializer call needs to be synchronized It has been discovered that Apache Axis TypeMapping register code is not threadsafe. Synchronous logic was added to the SOAPServerService to reduce the conflict between multiple SOAPServerService threads from changing a global HashMap object.
0144277	Add support for unsignedByte type to SOAP AGENT service A customer had a WSDL document that required support for an unsignedByte data type.
0144278	Move JSON parser classes into jsm.jar from jsmservice.jar Now that JSON is become a primary protocol, the JSON parser classes where moved from jsmservice.jar file to jsm.jar. The HTTPInboundJSONService now uses the new JSON parser classes.
0144279 0144255	Change HTTP REST method DELETE to be a no content method The HTTP outbound services, UserAgent have been modified so the custom REST DELETE method does not sent Content-Type and Content-Length properties.
0144333	Set Studio Look&Feel theme to Desert Blue for all platforms Previously Studio's Look&Feel changed depending on the platform. It is now locked to one theme.
0144341 0144336	FTP GET command was not reading the inputstream in record size chunks The FTP GET command now reads the remote file input stream using the specified record size amount.
0144478 0144462	Allow complex number formats to be added to an Excel document Currently number format patterns are vaildated to comply with Java decimal format patterns. The new COMPLEXFORMAT keyword allows complex Excel formats to be used. DEFINE ... TYPE(*NUMBER) COMPLEXFORMAT(#.##;#.##;-)

Affected objects

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

Object Name	Folder	Platform
jsm.jar	LANSA Integrator Instance jar directory	All
jsmas2.jar	LANSA Integrator Instance jar directory	All
jsmaxis.jar	LANSA Integrator Instance jar directory - Axis 1.4 Nov 19 build	All
jsmbcmail.jar	LANSA Integrator Instance jar directory - Bouncy Castle 1.4.5	All
jsmbcpg.jar	LANSA Integrator Instance jar directory - Bouncy Castle 1.4.5	All
jsmbcprov.jar	LANSA Integrator Instance jar directory - Bouncy Castle 1.4.5	All
jsmcomdisc.jar	LANSA Integrator Instance jar directory - Axis commons-discovery 0.4	All
jsmcomlog.jar	LANSA Integrator Instance jar directory - Axis commons-logging 1.1	All
jsmedimap.jar	LANSA Integrator Instance jar directory	All
jsmide.jar	LANSA Integrator Instance jar directory	All
jsmjaf.jar	LANSA Integrator Instance jar directory - Java Activation Framework 1.1.1	All
jsmjaxrpc.jar	LANSA Integrator Instance jar directory - Axis JAXRPC 1.1	All
jsmldap.jar	LANSA Integrator Instance jar directory - Open LDAP 2008-03-01 build	All
jsmlog4j.jar	LANSA Integrator Instance jar directory - Axis Log4j 1.2.15	All
jsmmail.jar	LANSA Integrator Instance jar directory - Java Mail 1.4.3	All
jsmnative.jar	LANSA Integrator Instance jar directory	All
jsmpdf.jar	LANSA Integrator Instance jar directory - iText 2.1.7	All
jsmpdfcjk.jar	LANSA Integrator Instance jar directory - iText fonts	All
jsmrfi.jar	LANSA Integrator Instance jar directory	All
jsmsaaj.jar	LANSA Integrator Instance jar directory - Axis SAAJ 1.2	All
jsmscript.jar	LANSA Integrator Instance jar directory - Rhino 1.6.7	All
jsmserializer.jar	LANSA Integrator Instance jar and endorsed directories - Xerces 2.7.0	All
jsmservice.jar	LANSA Integrator Instance jar directory	All
jsmsoap.jar	LANSA Integrator Instance jar directory	All
jsmssh2.jar	LANSA Integrator Instance jar directory - JSch 1.42	All
jsmstax.jar	LANSA Integrator Instance jar directory - Woodstox 3.2.4	All
jsmstaxapi.jar	LANSA Integrator Instance jar directory - Woodstox 1.0.1	All
jsmutil.jar	LANSA Integrator Instance jar directory	All
jsmwsaddr.jar	LANSA Integrator Instance jar directory - Axis WS-Addressing 1.0	All
jsmwsdl4j.jar	LANSA Integrator Instance jar directory - Axis WSDL4J 1.6.2	All
jsmwssec.jar	LANSA Integrator Instance jar directory - Axis WS-Security 1.5.8	All
jsmxalan.jar	LANSA Integrator Instance jar and endorsed directories - Xalan 2.7.0	All
jsmxerces.jar	LANSA Integrator Instance jar and endorsed directories - Xerces 2.8.1	All
jsmxls.jar	LANSA Integrator Instance jar directory - jXL 2.6.8	All
jsmxmlapi.jar	LANSA Integrator Instance jar and endorsed directories - Xerces 1.3.03	All
jsmxmlsec.jar	LANSA Integrator Instance jar directory - Axis XML-Security 1.4.3	All

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

Object Name	Object Type	Library
QCLSRC	*PF	*JSMLIB
QCMDSRC	*PF	*JSMLIB
QDDSSRC	*PF	*JSMLIB
QRPGLESRC	*PF	*JSMLIB
SFMFILTER	*PF	*JSMLIB
SFMFILTER1	*LF	*JSMLIB
SFMFILTER2	*LF	*JSMLIB
SFMFOLDER	*PF	*JSMLIB
SFMFOLDER1	*LF	*JSMLIB
SFMUSER	*PF	*JSMLIB
SFMUSER1	*LF	*JSMLIB
SFMUSER2	*LF	*JSMLIB
DC@D8700	*DSPF	*JSMLIB
DC@P8700	*PGM	*JSMLIB
JSM	*DSPF	*JSMLIB
JSM	*MSGF	*JSMLIB
JSM	*MENU	*JSMLIB
JSMMSGF	*MSGF	*JSMLIB
CHGJSMAUT	*PGM	*JSMLIB
CHGJSMDFT	*PGM	*JSMLIB
CHGJSMOWN	*PGM	*JSMLIB
CLRJSM	*PGM	*JSMLIB
CRTJSMSBS	*PGM	*JSMLIB
EDTJSMMGR	*PGM	*JSMLIB
EDTJSMSRV	*PGM	*JSMLIB
JSMADMIN	*PGM	*JSMLIB
JSMAUTH	*PGM	*JSMLIB
JSMBUILD	*PGM	*JSMLIB
JSMCHECK	*PGM	*JSMLIB
JSMCHGJOB	*PGM	*JSMLIB
JSMCHGUSER	*PGM	*JSMLIB
JSMCLEAR	*PGM	*JSMLIB
JSMDIRECT	*PGM	*JSMLIB
JSMDQGET	*PGM	*JSMLIB
JSMDQPUT	*PGM	*JSMLIB
JSMGETENV	*PGM	*JSMLIB
JSMGETPORT	*PGM	*JSMLIB
JSMLINK	*PGM	*JSMLIB
JSMMQDEPTH	*PGM	*JSMLIB
JSMMQGET	*PGM	*JSMLIB
JSMMQPUT	*PGM	*JSMLIB
JSMOWNER	*PGM	*JSMLIB
JSMPENDING	*PGM	*JSMLIB
JSMPROXY	*PGM	*JSMLIB
JSMTRCENV	*PGM	*JSMLIB
OPTJSM	*PGM	*JSMLIB
RUNJSM	*PGM	*JSMLIB
WRKJSM	*PGM	*JSMLIB
DCXS882X	*SRVPGM	*JSMLIB
DCXS883X	*SRVPGM	*JSMLIB
JSMDTAQ	*SRVPGM	*JSMLIB
JSMMGRSRV	*SRVPGM	*JSMLIB
JSMMSGQ	*SRVPGM	*JSMLIB
JSMRPGSRV	*SRVPGM	*JSMLIB
JSMUSRSPCE	*SRVPGM	*JSMLIB
LIBLSSRV	*SRVPGM	*JSMLIB
CHGJSMAUT	*CMD	*JSMLIB
CHGJSMDFT	*CMD	*JSMLIB
CHGJSMOWN	*CMD	*JSMLIB
CLRJSM	*CMD	*JSMLIB
CRTJSMSBS	*CMD	*JSMLIB
EDTJSMMGR	*CMD	*JSMLIB
EDTJSMSRV	*CMD	*JSMLIB
OPTJSM	*CMD	*JSMLIB
RUNJSM	*CMD	*JSMLIB
STRJSM	*CMD	*JSMLIB
WRKJSM	*CMD	*JSMLIB
JSMCLTDTA	*DTAARA	*JSMLIB
JSMDRTDTA	*DTAARA	*JSMLIB
JSMMGRDTA	*DTAARA	*JSMLIB

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

Object Name	Folder
LANSA Integrator Studio	Integrator\Studio
LANSA Integrator User Agent	Integrator\UserAgent
LANSA Integrator Remote Function Invocation	Integrator\RFI
LANSA Integrator on Windows	Integrator\JSMInstance
Integrator\JSMCGI
Integrator\JSMAdmin

Instructions for installing on IBM i

The following instructions use the LOADEPC command to automate the installation.
(If the LOADEPC command is not present in your LANSA Integrator library (eg: LICJSMLIB) then click here for alternate instructions.)

Backup all the LANSA Integrator library and ALL the Integrator IFS objects (LANSA_jsmlib/jsm) before applying this EPC (this IFS is backed up by the EPC load program)
End the JSM server to be upgraded before installing EPC869.
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.
Move the unzipped file EPC869 to an IFS folder on the IBM i. ( e.g. /LANSA_jsmlib(pgmlib)/tmp/epc869' )
For this EPC use the following options:
1. Install the EPC from = *IFS
2. Apply this EPC to = LANSA_INTEGRATOR
Run the command LOADEPC with the following parameters:
jsmlib/LOADEPC and press command 4 (F4) to prompt the command (This command also can be run in batch)

EPC number . . . . . . . . . . . > 869

Install the EPC from . . . . . . > *IFS
IFS Path and object name . . . . eg: /LANSA_jsmlib(pgmlib)/tmp/epc869
Apply this EPC to . . . . . . . > LANSA_INTEGRATOR
LANSA Integrator library . . . jsmlib
LANSA program library . . . pgmlib (This is optional)

The following instructions use a partially manual procedure to complete the installation.
(The preferred installation procedure uses the LOADEPC command that should be present in your LANSA Integrator library (eg: LICJSMLIB). Click here for instructions using the LOADEPC command.)

End the JSM server to be upgraded before installing EPC869.
Make a backup of the JSM directory from the IBM i. The current JSM directory will also be saved in the backout library.
EPC869 must be extracted onto a Windows machine then uploaded onto the IBM i server.
For IBM i shared folders:

in Explorer, map to the shared folder drive
create a folder named EPC869
copy unzipped file EPC869 to folder EPC869

If your network file system is not supporting IBM i shared folders, use FTP via TCP/IP and perform the following steps:

logon to the IBM i and create folder EPC869
open a DOS session on the PC
change to the directory where the downloaded and unzipped files are located
sign on to FTP site - FTP XXXXXXXX (where XXXXXXXX is the name of IBM i system or TCP/IP address)
enter your IBM i user id and password
to send as a binary file : enter command bin
change to QDLS file system : enter command cd /QDLS
change to the folder EPC869 : enter command cd EPC869
to send the downloaded file to the IBM i : enter command put EPC869
to exit : enter command quit

Use the XFLRTOSAVF command to convert the folder to a save file format (LANSA program library must be on your library list) - press F4 for command details. Save file EPC869 will be created by this command.
Sign on as a user profile that is QSECOFR, part of the QSECOFR group, or, has *ALLOBJ and *SECADM special authorities.

NOTE: Check the IBM i system value QFRCCVNRST. If QFRCCVNRST is set to 0, you must use FRCOBJCVN(*YES) on the RSTOBJ command.

Use the IBM i RSTOBJ (restore object) command to restore all objects from library QTEMP into library QTEMP.

For a save file you will use the following command:

RSTOBJ OBJ(*ALL) SAVLIB(QTEMP) DEV(*SAVF) SAVF(EPC869) RSTLIB(QTEMP)

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.
Install the EPC using the command:

LOADEPC869 JSMLIB(<jsmlib>) PGMLIB(<LANSA_pgmlib>)

Where <jsmlib> is the name of the LANSA Integrator JSM library. This is often JSMLIB but it may be different on your system.
Where <LANSA_pgmlib> is LANSA program library name and is optional.
Press enter to continue processing.
Save and then delete the backout library (iiiJEPC99 where iii = 1st three letters of your LANSA Integrator library and JEPC99 where 99 = is unique number) created by the install. The contents of the library may be used to back out this EPC and return your system to its previous state.
To install the EPC on another LANSA system, sign off and then on again before commencing the next installation.

Additional Install Notes (IBM i)

If custom changes are required to the STRJSM program, the changes should be applied and affected source files should be recompiled. A sample is provided in file QCLSRC.
If custom changes are required to the exit programs JSMADMEXT, JSMDRTEXT, JSMLSAEXT and JSMPXYEXT , the changes should be applied and then the affected source files should be recompiled. Samples are provided in file QCLSRC.
Please view the Additional Install Notes section in this document for important post-installation/upgrade checks.

Instructions for installing on Windows (including Integrator Desktop Applications)

End the JSM server to be upgraded before installing EPC869.
Make a backup of the Integrator directory from Windows.
Note that if you have added or updated any entries in the studio project <studio-project id="20000000-000000" name="lansa"> section of any of the property files these will be removed during the upgrade. It is suggested that you place your own entries in a separate studio project section prior to upgrade.
Unzip (double click) EPC869w.exe to start the upgrade of LANSA Integrator on Windows.
NOTE: Please view the Additional Install Notes section in this document for important post-installation/upgrade checks.
If upgrading an independent User Agent install, uninstall the existing User Agent first. This can be done in one of 2 ways:
1. Remove it using Add/Remove programs from the control panel.
2. Start the install (see below) and it will automatically prompt you to remove any existing User Agent installations.
Then unzip (double click) UA_EPC869.exe to start the installation of the User Agent.
You might want to do a backup of your current independent User Agent install before you start the upgrade process.
If upgrading an independent RFI install, uninstall the existing RFI first. This can be done in one of 2 ways:
1. Remove it using Add/Remove programs from the control panel.
2. Start the install (see below) and it will automatically prompt you to remove any existing RFI installations.
Then unzip (double click) RFI_EPC869.exe to start the installation of RFI.
You might want to do a backup of your current independent RFI install before you start the upgrade process.

Additional Install Notes (IBM i and Windows)

When the JSM instance starts it will process the files in the upgrade directory. If the upgrade is successful the JSM instance will restart else the instance will end. Check the file UPGRADE-LOG.txt in the JSM instance directory for upgrade messages.

An example of the upgrade messages (not complete) :

Upgrade JSM instance : /jsm/instance - Upgrade properties file : manager.properties Properties file upgraded - Upgrade properties file : service.properties Properties file upgraded - - Upgrade properties file : XMLQueueService.properties Properties file upgraded - Upgrade completed Remove upgrade files - Delete file : /devjsm/instance/upgrade/mailcap.txt - Delete file : /devjsm/instance/upgrade/integrator-feature.txt - - Delete upgrade directory - Removal completed
All the properties files will contain an "unassigned" section. This section contains lines that did not belong to a section.
Review the unassigned section for possible configuration entries. Normally this section just contains # comments and the whole section can be deleted. Use Studio to remove all unassigned sections from property files.

#!<studio-project id="00000000-000000" name="unassigned"> # # Move these entries to a new or existing studio-project section. # Delete this unassigned section. # # #!</studio-project>
The PKI Editor no longer requires the 3rd party jar files from Phaos Technology. Bouncy Castle is now used and these jar files are shipped with Studio.
When using the Studio application, several obsolete directories and files will be renamed or deleted when a project is opened or a wizard is executed.
The SOAP Wizard, JSON Wixard, XML transformation and binding Wizards will execute remove obsolete project solution files when they are started.

The following files will be removed from the project solution directory:

    XML_TRACE.TXT
    XML_COMPILE.TXT
    JSON_TRACE.TXT
    JSON_COMPILE.TXT
    SOAP_TRACE.XT
    SOAP_COMPILE.TXT
    SOAP_WSDL.XT

The following directories will be removed from the project solution directory:

    xsl-compile
    xml-compile
    json-compile
    xsl-source      ( if empty )
    soap-compile ( if empty )

If the soap-compile directory exists and contains files, it will be renamed to compile-agent.
This the safest option to preserve the contents of the soap-compile directory.
It is standard practice to have only one SOAP project per solution directory.
If the solution directory is being used for a SOAP server project, then it is ok to delete the soap-agent directory as it is not used and will only contain old SOAP server generated code.