Oracle B31003-01, User Manual

Page 1: ...Oracle Application Server Adapter for IMS TM User s Guide 10g Release 3 10 1 3 1 0 B31003 01 January 2007 ...

Page 2: ...deral Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the Programs including documentation and technical data shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement and to the extent applicable the additional rights set forth in FAR 52 227 19 Commercial Computer Softwa...

Page 3: ...onfiguring the J2CA 1 5 IMS TM Adapter 2 2 Using the CCI API to Develop Applications 2 3 Configuring Multiple Adapters 2 4 Updating Configuration Information 2 4 3 Troubleshooting OracleAS Adapter for IMS TM Troubleshooting the Daemon 3 1 Starting the Daemon 3 1 Task Starting the Daemon 3 2 Shutting Down the Daemon 3 2 Monitoring the Daemon During Run Time 3 2 Daemon Computer Options 3 2 Workspace...

Page 4: ...Category 5 6 debug Category 5 6 miscellaneous Category 5 7 odbc Category 5 8 oledb Category 5 8 optimizer Category 5 8 queryProcessor Category 5 8 transactions Category 5 8 tuning Category 5 9 Migration Considerations 5 9 Security Considerations 5 10 Setting Design Time Security 5 10 Setting Run time Security 5 10 Transaction Support 5 11 6 Installing and Configuring OracleAS Adapter for IMS TM Pr...

Page 5: ...n time User Access to the IBM OS 390 or z OS Platform 6 18 Modeling Interactions for OracleAS Adapter for IMS TM 6 19 Setting Up an Oracle Connect Adapter 6 19 Generating Outbound Interactions 6 21 Viewing the XML Schema 6 26 Creating XML Schemas 6 27 A Advanced Tuning of the Metadata Metadata for the Back end Adapter A 1 General Tab A 1 Interaction Tab A 2 Schema General Tab A 3 Schema Record Tab...

Page 6: ...vi ...

Page 7: ...access IMS TM transactions Documentation Accessibility Our goal is to make Oracle products services and supporting documentation accessible with good usability to the disabled community To that end our documentation includes features that make information available to users of assistive technology This documentation is available in HTML format and contains markup to facilitate access by the disabl...

Page 8: ...a week For TTY support call 800 446 2398 Related Documents For more information see the following documents in the Oracle Other Product One Release 7 0 documentation set or in the Oracle Other Product Two Release 6 1 documentation set Oracle Application Server Adapter Concepts Guide Oracle Application Server Adapter Installation Guide Oracle Application Server Adapter Concepts Guide Oracle Applica...

Page 9: ...alled OTMA Open Transaction Manager Access as well as through 3270 terminals IMS TM transactions are built around an input message output message concept with a special layer MFS translating the message to the screen and back for a user interface In addition to OTMA there is also an IMS TM transaction gateway that enables TCP IP access to IMS TM transactions OracleAS Adapter for IMS TM includes th...

Page 10: ...plication The J2CA 1 5 IMS TM adapter converts the J2CA interaction invocation received from an application client to the XML format and passes the XML format to Oracle Connect on the legacy server The daemon listens for the request coming from the J2CA 1 5 IMS TM adapter client and assigns a server process to handle the request The properties of the server process such as connection pooling requi...

Page 11: ... with the EIS OracleAS adapters are deployed as a Resource Adapter RA within the OC4J container The contract between the OC4J client application and the resource adapter is defined by the common client interface CCI The contract between the OC4J container and the resource adapter is defined by the service provider interface SPI The SPI API addresses the connection management transaction management...

Page 12: ...r config property name userName value config property name password value config property name eisName value config property name serverName value config property name workspace value config property name portNumber value config property name persistentConnection value config property name keepAlive value config property name firewallProtocol value config property name connectTimeout value config ...

Page 13: ... See Also Daemon Security on page C 5 and WS Security on page C 16 for details about users allowed to access an Oracle Connect server password optional Specifies a valid password for the user persistentConnecti on optional Set to true or false When set to true connections can persist across multiple requests or connection context changes It is recommended to set this property to true keepAlive opt...

Page 14: ...teMappedRecord query queryRecord put text select from disam nation javax resource cci Record oRec interaction execute iSpec queryRecord 4 Invoke the execute method on the interaction to initiate a call to the EIS Pass any data for the interaction as input and output records 5 Once the interactions have been processed close the Interaction and Connection objects Configuring Multiple Adapters Each J...

