Test Plan Template ver.
Error: Reference source not found
KT HPU EBF Enhancement- QA Test Plan
Project Name Project Version
KT EBF 1.0
Test Plan Version Test Plan Template Version
1.0 1.0
Document Revision History
Author
Vidyanand Penugula Vidyanand Penugula Vidyanand Penugula
Comments
Initial draft Incorporated Review comments Incorporated imp conf.properties cases
Date
18-01-2012 20-01-2012
Test Plan Review/Approval
Title
Product Manager Project Manager QA Project Lead QA Team Review Team
Name
Mukesh Kumar Maroda Jitendra Nath Guptha N/A N/A Mukesh Kumar Maroda
Date
18-01-2012 18-01-2012
18-01-2012
Template version last updated on 06/02/2005 DO NOT COPY THIS DOCUMENT
This document contains information that is proprietary and confidential to Informatica Corporation. It is intended only for internal distribution. This document may not be copied or distributed in any form without the prior written consent of Informatica Corporation. Document location: 2005 Informatica Corporation. All rights reserved.
Informatica Confidential
Page 1 of 7
7/2/2012
Test Plan Template ver.Error: Reference source not found
Table of Contents
KT HPU EBF Enhancement- QA Test Plan.......................................................................1
1. GOAL...................................................................................................................................2 2. REFERENCE DOCUMENTS............................................................................................2 3. FUNCTIONALITIES/AREAS TO BE TESTED...............................................................3 4. FUNCTIONALITY/AREAS NOT REQUIRING TESTING............................................3 5. HIGH LEVEL TEST OVERVIEW....................................................................................3 6. ACCEPETANCE TESTS:..................................................................................................5 7. L& P TESTS:........................................................................................................................5 8. REGRESSION TESTING:..................................................................................................5 9. SCENARIOS COVERED FOR VARIOUS ENVIRONMENTS:.....................................5 10. TESTING SCHEDULE/MAJOR MILESTONES...........................................................6 11 TESTING APPROACH......................................................................................................6 12. RESOURCE REQUIREMENT.........................................................................................6 13 RISKS, ASSUMPTIONS AND CONTINGENCIES:.......................................................6
1. GOAL
The scope of the project includes testing the export in archiving in ILM using the third party utility call HPU (High Performance Utility for DB2) instead of using the JDBC /ODBC or db2 Load client.
2. REFERENCE DOCUMENTS Document
QA Project Strategy
Link
N/A
Date
Informatica Confidential
Page 2 of 7
7/2/2012
Test Plan Template ver.Error: Reference source not found Functional Specifications Design Implementation Feature Testing Project Plan Korea_Telecom_Requirements by clee_RG.docx Korean Telecom Requirements Solution 2.1.docx N/A
Table 1: Links to Required Reference Documents.
3. FUNCTIONALITIES/AREAS TO BE TESTED
1. Online Archive & File Archive for DB2 UDB after invoking HPU Export utility. 2. Restore Online Archive & Restore File Archive for DB2 UDB after invoking HPU Export. 3. With different Import/Load and column/Row Separator properties.
4. FUNCTIONALITY/AREAS NOT REQUIRING TESTING
As this is EBF, we are not focusing remaining scenarios like Seamless access, create tables, Data Discovery, Audit Log, Manage Retention, Legal Hold, Purge etc.
5. HIGH LEVEL TEST OVERVIEW INTEGRATION TESTS: Test Area Section
1 N/A
Scenarios
Priority
SMC
Table 2: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification. Integration Test Scenarios to be tested as part of the enhancement. Priority of the Test Case. Simple / Medium / Complex categorization of the scenario
Informatica Confidential
Page 3 of 7
7/2/2012
Test Plan Template ver.Error: Reference source not found
PROGRESSION TESTS: Test Area - Section
1 Online Archive 2.1
Scenarios
Online Archive (Archive and Purge) for DB2 UDB after invoking HPU Export utility. Online Archive (Archive Only) for DB2 UDB after invoking HPU Export utility. File Archive Bulk mode for DB2 UDB after invoking HPU Export utility. Online Restore for DB2 UDB after invoking HPU Export utility. File Restore for DB2 UDB after invoking HPU Export utility. Online Archive for DB2 UDB after invoking HPU Export utility without staging. File Archive without Bulk mode for DB2 UDB after invoking HPU Export utility. File Archive Bulk mode for DB2 UDB after invoking HPU Export utility with bcp column and row separator with one byte long File Archive Bulk mode for DB2 UDB after invoking HPU Export utility with bcp column and row separator with more than one byte long File Archive Bulk mode for DB2 UDB after invoking HPU Export utility with different Import/Load properties (db2ImpStar, db2ImpMiddle, db2ImpLast)
Priority
P1 P1 P1 P1 P1 P2 P2 P1
SMC
Medium Medium Medium Medium Medium Medium Medium Complex
2 Online Archive 2.1 3 File Archive 2.1 4 Online Restore 2.1 5 File Restore 2.1 6 7 Online Archive 2.1 File Archive 2.1 File Archive 2.1 8 File Archive 2.1 9 File Archive 2.1 1 0
P1
Complex
P1
Complex
Table 3: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification. Progression Test Scenarios to be tested as part of the enhancement. Priority of the Test Case. Simple / Medium / Complex categorization of the scenario
NEGATIVE / CORNER TESTS: Test Area - Section
1 2 Online Archive 2.1 File Archive 2.1
Scenarios
Priority
P2 P2
SMC
Medium Medium
Online Archive for DB2 after invoking HPU Export utility but not passing HPU path. File Archive for DB2 after invoking HPU Export utility but not passing HPU path.
Table 4: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification. Progression Negative and Corner Test Scenarios to be tested as part of the enhancement. Priority of the Test Case. Simple / Medium / Complex categorization of the scenario
INTERNATIONALIZATION (I18N) TESTS:
Informatica Confidential
Page 4 of 7
7/2/2012
Test Plan Template ver.Error: Reference source not found
Test Area - Section
1 N/A
Scenarios
Priority
SMC
Table 5: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification. I18N Test Scenarios to be tested as part of the enhancement. Priority of the Test Case. Simple / Medium / Complex categorization of the scenario
6. ACCEPETANCE TESTS:
Test Area - Section
1 N/A
Table 6: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification scenario. Acceptance Test are the Pre-Agreed cases should be working for accepting the build. Priority of the Test Case. Simple / Medium / Complex categorization of the
Scenarios
Priority
SMC
7. L& P TESTS: Test Area - Section
1 N/A
Scenarios
Priority
SMC
Table 6: Test Area is the Module (Ex: Online Archive). Section is the Section Reference from the Specification scenario. L & P Test scenarios to be executed. Priority of the Test Case. Simple / Medium / Complex categorization of the
8. REGRESSION TESTING: Test Area - Section
1 Online Archive 2.1 2 File Archive 2.1 3 4 Online Archive 2.1 File Archive 2.1
Scenarios
Online Archive for DB2 UDB without any Export and HPU utility invoked File Archive for DB2 UDB without any Export and HPU utility invoked. Online Archive for DB2 UDB with any Export utility and HPU utility commented File Archive for DB2 UDB with any Export utility and HPU utility commented. Online Archive for DB2 zOS without any Export utility invoked File Archive for DB2 zOS without any Export utility invoked. Online Archive for DB2 As400 without any Export utility invoked File Archive for DB2 As400 without any Export utility invoked.
Priority
P2 P2 P2 P2 P2 P2 P2 P2
SMC
Medium Medium Medium Medium Medium Medium Medium Medium
5 Online Archive 2.1 6 File Archive 2.1 7 Online Archive 2.1 8 File Archive 2.1
Table 5: High-Level Performance & Stress Test Descriptions. Reference numbers are given in the format W.X.Y.; paragraph (par) A.
9. SCENARIOS COVERED FOR VARIOUS ENVIRONMENTS: As KT is using only AIX , we are executing all the scenarios on AIX with DB2 UDB.
Informatica Confidential
Page 5 of 7
7/2/2012
Test Plan Template ver.Error: Reference source not found
Test Area - Section 1
Scenarios
Environment
Table 5: High-Level Performance & Stress Test Descriptions. Reference numbers are given in the format W.X.Y.; paragraph (par) A.
10. TESTING SCHEDULE/MAJOR MILESTONES Phase Start Date QA Prep 18-01-2012 Progression Execution 23-01-2012 Regression Execution 30-01-2012 Final Sign-off 31-01-2012 11 TESTING APPROACH
End Date 20-01-2012 31-01-2012 31-01-2012 31-01-2012
We are executing all the test cases on already installed HPU AIX box. Only below test cases will be executed on the new AIX 5.3 environment subject to availability of the box and HPU installation progress. Progression test cases 1 and 3.
12. RESOURCE REQUIREMENT
Staffing : 1 Vidyanand Penugula Training: N/A
Systems
List all the systems required for a successful execution of the test plan. Hardware
1. Operating Systems:
AIX
2. Databases: DB2UDB . 3. 3rd Party systems
HPU
4. Testing Tools N/A 13 RISKS, ASSUMPTIONS AND CONTINGENCIES: Risk: 1.We are executing all the scenarios on already installed HPU AIX box. 2.Execution of test cases on new AIX 5.3 will depend on availability of AIX 5.3 box and HPU software installation and DB2 Data bases. Assumptions:
Informatica Confidential Page 6 of 7 7/2/2012
Test Plan Template ver.Error: Reference source not found
1. Testing this KT EBF on ILM 5.3.6 with EBF 10693 on DB2 home. 2. HPU software (High Performance Utility for DB2) is already installed. 3. Catalog nods are already created on all DB sources (UDB,zOS,As400)
Informatica Confidential
Page 7 of 7
7/2/2012
