f



LOG FILES inonconfig file

Hi all,

I am new to informix.

I would like to know how to calculate the rootdbs

1) Is it (Logfiles x log size) + (PHYsical log) + some schemas ?

2) Can i have a small value of Log file log size and physical log
during initialization and increase after the initialization by just
restarting the server.( i will increase the rootdbs by adding a large
chunk from other disk)

3) i have a part of roodbs on one LV (logicalvolume) and other on ther
LV and VG also.

4)If i add a new chunk to rootdbs ,do i need to make any change to
onconfig file


Thanks.

0
doitman
11/9/2006 3:58:49 PM
comp.databases.informix 16083 articles. 0 followers. Post Follow

1 Replies
599 Views

Similar Articles

[PageSpeed] 22

doitman wrote:
> Hi all,
> 
> I am new to informix.
> 
> I would like to know how to calculate the rootdbs
> 
> 1) Is it (Logfiles x log size) + (PHYsical log) + some schemas?

Unless you want to place your logical and physical logs in one or more 
separate dbspaces - which is recommended BTW - that's about right.  If you 
will be moving the logs after initialization to different dbspaces you only 
have to allocate space for the initial 6 logical logs and the default 
physical log.

> 2) Can i have a small value of Log file log size and physical log
> during initialization and increase after the initialization by just
> restarting the server.( i will increase the rootdbs by adding a large
> chunk from other disk)

Yes, you need a minimum of 3 logical logs in order to initialize the server 
and the default/sample ONCONFIG file creates six for you if you don't modify 
it.  Once the server is initialized you can create new logical logs in the 
same or a different dbspace then drop the original ones that were in rootdb 
space.  This can be done with the server online you just have to use onmode 
-l to switch the current log to one of the new ones and archive the existing 
logs before being able to drop them.

Moving the physical log is actually easier.  Just modify the location and/or 
size in the ONCONFIG file and bounce the server.  The server knows where the 
orginal physical log is and will use it for startup recovery if needed and 
then drop it and create the new physical log.

> 3) i have a part of roodbs on one LV (logicalvolume) and other on ther
> LV and VG also.
> 
> 4)If i add a new chunk to rootdbs ,do i need to make any change to
> onconfig file

No, only the first rootdb chunk needs to be documented in the ONCONFIG file.

> 
> Thanks.
> 

Art S. Kagel
0
Art
11/9/2006 5:59:57 PM
Reply:

Similar Artilces:

Restore of database file and log file
Hi, I have a Sybase Adaptive Server Anywhere 7 database running. I have a database file that is dated june 12, 2003 I have the database log file from yesterday. The backupsoftware have not backed up the database file since june 12 because it did not back up open files. So, can i merge my database file frome june 12 and my logfile from yesterday and have all the changes since june 12 committed ? If, so how do i do it ? Can't see any tools in the Sybase Central that can help me out... This is a library database and my librarian is not happy at the moment..... ...

RE: LOG FILES inonconfig file
> -----Original Message----- > From: informix-list-bounces@iiug.org=20 > [mailto:informix-list-bounces@iiug.org] On Behalf Of doitman > Sent: Thursday, November 09, 2006 8:59 AM > To: informix-list@iiug.org > Subject: LOG FILES inonconfig file >=20 > Hi all, >=20 > I am new to informix. Welcome to the group. Please include OS version, hardware and IDS version when posting questions; it really helps. Check out the link below; it lists all of the Informix documentation currently available from IBM: http://www-306.ibm.com/software/data/informix/pubs/library/ids_100.html >=20 > I would like to know how to calculate the rootdbs >=20 > 1) Is it (Logfiles x log size) + (PHYsical log) + some schemas ? >=20 > 2) Can i have a small value of Log file log size and physical log > during initialization and increase after the initialization by just > restarting the server.( i will increase the rootdbs by adding a large > chunk from other disk) >=20 > 3) i have a part of roodbs on one LV (logicalvolume) and other on ther > LV and VG also. >=20 > 4)If i add a new chunk to rootdbs ,do i need to make any change to > onconfig file Chunks can be added at any time and they can be spread across different disks, logical volumes and filesystems; no changes to the ONCONFIG file are needed. Mike Badar ESRI Professional Services 1 International Ct. Broomfield, CO 80021 mbadar@e...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV ...

Data/Transaction log files for two databases have same file name
We have two db's. One live and one test. When I right click on the live one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\LIVE.MDF When I right click on the test one in SQL Enterprise Manager and select properties -> Data Files -> File Name is LIVE.MDF Location is F:\Data\TEST.MDF Same thing applies to Transaction log files too. My concern is File Name is same in both the above cases even though the location is different. What are the consequences of this. Thanks for your help GVV Girish (kattukuyil@hotmail.co...

file.exe file generation from file.m file
How to generate application (*.exe) file from *.m file, which has lots of graphics. Program was written for image watermarking by using image processing toolbox. I want to send this program some where else but with out sowing the program codes. By this *.exe no need to use matlab6.5 platform. Also tell me How to generate *.p file from *.m file Which is hide the code to user but for run this program need matlab6.5 Please give me some idea about it. it is very urgent for me. I will be very great full to you "Biswajit Kar" <hibiswajitkar@rediffmail.com> wrote in message ne...