Page 15: ...apter for IMS TM is performed using Oracle Studio It is used to monitor the daemon and server activity and control what happens to the daemon and server processes This section contains the following topics Starting the Daemon Shutting Down the Daemon Monitoring the Daemon During Run Time Daemon Logs Starting the Daemon The daemon is started when OracleAS Adapter for IMS TM is installed In case you...

Page 16: ...e Configuration Explorer and select Open Runtime Perspective You can manage the daemon by expanding the relevant node daemon workspace or server process and choosing the relevant option as described in the following sections Daemon Computer Options Right click the daemon to display the options available for it including the ability to display the daemon log The following table lists the avaiable o...

Page 17: ...loss Rename Enables to change the name of the daemon displayed in the Runtime Explorer Remove Removes the daemon from the Runtime Explorer Refresh Refreshes the display Table 3 2 Workspace Options Option Description Edit Workspace Configuration Opens the daemon editor to enable you to reconfigure the workspace See Also Appendix C Advanced Tuning of the Daemon for details about the configuration se...

Page 18: ... as shown in the following figure Display the required log by right clicking the level you want daemon workspace or server and selecting View Log Each log is displayed in a different tab You can flick between logs by clicking the required tab Table 3 3 Server Options Option Description Status Checks the status of the server The information about the server includes the server mode and the number o...

Page 19: ...ted debug The log displays who has connected and disconnected from the server process any errors that have been generated and any tracing that has been specified in the daemon configuration The Server Log Monitor The server log displays activity between clients and the server process used by that client to handle the client request You can change the level of logging by clicking Properties The fol...

Page 20: ... Request Explicit Disconnect client explicitly closes connection or client program terminates The server is immediately notified of the disconnect and either becomes available for use by another client or terminates if it is not reusable The server does not know that the client has disconnected and continues processing When processing completes the server tries to reply to the client and immediate...

Page 21: ...d C00D Daemon request requires a client login Cause The requested daemon requires a valid client login which was not supplied Action Reissue the command and specify a username and password Action Edit the user profile in Oracle Studio to specify a valid username and password for the IBM OS 390 or z OS platform C00E Daemon request requires an administrator login Cause The requested daemon service r...

Page 22: ...llowed to check for system usernames and passwords C014 Client connection limit reached try later Cause The maximum number of server processes for the workspace has been reached and none of the active servers could accept the client connection Action Increase the value of the Number of sub tasks in the WS Server section of the daemon configuration Action Try running the command later C015 Failed t...

Page 23: ...Oracle Support Services C01B Unexpected error in s Cause Internal error Action Contact Oracle Support Services C01C Cannot update configuration without _APPLICATIONS lock Cause Internal error Action Contact Oracle Support Services C01D Need to lock the application first Cause Internal error Action Contact Oracle Support Services C01F Cannot set configuration of a deleted application Cause Internal...

Page 24: ...e launches the correct version of Oracle Connect Action Increase the value of the Set maximum number of servers and or Maximum parameter for the Clients per server limit in the WS Server section of the daemon configuration C023 Call made to unregistered module d Cause Internal error Action Contact Oracle Support Services C024 Failed to create a socket Cause An error occurred within the TCP IP subs...

Page 25: ...ent Cause A server that was started by the Oracle Connect daemon to service a client did not get a client connection request within one minute The server terminates Action In most cases the client was terminated by a user request so no specific action is required Action If no client can connect to the server it may be that the server has multiple network cards and the Oracle Connect daemon is not ...

Page 26: ...l error Action Contact Oracle Support Services C038 Cannot re register RPC procedure number x Cause Internal error Action Contact Oracle Support Services C042 Remote call to s failed s Cause Remote call to API failed Action Check the daemon log file Action If necessary change the level of detail written to the log file to help resolve the problem C043 Failed to connect to host s s Cause The remote...

Page 27: ...anager perspective Action In case of a network problem check the network connection by trying to ping the host computer or run FTP or Telnet to or from it C067 Unexpected error occurred in server function s Cause One of the server functions has exited with an exception such as an Abend or Invalid Instruction Action Contact Oracle Support Services C068 Fail to login daemon Cause The daemon is not r...

Page 28: ...ilure is corrected the connection to the daemon is reestablished automatically C070 Server failed to send reply to the client Cause Server terminated unexpectedly Action Unless the client was intentionally stopped for example using Control C contact Oracle Support Services C071 Connection to server s was disconnected Cursors state was lost Cause Either a network failure server failure or a server ...

