MVSFORUMS.com

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

hi,

is it possible to run a load utility without updating one or more indexes of the table?

thanks.

kolusu · Posted: Wed May 13, 2009 9:47 pm Post subject:

jctgf,

I think it canNOT be done, but I am curious as to why you want to do it.

Kolusu

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

hi,

every month i need to run a load replace on a table that contains 9 billion records.

the table contains 2 indexes and, in order to make it faster, i have been dropping the second index of the table, running the load and then rebuilding the index.

recently i was told that dropping an index is extremely dangerous because it may lock the database and cause serious damage to the entire environment.

so, i was wondering if i could run the load without updating this index (in order to make it faster). at the end of the load, i'd rebuild the index.

thanks.

kolusu · Posted: Thu May 14, 2009 11:06 pm Post subject:

NASCAR9 · Posted: Fri May 15, 2009 9:29 am Post subject:

I think you need to step back and look at the volume of data you are loading. It will take a little while. What kind of time are you taking about? Are you running stats after your load? Like kolusu said, sorting the data will help, but when you add the time of the sort and the load together is it worth the extra step? I don't know.
_________________
Thanks,
NASCAR9

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

thanks.
can some one give me some tips about version 8 partitioned table, please?
i was told that in this case a partitioned index is not necessary anymore.
what's the CREATE TABLE code to create such a table?
i'll still need a partitioned criteria, right? where do i declare it considering that there's no partitioned index?
thanks.

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

hi,

recently i was told that dropping an index is extremely dangerous because it may lock the database and cause serious damage to the entire environment.

how true is it please?

what can i do to avoid locking the whole thing?

thanks.

dbzTHEdinosauer · Posted: Sat May 16, 2009 8:41 am Post subject:

Was just reading Partitioned Tables/NPI by Craig Mullins. Don't know if it applies, but worth the read.
_________________
Dick Brenholtz
American living in Varel, Germany

jctgf · Beginner Joined: 05 Nov 2006 Posts: 89 Topics: 36

hi!

I was wondering if I could run a "recover" instead of a "load".

I'm not very familiar with the "copy/recover" utilities.

can I select records with a "copy" utility?

can I turn off the update of an index before running a "recover" and then rebuild the index when the "recover" is over?

thanks.

satyenderd · Beginner Joined: 26 Aug 2005 Posts: 144 Topics: 73

jctgf,

If I am not wrong, I think you are looking for the "Table Partition".
In Table partitioning, Partitioning Index is not required.

Check the link:

http://www.neodbug.org/nov_2006/Partitioning_Maint_Perf.pdf

-Satya
_________________
Satya