unlogged database

unlogged database

Post by Roberto Dircio Palacios-Maced » Sun, 31 Dec 1899 09:00:00



i have a big database, unfortunately it isn't logged, so I want it to be
on log mode ansi, how to?. I'm thinking about re-cerating it. =(

thanx

____roberto dircio palacios macedo__________________________________
  __      |                    |
 /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
 \/_/\_\  |  Cooperative       | tel:(22)292431

 \/_/ ict |  UDLA-P, Mexico.   |
__________|____________________|____________________________________

 
 
 

unlogged database

Post by Roberto Dircio Palacios-Maced » Sun, 31 Dec 1899 09:00:00


ok, i tried it from the OS prompt.. it kept looking for the tape
physically. So i decided to change it in onmonitor. At the
"parameters/initialize" menu, settings appear like this...

 INITIALIZATION: Make desired changes and press ESC to record changes.
  Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level help.
                                DISK PARAMETERS
Page Size     [    2] Kbytes                                  Mirror
[N]  

Tape Dev.     [/dev/rmt/0n                                             ]
Block Size    [        16] Kbytes           Total Tape Size [     10240]
Kbytes
Log Tape Dev. [/dev/null                                               ]
Block Size    [        16] Kbytes           Total Tape Size [     10240]
Kbytes
Stage Blob    [                  ]

Root Name     [rootdbs           ]                Root Size [    100000]
Kbytes
Primary Path  [/export/home/sw/informix/etc/online_root                ]
                                                Root Offset [         0]
Kbytes
Mirror Path   [                                                        ]
                                              Mirror Offset [         0]
Kbytes
Phy. Log Size [      1000] Kbytes             Log. Log Size [      1500]
Kbytes
                                          Number of Logical Logs [    6]

but changing the tapedev to /dev/null gives this scary warning:

continue (y/n)
This step will overwrite your existing primary/mirror cooked ROOT DBspace.

shall i continue?

thanks. =O


> You can do the following:

> set TAPEDEV = /dev/null

> ontape -s -L 0 -U <dblist>    # Creates an unbuffered log database
> ontape -s -L 0 -A <dblist>    # Creates an ansi logging database

> Steve Romankiw


> > i have a big database, unfortunately it isn't logged, so I want it to be
> > on log mode ansi, how to?. I'm thinking about re-cerating it. =(

> > thanx

> > ____roberto dircio palacios macedo__________________________________
> >   __      |                    |
> >  /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
> >  \/_/\_\  |  Cooperative       | tel:(22)292431

> >  \/_/ ict |  UDLA-P, Mexico.   |
> > __________|____________________|____________________________________

____roberto dircio palacios macedo__________________________________
  __      |                    |
 /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
 \/_/\_\  |  Cooperative       | tel:(22)292431

 \/_/ ict |  UDLA-P, Mexico.   |
__________|____________________|____________________________________
Just for the sake of it make sure you're always frowning
it shows the world that you have substance and depth.  Tennant/Lowe
____________________________________________________________________

 
 
 

unlogged database

Post by Art S. Kage » Sun, 31 Dec 1899 09:00:00



> i have a big database, unfortunately it isn't logged, so I want it to be
> on log mode ansi, how to?. I'm thinking about re-cerating it. =(

You can change the logging mode of a database only during an archive
process.  Using ontape:

ontape -s -L 0 -A mydatabase    # Add ANSI mode to database mydatabase.
ontape -s -L 0 -B mydatabase    # Add Buffered Informix logging.
ontape -s -L 0 -U mydatabase    # Add unbuffered Informix logging.
ontape -s -L 0 -N mydatabase    # Remove logging from database.

Multiple databases are space separated and the Loggin flag (-A, -U, -B,
-N) must be the last flag.  BTW, though I am sure Jonathan Leffler can
make a good case for his favorite logging mode (ANSI) I find that ANSI
mode is more trouble than it is worth and tend to use Unbuffered
Logging.

Art S. Kagel

 
 
 

unlogged database

Post by Roberto Dircio Palacios-Maced » Sun, 31 Dec 1899 09:00:00


good thing you guys are around. I would've made a real disaster. I did as
robert said. It went smooth with /dev/null as tapedev... a slick buffered
log database is the result.

        thanks.


> Don't do it!!!!!!!!!!!!!!!!!!!!!!!!!!!  This will overwrite or "initialize"
> your database instance.  You will lose all data!  You can easily change the
> tape device to /dev/null in your onconfig file and then simply bounce your
> engine (onmode -k followed by an oninit).  I'm not sure if this is what you
> really want to do anyway since you are just trying to turn on logging.  To
> change the logging status of a database you must do a level 0 archive:

> ontape -s -B dbname

> To turn logging off:

> ontape -s -U dbname
> --
> Regards,
> Robert



> > ok, i tried it from the OS prompt.. it kept looking for the tape
> > physically. So i decided to change it in onmonitor. At the
> > "parameters/initialize" menu, settings appear like this...

