Hi,
I tried running the HPU on a table which has billions of record , and the job ran for more than 3 days , can anyone tell me what would be the reason for the same.Is it the performance issue of HPU or something to do with the system.
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Sun Sep 12, 2004 7:44 pm Post subject:
Quote:
I tried running the HPU on a table which has billions of record , and the job ran for more than 3 days
Meena,
You must be kidding when you said your DB2 table had Billions of rows. Are you sure it is billions and not millions? 1 billion is 1000 miliion. The total population of the world is only 6 billions( we reached that mark in 1999).
hmm I wonder which device is gonna hold that many records. How many volumes did it take to unload the entire data? I very much doubt if DB2 can even handle that many records.
If the number is in millions, then may be you can talk to your DBA about the performance and he might suggest some improvements.
Hi Kolusu,
The database is an order database , hence each day lot of orders come in and hence there are atleast 50 million records(if not a billion) in the table.
Can you suggest anyother link where i can get more information about this utility??
Thanks
Meena
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Mon Sep 13, 2004 6:04 am Post subject:
Meena,
A 50 million unload should not run for 3 days. We have 23 million table and it unloads flat out in 45-60 mins using dsnutilb utility. The only manual HPU has listed above. Can you post your JCL
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Mon Sep 13, 2004 9:20 am Post subject:
Meena,
ewwwwww! Now I know why your job ran for 3 days. You hardcoded a blocksize of 183, which means it will write one record per block.The optimal blocksize for a lrecl of 183 on tape datasets is 32757 Which will write 179 records per block. If you are writting it to a dasd file then the optimal block size is 27816 for 3390 dasd device type.
Please change your blocksize parameters and re-run the job.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