log file sync , log file parallel write
Hi , my top wait list shows 2 events , log file sync and log file parallel write in 1 hour. During this time , the db server created 370,594 bytes redo per second. the docs say that high value of both log file sync and log file parallel write indicates io problem . How can we decide whether below numbers are close to each other or not? If it is not possible to change the application and eliminate the unnecessary commits (such as sap) , how can lg file sync be decreased? Kind Regards Load Profile ~~~~~~~~~~~~ Per Second Per Transaction ...

Choosing log file destination in logging configuration file
Hey, I have a sort of petty-neurotic question, I'm kinda pedantic and like to keep my log directories clean, and this thing is bothering me to the point of actually posting a question (couldn't find any post about this..). My application has two types of components: daemons and regular ones that are run every on crontab. Because the log structure is very similar, I want both to use the same logging configuration file. For clarity, I want all of the files to have the date as part of the filename. The TimedRotatingFileHandler has it built in (once it rotates), and I found a dirty hack...

whiel log file is monitoring, if that log file is truncated?
if new line added at the end of file , I can read that added line as follow. while reading a file , if someone run command such as "cat /dev/null > /tmp/a.log" after that ,new added line will be added from first line. and then I can't read new added line... I think 1) file pointer is at the end of file, but when someone runs "cat /dev/null> /tmp/a.log" , file is empty... 2) file handle has been chagned? I'd like to know , even if someone runs cat command I want to read new added line without stop is there a way to solve that problem? ...

Log Files and Results Files
I am seeking an opinion on what goes in each file in an automated test environment. I have two types of data: 1. Test Execution Outcomes, Case Data Values, etc. i.e. the outcome of the test and enough data to repeat the test. (quite a bit of data) 2. Detailed test execution data that would be used to investigate failures and unexpected incidents but that is not referred to if the tests pass. (Lots and lots of data) I have two files: a. Log file. b. Results file. What data set goes into what file? I am asking to help resolve a "discussion" in the office. Thanks Gle...

log file sync vs log file parallel write
Hello all, While investigating performance problems in a database I discovered that the 'log file sync' wait event is almost always in the top 5. (I am looking at the statspack datat) Calculating the ratio of the average wait time of the 'log file sync' and the 'log file parallel write' gives a ratio of 10. Does someone know why this may happen? Regards Hans-Peter On 3 okt, 12:31, HansP <hans-peter.sl...@atosorigin.com> wrote: > Hello all, > > While investigating performance problems in a database I discovered > that the 'log file sync' ...

Lag Time Between Log File Switch and Archive Log File
Colleagues: Has anyone experienced lag times after an automatic log switch happens and the time the archive log file appears in the archive log directory? I am running Oracle9i (9.2) on Solaris/UNIX. For additional information, below are SQL results of time differences between when the log switch happened and when the archive log file was written to disk. I welcome all ideas at your earliest convenience on this and thanks in advance. Donna BYTES NEXT_TIME COMPLETION_TIME LAG ---------------- -------------------- -------------------- ---------- 1,048...

file extention from file file location
Hi, I am new to perl (only working on this one problem) but I program in other languages. We have an upload script written in cgi. Can anyone tell me how to get the file extension from the variable $File1 (actual file location on uploader's computer) then find out if it is equal to "txt" Thanks in advance for not telling me to read the manual. Ron -- PLEASE NOTE: comp.infosystems.www.authoring.cgi is a SELF-MODERATED newsgroup. aa.net and boutell.com are NOT the originators of the articles and are NOT responsible for their content. HOW TO POST to co...

Iteration through File.file? misses entries for which File.file?(entry) == true
Hello everyone, I'm new to Ruby, so I'm most likely making an elementary mistake. However, searching Google didn't help me find my answer, and after mucking around with irb I still haven't figured it out. I wrote a method that was intended to take all of the files in a given directory and put them into an array. Here's the code I wrote: def getFiles(dir) pwdFiles = Array.new Dir.foreach(dir) do |entry| pwdFiles.push(entry) if File.file?(entry) == true end end This works fine when called on the working directory --- that is, getFile...

how data file and log file grow?
Greetings, The following shows how the Properties of a database look like: Data Files: File Name: student_dat Location: e:\data\MSSQL\Data\student.mdf Space allocated (MB): 62 'Automatically grow file' checked File growth: 'By percent 10%' checked Maximum file size: 'Unrestricted file growth' checked Transaction Log: File Name: student_log Location: e:\data\MSSQL\Data\student.ldf Space allocated (MB): 52 'Automatically grow file' checked File growth: 'By percent 10%' checked Maximum file size: 'Unrestricted file growth' checked The physical...

Writing a log file from an obey file
In message <51a5dbfe09news*@Torrens.org.uk> "Richard Torrens (News)" <News+15019@Torrens.org.uk> wrote: > Lua looks attractive, but it's a long learning curve for a single job! Here is the single job then: Write the following in a text file called "writelog": do local var,logfile,err = os.getenv,arg[1],"Cannot open " local log = assert(io.open(logfile,"a+"),err..logfile) log:write("\n", var "Sys$Time"," on ",var "Sys$Date","\n", var "cycle_No&...

LOG file problem: multithreaded in same file
hi, i have stumbled into a "little" problem - i have a multithread application, with multiple DLL's which write logentries into a set of logfiles. The problem is that in some cases several threads are accessing the same logfile, some of theese threads are placed in DLL's (and worse, some threads are placed in DLL's loaded by DLL's :) ). This is ofcourse resulting in a logfile that occasionally contains mixed blocks from different threads, which messes up the logfile. Under normal circumstances in a multithreaded - single file enviorment i could s...

