Hi ALL,
System Configuration:
IBM AIX 5.3.0.0 64bit, 8 CPU machine
Memory: 58GB
Progress: 10.1C
Database size: 47.9 GB [by dbanalysis report]
152 GB [by promon -> 5. Activity]
Challange: After the D&L , when I'm executing full index rebuild on the database, it is taking 5 hrs to complete this...
Thanks Rob,
I actually able to find the root cause of the reported issue. It occurred because the load process was terminated abnormally.So on restarting the load it completed without any issue.
Thanks all for your great support.
Regards,
Pankaj
Thanks Rob and Tom for your valuable inputs.
You know what,as per your suggestion , I've rebuild all the indexes of this table and then ran the binary dump with the given parameters.
And the result was strange. This time it took 45 mins to dump aal the records of this table , so it was a big...
Thanks Rob for your valuable inputs.
What was your full proutil command line for this latest test?
$DLC/bin/proutil $DBNAME -C dump spt_det $DMPDIR -index 1637 -thread 1 -threadnum 4 -dumplist $DMPDIR/spt_det.lst
What are the details on this table from the RECORD BLOCK SUMMARY in dbanalys...
Hi ALL,
I am getting below error message when I'm doing binary dump of the a table:
Could not find record. Recid 35271050, error number 8, return -1. (12011) Binary Dump failed. (6253)
I ran full index check on this table and didn't got any error.
So not sure how can I proceed further with...
I executed the multi-threaded dump with idx 1637 and it took 5:45 mins this time.
I need help in adding an index [as suggested priviously] to this table and do the dump using this index.So what all things I need to consider in adding an index?
Currently the two indexes are defined as below:
││...
Thanks Rob for your input. Below given my answers:
When is the last time you compacted or rebuilt your indexes? Try compacting, or rebuilding if you can afford the downtime, and see if it helps.
No idea, but can try rebuilding and check.
Which one is the primary index...
Hello ALL,
System Configuration:
IBM AIX 5.3.0.0 64bit, 8 CPU machine
Memory: 58GB
Progress: 10.1C
Database size: 47.9 GB [by dbanalysis report]
152 GB [by promon -> 5. Activity]
Challenge: Binary dump of a table taking more then 7 hrs,so need your valuable inputs...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.