Page 29: ...n Reopen the connection and try again J0028 Internal Error Unknown XML tag s Cause Internal error Action Contact Oracle Support Services J0030 Internal Error Method s needs to be overwritten Cause Internal error Action Contact Oracle Support Services J0031 Internal Error Required attribute s not found in s verb Cause Internal error Action Contact Oracle Support Services J0032 Internal Error s ACP ...

Page 30: ...required for interaction s execution Cause Internal error Action Contact Oracle Support Services J0048 Invalid metadata type s is passed to s function Cause A request for metadata was not fulfilled Action Check the validity of the request J0050 Key of the put method must be of type string Cause In either a GET or PUT operation the key must be a string Action Change the key used in the operation to...

Page 31: ...ge the value used in the operation to a valid value J0078 In nonpersistent connection and non keep alive encryption is not supported ignored Cause Encryption is not supported for nonpersistent connections Action There is no action to take This warning can be ignored J0079 Invalid argument passed to s Argument s Value s Cause The value pass Action Change the argument used to a number ...

Page 32: ...Resolving Specific Errors 3 18 Oracle Application Server Adapter for IMS TM User s Guide ...

Page 33: ...ation extension and redeployment of existing business processes Each business activity is a self contained self describing and modular application whose interface is defined by the WSDL and the business process is modeled as a Web Service A Web Service is first published and then composed or orchestrated into business flows Publishing a service is implemented by taking a function within an existin...

Page 34: ...alled Checking Metadata Availability Using Oracle JDeveloper Perform the following steps to verify that the metadata of the Oracle Connect server is available in Oracle BPEL Process Manager 1 Open Oracle JDeveloper 2 On the Connections tab expand the Integration Server node to view the list of OC4J servers 3 Expand the node of the OC4J server on which you configured the JCA 1 5 IMS TM adapter see ...

Page 35: ... element name binput type binput xsd complexType name binput xsd attribute name p1 type xsd int xsd attribute name p2 type xsd int xsd complexType xsd schema xsd schema xmlns xsd http www w3 org 2001 XMLSchema xmlns noNamespace calc targetNamespace noNamespace calc elementFormDefault qualified attributeFormDefault unqualified xsd element name output type output xsd complexType name output xsd attr...

Page 36: ...teract with the OracleAS Adapter for IMS TM 4 4 Oracle Application Server Adapter for IMS TM User s Guide plt partnerLinkType name addPartnerLinkType plt role name addRole plt portType name tns addPortType plt role plt partnerLinkType definitions ...

Page 37: ...f server processes so that a server process is always available for a client request Use Oracle Studio to maintain daemon and daemon workspace parameters to control the allocation of server processes and their management in a pool You can also have a number of daemon workspace configurations Therefore you can create individual workspaces for use with different adapters Adding a New Daemon Workspac...

Page 38: ...rkspace click Ellipsis and select the workspace which properties you want to copy 7 Click Next The Select Scenario screen is displayed as shown in the following figure Figure 5 2 The Select Scenario screen 8 Select Application Server using connection pooling and click Next 9 Continue through the wizard and specify the required values for the workspace 10 To complete the workspace definition click ...

Page 39: ...ms Oracle and then select Studio 2 In the Configuration Explorer expand the the computer defined in Setting Up the IBM OS 390 or z OS Platform in Oracle Studio on page 6 14 3 Expand the Daemons node The daemon configurations available on this computer are listed 4 Expand the IRPCD node The daemon workspaces are listed 5 Right click the required workspace and select Edit Workspace 6 ...

Page 40: ... either dies or if reusable servers have been specified it is returned to the pool You set up a pool of server processes by specifying the following parameters in the WS Server tab Initial number of servers The number of server processes that are prestarted for this workspace when the daemon starts up These are available for use by new client processes with minimal initialization time Instead of s...

Page 41: ...tasks results in 100 tasks started 10 sub tasks for each process Configuring a Binding Environment Each binding configuration includes the following Environment settings which are used to configure the environment used by any of the adapters defined in the binding Application adapters on the current computer Perform the following steps to configure the environment settings 1 From the Start menu se...

Page 42: ...n memory The default is 65535 bytes comMaxXmlSize Specifies the maximum size of an XML document passed to another computer The default is 65535 bytes Table 5 3 debug Category Parameters Parameter Description acxTrace When set to true the input xml sent to the back end adapter and the output xml returned by the back end adapter are written to the log analyzerQueryPlan This parameter is not applicab...

Page 43: ...n the output column will be a null or empty value and the error is reported to the log 2 An error is reported and processing stops edit This parameter is not applicable for use with OracleAS Adapter for IMS TM language Identifies the application language A default codepage is selected based om the value specified for this parameter See also Appendix D Globalization Settings nlsString Specifies the...

