MVSFORUMS.com

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Hi,

I am trying to unload a table using PGM=INZUTILB .For the same table when I do a "select count (*)....." , then I get few more records than the earlier count.

Iam surprised to see this difference for the same table.

Can any one please tell me why there is a difference in the record count when I do a unload and when I execute the SQL (Select count (*) )

Thanks,
Thrivikram.

kolusu · Posted: Sun Feb 11, 2007 10:08 am Post subject:

THRIVIKRAM,

couple of things to check

1. Were there any inserts/updates/deletes between the batch job run and spufi?
2. Are you quering the same table in spufi and batch unload?

PGM=INZUTILB seems to be your shop specific utility. Is it actually running DSNTEP2 or DSNTIAUL utility ?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Kolusu,

1) No there are no inserts/updates/deletes between the batch job run and spufi. I checked that today also by running both consequently.

2)Yes Iam quering the same table.

PGM=INZUTILB is using "FORMAT DSNTIAUL"( I saw this in the Sysin)

Thanks,
Thrivikram.

kolusu · Posted: Wed Feb 14, 2007 6:50 am Post subject:

THRIVIKRAM,

How did you check if any user ran a spufi and deleted the records from the table? An online screen can delete/update the rows

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

THRIVIKRAM · Beginner Joined: 03 Oct 2005 Posts: 70 Topics: 34

Kolusu,

Thats correct and has a probability. But in my case, I did two sets of Unloads and Querried the table.
1)Ran querry: 27,834 - records
2)Unload Job: 27,563
Got a doubt and again,
3)Ran Querry: 27,834
4)Unload job: 27,563

This is what I did.

Thanks,
Thrivikram.

kolusu · Posted: Wed Feb 14, 2007 12:44 pm Post subject:

Thrivikram,

Is this a partitioned table ?

Also can you run this query and show us the results?

dbzTHEdinosauer · Posted: Wed Feb 14, 2007 1:48 pm Post subject:

Thrivikram,
also, what sql are you using in the table unload?

an unload for all rows will unload all rows. something is not right here.

go thru your output of the unload and determine which rows are in the table that are not in the output.

only 30k rows, 15min to write a prog, 2 min to run. analyze the rows in the table that are not in the unload output.
_________________
Dick Brenholtz
American living in Varel, Germany