BASE24 Transaction Warehouse Runbook

BASE24 Transactio Transactionn Warehouse Warehouse Runbook Runbook ACI ACI Payments Manager™

BASE24 Transaction Warehouse Runbook

© 2007 by ACI Worldwide Inc. All rights reserved.

All information contained in this documentation is confidential and proprietary to ACI Worldwide Inc., and has been delivered for use use pursuant to license. No part of this documentation may be photocopied, electronically transferred, modified, or reproduced in any manner that is contrary con trary to license without the prior written consent of ACI Worldwide Worldwide Inc. Access Control Server, ACI Automated Case Management System, ACI Card Management System, ACI Claims Manager, ACI Commerce Gateway, Gateway, ACI Debit Card System, ACI e-Courier, ACI Host Link, ACI Merchant Merchan t Accounting System, ACI Payments Manager, ACI Proactive Risk Manager, ACI ACI Smart Chip Manager, BASE24, BASE24-atm, BASE24-card, BASE24-check auth, BASE24-configuration manager, BASE24-es, BASE24-frequent shopper, BASE24infobase, BASE24-pos, BASE24-refunds, BASE24-remote banking, BASE24-teller, NET24, and WINPAY24 are trademarks or registered trademarks of ACI Worldwide Inc., Transaction Systems Architects, Architects, Inc., or their subsidiaries. Other companies’ trademarks, trademarks, service marks, or registered trademarks and service marks are trademarks, service marks, or registered trademarks and service marks of their respective companies.

Feb-2007, Release 07.1

Publication Number: BTW03

2

Feb-2007 07.1 BTW03 ACI Worldwide Inc.


© 2007 by ACI Worldwide Inc. All rights reserved.

All information contained in this documentation is confidential and proprietary to ACI Worldwide Inc., and has been delivered for use use pursuant to license. No part of this documentation may be photocopied, electronically transferred, modified, or reproduced in any manner that is contrary con trary to license without the prior written consent of ACI Worldwide Worldwide Inc. Access Control Server, ACI Automated Case Management System, ACI Card Management System, ACI Claims Manager, ACI Commerce Gateway, Gateway, ACI Debit Card System, ACI e-Courier, ACI Host Link, ACI Merchant Merchan t Accounting System, ACI Payments Manager, ACI Proactive Risk Manager, ACI ACI Smart Chip Manager, BASE24, BASE24-atm, BASE24-card, BASE24-check auth, BASE24-configuration manager, BASE24-es, BASE24-frequent shopper, BASE24infobase, BASE24-pos, BASE24-refunds, BASE24-remote banking, BASE24-teller, NET24, and WINPAY24 are trademarks or registered trademarks of ACI Worldwide Inc., Transaction Systems Architects, Architects, Inc., or their subsidiaries. Other companies’ trademarks, trademarks, service marks, or registered trademarks and service marks are trademarks, service marks, or registered trademarks and service marks of their respective companies.

Feb-2007, Release 07.1

Publication Number: BTW03

2



TABLE OF CONTENTS TABLE OF CONTENTS ........................... ................................ ..... ........................... ......................................... ........................... ........................... ............................. ........................... ............ 3 1 BASE24 Transaction Warehouse (Java).............. (Java)............................ ........................... ........................... ........................... ........................... ............................ ................ 7 1.1 Overview ............................ .......................................... ............................ ............................ ............................ ............................ ............................ ............................ ............................ ......................... ........... 7 1.1.1 Pre-Cycle Processing ............... ............................. ............................ ............................ ............................ ............................ ............................ .......................... .......................... .............. 7 1.1.2 Cycle Processing............... Processing............................. ............................ ............................ ............................ ........................... ........................... ........................... ........................... ..................... ....... 7 1.1.3 Daily Processing Processing .......................... ........................................ ............................ ............................ ............................ ............................ ............................ ........................... ...................... ......... 7 1.1.4 End-of-Day Processing Processing .............. ............................ ............................ ............................ ........................... ........................... ............................ ............................ ......................... ........... 7 1.1.5 Monthly Processing ............... ............................. ............................ ............................ ........................... ........................... ............................ ........................... ........................... ................ .. 7 1.1.6 Quarterly Processing................ Processing.............................. ............................ ............................ ............................ ............................ ............................ .......................... .......................... .............. 7 1.1.7 Yearly Processing Processing ...................... .................................... ............................ ............................ ........................... ........................... ............................ ............................ ......................... ........... 7 1.1.8 On-Request Processing.. Processing.............. .......................... ............................ ............................ ........................... ........................... ............................ ............................ ......................... ........... 7 1.2 JCL Execution of Java ............... ............................ ........................... ............................ ............................ ........................... ........................... ........................... ........................... ..................... ....... 8 1.3 B40000 – Raw Load ........................... ............................. .. .......................... ........................................ ............................ ............................ ............................ ............................ ....................... ......... 9 1.4 B40110 – ATM Tran Mapper Loader... Loader............................... ......................................... ........................... ............................ ............................ ........................... .................... ....... 13 1.5 B40120 – POS Tran Mapper Mapper Loader ..................... ................................... ............................ ............................ ........................... ........................... ............................. ................. .. 16 1.6 B40130 – ATM Admin Mapper Loader Loader ................ ............................ ........................... ............................ ............................ ........................... ........................... .................. .... 19 1.7 B40140 – POS Admin Mapper Loader....................... Loader.................................... ........................... ........................... ........................... ........................... ........................... .............. 22 1.8 B40150 – ATM Unprocessed Unprocessed Tran Mapper Loader ................. .............................. ........................... ........................... ............................ .......................... ............ 25 1.9 B40160 – POS Unprocessed Tran Mapper Loader ..................... ................................... ........................... ........................... ........................... ........................ ........... 29 1.10 B40170 – ATM Unprocessed Admin Mapper Mapper Loader............... Loader............................. ............................ ........................... ........................... ......................... ........... 32 1.11 B40200 – BASE24 Warehouse Summary... Summary ................ ........................... ............................ ............................ ............................ ............................ ........................... ............. 35 1.12 B40210 – ODS ATM Tran Tran Conversion ................ ............................. ........................... ........................... ........................... ........................... ............................ ................... ..... 38 1.13 B40220 – ODS POS Tran Conversion....................... Conversion.................................... ........................... ........................... ........................... ........................... ............................ ............... 41 1.14 B40230 – ODS ATM Admin Admin Conversion ................. .............................. ............................ ........................... ........................... ............................ ........................... ............. 44 1.15 B40240 – ODS POS Admin Conversion ................. ............................. ........................... ........................... ........................... ........................... ............................ ................. .. 47 2 BASE24 Transaction Transaction Warehouse (COBOL) (COBOL) ................. .............................. ........................... ........................... ........................... ........................... ................. .... 50 2.1 Overview ............................ .............................. ........................... ......................................... ............................ ............................ ............................ ............................ ............................ ....................... ......... 50 2.1.1 Pre-Cycle Processing ................. ............................... ............................ ............................ ............................ ............................ ............................ ........................... ...................... ......... 50 2.1.2 Cycle Processing................. Processing............................... ............................ ............................ ............................ ............................ ............................ ........................... ........................... ................ .. 50 2.1.3 Daily Processing Processing ............. ............. ........................... ......................................... ............................ ............................ ............................ ............................ ........................... .................... ....... 51 2.1.4 End-of-Day Processing Processing ................. .............................. ........................... ............................ ............................ ........................... ........................... ............................ ..................... ....... 51 2.1.5 Monthly Processing .................. ............................... ........................... ............................ ............................ ........................... ........................... ........................... ......................... ............ 51 2.1.6 Quarterly Processing................ Processing.............................. ............................ ............................ ............................ ............................ ............................ .......................... ........................ ............ 51 2.1.7 Yearly Processing Processing ......................... ...................................... ........................... ............................ ............................ ........................... ........................... ............................ ..................... ....... 51 2.1.8 On-Request Processing.......................... Processing............ ............................ ........................... ........................... ............................ ............................ ........................... ......................... ............ 52 2.2 B4C100 – Preprocess Extr act act File File ................ ............................. ........................... ........................... ........................... ........................... ........................... ............................ .............. 53 2.3 B4C200 – ATM Mapper... Mapper............................. ........................................ ............................ ........................... ........................... ............................ ............................ ............................ .............. 55 2.4 B4C210 – POS POS Mapper ...................... .................................... ........................... ........................... ............................ ............................ ........................... ........................... ....................... ......... 58 2.5 B4C300 – Load Core Files ........................ ..................................... ........................... ............................ ............................ ........................... ........................... ............................ ................ .. 60 2.6 B4C305 – Load Suspense Suspense Files ................. ............................... ............................ ............................ ........................... ........................... ........................... ........................... ................ .. 66 2.7 B4C310 – Load POS T Fact File ................. ..... .......................... ........................... ........................... ............................ ........................... ........................... ............................ .............. 69 2.8 B4C311 – Load POS T Dim1 File............... File... ......................... ........................... ........................... ........................... ........................... ........................... ............................. ............... 70 2.9 B4C312 – Load POS T Dim2 File................... File...... ........................... ........................... ........................... ........................... ........................... ............................. ........................ ......... 71 2.10 B4C313 – Load POS T Token1 File................. File... ............................ ........................... ........................... ............................ ........................... ........................... ....................... ......... 72 2.11 B4C314 – Load POS T Token2 File .............. ............................ ............................ ............................ ........................... ........................... ........................... ......................... ............ 73 2.12 B4C315 – Load ODS POS Tran Dim3 File... Fi le............... ......................... ........................... ............................ ........................... ........................... ............................ .............. 74 2.13 B4C316 – Load ODS Card Details File...... ........................... ........................................ ........................... ........................... ........................... ............................ ................ .. 75 2.14 B4C317 – Load ODS POS Terminal File. ............... ............................. ........................... ........................... ........................... ........................... ............................ ................ .. 76 2.15 B4C318 – Load ODS POS Retailer Fil e................. e............................... ........................... ........................... ............................ ............................ ............................ ................ .. 77 2.16 B4C319 – Load ODS POST PK Fil e............... e............................. ............................ ........................... ........................... ............................ ............................ ....................... ......... 78 2.17 B4C330 – Load ATM T Fact File...... .......................... ........................................ ........................... ........................... ............................ ........................... ......................... ............ 79 2.18 B4C331 – Load ATM T Dim1 Dim1 File ................ ............................. ........................... ........................... ........................... ........................... ........................... .......................... ............ 80 Feb-2007 07.1 BTW03 ACI Worldwide Inc.

3


2.19 B4C332 – Load ATM T Dim2 File ............................................................................................................. 81 2.20 B4C333 – Load ATM T Token1 File .......................................................................................................... 82 2.21 B4C334 – Load ATM T Token2 File .......................................................................................................... 83 2.22 B4C335 – Load ODS ATM Tran Dim3 File ............................................................................................... 84 2.23 B4C336 – Load ODS Card Details File........ ............................................................................................... 85 2.24 B4C337 – Load ODS ATM Terminal File .................................................................................................. 86 2.25 B4C338 – Load ODS ATMT PK F ile ......................................................................................................... 87 2.26 B4C350 – Load POS A Fact File.... ............................................................................................................. 88 2.27 B4C351 – Load POS A Clrk File ................................................................................................................ 89 2.28 B4C352 – Load POS A Ser File .................................................................................................................. 90 2.29 B4C353 – Load POS A Set File .................................................................................................................. 91 2.30 B4C354 – Load POS A SPF File ................................................................................................................. 92 2.31 B4C355 – Load ODS PA Retailer File ........................................................................................................ 93 2.32 B4C356 – Load ODS PA Terminal File.. .................................................................................................... 94 2.33 B4C357 – Load ODS Card Details File ....................................................................................................... 95 2.34 B4C358 – Load ODS POSA PK File .......................................................................................................... 96 2.35 B4C370 – Load ATM A Fact File ............................................................................................................... 97 2.36 B4C371 – Load ATM A Terminal Balance File.......................................................................................... 98 2.37 B4C372 – Load ATM ATRMCSH File....................................................................................................... 99 2.38 B4C373 – Load ATM TRMS File............................................................................................................. 100 2.39 B4C374 – Load Card Details File.............................................................................................................. 101 2.40 B4C375 – Load ODS AA Terminal File ................................................................................................... 102 2.41 B4C376 – Load ODS ATMA PK File....................................................................................................... 103 2.42 B4C390 – Load ATM Terminal Files ........................................................................................................ 104 2.43 B4D200 – ATM Backout and Suspense Processing.................................................................................. 106 2.44 B4D210 – POS Backout and Suspense Processing ................................................................................... 113 2.45 B4D300 – Load Core Files for Backout/Suspense .................................................................................... 120 2.46 B4D305 – Load Suspense Files for Backout/Suspense ............................................................................. 126 2.47 B4D310 – Load POS T Fact File for Backout/Suspense ........................................................................... 129 2.48 B4D311 – Load POS T Dim1 File for Backout/Suspense......................................................................... 130 2.49 B4D312 – Load POS T Dim2 File for Backout/Suspense......................................................................... 131 2.50 B4D313 – Load POS T Token1 File for Backout/Suspense...................................................................... 132 2.51 B4D314 – Load POS T Token2 File for Backout/Suspense...................................................................... 133 2.52 B4D315 – Load ODS POS Tran Dim3 File for Backout/Suspense........................................................... 134 2.53 B4D316 – Load ODS Card Details File for Backout/Suspense....... .......................................................... 135 2.54 B4D317 – Load ODS POS Terminal File for Backout/Suspense.. ............................................................ 136 2.55 B4D318 – Load ODS POS Retailer File for Backout/Suspense ................................................................ 137 2.56 B4D319 – Load ODS POST PK File for Backout/Suspense ..................................................................... 138 2.57 B4D330 – Load ATM T Fact File for Backout/Suspense.......................................................................... 139 2.58 B4D331 – Load ATM T Dim1 File for Backout/Suspense ....................................................................... 140 2.59 B4D332 – Load ATM T Dim2 File for Backout/Suspense ....................................................................... 141 2.60 B4D333 – Load ATM T Token1 File for Backout/Suspense .................................................................... 142 2.61 B4D334 – Load ATM T Token2 File for Backout/Suspense .................................................................... 143 2.62 B4D335 – Load ODS ATM Tran Dim3 File for Backout/Suspense ......................................................... 144 2.63 B4D336 – Load ODS Card Details File for Backout/Suspense......... ........................................................ 145 2.64 B4D337 – Load ODS ATM Terminal File for Backout/Suspense ............................................................ 146 2.65 B4D338 – Load ODS ATMT PK File for Backout/Suspense ................................................................... 147 2.66 B4D390 – Load ATM Terminal Files ....................................................................................................... 148 2.67 B4D400 – ODS Processing........................................................................................................................ 150 2.68 B4D500 – Warehouse Summary Update ................................................................................................... 152 APPENDIX A ............................................................................................................................................ 154 MapperLoader Return Codes / PRCS_LOG rtrn_code.......................................................................................... 154 APPENDIX B ............................................................................................................................................. 157 Cleaning Up for a Rerun or Error (trace tables and exception tables) ................................................................... 157 APPENDIX C ............................................................................................................................................. 159 Starting the Mapper Loader Interactively for Real Time Processing .................................................................... 159 4



