Migration unit testing process


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Migration unit testing process
# 1  
Old 09-28-2008
Migration unit testing process

Hi,
We are doing migration from DB2 to Teradata.
There are couple of things involving in the project.

Please see below following order

Autosys-Jil script
Profile script
Category1
Teradata script
Data stage job script
Tera data script
Export files script..


Like that we have 10000 jobs....

We are planning to migrate all the scipts. We did lot of atomization to change all the scripts,,, like search and replace the string....


Now the challenging task is UNIT TESTING.
I suggested the client two ways:

1. We deploy all the existing code in to one schema.....
Another schema we will deploy the latest code....
We will compare with the counts in the tables.
The output counts should be matched.

Advantages:
1. Improve the quality of testing
2. Work flow is understandable.
Disadvantages:
1. Investing llot of cost on resources.
2. Client is not accepting to spend that much money on additional resource


2. First deploy the existing code then load the data into tables. Then take the back up of the tables and deploy the new code and trigger the load.
Compare the two tables.
The counts should be match.

Advantages:
1. Save the amount of resource cost.

Disadvantages:
1. Re work process is more if the output is not correct.

Please advise me any other solution.

We have very less time to do on unit testing. Help me on advises and automise the unit testing process.

Thanks
Suri...
# 2  
Old 09-28-2008
Maybe it makes sense to have ordered queries on all tables, then run the output through a filter, and finally pass it through a checksummer (md5 for instance):

Code:
<psuedocode>
For each table:
  select * from <table> order by <primary key> 
  Output query to a file. 
  Send file through a formatting filter to remove, for instance, unprintable characters and spacing. 
  Send resulting output through [b] openssl md5 - [b]

Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. AIX

AIX - FC Switch migration, SAN Migration question!

I'm New to AIX / VIOS We're doing a FC switch cutover on an ibm device, connected via SAN. How do I tell if one path to my remote disk is lost? (aix lvm) How do I tell when my link is down on my HBA port? Appreciate your help, very much! (4 Replies)
Discussion started by: BG_JrAdmin
4 Replies

2. UNIX for Dummies Questions & Answers

Simple unit script

Hello guys this is my first post in this forum. Since now ive been passive an ive only been looking for existing information. Now I could use specific help on a UNIX script i want to make that would: 1. Take 1-3 arguments. 2. Display the contents of its arguments, formatted as follows:... (7 Replies)
Discussion started by: banzomaster
7 Replies

3. Red Hat

Doubt about process migration

Hello experts, My doubt is, shall we move process from one node to another node..? This will be need when the cpu running on max load. Thanks. (1 Reply)
Discussion started by: srigias
1 Replies

4. Shell Programming and Scripting

Testing a process has ended (in the background)

Hi guys. Hopefully this question will make sense! Continuing on my script to automatically copy some huge files across the network onto various servers as background jobs, I need to be able to check that each job has finished successfully. The script below shows what I want - almost. The... (2 Replies)
Discussion started by: dlam
2 Replies

5. UNIX for Dummies Questions & Answers

Testing the forking process.

Hey, first time poster and a new UNIX user here. My question is regarding the forking process. I logged in to tty1, and typed the command ls -1 and hit enter. How can i tell that the ls -1 command ran in a subshell? Thanks. (0 Replies)
Discussion started by: Vitamin254
0 Replies

6. UNIX for Advanced & Expert Users

process migration

how can i migrate a running process in unix to another node? (1 Reply)
Discussion started by: aisalihu
1 Replies

7. UNIX for Dummies Questions & Answers

process migration

how can i migrate a running process in unix to another node for load balancing? (3 Replies)
Discussion started by: aisalihu
3 Replies

8. UNIX for Advanced & Expert Users

Process migration

Using binary translators, would it be possible capture the runtime image (instructions and data) of processes and translate these so that the process can run from where it left on a machine with a different architecture? This will be useful for migrating applications to heterogenous systems for... (3 Replies)
Discussion started by: sumona
3 Replies
Login or Register to Ask a Question