Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Ingres Topics / September 2006

Tip: Looking for answers? Try searching our database.

Re: [Info-ingres] Re: Creating a RAW transaction logfile

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Self - 19 Sep 2006 11:34 GMT
Hi Michel

Shutdown the installation, move the current cooked log and cooked
dual logs aside (ie. just rename them to something) then execute
mkrawlog and mkrawlog -dual.

Once the rawlogs are in place and the installation starts and stops
without error then you may remove the cooked logs.

Marty

> Hi,
>
> I think I first have to make the RAW and after that enable DUAL and
> then make the dual RAW.
>
> But if I make just the first RAW logfile i get the follwing error:
>
> Please enter path of raw device file: /dev/rdsk/c1t2d0s0
> Please enter the next path of raw device file or
>  return to end:
>
> Checking size of raw device...
>
> The raw log device contains 1994496 Kbytes.
> mknod: File exists
>
> ----------------------------------------------------------------------
> - |                               ***ERROR*** | | | |  Error linking
> ingres_log.l1 file to raw device. | |
>
> ----------------------------------------------------------------------
> -
>
> Thank you.
>
> Michel
>
> martin.bowes@ctsu.ox.ac.uk schreef:
>
> > Hi Michael,
> >
> > What does the mkrawlog -dual actually say?
> >
> > Errors in the errlog.log?
> >
> > Marty
> >
> > > Hi,
> > >
> > > I tried that also already.
> > > I saw that it was disabled, after destrying it and remake it it
> > > still doens't work.
> > >
> > > Michel
> > >
> > > martin.bowes@ctsu.ox.ac.uk schreef:
> > >
> > > > Hi Michael,
> > > >
> > > > The prior attempt to start the installation when the dual log
> > > > was not raw may have caused it to de-configure the dual log. Use
> > > > cbf and see what the status is.
> > > >
> > > > Marty
> > > > On 18 Sep 2006 at 7:19, michel.mansens@gmail.com wrote:
> > > >
> > > > > Hello,
> > > > >
> > > > > Thanks for the fast reply. But it doesn't work with the -dual
> > > > > option. It still thinks that there is only one transaction log
> > > > > file.
> > > > >
> > > > > Kind Regards,
> > > > >
> > > > > Michel
> > > > >
> > > > > martin.bowes@ctsu.ox.ac.uk schreef:
> > > > >
> > > > > > Hi michel,
> > > > > >
> > > > > > Run mkrawlog with the parameter -dual.
> > > > > >
> > > > > > Martin Bowes
> > > > > >
> > > > > > > Hi,
> > > > > > >
> > > > > > > I enabled dual logging at the installation.
> > > > > > > The normal log has location /install  and the dual log has
> > > > > > > location /gp So both logs are 16mb with the location
> > > > > > > /gp/log/
> > > > > > >
> > > > > > > Now I run mkrawlog (as root) but the program only wants to
> > > > > > > make 1 log a rawlog. I only can fill out the raw location
> > > > > > > for the defualt log and not the dual log.
> > > > > > >
> > > > > > > I get then the error that both logfiles has to be the same
> > > > > > > size.
> > > > > > >
> > > > > > > Kind Regards,
> > > > > > >
> > > > > > > Michel
> > > > > > >
> > > > > > > martin.bowes@ctsu.ox.ac.uk schreef:
> > > > > > >
> > > > > > > > Hi Michel,
> > > > > > > >
> > > > > > > > > How can i create an RAW transaction logfile?
> > > > > > > > >
> > > > > > > > > Do i have the say with the installation of Ingres that
> > > > > > > > > de default transaction logfile is 16mb with location
> > > > > > > > > "/ingres" and later create the transaction logfile
> > > > > > > > > with MKRAWLOG at the new location /log and indicate it
> > > > > > > > > is a raw log.
> > > > > > > >
> > > > > > > > Yep first create the log and dual log as normal 'cooked'
> > > > > > > > logs. Then shutdown the installation.
> > > > > > > >
> > > > > > > > Your systems people then need to create a raw partition
> > > > > > > > on the disk. (one for the primary log and one for the
> > > > > > > > dual log).
> > > > > > > >
> > > > > > > > Then they (as root) execute the mkrawlog command to
> > > > > > > > create the necessary 'stuff' on the raw area for Ingres
> > > > > > > > to use. Plus it installs a hard link in the
> > > > > > > > II_LOG_FILE/ingres/log area that points to the raw
> > > > > > > > location. Ditto for the dual log.
> > > > > > > >
> > > > > > > > IIRC. The program will automatically handle the dual log
> > > > > > > > for you.
> > > > > > > >
> > > > > > > > BTW. If the host has multiple ingres installations you
> > > > > > > > may need to edit the mkrawlog to ensure that each time
> > > > > > > > it 'su - ingres' that it sets the correct installation.
> > > > > > > >
> > > > > > > >  Or do i have to do sometging in CBF.
> > > > > > > > No. You do nothing in CBF.
> > > > > > > >
> > > > > > > > > And do I have to make de RAW mount the samesize as i
> > > > > > > > > want the transaction logfile has to be?
> > > > > > > >     Yes.
> > > > > > > >
> > > > > > > > Martin Bowes.
> > > > > > > > --
> > > > > > > > Random Duckman Quote #116:
> > > > > > > > Cornfed: Duckman daddio - you have ears but you don't
> > > > > > > > listen.
> > > > > > > >         Actually, you don't have ears. I've never
> > > > > > > >         noticed that before. This is really freaking me
> > > > > > > >         out. How do you hear? What holds your glasses
> > > > > > > >         up?
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > Info-ingres mailing list
> > > > > > > Info-ingres@cariboulake.com
> > > > > > > http://mailman.cariboulake.com/mailman/listinfo.py/info-in
> > > > > > > gres
> > > > >
> > > > > _______________________________________________
> > > > > Info-ingres mailing list
> > > > > Info-ingres@cariboulake.com
> > > > > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
> > >
> > > _______________________________________________
> > > Info-ingres mailing list
> > > Info-ingres@cariboulake.com
> > > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
>
> _______________________________________________
> Info-ingres mailing list
> Info-ingres@cariboulake.com
> http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
michel.mansens@gmail.com - 19 Sep 2006 11:58 GMT
Hi,

