Re: Informix versus oracle

On 29 May 2003 05:17:40 -0700, wumutek@yahoo.com (Vincento Harris) wrote: >Thanks a lot for your answers >Once again I am working torwards qualifying to be a newbie in >Informix Don't have to qualify to be a newbie . . . . it comes naturally . . 8-) >If it helps any I have worked with Oracle up to 9i. >But work on a day to day basis with Oracle 8i. > > >I have support for an informix database but feel uncomfortable calling >support to have something as basic as adding a datafile or even >checking >"alert "logs application logs (assuming I know where they are located) >This begs the question,why not let support do it.The response is I >will like to be weaned someday from support Great! >So information like >1) where to check the log file in informix Some important Informix variables to consider: $INFORMIXSERVER -- points to the current Informix instance $INFORMIXDIR -- corresponds to $ORACLE_HOME $ONCONFIG -- corresponds to $?????? in Oracle -- the ONCONFIG variable points to the configuration file currently active for a given Informix instance. To see where the log file is: vi $INFORMIXDIR/etc/$ONCONFIG -- look for MSGPATH tail $INFORMIXDIR/etc/"filename_corresponding_to_MSGPATH" >2)how to change the sizes of a physical/logical log, dbspace,dbslice >and shared memory will be more than appreciated Physical / logical log / shared memory parametersf -- that information would be listed in the ONCONFIG file. Dbspace -- you add chunks (datafiles) using the 'onspaces' command. >Documentation will have its place >Again thank you for your expert time >Vince If possible, check out the Informix admin class for Oracle DBAs. Of course, training dollars are a bit scarce these days . . . . . John Carlson