APPENDIX D ............................................................................................................................................ 161 Continual Batch Loading from -es – Automapper................................................................................................. APPENDIX E ............................................................................................................................................. 162 Job – Database Cross Reference............................................................................................................................ APPENDIX F ............................................................................................................................................. 163 ES ACTION CODES TO PTLF RESPONSE CODES .... .................................................................................... APPENDIX G ............................................................................................................................................ 165 DATE ROUTINE MESSAGES ............................................................................................................................ I/O ROUTINE MESSAGES.... ..............................................................................................................................


161 162 163 165 167

5


ACI Worldwide Inc.

6



1 BASE24 Transaction Warehouse (Java) 1.1 Overview 1.1.1 Pre-Cycle Processing None.

1.1.2 Cycle Processing None.

1.1.3 Daily Processing None.

1.1.4 End-of-Day Processing None.

1.1.5 Monthly Processing None.

1.1.6 Quarterly Processing None.

1.1.7 Yearly Processing None.

1.1.8 On-Request Processing None.


7


1.2 JCL Execution of Java The following information applies to all Transaction Warehouse processes that are written in the Java programming language. Program BPXBATCH:

In the JCL, BPXBATCH is the IBM program that is used to execute shell scripts in the UNIX environment. When BPXBATCH is specified as the program to execute in the JCL, it is really executing a program that ends with cat, java or rm. The UNIX program that is executed can be identified by looking at the UNIX script specified by the STDIN DD in the JCL. The script name will be the JCL name and the step name separated by an underscore. For example, in job B40110, the script name for STEP05 is B40110_STEP05.sh.

Step STEPU1:

The first step of each procedure is to reset the UNIX sysout files. This is accomplished by copying a null file to the .out file of the Java program. Step STEPU9:

The last step of each procedure is to copy the UNIX output files of the Java program(s) to the SDSF sysout. This allows the operations staff to see the UNIX sysout messages in their normal SDSF environment, thus eliminating the need to look two places to get the complete information on a procedure.

8



1.3 B40000 – Raw Load

B40000

STEPU1 IKJEFT01

Input Base24SuperExtractFile Output ATM_ADMIN_RAW00 ATM_TRAN_RAW00 POS_ADMIN_RAW00 POS_TRAN_RAW00 WHSE_AATRC_PROC WHSE_ATTRC_PROC WHSE_PATRC_PROC WHSE_PTTRC_PROC ATM_BATCH_DUP_CHK POS_BATCH_DUP_CHK SM_AATRC_PROC(onlyifSVisinstalled) SM_ATTRC_PROC(onlyifSVorHMis installed) SM_PTTRC_PROC(onlyifSVorHMis installed) EA_ATTRC_PROC(onlyifXAisinstalled) EA_PTTRC_PROC(onlyifXAisinstalled) RT_AMNTRC_PROC(onlyifMonitoringis installed) RT_PMNTRC_PROC(onlyifMonitoringis installed) RT_AALTRC_PROC(onlyifAlertingis installed) RT_PALTRC_PROC(onlyifAlertingis installed)

STEPU2 IKJEFT01

Database

STEP05 BPXBATCH (MapperLoader)

STEPU8 IKJEFT01

STEPU9 IKJEFT01


9


Description:

Inserts BASE24 Super extract files into the Raw data tables. This is only run when Mapper Loader is in batch mode. Dependencies:

None Restart Instructions:

Restore affected tables to their prerun state, and start at the beginning of the job. Rerun Instructions:

Restore affected tables to their prerun state, and start at the beginning of the job.

STEPU1 Clear out the previous run’s .out file.

PROGRAM: IKJEFT01 INPUT PARAMETERS: SYSTSIN

B4CPNULL

INPUT FILES: DNULL

/dev/null

OUTPUT FILES: UFILE01

/B40000_STEP05.out

RESTART INSTRUCTIONS: Restart at this step. STEPU2 Copy the BASE24 Super Extract to a temporary USS file.


B40000U2

INPUT FILES: MXTRACT

Extract file

OUTPUT FILES: UXTRACT

File path on HFS

RESTART INSTRUCTIONS: Restart at this step.

10



STEP05

PROGRAM: BPXBATCH (script B40000_STEP05.sh) – MapperLoader.RawLoad.B24Extract is executed. INPUT PARAMETERS: Properties file, copied BASE24 file (UXTRACT variable) Optional parameters – aa, at, pa, pt. The default normal processing is to load all records to the database. However, if a situation arises where only certain types of records need to be loaded, the java execution line can be edited to have any or all of these four parameters after the UXTRACT (separated by a space). Respectively, they represent “atm admin”, “atm tran”, “pos admin”, and “pos tran”. If any of these parameters are specified, only those specified will be loaded to the database. For example, specifying aa at pt would cause everything but POS admin transactions to be loaded. INPUT FILES: BASE24 Super Extract file

OUTPUT FILES: ATM_ADMIN_RAW00 ATM_TRAN_RAW00 POS_ADMIN_RAW00 POS_TRAN_RAW00 WHSE_AATRC_PROC WHSE_ATTRC_PROC WHSE_PATRC_PROC WHSE_PTTRC_PROC ATM_BATCH_DUP_CHK POS_BATCH_DUP_CHK SM_AATRC_PROC (only if SV is installed) SM_ATTRC_PROC (only if SV or HM is installed) SM_PTTRC_PROC (only if SV or HM is installed) EA_ATTRC_PROC (only if XA is installed) EA_PTTRC_PROC (only if XA is installed) RT_AMNTRC_PROC (only if Monitoring is installed) RT_PMNTRC_PROC (only if Monitoring is installed) RT_AALTRC_PROC (only if Alerting is installed) RT_PALTRC_PROC (only if Alerting is installed)


RETURN CODES AND ACTIONS CONCERNING THOSE CODES: See Appendix A. STEPU8 Delete the temporary BASE24 Super Extract from USS.

PROGRAM: IKJEFT01


11


INPUT PARAMETERS: SYSTSIN

DUMMY

INPUT FILES: OUTPUT FILES: UXTRACT

File path on HFS


STEPU9 Copy this run’s .out file to the sysout.


B4CPSYSO

INPUT FILES: UFILE01

/B40000_STEP05.out

OUTPUT FILES: OSTEP01

SYSOUT=*


12



1.4 B40110 – ATM Tran Mapper Loader

B40110 Input ATM_TRAN_RAW00 STEPU1 IKJEFT01

Input/Output WHSE_ATTRC_PROC ATM_TF_DT_WD ATM_TF_FD_WD ATM_TF_TDT_WD Output WHSE_ATTRC_DEL ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_T_TKN1 ATM_T_TKN2 ATM_T_DIM1 ATM_T_DIM2 ATM_T_FACT Output (error tables) WHSE_ATTRC_ERR PRCS_LOG ATM_TRAN_RAW_EXCP

Database


STEPU9 IKJEFT01

Description:

Selects transactions from the ATM_TRAN_RAW00 table and writes to the ATM financial transaction Tran Warehouse tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The ATM_TRAN_RAW00 table must contain financial transactions. Restart Instructions:

Can be restarted without restoring any tables – it will start with the lowest key in the WHSE_ATTRC_PROC table. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table clean up information. Delete rows from ATM_T_TKN1, ATM_T_TKN2, ATM_T_DIM1, ATM_T_DIM2, and ATM_T_FACT that match any of the transaction keys • •


13




B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40110_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40110_STEP05.sh) – MapperLoader.Batch.TW.ATMTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: ATM_TRAN_RAW00 WHSE_ATTRC_PROC ATM_TF_DT_WD ATM_TF_FD_WD ATM_TF_TDT_WD

OUTPUT FILES: WHSE_ATTRC_PROC ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TF_DT_WD ATM_TF_FD_WD ATM_TF_TDT_WD ATM_T_TKN1 ATM_T_TKN2 ATM_T_DIM1 ATM_T_DIM2 ATM_T_FACT WHSE_ATTRC_DEL WHSE_ATTRC_ERR PRCS_LOG ATM_TRAN_RAW_EXCP

14




RETURN CODES AND ACTIONS CONCERNING THOSE CODES: See Appendix A. STEPU9 Copy this run’s .out file to the sysout.


B4CPSYSO


/B40110_STEP05.out


SYSOUT=*



15


1.5 B40120 – POS Tran Mapper Loader

B40120 Input POS_TRAN_RAW00

STEPU1 IKJEFT01

Input/Output WHSE_PTTRC_PROC POS_TF_DT_WD POS_TF_FD_WD POS_TF_TDT_WD Output WHSE_PTTRC_DEL ODS_POST_PK ODS_CARD_DETAILS ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 POS_T_TKN1 POS_T_TKN2 POS_T_DIM1 POS_T_DIM2 POS_T_FACT

Database


STEPU9 IKJEFT01

Output (error tables) WHSE_PTTRC_ERR PRCS_LOG POS_TRAN_RAW_EXCP Description:

Selects transactions from the POS_TRAN_RAW00 table and writes to the POS financial transaction Tran Warehouse tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The POS_TRAN_RAW00 table must contain financial transactions. Restart Instructions:

Can be restarted without restoring any tables – it will start with the lowest key in the WHSE_PTTRC_PROC table. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table clean up information. Delete rows from POS_T_TKN1, POS_T_TKN2, POS_T_DIM1, POS_T_DIM2, and POS_T_FACT that match any of the transaction keys • •

16



STEPPU1 Clear out the previous run’s .out file.


B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40120_STEP05.out


STEP05

PROGRAM: BPXBATCH BPXBATCH (script B40120_STEP05.sh) – MapperLoader.Batch.TW.P MapperLoader.Batch.TW.POSTran OSTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: POS_TRAN_RAW00 WHSE_PTTRC_PROC POS_TF_DT_WD POS_TF_FD_WD POS_TF_TDT_WD

OUTPUT FILES: WHSE_PTTRC_PROC ODS_POST_PK ODS_CARD_DETAILS ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 POS_TF_DT_WD POS_TF_FD_WD POS_TF_TDT_WD POS_T_TKN1 POS_T_TKN2 POS_T_DIM1 POS_T_DIM2 POS_T_FACT WHSE_PTTRC_DEL WHSE_PTTRC_ERR PRCS_LOG POS_TRAN_RAW_EXCP Feb-2007 07.1 BTW03 ACI Worldwide Inc.

17





B4CPSYSO


/B40120_STEP05.out


SYSOUT=*


18



1.6 B40130 – ATM Admin Mapper Loader

B40130 Input ATM_ADMIN_RAW00

STEPU1 IKJEFT01

Input/Output WHSE_AATRC_PROC ATM_AF_DT_WD ATM_AF_FD_WD ATM_AF_TDT_WD Output WHSE_AATRC_DEL ODS_ATMA_PK ODS_AA_TERMINAL ODS_CARD_DETAILS ATM_A_TRMBL ATM_ATRMCSH ATM_A_TRMS ATM_A_FACT Output (error tables) WHSE_AATRC_ERR PRCS_LOG ATM_ADMIN_RAW_EXCP

Database


STEPU9 IKJEFT01

Description:

Selects transactions from the ATM_ADMIN_RAW00 table and writes to the ATM admin transaction Tran Warehouse tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The ATM_ADMIN_RAW00 ATM_ADMIN_RAW00 table must contain admin transactions. Restart Instructions:

Can be restarted without restoring any tables. It will start with the lowest key in the WHSE_AATRC_PROC table. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table clean up information. Delete rows from ATM_A_TRMBL, ATM_ATRMCSH, ATM_A_TRMS, and ATM_A_FACT that match any of the transaction keys. • •


19




B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40130_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40130_STEP05.sh) – MapperLoader.Batch.TW.ATMAdmin is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: ATM_ADMIN_RAW00 WHSE_AATRC_PROC ATM_AF_DT_WD ATM_AF_FD_WD ATM_AF_TDT_WD

OUTPUT FILES: WHSE_AATRC_PROC ODS_ATMA_PK ODS_AA_TERMINAL ODS_CARD_DETAILS ATM_AF_DT_WD ATM_AF_FD_WD ATM_AF_TDT_WD ATM_A_TRMBL ATM_ATRMCSH ATM_A_TRMS ATM_A_FACT WHSE_AATRC_DEL WHSE_AATRC_ERR PRCS_LOG ATM_ADMIN_RAW_EXCP

RESTART INSTRUCTIONS: Restart at this step. 20





B4CPSYSO


/B40130_STEP05.out


SYSOUT=*



21


1.7 B40140 – POS Admin Mapper Loader

B40140 Input POS_ADMIN_RAW00

STEPU1 IKJEFT01

Input/Output WHSE_PATRC_PROC POS_AF_DT_WD POS_AF_FD_WD POS_AF_TDT_WD Output WHSE_PATRC_DEL ODS_POSA_PK ODS_CARD_DETAILS ODS_PA_RETAILER ODS_PA_TERMINAL POS_A_CLRK POS_A_SER POS_A_SET POS_A_SPF POS_A_FACT Output (error tables) WHSE_PATRC_ERR PRCS_LOG POS_ADMIN_RAW_EXCP

Database


STEPU9 IKJEFT01

Description:

Selects transactions from the POS_ADMIN_RAW00 table and writes to the POS admin transaction Tran Warehouse tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The POS_ADMIN_RAW00 table must contain admin transactions. Restart Instructions:

Can be restarted without restoring any tables. It will start with the lowest key in the WHSE_PATRC_PROC table. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table cleanup information. Delete rows from POS_A_CLRK, POS_A_SER, POS_A_SET, POS_A_SPF, and POS_A_FACT that match any of the transaction keys • •

22



URESET Clear out the previous run’s .out file.


B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40140_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40140_STEP05.sh) – MapperLoader.Batch.TW.POSAdmin is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: POS_ADMIN_RAW00 WHSE_PATRC_PROC POS_AF_DT_WD POS_AF_FD_WD POS_AF_TDT_WD

OUTPUT FILES: WHSE_PATRC_PROC ODS_POSA_PK ODS_CARD_DETAILS ODS_PA_RETAILER ODS_PA_TERMINAL POS_AF_DT_WD POS_AF_FD_WD POS_AF_TDT_WD POS_A_CLRK POS_A_SER POS_A_SET POS_A_SPF POS_A_FACT WHSE_PATRC_DEL WHSE_PATRC_ERR PRCS_LOG POS_ADMIN_RAW_EXCP


23


RESTART INSTRUCTIONS: Restart at this step. STEPU9 Copy this run’s .out file to the sysout.


B4CPSYSO


/B40140_STEP05.out


SYSOUT=*


24