Page 44: ...e of 5 and the Sliding Base Year policy is used Two policies are provided Fixed Base Year year2000Policy is set to a value greater than or equal to 1900 In this case the value of year2000Policy is the first 4 digit year after 1900 that can be represented by a 2 digit year For example if year2000Policy is set to 1905 the years 2000 2004 will be represented by 00 04 All other 2 digits will map to 19...

Page 45: ...ng for the serverLogFile parameter might need changing depending on the platform 5 Set up the target platform in Oracle Studio in the same way you set up the source platform as described in Setting Up the IBM OS 390 or z OS Platform in Oracle Studio on page 6 14 6 In the Configuration Explorer right click the target computer and select Import XML definitions 7 Import the XML file to the target pla...

Page 46: ...ession is encrypted Otherwise only the password exchange is encrypted using the hardcoded key Credentials Passwords and usernames exchanged over the network are encrypted using a pre defined hardcoded 128 bit RC4 session key Design Time Security within Oracle Studio to grant access to Oracle Studio itself and to grant access to computers user profiles and workspaces Run time Security used to acces...

Page 47: ...e WS Security tab in Oracle Studio For details of the WS Security tab refer to WS Security on page C 16 The ability to run commands on the daemon such as starting or stopping a daemon or ending server processes is available only to administrators who have been registered in Oracle Connect as a daemon administrator A client is registered as a valid daemon administrator in the Daemon Security tab in...

Page 48: ...Transaction Support 5 12 Oracle Application Server Adapter for IMS TM User s Guide ...

Page 49: ...cleAS Adapter for IMS TM ensure that your computer meets the following requirements IBM OS 390 or z OS Hardware and Software Requirements Windows Hardware and Software Requirements IBM OS 390 or z OS Hardware and Software Requirements This section describes the following requirements for installing Oracle Connect on an IBM OS 390 or z OS platform Hardware Requirements Software Requirements Hardwar...

Page 50: ...imum requirement is 4 MB for each connection A connection is defined as a connection to a server process or daemon The actual memory requirement depends on such things as the size of the database and the number of databases accessed CD ROM Drive An internal or external CD ROM drive Disk Space 3380 and 3390 disks 150 cylinders Table 6 2 Oracle Connect Software Requirements Software Component Requir...

Page 51: ... or Microsoft Windows 2003 Microsoft Network transport protocol software TCP IP included with Microsoft Windows Note If you have an Oracle Connect back end adapter already installed on the IBM OS 390 or z OS platform then follow the instructions described in Updating an Existing Oracle Connect Installation with IMS TM on page 6 12 The other back end adapters that run on an IBM OS 390 or z OS platf...

Page 52: ...pear in the job ISPF load library name ISP SISPLOAD Table 6 6 Required Permissions Permission Permission to define an APF authorized library Permission to write to an active proclib such as user proclib Permission to update the security manager such as RACF Optionally permission to specify an output class for Oracle Connect output Table 6 7 Installation Checklist Step Comment Outputs tso profile p...

Page 53: ...2 TRANSMIT LOAD in the binary mode from the installation CD to the mainframe You can replace the OCL1012 high level qualifier to any qualifier you want Installation Instructions Perform the following steps to install Oracle Connect 1 Run the following command at the TSO prompt RECEIVE INDSNAME nnn TRANSMIT KIT Where nnn represents the high level qualifier you want to assign for the Oracle Connect ...

Page 54: ...t is displayed only if SMS is used to manage the installation you answered Y to the first prompt Enter the storage class ENTER THE UNIT NAME FOR INSTALLATION TEMP DATASETS 3390 If a storage class is not specified then enter the unit name for temporary datasets used during the installation procedure ENTER THE VOLUME NAME FOR INSTALLATION TEMP DATASETS This prompt is displayed only if SMS is not use...

Page 55: ...ompt The volume name for temporary datasets used during the installation procedure PLEASE CONFIRM YES NO QUIT YES Confirm the entered details ENTER THE OUTPUT CLASS FOR INSTALLATION OUTPUT A Enter the output class for Oracle Connect output Assigning a device that is set on HOLD prevents the loss of log information when the Oracle Connect started tasks finish the default is A DO YOU WANT TO USE THE...