Thank you for all your advice so far.
Im getting further but now I get a new error:

Formatting raw transaction log...

Unable to format raw transaction log.

This indicates an error if the INGRES/DBMS has already been set up in
this installation.

-----------------------------------------------------------------------

|  The following raw transaction log has been created:
|
|       /gp/ingres/log/ingres_log
|
|  This file needs to be formatted before it can be used.

-----------------------------------------------------------------------

The rcpconfig.log:

!Erase the log files...
!
"rcpconfig.log" [Read only] 488 lines, 28786 characters
!pen file open() failed with operating system error 5 (I/O error)'
!(rcpconfig.c, 1538) ERsend--->'        ::[RCPCONFIG         ,
00732100]: Tue Se
p 19 12:44:06 2006 E_CL0604_DI_BADOPEN Error trying
!to open file open() failed with operating system error 5 (I/O error)'
!(rcpconfig.c, 1541) ERsend--->'        ::[RCPCONFIG         ,
00732100]: Tue Se
p 19 12:44:06 2006 E_DM9012_BAD_LOG_OPEN Error addin
!g a server to the logging system. open() failed with operating system
error 5 (
I/O error)'
!Can't open the log file. This error can be caused by
!any of the following:
!       1) Log file does not exist.
!       2) Incorrect permissions or ownership of log file.
!       3) Incorrect permissions or ownership of executable.
!       4) Logging system busy (ie. acp, rcp, or dbms
!          processes still running
!Unable to open the logging system.

errlog.log:

ADOPEN  Error trying to open file
open() failed with operating system error 5 (I/O error)
       ::[RCPCONFIG         , 00732100]: Tue Sep 19 12:44:06 2006
E_CL0604_DI_B
ADOPEN  Error trying to open file
open() failed with operating system error 5 (I/O error)
       ::[RCPCONFIG         , 00732100]: Tue Sep 19 12:44:06 2006
E_DM9012_BAD_
LOG_OPEN        Error adding a server to the logging system.
open() failed with operating system error 5 (I/O error)
       ::[RCPSTAT           , 00732100]: Tue Sep 19 12:47:34 2006
E_CL0604_DI_B
ADOPEN  Error trying to open file
open() failed with operating system error 5 (I/O error)
       ::[RCPCONFIG         , 00732100]: Tue Sep 19 12:47:41 2006
E_CL0604_DI_B
ADOPEN  Error trying to open file
open() failed with operating system error 5 (I/O error)
       ::[RCPCONFIG         , 00732100]: Tue Sep 19 12:47:41 2006
E_CL0604_DI_B
ADOPEN  Error trying to open file
open() failed with operating system error 5 (I/O error)
       ::[RCPCONFIG         , 00732100]: Tue Sep 19 12:47:41 2006
E_DM9012_BAD_
LOG_OPEN        Error adding a server to the logging system.
open() failed with operating system error 5 (I/O error)

Self schreef:

> Hi Michel
>
[quoted text clipped - 167 lines]
> > Info-ingres@cariboulake.com
> > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
badgirljo@hotmail.com - 19 Sep 2006 16:01 GMT
I've used both 'cooked' and 'raw' transactions logfiles ... personally
i'm not keen on 'raw' transaction log files.

I've also performed tests on both (spanking the transaction log files
e.g. lots of updates, deletes using 2gb transaction log files) i can
hardly see any difference.

Is there any specific reason for using 'raw' transaction log files?
other than *might* be faster ...? are you just using local storage?

Jo.

> Hi,
>
[quoted text clipped - 245 lines]
> > > Info-ingres@cariboulake.com
> > > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
michel.mansens@gmail.com - 20 Sep 2006 06:33 GMT
The client wants this. I don't have a choise.

badgirljo@hotmail.com schreef:

> I've used both 'cooked' and 'raw' transactions logfiles ... personally
> i'm not keen on 'raw' transaction log files.
[quoted text clipped - 257 lines]
> > > > Info-ingres@cariboulake.com
> > > > http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres
martin.bowes@ctsu.ox.ac.uk - 20 Sep 2006 09:04 GMT
Hi Jo,
> I've used both 'cooked' and 'raw' transactions logfiles ... personally
> i'm not keen on 'raw' transaction log files.

I suspect that there is very little performance difference between the
raw or cooked log. I've never bothered trying to measure it but those
that have normally quote figures under 10% in favour of raw logs.

But there is one killer advantage of a raw log. Its not part of the
filesystem and so it can't be backed up by dump, hence it can't be
restored from a backup. Having seen the carnage that ensued when
this was accidentally done on a system, I go for raw logs wherever the
OS supports them.

However, against this is that the area on disk reserved for the raw log
can be overwritten by a systems programmer who forgot that it was
reserved for the raw log. And yes, I've seen that happen too! Boy was
he popular.

Martin Bowes
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.