Help me! level-0 takes 8 hours
Posted in 1994
Dear users, We have some problems with the level-0 archive processing time (8 hours) We have this scenario - A NCR 3450 with a 5Gbytes Online database (Online 5.01) - One table in the DB has 3.5 Gb. - One level-0 archive takes more than 8 hours - Two QIC 525 Mb tapes devices 1) In order to reduce the level-0 execution time, we are looking for a DAT 4Gb unit tape. Does anyone know another tape device better (faster) than the DAT 4GB? 2) The 3.5Gb table receives 25000 insert every day, but never receives an update. Obviously, this table is responsible for the level-0 archive execution time. I want not to include the statics rows of the 3.5 Gb table in a level-0 archive. Is it posible? Anyone knows how to do it? We tried putting the big table in another Online system. The results: level-0 archive processing time is excelent the performance of the applications is not well. Thanks in advance Nacho -- Ignacio Bisso nacho@patan.pnudreg.pe