Writting to file from Database-Files are empty
Hi everyone.. I've posted message couple of weeks ago, and I am greatful to your help. However, I wrote the method, and it does produce the 4 files, however all the files it produce are empty.. can anyone help.. This is the method: public void writeToFile(String fileName, String viewId) { FileOutputStream fileOut = null; PrintStream myOutput; try{ fileOut = new FileOutputStream(fileName); }catch (FileNotFoundException IOE){} //write to file1- start of Ali Changes 31/01/2006 try{ myOutput = new PrintStream(fileOut); query = "select * f...

File format of aracle database files?
Hi, I wonder, if there is published any information about the oracle file format (where the tables and records are stored). Can someone give me a hint? Thank you! Thilo Immel Thilo Immel wrote: > Hi, > > I wonder, if there is published any information about the oracle file > format (where the tables and records are stored). > > Can someone give me a hint? > > Thank you! > > Thilo Immel > http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c03block.htm#2528 Lots of other good, free documentation available there too! --Mark Bole Mark, >Thilo Immel wrote: > >> Hi, >> >> I wonder, if there is published any information about the oracle file >> format (where the tables and records are stored). >> >> Can someone give me a hint? >> >> Thank you! >> >> Thilo Immel >> > >http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c03block.htm#2528 > >Lots of other good, free documentation available there too! > Thank you Mark! Unfortunatly I have to log in. Ok, so I want to sign up. But the sign up form always says that there is a fault in postal code (I am coming from germany, and I filled the form properly). Fakt is: I can not sign up! Ok, thougth I send an email to oracle and tell them this problem (there is a link contact us at the sign up form). Bu...

tailing multiple files in to log file
I have over 60 seporate files that I would like to tail the last 10 lines of and ,erge in to one file. i would like to write a shell script to do this but am having fun knowing where to start. i have looked at the manual for tail and can see that it can do muliple files but will i have to name all of the seporate filenames or could i use a dos like switch of *.txt for these files and then tail the output to the file i want. any help gratefully recived a windowz dos freek ! ! "sally.bridges@gmail.com" <sally.bridges@gmail.com> writes: > I have over 60 seporate files tha...

detach database, attach database without log file
If I detach a database on a server, then attach the database with a single file only using the data file...will I lose any transactions that were in the original log file? There is a debate going on here at work where some people think that during the detach, transactions in the log file are saved to the data file. Thanks! Hi You will not loose any committed transactions. Uncommitted transactions will normally be rolled back rolled back even if you attached the log file!! If this did happen it would be indicated in the SQL Server log file. John "DBA" <kaylisse@yahoo.com> ...

Database Log-file
Hello, my db2 V8.1 stopped just without any reason. Now I am wondering where I con find a log file which explains this behaviour... I cant find anything in the instance directory. The database is running on a Linux system Any help would be appreciated. Greetings, Jan The db2diag.log should be under the instance owner's directory, in sqllib/db2dump directory. If it's not that way on your system, you may have to search the whole instance owner's directory structure. But db2diag.log will be in there somewhere! It tells you what DB2 thinks happened when it cr...

log file sync vs log file parallel write probably not bug 2669566
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" &qu...

log file sync vs log file parallel write probably not bug 2669566 #3
This is a continuation of a previous thread about =91log file sync=92 and =91log file parallel write=92 events. Version : 9.2.0.8 Platform : Solaris Application : Oracle Apps The number of commits per second ranges between 10 and 30. When querying statspack performance data the calculated average wait time on the event =91log file sync=92 is on average 10 times the wait time for the =91log file parallel write=92 event. Below just 2 samples where the ratio is even about 20. "snap_time" " log file parallel write avg" "log file sync avg" &qu...

Archive logs files accumulating on my Oracle log mode Database
>From what I understand is that an Oracle log mode Database is the recommended configuration for a production database. However, the problem we have is that Archive Logs files in the ..\RDBMS\ directory are accumulating daily which has implications when you have limited disk space. How should these Archive log files be maintained? ie when should they be deleted from the system? is there an automated procedure which will remove the log files on a weekly basis? I understand that there are two ways for performing a backup of the oracle database, 1) cold backup (requires the oracle database...

Web resources about - LOG FILES inonconfig file - comp.databases.informix

Resources last updated: 2/27/2016 8:46:11 PM