1.8 B40150 – ATM Unprocessed Tran Mapper Loader Input AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS ATM_TRAN_RAW00 BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_TLF_TXN_CD_XREF CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_INTRNL_MAPPER CZ_MRCH_CAT_CD_REF CZ_PROD CZ_RESP_CD CZ_SRCE_BU CD_TC_PROC_TXN Input/Output SM_ATTRC_PROC B4_SUSPENDED_TXNS SM_ATTRC_ERR CZ_T_BTCH CZ_EXT_BTCH_ID CZ_EXT_FILE_ID CZ_TXN_BO

B40150

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01 Output SM_ATTRC_DEL CZ_PIN_CHG_TXN CZ_UNPRCD_AMTS CZ_TXN_GENRC_TOKEN CZ_UNPRCD_TXN CZ_T_FILE CZ_PRCD_TXN CZ_PRCD_AMTS HM_ADDL_TXN_DATA Output (errortables) PRCS_LOG ATM_TRAN_RAW_EXCP

Description:

Selects transactions from the ATM_TRAN_RAW00 table and writes to the unprocessed transaction tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The ATM_TRAN_RAW00 table must contain financial transactions.


25


Restart Instructions:

Can be restarted without restoring any tables. It will start with the lowest key in the SM_ATTRC_PROC table. Partially processed transactions will be pulled from SM_ATTRC_ERR and processed. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table cleanup information. Run B4R100 to reset proc and del trace tables. • •



B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40150_STEP05.out

RESTART INSTRUCTIONS: Restart at this step. STEP05

PROGRAM: BPXBATCH (script B40150_STEP05.sh) – MapperLoader.BaseClasses.SM.ATMTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS ATM_TRAN_RAW00 SM_ATTRC_PROC BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_TLF_TXN_CD_XREF CD_TC_PROC_TXN CZ_BIN 26



CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BU_TYP CZ_BUS_UNIT CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_INTRNL_MAPPER CZ_MRCH_CAT_CD_REF CZ_PROD CZ_RESP_CD CZ_SRCE_BU B4_SUSPENDED_TXNS (error processing) OUTPUT FILES: SM_ATTRC_PROC SM_ATTRC_DEL SM_ATTRC_ERR PRCS_LOG ATM_TRAN_RAW_EXCP CZ_PIN_CHG_TXN CZ_UNPRCD_AMTS CZ_TXN_GENRC_TOKEN CZ_UNPRCD_TXN CZ_T_BTCH CZ_EXT_BTCH_ID CZ_EXT_FILE_ID CZ_TXN_BO CZ_T_FILE CZ_PRCD_TXN CZ_PRCD_AMTS HM_ADDL_TXN_DATA B4_SUSPENDED_TXNS (error processing)




B4CPSYSO


/B40150_STEP05.out


27



SYSOUT=*


28



1.9 B40160 – POS Unprocessed Tran Mapper Loader Input POS_TRAN_RAW00 AM_ACCT AM_TI BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_PLF_TXN_CD_XREF B4_REG_GRP_BRCH B4_TERM CD_TC_PROC_TXN CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_INTRNL_MAPPER CZ_MRCH_CAT_CD_REF CZ_PROD CZ_RESP_CD CZ_SRCE_BU Input/Output SM_PTTRC_PROC B4_SUSPENDED_TXNS SM_PTTRC_ERR CZ_T_BTCH CZ_EXT_BTCH_ID CZ_EXT_FILE_ID CZ_TXN_BO Output SM_PTTRC_DEL CZ_UNPRCD_AMTS CZ_TXN_GENRC_TOKEN CZ_UNPRCD_TXN

B40160

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Output (continued) HM_ADDL_TXN_DATA CZ_T_FILE CZ_PRCD_TXN CZ_PRCD_AMTS CZ_TXN_SWITCH CZ_LINE_ITEM_DTL Output (errortables) PRCS_LOG POS_TRAN_RAW_EXCP

Description:

Selects transactions from the POS_TRAN_RAW00 table and writes to the unprocessed tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The POS_TRAN_RAW00 table must contain financial transactions. Restart Instructions:

Can be restarted without restoring any tables. It will start with the lowest key in the SM_PTTRC_PROC table. Partially processed transactions will be pulled from SM_PTTRC_ERR and processed.


29


Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table cleanup information. Run B4R100 to reset proc and del trace tables. • •



B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40160_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40160_STEP05.sh) – MapperLoader.Batch.SM.POSTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: AM_ACCT AM_TI BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_PLF_TXN_CD_XREF B4_REG_GRP_BRCH B4_SUSPENDED_TXNS (error processing) B4_TERM CD_TC_PROC_TXN CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT SM_PTTRC_PROC 30



CZ_INTRNL_MAPPER CZ_MRCH_CAT_CD_REF CZ_PROD CZ_RESP_CD CZ_SRCE_BU POS_TRAN_RAW00 OUTPUT FILES: SM_PTTRC_PROC SM_PTTRC_DEL SM_PTTRC_ERR PRCS_LOG POS_TRAN_RAW_EXCP B4_SUSPENDED_TXNS (error processing) CZ_T_BTCH CZ_EXT_BTCH_ID CZ_EXT_FILE_ID CZ_TXN_BO CZ_T_FILE CZ_PRCD_TXN CZ_PRCD_AMTS CZ_TXN_SWITCH CZ_LINE_ITEM_DTL CZ_UNPRCD_AMTS CZ_TXN_GENRC_TOKEN CZ_UNPRCD_TXN HM_ADDL_TXN_DATA RESTART INSTRUCTIONS: Restart at this step.



B4CPSYSO


/B40160_STEP05.out


SYSOUT=*



31


1.10 B40170 – ATM Unprocessed Admin Mapper Loader B40170 Input ATM_ADMIN_RAW00 B4_FIID CZ_BIN CZ_BIN_BIN_RNG CZ_BUS_UNIT CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_INTRNL_MAPPER CZ_RESP_CD Input/Output SM_AATRC_PROC B4_SUSP_ADMIN B4_SUSP_ADMIN_ADJ B4_SUSP_ADMIN_REC SM_AATRC_ERR Output SM_AATRC_DEL SZ_HOPR_BAL_TTL SZ_TERM_BAL SZ_TERM_BAL_ADMIN

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Output (error tables) PRCS_LOG ATM_TRAN_RAW_EXCP

Description:

Selects transactions from the ATM_ADMIN_RAW00 table and writes to the unprocessed transaction tables. This is only run when Mapper Loader is in batch mode. Dependencies:

The ATM_ADMIN_RAW00 ATM_ADMIN_RAW00 table must contain financial transactions. Restart Instructions:

Can be restarted without restoring any tables. It will start with the lowest key in the SM_AATRC_PROC SM_AATRC_PROC table. Partially processed transactions will be pulled from SM_AATRC_ERR and processed. Rerun Instructions:

To rerun the entire procedure: Refer to Appendix B for trace table and exception table clean up information. Run B4R100 to reset proc and del trace tables. • •

32





B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40170_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40170_STEP05.sh) – MapperLoader.Batch.SM.ATM MapperLoader.Batch.SM.ATMAdmin Admin is executed. INPUT PARAMETERS: Properties file (ml.properties) (ml.properties) INPUT FILES: ATM_ADMIN_RAW00 SM_AATRC_PROC B4_FIID CZ_BIN CZ_BIN_BIN_RNG CZ_BUS_UNIT CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_INTRNL_MAPPER CZ_RESP_CD B4_SUSP_ADMIN B4_SUSP_ADMIN (error processing) B4_SUSP_ADMIN_ADJ B4_SUSP_ADMIN_ADJ (error processing) B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_REC (error processing) OUTPUT FILES: SM_AATRC_PROC SM_AATRC_DEL SM_AATRC_ERR PRCS_LOG ATM_ADMIN_RAW_EXCP B4_SUSP_ADMIN B4_SUSP_ADMIN (error processing) B4_SUSP_ADMIN_ADJ B4_SUSP_ADMIN_ADJ (error processing) B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_REC (error processing) SZ_HOPR_BAL_TTL SZ_TERM_BAL SZ_TERM_BAL_ADMIN Feb-2007 07.1 BTW03 ACI Worldwide Inc.

33





B4CPSYSO


/B40170_STEP05.out


SYSOUT=*


34



1.11 B40200 – BASE24 Warehouse Summary

B40200

STEPU1 IKJEFT01

STEPU2 IKJEFT01

Input ATM_A_FACT POS_A_FACT ATM_T_FACT POS_T_FACT ATM_AF_FD_WD POS_AF_FD_WD ATM_TF_FD_WD POS_TF_FD_WD

Database


Output WHSE_SUM PRCS_LOG STEPU9 IKJEFT01

Description:

Does counts by day on the ATM and POS fact tables and inserts them into the WHSE_SUM table. Dependencies:

Can be run any time, but ideally this should run after completion of the B40* jobs. Restart Instructions:

Can be restarted without reloading any tables.


35


Rerun Instructions:

Can be rerun without reloading any tables. STEPU1 Clear out the previous run’s .out file and create file for UAPPEND step.


B40200U1

INPUT FILES: DNULL

/dev/null

OUTPUT FILES: UFILE01 UTMPENV

/B40200_STEP05.out /b40200_env.tmp

RESTART INSTRUCTIONS: Restart at this step. STEPU2 Add STARTDATE and ENDDATE variables to env file.


B40200U2

INPUT FILES: MTMPDATE

Instream – Contains STARTDATE and ENDDATE.

OUTPUT FILES: UTEMPENV

/b40200_env.tmp

RESTART INSTRUCTIONS: Restart at this step STEP05

PROGRAM: BPXBATCH executes script B40200_STEP05.sh. That script executes another script called B40200_ALL.sh, which executes the following programs: MapperLoader.Summary.TW.ATMTranKeep MapperLoader.Summary.TW.ATMTranDrop MapperLoader.Summary.TW.ATMTranMultipleLN MapperLoader.Summary.TW.ATMAdmin MapperLoader.Summary.TW.POSTranKeep MapperLoader.Summary.TW.POSTranDrop MapperLoader.Summary.TW.POSTranMultipleLN MapperLoader.Summary.TW.POSAdmin MapperLoader.Summary.TW.VisaIncoming 36



MapperLoader.Summary.TW.VisaOutgoing MapperLoader.Summary.TW.IPMIncoming MapperLoader.Summary.TW.IPMOutgoing MapperLoader.Summary.TW.ECCFIncoming MapperLoader.Summary.TW.ECCFOutgoing INPUT PARAMETERS: Properties file, STARTDATE, and ENDDATE If STARTDATE and ENDDATE are specified, this will summarize the range of days inclusive. If only STARTDATE is specified, it will summarize that day plus the previous 5 days. If neither is specified (standard procedure), it will summarize today’s date. INPUT FILES: ATM_A_FACT POS_A_FACT ATM_T_FACT POS_T_FACT ATM_AF_FD_WD POS_AF_FD_WD ATM_TF_FD_WD POS_TF_FD_WD

OUTPUT FILES: WHSE_SUM PRCS_LOG




B4CPSYSO


/B40200_STEP05.out


SYSOUT=*



37


1.12 B40210 – ODS ATM Tran Conversion

B40210 Input/Output ATM_T_FACT ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TERMINAL ATM_TRAN_DIM3 CARD_DETAILS

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Description:

Selects transactions from the ODS tables used by ATM admin transactions and reduces the amount of transactions to only the new distinct rows. The new rows are placed in the final TW tables. The FACT table is updated, with the references to the ODS tables being changed to the final TW tables. Dependencies:

None. Restart Instructions:

Can be restarted without restoring any tables. Rerun Instructions:

Can be rerun without restoring any tables.


38




B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40210_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40210_STEP05.sh) – MapperLoader.ODS.ODSATMTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: ATM_T_FACT ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TERMINAL ATM_TRAN_DIM3 CARD_DETAILS

OUTPUT FILES: ATM_T_FACT ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TERMINAL ATM_TRAN_DIM3 CARD_DETAILS




39



B4CPSYSO


/B40210_STEP05.out


SYSOUT=*


40



1.13 B40220 – ODS POS Tran Conversion

B40220 Input/Output POS_T_FACT ODS_POST_PK ODS_CARD_DETAILS ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 CARD_DETAILS POS_RETAILER POS_TERMINAL POS_TRAN_DIM3

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Description:







41



B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40220_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40220_STEP05.sh) – MapperLoader.ODS.ODSPOSTran is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: POS_T_FACT ODS_POST_PK ODS_CARD_DETAILS ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 CARD_DETAILS POS_RETAILER POS_TERMINAL POS_TRAN_DIM3

OUTPUT FILES: POS_T_FACT ODS_POST_PK ODS_CARD_DETAILS ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 CARD_DETAILS POS_RETAILER POS_TERMINAL POS_TRAN_DIM3


RETURN CODES AND ACTIONS CONCERNING THOSE CODES: See Appendix A. 42



STEPU9 Copy this run’s .out file to the sysout.


B4CPSYSO


/B40220_STEP05.out


SYSOUT=*



43


1.14 B40230 – ODS ATM Admin Conversion

B40230 Input/Output ATM_A_FACT ODS_ATMA_PK ODS_AA_TERMINAL ODS_CARD_DETAILS ATM_TERMINAL CARD_DETAILS

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Description:






44




B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40230_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40230_STEP05.sh) – MapperLoader.ODS.ODSATMAdmin is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: ATM_A_FACT ODS_ATMA_PK ODS_AA_TERMINAL ODS_CARD_DETAILS ATM_TERMINAL CARD_DETAILS

OUTPUT FILES: ATM_A_FACT ODS_ATMA_PK ODS_AA_TERMINAL ODS_CARD_DETAILS ATM_TERMINAL CARD_DETAILS



PROGRAM: IKJEFT01


45


INPUT PARAMETERS: SYSTSIN

B4CPSYSO


/B40230_STEP05.out


SYSOUT=*


46



1.15 B40240 – ODS POS Admin Conversion

B40240 Input/Output POS_A_FACT ODS_POSA_PK ODS_CARD_DETAILS ODS_PA_RETAILER ODS_PA_TERMINAL CARD_DETAILS POS_RETAILER POS_TERMINAL

STEPU1 IKJEFT01

Database


STEPU9 IKJEFT01

Description:

Selects transactions from the ODS tables used by POS admin transactions and reduces the amount of transactions to only the new distinct rows. The new rows are placed in the final TW tables. The FACT table is updated, with the references to the ODS tables being changed to the final TW tables. Dependencies:






47



B4CPNULL

INPUT FILES: DNULL

/dev/null


/B40240_STEP05.out


STEP05

PROGRAM: BPXBATCH (script B40240_STEP05.sh) – MapperLoader.ODS.ODSPOSAdmin is executed. INPUT PARAMETERS: Properties file (ml.properties) INPUT FILES: POS_A_FACT ODS_POSA_PK ODS_CARD_DETAILS ODS_PA_RETAILER ODS_PA_TERMINAL CARD_DETAILS POS_RETAILER POS_TERMINAL

OUTPUT FILES: POS_A_FACT ODS_POSA_PK ODS_CARD_DETAILS ODS_PA_RETAILER ODS_PA_TERMINAL CARD_DETAILS POS_RETAILER POS_TERMINAL



