Re: How to load table without log

Adam Sorati wrote: > > Eng: online 7.23.UC1 > OS: AIX 2.4.1 > HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. > DB: 1.3 GIG > > Could someone please advise me of the best way to load > a table without using the logical log. I am getting a long > transaction error and the logical log is currently very large, > 360 MG for a 1.3 GIG DB. > > The database is using log bufferring, and I only are required to > load one or two tables. There may be 2 solutions: 1) split the data-files which you like to load into smaller pieces. 2) Switch off logging. (I do not know how it works for "Online" but in IUS you can use the following way) a) use "onmonitor" -> "Logical-Logs" -> "Databases" where you can select a database (CTRL-B) and switch to "no logging" via (again) CTRL-B. b) load the data into the tables c) Switching back to "buffered logging" is a little more complicated. IUS wants itself to be level-0-backuped before. When you are dumping to tape "/dev/null" ;) this might not be a problem: Try "ontape" to see the possible parameters. "ontape -s -B <database-name>" archives the full system "-s" by default as level-0-backup and sets buffered logging "-B" for the specified database. (oh, it might be that the system needs to be in Quiescent-Mode for archiving&settingLog.) i hope, i could help you, Gert. -- Gert Brinkmann email: gbrinkmann@dimedis.de Software Development tel: 0221/921260-0 dimedis GmbH fax: -99 Habsburgerring 2-12 http://www.dimedis.de 50674 Koeln http://www.RealTimeImage.de