Page 56: ...TP copy the BRANDBIN file in binary mode from the Oracle Connect IMSTM Legacy Adapter directory in the installation CD to the mainframe to INSTROOT DEF BRANDBIN Define the LOADAUT library as an APF authorized library Table 6 10 IMS TM Adapter Specific Installation Prompts and Responses Screen Response ENTER THE ISPF LOAD LIBRARY NAME ISP SISPLOAD Enter the ISPF load library name only if you do not...

Page 57: ...START IRPCDINI After PARM B L ip_address 2252 START IRPCDINI Where ip_address is ip address of the computer 2552 is the default port for starting the daemon and IRPCDINI is the default daemon configuration The ATTDAEMN and ATTSRVR started tasks need permission to use an Open Edition TCP IP stack The owner must be a user with OMVS segment defined and the OMVS UID 0000000000 In the security manager ...

Page 58: ... services file refer to the TCP IP documentation Starting the Daemon Activate INSTROOT USERLIB ATTDAEMN as a started task to invoke the daemon For example in the SDSF screen enter the following s ATTDAEMN Where INSTROOT is the high level qualifier where Oracle Connect is installed To submit the daemon as a job remove comments from the first two lines of the ATTDAEMN JCL change the PARM line as des...

Page 59: ...OPRIV PROGRAM IS NOT PRIVILEGED DSI REQUIRES DATA SET INTEGRITY PASS CANNOT BYPASS PASSWORD PROTECTION SYST PROGRAM IS A SYSTEM TASK AFF NONE NO CPU AFFINITY NOPREF NO PREFERRED STORAGE FRAMES b To make the SCHEDxx changes take effect perform one of the following tasks Re IPL the system Issue the SET SCH command c Edit and submit the following JCL procedure to run DFSYSVI0 OTMAINIT PROC RGN 3000K ...

Page 60: ...here apf_library is the APF authorized library outside the LPA directory where the ATYSCVW member was moved Table 6 11 Preinstallation Information Topic Required Information Default Comment CICS CICS EXCI load library name CICS CICS SDFHEXCL To access IMS DB or VSAM data under CICS Table 6 12 Required Permissions Permission Permission to read the CICS EXCI library when accessing IMS DB or VSAM dat...

Page 61: ...PLEASE CONFIRM YES NO QUIT YES Confirm the entered details THE VSAM DRIVER IS INSTALLED AUTOMATICALLY DO YOU ALSO WANT ORACLE CONNECT FOR LEGACY ADAPTER TO WORK WITH VSAM UNDER CICS YES NO NO Answer YES to this prompt if you have Oracle Connect for VSAM already installed and you want to access VSAM data under CICS ENTER THE CICS EXCI LOAD LIBRARY NAME CICSTS13 CICS SDFHEXCI If you responded YES to...

Page 62: ...Schemas Setting Up the IBM OS 390 or z OS Platform in Oracle Studio Perform the following steps to configure the IBM OS 390 or z OS using Oracle Studio 1 From the Start menu select Programs Oracle and then select Studio 2 Right click Machines in the Configuration Explorer and select Add Machine The Add Machine screen is displayed see Figure 6 1 Note If Oracle Studio is already installed because yo...

Page 63: ...dio includes mechanisms to secure access to Oracle Connect both during modeling and during run time During modeling the following security mechanisms can be applied Setting Password Access to Oracle Studio Specifying Users with Administrative Rights During run time client access to Oracle Connect is provided by the user profile Setting Up Run time User Access to the IBM OS 390 or z OS Platform Set...

Page 64: ... select Preferences The Preferences screen is displayed as shown in the following figure Figure 6 2 The Preferences screen 3 Select the Studio node 4 Click Change master password The Change Master Password screen is displayed as shown in the following figure Figure 6 3 The Change Master Password screen 5 Leave the Enter current master password field empty and type a new master password 6 Confirm t...

Page 65: ...lorer and select Administration Authorization The Administration Authorization screen is displayed as shown in the following figure Figure 6 4 The Administration Authorization screen The screen has the following sections Administrators Administrators can view and modify all the definitions in Oracle Studio for the selected computer On initial entry to Oracle Studio every user is defined as a syste...

Page 66: ...er profile A user profile contains name and password pairs that are used to access a computer data source or application at run time when anonymous access is not allowed 1 In the Configuration Explorer expand the node of the computer for which you want to set the user name and password 2 Expand the Users node 3 Right click the NAV user profile and select Edit User The User Editor pane is displayed...

