1. Payments Scripts
  2. Payments Scripts

2 Payments Scripts

The Overview of this document is to share you the PAYMENTS SCRIPTS which require manual execution in the database.

Post FCPayments database installation, below are the list of properties to be updated in the payments table:
  1. pmtm_job_param.txt script has to be run to insert entries into PMTM_JOB_PARAM table.

    Changes to be done in the script before compiling in the schema:

    • If Application Server is Weblogic,

      For PM.CTX.PROVIDER property, replace “t3://10.10.10.10:1010” with
      “t3://Weblogic_IP:Server_Port” or “t3://hostname:Server_Port

    • If Application Server is Websphere,

      For PM.CTX.FACTORY property, replace ”weblogic.jndi.WLInitialContextFactory” in the script
      with “com.ibm.websphere.naming.WsnInitialContextFactory”.

      For PM.CTX.PROVIDER property, replace “t3://10.10.10.10:1010” with
      “iiop://Websphere_IP:Bootstrap_port” or “t3://hostname:Server_Port

    • For PM.CTX.CONNFACTORY the appropriate connection factory needs to be provided for e.g jms/PMQCF.

    Figure 2-1 pmtm_job_param.txt


    File

  2. PMTM_SYSTEM_PARAMETERS table changes to be created/updated in screenPMDSYSPM.

    For PARAM_NAME “PM.CTX.FACTORY”, update the PARAM_VALUE as ‘weblogic.jndi.WLInitialContextFactory’ for weblogic and ‘com.ibm.websphere.naming.WsnInitialContextFactory’ for websphere.

    For PARAM_NAME “PM_CTX_PROVIDER”, update the PARAM_VALUE as “t3://Weblogic_IP:Server_Port” or ” or “t3://hostname:Server_Port” for web-logic and

    “iiop://Websphere_IP:Bootstrap_port” or “” or “t3://hostname:Server_Port” for web- sphere.

    • For PARAM_NAME “PM.CTX.CONNFACTORY” the appropriate connection factoryneeds to be provided which is created in JMS Server for e.g jms/PMQCF.
    • For PARAM_NAME “C2B_FILE_PATH”, give the C2B path maintained in theserver.
    • For PARAM_NAME “DD_FILE_PATH” property, give the DD path maintained in the server.
    • For PARAM_NAME “DEBUG_PATH” property, give the PM DEBUG path maintainedin the server.
    • For PARAM_NAME “DISPATCH_PATH” property, give the DISPATCH path maintainedin the server.
  3. CSTM_EXTERNAL_SERVER_DETAILS table updation.
    • For field “CONTEXT_PROV_URL”, update the values for Non-Cluster setup as “t3://Weblogic_IP:Server_Port” or “t3://Host Name:Server_Port” and for Cluster setup as “t3://HOST NAME1: PORT 1, HOST NAME2:PORT 2” in web-logic application server.
    • For QUEUE_FCTRY_JNDI value should be maintained as ‘jms/PMQCF’.
    • For CACHE_QUEUE_JNDI value should be maintained as ‘jms/CACHE_TOPIC’.