48




B4CPSYSO


/B40240_STEP05.out


SYSOUT=*



49


2 BASE24 Transaction Warehouse (COBOL) 2.1 Overview 2.1.1 Pre-Cycle Processing None.

2.1.2 Cycle Processing

B4C100 ExtractPreprocessor

B4C200

B4C210

ATMMapper

POSMapper

TableLoads

B4C330 B4C331 B4C332 B4C333 B4C334 B4C335 B4C336 B4C337 B4C338 B4C370 B4C371 B4C372 B4C373 B4C374 B4C375 B4C376 B4C390

50

B4C300 B4C305

B4C310 B4C311 B4C312 B4C313 B4C314 B4C315 B4C316 B4C317 B4C318 B4C319 B4C350 B4C351 B4C352 B4C353 B4C354 B4C355 B4C356 B4C357 B4C358



2.1.3 Daily Processing B4D200

B4D210

ATM Backout and Suspense Processing

ATM Backout and Suspense Processing Table Loads

B4D330 B4D331 B4D332 B4D333 B4D334 B4D335 B4D336 B4D337 B4D338

B4D300 B4D305 B4D390

B4D310 B4D311 B4D312 B4D313 B4D314 B4D315 B4D316 B4D317 B4D318 B4D319

B4D400 ODS Processing

B4D500 Warehouse Summary Update

2.1.4 End-of-Day Processing None.

2.1.5 Monthly Processing None.

2.1.6 Quarterly Processing None.

2.1.7 Yearly Processing None. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

51


2.1.8 On-Request Processing None.

52



2.2 B4C100 – Preprocess Extract File

STEP05

OUTPUT ATM_FILE_INFO POS_FILE_INFO CZ_T_FILE CZ_T_BTCH

Sequence Files

B4C100nn. ATMBTRN (+1)

B4B00100

B4C100nn. POSBTRN (+1)

INPUT/OUTPUT ATM_BATCH_DUP_CHK POS_BATCH_DUP_CHK

PARMLIB B4C10005 B4C100OR

Preprocess Base24 Extract Files

Base24 Extract File

B4C100nn. BERRFILE (+1)

B4C100nn. DERRFILE (+1)

Description: Preprocess the extract file. Preprocessing includes duplicate file checking, updating file tracking, and optionally validating file trailer counts and amounts. This process will also split the ATM and POS transactions into two separate files so they can be processed in parallel. Dependencies:

Can not run with jobs that use the sequence files. Restart Instructions:

Restart at the beginning. Rerun Instructions:

Restart at the beginning. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

53


STEP05

PROGRAM: B4B00100 - Reads the extract file, checks for duplicate files, updates file tracking information, updates file info (counts & amounts) for each logical file, and splits the extract into and an atm file and a pos file. INPUT PARAMETERS: COMMIT PARM1IN PARM2IN

COMMIT - Number of transactions to process before a COMMIT B4C10005 B4C100OR

INPUT FILES: BEXTRACT DEXTRACT

JCL Override of Binary extract file JCL Override of Display extract file

OUTPUT FILES: ATMBTRN POSBTRN BERRFILE DERRFILE

B4C100nn.ATMBTRN(+1) B4C100nn.POSBTRN(+1) B4C100nn.BERRFILE(+1) B4C100nn.DERRFILE(+1)

ATM_FILE_INFO POS_FILE_INFO CZ_T_FILE CZ_T_BTCH

INPUT/OUTPUT FILES: B4ATSEQ B4AASEQ B4PTSEQ B4PASEQ

Next Sequence number for ATM TRAN records Next Sequence number for ATM ADMIN records Next Sequence number for POS TRAN records Next Sequence number for POS ADMIN records

ATM_BATCH_DUP_CHK POS_BATCH_DUP_CHK

RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER CZ9000 thru CZ9099

54

CAUSE

Error resulting from call to an I/O (Input/Output) routine.

ACTION

See list of standard I/O errors in Appendix G.



2.3 B4C200 – ATM Mapper

AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ CZ_EXT_TXN_CD_XREF CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_PROD CZ_RESP_CD CZ_SRCE_BU CD_TC_PROC_TXN

STEP05

B4C200nn.UNTXN(+1) B4C200nn.TXNAMT(+1) B4C200nn.TXREF(+1) B4C200nn.TICHG(+1) B4C200nn.GTTXN(+1) B4C200nn.TRMBAL(+1) B4C200nn.TRMBALA(+1) B4C200nn.HPRBLTL(+1) B4C200nn.SUSPTO(+1) B4C200nn.SUSPAO(+1) B4C200nn.SUSPARO(+1) B4C200nn.SUSPAAO(+1)

DATABASE

PARMLIB

B4B00200

B4C20005

ATM Mapper

B4C100nn. ATMBTRN (0)

B4C200nn.ATMTFCT(+1) B4C200nn.ATMTDM1(+1) B4C200nn.ATMTDM2(+1) B4C200nn.ATMTDM3(+1) B4C200nn.ATMTTK1(+1) B4C200nn.ATMTTK2(+1) B4C200nn.ATMTCRD(+1) B4C200nn.ATMTTRM(+1) B4C200nn.ODSATPK(+1) Multiple Output

B4C200nn.ATMAFCT(+1) B4C200nn.ATMABAL(+1) B4C200nn.ATMACSH(+1) B4C200nn.ATMARMS(+1) B4C200nn.ATMACRD(+1) B4C200nn.ATMATRM(+1) B4C200nn.ODSAAPK(+1)

Description: Execute the ATM Mapper. Dependencies:

Must run after B4C100. Restart Instructions:


Restart at the beginning. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

55


STEP05

PROGRAM: B4B00200 - Reads the ATM file, conditionally reads released suspense transactions, determines the partition ids, writes the transactions to the warehouse, normalizes and writes out the transactions for core. INPUT PARAMETERS: COMMIT PARM1IN

COMMIT - Number of transactions to process before a COMMIT B4C20005

INPUT FILES: ATMBTRN

B4C100nn.ATMBTRN(0)

AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ CZ_EXT_TXN_CD_XREF CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_PROD CZ_RESP_CD CZ_SRCE_BU CD_TC_PROC_TXN OUTPUT FILES: UNTXN TXNAMT TXREF TICHG GTTXN 56

B4C200nn.UNTXN(+1) B4C200nn.TXNAMT(+1) B4C200nn.TXREF(+1) B4C200nn.TICHG(+1) B4C200nn.GTTXN(+1) Feb-2007 07.1 BTW03 ACI Worldwide Inc.


TRMBAL TRMBALA HPRBLTL SUSPTO SUSPAO SUSPARO SUSPAAO

B4C200nn.TRMBAL(+1) B4C200nn.TRMBALA(+1) B4C200nn.HPRBLTL(+1) B4C200nn.SUSPTO(+1) B4C200nn.SUSPAO(+1) B4C200nn.SUSPARO(+1) B4C200nn.SUSPAAO(+1)

ATMTFCT ATMTDM1 ATMTDM2 ATMTDM3 ATMTTK1 ATMTTK2 ATMTCRD ATMTTRM ODSATPK

B4C200nn.ATMTFCT(+1) B4C200nn.ATMTDM1(+1) B4C200nn.ATMTDM2(+1) B4C200nn.ATMTDM3(+1) B4C200nn.ATMTTK1(+1) B4C200nn.ATMTTK2(+1) B4C200nn.ATMTCRD(+1) B4C200nn.ATMTTRM(+1) B4C200nn.ODSATPK(+1)

ATMAFCT ATMABAL ATMACSH ATMARMS ATMACRD ATMATRM ODSAAPK

B4C200nn.ATMAFCT(+1) B4C200nn.ATMABAL(+1) B4C200nn.ATMACSH(+1) B4C200nn.ATMARMS(+1) B4C200nn.ATMACRD(+1) B4C200nn.ATMATRM(+1) B4C200nn.ODSAAPK(+1)



CAUSE


ACTION


57


2.4 B4C210 – POS Mapper STEP05 INPUT AM_ACCT AM_TI BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS CD_TC_PROC_TXN CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_EXT_TXN_CD_XREF CZ_PROD CZ_RESP_CD CZ_SRCE_BU

B4C210nn.UNTXN(+1) B4C210nn.TXNAMT(+1) B4C210nn.TXREF(+1) B4C210nn.GTTXN(+1) B4C210nn.TXNSW(+1) B4C210nn.LIDTL(+1) B4C210nn.SUSPTO(+1)

DATABASE

PARMLIB

B4B00200

B4C21005

POS Mapper

B4C100nn. POSBTRN (0)

Multiple Output

B4C210nn.POSTFCT(+1) B4C210nn.POSTDM1(+1) B4C210nn.POSTDM2(+1) B4C210nn.POSTDM3(+1) B4C210nn.POSTTK1(+1) B4C210nn.POSTTK2(+1) B4C210nn.POSTCRD(+1) B4C210nn.POSTTRM(+1) B4C210nn.POSTRET(+1) B4C210nn.ODSPTPK(+1) B4C210nn.POSAFCT(+1) B4C210nn.POSACRK(+1) B4C210nn.POSASER(+1) B4C210nn.POSASET(+1) B4C210nn.POSASPF(+1) B4C210nn.POSARET(+1) B4C210nn.POSATRM(+1) B4C210nn.POSACRD(+1) B4C210nn.ODSPAPK(+1)

Description: Execute the POS Mapper. Dependencies:



Restart at the beginning.

58



STEP05

PROGRAM: B4B00200 - Reads the POS file, conditionally reads released suspense transactions, determines the partition ids, writes the transactions to the warehouse, normalizes and writes out the transactions for core. INPUT PARAMETERS: COMMIT PARM1IN

COMMIT - Number of transactions to process before a COMMIT B4C21005

INPUT FILES: POSBTRN

B4C100nn.POSBTRN(0)

OUTPUT FILES: UNTXN TXNAMT TXREF GTTXN TXNSW LIDTL SUSPTO

B4C210nn.UNTXN(+1) B4C210nn.TXNAMT(+1) B4C210nn.TXREF(+1) B4C210nn.GTTXN(+1) B4C210nn.TXNSW(+1) B4C210nn.LIDTL(+1) B4C210nn.SUSPTO(+1)

POSTFCT POSTDM1 POSTDM2 POSTDM3 POSTTK1 POSTTK2 POSTCRD POSTTRM POSTRET ODSPTPK

B4C210nn.POSTFCT(+1) B4C210nn.POSTDM1(+1) B4C210nn.POSTDM2(+1) B4C210nn.POSTDM3(+1) B4C210nn.POSTTK1(+1) B4C210nn.POSTTK2(+1) B4C210nn.POSTCRD(+1) B4C210nn.POSTTRM(+1) B4C210nn.POSTRET(+1) B4C210nn.ODSPTPK(+1)

POSAFCT POSACRK POSASER POSASET POSASPF POSARET POSATRM POSACRD ODSPAPK

B4C210nn.POSAFCT(+1) B4C210nn.POSACRK(+1) B4C210nn.POSASER(+1) B4C210nn.POSASET(+1) B4C210nn.POSASPF(+1) B4C210nn.POSARET(+1) B4C210nn.POSATRM(+1) B4C210nn.POSACRD(+1) B4C210nn.ODSPAPK(+1)



CAUSE


ACTION


59


2.5 B4C300 – Load Core Files

B4C200nn. UNTXN(0)

STEP05

DSNUPROC Databaseloadutility procedure

OUTPUT CZ_UNPRCD_TXN

B4C210nn. UNTXN(0)

B4C200nn. TXNAMT(0)

STEP10


OUTPUT CZ_PRCD_AMTS

B4C210nn. TXNAMT(0)

B4C200nn. TXNAMT(0)

STEP15


OUTPUT CZ_UNPRCD_AMTS

B4C210nn. TXNAMT(0)

60



B4C200nn. TXREF(0)

STEP20

DSNUPROC Database load utility procedure

OUTPUT CZ_TXND_PID

B4C210nn. TXREF(0)

DSNUPROC B4C210nn. TXNSW(0)

Database load utility procedure

STEP25 OUTPUT CZ_TXN_SWITCH

DSNUPROC B4C210nn.LIDT L(0)


STEP30 OUTPUT CZ_LINE_ITEM_DTLS

DSNUPROC B4C200nn.. TICHG(0)


STEP35 OUTPUT CZ_TI_CHG_TXN

B4C200nn. GTTXN(0)

STEP40


OUTPUT CZ_TXN_GENRC_TOKEN

B4C210nn. GTTXN(0)


61


Description: Load Core transaction files from ATM and POS Mappers. Dependencies:

Must run after B4C200 and B4C210. Restart Instructions:


Restart at the beginning. STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDUTXN INPUT FILES: SYSREC

B4C200nn.UNTXN(0) B4C210nn.UNTXN(0)

OUTPUT FILES: CZ_UNPRCD_TXN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDPAMT INPUT FILES: SYSREC

62

B4C200nn.TXNAMT(0) B4C210nn.TXNAMT(0)



OUTPUT FILES: CZ_PRCD_AMTS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDUAMT INPUT FILES: SYSREC

B4C200nn.TXNAMT(0) B4C210nn.TXNAMT(0)

OUTPUT FILES: CZ_UNPRCD_AMTS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP20

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDTXRF INPUT FILES: SYSREC

B4C200nn.TXREF(0) B4C210nn.TXREF(0)

OUTPUT FILES: CZ_TXND_PID RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP25

PROGRAM: Database Load Utility Feb-2007 07.1 BTW03 ACI Worldwide Inc.

63


INPUT PARAMETERS: SYSIN - CZLDTXSW INPUT FILES: SYSREC

B4C210nn.TXNSW(0)

OUTPUT FILES: CZ_TXN_SWITCH RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP30

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDLIDT INPUT FILES: SYSREC

B4C210nn.LIDTL(0)

OUTPUT FILES: CZ_LINE_ITEM_DTLS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP35

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDTICH INPUT FILES: SYSREC

B4C200nn.TICHG(0)

OUTPUT FILES: CZ_TI_CHG_TXN

64



RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP40

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDGTKN INPUT FILES: SYSREC

B4C200nn.GTTXN(0) B4C210nn.GTTXN(0)

OUTPUT FILES: CZ_TXN_GENRC_TOKEN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


65


2.6 B4C305 – Load Suspense Files

B4C200nn. SUSPTO(0)

STEP05


OUTPUT B4_SUSPENDED_TXN

B4C210nn. SUSPTO(0)

B4C200nn. SUSPAO(0)

STEP10


OUTPUT B4_SUSP_ADMI

B4C210nn. SUSPAO(0)

B4C200nn. SUSPARO(0)

STEP15


OUTPUT B4_SUSP_ADMIN_REC

B4C210nn. SUSPARO(0)

B4C200nn. SUSPAAO(0)

STEP20


OUTPUT B4_SUSP_ADMIN_ADJ

B4C210nn. SUSPAAO(0)

Description: Load Suspense transaction files from ATM and POS Mappers.

66



Dependencies:

Must run after B4C200 and B4C210. Restart Instructions:



STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSTXN INPUT FILES: SYSREC

B4C200nn.SUSPTO(0) B4C210nn.SUSPTO(0)

OUTPUT FILES: B4_SUSPENDED_TXN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSA INPUT FILES: SYSREC

B4C200nn.SUSPAO(0) B4C210nn.SUSPAO(0)

OUTPUT FILES: B4_SUSP_ADMI RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

67


STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSAR INPUT FILES: SYSREC

B4C200nn.SUSPARO(0) B4C210nn.SUSPARO(0)

OUTPUT FILES: B4_SUSP_ADMIN_REC RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP20

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSAA INPUT FILES: SYSREC

B4C200nn.SUSPAAO(0) B4C210nn.SUSPAAO(0)

OUTPUT FILES: B4_SUSP_ADMIN_ADJ RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

68



2.7 B4C310 – Load POS T Fact File STEP05

DSNUPROC B4C210nn. POSTFCT(0)

Databaseloadutility procedure

OUTPUT POS_T_FACT

Description: Load POS warehouse file. Dependencies:




STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTFCT INPUT FILES: SYSREC

B4C210nn.POSTFCT(0)

OUTPUT FILES: POS_T_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


69


2.8 B4C311 – Load POS T Dim1 File STEP05

DSNUPROC B4C210nn. POSTDM1(0)


OUTPUT POS_T_DIM1





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTDM1 INPUT FILES: SYSREC

B4C210nn.POSTDM1(0)

OUTPUT FILES: POS_T_DIM1 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

70



2.9 B4C312 – Load POS T Dim2 File STEP05



OUTPUT POS_T_DIM2





STEP05


B4C210nn.POSTDM2(0)



71


2.10 B4C313 – Load POS T Token1 File STEP05

DSNUPROC B4C210nn. POSTTK1(0)


OUTPUT POS_T_TKN1





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTTK1 INPUT FILES: SYSREC

B4C210nn.POSTTK1(0)

OUTPUT FILES: POS_T_TKN1 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

72



2.11 B4C314 – Load POS T Token2 File STEP05

DSNUPROC B4C210nn. POSTTK2(0)

Databaseloadutility procedure

OUTPUT POS_T_TKN2





STEP05


B4C210nn.POSTTK2(0)



73


2.12 B4C315 – Load ODS POS Tran Dim3 File STEP05



OUTPUT ODS_POS_TRAN_DIM3





STEP05


B4C210nn.POSTDM3(0)

OUTPUT FILES: ODS_POS_TRAN_DIM3 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

74



2.13 B4C316 – Load ODS Card Details File STEP05

DSNUPROC B4C210nn. POSTCRD(0)


OUTPUT ODS_CARD_DETAILS





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDOCRD INPUT FILES: SYSREC

B4C210nn.POSTCRD(0)

OUTPUT FILES: ODS_CARD_DETAILS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


75


2.14 B4C317 – Load ODS POS Terminal File STEP05

DSNUPROC B4C210nn. POSTTRM(0)


OUTPUT ODS_POS_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTTRM INPUT FILES: SYSREC

B4C210nn.POSTTRM(0)

OUTPUT FILES: ODS_POS_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

76



2.15 B4C318 – Load ODS POS Retailer File STEP05

DSNUPROC B4C210nn. POSTRET(0)


OUTPUT ODS_POS_RETAILER





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTRET INPUT FILES: SYSREC

B4C210nn.POSTRET(0)

OUTPUT FILES: ODS_POS_RETAILER RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


77


2.16 B4C319 – Load ODS POST PK File STEP05

DSNUPROC B4C210nn. ODSPTPK(0)


OUTPUT ODS_POST_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTPK INPUT FILES: SYSREC

B4C210nn.ODSPTPK(0)

OUTPUT FILES: ODS_POST_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

78



2.17 B4C330 – Load ATM T Fact File STEP05

DSNUPROC B4C200nn. ATMTFCT(0)


OUTPUT ATM_T_FACT

Description: Load ATM warehouse file. Dependencies:




STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATFCT INPUT FILES: SYSREC

B4C200nn.ATMTFCT(0)

OUTPUT FILES: ATM_T_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


79


2.18 B4C331 – Load ATM T Dim1 File STEP05

DSNUPROC B4C200nn. ATMTDM1(0)


OUTPUT ATM_T_DIM1





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATDM1 INPUT FILES: SYSREC

B4C200nn.ATMTDM1(0)

OUTPUT FILES: ATM_T_DIM1 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

80



2.19 B4C332 – Load ATM T Dim2 File STEP05



OUTPUT ATM_T_DIM2





STEP05


B4C200nn.ATMTDM2(0)



81


2.20 B4C333 – Load ATM T Token1 File STEP05

DSNUPROC B4C200nn. ATMTTK1(0)


OUTPUT ATM_T_TKN1





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATTK1 INPUT FILES: SYSREC

B4C200nn.ATMTTK1(0)

OUTPUT FILES: ATM_T_TKN1 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

82



2.21 B4C334 – Load ATM T Token2 File STEP05

DSNUPROC B4C200nn. ATMTTK2(0)


OUTPUT ATM_T_TKN2





STEP05


B4C200nn.ATMTTK2(0)



83


2.22 B4C335 – Load ODS ATM Tran Dim3 File STEP05



OUTPUT ODS_ATM_TRAN_DIM3





STEP05


B4C200nn.ATMTDM3(0)

OUTPUT FILES: ODS_ATM_TRAN_DIM3 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

84




DSNUPROC B4C200nn. ATMTCRD(0)







STEP05


B4C200nn.ATMTCRD(0)



85


2.24 B4C337 – Load ODS ATM Terminal File STEP05

DSNUPROC B4C200nn. ATMTTRM(0)


OUTPUT ODS_ATM_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATTRM INPUT FILES: SYSREC

B4C200nn.ATMTTRM(0)

OUTPUT FILES: ODS_ATM_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

86



2.25 B4C338 – Load ODS ATMT PK File STEP05

DSNUPROC B4C200nn. ODSATPK(0)


OUTPUT ODS_ATMT_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATPK INPUT FILES: SYSREC

B4C200nn.ODSATPK(0)

OUTPUT FILES: ODS_ATMT_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


87


2.26 B4C350 – Load POS A Fact File STEP05

DSNUPROC B4C210nn. POSAFCT(0)


OUTPUT POS_A_FACT





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPAFCT INPUT FILES: SYSREC

B4C210nn.POSAFCT(0)

OUTPUT FILES: POS_A_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

88



2.27 B4C351 – Load POS A Clrk File STEP05

DSNUPROC B4C210nn. POSACRK(0)


OUTPUT POS_A_CLRK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPACRK INPUT FILES: SYSREC

B4C210nn.POSACRK(0)

OUTPUT FILES: POS_A_CLRK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


89


2.28 B4C352 – Load POS A Ser File STEP05

DSNUPROC B4C210nn. POSASER(0)


OUTPUT POS_A_SER





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPASER INPUT FILES: SYSREC

B4C210nn.POSASER(0)

OUTPUT FILES: POS_A_SER RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

90



2.29 B4C353 – Load POS A Set File STEP05

DSNUPROC B4C210nn. POSASET(0)


OUTPUT POS_A_SET





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPASET INPUT FILES: SYSREC

B4C210nn.POSASET(0)

OUTPUT FILES: POS_A_SET RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


91


2.30 B4C354 – Load POS A SPF File STEP05

DSNUPROC B4C210nn. POSASPF(0)


OUTPUT POS_A_SPF





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPASPF INPUT FILES: SYSREC

B4C210nn.POSASPF(0)

OUTPUT FILES: POS_A_SPF RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

92



2.31 B4C355 – Load ODS PA Retailer File STEP05

DSNUPROC B4C210nn. POSARET(0)


OUTPUT ODS_PA_RETAILER





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPARET INPUT FILES: SYSREC

B4C210nn.POSARET(0)

OUTPUT FILES: ODS_PA_RETAILER RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


93


2.32 B4C356 – Load ODS PA Terminal File STEP05

DSNUPROC B4C210nn. POSATRM(0)


OUTPUT ODS_PA_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPATRM INPUT FILES: SYSREC

B4C210nn.POSATRM(0)

OUTPUT FILES: ODS_PA_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

94




DSNUPROC B4C210nn. POSACRD(0)







STEP05


B4C210nn.POSACRD(0)



95


2.34 B4C358 – Load ODS POSA PK File STEP05

DSNUPROC B4C210nn. ODSPAPK(0)


OUTPUT ODS_POSA_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPAPK INPUT FILES: SYSREC

B4C210nn.ODSPAPK(0)

OUTPUT FILES: ODS_POSA_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

96



2.35 B4C370 – Load ATM A Fact File STEP05

DSNUPROC B4C200nn. ATMAFCT(0)


OUTPUT ATM_A_FACT





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAAFCT INPUT FILES: SYSREC

B4C200nn.ATMAFCT(0)

OUTPUT FILES: ATM_A_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


97


2.36 B4C371 – Load ATM A Terminal Balance File STEP05

DSNUPROC B4C200nn. ATMABAL(0)


OUTPUT ATM_A_TRMBL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAABAL INPUT FILES: SYSREC

B4C200nn.ATMABAL(0)

OUTPUT FILES: ATM_A_TRMBL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

98



2.37 B4C372 – Load ATM ATRMCSH File STEP05

DSNUPROC B4C200nn. ATMACSH(0)


OUTPUT ATM_ATRMCSH





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAACSH INPUT FILES: SYSREC

B4C200nn.ATMACSH(0)

OUTPUT FILES: ATM_ATRMCSH RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


99


2.38 B4C373 – Load ATM TRMS File STEP05

DSNUPROC B4C200nn. ATMARMS(0)


OUTPUT ATM_A_TRMS





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAARMS INPUT FILES: SYSREC

B4C200nn.ATMARMS(0)

OUTPUT FILES: ATM_A_TRMS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

100



2.39 B4C374 – Load Card Details File STEP05

DSNUPROC B4C200nn. ATMACRD(0)







STEP05


B4C200nn.ATMACRD(0)



101


2.40 B4C375 – Load ODS AA Terminal File STEP05

DSNUPROC B4C200nn. ATMATRM(0)


OUTPUT ODS_AA_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAATRM INPUT FILES: SYSREC

B4C200nn.ATMATRM(0)

OUTPUT FILES: ODS_AA_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

102



2.41 B4C376 – Load ODS ATMA PK File STEP05

DSNUPROC B4C200nn. ODSAAPK(0)


OUTPUT ODS_ATMA_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LAAPK INPUT FILES: SYSREC

B4C200nn.ODSAAPK(0)

OUTPUT FILES: ODS_ATMA_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


103


2.42 B4C390 – Load ATM Terminal Files

DSNUPROC B4C200nn. TRMBALA(0)


STEP05 OUTPUT SZ_TERM_BAL_ADMIN

DSNUPROC B4C200nn. TRMBAL(0)


STEP10 OUTPUT SZ_TERM_BAL

DSNUPROC B4C200nn. HPRBLTL(0)


STEP15 OUTPUT SZ_HOPR_BAL_TTL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSTBLA INPUT FILES: SYSREC

104

B4C200nn.TRMBALA(0)



OUTPUT FILES: SZ_TERM_BAL_ADMIN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSTBL INPUT FILES: SYSREC

B4C200nn.TRMBAL(0)

OUTPUT FILES: SZ_TERM_BAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSHBLT INPUT FILES: SYSREC

B4C200nn.HPRBLTL(0)

OUTPUT FILES: SZ_HOPR_BAL_TTL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


105


2.43 B4D200 – ATM Backout and Suspense Processing STEP05

PARMLIB B4D20005

CZB00999 DynamicSQL Executer

INPUT/OUTPUT CZ_TXN_BO

ATM Sequence File STEP10 INPUT CZ_TXN_BO

B4B00150 ATMBackout Processing

B4D200. ATMBTRN (+1)

PARMLIB B4D20010 STEP15

PARMLIB B4D20015



STEP20

PARMLIB B4D20020

106


INPUT/OUTPUT B4_SUSPENDED_TXNS B4_SUSP_ADMIN



STEP25 Input AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ

Input (contnued) CZ_EXT_TXN_CD_XREF CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_PROD CZ_RESP_CD CZ_SRCE_BU CD_TC_PROC_TXN

DATABASE

PARMLIB

B4B00200

B4D20025

ATM Mapper

Multiple Output

B4D200.UNTXN(+1) B4D200.TXNAMT(+1) B4D200.TXREF(+1) B4D200.TICHG(+1) B4D200.GTTXN(+1) B4D200.TRMBAL(+1) B4D200.TRMBALA(+1) B4D200.HPRBLTL(+1) B4D200.SUSPTO(+1) B4D200.SUSPAO(+1) B4D200.SUSPARO(+1) B4D200.SUSPAAO(+1) B4D200.ATMTFCT(+1) B4D200.ATMTDM1(+1) B4D200.ATMTDM2(+1) B4D200.ATMTDM3(+1) B4D200.ATMTTK1(+1) B4D200.ATMTTK2(+1) B4D200.ATMTCRD(+1) B4D200.ATMTTRM(+1) B4D200.ODSATPK(+1)

B4D200. ATMBTRN (+1)

STEP30

PARMLIB B4D20030


CZB00999 Dynamic SQL Executer

INPUT/OUTPUT B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ

107


Description: Process ATM backout and suspense transactions. Dependencies:

Must run after cycle processing. Restart Instructions:



PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to update the release code on the CZ_TXN_BO table. INPUT PARAMETERS: COMMIT PARM1IN

COMMIT - Number of transactions to process before a COMMIT B4D20005

Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: CZ_TXN_BO OUTPUT FILES: CZ_TXN_BO


CAUSE


ACTION


STEP10

PROGRAM: B4B00150 – Create ATM batch file for ATM backout transactions. INPUT PARAMETERS: COMMIT PARM1IN 108

COMMIT - Number of transactions to process before a COMMIT B4D20010 Feb-2007 07.1 BTW03 ACI Worldwide Inc.


INPUT FILES: CZ_TXN_BO B4ATSEQ

B4ATSEQ

OUTPUT FILES: ATMBTRN

B4D200.ATMBTRN(+1)


CAUSE


ACTION


STEP15





CAUSE


ACTION


STEP20

PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to update the release code on the B4_SUSPENDED_TXNS and B4_SUSP_ADMIN tables.


109


INPUT PARAMETERS: COMMIT PARM1IN


Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: B4_SUSPENDED_TXNS B4_SUSP_ADMIN OUTPUT FILES: B4_SUSPENDED_TXNS B4_SUSP_ADMIN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER CZ9000 thru CZ9099

CAUSE


ACTION


STEP25

PROGRAM: B4B00200 - Reads the ATM file, conditionally reads released suspense transactions, determines the partition ids, writes the transactions to the warehouse, normalizes and writes out the transactions for core. INPUT PARAMETERS: COMMIT PARM1IN


INPUT FILES: ATMBTRN