Page 67: ...r z OS platform to handle the interactions to and from an IMS TM transaction You use Oracle Studio to specify these definitions Perform the following steps 1 From the Start menu select Programs Oracle and then select Studio 2 In the Configuration Explorer expand the node of the computer defined in Setting Up the IBM OS 390 or z OS Platform in Oracle Studio on page 6 14 3 Expand the Bindings node T...

Page 68: ...pter is added to the list and the definition opens for editing 10 Select the Properties tab and change any of the properties for the adapter as required The Properties tab is shown in the following figure Figure 6 8 The Adapter Properties tab Note Other adapters that are displayed in the Type list are not supported with the version of Oracle Connect installed at the site ...

Page 69: ...ansactions to be executed through the application adapter Use the Metadata Import procedure to generate interaction metadata as follows 1 In the Configuration explorer right click the IMS TM back end adapter defined in Setting Up an Oracle Connect Adapter on page 6 19 2 Select Edit metadata to display the Metadata tab with the IMS TM back end adapter displayed under the Adapters list 3 Right click...

Page 70: ...files from another computer 8 If the files are on another computer then right click My FTP Sites and select Add Optionally double click Add FTP site The Add FTP Site screen is displayed 9 Enter the server name or IP address where the COBOL copybooks reside and enter a valid username and password to access the computer if anonymous access is used then click Anonymous connection then click OK The FT...

Page 71: ...sed in quotes and click OK 12 Select the required COBOL copybook file or files and click Finish The selected file or files are displayed in the Metadata Import wizard 13 Click Next The Apply Filters screen is displayed as shown in the following figure Note You can import the metadata from one COBOL copybook and later add to this metadata by repeating the import procedure using different COBOL copy...

Page 72: ...Integer Storage Mode Specify either NOIBMCOMP for byte storage mode or IBMCOMP is for word storage mode Ignore after column 72 Ignores columns 73 to 80 in the COBOL copybook IgnoreFirst6 Ignores the first six columns in the COBOL copybook Replace hyphens in record and field names with underscores _ Replaces all hyphens in either the record or field names in the metadata generated from the COBOL wi...

Page 73: ... a response sync send The interaction sends a request and does not expect to receive a response Input Identifies an input record The input record is the data structure for the interaction The records generated from the COBOL files specified at the beginning of the procedure are listed Select the relevant record for the interaction Note You must specify an input record for each interaction before y...

Page 74: ...is shown in the following figure Description Free text describing the interaction Interaction Specific Parameters IMS TM specific parameters c The interaction commit mode maxSegmentSize The maximum size of the segment The default value is 32768 bytes transaction The name of the transaction that is executed when the interaction is executed You must specify a transaction name for each interaction Th...

Page 75: ... TM 6 27 Figure 6 13 The Source tab Creating XML Schemas The XML schema describing the adapter interactions and the input and output records for these interactions are created automatically during the import procedure as described in Generating Outbound Interactions on page 6 21 ...

Page 76: ...Configuring Oracle Connect 6 28 Oracle Application Server Adapter for IMS TM User s Guide ...

Page 77: ...grams Oracle and then select Studio 2 Expnad the node of the required computer in the Configuration Explorer 3 Expand the Bindings node 4 Expand the NAV binding node 5 Expand the Adapters node to display the adapters 6 Right click the IMS TM adapter in and select Edit Metadata to display the Metadata tab 7 Right click the required interaction in the Metadata Explorer and select Edit The metadata e...

Page 78: ...finition Description Specifies an identifying description of the adapter Authentication mechanism Specifies the authentication method used to access the adapter The available mechanisms are kerbv5 none basic password Max request size Specifies the maximum size in bytes for an XML request or reply Larger messages are rejected with an error Max active connections Specifies the maximum number of simu...

Page 79: ...n Mode Determines the interaction mode The following interaction modes are available sync send receive The interaction sends a request and expects to receive a response sync send The interaction sends a request and does not expect to receive a response sync receive The interaction expects to receive a response async send Not applicable Input record Identifies an input record Output record Identifi...

Page 80: ...wn in the following figure Figure A 3 The Schema General tab The Schema General tab comprises fields as listed in the following table Table A 3 Schema General tab Components Field Description Schema name The name of the adapter Version The schema version Header A C header file to map between the data structure and the adapter ...

Page 81: ...structures for the interaction The Schema Record tab is shown in the following figure Figure A 4 The Schema Record tab The Schema Record tab comprises fields as listed in the following table Use the Fields List area to define single data items within a record Table A 4 Schema Record tab Components Field Description Name Specifies the name of the field ...

