Oninit® Archive
Results for “LOGFILES”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
Error in COMMIT WORK when trying to add a chunk
@Jacob, I may be misremembering, or maybe things have changed in recent versions of Informix, but in general, it is better to have several smaller logical logs than a few (or a single) large ones. This is because the LTXHWM and LTXEHWM percentages are based not on the percentage…
Need help for Usage of "UTL_FILE_GET_LINE"
Hello, When I use UTL_FILE_GET_LINE I always get the error: (EXC04) - Message cannot be found. Version 15.0.0.2 on Ubuntu. Trace shows, that the file is open: execute function informix.utl_file_is_open[procid=613] ( arg[0] = 0 ) expression: (select (<procedure> utl_file_is_open, …
How long has a transaction or query been running?
Hi try with something like select dbinfo('utc_to_datetime', starttime) from systxptab select dbinfo('utc_to_datetime', begintime) from systxptab A rough estimate is in the message logfile: "begin_logpos between logpos of two checkpoints in this logical log onlog output for the lo…
Data or date-time columns in oncfg_(servername).(servernum)
One more info from sysmaster.sql: create table informix.syslogfil { Internal Use Only } ( address int8, { address of logfile structure } number smallint, { logfile number } flags smallint, { …
Changing DBSPACETEMP run-time
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, is there a way to change DBSPACETEMP for a session inside 4GL? ------------------------------ Sincerely, Dennis ------------------------------…
Logical Logs - Flags and backups
Hi Mark, The "B" in the 3rd position means that the logical log has been backed up, which is good! The log backup will be triggered by the script referenced in your onconfig file with the parameter ALARMPROGRAM. It is called each time a logical log is filled or logical log is sw…
Logical Logs/Physical logs
IDS 12.10.FC12 Solaris 10 1/13 If you had to choose having a separate dbspace for logical logs or physical logs, but not both, which would you choose? I'm uncertain which is likely to generate more I/O. Thank you. Regards, DG ------------------------------ David Grove -----------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Spaces and Spindles: Thought Experiment
For extra credit, consider having two dbspaces for logical logs (odd and even). DG…
Number of logical logs growing ?
This is what I've found in logs at the time of crontab ontape -a jobs ( no one was connected to the db, neither no jobs were usign it ): 17:20:01 Logical Log 47416 - Backup Started 17:20:01 Logical Log 47416 - Backup Completed 17:20:01 Logical Log 47417 - Backup Started 17:20:01…
Reading logical logs of informix
Is it possible to find what was being written in database at a certain point of time by reading logical-logs?…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
IDS not writing to online.log
Hi Art, tried that already. When I add a logical log I will see the corresponding entry in online.log and a checkpoint, and nothing happens after that. And I can't switch the logical logs because onmode -l is not working…
Long transaction problem
When IDS will used up all the logical log? i.e. the log file below the current logical log file has open transaction also . thanks for your time.…
Need assistance on spreading logical logs
IDS 11.70 I need advice on how to setup a spread of logical logs over at least two disks. the idea behind this is to enable one logical log to be backed up and another being used which may improve performance.…
Mutex logs on logical log flip
IDS 11.50 on Solaris We've only just started noticing this odd occurrence. I t only just have started happening or it may have been happening for ages but there's more focus upon it now. Our customer's monitoring was detecting occasional periods of slow queries, perhaps persist…
IDS 12.10.FC- Installation
Hi, Thank you for your advice. We plan to upgrade our informix version into our new server (non place migration), Which best method we can use to migrate data to reduce our downtime? Right now, i think we can use dbexport & dbimport. "For the rootdbs size issue, what have you d…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
IDS 12.10 on Ubuntu 14.04 LTS Server
Hi, I'm installing Informix DS Innovator-C Edition on Ubuntu 14.04 LTS Server. After the installation I get a message some warnings/errors happened during install (logfile). However the server is working fine. - Are there any specific settings I need? - Do I need to add/change…
Root db space fills up
The logical and physical logs reside in there own db space.…
logical logs location
Run the following query in sysmaster database. it will give the logical log number, chunk number and dbspace name where logical log is located. select number logfile, c.chknum CHUNK, d.name DBSPACE from syslogfil l, syschunks c, sysdbstab d where c.chknum = l.chunk and c.dbsnu…
RSS not working
Have you tried changing: LTAPEDEV /llog/drcallog to LTAPEDEV /dev/null to see if the logical log backup is causing the message?…
Logical log size
Hi, the size of a single logical log file should be set in a way to not lose much data when it comes to the most severe condition that you would have to restore a database system which is down and inaccessible (so you cannot get any more the active log using salvage logs). We h…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
DYNAMIC_LOGS=2 Functionality?
Hi, Silly question ... do you backup your logical logs? If you do want to backup your logs, then consider using ALARMPROGRAM to backup logical logs when complete (using onbar or ontape) - that way you should not encounter full logical logs because they are not being backed up. …
Logical log backup
Folks, IDS11.50FC8 , Linux We have a couple of boxes , all are setup to do automatic logical backup. Once the current log is full, it triggers the alarm procedure to start a backup. It works great. But, The interesting thing is, some servers do not always backup a full logical…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
some questions about Art's utils3_ak to backup logical log to disk
os: redhat 5.x ids version : 10.uc3 Thanks to Art's tool utils3_ak to backup logical log to disk. I copy log_full.sh to $INFORMIXDIR/etc and modiy LTAPEDEV , ALARMPROGRAM according to the instructions. It work now! I have 2 questions about it 1. How to do the restore from the …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Insufficient buffer size for error message
Hello, We are still working with IDS 7.31 on Windows NT4, we are about to start a project to migrate. But I have a question about the version we are actually working with. I notice more and more often the following message in the logfile: "Insufficient buffer size for error mes…
Add more logical logs in IDS 9.4
Hi All, I'll be performing adding logical logs into our existing DB. My question are the following: 1. Do the DB needs to be in quiescent state? i believe, there's no need at all. Once i have added the new dbspaces to be used by the logical logs, i will drop the existing ones …
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Any resolution steps for this failed llogdbs that
IDS: IBM Informix Dynamic Server Version 11.50.FC9W1X7 OS: Sun Microsystems Inc. SunOS 5.10 Generic January 2005 I'm having the Systems Admin to review the disk now. 14:13:25 Assert Warning: I/O error, Primary Chunk '/ifmx/ciboodle/chunks/llogdbs_4' -- Offline 14:13:25 IBM Info…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
non-log and logical log buffer
Hi, If a database is non-log, do update/insert/ go into the logical log buffer? thanks for your time.…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Restore + Logical log - caution
The last weeks I discovery a behave of the engine what is something new for me. I believe others will be surprised too... IFX 11.50 FC9 When you restore an archive with logical logs , maybe you needed the files/tapes of logical logs backuped before the Archive Level 0. The rea…
CLR vs Long Transactions...
Immediately backing up your log doesn't automatically make it available for re-use. A long transaction is a function of how many logical logs a transaction spans (stays open) with respect to the amount of logical logs you have defined. In your situation every time you do a log sw…
Long transaction
Hi, when long transaction being rollback, could others execute SQL select that don't write logical log? thanks.…
Issues after upgrade
Hi, I have error messages after the upgrade from 7.31 to 11.5 In 7.31, the output of oncheck -pe was: ... LOGICAL LOG Pages - Log 52 456063 8000 LOGICAL LOG Pages - Log 53 464063 8000 LOGICAL LOG Pages - Log 54 …
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
Tool to estimate the size of an index
Sorry, I forgot to provide the version of the installation: IBM Informix Dynamic Server Version 11.50.FC4 Operative System: AIX Version 6.1…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Display contents of Logical Log
Is there a way to display the contents of the logical logs if the LTAPEDEV parameter is set to backup the logical logs to a directory? (LTAPEDEV /informix11/inflog) I had a look at the onlog command and in that the -d switch accepts the tape drive path. Appreciate your response…
AIX 5.3 IDS 11.50 FC5 - Performance Advisory
Have any of you experienced this? In reviewing the online.log, I discovered that AFTER a system reboot, and ONLY AFTER a system reboot, the first time the "Auto Update Statistics Refresh" begins, the following performance advisory is recorded. The Backup occurs nightly, the AUS …
Long Transaction Despite DYNAMIC_LOGS = 2
Clifton, my inputs are as followings: The transaction by the user "ifxcmgt" spanned 2.2 GB (LTXHWM=70%) out of 3.1 GB total logical log dbspace (~33000 KBx100 or 3.1 GB); therefore, it was defined as a long transaction and was rolled back. Transaction rollback and other process…
Re: Upgrade from 9.4 to 11.10
One thing I noticed is you have lots of little logs - 85 12M logs for a total of 1Gig. IDS 11 prefers larger log files so that it does not fill and switch too quickly (which might occur during the batch processes). It will give you a warning in the alert log when/if that happen…
nsrmm: Invalid pool name
By Luck i could solve this prob myself.. I did change in ONCONFIG to ISM_DATA_POOL ISMDiskData ISM_LOG_POOL ISMDiskLogs Bounced the engine and ran ism_startup -init once again. Then i tried to add ism_op -label /infmxtmp/infcert/dbspaces -pool ISMDiskData -volume ISMData ism_o…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
how to free up logical logs
Hi All, I've encountered problem on logical logs once again... I'm using onbar on backing up the logical logs and dbspaces. Unfortunately, the netbackup failed and causing the "logical logs" full. Q: what is the correct solution, without losing the logical logs? Is there any wa…
ontape -c
I use 'ontape -c ' to backup the logical log, if the 'ontape -c' process was terminated abnormally, for example, the machine crash or it was killed by others, do anybody know if I could restore those logical log sucessful?…
Logical logs backup
Hi Martin, Thanks for your response! Correct me if my clarification is wrong! At one point of time, the status of the logical logs is Logical log 4 to 7 -> U_B__ Logical log 8 -> U_C_L Logical log 9-13 -> U_B__ All the logical logs are 100% full When i did a level 0 backup, th…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Logical Log Files are Full -- Backup is Needed
Okay, looks like setting LTAPEDEV to '/opt/app/informix/tmp' did work (atleast for one log!) I was able to restart the server, and run 'ontape -a' again to complete all backups. I wonder why it had that hiccup though... Incidentally, whenever I change the parameter LOGFILES to …
Reducing logical log space
I'm looking for reassurance, really ... IDS 10.0FC8 on HP-UX 11.31. HDR running. My customer is running out of disk space on its production system, and cannot provide any more at all for Informix for a couple of weeks (don't ask!). As the application dbspaces will likely not l…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
Extracting logical logs from a level1 archive ?
Is it possible to extract the logical logs from a level1 archive to use for rolling forward ?…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
Location of physical and logical logs
This may seem like a bit of stupid question but how do I find out in which dbspace the logs are on a system I didn't set up? Thanks -- Regards Scott Newton | R&D Solution Specialist | Integral Technology Group Ltd 95 Ascot Ave, Greenlane | PO Box 302313, North Harbour, North Sh…
Re: Logical Log files MISSING
Bigger logical log files?…
Logical Log files MISSING
Hello Ive checked the online.log file for one of the missing log 20084 23:12:22 Logical Log 20083 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20084 Complete, timestamp: 0x8e06d245. 23:12:22 Logical Log 20083 - Backup Started 23:12:23 Logical Log 20083 - Backup Comple…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
Understanding the Logical Log Usage
Am using version 10.00.UC7X1 and have a few *basic* questions on the usage of the logical log file. The database has a logging mode of unbuffered logging with a page size is 2048 bytes (as returned by onstat -b). I have 3 log files with each file being 5000 KB in size. I have a …
HDR secondary database
Hi, You can safely shutdown the secondary and reboot the machine. Do not use the onmode command to change the state to standard. The HDR is being reestablished when the instance comes up again. The primary will then send the logfiles from in between to the secondary to synchroni…
Re: Restoring a logical log
ian.miell@gmail.com wrote: > We have some scripts which parse the output of onlog -n/-l and > produces user-friendly output. > > We've been given a log file from backup which has the header: > > [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less > 00000000 ff ff ff ff ff ff 00 00 00 0…
Restoring a logical log
We have some scripts which parse the output of onlog -n/-l and produces user-friendly output. We've been given a log file from backup which has the header: [xxxxxxl@xxxxxxx] 43$ hd llog.631510 | less 00000000 ff ff ff ff ff ff 00 00 00 0a 00 09 00 9d 07 5f |..............._| …
Re: How can fetch cause long transaction
> I have one more question: > > When DYNAMIC_LOG is set 2, does it starts to add more logical logs > dynamically when next logical log in the sequence has open > transaction. Does this become active only during roll back and next > logical log has an open transaction or could it …
Logical logs backup to disk
Hello Guys, here's another one of which I'm in doubt for some time. Finally decided to post it. If backup of logical logs is written on disk, do you need to rename the existing file first before starting a new backup, or is there an "append" ? In other words, if you don't rena…
Logical Log
Version IDS 10 When DYNAMIC_LOG is 2 and logical logs gets full Informix starts to write to rootdbs and Informix uses LOGSIZE from what was used initially for disk space initialization. And it appears like even if the LOGSIZE is changed using onparams or in onconfig file, Inform…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Never ending Checkpoint
IDS 9.40.FC4W2 SunOS 5.8 Last Saturday we had a "never ending checkpoint". There are no loggings about the event except the lines in online.log: 11:41:01 Fuzzy Checkpoint Completed: duration was 2 seconds, 2789 buffers not flushed, timestamp: 0x60364810. 11:41:01 Checkpoint …
How HDR resync after network connection resumes
With "RETAIN_TYPE" is set to 1, HDR would be reestablished from secondary server when old primary is up once again. When the logical log backup has been performed on secondary server, how the oustanding logical log could be retrieved for resync to old primary server? 1) Do I ne…
HDR failure handling on network disconnection
Is the process of logical log rolling forward by "ontape" or "onbar" are automatic?…
Difference between Physical and Logical Logs?
It seems the work done by logical log is more than physical log. What is the point of having physical log? As logical log already including post and pre image of database chanages.…
Logical Logs
Hi All Gurus, I'm new to this forum and IDS. Please advise me how to remove/delete the logical logs No.1 till No.3 from onstat -l, i assume flag D indicates DELETE ( pls corret me if wrong) And would it possible to readjust LOGSIZE to smaller value say "16384" from any availabl…
Informix Engine not starting
Can you please try to increase Physical & Logical log file sizes in Onconfig.bnm Thanks Tara…
Rename Dbspaces
Hi, You can add a new dbspace, create logfiles in this new DBSpace using onparams, and drop all old (backed up)logfiles using onparams again. In between you need to take a full (Level 0) backup in order for the new logfiles to be considered. In order to be able to drop old logfi…
Process taking most of Logcal Log
Version: IDS 10 Is there a way to tell which process on the box is filling up the logs. I was thinking if there is a way to tell which process / thread is writing the logical logs or filling up the logical logs…
OFF_RECVRY_THREADS and ON_RECVRY_THREADS
Does these parameters help in logical log recovery. I was wondering if increasing ON_RECVRY_THREADS help in HDR on secondary server.…
HDR Secondary mode Log transfer handling
How the transcation is delivered from Primary Database to Secondary Database? - In a full logical log ? - Any committed transaction at Primary Database? If the transaction is delivered from Priamry to Secondary Database in a full logical log, then any recommendation on the size …
How to find the location of logical log file
Veeru71 wrote: > Given a logical log file, wow can we find out its location > (dbspace) ? > onstat -l doesn't show this info. > Thanks > Using the sysmaster database: SELECT l.number logfile, d.name dbspace FROM syslogfil l, syschunks c, sysdbspaces d WHERE l.chunk = c.chk…
Timestamps into a TRACE logfile - current time in stored procedures
Hello list, what can I do to get timestamps having fractions of seconds into a TRACE created using TRACE PROCEDURE. What I have is: TRACE <sometext>; select dbinfo('utc_to_datetime',sh_curtime) into _trace_ts from sysmaster:sysshmvals; TRACE _trace_ts; But also casting like se…
IDS Primary down
Hi all.... In it completes week, my IDS Primary has down in 4 opportunities having shown the following message of error: 03:10:47 Maximum server connections 567 03:11:21 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 03:11:21 IBM Informix Dynamic Server Version 10…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Logical Logs in Enterprise Replication
Hi All, I am using Enterprise Replication on IDS10 UC5. I have 33 Logical Logs for IDS, each of 5000 pages i.e. 20,000KB. Test >onstat -l IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 09:00:11 -- 81408 Kbytes Physical Logging Buffer bufu…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
using onlog to display old logfiles backup up with
Hi, I want to display the contents of old logfiles (IDS 9.40 FC5) with the onlog utility. The documentation says: When using onbar to backup the logs, then onlog asks the storage manager (ISM in our environment) automatically to get the required logs. When I try the following co…
Re: Splitting logical logs
news.arcor.de wrote: > IDS 9.4 WE, Sola�ris 9 > > Hi everybody, > > we use to back up our logical logs using "ontape -c", for example in a file > named "trans.log". > As a consequence, when restoring a Level-0 backup using ontape -r, we can > only restore *all* logical logs con…
Splitting logical logs
IDS 9.4 WE, Sola�ris 9 Hi everybody, we use to back up our logical logs using "ontape -c", for example in a file named "trans.log". As a consequence, when restoring a Level-0 backup using ontape -r, we can only restore *all* logical logs contained in the trans.log or *no* logic…
Problem while taking backup
Hi, Ok you take it manually, but where is it going to ? (TAPEDEV and LTAPEDEV in your ONCONFIG_file) If you take it manually, are your variables INFORMIXDIR, INFORMIXSERVER and ONCONFIG Correctly set ? Any messages in your logfile ? (find logfile with : grep MSG $INFORMIXDIR/e…
Logical log backups
Hi I am having a dreadful time with a autochanger tape device for which my logical logs and archives are backed up to. Problem being the device frequently stops working and unless it is fixed before the logical logs run out, I get downtime. I am using the networker software to …
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
not write Log
Can I control the writing Logical LOG? I mean I have a large job and it will use up all my Logoical logs, so I would like to avoid writing log temporarilly for this job. Thanks, Quman…
Shrink onsrvapd.log and onsnmp. .log
Hello, Is it possible to shrink the following logfiles, which are used by the onsrvapd daemon? - onsrvapd.log - onsnmp.<server>.log Thanks in advanced!…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
logical log size
Hello, The logical logs on my system are configured as 30 32MB logs. The system has been growing rapidly and currently cuts 2-3 logs every 5 minutes. Backup is to a spectralogic tape unit, which is fairly slow to spin up. In order to not run out of logs due to backup issues, I w…
Not using the 100% logical log page size alloacted to informix
No, i meant the logical log page file that i have appended in my query.…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
return code 164 during logical log backup
Hi all, I have following kind of problem with logical logs backup: When the current logical log is comming full, it does'nt make logical log backup and in online log of informix following message appear: -------------------------------------------------- 16:13:14 Logical Log 524…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Long transaction aborted in Informix IDS 7.31
Hi. Firstly you should check how many log files has your instance (onstat -l, last line). If it has less than LOGFILES, you should add as many log files as you need. If not, you should set LOGFILES to a higher value and then add logfiles. By the way, if your database has 100…
Dynamic Logical Logs
I need to get a clarification on the Dynamic Logical LOgs in IDS 9.4. We having few sites running in IDS 9.4 FC6 on IBM pSeries AIX 5.3 Below are the parameter values which have been set :- # Logical Log Configurationd LOGFILES 6 # Number of logical log files LOGSIZE 2000 # Lo…
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
transaction return codes
Hi! I am working with an Informix Dynamic Server, I am not sure about the version. The system is transaction based and I have to turn the transaction off for a few operations. I did it with "ondblog nolog". I then started a script which inserts some stuff into a DB and is parall…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: Logical Logs's
begnadigen Sie mich, Ich verstehe nicht -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Bono Vox Sent: 04 May 2005 11:02 PM To: ids@iiug.org Cc: iiug-esp@iiug.org; informix-list@iiug.org Subject: Logical Logs's Co…
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log 27225 - …
Logical Logs's
Consulta: Cuando ejecuto el comando: $onstat -m y tengo la siguiente salida: 15:50:55 Logical Log 27225 Complete. 15:51:32 Logical Log 27222 - Backup Completed 15:51:32 Logical Log 27223 - Backup Started 15:51:36 Logical Log 27223 - Backup Completed 15:52:00 Logical Log…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
Re: PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
PANIC: Attempting to bring system down
looking at their log file that happened before logical recovery completed! looks like they had another problem before they got this one otherwise they wouldn't have had to perform logical recovery…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
Re: Adding logical logs problem..7.31UD7
> rootdbs.. Now I'm editing onconfig and changed LOGFILES 3 to 30. > > typing: > onparams -a -d llogdbs_1_1 -s 3412 > > and got this error: > Exceeding the maximum number of logical logs allowed. You have to set LOGSMAX onconfig parameter to the value >= number of logical logs …
RE: Logical Logs not full
Brice, What you have described is not quite accurate; The logical log is not backed up the instant the transaction is committed when in unbuffered mode, it is written directly to the logical log as opposed to being stored in the current logical log buffer. Buffered logging us…
RE: Logical Logs not full
Muthana, The logical logs are fine, I wouldn't be dropping and recreating them, there is only one reason I can think of as to why a logical log would not reach 100% and that is onmode -l (force next logical log) this may be for any number of reasons, but typically it would be a…
Logical Logs not full
This is a multi-part message in MIME format. ------_=_NextPart_001_01C50831.81451638 Content-Type: multipart/alternative; boundary="----_=_NextPart_002_01C50831.81451638" ------_=_NextPart_002_01C50831.81451638 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-E…
Help !! - Logical Logs are full
IDS 9.21 UC4 LINUX RH 7.1 There was a long transaction aborted, an the IDS stuck in an eternal CKPT. The online.log said : "09:51:44 Waiting for Next Logical Log File to be Freed 09:51:44 Process exited with return code 127: /bin/sh /bin/sh -c /home/informix /etc/log_full.sh 3 …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Ontape/logical logs
Hi all, I'm reasonably new when it comes to Informix, so I hope this isn't an often- asked question. I've set up a disaster recovery server for our main Informix server, to which I automatically send my level 0/level 1 backups and logical logs, as they're written to disk. I've p…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
ontape -c stop archiving logical log on 9.21UC7
Dear All, I'm using 9.21UC7 on AIX4.3.3ML11, normally "ontape -c" archives logical log when the log is full(the logical log status changes from U---- to U-B---), but sometimes, it stops archiving logical log, even if you use "control+c" to stop it and restart it, it still cann't …
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: How to change number of logical log files ?
Hi Jenifer. If you want to more logical logs, try the following. Modify LOGFILES in $INFORMIXDIR/etc/$ONCONFIG LOGFILES 6 # Number of logical log files Change 6 to XX. Bounce engine. HTH -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "jenife…
Re: RE: onbar error message
We run 9.40.UC3 on RH Linux. We have 6 logfiles, 5000 KB each and we run into this error with available log files.. Did you get the problem resolved by changing the logsize?…
RE: Logical logs - how to tell if full?
Notbeen on anysystem admin courses whatsoever - and unlikely to.. Is it safe to back up the logical logs at anytime?…
onbar error message
Hello! I have an Informix backup configured as an onbar + Legato Networker combination with IDS 9.40 UC3 on Solaris 9 machine. We take dbspace backups every night and continously backup logical logs using log_full.sh script. All works well except one thing: if logical logs start …
Informix Tivoli copygroup setup
Am about to start testing using TSM for Informix backups and have not been able to find a good example of how to setup the backup copygroups. IDS 9.21.UC2 on AIX 4.3.3 ML10 with TSM 5.1 Recovery Requirements: PIT recovery within last 12 days. Plan on running 2 L0, 2 L1, and 2 L…
logical log record failed
Hello all, IDS 9.21 UC4 Solaris 8 We have two systems replicating through HDR. the secondary server which is receiving the logs from the primary server suddenly starting giving this error message " rollforward of log record failed" then it gives the logical log number and the p…
onbar backup logical logs
Hi All, I am using onbar to backup my informix 7.31 databases with Legato networker. I dont want to backup my logical logs. Before using onbar, with ontape, I backed up my logical logs to /dev/null. How can I do that with onbar and Legato networker. Thanks for any help ______…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
Logical Log Backup Informix 9.4 linux
Please ignore my previous posting, It was in response to some other question which I wrongly posted here. To your problem, can you give more details on - how much delay you noticed (please send the part of online.log ) - the size of your logfile for which you are seeing the dela…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
AIX logical logging question
My sysadmin wants to know if I can send the logical logs to a rewriteable DVD drive? Seems like new AIX boxes are coming equipped with these devices instead of 8mm tape drives. Anybody doing this currently? -- Phillip…
Physical and logical log placement
It's often recommended that the physical and logical logs be moved from rootdbs. Apart from performance, is there some reason I've missed why they should be kept separate? And does it make any difference if the whole instance is going in a RAID 1+0 array? Andy Kent…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
logical logs in 9.40.FC3
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C3FA52.A6808A50 Content-Type: text/plain I just went into production this weekend on release 9.40.FC3, AIX 5.2. On my…
onbar script for logical logs
Anyone have a script to perform continuous logging using onbar to filesystems? I would like to write to a separate file on disk daily. Thanks for any help in advance.…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Calculate Logical Log Required
I have read DB Adm reference and some other Informix manuals and cannot find how to calculate the required logical log need for following cases. Can anyone tell me? Just some example :- 1. Say I need to load 1,000,000 rows with record size 100 bytes to DB. How many logical l…
Write Logical Logs To Disk
Hi, Greetings, The situation: I am trying to write the logical logs on the first instance to the disk instead of the tape so that I may transfer these to the second instance and use recovery to bring it upto date. I am trying this to implement production backup at the database…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
REgarding the Error in Logical Logs
Hi, We are running Informix 9.3 on Sun OS 5.8 . I cannot get my database engine up because of following error : 12:36:39 Results: Log record (OLDRSAM:HDELETE) in log 95507, offset 0xdf352c was not rolled back 12:36:39 Action: Use 'onlog' to view the transaction and repair manua…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Logical log backup on XPS
Hi All, We have XPS 8.40 installed on HP UX 11i. Ther server was initialised and we were trying to load data into a table . Now the server is in Blocked state and the online.log file mentions that we need to take logical log back. Pls let us know the process for taking logical …
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Restore certain Logical Logs
Hi guys, restoring a Level-0-archive using ontape -r and after that restoring logical logs using ontape -l works without any problem. Now, I have to restore a database-state, given after certain logical log. Is it possible, to restore a Level-0-archive (which includes the log…
Re: Instance startup time
Hi, query the table sysshmvals from sysmaster database. This should help. Dani "Rulesh Felix Rebello" <rrebello@fsl.org.jm> wrote in message news:<bm1k1u$kl3$1@terabinaries.xmission.com>... > Place the following lines in a file and execute the file ....u'll get the > Day, Date…
RE: Instance startup time
Place the following lines in a file and execute the file ....u'll get the Day, Date, Month Year and Time when the Informix engine was last brought up... grep MSGPATH $INFORMIXDIR/etc/$ONCONFIG|grep -Ev "#.*MSGPATH" |read garb logfile logfile=`echo $logfile|cut -d"#" -f1` N=`grep…
logical log recovery problem
Hi All, I'm getting the following error when trying to start up a database: 09:57:10 Results: Log record (OLDRSAM:HINSERT) in log 988, offset 0x3ab0098 was not rolled back 09:57:10 Action: Use 'onlog' to view the transaction and repair manually. 09:57:10 stack trace for pid 228…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Applying Logical Logs for a restore ?
I'm an informix newbie. So my question is very basic. After I have backed up the logical logs how is the process of reapplying them to the database to get it current done ? The logs have been backed up using ontape -a Thanks, Jack…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
Logical log buffer
Version: IDS 7.30 UC7 Question: We have 3 logical log buffers, 32K each. And databases use buffered logical log (>/dev/null), altogether 8 logical logs. One day users complained they can't do anything and when we ran onstat -u, we found out something like this: ..... e940e864 G…
Re: Logical Logs Size
What about the following : onstat -l (LOGBUFF will be shown here) What log mode on the database (Buffered, Unbuffered, None) Version of IDS O/S running on Are temp tables in use?? Do you have temp dbspaces?? Do you use into temp with no log?? Some of the online log that shows lo…
RE: Logical Logs Size
Fred 30 Gb seems rather large for total log space (in fact almost 19 Gb seems large). What is the size of your database? How quickly are you using the logs? What are your Long transaction limits set to? How often do you hit this long transaction? Can you (should you) split these…
Logical Logs Size
Hi, Well, in order to avoid amongother things several Long transactions aborded, I have decided to increase to size of the logical logs. This is what the actual configuration is : Total Logs Size : 18957068 KB Logs Number : 375 35 Logs of 15000 KB 340 Logs of 50000 KB …
Re: restore logical log
Andrey Mischenko wrote: > How to restore logical > log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a > log If you are asking how to restore logical logs when you have thrown them away using /dev/null, then the answer is; you can't, because they don't ex…
Re: restore logical log
Hello Andrey, If you had been backing up the logical logs to the bit bucket, I'm afraid there's no way you can restore the logs.... The only way is to go to a full Level 0 backup. Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Solutions Ph: 602-217-…
restore logical log
How to restore logical log if a parameter LTAPEDEV there was /dev/null on a moment of shaping of a log…
Where are the logical logs?
Hi there, Is there any way to know which dbspace are the logical logs in? Thx.…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
ISA slow with logical logs
Hai, When requesting the logical log information via ISA this tool is very slow. Does anybody know a solution? Bickel…
mt_shm_init: can't create resident segment
Somebody shut down my Informix server today and when I rebooted the computer the server did not start automatically when I entered services in control pane. I was getting error 2140. When I opened the server log file I got the following entry at the end of the logfile: 17:07:55 …
Re: Logical-log backup
----- Original Message ----- From: Woi Yew Fong <yfwoi@tpl.com.sg> To: <informix-list@iiug.org> Sent: Tuesday, January 30, 2001 9:40 AM Subject: Logical-log backup > > Hi there, > > I am confused with the automatic logical-log backup (with ontape -a) and > > continues logical-l…
Logical-log backup
> Hi there, > I am confused with the automatic logical-log backup (with ontape -a) and > continues logical-log file backup (with ontape -c). Can somebody clarify > the doubt for me. > > 1. Does automatic logical-log backup mean an operator need to execute the > command ontape -a…
SHMBASE Address - From Gigi
Hi I am facing a problem .while trying to install a Informix Database on Dell 2300/500MHz Intel / Sco Openserver Unix platform. with memory of 512MB The message is like this ILLEGAL MEMORY ADDRESS showing in the logfile, when I used SHMBASE=0x0 on the configuration file.…
Enterprise Replication log
Enterprise Replication does not have a seperate set of logs. It snoops from the normal logical log file buffers. It only snoops from the log files themselve during recovery or if for some reason it falls behind.…
Loading Module <SPLNULL>
The logfile of our IDS.2000 9.21.UC2 show the following entries from time to time: Loading Module <SPLNULL> ... Unloading Module <SPLNULL> What does this mean? Thank you, Jens…
procesor affinity and data replication
Can i set procesor affinity on secondary server in data replication pair? When I set AFF_SPROC and AFF_NPROCS, after reboot there is no information about affinity in logfile (usually on standard server information is after "On-line" message, but on secondary there is of course no…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Recovering logfile in Informix SE
Recover the database from your backup. You can recover tables from backup if you are careful and know what you are doing. The answer to your question is No using the log. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiu…
Recovering logfile in Informix SE
Does anybody know how to recover data from a logfile of an Informix SE database. I cannot find anything about it in the informix manuals I have . The only thing we found is the selog command which shows the content of a logfile , but seems to have no option to get data back int…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Drop the last transaction from logical log
Does any body know how to drop the last transaction from logical log before startup the database instance?…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
Logical Log Files are Full
Is there any way to flush out the contents of the LOgical Log Files through a script or command without manually setting it ? Thanks, Gavin…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
HHHHEEEELLLLPPPP!!!! My servers have gone nuts!
What are the stack traces from the af files? Just function names from the atcive thread will do.. Also check UNIX kernel logs (Look in /etc/syslog.conf for names of logfiles). David.…
logical logs
Hi all, How to find out which session causing the logical logs to fill up. Regards Aboo…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Re: Informix logfiles truncating
The engine has to be brought up with LTAPEDEV set to /dev/null. If you just change LTAPEDEV in onconfig or onmonitor it does mark the logs as backed up. If you bounce with LTAPEDEV set to /dev/null logs are marked as backed up. Jonathan Leffler …
RE: Informix logfiles truncating
Informix treats /dev/null specially. You shouldn't need to run ontape to free logs that are backed up to /dev/null > -----Original Message----- > From: Valeriy Tsuryk [SMTP:valery@quikcat.com] > Sent: Thursday, July 13, 2000 7:55 AM > To: informix-list@iiug.org > Subject: Re: I…
Re: Informix logfiles truncating
From: "Valeriy Tsuryk" <valery@quikcat.com> > >Sorry for one more question. >As far as I can understand even if I will have LTAPEDEV as /dev/null I >should schedule ontape -.... >or something else in order to wipe out log dbspace? No. You don't have to schedule ontape. The log f…
Re: Informix logfiles truncating
Set your LTAPEDEV to /dev/null? From: "Valeriy Tsuryk" <valery@quikcat.com> > >We developing distributed client-server application and we using > >Informix Dynamic Server Workgroup Edition 7.3... on UnixWare 7.1.1. > >Our database uses transaction logging. > >Our database has co…
Re: Informix logfiles truncating
ontape -c will continuously backup logs, and if you really don't want the backups you can set your backup device to /dev/null "Valeriy Tsuryk" <valery@quikcat.com> on 13/07/2000 13:01:14 Please respond to "Valeriy Tsuryk" <valery@quikcat.com> To: informix-list@iiug.org cc: …
Informix logfiles truncating
Hello ! We developing distributed client-server application and we using Informix Dynamic Server Workgroup Edition 7.3... on UnixWare 7.1.1. Our database uses transaction logging. Our database has couple static tables with customers information and several tables with dynami…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Logical logs?
Logical logs reside on disks. Logical log buffers reside in memory. If you want to increase the size and number of Logical logs then just add more disk space. Don "Josep M. Marti" wrote: > > Hi all, > I have a problem with the logical log. I need to add more logical logs > be…
Logical logs?
Hi all, I have a problem with the logical log. I need to add more logical logs becouse I can't run any proces, but the logical logs need memory space or disk space? If I put a lot of logical logs I needed add memory or disk? thanks all, -- ------------------------------------…
Questions about sysprofile in sysmaster?
In Informix << Adminstrator reference>> book, It tells me that the table sysprofile in sysmaster contains columns such as llgrecs,llgpagewrites,llgwrites and it wrote: llgrecs: Logical-log records llgpagewrites: Logical-log writes llgwrites: Logical-log page writes 1.What doe…
Re: Writing files with stored procedures
Use the TRACE statement? E.g.: SET DEBUG FILE TO '/tmp/logfile' WITH APPEND; TRACE 'whatever ...'; * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!…
Logical logs
Hi All, I have a informix database of 7.30 where in the logical log is getting full very frequently. > What might be the reason. I think the "size" / "physize" of each log is > very less. I am giving below the output of "onstat -l". Is there any > parameters in onconfig tha…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Logical logs
In our system, I am noticing Long Transactions being caused sometimes. We have 80 log files, each of size 2048. LTXHWM & LTXEHWM are 50 & 60. I don't want to increase them. I am planning to increase the no. of log files to 120 or to 160. Are there any pros and cons of having more…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Need more Information about backups / Where to find ?
Hello, i've got some examples for Backups of DB and Logfiles from Informix. Know i want read more about this. OK Full Archive is done by 'ontape -s -L 0', Logs will be saved with 'ontape -a'. I already realized that there's a 'log_full.sh' but i would prefer to read more about it…
More Info about Backups
Hello, i've got some examples for Backups of DB and Logfiles from Informix. Know i want read more about this. OK Full Archive is done by 'ontape -s -L 0', Logs will be saved with 'ontape -a'. I already realized that there's a 'log_full.sh' but i would prefer to read more about it…
question
Try backing up the logical logs with ontape. Nona…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
RE: What is the maximum logical logs you can have on an instance?
The Administrator's Guide for IDS 7.3 shows the maximum value for LOGSMAX and LOGFILES to be 32,767. -----Original Message----- From: richard palmer [mailto:palric@tor.maves.ca] Sent: Monday, January 10, 2000 12:25 PM To: Christopher Weldon Ayres Cc: informix-list@iiug.org Subje…
Re: What is the maximum logical logs you can have on an instance?
On an AIX hosted using IDS 7.31 UC2 the instance will start successfully with LOGFILES=2000 and LOGSMAX=2000. have a nice day. Christopher Weldon Ayres wrote: > I believe it is 64?…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
cann't open logfile
Hello, I installed Informix SE V720 and restaured a database created under Informix SE V4.x from another machine. When I try to connect to the database, I receive the following messages: 224: Cann't open transaction log file 120: ISAM error: cann't open log file finderr sugges…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Re: web databases & CGI
I've included some sql error checks and when the cgi program is executed i get an sqlerror in my logfile: Testing CGI program ===================== Run at: 10:21:33 on 17/11/1999 opening database ksh_db@informix connecting to db sqlcode -461, isam 0 Sql: Unable to load locale…
Re: web databases & CGI
I've included some sql error checks and when the cgi program is executed i get an sqlerror in my logfile: Testing CGI program ===================== Run at: 10:21:33 on 17/11/1999 opening database ksh_db@informix connecting to db sqlcode -461, isam 0 Sql: Unable to load locale…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Script Parameter Passed to Ontape Restore script
Can anyone tell me the command to pass a parameter to "ontape -r" in a batch script? I have been trying the following command, echo "y\\n"|ontape -r >> ${LOGFILE}, but the y and n do not get passed. I can be reached a jhimschoot@crowechizek.com. Thanks,Jim…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
ontape -c
When using 'ontape -c', for continuos backup of logical logs, what is the proper way to terminate the command? Is it simply a CTRL-C?…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
HELP!!!
im looking at every logical log at 100% and naturally a blocked checkpoint. whats the best, and next best thing to do in a case like this!!!…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
Size of Logical Logfiles
Hi *, I´d like to know whats the best size for Logical Logfiles. I´m using an unbuffered Log with my Database. So what happens when a tansaction commits? Is the whole Logfile written to disk? Or is just the part written to disk which has changed? Thanks Thomas…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
logicallogs
Hi there In the IECC database list my databases have the status LOGGING MODE - no. But the logical logs (onstat -l) are in use. Why ??? Thanks…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: Logical logs
Patrick You can increase the NUMBER of logical log files by executing the onparams command, which will effectively increase the size of your logical log space. You need to add few more logfiles using the "onparams -a -d logDBSpace" command and increase the value of LOGSMAX in yo…
Logical logs
Hi Everyone , I am new to the administrative side of Informix Dynamic OL Server and would be gratefull if someone is able to give me a clear answer pertaining to increasing the size of my logical log file. I have tried adjusting the parameters in my confiuration files that did…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
Log Files Full
Error message: Logical Log Files are Full -- Backup is Needed Can anyone help me? Thanks in advance, Joao…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Posting from the Informix-list
Does anyone know if there are problems with the IIUG website? Everytime I try and access it via http://www.iiug.org I get the following message: Can't open logfile /usr/local/wnlogs/wn.log Thanks, Randy W. McDaniel Senior Database Administrator Fidelity Investments 100 Crosby…
Re: ErrorCode = -27002
Prasad Bandaru wrote: > > Hi, > > Thanks for the reply. I tried onmode -my. the server waits there for ever doing > nothing. I am not sure what's happening. > > Here's my onconfig file. > ========================================================= > > INFORMIX-Universal Server Vers…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
automating archives on HPUX
I run the following script for a level 0 archive via cron. Please note that it assumes that I have an environment var called LOGDIR. John S. --------------------------------- #!/bin/sh . config/profile LOGFILE=$LOGDIR/ontape.log echo "Start Production Database Backup 0 at "`…
URGENT: DRAIN LOG FILES
How can I drain logfiles in IDS 7.3 NT? I am developing so I don't need to save data, I just want to clean the log. I can do it by executing ontape -a and if LTAPEDEV and TAPEDEV are set to NULL, but I don't know how exactly I must do it: Have tried: TAPEDEV \\\\null LTAPEDEV \\\…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
DBA probems
Hi this is mukund ! I am doing backup thru ontape utility as follows ontape -s -L 0 everyday. (logfiles backup thru ontape -a is not done) Is archive level 0 backup without logfile backup thru ontape -a command is sufficient ? If not what is correct method ? Favor me with correct…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Logical Log
This is a multi-part message in MIME format. ------=_NextPart_000_0084_01BE5CC0.3EFB85E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear User, I have been trying to get a large file loaded on a database with = transaction loggin…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
Private installation of IUS9.14
Hello, I tried to set up a private installation of the Informix Universal Server 9.14.UC4 on Solaris 2.6. After starting the server with oninit -i the program writes listener-thread: err = -951: oserr = 0: errstr = ifdp: Incorrect password or user ifdp is not known on the …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Re: Logfiles
Use onlog, and refer to manual on interpreting onlog output... It is pretty cryptic... dtracy Paul Crompton wrote: > > Is there any way to look at the information contained in the log files. This > is more of a curiosity the an actual need. > > Paul Crompton > Lee County Clerk …
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Logfiles
On Mon, 7 Dec 1998 07:33:43 -0500, Paul Crompton <PCrompton@CLERK-OF-COURT.co.lee.fl.us> wrote: vi…
Re: Logfiles
At 07:33 AM 07-12-98 -0500, Paul Crompton wrote: >Is there any way to look at the information contained in the log files. This >is more of a curiosity the an actual need. The "onlog" utility. See the Administrator's Guide for details (Page 35-23 in the 7.3 version.) __________…
Re: Logfiles
$INFORMIXDIR/bin/onlog Scott A Johnson wrote in message <366c1fe9.4863942@news.kcnet.com>... >On Mon, 7 Dec 1998 07:33:43 -0500, Paul Crompton ><PCrompton@CLERK-OF-COURT.co.lee.fl.us> wrote: > >vi…
Re: Logfiles
Check out the onlog utility. Watch out though, don't look at the current log if you can help it as onlog exclusively locks the logical log file thus dis-allowing all access until you free the log. Is this what you wanted, or did you want to look at the textual information held i…
Logfiles
Is there any way to look at the information contained in the log files. This is more of a curiosity the an actual need. Paul Crompton Lee County Clerk of Courts pcrompton@clerk-of-court.co.lee.fl.us * Paul EXT. 2270…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: tbinit without logical recovery ??
Art S. Kagel wrote: > The ONLY way: Call Informix Tech support and they can log in and > truncate the logical logfiles so that the engine thinks the log ends > at the beginning of log file with the last checkpoint. Then you can > bring the engine up. You do need to go through…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
Re: Alter Fragment - LTX
Sadagopan, Sathish, CFCTR wrote: > > Hi, > I did an 'Alter fragment table xyz init in same_dbspace' > to compress the table.After the statement ran for some time I got the -458 > error , Long Transaction Aborted. > I have continuous logging running to a tapedevice.The logs were…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Roll Forward Logical Log
Hi, Just wondering if I create my temp table 'with no log' option in my stored procedure. Do I have a problem rolling forward my logical log as the temp table will not be logged ?? Thanks JH…
Logical Logs
Hello, just two simple questions: What is a logical log ? Are the logical logs stored on tape automatically with the "ontape -s" command? Best regards Andre…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: BackUp LogFiles
In article <362C4CE7.2E04@informatik.uni-leipzig.de>, graefe@informatik.uni-leipzig.de (Sven Graefe) wrote: > > > > Hello, > > > > How can I delete (clear) full log-files, without any BackUp on disk or > > tape? > > > > If there no possibility, how can I make the easiest BackUp …
AW: BackUp LogFiles
Hallo Sven! Setze die TAPDEVS f=FCr die Logfiles in der onconfig auf /dev/null.=20 Damit werden die Logfiles auf das Device null gesichert. OK? Andy M. Bettin -----Urspr=FCngliche Nachricht----- Von: Sven Graefe [mailto:graefe@informatik.uni-leipzig.de] Gesendet am: Dienstag…
BackUp LogFiles
Hello, How can I delete (clear) full log-files, without any BackUp on disk or tape? If there no possibility, how can I make the easiest BackUp on disk? I don't need the log-files. But I have to use unbuffered logging and so the log-files are full in a shortest time. I had set …
Re: BackUp LogFiles
> > Hello, > > How can I delete (clear) full log-files, without any BackUp on disk or > tape? > > If there no possibility, how can I make the easiest BackUp on disk? > I don't need the log-files. But I have to use unbuffered logging and so > the log-files are full in a shortest t…
Re: BackUp LogFiles
In article <362B53DD.189F@informatik.uni-leipzig.de>, graefe@informatik.uni-leipzig.de (Sven Graefe) wrote: > Hello, > > How can I delete (clear) full log-files, without any BackUp on disk or > tape? > > If there no possibility, how can I make the easiest BackUp on disk? > I don…
Re: BackUp LogFiles
In article <362B53DD.189F@informatik.uni-leipzig.de>, Sven Graefe <graefe@informatik.uni-leipzig.de> wrote: > Hello, > > How can I delete (clear) full log-files, without any BackUp on disk or > tape? > > If there no possibility, how can I make the easiest BackUp on disk? > I do…
Re: BackUp LogFiles
This is a multi-part message in MIME format. --------------8C63EE125199D1E0BFDA9C06 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sven Graefe wrote: > Hello, > > How can I delete (clear) full log-files, without any BackUp on disk or > > tape? > > If…
Re: BackUp LogFiles
Sven Graefe wrote: > > Hello, > > How can I delete (clear) full log-files, without any BackUp on disk or > tape? > > If there no possibility, how can I make the easiest BackUp on disk? > I don't need the log-files. But I have to use unbuffered logging and so > the log-files are f…
BackUp LogFiles
Hello, How can I delete (clear) full log-files, without any BackUp on disk or tape? If there no possibility, how can I make the easiest BackUp on disk? I don't need the log-files. But I have to use unbuffered logging and so the log-files are full in a shortest time. Thanks, fo…
Re: Question on database recovery
In article <361a8b42.0@newsread1.dircon.co.uk>, "H.Sahar" <hamid@dircon.co.uk> wrote: > Hi, > for some reason my database dropped, but because I have a backup > file dbs I tried to copy into database area and try to use > start database command to create log file and I am getti…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
problem deleting 31697 records in SE 7.13.UC1
hello, Did I miss something, or is it really impossible to delete a large number of records in a single table (eg. 30 000 or 60 000)? Could perhaps somebody tell me anything about a known upper limit ? (temp space is about 17Mb free, data space more than 170Mb free, which shou…
Re: Moving SE Database and logfile
Hi Laurent! Laurent COLLIGNON wrote: > Ok you have found the problem > Let me explain how I resolve it > > With a very little C program I directly modify the file > <xxx.dbs/systables.dat> by replacing the string containing the word > <syslog>. > You can directly see it with: >…
Re: Moving SE Database and logfile
Ok you have found the problem Let me explain how I resolve it With a very little C program I directly modify the file <xxx.dbs/systables.dat> by replacing the string containing the word <syslog>. You can directly see it with: grep syslog xxx.dbs/systables.dat You just have to cr…
Re: Moving SE Database and logfile
On Mon, 07 Sep 1998 12:56:55 +0100, Peter Lancashire <Peter.Lancashire.PL1@bayer.co.uk> wrote: >Yes. START DATABASE xxx WITH NO LOG. > >You need to stop the logging before moving the database and restart it >after the move. The reason is that the database contains a reference to…
Re: Moving SE Database and logfile
Axel Sander wrote: > > Hi, > I successfully moved my SE 5.x to a new partition by just copying all > database files. I discovered one problem: > After moving the files the old logfile *must* still exist in the old > directory (could be length of 0) given by the systables. When I …
Moving SE Database and logfile
Hi, I successfully moved my SE 5.x to a new partition by just copying all database files. I discovered one problem: After moving the files the old logfile *must* still exist in the old directory (could be length of 0) given by the systables. When I try "dbaccess - -" and "start d…
Logical Logs
Hello List, I have ten logcal log under IDS 7.30 and when I take backup through ontape -a and when I see the status of logical logs using onstat -l the percentage used does not change however I get a backup flage B additional. But Is it not that the %used should become Zero ? …
logical logs
Hi, The L.Logs on my system after a L.log backup normally shows a status of "U_B_ _ _ _" They are backed up as soon as they are full thro' the ALARMPROGRAM. 1) However suddenly some of the logs show a status of "F _ _ _ _ _ _".Though this might mean the same as "U_B____" , Any id…
Re: Update prob. w/ I-SE logfile
Jo�o Natal wrote: > > Hi there, > > Env : SCO Unix 3.2v4.2 + I-SE 5.00.UD1 > Table: mov ( year smallint, month smallint, nrdoc int status char(1)) > Index: unique ( year, month, nrdoc) > Transactions: on > Users: Only me > > The problem arises when i try the following update: > …
Re: Update prob. w/ I-SE logfile
On Thu, 06 Aug 1998 16:39:50 GMT, in article <6qcpni$ltj$1@duke.telepac.pt>, natal@mail.telepac.pt (Jo�o Natal) wrote: >Hi there, > >Env : SCO Unix 3.2v4.2 + I-SE 5.00.UD1 >Table: mov ( year smallint, month smallint, nrdoc int status char(1)) I assume that between int and statu…
Update prob. w/ I-SE logfile
Hi there, Env : SCO Unix 3.2v4.2 + I-SE 5.00.UD1 Table: mov ( year smallint, month smallint, nrdoc int status char(1)) Index: unique ( year, month, nrdoc) Transactions: on Users: Only me The problem arises when i try the following update: update mov set status = "A" where yea…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: change logging status U-B to F
Why do you want to mark your logfile as free? Is "Backed up" not enough? A free logfile is an "never used" logfile. There is no way to mark a used logfile "free". This feature has changed since V6. Yours Volker Chuanlarp Satchavarodom schrieb: > > Dear All, > > I tried to c…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Logical Logs
Hello, When I do a restore using ontape and then rollforward the L.logs . When finished with the Logical logs, the message into the logfile is "Logical Log nnnn Complete" where nnnn is The first log with which the rollforward started and not the last log which was rolled forward.…
Informix Dynamic Server & Text columns
Hi everybody, Can you help me ? I've created a table with the following structure : column type -------- ---- code smallint obs text How can I insert into this table with Java program ? I'm using Informix Java AP…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
How to size the logical log ?
Hello Guys, Does anybody know how to calculate the size of the logical logs ? What does the logical log size based upon ? What are the factors ? I want to backup the logical logs very often to avoid disaster. How does informix backup logical logs ? …
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
Re: What is the best way to backup logical logs ?
Timothy_Lam@crow.bmc.com wrote: > > Hello, > > What is the best way to backup logical logs to remote machine? > Should I kick it off when the logical log becomes full ? > Does anyone has any examples ? > > > What is the recommend size of logical logs ? Ho…
What is the best way to backup logical logs ?
Hello, What is the best way to backup logical logs to remote machine? Should I kick it off when the logical log becomes full ? Does anyone has any examples ? What is the recommend size of logical logs ? How do you calculate ? Rdgs Timothy…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Checking datatype of CHAR variable in 4GL
Alan Denney writes: > If the log contents matter that much to you, you can stop and start > error logging when you change WHENEVER from STOP to CONTINUE and vice-versa. What's the format of the 4GL statement to stop error logging when you change WHENEVER from STOP to CONTINUE ?…
Re: What size for LOGSIZE and LOGFILES on OWS 7.22
In article <34E1EA5D.549C6141@garpac.com>, Jacob Salomon <jake@garpac.com> writes >David Williams wrote: >--- SNIP --- >> Depends, try 250K logical logs and have a few hundred of them. >> Try a physical log of 25Mb and grow it if needed. > >David, > >being a big fan of LBU_PR…
Re: What size for LOGSIZE and LOGFILES on OWS 7.22
David Williams wrote: --- SNIP --- > Depends, try 250K logical logs and have a few hundred of them. > Try a physical log of 25Mb and grow it if needed. David, being a big fan of LBU_PRESERVE, I object to the very suggestion of using small logs. I am much more in favor a a …
Re: What size for LOGSIZE and LOGFILES on OWS 7.22
In article <19980210123301.HAA11677@ladder02.news.aol.com>, ProzessDV <prozessdv@aol.com> writes >I've read that LOGSIZE and LOGFILES and PHYSFILE should be made very huge. What >would be an efficient size when you have about 50 users concurrent and a 4 >GByte hard disk space. I'…
What size for LOGSIZE and LOGFILES on OWS 7.22
I've read that LOGSIZE and LOGFILES and PHYSFILE should be made very huge. What would be an efficient size when you have about 50 users concurrent and a 4 GByte hard disk space. I've also read that OWS can only handle up to 32 concurrent users. Is this right? Many thanks already…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
ontape within a script
Apologies first of all; I've seen this question posted before, but I can't find the answer in any archives. When running an ontape -s, if the tape is not ready, the message to prepare the tape will be repeated. Within a script, this will simply start a tight loop which will qui…
NOCURRENT
Hi I just upgraded to Informix 7.23 UC7 from 7.23 UC3. I found that while backing logfiles, NOCURRENT is not the default. Meaning unless I specifically say NOCURRENT or CURRENT my backup will fail. The command: backup/logfile/automatic/vset=vset1/autovop/immediate will F…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
Logical Logs
Hi users, The env i am using is Informix OWS 7.20. The database i am using dosen't have logs. So in my esql/c programs if i user BEGIN WORK it gives me an error. Can anybody tell how to create log for existing database or if i export the database how to import it into …
logical logs
Hi I am running Online 7.23 on HP 10.20 Why was logical log backed up every 2-3 minutes? Is there any hint not to make that backup too fast? Here is the info... 11:07:08 Logical Log 608 Complete. 11:07:09 Process exited with return code 133: /bin/sh /bin/sh -c /usr/informix/…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
Re: SQL from command line capturing screen display.
Terron Wright wrote: > > How can I capture what is displayed to the screen when doing dbaccess > script from the command > line in UNIX. I would like to be able to capture the 100 records updated > display. You can run dbaccess in command line mode under script or redirect outpu…
Re: What is Best way to Backup Informix Data?
You can backup the logical logs to disk. Check out the shell scripts in the $INFORMIX/etc directory. One of them is an example of trapping informix event 23 and backing up the logs to disk. All you need to do is trow away the old logfiles from time to time. Perform a level 0 ar…
Re: informix logical logfiles
I suspect either you just restarted your database engine or may have run onstat -z which might? zero out these statistics. Are either of these true? -Bill } } > We use informix online 7.11 and I think our applicaton behave a bit strange. } > } > After } > onstat -l } > } > Buffe…
informix logical logfiles
> We use informix online 7.11 and I think our applicaton behave a bit strange. > > After > onstat -l > > Buffer bufused bufsize numpages numwrits pages/io > P-1 0 16 0 0 0.00 > phybegin physize phypos phyused %used > 108b75 10000 …
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
RE: Logical Logs on OWS 7.20 UC2
Hi Ramp! Even in a non-transactional environment, the Logical Logs will be used. The administrative tasks performed by the Informix threads will be using the logical log space, even if you don't any database with LOG. When you set the /dev/null, Informix automatically will set …
Logical Logs on OWS 7.20 UC2
What i don=B4t know is what happen when the logical logs get full in a no= t transactional evironment and with then devicel for logical logs set to /dev/null . I will get a dead lock or the logs get empty when On-Line need more space. -- = Un saludo civil http://www.svalero.es/…
Re: Update via logfile
Protime wrote: > Problem :- 6 regional offices all running Informix Standard engine > with > databases varying in size from 2GB to 7GB. We want to maintain a > separate > copy of each of these databases on a central machine, it is > impractical to > copy and restore each of the …
Re: Update via logfile
Protime wrote: > Problem :- 6 regional offices all running Informix Standard engine > with > databases varying in size from 2GB to 7GB. We want to maintain a > separate > copy of each of these databases on a central machine, it is > impractical to > copy and restore each of the …
Re: Online hangs during oninit after reboot.
In <5tt1qc$ss0@cssun.mathcs.emory.edu> mws@appi.ci.in.ameritech.com (Mark Stannard) writes: >We are running Online Dynamic Server 7.23.UC1 on an RS6000 with AIX >4.14. Currently we reboot the machine every Saturday morning. Several >times the Online instance has hung during th…
Re: Update via logfile
"Protime" <protime@dbn.lia.net> wrote: :Problem :- 6 regional offices all running Informix Standard engine with :databases varying in size from 2GB to 7GB. We want to maintain a separate :copy of each of these databases on a central machine, it is impractical to :copy and restor…
Update via logfile
Problem :- 6 regional offices all running Informix Standard engine with databases varying in size from 2GB to 7GB. We want to maintain a separate copy of each of these databases on a central machine, it is impractical to copy and restore each of the databases in its entirety via …
Re: Device files did not show up?
Evelyn Have you installed the stape driver in the kernel? Under HPUX you can use insf to re-create the device files if they are not there. As for an automatic ontape script you can use cron to schedule a script which …
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: How do I test a database?
..and, Turn on set explain on. Gt the SQL for the most common queries and mc queries. Get the users to sign off on expected load. Find out what expected table hits are either via SMI or do an analysis of the logfiles if it's under Online 6. Build a stress-test environment …
Problem with Informix Logspace (urgent)
Hi everybody ! (I'm new to this group). I've got the following problem with Informix 6.0 running on Solaris2.5: To avoid a 'Long transaction aborted ...' i added a new chunk to my rootdbs (200 MB). Then i tried to add new logspace using the following two methods: (i've got to m…
Re: 7.1 initialization error
Check if the "informix" user can write into "/INFORMIXTMP" if this directory exists or into "/tmp". If this doesn't work you should send more information (logfile, onconfig, sqlhosts, ...) Uwe…
Re: Why long transaction cannot rollback?????
I am not sure whether this applies to your version of Informix; however, I was told in a performance and tuning class that the system will examine the logical logs after passing the high water mark and examine the processes active in the current logical log. If one has five logic…
Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!
Thanks for your suggestion. However, we had already set the logical log backup device to /dev/null. In this case, what causes logical log full? Sincerely yours, Xiaohui Shen…
logical logging
Hi I have a question to ask. I am on HP 9.0 O/X with online 5.12 When I changed to /dev/null on the primary drive from /dev/ifmx/1m and then turned off the B logging, then I ran the sql script after long transaction aborted. Once the script was done, I turned the logging back …
Re: Standard Engine Log File
slivi@interaccess.com (Sandy Livingston) wrote: :What table & field is the location of the standard :engine log file stored in? I have a customer who's :using the standard engine, but I can't find the :standard.log. Can I find it thru some table? :Thanks. There is no log fil…
Re: Turn Transactions on?
Richard Spitz wrote: > > Sorry for having to reply to myself, I made an important typo: > > Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: > : the logfile is not purged automatically, you have to do housekeeping > : from time to time by entering "cat /dev/null <logfi…
Re: Turn Transactions on?
Sorry for having to reply to myself, I made an important typo: Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: : the logfile is not purged automatically, you have to do housekeeping : from time to time by entering "cat /dev/null <logfile>" after a backup It has to r…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Backing Up SE - Questions
>The first chapter states "In general, every transaction log file must >have a corresponding archive copy of the database." I took this to mean that it was necissary to have a transaction log and database backup that are synched (i.e., one logfile=one backup). Not that you must…
Re: Suppressing all messages from sacego and isql
> A while ago I posted this question but no suggestions worked completely. > I can suppress all messages from a command line "sacego" with the -s option, > but I can't suppress messages from a command line isql statement. > I have a shell script that calls several isql procedures…
Log files in Online 5.x
Can anybody tell me an easier method for changing th logfile size on I-Online 5.x than unloading the whole database and reloading it with a new size? When we went through and redesigned the dbspaces and table distribution, we brought the system back up with very small log files. …
Informix 7.1 on SCO Open Server 5.0
Hi, I tried to install Informix Dynamic Online Server on a system that runs under SCO OpenServer 5.0. The startup of informix ends up in an error due to shared memory allocation. In the logfile there is a statement like a statement like: << shared memory base illegal >> Can som…
Newbee with questions about physical and logical log allocations.
Does anybody have a good rule-of-thumb calculating the size of the physical and logical log sizes. Informix said the total physical and logical logs size should be 20% of the total dbspace dedicated to online. Informix also indicates that the ratio of logical to physical logs si…
Re: tbmode/tbtape on Online 5
Andreas Zeugswetter (andreas.zeugswetter@telecom.at) wrote: : On Fri, 20 Oct 1995 00:13:55, ian.goddard@geo2.poptel.org.uk (Ian Goddard) : wrote: : >In article <45juq2$3sp@news.Belgium.EU.net> cevi0004@pophost.eunet.be (Meyers Alex) writes: : >>From: cevi0004@pophost.eunet.be (M…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: Long transaction
I was being silly - I was thinking it was the percentage of the last log file not a %age of the whole logical log space. -- Tony McCartan Tony Mc (UK)…
rollforward problem
Informix SE esqlc 4.00.U compiled program: after "fixing" error -547 ( thanx for translating the code, Darin !) I got another problem: the "rollforward database dbname" - comand results in errorcode -247, which is "ROLLFORWARD DATABASE failed. Check ISAM-Error" The ISAM-Error …
Physical Log and Logical Log
Hi Folks, I found some case at my friend's site. His Physical Log and Logical Log setting is : Physical Log size = 2000 Kbytes Logical Log size = 10000 Kbytes No. of Logical Log = 10 When he run daily 4GL-application with 70-80 users simultano…
Disk Crash killing logs
Folks, This is a (knock-on-wood) hypothetical question that may be some general interest. Suppose you have your logical logfiles on a disk by themselves (or at least sharing no part of your database partitions) and you have a disk crash on that log disk. Suppose you've followe…
Logical Logs
>Sender: news@srgenprp.sr.hp.com (News Administrator) > > We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. > Our tbconfig said LOGFILES 6 >>>>stuff deleted > LOGSIZE 500 > My question is: Is there an optimum balance between LOGFIL…
Re: Logical Logs question
Steve Brown (steveb@sr.hp.com) wrote: : We are running ONLINE 5.02 UC1 on a HP9000 series 867 under HPUX 9.04. : Our tbconfig said LOGFILES 6 : LOGSIZE 500 : LOGSMAX 6 : These logs are defined in the root dbspace. : : We have been ru…
inhospitable logs in SE
I've noticed that running Informix SE (5.0) on an SS10, that from time to time the permissions on the database logfile are changed from 660 to 640, and thus all db users get an error -224. I've seen it often, and so the fix (chmod) is automatic, but I can't seem to figure out wh…
Re: On-line engine startup failure
Hal Wigoda (hwigoda@seg7.arlingtonhgts.mnc.mot.com) wrote: <tbinit -s problems deleted....> : Does anyone have any ideas? Check your kernel parameters. You probably have a problem with resource allocation. Look in the online logfile to see if it tells you more.... Look espe…
Re: C-ISAM logfiles and recovery time
spitz@ana.med.uni-muenchen.de writes: >Bjarne Hansen (bj@perfmap.austin.ibm.com) wrote: > >: Another question/wish: Is there a way to make C-ISAM use Online tables ? > >If anybody knows how to accomplish this, please post here or send me >a copy of the answer. This is not possib…
Re: C-ISAM logfiles and recovery time
Bjarne Hansen (bj@perfmap.austin.ibm.com) wrote: : Another question/wish: Is there a way to make C-ISAM use Online tables ? If anybody knows how to accomplish this, please post here or send me a copy of the answer. Regards, Richard -- +----------------------------+------------…
Re: C-ISAM logfiles and recovery time
>From: uunet!perfmap.austin.ibm.com!bj (Bjarne Hansen) >Subject: C-ISAM logfiles and recovery time >Date: Wed, 19 May 1993 00:23:01 GMT >X-Informix-List-Id: <news.3373> >We are using C-ISAM with logfiles, isbegin() and iscommit(). >This works great, but we are concerned about re…
C-ISAM logfiles and recovery time
We are using C-ISAM with logfiles, isbegin() and iscommit(). This works great, but we are concerned about recovery time in case of a system failure. According to the docs, a failure will require us to restore the latest backup, and do isrecover() from the logfiles. Is this correc…
Re: RDBMS Feature Matrix (FAQ in the works !!!)
In article <C4Avtq.Gv1@unixhub.SLAC.Stanford.EDU>, ian@tethys.SLAC.Stanford.EDU (Ian A. MacGregor) writes... >In article <1993Mar22.151030.18234@ryn.mro4.dec.com>, abbott@priory.enet.dec.com (Robert Abbott) writes: >|> In response to my questions about the following Oracle f…
Re: logfile format?
paul linton writes: >Does anyone have the format that the logfile for informix SE engine >is in? See the C-ISAM Programmer's Manual, Appendix D ppg 7-10. >Also, is it something the changes from version to version? The general format does not change, though new entries may be a…
logfile format?
Does anyone have the format that the logfile for informix SE engine is in? Also, is it something the changes from version to version? Regarding Online: What kind of problems are people running into with regards to relying completely on informix tools? I may be under the group …
logical logs
I am running informix-online 4.00.UH2 on a Pyramid MIS-12/05 (OSx 5.1a). Part of the output from 'tbstat -l' is listed below: address number flags uniqid begin size used %used e0068944 1 U---C-L 5 100d64 250 66 26.40 e0068960 …
Re: Format of database logfile needed
Path: emory!swrinde!cs.utexas.edu!qt.cs.utexas.edu!yale.edu!think.com!ames!olivea!gossip.pyramid.com!pyramid!infmx!davek From: davek@informix.com (David Kosenko) Newsgroups: comp.databases.informix Message-ID: <1992Jan3.205934.4751@informix.com> Date: 3 Jan 92 20:59:34 GMT Refere…
Re: Format of database logfile needed
The format of Informix's SE Transaction Log file is defined on page D-10/12 of the C-ISAM Manual. I think it would be foolish of me to iterate the contents of these pages due to Informix's copywrite! However, the documentation is reasonably comprehensive an…
Format of database logfile needed
Path: emory!wupost!cs.utexas.edu!uunet!psinntp!gdc!nms!bergquis From: bergquis@nms.gdc.com (Brett Bergquist) Newsgroups: comp.databases.informix Message-ID: <433@wimpy.nms.gdc.com> Date: 12 Dec 91 12:18:43 GMT Organization: General DataComm, Middlebury CT Does anyone know the fo…
Online console, logfile, tbtape -c output
Has anyone done anything creative with grabbing the output of the Online engine? Like using named pipes or fifo's for the logfile or output from continuous log backup. I'd like to be able to have all that output and more get parsed for things like nasty errors or requests for n…