B4D200.ATMBTRN(+1)

AA_ACCT_TYP AM_ACCT AM_TI AM_TI_ACS_TO_ACCTS BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS B4_SUSP_ADMIN 110



B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ CZ_EXT_TXN_CD_XREF CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_PROD CZ_RESP_CD CZ_SRCE_BU CD_TC_PROC_TXN OUTPUT FILES: UNTXN TXNAMT TXREF TICHG GTTXN TRMBAL TRMBALA HPRBLTL SUSPTO SUSPAO SUSPARO SUSPAAO

B4D200.UNTXN(+1) B4D200.TXNAMT(+1) B4D200.TXREF(+1) B4D200.TICHG(+1) B4D200.GTTXN(+1) B4D200.TRMBAL(+1) B4D200.TRMBALA(+1) B4D200.HPRBLTL(+1) B4D200.SUSPTO(+1) B4D200.SUSPAO(+1) B4D200.SUSPARO(+1) B4D200.SUSPAAO(+1)

ATMTFCT B4D200.ATMTFCT(+1) ATMTDM1 B4D200.ATMTDM1(+1) B4D200.ATMTDM1(+1) ATMTDM2 B4D200.ATMTDM2(+1) B4D200.ATMTDM2(+1) ATMTDM3 B4D200.ATMTDM3(+1) B4D200.ATMTDM3(+1) ATMTTK1 B4D200.ATMTTK1(+1) ATMTTK2 B4D200.ATMTTK2(+1) ATMTCRD B4D200.ATMTCRD(+1) ATMTTRM B4D200.ATMTTRM(+1) ODSATPK B4D200.ODSATPK(+1)


CAUSE


ACTION


STEP30

PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to delete processed transactions on the B4_SUSPENDED_TXNS table. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

111




Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ

OUTPUT FILES: B4_SUSPENDED_TXNS B4_SUSP_ADMIN B4_SUSP_ADMIN_REC B4_SUSP_ADMIN_ADJ


112

CAUSE


ACTION




2.44 B4D210 – POS Backout and Suspense Suspens e Processing STEP05

PARMLIB B4D21005



POS Sequence File STEP10 INPUT CZ_TXN_BO

B4B00150 POS Backout Processing

B4D210. POSBTRN (+1)

PARMLIB B4D21010 STEP15

PARMLIB B4D21015



STEP20

PARMLIB B4D21020




113


STEP25

Input (contnued) CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_EXT_TXN_CD_XREF CZ_PROD CZ_RESP_CD CZ_SRCE_BU

Input AM_ACCT AM_TI BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM B4_SUSPENDED_TXNS CD_TC_PROC_TXN CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS

B4D210.UNTXN(+1) B4D210.TXNAMT(+1) B4D210.TXREF(+1) B4D210.GTTXN(+1) B4D210.TXNSW(+1) B4D210.LIDTL(+1) B4D210.SUSPTO(+1)

DATABASE

PARMLIB

B4B00200

B4D21025

POS Mapper

B4D210. POSBTRN (+1)

Multiple Output

B4D210.POSTFCT(+1) B4D210.POSTDM1(+1) B4D210.POSTDM2(+1) B4D210.POSTDM3(+1) B4D210.POSTTK1(+1) B4D210.POSTTK2(+1) B4D210.POSTCRD(+1) B4D210.POSTTRM(+1) B4D210.POSTRET(+1) B4D210.ODSPTPK(+1)

STEP30

PARMLIB B4D21030

114





Description: Process POS backout and suspense transactions. Dependencies:

Must run after cycle processing. Restart Instructions:





Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: CZ_TXN_BO

OUTPUT FILES: CZ_TXN_BO


CAUSE


ACTION


STEP10

PROGRAM: B4B00150 – Create POS batch file for POS backout transactions.


115




INPUT FILES: CZ_TXN_BO B4PTSEQ

B4PTSEQ

OUTPUT FILES: POSBTRN

B4D210.POSBTRN(+1)


CAUSE


ACTION


STEP15





116

CAUSE


ACTION




STEP20

PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to update the release code on the B4_SUSPENDED_TXNS table. INPUT PARAMETERS: COMMIT PARM1IN


Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: B4_SUSPENDED_TXNS OUTPUT FILES: B4_SUSPENDED_TXNS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER CZ9000 thru CZ9099

CAUSE


ACTION


STEP25

PROGRAM: B4B00200 - Reads the POS file, conditionally reads released suspense transactions, determines the partition ids, writes the transactions to the warehouse, normalizes and writes out the transactions for core. INPUT PARAMETERS: COMMIT PARM1IN


INPUT FILES: POSBTRN

B4D210.POSBTRN(+1)

AM_ACCT AM_TI BS_PARTITION_GROUP BS_PARTMDATA B4_CARD_ACCEPTOR B4_FIID B4_LN B4_REG_GRP_BRCH B4_TERM Feb-2007 07.1 BTW03 ACI Worldwide Inc.

117


B4_SUSPENDED_TXNS CD_TC_PROC_TXN CZ_BIN CZ_BIN_BIN_RNG CZ_BIN_ISS CZ_BUS_UNIT CZ_BU_TYP CZ_CRD_TYP_CONV CZ_CRNCY_CD CZ_CRNCY_RATE CZ_DRCT_CRNCY_RT CZ_EXT_TXN_CD_XREF CZ_PROD CZ_RESP_CD CZ_SRCE_BU

OUTPUT FILES: UNTXN TXNAMT TXREF GTTXN TXNSW LIDTL SUSPTO

B4D210.UNTXN(+1) B4D210.TXNAMT(+1) B4D210.TXREF(+1) B4D210.GTTXN(+1) B4D210.TXNSW(+1) B4D210.LIDTL(+1) B4D210.SUSPTO(+1)

POSTFCT POSTDM1 POSTDM2 POSTDM3 POSTTK1 POSTTK2 POSTCRD POSTTRM POSTRET ODSPTPK

B4D210.POSTFCT(+1) B4D210.POSTDM1(+1) B4D210.POSTDM2(+1) B4D210.POSTDM3(+1) B4D210.POSTTK1(+1) B4D210.POSTTK2(+1) B4D210.POSTCRD(+1) B4D210.POSTTRM(+1) B4D210.POSTRET(+1) B4D210.ODSPTPK(+1)


CAUSE


ACTION


STEP30

PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to delete processed transactions on the B4_SUSPENDED_TXNS table.

118





Note: Parm member has a 2,000-character limit for total of SQL statements. INPUT FILES: B4_SUSPENDED_TXNS OUTPUT FILES: B4_SUSPENDED_TXNS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER CZ9000 thru CZ9099


CAUSE


ACTION


119


2.45 B4D300 – Load Core Files for Backout/Suspense

B4D200. UNTXN(0)

STEP05


OUTPUT CZ_UNPRCD_TXN

B4D210. UNTXN(0)

B4D200. TXNAMT(0)

STEP10


OUTPUT CZ_PRCD_AMTS

B4D210. TXNAMT(0)

B4D200. TXNAMT(0)

STEP15


OUTPUT CZ_UNPRCD_AMTS

B4D210. TXNAMT(0)

120



B4D200. TXREF(0)

STEP20


OUTPUT CZ_TXND_PID

B4D210. TXREF(0)

B4D210. TXNSW(0)

STEP25


OUTPUT CZ_TXN_SWITCH

STEP30

DSNUPROC B4D210.LIDTL( 0)


OUTPUT CZ_LINE_ITEM_DTLS

STEP35

DSNUPROC B4D200..TICHG (0)


OUTPUT CZ_TI_CHG_TXN

B4D200. GTTXN(0)

STEP40


OUTPUT CZ_TXN_GENRC_TOKEN

B4D210. GTTXN(0)


121


Description: Load Core transaction files from ATM and POS Mappers. Dependencies:

Must run after B4D200 and B4D210. Restart Instructions:



STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDUTXN INPUT FILES: SYSREC

B4D200.UNTXN(0) B4D210.UNTXN(0)

OUTPUT FILES: CZ_UNPRCD_TXN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDPAMT INPUT FILES: SYSREC

122

B4D200.TXNAMT(0) B4D210.TXNAMT(0)



OUTPUT FILES: CZ_PRCD_AMTS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDUAMT INPUT FILES: SYSREC

B4D200.TXNAMT(0) B4D210.TXNAMT(0)

OUTPUT FILES: CZ_UNPRCD_AMTS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP20

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDTXRF INPUT FILES: SYSREC

B4D200.TXREF(0) B4D210.TXREF(0)

OUTPUT FILES: CZ_TXND_PID RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP25

PROGRAM: Database Load Utility Feb-2007 07.1 BTW03 ACI Worldwide Inc.

123


INPUT PARAMETERS: SYSIN - CZLDTXSW INPUT FILES: SYSREC

B4D210.TXNSW(0)

OUTPUT FILES: CZ_TXN_SWITCH RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP30

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDLIDT INPUT FILES: SYSREC

B4D210.LIDTL(0)

OUTPUT FILES: CZ_LINE_ITEM_DTLS RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP35

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDTICH INPUT FILES: SYSREC

B4D200.TICHG(0)

OUTPUT FILES: CZ_TI_CHG_TXN

124



RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

STEP40

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - CZLDGTKN INPUT FILES: SYSREC

B4D200.GTTXN(0) B4D210.GTTXN(0)

OUTPUT FILES: CZ_TXN_GENRC_TOKEN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


125


2.46 B4D305 – Load Suspense Files for Backout/Suspense

B4D200. SUSPTO(0)

STEP05


OUTPUT B4_SUSPENDED_TXN

B4D210. SUSPTO(0)

B4D200. SUSPAO(0)

STEP10


OUTPUT B4_SUSP_ADMI

B4D210. SUSPAO(0)

B4D200. SUSPARO(0)

STEP15


OUTPUT B4_SUSP_ADMIN_REC

B4D210. SUSPARO(0)

B4D200. SUSPAAO(0)

STEP20


OUTPUT B4_SUSP_ADMIN_ADJ

B4D210. SUSPAAO(0)

Description: Load Suspense transaction files from ATM and POS Mappers.

126



Dependencies:

Must run after B4D200 and B4D210. Restart Instructions:



STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSTXN INPUT FILES: SYSREC

B4D200.SUSPTO(0) B4D210.SUSPTO(0)

OUTPUT FILES: B4_SUSPENDED_TXN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSA INPUT FILES: SYSREC

B4D200.SUSPAO(0) B4D210.SUSPAO(0)

OUTPUT FILES: B4_SUSP_ADMI RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. Feb-2007 07.1 BTW03 ACI Worldwide Inc.

127


STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSAR INPUT FILES: SYSREC

B4D200.SUSPARO(0) B4D210.SUSPARO(0)

OUTPUT FILES: B4_SUSP_ADMIN_REC RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP20

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LDSAA INPUT FILES: SYSREC

B4D200.SUSPAAO(0) B4D210.SUSPAAO(0)

OUTPUT FILES: B4_SUSP_ADMIN_ADJ RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

128



2.47 B4D310 – Load POS T Fact File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTFCT(0)


OUTPUT POS_T_FACT


Must run after B4D210. Restart Instructions:



STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTFCT INPUT FILES: SYSREC

B4D210.POSTFCT(0)

OUTPUT FILES: POS_T_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


129


2.48 B4D311 – Load POS T Dim1 File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTDM1(0)


OUTPUT POS_T_DIM1





STEP05


B4D210.POSTDM1(0)


130



2.49 B4D312 – Load POS T Dim2 File for Backout/Suspense STEP05



OUTPUT POS_T_DIM2





STEP05


B4D210.POSTDM2(0)



131


2.50 B4D313 – Load POS T Token1 File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTTK1(0)


OUTPUT POS_T_TKN1





STEP05


B4D210.POSTTK1(0)


132



2.51 B4D314 – Load POS T Token2 File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTTK2(0)


OUTPUT POS_T_TKN2





STEP05


B4D210.POSTTK2(0)



133


2.52 B4D315 – Load ODS POS Tran Dim3 File for Backout/Suspense STEP05



OUTPUT ODS_POS_TRAN_DIM3





STEP05


B4D210.POSTDM3(0)

OUTPUT FILES: ODS_POS_TRAN_DIM3 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

134



2.53 B4D316 – Load ODS Card Details File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTCRD(0)







STEP05


B4D210.POSTCRD(0)



135


2.54 B4D317 – Load ODS POS Terminal File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTTRM(0)


OUTPUT ODS_POS_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTTRM INPUT FILES: SYSREC

B4D210.POSTTRM(0)

OUTPUT FILES: ODS_POS_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

136



2.55 B4D318 – Load ODS POS Retailer File for Backout/Suspense STEP05

DSNUPROC B4D210. POSTRET(0)


OUTPUT ODS_POS_RETAILER





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTRET INPUT FILES: SYSREC

B4D210.POSTRET(0)

OUTPUT FILES: ODS_POS_RETAILER RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


137


2.56 B4D319 – Load ODS POST PK File for Backout/Suspense STEP05

DSNUPROC B4D210. ODSPTPK(0)


OUTPUT ODS_POST_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LPTPK INPUT FILES: SYSREC

B4D210.ODSPTPK(0)

OUTPUT FILES: ODS_POST_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

138



2.57 B4D330 – Load ATM T Fact File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTFCT(0)


OUTPUT ATM_T_FACT





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATFCT INPUT FILES: SYSREC

B4D200.ATMTFCT(0)

OUTPUT FILES: ATM_T_FACT RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


139


2.58 B4D331 – Load ATM T Dim1 File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTDM1(0)


OUTPUT ATM_T_DIM1





STEP05


B4D200.ATMTDM1(0)


140



2.59 B4D332 – Load ATM T Dim2 File for Backout/Suspense STEP05



OUTPUT ATM_T_DIM2





STEP05


B4D200.ATMTDM2(0)



141


2.60 B4D333 – Load ATM T Token1 File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTTK1(0)


OUTPUT ATM_T_TKN1





STEP05


B4D200.ATMTTK1(0)


142



2.61 B4D334 – Load ATM T Token2 File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTTK2(0)


OUTPUT ATM_T_TKN2





STEP05


B4D200.ATMTTK2(0)



143


2.62 B4D335 – Load ODS ATM Tran Dim3 File for Backout/Suspense STEP05



OUTPUT ODS_ATM_TRAN_DIM3





STEP05


B4D200.ATMTDM3(0)

OUTPUT FILES: ODS_ATM_TRAN_DIM3 RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

144



2.63 B4D336 – Load ODS Card Details File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTCRD(0)







STEP05


B4D200.ATMTCRD(0)



145


2.64 B4D337 – Load ODS ATM Terminal File for Backout/Suspense STEP05

DSNUPROC B4D200. ATMTTRM(0)


OUTPUT ODS_ATM_TERMINAL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATTRM INPUT FILES: SYSREC

B4D200.ATMTTRM(0)

OUTPUT FILES: ODS_ATM_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

146



2.65 B4D338 – Load ODS ATMT PK File for Backout/Suspense STEP05