Page 82: ...Adapter Data Type Support for details about the mapping from COBOL data types to IMS TM back end adapter data types Length The size of the field including a null terminator when the data type supports null termination Note Use the Specifications box to specify field properties See Also Appendix B Back end Adapter Data Type Support for details about the mapping from COBOL data types to Oracle Conne...

Page 83: ......

Page 84: ...Metadata for the Back end Adapter A 8 Oracle Application Server Adapter for IMS TM User s Guide ...

Page 85: ... The mapping of data types between OracleAS Adapters for IMS TM and Oracle Application Server is performed internally by Oracle Connect Table 6 17 Data Type Mapping COBOL and Oracle Connect Back end Adapter COBOL Data Type Oracle Connect Data Type BINARY with fractional data string BINARY without fractional data int COMP with fractional data string COMP without fractional data int COMP 2 double CO...

Page 86: ...S TM User s Guide NATIVE 4 int NATIVE 8 string PACKED DECIMAL string POINTER int SIGN IS TRAILING string SIGN IS TRAILING SEPARATE CHARACTER string Table 6 17 Cont Data Type Mapping COBOL and Oracle Connect Back end Adapter COBOL Data Type Oracle Connect Data Type ...

Page 87: ...3 Right click the computer and select Open Runtime Perspective 4 Right click the required daemon in the Runtime Explorer and select Edit Daemon Configuration The Daemon Control tab is displayed 5 After making changes to the daemon right click the daemon and select Reload Configuration The Daemon Control tab is shown in the following figure Note You can also change daemon settings using the Configu...

Page 88: ... number of bytes that the daemon handles for an XML document Maximum XML in memory The maximum amount of space reserved for the XML in memory Default language The language that the daemon supports This setting is used when working with a client with a code page different from the server code page Call timeout The timeout period for short calls for all daemons The definition of a short call is a ca...

Page 89: ... this period then the client is notified that the server did not respond The value specified for this parameter serves as the default timeout for all the workspaces listed in the daemon configuration The default value for this parameter is 60 seconds Notes Entering the timeout in a workspace overrides the value set in this field for that workspace Even if the XML source does not list this paramete...

Page 90: ... daemon logins Daemon RPC function calls Logs all daemon RPC function calls Daemon internal operations Logs daemon internal operations Log trace information Logs low level RPC operations Display host and client domain name Specifies whether the client host and domain name are logged rather than the client IP address The default is false Trace options Specifies the type of tracing being performed N...

Page 91: ...ect the required computer from the Configuration Explorer 3 Right click the computer and select Open Runtime Perspective 4 Right click the daemon in the Runtime Explorer and select Edit Daemon Configuration 5 Click the Daemon Security tab 6 After making changes to the daemon right click the daemon and select Reload Configuration System trace Generates system specific tracing of various operations ...

Page 92: ...e daemon settings using the Configuration Explorer by selecting a computer and scrolling the list to the required daemon Right click the daemon and select Edit Daemon Changes made to the daemon configuration are not implemented They are only implemented after the configuration is reloaded using the Reload Configuration option in the Runtime Manager Table 6 20 Daemon Security tab Components Field D...

Page 93: ...an be administrators 1 If a user is not specified the account from which the daemon was started is considered the administrator Note that the daemon does not require the user to log in to the account on the system but to log in to the daemon using the account name and password Machine access Manages access to the computer Allow anonymous login Whether workspaces allow anonymous logins without user...

Page 94: ...quired daemon Right click the daemon and select Edit Daemon Changes made to the daemon configuration are not implemented They are only implemented after the configuration is reloaded using the Reload Configuration option in the Runtime Manager Table 6 21 WS Info tab Components Field Description Workspace name The name used to identify the workspace Note The default configuration includes the defau...

Page 95: ...name This field is not applicable for use with OracleAS Adapters for IMS TM Timeout parameters The time the client waits for the workspace server to start If the workspace server does not start within this period then the client is notified that the server did not respond Specifying the timeout here overrides the default setting specified in the Control section See Also Daemon Control on page C 1 ...

Page 96: ...ck the daemon and select End Unused Servers Any servers in the connection pool are closed and new servers start with the new configuration The WS Server tab is shown in the following figure Figure 6 18 The WS Server tab The WS Server tab comprises fields as listed in the following table ...

Page 97: ...able for use with OracleAS Adapter for IMS TM reusable An extension of single client mode Once the client processing finishes the server process does not die and can be used by another client reducing startup times and application startup overhead This mode does not have the high overhead of single client mode because the servers are already initialized However this server mode can use a lot of se...

