CAS PROGRAMMER’S DESIGN AND TEST DOCUMENT SUBJECT: UK Datacash recovery after role swap PROJECT #: 20080626011 SDLC # and PHASE: 110270004 01 PROJECT TYPE: Enhancement
PROGRAM: UK309G/UK325G/UK329G PROGRAMMER: Rajendra Sharma / Fred Santos UNIT TEST APPR’D: KC Baltz / Fred Santos DEVELOPMENT ANALYST: Fred Santos PROJECT REQUESTED BY David Burke Department – MIS PURPOSE
CURRENT STATUS: Ready for QA UNIT TESTED: Yes DATE: 09/25/2008 DATE:
When the DATACASH (and HPI) servers are re-started without first issuing a "shutdown" request, the corresponding Data Queue control records are still marked as "active" on the DB Server. Any of the "active" Data queue’s could then be selected for a DATACASH (or HPI) transaction. Of course, when the servers are re-started, some of these supposedly active Data Queue’s are no longer serviceable, thus resulting in alerts to QSYSOPR. To fix this problem, perform following steps, 1) Flag the Data queue as Deleted in file CTLDTQDQ 2) Send a SHUTDOWN message on the older DTAQ 3) Delete the older DTAQ
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -1-
01/07/09
HOW TO TEST Testing for Data Cash interface Point to note: At any instance only one Data queue should be active for an IP address, if there is an existing Data queue for the same IP, then the new changes in program should first Mark that record in CTLDTQDQ as Deleted by DQstatus =’D’, then delete the Data queue. Step 1 – Start a DataCash server instance. There should be a single ‘A’ record for that IP address in CTLDTQDQ. Note the DataQueue name Step 2 – Start another DataCash server instance. The first instance should be shut down and there should still one ‘A’ entry in CTLDTQDQ. However, the DataQueue name should be different. To verify no regressions have been caused by this change, some credit card transactions should be done in the UK environment. For HPI, perform step 1 and 2 substituting an HPI server instance for the DataCash instances. To regression test, disable the HPI simulator and create an assignment for a new VIN.
PROGRAMMER COMMENTS AREAS AFFECTED CAS Project will be coordinated by KC Baltz. WEB CONSIDERATIONS NA
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -201/07/09
DATABASE CHANGES NA
AFFECTED MENU(S) NA OBJECT MIGRATION ISSUES This has to be done after UK business hours. This project is also tied to project 111880928, phase 1 and 2. They must be installed simultaneously.
DATA QUEUE IMPACT NA BID PROCESSES IMPACT NA WEB SERVER IMPACT NA WEB JOBS IMPACT NA SECURITY None – Changes being made to existing objects.
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -3-
01/07/09
POST INSTALL WORK I: SPECIFIC TABLE CHANGES FILE/FUNCTION SECTRNQT COMREFRF COMREFAI NOTAUTNA HELPTXHT PMTCTLPC CASMSGF RPTFUNRJ RPTREQRK PRINT FILE DEFINITIONS REQD Y/N NEW/CHANGED CODE/TEXT/RECORD NOTES
POST INSTALL WORK II: OTHER REQUIRED ACTIONS NA RELATIONSHIPS NA STORED PROCEDURES NA USER DEFINED FIELDS NA OBJECTS NAME TYPE ATTR NEW DESCRIPTION
01/07/09
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -4-
UK309G UK325G UK329G
*PGM *PGM *PGM
RPGLE RPGLE RPGLE
HPI Java interface Start up UK Credit Card request processor UK Credit Card Java Interface Start up
TEST CONDITIONS – EXPECTED RESULTS PROGRAM UK325G UK329G CONDITION No Role swap 1.1 Initiate a Data cash transaction from a pc. Then reissue the different transaction type ( Queue & sub-queue type) from same pc Role swap – same PC machine, with same Queue & sub-queue type 2.1 Initiate a Data cash transaction from a pc. Then reissue the different transaction type ( Queue & sub-queue type) from same pc Role swap – Different PC machine, with same Queue & No records should be Same as updated with DQStatus Expected result =’D’ EXPECTED RESULT ACTUAL RESULT LOT # OTHER
UK325G UK329G
First records should be Same as updated with DQStatus Expected result = ‘D’ and second records should be active.
UK325G UK329G
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -5-
01/07/09
UK325G UK329G
UK325G UK329G
sub-queue type 2.1 Initiate a Data cash transaction from a pc. Then reissue the different transaction type ( Queue & sub-queue type) from different pc machine. Please make sure IP address of the two PC machine are different Role swap – same PC machine, with different Queue & subqueue type 2.1 Initiate a Data cash transaction from a pc. Then reissue the different transaction type ( Queue & sub-queue type should be different from the previous) from same pc Role swap – Different PC machine with different Queue & sub-queue type 2.1 Initiate a Data cash transaction from a pc. Then reissue the different transaction type ( Queue & sub-queue type should be different from the previous) from different pc machine. Please make sure IP address of the two PC machine are different
First records should remain Active for the first IP, and second record should be Active with different IP address
Same as Expected result
First records should NOT be updated with DQStatus = ‘D’ and second records should be active.
Same as Expected result
First records should remain Active for the first IP, and second record should be Active with different IP address
Same as Expected result
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -6-
01/07/09
D.A COMMENTS D.A. TEST CASES PROGRAM CONDITION EXPECTED RESULT ACTUAL RESULT LOT # OTHER
QA COMMENTS QA TEST CASES PROGRAM CONDITION EXPECTED RESULT ACTUAL RESULT LOT # OTHER
D:\Docstoc\Working\pdf\35ac2862-3be0-4b1f-9b42-b724c9224b1f.doc -7-
01/07/09