DSNUPROC B4D200. ODSATPK(0)


OUTPUT ODS_ATMT_PK





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LATPK INPUT FILES: SYSREC

B4D200.ODSATPK(0)

OUTPUT FILES: ODS_ATMT_PK RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


147


2.66 B4D390 – Load ATM Terminal Files

DSNUPROC B4D200. TRMBALA(0)


STEP05 OUTPUT SZ_TERM_BAL_ADMIN

DSNUPROC B4D200. TRMBAL(0)


STEP10 OUTPUT SZ_TERM_BAL

DSNUPROC B4D200. HPRBLTL(0)


STEP15 OUTPUT SZ_HOPR_BAL_TTL





STEP05

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSTBLA INPUT FILES: SYSREC

148

B4D200.TRMBALA(0)



OUTPUT FILES: SZ_TERM_BAL_ADMIN RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility. STEP10

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSTBL INPUT FILES: SYSREC

B4D200.TRMBAL(0)

OUTPUT FILES: SZ_TERM_BAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.

STEP15

PROGRAM: Database Load Utility INPUT PARAMETERS: SYSIN - B4LSHBLT INPUT FILES: SYSREC

B4D200.HPRBLTL(0)

OUTPUT FILES: SZ_HOPR_BAL_TTL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: Reference the Messages and Codes manual for the DB2 database load utility.


149


2.67 B4D400 – ODS Processing

Parameters B4D40005 B4LODSPT B4LODSPA B4LODSAT B4LODSAA

B4B00400 ODS Processing

Input/Output ATM_T_FACT ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TERMINAL ATM_TRAN_DIM3 CARD_DETAILS POS_T_FACT ODS_POST_PK ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 POS_RETAILER POS_TERMINAL POS_TRAN_DIM3 ATM_A_FACT ODS_ATMA_PK ODS_AA_TERMINAL POS_A_FACT ODS_POSA_PK ODS_PA_RETAILER ODS_PA_TERMINAL

STEP05

Description:

Perform Transaction Warehouse ODS Processing. Dependencies:

Run after all B4D300 jobs have completed.

Restart Instructions:

STEP05 - Restart from the beginning. Rerun Instructions:

Rerun from the step that stopped.

150



STEP05

PROGRAM: B4B00400 INPUT PARAMETERS: COMMIT PARM1IN SQLIN

COMMIT - Number of transactions to process before a COMMIT B4D40005 B4LODSPT B4LODSPA B4LODSAT B4LODSAA

INPUT FILES:

OUTPUT FILES: INPUT/OUTPUT FILES: ATM_T_FACT ODS_ATMT_PK ODS_ATM_TERMINAL ODS_ATM_TRAN_DIM3 ODS_CARD_DETAILS ATM_TERMINAL ATM_TRAN_DIM3 CARD_DETAILS POS_T_FACT ODS_POST_PK ODS_POS_RETAILER ODS_POS_TERMINAL ODS_POS_TRAN_DIM3 POS_RETAILER POS_TERMINAL POS_TRAN_DIM3 ATM_A_FACT ODS_ATMA_PK ODS_AA_TERMINAL POS_A_FACT ODS_POSA_PK ODS_PA_RETAILER ODS_PA_TERMINAL RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER CZ9000 thru CZ9099


CAUSE


ACTION


151


2.68 B4D500 – Warehouse Summary Update

PARMLIB B4D50005


INPUT/OUTPUT CZ_BUS_UNIT WHSE_SUM ATM_T_FACT ATM_TF_FD_WD POS_T_FACT POS_TF_FD_WD POS_A_FACT POS_AF_FD_WD VISA_DRAFT VISA_MONEY VISA_NOMON IPM_ADMIN IPM_MONETARY IPM_RECON

STEP05

Output WHSE_SUM

Description: Update Warehouse Summary tables. Dependencies:




152



STEP05

PROGRAM: CZB00999 – Dynamic SQL Executer – used to execute SQL to update the warehouse summary tables. INPUT PARAMETERS: COMMIT PARM1IN


Note: Parm member has a 2,000-character limit for total o f SQL statements.

INPUT FILES: CZ_BUS_UNIT WHSE_SUM ATM_T_FACT ATM_TF_FD_WD POS_T_FACT POS_TF_FD_WD POS_A_FACT POS_AF_FD_WD VISA_DRAFT VISA_MONEY VISA_NOMON IPM_ADMIN IPM_MONETARY IPM_RECON OUTPUT FILES: WHSE_SUM



CAUSE


ACTION


153


APPENDIX A MapperLoader Return Codes / PRCS_LOG rtrn_code RETURN CODES AND ACTIONS CONCERNING THOSE CODES: MESSAGE NUMBER

154

1

CAUSE Cannot find table in dbinfo map

2

Date Parse Exception

3

Not specifically handled

4

File Date cannot be null or spaces

5

Partition Group not found

6

Partition ID not found

7

Cannot create delete SQL

8

NumberFormatException setting variable

9

Cannot create update SQL

10

NumberFormatException in where column

11

New row not allowed

12

Column not found

13

EA_BIN_DTL_KEY cannot be found

14

EA_DATE number format exception

15

EA_TERM_DTL row added

ACTION Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. EA BIN not defined. Define before next cycle. See RTRN_MSG in PRCS_LOG for values searched for. Call programmer / check PRCS_LOG for further information. Informational, no response required. Add terminal to terminal grouping if desired.



MESSAGE NUMBER 16

CAUSE EA_TC_DTL row added

17

EA_RC_DTL row added

50

EA file already exists

51

EA cannot move file

52

EA Directory missing

53

EA LN column not in Foreign Terminal Table

54

EA FIID column not in Foreign Terminal Table

55

Restore EA multiple date error

56

EA field not found

60

Error writing to tlfadminmapperqueue

71

Error writing to tlfmapperqueue

72

Error writing to ptlfmapperqueue

73

Parser get field start error

74

Parser set synonym error

75

Header token eye catcher not found

76

Token eye catcher not found

100

Properties File location not specified

101

IO Error reading Properties File

102

Properties File not found

103

Properties File name not set

104

Properties File fields missing


ACTION Informational, no response required. Add tran code to tran code grouping if desired. Informational, no response required. Add return code to return code grouping if desired. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check PRCS_LOG for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information.

155


156

MESSAGE NUMBER 105

CAUSE Properties File incorrect values

106

Properties File incorrect values

107

Invalid date argument

108

Zbatch invalid combination

200

java.lang.Exception thrown

201

java.lang.ClassNotFoundException thrown

202

java.io.IOException thrown

203 204

java.lang.reflect.InvocationTargetException thrown java.io.FileNotFoundException thrown

205

java.net.UnknownHostException thrown

All SQL return codes (see database vendor documentation)

See database vendor documentation

ACTION Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Call programmer / check sysout for further information. Check PRCS_LOG and/or sysout file for database vendor message. Consult database vendor documentation for further information.



APPENDIX B Cleaning Up for a Rerun or Error (trace tables and exception tables) There are three trace tables each for each piece of each product - a “proc”, a “del”, and an “err”. These tables each contain a single field that maps back to the key field of the “raw data” table. The key fields are named the same in the trace as the raw table. The “proc” table contains the "transactions I have to process", the “del” table contains the "transactions I have processed successfully", and the “err” table contains the "transactions I was unable to process successfully". There are three kinds of tables that are populated when an error occurs. These are the aforementioned “err” trace table, the “raw exception” table, and the “processing log” table. The “processing log” table will always be PRCS_LOG; the others will vary depending on which piece of the application you are resetting. Resetting these tables for a rerun or error is a manual process. Here is the process for a given key (“key value”). If there are more keys, the WHERE clauses would need to reflect that. If all the keys in a table were to be moved, some of the WHERE clauses would not be needed << refer to Appendix B.xls for the values of “proc”, del”, “raw name” etc. >> 1.

Verify that the transactions are still in the Raw Data table.

SELECT * FROM “raw name” WHERE “key field” = “key value” If the key is not in the raw table but is an error, it can be moved from the “raw exception” table. This allows you to skip the insert into the “proc” ( step 2), because the database trigger should repopulate the “proc” table. INSERT INTO “raw name” (“key field”, PARTITION_ID, PROCESSOR_ID, FILE_DATE, TRHA, FILE_ID, FILE_LN, “tlf or ptlf field”) (SELECT “key field”, PARTITION_ID, PROCESSOR_ID, FILE_DATE, TRHA, FILE_ID, FILE_LN, “tlf or ptlf field” FROM “raw exception” WHERE “key field” = “key value” AND LM_NAME = “raw lm name”) If the key is not in the raw table, the entire day will have to be reloaded and the existing version of the day deleted from the warehouse/other products.

2.

Insert the transactions back into the “proc” from “del” and/or “err”.

INSERT INTO “proc“ (SELECT * FROM “del” WHERE “key field” = “key value”) INSERT INTO “proc” (SELECT * FROM “err” WHERE “key field” = “key value”) 3.

Delete the transactions from “del” and/or “err”.

DELETE FROM “del” WHERE “key field” = “key value” DELETE FROM “err” WHERE “key field” = “key value” 4.

Delete the transactions from the Raw exception table.

DELETE FROM “raw exception” WHERE “key field” = “key value” AND LM_NAME = ‘“raw lm name”’


157


5.

Delete the transactions from the processing log.

DELETE FROM PRCS_LOG WHERE SCRP_NAME LIKE ‘“scrp name”%”key field”: ”key value” %‘

Example: To do a complete rerun for job B40110 with a “key value” of 1. “key field” = “raw name” = “proc” = “del” = “err” = “raw exception” = “raw lm name” = “scrp name” =

ATM_TRAN_ID_KEY ATM_TRAN_RAW00 WHSE_ATTRC_PROC WHSE_ATTRC_DEL WHSE_ATTRC_ERR ATM_TRAN_RAW_EXCP TW Tran Warehouse – ATM Tran TW

Step 1

SELECT * FROM ATM_TRAN_RAW00 WHERE ATM_TRAN_ID_KEY = 1 Step 2

INSERT INTO WHSE_ATTRC_PROC (SELECT * FROM WHSE_ATTRC_DEL WHERE ATM_TRAN_ID_KEY = 1) INSERT INTO WHSE_ATTRC_PROC (SELECT * FROM WHSE_ATTRC_ERR WHERE ATM_TRAN_ID_KEY = 1) Step 3

DELETE FROM WHSE_ATTRC_DEL WHERE ATM_TRAN_ID_KEY = 1 DELETE FROM WHSE_ATTRC_ERR WHERE ATM_TRAN_ID_KEY = 1 Step 4

DELETE FROM ATM_TRAN_RAW_EXCP WHERE ATM_TRAN_ID_KEY = 1 AND LM_NAME = ‘TW’ Step 5

DELETE FROM PRCS_LOG WHERE SCRP_NAME LIKE ‘Tran Warehouse – ATM Tran TW%ATM_TRAN_ID_KEY: 1 %‘

Specific to B40110 Delete from the additional tables that B40110 specifies (ATM_T_TKN1, ATM_T_TKN2, ATM_T_DIM1, ATM_T_DIM2, ATM_T_FACT) where ATM_TRAN_ID_KEY = 1

158



APPENDIX C Starting the Mapper Loader Interactively for Real Time Processing The Mapper Loaders can be started in an interactive manner that allows them to constantly check for new transactions in the raw/trace tables and process them. This allows for constant processing as data comes in. The tables affected are the same that are used for the batch process. This interactive process consists of a “ThreadServer” and a “ThreadClient”. The ThreadServer contains the actual mapping and loading processes that take place against the database. The ThreadClient is a way to interact with the ThreadServer and start/stop those processes. The ThreadServer and ThreadClient communicate through a port (specified in the PORTNUM property in the Properties File). Only one instance of ThreadServer and one instance of ThreadClient can run at a time for that port.

THREADSERVER COMMANDS: Starting the ThreadServer

Executing the appropriate startserver script (twstartserver, smstartserver, etc.) in UNIX will execute the java ThreadServer program in the background using nohup. There is one argument to this script. It is the name of an output file to redirect the output to. Example (the 042203 is a d ate): /home/tsomgaa > twstartserver tw042203.log

THREADCLIENT COMMANDS:

The valid commands that can be entered from ThreadClient will vary depending on the maximum number of threads and whether or not there are admin threads. Starting the ThreadClient

Executing the appropriate startclient script (twstartclient, smstartclient, etc.) in UNIX will execute the java ThreadClient program. As the ThreadClient initializes, the Properties File contents are displayed to the user. Once the ThreadClient is completely running, you will be requested to enter commands. Commands are case insensitive.

Menu of Possible Commands

A list of valid commands will be displayed when the user enters an invalid command. Example: (the line in bold italics is what the user enters; the rest are displays from the program) Server: PLEASE ENTER COMMAND: not a command

Client: not a command Server: Invalid Command, valid commands are: Start ATM Admin TW 0,


159


Stop ATM Admin TW 0, Start ATM Tran TW 0, Stop ATM Tran TW 0, Start ATM Tran TW 1, Stop ATM Tran TW 1, Start ATM Tran TW 2, Stop ATM Tran TW 2, Start ATM Tran TW 3, Stop ATM Tran TW 3, Start POS Admin TW 0, Stop POS Admin TW 0, Start POS Tran TW 0, Stop POS Tran TW 0, Start POS Tran TW 1, Stop POS Tran TW 1, Start POS Tran TW 2, Stop POS Tran TW 2, Start POS Tran TW 3, Stop POS Tran TW 3, Start ATM Admin All, Start ATM Tran All, Start POS Admin All, Start POS Tran All, Stop ATM Admin All, Stop ATM Tran All, Stop POS Admin All, Stop POS Tran All, Show Running Threads, ATM Tran Messages On, POS Tran Messages On, ATM Tran Messages Off, POS Tran Messages Off, Quit, Quit All

Start

– starts the thread specified by . Example: ATM Tran TW 0. Stop – stops the thread specified by . Start All – starts all threads for . In the example shown above, “Start ATM Tran All” would issue a Start command for ATM Tran TW 0, ATM Tran TW 1, ATM Tran TW 2, and ATM Tran TW 3. Stop < thread type> All – stops all threads for . Show Running Threads – displays every thread name that is currently running. Messages On – turns on prints of additional statistical messages to the output. Messages Off – turns off prints of additional statistical messages to the output (default). Quit – stops the ThreadClient process. The ThreadServer continues to check for and load transactions and can be accessed later through another ThreadClient execution. Quit All – stops the ThreadClient process and the ThreadServer process. Transactions will not be loaded until another ThreadServer is started and individual threads are started using the Start commands of the ThreadClient.

160



APPENDIX D Continual Batch Loading from -es – Automapper In order to satisfy a continual 15 minute load requirement from ES, a new script was created called “automapper”. This is a UNIX loop script that checks for new ES files, runs the same program as the B40000 JCL, and then renames the files based on return code (.processed or .error). Stopping and pausing this script uses the same UNIX key combinations that apply to other scripts. If the process is running in an open telnet session, Control C will end/kill the process, Control Z will pause the script execution, and bg and fg commands can be used to move it from the bg to the fg. If the process is not running in an open telnet session, then terminating the script can be done by finding the process id (using a command such as ps –eaf | grep automapper) and doing a kill command on it.


