Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Automation in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Fri Dec 11, 2015 9:59 pm    Post subject: Automation in DB2
Reply with quote

Hi,

I know this is actually a hugh topic to discuss at forum, but i need some help in automating DB2 tables testing:

1. I have a DB2 table GAA1.STRUCTURE loaded monthly which contains 100K + rows. I need to test the data (each and every column, row by row) from the input file, to make sure everything got loaded fine in table.

2. I can do a count check and some random records testing, but i need to check the DATA here for all the records.

3. I was thinking to unload the table into a file and then compare it line by line in Excel, but if i want to compare it with previous table load, with the new load, how can i do that..

4. Also, since the rows are 100K+, excel compare would not work i guess.

Any suggestions would be helpful. Thanks.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Fri Dec 11, 2015 10:26 pm    Post subject:
Reply with quote

I don't think this is a legitimate testing, why would data be not same from the load file Vs same table unload? unless being altered by real-time.
why do you need excel? Do you not aware of ISRSUPC or COMPAREX or DFSORT JOINKEYS?
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 331
Location: USA

PostPosted: Fri Dec 11, 2015 11:32 pm    Post subject: Reply to: Automation in DB2
Reply with quote

Using Excel is Not a good idea. If you pass the data multiple times then there are more chances of a mess up. How would you make sure that the data in excel is same as the data in the table? So, you would add another possibility of doing a comparison and it's never ending.

What I would suggest is that you get the input data (from where you loaded the table) and the output data (possibly unload) into the same format. So, there will be 2 different files to compare (remember to convert in the same format) and then use ICETOOL's Splice Job to get matching/non-matching rows.

.
Back to top
View user's profile Send private message
chhabraravneet

New User


Joined: 04 Oct 2007
Posts: 49
Location: Mumbai

PostPosted: Sat Dec 12, 2015 1:24 am    Post subject: Reply to: Automation in DB2
Reply with quote

Thanks for the suggestions.

Rohit - There are some transformations in between the load, that;s the reason we need to verify the input and output. Its like Input file --> Stage table --> Output Table.

Input file to Stage table is full move, so no need to test that.
we need to test if Input file and Output table has same records.

But i agree with you guys, excel is not a good idea here. I will try to unload the table and format it and then compare it with input.

Thanks again.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1609
Location: NY,USA

PostPosted: Sat Dec 12, 2015 11:26 am    Post subject:
Reply with quote

Well, Let us know if you get in difficulties.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Automation of data entry using Rexx i... zingy.rajeev CLIST & REXX 4 Mon Aug 22, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Automation of data entry using Rexx i... zingy.rajeev CICS 0 Mon Aug 22, 2016 4:11 pm
No new posts Automation JCL Problem - PDSM18 input... PokerGuru JCL & VSAM 4 Wed Aug 19, 2015 12:05 am
No new posts TWS Scheduler to Visio Flow automation Sujana K IBM Tools 4 Thu Aug 07, 2014 8:10 am
No new posts Automation of batch delay in prod. samratganguly JCL & VSAM 3 Sat Nov 23, 2013 2:16 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us