Re: Diagnostic & Violations tables

stiglich@promarkone.com wrote: ||Hello, || || Is there a way to give extent sizes for diagnostics & violations ||tables that are created by High Performance Loader? It seems to ||default to 8 pages. This is not good when you have a very large ||load because you get extents scattered all over the place. Jacob Salomon presumptuously responded: | |Pete, | |probably not, because that kind of control is not part of the "start |violations table" command. | |However, after running the START command, you should be able to | ALTER TABLE blah_vio NEXT SIZE 100000 | ALTER TABLE blah_dia NEXT SIZE 100000 | |so that the major part of the violations/diagnostic tables are in a |huge extent. This is almost as good, I think. Weeeellll=85. Pete tried it and was polite enough to inform me privately that it doesn't work. His exact words: |Unfortunatly, I get an 897 error, cannot alter violations table or |something to that effect. Hmm=85 I had to try that myself and got the same result. I even tried to be wise guy and stop violations for the table. I was then able to alter table as above. However, when I tried to restart violations for the table, it complained that the tables it wanted to create already exist. Excuse me=85 # # ### # # ## ##### ##### #### # # # # ### # # # # # # # # # # # # # # ### # # # # # # # # ###### ###### # # ###### ##### ##### # ### # # # # # # # # # # # # # # # # # ### # # # # # # # #### # # # # ### Why can't we alter a table used as a diagnostic? Probably has something to do with some kind of locks. OK, I can live with that. But why can't the violation & diagnostic tables exist already? (Come to think of it, life goes on without that feature as well...) When I create a constraint, the engine is willing to use an existing index. I can plunk two identical tables into one by declaring them to be fragments of the same table. Informix has the logic to use an existing structure for use in a new structure. It is so logical to use an existing table as a diagnostic table if it is properly layed out. But nooOOOOOOOOooooo! >;) -- Jake (Never thought I'd be mimicking John Belushi. Yuchh!) = +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+