161


APPENDIX E Job – Database Cross Reference

Job Name B40110

Key field

Raw name

TLF/PTLF

Proc

Del

Err

Raw LM Name

Raw Exception

Scrp Name

ATM_TRAN_ID_KEY

ATM_TRAN_RAW00

TLF

WHSE_ATTRC_PROC WHSE_ATTRC_DEL WHSE_ATTRC_ERR

ATM_TRAN_RAW_EXCP

TW

Tran Warehouse - ATM Tran TW

B40120

POS_TRAN_ID_KEY

POS_TRAN_RAW00

PTLF

WHSE_PTTRC_PROC WHSE_PTTRC_DEL WHSE_PTTRC_ERR

POS_TRAN_RAW_EXCP

TW

Tran Warehouse - POS Tran TW

B40130

ATM_ADMIN_ID_KEY

ATM_ADMIN_RAW00

TLF

WHSE_AATRC_PROC WHSE_AATRC_DEL WHSE_AATRC_ERR ATM_ADMIN_RAW_EXCP

TW

Tran Warehouse - ATM Admin TW

B40140

POS_ADMIN_ID_KEY

POS_ADMIN_RAW00

PTLF

WHSE_PATRC_PROC WHSE_PATRC_DEL WHSE_PATRC_ERR POS_ADMIN_RAW_EXCP

TW

Tran Warehouse - POS Admin TW

B40150

ATM_TRAN_ID_KEY

ATM_TRAN_RAW00

TLF

SM_ATTRC_PROC

SM_ATTRC_DEL

SM_ATTRC_ERR

ATM_TRAN_RAW_EXCP

Settlement

Settlement - ATM Tran Settlement

B40160

POS_TRAN_ID_KEY

POS_TRAN_RAW00

PTLF

SM_PTTRC_PROC

SM_PTTRC_DEL

SM_PTTRC_ERR

POS_TRAN_RAW_EXCP

Settlement

Settlement - POS Tran Settlement

B40170

ATM_ADMIN_ID_KEY

ATM_ADMIN_RAW00

TLF

SM_AATRC_PROC

SM_AATRC_DEL

SM_AATRC_ERR

ATM_ADMIN_RAW_EXCP

Settlement

Settlement - ATM Admin Settlement

B40200

-

-

-

-

-

-

162

-

TW Summary



APPENDIX F ES ACTION CODES TO PTLF RESPONSE CODES ES ACTION CODE

BASE24 PTLF RESPONSE CODE

BASE24 PTLF RESPONSE CODE DESCRIPTION

000 Approved

000

APPROVED WITH BALANCES

001 Honor with Identification

004

APPROVED WITH PENDING ID

003 Approved (VIP)

006

APPROVED WITH VIP STATUS

100 Deny, Do not Honor

050

DECLINED

101 Deny, Expired Card

051

EXPIRED CARD

104 Deny, Restricted Card

059

RESTRICTED STATUS

106 Deny, Allowable PIN tries exceeded

052

PIN TRIES EXCEEDED

107 Deny, Refer to card issuer

101

ISSUE A CALL

111 Deny, Invalid card Number

075

INVALID PAN LENGTH

114 Deny, No account of type requested

060

ACCOUNT NOT ON THE CAF

115 Deny, Requested function not supported

063

INVALID AUTHORIZATION TYPE

116 Deny, Not sufficient funds

076

INSUFFICIENT FUNDS

117 Deny, Incorrect PIN

200

INVALID ACCOUNT

118 Deny, No card Record

206

CAF NOT FOUND

119 Deny, Transaction not permitted to cardholder

055

INVALID TRANSACTION

120 Deny, Transaction not permitted to terminal

055

INVALID TRANSACTION

121 Deny, Exceeds withdrawal amount limit

076

INSUFFICIENT FUNDS

125 Deny, Card not effective

051

EXPIRED CARD


APPENDIX F ES ACTION CODES TO PTLF RESPONSE CODES ES ACTION CODE

BASE24 PTLF RESPONSE CODE

BASE24 PTLF RESPONSE CODE DESCRIPTION

000 Approved

000

APPROVED WITH BALANCES

001 Honor with Identification

004

APPROVED WITH PENDING ID

003 Approved (VIP)

006

APPROVED WITH VIP STATUS

100 Deny, Do not Honor

050

DECLINED

101 Deny, Expired Card

051

EXPIRED CARD

104 Deny, Restricted Card

059

RESTRICTED STATUS

106 Deny, Allowable PIN tries exceeded

052

PIN TRIES EXCEEDED

107 Deny, Refer to card issuer

101

ISSUE A CALL

111 Deny, Invalid card Number

075

INVALID PAN LENGTH

114 Deny, No account of type requested

060

ACCOUNT NOT ON THE CAF

115 Deny, Requested function not supported

063

INVALID AUTHORIZATION TYPE

116 Deny, Not sufficient funds

076

INSUFFICIENT FUNDS

117 Deny, Incorrect PIN

200

INVALID ACCOUNT

118 Deny, No card Record

206

CAF NOT FOUND

119 Deny, Transaction not permitted to cardholder

055

INVALID TRANSACTION

120 Deny, Transaction not permitted to terminal

055

INVALID TRANSACTION

121 Deny, Exceeds withdrawal amount limit

076

INSUFFICIENT FUNDS

125 Deny, Card not effective

051

EXPIRED CARD

126 Deny, Invalid PIN block

200

INVALID ACCOUNT

127 Deny, PIN length error

200

INVALID ACCOUNT

200 Deny (Keep Card), Do not Honor

909

CAPTURE

201 Deny (Keep Card), Expired card

901

EXPIRED CARD

202 Deny (Keep Card), Suspected fraud

906

DELINQUENT

204 Deny (Keep Card), Restricted card

905

NUMBER OF TIMES USED LIMIT EXCEEDED

206 Deny (Keep Card), Allowable PIN tries exceeded

900

PIN TRIES EXCEEDED

208 Deny (Keep Card), Lost card

906

DELINQUENT

209 Deny (Keep Card), Stolen card

906

DELINQUENT

210 Deny (Keep Card), Suspected counterfeit card

906

DELINQUENT


163


400 Reversal Accepted

000

APPROVED

944 Data format error

074

UNABLE TO AUTHORIZE

947 Recurring data error

074

UNABLE TO AUTHORIZE

DEFAULT (ALL OTHERS)

100

UNABLE TO PROCESS THE TRANSACTION


400 Reversal Accepted

000

APPROVED

944 Data format error

074

UNABLE TO AUTHORIZE

947 Recurring data error

074

UNABLE TO AUTHORIZE

DEFAULT (ALL OTHERS)

100

UNABLE TO PROCESS THE TRANSACTION

164



APPENDIX G DATE ROUTINE MESSAGES MESSAGE NUMBER CZ1100 CZ1101

CZ1102

CZ1103 CZ1104-CZ1109

CAUSE Call to date routine was successful. Call to date routine was successful; the first date passed was greater than the second date passed. Call to date routine was successful; the second date passed was greater than the first date passed. Call to date routine was successful; the number passed was zero. Should not receive these messages

ACTION No action required. No action required.

No action required.

No action required. No action required.


APPENDIX G DATE ROUTINE MESSAGES MESSAGE NUMBER CZ1100 CZ1101

CZ1102

CZ1103 CZ1104-CZ1109 CZ1110

CAUSE Call to date routine was successful. Call to date routine was successful; the first date passed was greater than the second date passed. Call to date routine was successful; the second date passed was greater than the first date passed. Call to date routine was successful; the number passed was zero. Should not receive these messages as they are reserved for future use. The date sent to the date routine was invalid.

CZ1111

The first date sent to the date routine was invalid.

CZ1112

The second date sent to the date routine was invalid.

CZ1113

The date sent to the date routine was out of range; it was either prior to Jan 1, 1900, or after Dec 31 , 2099.

CZ1114

The first date sent to the date routine was out of range; it was either prior to Jan 1, 1900, or after Dec 31, 2099.

CZ1115

The second date sent to the date routine was out of range; it was either prior to Jan 1, 1900, or after Dec 31, 2099.

CZ1116

The number sent to the date routine was not a valid number. The number sent is larger than supported by the date routine. Reserved for future use.

CZ1117 CZ1118


ACTION No action required. No action required.

No action required.

No action required. No action required. There is either an invalid date in the input data or a program logic error. There is either an invalid date in the input data or a program logic error. There is either an invalid date in the input data or a program logic error. The date routine does not support the passed date. This is most likely an invalid date in the input data or a program logic error. The date routine does not support the passed date. This is most likely an invalid date in the input data or a program logic error. The date routine does not support the passed date. This is most likely an invalid date in the input data or a program logic error. This is most likely a program logic error. This is most likely a program logic error. Should not receive this message.

165


166

MESSAGE NUMBER CZ1119

CAUSE

ACTION

Reserved for future use.

CZ1120

Operation code invalid.

CZ1121

The format code for the send date is not a valid format.

CZ1122

The format code for the return date is not a valid format.

CZ1123


CZ1124


CZ1125

System error in the date routine.

Should not receive this message. The operation code passed is not one supported by the date routine. This is a logic error in the program. The format code is either invalid or not valid based on the operation code. This is a logic error in the program. The format code is either invalid or not valid based on the operation code. This is a logic error in the program. Should not receive this message. Should not receive this message. There was an error in the date routine that it could not recover from. Most likely this is a logic error in the date routine.



I/O ROUTINE MESSAGES MESSAGE NUMBER CZ9000

CAUSE Bad return from I/O routine. Lists Return code, Request ID and Action Code of request.

ACTION Review the output from the program for additional information concerning this error. Return codes correspond to the last 2 digits of the following messages. (i.e. return code 11 corresponds to message CZ9011). Request ID descriptions can be found in the CZ_REQUESTS table.

CZ9010

Unexpected End-of-File condition.

CZ9011

Unexpected row not found condition.

CZ9012

Read past End-of-File.


Action Codes are as follows: 10 = Read 20 = Cursor Read 30 = Update 40 = Write 50 = Delete 60 = Sequential Read 70 = Sequential Write This error generally indicates expected data is not available in the database, or it may indicate a logic error in the program. Review the output from the program for additional information concerning this error. This error generally indicates expected data is not available in the database, or it may indicate a logic error in the program. Review the output from the program for additional information concerning this error. This error generally indicates a logic error in the program. Review the output from the program for additional information concerning this error.

167



CAUSE Multiple rows found – Expected to find only one row. (For DB2 this is the result of a –811 error.)

CZ9014

No Stop Read.

CZ9015

No Start Read.

CZ9016

Constraint Violation. (For DB2 this is the result of a –530 error.)

168

ACTION This error indicates more rows were available, based on the SQL selection criteria, than were expected. This may indicate an error in the data or a logic error in the program. Review the output from the program for additional information concerning this error. This error generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This error generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This error indicates an attempt was made to insert or update a row in the database and a column in the row did not match the foreign key constraints for that column. This generally indicates a data value error (possibly the program did not properly edit data values), a program logic error, or a database definition error. Review the output from the program for additional information concerning this error.




CAUSE Bind Error. (For DB2 this is the result of a –818 error.)

CZ9018

No NULL indicator. (For DB2 this is the result of a –305 error.)

CZ9019


Other I/O error (error other than those listed in this table)

ACTION This error indicates the precompiler-generated timestamp in the load module is different from the bind timestamp built from the DBRM. This problem can occur if (1) the precompile, compile, and link were done without doing a BIND of the program; (2) the precompile and BIND were done without doing the compile and link for the application program; (3) the BIND of the program was done using a DBRM that resulted from a different precompile of the application program than that which produced the object module that is linked into the application module. Review the output from the program for additional information concerning this error. This indicates a column of data contained a NULL value, but the program did not specify an indicator variable for the column. This generally indicates a logic error in the program or an error in coding the SQL statement. Review the output from the program for additional information concerning this error. This indicates an error, other than the standard errors handled by the I/O layer programs, has occurred. These errors are generally caused by problems with the database but can also be caused by bad data or program logic errors. Review the output from the program for additional information concerning this error.

169


170


CAUSE Bad Request Program.

CZ9021

Bad Processing Type.

CZ9022

Previous I/O layer initialization request.

CZ9023

Previous I/O layer termination request.

CZ9024

I/O layer has not been initialized.

ACTION This indicates the ‘Request Program’ value in the header area of the request to the I/O layer was not provided. This generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This indicates the ‘Processing Type’ value in the header area of the request to the I/O layer was not provided or was invalid. This generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This indicates a request was made to the I/O layer to perform initialization processing, however, the initialization processing had already been performed. This generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This indicates a request was made to the I/O layer to perform termination processing, however, the termination processing had already been performed. This generally indicates a logic error in the program. Review the output from the program for additional information concerning this error. This indicates a request was made to the I/O layer to perform an I/O request, other than an initialization request, but the I/O layer had not yet been initialized. This generally indicates a logic error in the program. Review the output from the program for additional information concerning this error.




Invalid action code.

CZ9032

Invalid record length.

CZ9033

Routing error.


CAUSE

ACTION This indicates the ‘Action Code’ specified for this request is missing or invalid. This generally means the action requested by the program calling the I/O layer is not supported by the I/O layer. Review the output from the program for additional information concerning this error. This indicates the length of the data area passed to the I/O layer was a different length than that expected by the I/O layer. This generally indicates the copybook used to pass data between the program and the I/O layer has changed, and not all programs using that copybook have not been modified or recompiled to use the new copybook. This may also be the result of a program logic error. Review the output from the program for additional information concerning this error. This indicates a request was made to the I/O layer to perform a specific request, however, the I/O layer could not determine the I/O program to call to satisfy this request. This means that either the program made an invalid request, or the request is not specified in the database. Review the output from the program for additional information concerning this error.

171


172


CAUSE Bad number of end points.

CZ9042

Request is not installed.

CZ9050

Invalid sub-request.

CZ9060

Business Unit hierarchy error.

ACTION This indicates a request was made to the I/O layer, however, the I/O layer could not determine which program to route the request to since more than one program has been configured to handle the request. This generally means the I/O routing requests for the application have been configured (installed) incorrectly. Review the output from the program for additional information concerning this error. This indicates a request was made to the I/O layer, however, the request has not been installed in the database. This means that the required routing information has not been installed in the database, or a request was made for access to data for an application that has not been installed. Review the output from the program for additional information concerning this error. This indicates a request made to the I/O layer contained a sub-request, and that subrequest was either missing or invalid. This means there was a logic error in the requesting program. Review the output from the program for additional information concerning this error. This indicates the hierarchy for a Business Unit is incorrectly configured. Correct the Business Unit configuration. Review the output from the program for additional information concerning this error.


BASE24 Transaction Warehouse Runbook

Recommend Documents