Selecting from an image copy using HPU INFUTILB



IBM's flagship relational database management system

Selecting from an image copy using HPU INFUTILB

Postby ITConsultant » Thu Oct 21, 2010 8:54 am

HI, I have image copy of a very large table on tape.

I am using INFUTILB utility to write out few of the millions of records that I am interested in.

I am selecting as following:

Select * from Table_A where
(column_A = value_A1 and column_B = value_B1) or
(column_A = value_A2 and column_B = value_B2) or
(column_A = value_A3 and column_B = value_B3) or
.
.
.
(column_A = value_A100 and column_B = value_B100) ;

Values in column_A are various dates while the Column_B values are numeric.

I am writing the output to a file. The resulting records that I get have gaps. For example, it will write M number of matching records and then skip N records before writing the matching records again. If I submit the job again after changing query to only select the records it missed the first time, it finds some but still misses a lot of them.

why would this be the case?
ITConsultant
 
Posts: 15
Joined: Wed Mar 10, 2010 4:28 am
Has thanked: 0 time
Been thanked: 0 time

Re: Selecting from an image copy using HPU INFUTILB

 

Re: Selecting from an image copy using HPU INFUTILB

Postby dick scherrer » Thu Oct 21, 2010 11:15 am

Hello,

What informational messages are created by the run?

It may help if you post these. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Selecting from an image copy using HPU INFUTILB

Postby ITConsultant » Thu Oct 21, 2010 11:47 pm

There were no errors or unusual messages in the log. Despite client's assurances that they provided me accurate selection data, that is not the case. The account rows they wanted retrieved are not there on the image copy and now they tell me that they may be stored under a different account number.
ITConsultant
 
Posts: 15
Joined: Wed Mar 10, 2010 4:28 am
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post