Page 98: ...he daemon uses the value specified in the Initial number of servers field The default for this field is 0 Keep when daemon ends When a daemon is shutdown all the servers started by that daemon are also killed even if they are active Set this field to true if you want the servers for the workspace to remain active even after the daemon has been shut down If this field is set to true it is the respo...

Page 99: ...subtasks results in 100 tasks started 10 subtasks for each process Limit number of active servers The maximum number of active server processes either available or in use Once reached no new server processes will be created for the particular workspace and client connections would be rejected if there is no available server to accept them Once the number of active servers drops below the maximum f...

Page 100: ...e Figure 6 19 The WS Logging tab The WS Logging tab comprises fields as listed in the following table Note You can also change daemon settings using the Configuration Explorer by selecting a computer and scrolling the list to the required daemon Right click the daemon and select Edit Daemon Changes made to the daemon configuration are not implemented They are only implemented after the configurati...

Page 101: ...oting the server RPC trace Enables debugging messages on the server Sockets Generates a message in the server log file for each socket operation This is useful for troubleshooting client server communication providing a detailed trace of every client server communication Extended RPC trace Generates a verbose message in the server log file for each low level RPC function called This is useful for ...

Page 102: ... and select Reload Configuration Server Specifies the server connection events to log The following server events are available Connect The event log displays the server connection events Disconnect The event log displays the server disconnect events Client Specifies the type of tracing performed The following client events are available Connect The event log displays the client connection events ...

Page 103: ...ivileges Identifies the users accounts with administrator privileges The following options are available All users Indicates that anyone can access the workspace and change the settings Selected users only The names of users accounts and groups that can be administrators Note If a user is not specified here the user specified in the Workspace users area will have administrator rights for this work...

Page 104: ...e range of ports available for this workspace when starting server processes Use this option when you want to control the port number so that Oracle Connect can be accessed through a firewall Use specific workspace account Defines the operating system account used for the workspace If not specified the account name that was provided by the client is used Allow anonymous client login to server acco...

Page 105: ...ow to define the language support Defining the Language and Codepage The language and codepage parameters are accessed from the computer where Oracle Studio is installed Perform the following steps to define the required language and codepage 1 From the Start menu select Programs Oracle and then select Studio 2 Select and expand the required computer node from the Configuration Explorer 3 Expand t...

Page 106: ......

Page 107: ...ean KOR KSC5601 MS949 Win IBM933 MS949 EUC KR both ASCII based Latin International LAT ISO 8859 15 IBM1148 IBM037 IBM1140 ISO 8859 1 ASCII based Portuguese POR ISO 8859 15 IBM1140 IBM500 IBM1148 ISO 8859 1 ASCII based Russian RUS ISO 8859 5 IBM1154 Spanish SPA ISO 8859 15 IBM1145 IBM037 IBM500 IBM1140 IBM1148 ISO 8859 1 ASCII based Turkish TUR ISO 8859 9 IBM1155 IBM857 Table 6 25 Cont NLS Language...

Page 108: ...Defining the Language and Codepage D 4 Oracle Application Server Adapter for IMS TM User s Guide ...

Page 109: ... 5 7 debug parameters acxTrace 5 6 analyzerqueryPlan 5 6 environment 5 6 generalTrace 5 6 logFile 5 6 oledbTrace 5 6 optimizerTrace 5 6 queryWarnings 5 7 traceDir 5 7 disk space requirements IBM S 390 6 2 PC 6 2 E edit parameter 5 7 environment parameters acxTrace 5 6 analyzerQueryPlan 5 6 codepage 5 7 comCacheBufferSize parameter 5 6 comMaxSocketSize 5 6 comMaxXmlSize 5 6 cvtSeverityLevel 5 7 deb...

Page 110: ...requirements PC 6 3 UNIX 6 2 optimizer environment parameters 5 8 traceDir parameter 5 7 writing plan to file 5 6 optimizerTrace parameter 5 6 Oracle Application Server requirements 6 2 P postinstallation IBM S 390 6 8 preinstallation IBM S 390 6 4 processor requirements PC 6 2 UNIX 6 2 Q query optimizer logging strategy 5 6 traceDir parameter 5 7 writing plan to file 5 6 queryProcessor environmen...

Page 111: ...ceDir parameter 5 7 transactions environment parameters 5 8 tuning environment parameters 5 9 W Windows installing 6 14 Workspace server mode C 11 X XML documents maximum size 5 6 Y Y2K See year2000Policy parameter year2000Policy parameter 5 8 ...

Page 112: ...Index 4 ...