> >  INITIALIZATION: Make desired changes and press ESC to record changes.
> >   Press Interrupt to abort changes.  Press F2 or CTRL-F for field-level
> help.
> >                                 DISK PARAMETERS
> > Page Size     [    2] Kbytes                                  Mirror
> > [N]  

> > Tape Dev.     [/dev/rmt/0n                                             ]
> > Block Size    [        16] Kbytes           Total Tape Size [     10240]
> > Kbytes
> > Log Tape Dev. [/dev/null                                               ]
> > Block Size    [        16] Kbytes           Total Tape Size [     10240]
> > Kbytes
> > Stage Blob    [                  ]

> > Root Name     [rootdbs           ]                Root Size [    100000]
> > Kbytes
> > Primary Path  [/export/home/sw/informix/etc/online_root                ]
> >                                                 Root Offset [         0]
> > Kbytes
> > Mirror Path   [                                                        ]
> >                                               Mirror Offset [         0]
> > Kbytes
> > Phy. Log Size [      1000] Kbytes             Log. Log Size [      1500]
> > Kbytes
> >                                           Number of Logical Logs [    6]

> > but changing the tapedev to /dev/null gives this scary warning:

> > continue (y/n)
> > This step will overwrite your existing primary/mirror cooked ROOT
> DBspace.

> > shall i continue?

> > thanks. =O


> > > You can do the following:

> > > set TAPEDEV = /dev/null

> > > ontape -s -L 0 -U <dblist>    # Creates an unbuffered log database
> > > ontape -s -L 0 -A <dblist>    # Creates an ansi logging database

> > > Steve Romankiw


> > > > i have a big database, unfortunately it isn't logged, so I want it to
> be
> > > > on log mode ansi, how to?. I'm thinking about re-cerating it. =(

> > > > thanx

> > > > ____roberto dircio palacios macedo__________________________________
> > > >   __      |                    |
> > > >  /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
> > > >  \/_/\_\  |  Cooperative       | tel:(22)292431

> > > >  \/_/ ict |  UDLA-P, Mexico.   |
> > > > __________|____________________|____________________________________

> > ____roberto dircio palacios macedo__________________________________
> >   __      |                    |
> >  /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
> >  \/_/\_\  |  Cooperative       | tel:(22)292431

> >  \/_/ ict |  UDLA-P, Mexico.   |
> > __________|____________________|____________________________________
> > Just for the sake of it make sure you're always frowning
> > it shows the world that you have substance and depth.  Tennant/Lowe
> > ____________________________________________________________________

____roberto dircio palacios macedo__________________________________
  __      |                    |
 /\_\__   |  Interactive and   | http://ict.udlap.mx/people/roberto
 \/_/\_\  |  Cooperative       | tel:(22)292431

 \/_/ ict |  UDLA-P, Mexico.   |
__________|____________________|____________________________________
Just for the sake of it make sure you're always frowning
it shows the world that you have substance and depth.  Tennant/Lowe
____________________________________________________________________
 
 
 

unlogged database

Post by Art S. Kage » Sun, 31 Dec 1899 09:00:00



> good thing you guys are around. I would've made a real disaster. I did as
> robert said. It went smooth with /dev/null as tapedev... a slick buffered
> log database is the result.

You could have changed it on the fly using onmonitor.  Just instead of
going into the parameters submenu go into Logical-Logs submenu and
select Tape-Parameters and change it there.  This will not attempt to
initialize the engine as the Parameters->Initialize screen does.  As
you discovered the engine does not reread the ONCONFIG file for the
LTAPE parameters when ontape/onbar runs as it does do for the TAPE
parameters.  These must be changed in the ONCONFIG file but also in
shared memory.  Only onmonitor can do that using the method above.

Art S. Kagel

 
 
 

1. Using Delete and wanting unlogged

I have SQL server 6.5 running on NT server 4.0 -

I have a 3 million+ row table, and I am wanting to archive off some records.

I created a new database and used a non-logged "select into" to get the
records off that I want to archive.

I then backed this database/table off to tape,  and deleted it.

Now I need to get the records off the original table.

During the course of running a "delete .. where" statement,  my syslogs
filled up,  even though I checked truncate log on checkpoint.

Has anyone out there done anything similar, and discovered a better way?  I
need help !!!!

Thanks in advance.
Steve Rogers
 (remove the "saveme" to reply)

2. pgsql/contrib/start-scripts freebsd linux

3. Using Delete and wanting unlogged PART II

4. Populating a VB 5.0 combobox

5. Unlogged transactions

6. The Slippery Slope, Smaller Transactions = Uglier Code?

7. What are unlogged transactions

8. ODMG-93 Standard - Where can I find it?

9. Unlogged transactions

10. SQL 6.5: Determining whether unlogged changes have taken place

11. dbimport unlogged

12. logical log entries for unlogged db

13. databases and how to identify system databases rather than user databases