Oninit® Archive
Results for “ROOTSIZE”
Not enough room in ROOT DBspace
Original post: Hi, I'm trying to setup a new server with the exact configuration like another one but now I just can't initialize the instance. I always receive : oninit: Not enough room in ROOT DBspace. Requested 3109038K, ONCONFIG value 'ROOTSIZE' 2097152K ONCONFIG: ROOTN…
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
Logical log's and initialize new instance
Hi group, The logic for 6 small log's at initialize a new instance and in root dbspace is : we know that dbspace will be there. A lot of on config values are set to small / starting values to get instance up and initialized. Then set up instance: add new dbspace's / chunks Move …
Informix 15.0.0.2 IL1: Insert from SMALL table into temp LARGE table very slow
Case is already initiated from my colleague (TS021230355), as you already have seen. ------------------------------ Emanuel Reisinger Axians ICT Austria GmbH ------------------------------…
Rootdbs initially in a large chunk
Jacob: No problem. Just set ROOTSIZE in the ONCONFIG file before running the oninit -i. I do, however, question why one would want a massive rootdbs since there shouldn't be anything in there besides the reserved pages and most of the system databases. Art Art S. Kagel, President…
Informix 15 server / CSDK compatibility matrix
I agree that we initially went overboard with the old client / large table restrictions. We're working on the feature request you mention. ------------------------------ John Lengyel ------------------------------…
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 ------------------------------…
Is it possible to import the copy made with ontape from one database to another PC?
I have tried starting the server with the -i switch but it has no effect. Sometimes it cuts off in the initialization phase, and other times in the Fast Recovery phase, but it always ends up warning that the shared memory could not be initialized. ------------------------------ G…
ROWID question
Making my own rowid sounds like a relatively quick and easy initial fix. Thanks! ------------------------------ James Hughes ------------------------------…
Community call 15 March 11:00 ET discussion thread
Thank you for your interest in our Community Call series! Continue the conversation initiated in the 15 March 2023 call with your questions and comments below. ------------------------------ Marius Ciortea Community Director IBM Palo Alto ------------------------------…
restoring informix using the onbar command. problem
If you are confident that the data has been safely restored, then I would try to initiate the restore from TSM and see what happens. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com --------------------…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
Things That Should Never Happen
Already done. The connected CMs also dropped out during that window, but did NOT initiate a failover, even though failover was enabled. ------------------------------ TOM GIRSCH ------------------------------…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
Table Extent Size calculation
Forgot, if you choose 4K pages, then the initial extent size would be 7022400 KB which is, as noted in the waste calculation, about 496 KB less space. ------------------------------ Art Kagel ------------------------------…
ontape error
Hi Paul My reasoning for null'ing the dbspace chunk files is that in the past I have gone around in circles with FULL_DISK_INIT. I note your point however. Perhaps removing the root chunk file on the RSS node and then fallocate'ing to create it afresh might be an option. --------…
Decrease Size of Root Dbspace
IDS 12.10.FC12 IDS 14.10.FC3 (upgrading very soon, so if it can be done in 14 that would be great) Solaris 10 1/13 Consider the following scenario: Many years ago an experimental Informix instance is created. The Oracle S.A.M.E. (Stripe and Mirror Everything) method is adopted, …
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
IDS 12.10.FC12 Solaris 10 1/13 Consider a new Informix instance with db/sbspaces (all 1 chunk) as follows: 1) dbspace for the database catalog and data tables; 2) dbspace for indexes (16K pages); 3) sbspace for sblobs (photos-- relatively infrequently accessed); 4) root dbspace …
Moving the logs, or not?
Hello. There are no performance benefits on your case. But, as a best practice, is always recommended, easing administration (you can even use an auto-extendable dbspace for your logs and their chunks). It might be painful to grow your root dbspace, let it simple. My opinion? K…
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
Bad page address or checksum on page zero (primary
Hi, recently I saw this message when I initialized our informix instance. It starts up without any problem and the database is functioning well, anybody know what could this message mean?…
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…
Dev Server Won't Start
Was there a restore done on this server which did not complete successfully? That is the most common reason I have seen for this message. Regards, David. > On 02 February 2018 at 15:07 BENJI LONG <ruggedmouse@hotmail.com> wrote: > > > It says Checking database partition index.…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
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.…
Assert Failed: Page Check Error in initchunk
$ oncheck -cDl sgbf_light2 shared memory not initialized for INFORMIXSERVER 'ol_tango'…
Re: HDR Question
Thanks for that explanation. I added it to my notes. I have made it by this error. Now the memory will not initialize for some reason…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
Rovoke insert permission but still can insert
I can't run the dbschema command. It says it couldn't initialize security subsystem.…
sysmaster - change locale?
Hi, Just for curiosity . Is possible initialize the instance and set sysmaster for a different locale ? Since no matter the *_LOCALE variables, it and all others sys* databases are always created with en_US.* locale.... Regards…
Erroc when dropping a table -- how to debug?
Damn it, I feared as much -- I thought I was using RAII everywhere (resource acquisition is initialization). Any thoughts on debugging that sanely?…
onspaces
is onspaces available to be used before the database server is initialized for the first time, or only after?…
onload questions
IDS 11.50.FC5 Solaris 10 I sent this in a couple of days ago, but I never saw it posted. --- I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace infor…
onload - onunload
IDS 11.50.FC5 Solaris 10 I created an onunload copy of a database on a server. The original database is housed in two difference dbspaces, a 2k and an 8k. Questions Does the unload contain any dbspace information? How does it know to send the tables to the different dbspaces?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
Creating a dbspace with a non-default page size
Hi, My environment : IDS 12.10 FC6 with HP-UX 11.31 I'm creating a new instance for a datawarehouse and I want to use the option -k pagesize of the command "onspaces". I want to use the non-default size only for data dbspaces, not for root, logical, physical or temporary dbspac…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
Re: RE: Error building 'sysmaster' database
Hi All, I had same issue recently in IDS 11.70 on linux. And as per Art I tried to execute the buildsmi script but did not helped. Increasing the ROOTSIZE in onconfig file resolved the issue for me. Hope this will help. Thank you. ~ Pravin Bankar…
backups
A (maybe minor) point on memory growth/allocations ... the initial LOCKS structure is allocated in the RESIDENT portion of the engine. Any new structures are allocated in the VIRTUAL portion, thus the new segment allocations. Thanks - Mark Scranton The Mark Scranton Group mark@m…
onbar -c -F in Windows Informix instance
My bad: Correct: onbar -b -F In initial threads I put: onbar -c -F (which was my typo mistake)…
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)…
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
Informix upgrade path
OK and Thank you very much ! yes I'm planing to initialize completly new engine - I 'm also planning to make also from stand alone server to SD secondary in Linux cluster.…
Insufficient space in temporary dbspaces
Hi, >>>> My IDS log is reporting "Insufficient space in temporary dbspaces" and I think I have enough space. IDS: IBM Informix Dynamic Server Version 12.10.FC5WE Platform: CentOS release 6.6 Spaces: | [informix@lpsalxids ~]$ onstat -d | | IBM Informix Dynamic Server Version 12.…
dbspaces corrupted
We have Version 11.70FC4 sitting on a Red Hat 5.9 server that is, in turn virtualised. All dbspaces are on cooked file systems. We had a process that blocked the server using "onmode c block" followed by a level 0 backup using "ontape s L 0". At some point during the backup,…
onbar Backup error
Hi, I am getting "131, ISAM error: no free disk space" very often. Sometime back I have rectified it by increasing ROOTSIZE for rootdbs. But it has come back again after few backup and restores using OnBar. I have tried adding temp space using: chown informix:informix /tmp/tmpSpa…
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
consolidating dbspaces
HP UX B.11.31 U 9000/800 IDS 11.70.FC7GE Good Day, I want to consolidate a number of 2gb chunks into a single chunk. Can anyone advise me on how to do that ? Thanks…
Physical Log size 2000 is too small
Hi, Good Day We are receiving an error when initializing the informix instance Physical Log size 2000 is too small. the command onparams -p -s 2000 was ran on the server and when is was restarted the error above was displayed. The problem is that we cannot again issue an onpa…
ROOTSIZE defaults
Configuration parameter ROOTSIZE in Informix v12.10.x defaults to 300000. This is different from our production version (11.70.x, HP-UX ia) where ROOTSIZE is 200000. I'm trying to understand the reasons for this size difference. The v12.x engine does come up with ROOTSIZE of 2000…
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
upgrading 11.70 to 12.10
I want to upgrade 11.70tc3 to 12.10tc2 on a Windows server 2008R2 machine. I did this on my development server by using dbexport and then uninstalling 11.70 and then installing 12.10 and then dbimporting data. (As I recall, the installer would not do an upgrade over the top of th…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
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.…
Performance impact with different page size
Hi, I am using informix 11.5 on Solaris and the database storage structure as one datadbs is with 16K page size second datadbs is with 4k page size and third datadbs is with 2k page size while log dbspace ,root dbspace and physical log dbspace is with 2k page size . My question …
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
Re: How to initialize fields
On Thu, Aug 16, 2012 at 12:00 AM, Francesco Alfano <edacedpa@yahoo.it>wrote: > How can I write a routine in Esql/C which initialize to 0 (zero) all > numeric fields (smallint, decimal, etc) and to (' ') space the other > fields in a table? > You've been given answers. I'm goin…
Re: How to initialize fields
See Marco's reply. Art Sent from my Galaxy S®IIIFrancesco Alfano <edacedpa@yahoo.it> wrote:I don't understand very well, can you give me a sort of sample code ? If I using your example, how can I perform different initializations for the numercic fields (initialized to 0) and …
Re: How to initialize fields
On 16/08/12 14:33, Francesco Alfano wrote: > I don't understand very well, > can you give me a sort of sample code ? > > If I using your example, how can I perform different initializations for > the numercic fields (initialized to 0) and alphanumeric (initialized to ' ') > > > T…
Re: How to initialize fields
I don't understand very well, can you give me a sort of sample code ? If I using your example, how can I perform different initializations for the numercic fields (initialized to 0) and alphanumeric (initialized to ' ') Thanks for your response. Il 16/08/2012 15:21, Art S. Kag…
RE: How to initialize fields
You can use memset to null out the entire struct which will take care of the binary fields then one field at a time put a space into the first characters of the char fields. Sent from my Galaxy S®IIIFrancesco Alfano <edacedpa@yahoo.it> wrote:Hi, How can I write a routine in Esql…
How to initialize fields
Hi, How can I write a routine in Esql/C which initialize to 0 (zero) all numeric fields (smallint, decimal, etc) and to (' ') space the other fields in a table ? Thanks for your response.…
reduce size of root dbspace
How to reduce size of root dbspace in Informix 11.7 ? Currently I have moved logical logs, physical logs, databases, temporary dbspace all out of root space. Currently only 6% of my root dbspace is used after importing required databases and there is slim chance that the database…
IDS 7.31 UD5 data(base) recovery
hi, i'm looking for any solution which allow me to get database server online or export data from dbspace the state is as follows: # onstat - Informix Dynamic Server Version 7.31.UD5 -- Fast Recovery (CKPT REQ) -- Up 22:31:46 -- 98304 Kbytes Blocked:CKPT # ontape -a Perfo…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
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 …
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
Informix doesn`t start
Hi, maybe this will help, Few varibles from ONCONFIG.ol_ids_1150_1 ROOTNAME rootdbs ROOTPATH C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\rootdbs_dat.000 # Path for device containing root dbspace ROOTOFFSET 0 ROOTSIZE 204800 # Size of root dbspace (Kbytes) MIRROR 0 # Mirroring flag (Yes …
dbpaces
hi, i want to copy using sql a table from 1 dbspace to another dbspace . Is this operation possible with ids 11.50? exemple: insert into dbpace1.database1.table1 from select * from dbspace2.database2.table2 thank's for your help…
Archive Behavior Change???
First confirm to see if dbspace r1 was actually backed up during the prior level 0 by checking both the online msg log and the onbar activity file I recall that the engine confirms the time stamp of the most recent level 0 from the dbspace root reserved page. So something could …
Cannot initialize instance
This is using IDS 11.7, on a box with one instance running using the same $INFORMIXDIR. This is the output on the screen: v6live > oninit -v Reading configuration file '/housing/informix/ids11_7/etc/ onconfig.v6live'...suc ceeded Creating /INFORMIXTMP/.infxdirs...succeeded Check…
Drop DBSpace
Hi experts, I want wo drop a dbspace, which we have been using for some byte columns as blob store. Now, we added a smartblob space and copied all the values to a blob column. The whole table was copied and access to the new table works good. Old table was dropped now. We want t…
oninit: Not enough room in ROOT DBspace.
Look at the number and size of logical logs and the size of the physical log. Art On Oct 12, 2011 8:13 PM, "BRETT SIMPSON" <brett.simpson@actrol.com.au> wrote: > Requested 9661038K, ONCONFIG value 'ROOTSIZE' 2097152K. > > using onspaces -c rootdbs -p /database/chunk03 -o 0 -s 2…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
Help! Broken server destroys customer demo...
On 03/08/2011 12:26, NEIL HAUGHTON wrote: > Here's some more information, the output of an oninit -v command: > > Checking group membership to determine server run mode...succeeded > Reading configuration file > 'C:\\\\PROGRA~1\\\\IBM\\\\Informix\\\\11.70/etc/ONCONFIG.ol_matdemo'…
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…
stupid question time
Informix 11.50.FC6 on HP-UX 11.31 ia64 (Integrity server) BL870c I have a nightly cron job that run Jacob Salomon's monitor-space script to check how full dbspaces are. Well this morning I got a report that root is 91% full. Root dbspace has one 2GB chuck. Since it has been ove…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
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.…
Recovering database from dbspaces
Hi, I have dbspaces(root, data and log) of an instance. I want to recover the database from these physical files on some other machine having same OS and hardware. Is there any way to get it done? Thanks, Anees…
Initializing ISM
I am getting the following message when I try to initialize ism: *** You need to set $INFORMIXDIR before running the ISM setup script. I have $INFORMIXDIR set up. I am wondering why ISM won't let me initialize.…
dbspace planning
Hello, I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices. Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP? I'm planning layout below: disk 1. rootdbspace, phys log, logical …
Instance Crashed !!
Physical Memory of machine is 32 GB. Swap space is 24 GB. Using IDS 11.50.FC6 Also, is it better to allocate more memory (initially) or in chunks (for OLTP Application) ? Thanks…
Performance advantage: fragment across dbspaces vs. in single space
Is there any advantage to fragmenting across multiple dbspaces instead of simply fragmenting in the same space? Aside from performance, are there any other reasons to fragment across dbspaces? Using IDS 11.50.FC4 on HPUX 11.23.…
Changing physical log size in non-rootdbs
Found the answer by doing. FYI... Take IDS 11.5 to admin mode (quiescent)using onmode -j. Use onparams -p to move log from its non-root-dbspace to another dbspace (where there is enough room for a physical log of the same size). Run fake archive. Drop the dbspace where the ph…
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…
onunload dbspace handling
Does onunload/onload handle variations in dbspaces? That is: 1) If I onunload a database which resides in 2 dbspaces, can I onload it into another instance with differently named dbspaces? If so, what is the command line syntax? 2) Can I onload a database which resided in 2 d…
informix dropping idle connections
Stuart In regards to the sde connection swwe see this in the log Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized for dev1110 . . . Instance initialized…
rootdbs size
We are trying to initialize our 11.1FC3 install on RHEL 5 as part of an upgrade to a VMware server and from an existing HP/UX-9.4 environment. We are using raw devices for our chunks. Based on our 9.4 installed, I created chunks for rootdbs of 350MB and a chunk for physdbs of 10…
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
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…
Raw Devices
Currently we are using our database on IDS 11.50.FC6 and our dbspaces are on UFS file system.Can we transfer our existing dbspaces on raw disk and how we do it , Also how much down time is expected.…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
Cannot find or open library file: -l 4gsh
We reinstalled Informix and 4GL under a new directory and now everything is working. Thanks for the initial reply!…
Dbspace recovery
Hi, I have started testing revovery of a singe dbspace or all. The senario is that the server that the IDS was running on is completely gone and we have to restore a backup from the backupsystem (we use Veritas NetBackup) to a new server/host running the same IDS version (for ti…
RE: IBM's Academic Initiative
Poor OTC... You yet again miss the point? Did you wake up on the wrong side of the bed? Look, you silly git, the point was that I was initially talking about IBM and IIUG's efforts to 'seed the field' through their academic initiative. We can all go back using Google's 'time ma…
Re: IBM's Academic Initiative
Ian Michael Gumby wrote: > Jerry, > > Shame on you. > Running your own little spin campaign. > > Is IBM's Cloud initiative the same thing that IBM launched with the IIUG? > I think not. > > Where is the IIUG in the article? > At the same time, Informix was mentioned only once. Al…
is possible multiple instances with the same dbspace?
Hello, I have 5 different servers replicating in other server. I would like to have only this root server and other instances running together and sharing the root dbspace. I can run different instances with differents dbspaces, but i would like not to duplicate data. Is it p…
shared memory not initialized for INFORMIXSERVER
When I try to start Informix Dynamix Server the following massage appears: shared memory not initialized for INFORMIXSERVER Any idea???…
shered memory not initialized for INFORMIXSERVER
When I am trying to start informix server the following massage apears: shared memory not initialized for INFORMIXSERVER Any idea??????…
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…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
Create index errors
Apologies if I'm teaching Grandma to suck eggs, but have you confirmed the number of extents that are being used? Those figures look suspiciously like the initial values used when creating a table. Simon…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
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…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
Upgrading to Infx 11.5
Hi, We are upgrading informix IDS from 7.3 to 11.5. We have started this in development server. We tried to bring IDS 11.5 up using the same 7.3 onconfig and sqlhosts file and we could successfully bring up IDS 11.5. But we are now not able to bring up IDS 7.3. We tried to i…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
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 …
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
Help : Assertion Failure Type: CRASH
Yes, I've tried this, but got error : oncheck -pt 1048854 shared memory not initialized for INFORMIXSERVER 'myServerName' Thank you for helping…
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…
Fake Informix Server
"oracle, old sherwoodian" <rana_gman@hotmail.com> wrote in message news:d8fce806-ff18-451f-9450-93a75b415f94@a39g2000yqc.googlegroups.com... > Hello, I was wondering if anyone ran into this condition! > I'm running Informix on Linux (Red Hat) OS. The boot sector and > Informix Se…
Infomix on Campus Academic Initiative
One of the hottest topics around... IIUG is working with IBM on this subject. For more info please check the latest IIUG insider: http://www.iiug.org/Insider/insider_jan09.php And answer the online survey: http://www.iiug.org/url/survey.html You can comment freely, make sugg…
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
slow views on IDS 11.50FC1
On 7 Oct, 22:30, ralf.blankenb...@eurotaxschwacke.de wrote: > Hi, > changing from 10.00FC4 to 11.50FC1 causes a "select * from view_XXX" > to run more than 2 hours. On 10.00FC4 this select took not more than > 10 minutes.An unload directly from the tables with the same select > s…
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…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
segmentation fault with c4gl
Hi Henrique Lima, This code has been scheduled to run every day once through the crontab utility. Initially it was working. So, this implies that the problem is occurring after running the program several times. Thanks for your response. Regards Kiran.…
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…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
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.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
ontape -s using too much temp space
I'm running IDS 11.10.HC2 on an hp-ux 11i machine. We just upgraded from 9.40 3+ weeks ago. Previously, we had no problem running level 1 backups during the day. However, now I am noticing that my temp dbspace will sometimes fill up during the level 1 backup. I just aborted the b…
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…
How to initialize an SDS instance
Hi, is there anybody who installed an SDS instance on IDS 11.xx. Maybe you can tell me where I can RTFM? Is theI have there anything I have to take into consideration when creating my raw devices? TIA Stefan…
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…
sequence problem on IDS 9.40
I seem that I understood. Do not use ALTER SEQUENCE RESTART WITH ... statement. Dbimport use this syntax to set initial value for sequences. After migrating database using dbexport/dbimport it's required to recreate sequences (drop/create start with..).…
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
restore a single table from tape
Can you restore a single table from a full Informix Archive tape? We are running Informix 10. I have a scheduled backup every evening that backups the entire dbspaces. I have dbs0, dbs1 and dbs2 along with temp and root dbspaces. Our live database is in dbs0, train in dbs1 and de…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
unable to initiate asyncronous read operation!!!
(281) unable to initiate asyncronous read operation. ids 9.4 sometimes have error like this and connection to the database is very slow! windows is 2k server. server is hp xeon lh 4. what can it be?…
Re: shared memory not initialized
Tom I may have missed this in the variety of posts ! but do i understand this is a new installation and has never run? If so have you actually initialised the engine (oninit -i) at any time? Keith On 13/08/07, Ogiwara Tsutomu <tsutomu_ogiwara@hotmail.com> wrote: > Hi Tom. > > …
Re: shared memory not initialized
Thanks Andreas, The system is resolving the host name fine. uname -n reports informix. when i ping informix, i get a reply from the correct IP, 192.168.26.66 Still no luck Tom On Aug 9, 4:55 am, Andreas Breitfeld <abrei...@de.ibm.com> wrote: > Maybe my hint regarding the 'set…
RE: shared memory not initialized
You didn't need to run oninit -v the second time, the first time (oninit -ivy) was enough. The second time around it tries to pop memory back in the same place as the last one. Check if the first one is still running: onstat - It probably is. If not, then you may have corrup…
RE: shared memory not initialized
The holy trinity is ONCONFIG, sqlhosts and /etc/services. Your entries look ok at this point - sounds like your rootdbs either does not exist or has wrong ownership/permissions (previous note). You also need environment variables: INFORMIXSERVER=informixserver (in your case) ON…
shared memory not initialized
I have just installed Informix 10 on a CentOS 4.5 system. When I run oninit -v to start the dbserver, I get the following, and then it dumps me back to bash: [root@informix informix]# oninit -v Your evaluation license will expire on 2007-10-30 00:00:00 Checking group membershi…
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
Re: IDS 9.4 instance can't initialize dbspace
Gary Quiring wrote: > Continuing the saga from my ontape restore to a different server I am > taking the suggestions to use archecker and IDS 9.4 to do a table > restore. My current server is 9.4. > I created an IDS 10 directory and changed all the paths and ENV vars to > use …
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
On IDS 10.00 when I trying to startup it remains eternally. In another screen (onstat -) appears IBM Informix Dynamic Server Version 10.00.UC6TL -- Fast Recovery (CKPT REQ) -- Up 03:37:18 -- 685576 Kbytes Blocked:CKPT. That I must do?…
Sysprocbody is full - how to get more space???
Bret Schuhmacher wrote: > Thanks very much, Jonathan! I think I've done what you recommended, but I'm > still getting the same error. I did the following: Please post the following: onstat -d Output from the following select: dbaccess sysmaster - <<EOF select dbsname, tabna…
Re: IBM and Oracle - Let's Rrrrrrrrrrrrruuuuuuuuumbbbbbbbbbbleeeeeeee
>From: DA Morgan <damorgan@psoug.org> [SNIP] Speaking of trolls... _________________________________________________________________ Download Messenger. Join the i�m Initiative. Help make a difference today. http://im.live.com/messenger/im/home/?source=TAGHM_APR07…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
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…
Files in /tmp
Hi, Could it be something like temporary sort-work-files ? No place anymore in temp dbspace so files are created in /tmp ? Do you have DBTEMP and PSORT_DBTEMP variables set ? Jacques Lapeire -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] …
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
IDS 10 instance can't initialize dbspace
Hola Gary, si estas inicializando IDS 10 (oninit -i), el valor de PHYSFILE debe ser menor que el ROOTSIZE, bastante menor, ademas el PHYSDBS debe igual que ROOTNAME. Por ejemplo: > ROOTNAME dbroot # Root dbspace name > ROOTSIZE 1008538 # Size of root…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
error initializing
Hi: when initializing my INFORMIX leaves the following message to me error: $ oninit -v Checking group membership to determine server run mode...succeeded Reading configuration file '/usr/informix/etc/onconfig.nazca'...succeeded Creating /INFORMIXTMP/.infxdirs...succeeded Creat…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
size of rootdbs
On 30 Nov 2006 01:26:14 -0800, doitman <sunil.saggar@gmail.com> wrote: > Hi all, > > What should be the size of rootdbs .I mean the optimum size. > How does the size of rootdbs affect the IDS performance? > It is takijng a lot of time to initialize ..Is it normal(as per my > con…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
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: tblspace tblspace extent size calculation for
You'll need one page for each table or index fragment in a dbspace. So, if you can guestimate how many tables/indexes/fragments you will ultimately have you can figure it out fairly precisely. Otherwise, ... Art S. Kagel ----- Original Message ----- From: Peter J Diaz De Leon <i…
tblspace tblspace extent size calculation for IDS
Does there exist calculations (or rules of thumb) for determining what the initial and next tblspace tblspace extent sizes should be for both the Root dbspace and non-Root dbspaces. Thanks Peter…
mirroring dbspaces
Hi all, anyone having experience with mirroring ? I inherited an informix config from a former collegue, and it looks very strange and insecure to me. In short : system running Solaris 8, 2 disks. All slices EXCEPT slice 6 (used for Informix raw-devices), are mirrored with Sol…
Re: Onpload error -- onpload exited abnormally during initialization
vratesh.chopra@gmail.com wrote: > encounter stated initialization error while using onpload for Informix > 9.4. > Which 9.4 version? What is the error number/message? Log a support call with IBM!…
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…
Can't drop down dbspace
I've been restoring a development database from very old backups (long story). Due to errors doing a full DB restore, I restored the critical dbspaces and 1 user dbspace. Logical restore of the next dbspace fails in the same logical log, probably due to a corrupted index. So that…
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…
Quick Ontape -r rootdbs question
Hi, If you attempt to use the ontape -r with redirection of the chunk names parameters for a specific database, is there any effect on rootdbs for the other databases? In other words if we have a 2 server set up described below and restore one dbspace, will ontape also restore th…
TEMP DBSPACE
Hi we have two quries like below create temp table tmp_table_no ( sl_no serial, lang_a char(2), lang_no char(14), rec_cnt integer) with no log second one is insert into tmp_table_no (lang_a, lang_no , rec_cnt) ", select distinct language_a, lang_no, count (lang_no) from ti_lang…
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: Cannot connect from windows client to IDS 10 with sdk 2.9 on Linux
Can you ping to "kylie" from Windows system ? if not, try using IP address of kylie What's the INFORMIXSQLHOSTS entry on Windows system ? make sure you are connecting to 'pic_ids1'. Regards, Nilesh Tuesday, April 25, 2006 11:55 AM To: informix-list@iiug.org cc: From: "kjulif…
Cannot connect from windows client to IDS 10 with sdk 2.9 on Linux
We are running redhat enterprise 4, and IDS 10. We just cannot connect via tcp from clients on our LAN. We HAVE set up INFORMIX SE on other machines in the past and had no problem. Now we are stumped. On past machines we have run SE and are used to seeing the sqlexecd demon, b…
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/…
initialization rhead struct failing
my os sco openserver5.05 + informix IDS 7.31 can you tall me what rhead struct do it…
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…
Re: create a DB on Linux
GRMBLLL the time spent on pissing off this guy could really be better spent telling him howto and then after that kindly refer him to the manual or googling..... assume you have installed it without setting up a demo instance. env vars: assume informix is installed in /opt/infor…
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…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
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!…
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
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.…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: chunk reserve page extent
A minor correction... Basically, the reversion routines take care of putting the extents back into the root chunk when you are reverting to a system that doesnt understand chunk reserve pages not on the root chunk of the root dbspace. So, there is no issue during reversion. If t…
Re: chunk reserve page extent
On 9/14/05, Rastislav Janac <rastislav.janac@dignitas.sk> wrote: > > I intuitively understand what this message in online.log means, > <>11:02:56 chunk reserve page extent is allocated from non-root chunk: > (51:13292,42) > 11:02:56 chunk reserve page extent is allocated from non…
Re: Informix/TSM Point In Time Restore
Not sure... but doesn't informix need to ensure the whole instance is consistent? Therefore it'll need to recover all dbspaces to the same point-in-time. Is "time1" in the past? That may not work. After the physical resotore, can you apply logical recovery to just those dbspa…
Re: ontape vs onbar
"Superboer" <superboer7@planet.nl> wrote in message news:1123830503.185843.157390@g49g2000cwa.googlegroups.com... > -->Root, log log, phys log (3 x temp), one large application dbspace. > > i would create more dbspaces... one big dbspace will not be done in > paralel. Thanks. I…
RE: Ontape Restore Merging Servers
Thanks for all of the questions/answers. I was expecting the initial answer that Art gave about dbexport/dbimport. I hadn't specified database names in my initial message and completely understand Keith's thoughts of unload/load if that were the case. This should help greatly …
Change chunk name
not really no. At minimum, assuming its not a critical dbspace 9root, physlog or loglogs) the you'd need to 1/ unload all the data from the dbspace 2/ drop the dbspace 3/ recreate the dbspace and all its chunks using the new patch fo rthe chunk 4/ reload all the data sorry…
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…
FW: Have you seen this?
Anyone out there able to answer what is happening here? =20 =20 + oninit -iy oninit: Not enough room in ROOT DBspace. Requested 180638K, ONCONFIG value 'ROOTSIZE' 100000K. oninit: Fatal error in shared memory initialization =20 The Tech Svcs store restore process executes oninit…
Database and no dbspace
Help. The dbspace is drop but now the database can't be drop. How do I drop/remove the database. I have created the dbspace but no luck. error: 311: Cannot open system catalog (systables). 135: ISAM error: TBLspace does not exist…
rootdbs memory problem
agt122:(informix)/home/informix>oninit -iy oninit: Not enough room in ROOT DBspace. Requested 213638K, ONCONFIG value 'ROOTSIZE' 160000K. oninit: Fatal error in shared memory initialization agt122:(informix)/home/informix>…
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:…
Re: Checkpoint stalled
Post your ONCONFIG file contents and a tail of the message log (onstat -m) containing a couple of checkout report lines. Art S. Kagel ----- Original Message ----- From: Parameshwar.... <pcdudyala@yahoo.com> At: 5/30 11:59 Hi, I am facing problem while initializing(disk) the ser…
Please Help!!!!!!!!!!!!!!!!!!!!!
"ERROR: could not initialize the security subsystem. please ensure that this account has the necessary privileges and insure INFORMIXSERVER value exists in the registry and environment."…
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: RE: New installation
Yes. In fact, one can automate the process with onparams, which automatically (it or by side effect) change your onconfig file appropiatly. J. -----Original Message----- From: Mike Dunham-Wilkie <mike@barrodale.com> To: "Murray Wood \\(IList\\)" <ifxmaillist@quanta.co.nz>, <in…
RE: New installation
Brian You have told Informxi to create a dbspace on 60Mb. Yet the initial contents of rootdbs in your ONCONFIG add up to 161Mb. It will not fit. Think you may want to set ROOTSIZE to 512000 MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-…
New installation
I'm installing IDS 9.4 on a new machine (Solaris 9). The install went fine. I set up a 512MB raw chunk for the rootdbs. I set the ROOTSIZE to 60000 When I do an oninit -i, I get the following: bash-2.05$ oninit -i This action will initialize IBM Informix Dynamic Server; any exi…
Re: Server won't initialize
Hi, setting SHMBASE to 0 certainly will not help. This is valid on HP-UX, but not other platforms. Check the "Machine Specific Notes" in "$INFORMIXDIR/release/en_us/0333/" directory for the recommended setting of SHMBASE for your platform. A letter "L" or "l" (for long) added t…
Server won't initialize
Hi, We seem to have a problem getting the server to initialize. We get an error shmat: [ENOMEM][12]: out of available data space, check system MAXMEM if we increase the amount of BUFFERS. I seem to get up to a limit of +- 120 MB shared memory although the machine has memory of 5…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
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…
Help!!!!
I am getting the following error when I try to run oninit: oninit -iy oninit: Not enough room in ROOT DBspace. Requested 218138K, ONCONFIG value 'ROOTSIZE' 150000K. oninit: Fatal error in shared memory initialization What do I do next? Regards, David…
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…
temp tables in IDS
I have a vendor application that appears to be creating temp tables in the root dbspace. I'm baffled. I don't want their temp tables pounding IO in the same dbspace at the system catalogs. There are 2 temp spaces, and the application database is created in dbspace 'dbs1'. They ma…
Fwd: RE: oninit: Not enough room in ROOT DBspace. [4035
How about simply an ONCONFIG paramter, ONINITLOCKED 1, means oninit -i is disabled! One would have to edit the ONCONFIG file to remove or disable the parameter (ie set to zero) in order to purposely init an existing instance. AND, oninit itself could add the parameter, initialize…
oninit: Not enough room in ROOT DBspace.
As others have already pointed out the oninit -i destroyed the existing instance and created a new empty one. HOWEVER, it MAY be possible to recover the original instance, IFF there were not databases living in rootdbs or you have an up-to-date archive and logical log backup from…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
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'?…
Re: Stripe and Mirror Everything?
"Claus Samuelsen" <csa@eye-bee-em.com> wrote in message news:41494202$0$212$14726298@news.sunsite.dk... > > I would certainly consider two dbspaces - the root dbspace and a > temporary dbspace. In a logged database transaction record writing > (which is typically the most io inte…
IDS 9.3.0 Error in initialize
Encountered below error while initializing the IDS 9.3.0 server. Any idea ? Program stopped at "tb4_exsq.4gl", line number 922. FORMS statement error number -1102. Field name not found in form rgds Ajith…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
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…
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…
cannot initialize root dbspace
$ 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 server run modesucceeded Reading configuration file '/informix/etc/on…
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…
Logical logs from rootdbs to own logspace
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
cannot initialize rootdbs
***************************** informix 7.3 UD1 running on Solaris 8 with 70 Mhz CPU and 168 MB RAM ****************************** Problem : Fatal error in shared memory creation error 156 command : $ oninit -i This action will initialize Informix Dynamic Server; any existing In…
shared memory not initiaized for INFORMIXSERVER
Geezer From The Freezer wrote: > > shared memory no initialized for INFORMIXSERVER 'informixservername' > Your engine has died?…
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.…
Re: ER initialization problems
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<SyHhc.12569$GR.1757984@attbi_s01>... > Is there a case open? > > > "Harry Johnson" <hjohnson@keeneinfo.com> wrote in message > news:6830f442.0404211702.170bc10a@posting.google.com... > > "Madison Pruet" <mpruet@comcast.n…
RE: Performance advice
On Thu, 22 Apr 2004 03:00:06 -0400, Willem Roos wrote: > I've been led to believe that all logged temp table activity goes to rootdbs > and all unlogged activity goes to temp dbspaces. Yes, no? <SNIP> If there are no 'normal' dbspaces listed in DBSPACETEMP then logged temp tabl…
Re: ER initialization problems
"Madison Pruet" <mpruet@comcast.net> wrote in message news:<j3nhc.169851$gA5.1981630@attbi_s03>... > no, but I'd like to see the output of several onstat -g ath on the gr_asp2 > when the target is hanging... > > > "Harry Johnson" <hjohnson@keeneinfo.com> wrote in message > news:6…
Re: Semi-Annual NoRAID5 rant
Mark Townsend wrote: > FYI - http://www.baarf.com/ hey hey - you're famous, Art. We also need a BAUAO initiative.…
ER initialization problems
I am having a problem initializing ER on my 2 Linux servers. I am running Informix 9.4.UC3 on both. I had a problem on the target server so I deleted the server on both the Primary and Target using: "cdr delete server gr_asp" on the primary "cdr delete server gr_asp2" on the t…
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…
Can I use UNC file shares for dbspaces?
Hi informix specialists, I have a filer that offers plenty of disk space and I would like to use it for root and other dbspaces. To be independent from any disk drive letters, I would like to use the UNC notation like \\\\filer\\share\\dir1\\rootdbs_000. Has anyone been able to…
Re: An interesting meeting with IBM
I forgot to mention that work is being done in Enterprise Replication so that re-synchronisation is much easier. Getting that initial sync, and then maintaining it when schems changes, is the only real hassle with ER at the moment.…
Initial creation of database?
i'm using informix 9.2 and ISA 1.10 and i believe i've installed both of them. But how do i actually create an initial database? Can i use ISA to create? because it seems i must have a database first then i can use ISA? or am i missing something? thanks!…
SMI Table
How to use smi tables to create a list showing all dbspaces and databases in each dbspaces? Thanks.…
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,…
Rootdbs gets filled
Hi bro, rootdbs seems pretty small: ROOTSIZE 30000 # Size of root dbspace (Kbytes) - Consider a bigger rootsize (256M, 512M, your milleage may vary) - I suppose you've set up a temp dbspace, right? its almost a basic rule for an installation. - move logical logs to its own dbs…
dbspace destroyed
Hi! On one machine dbspace was destroyed by unwary sysadmin who repartiioned disk with informix chunks on it (raw devices). Now, informix can be started (it complains about missing chunks though). What is the procedure for removing staled information for chunks? I should remov…
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…
Re: newbie with problems restoring db
"Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:bvttvi$10m2t3$2@ID-64669.news.uni-berlin.de... > Daniel wrote: > > > I tried "$0.00" and that did not work. However, "0.00" did work. The > > dbimport program ran more this time, but did not complete itself. I got a …
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…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
Serial, serial8 initialization values
Hi, Does somebody help me with next problem on IDS 9.30 ? Where in the database are written intialization values of serial or serial8 data types? With regards Jozef…
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…
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
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.…
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.…
ODBC access from aix to a informix db V7.12
Hello! is there anybody who works with a odbc-connection from a aiy maschine to a informix db? because we plan to initiate a connection like this. BR uwe Terborg -- Posted via http://dbforums.com…
IDS 7.3* - Long long long checkpoint !
I've noticed very long checkpoints in the online.log file. What does IDS do in a checkpoint that can take so long ? Environnement: IDS running on NT 2000 or Linux (even SCO !) with at least 128MB RAM, monoproc. IDS is usually the only big apps running on the box. "Small" databas…
big dbspace
Hello, I need a very big dbspace (at least 15Gb) for my database (IDS 9.4) but the limit for a single dbspace is about 2Gb. How can I increase this limit? thank you…
break one dbspace in to two dbspace
Hi all I have one dbspace where I have all data and indexes I wanted to created one more dbspace one dbspace has the data in it one dbspace has the indexes in it how do that ? regard sending to informix-list…
HDR initial setup question
Hi, I've been trying to get a pair of servers to work in HDR (High Availability Data Replication) mode - but am having some problems getting them to be identical in the first place. I have followed the documentation in the Admin guide to configure the two servers to be identical…
HDR initial setup question
Hi, I've been trying to get a pair of servers to work in HDR (High Availability Data Replication) mode - but am having some problems getting them to be identical in the first place. I have followed the documentation in the Admin guide to configure the two servers to be identical…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
How do you update corresponding rows on the same table after a row on the table has been updated?
This is my goal: When specific columns in a row, in a table, are updated, corresponding columns in other rows in the same table need to be updated with the same values as changes to the initial row. This would work if I need to update other columns on the same row: Passing param…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
not initializing shared memory
mt_shm_remove: WARNING: may not have removed all/correct segments what do you do about that?…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
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…
Re-initialize database space?
We use IDS2000 9.21.UC1. During development of a datablade we have crashed IDS multiple times. In several interesting and unique ways I might add. We have 2 active databases on this instance and both are doing strange things. For one example, consider the following 4gl snippet: …
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…
Reg: Max size allowed in creation of dbspace
Hi , I need to create a dbspace of abt 5-6 GB. on using onspaces to create the dbspace i am limited in size to about 2.09 GB is there a way to create a dbspaces of about 6 GB or is there a size restriction ? Thanks for any help Sudhir sending to informix-list…
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…
error on initialization
I'm having a problem bringing up the IDS engine. Oninit -v output = shows: Opening primary chunks...succeeded Opening mirror chunks...succeeded Initializing dbspaces...succeeded Validating chunks...succeeded Initialize Async Log Flusher...succeeded Forking btree cleaner...succee…
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
initial size of tblspace?
hello, can any one answer this question When Informix configures a new DBSpace on disk, it initializes a section called the tblspace tblspace for keeping track of all tables within that DBSpace. What is the initial size of the tblspace tblspace in pages? bye sudhakar -- Posted …
FATAL ERROR
where can help ??? Fatal Error in Initializing ASF with ' ASF_INIT_DATA' flags; asfcode = '25507'…
-640 QPlan sanity failure (2028.0).
Upgraded a 7.31.UC6 server to 7.31.UD1(Solaris 2.6) and get the following.. "-640 QPlan sanity failure (2028.0). " whenever a stored proc is executed. Update statistics fixes it initially, but it still occurs periodically. Patrick McDonough Intraware…
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
Re: location of logs
oncheck -pe From: rsalido@my-deja.com > >Is there a way to find out where my logs are? I mean onstat -l gives me >a bunch of information regarding the logs but I dont think it shows in >which dbspace they reside in.....any ideas? > I just started working on this database and …
location of logs
Is there a way to find out where my logs are? I mean onstat -l gives me a bunch of information regarding the logs but I dont think it shows in which dbspace they reside in.....any ideas? I just started working on this database and I'd like to know if the logs physical and logi…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
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: Root DBspace confusion
Mark, I like your suggested clarifications for this paragraph -- to not say "resize", but instead say "use a minimal log size when you first initialize the database server", and then do all the steps to move and resize the logs after initialization to keep the root dbspace small…
Re: Root DBspace confusion
> > Hi Michael and Mark, > > Yes, this paragraph does not address what to do when you resize the > root dbspace after you've already defined your dbspaces, chunks, etc. > This section addresses sizing estimates BEFORE you start the > database server the first time. We recommend …
Re: Root DBspace confusion
Hi Michael and Mark, Yes, this paragraph does not address what to do when you resize the root dbspace after you've already defined your dbspaces, chunks, etc. This section addresses sizing estimates BEFORE you start the database server the first time. We recommend elsewhere tha…
Re: Root DBspace confusion
Michael Hoffman wrote: > > Hi all, > > A bit of confusion upon reading the Administrator's Guide prior to > installing IDS 9.2. (After reading the following I went back to the 7.3 > manual and found the same passage) > > In Chapter 14 (Data Storage): > If you plan t…
Root DBspace confusion
Hi all, A bit of confusion upon reading the Administrator's Guide prior to installing IDS 9.2. (After reading the following I went back to the 7.3 manual and found the same passage) In Chapter 14 (Data Storage): If you plan to move the physical and logical logs, the init…
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…
Re: rootdbspace
From: "Andreas Bettin" <andy@pneu.com> > >my rootdbs is 100.000 kb. (Engine: Online 5.1, yes really!). In the >tbconfig there is the entry ROOTSIZE 100000. Now, i will >increase the size to 200.000 kb with an second chunk, because we have >problems running big querys with …
dbaccess
Armin Kuepfer wrote: > When trying to start dbaccess on my PC I receive the error message: > "Could not initialize the security subsystem. Check Your environment variables.…
rootdbspace
Hi my rootdbs is 100.000 kb. (Engine: Online 5.1, yes really!). In the tbconfig there is the entry ROOTSIZE 100000. Now, i will increase the size to 200.000 kb with an second chunk, because we have problems running big querys with havy sorts in it. (online says: not enough…
Segmentation fault
Hi! We are trying to install IDS 7.31 on AIX 4.3.2. When initialized, server cannot be launched online - it says "Segmentation error" What could be the problem? Thanks! Sent via Deja.com http://www.deja.com/ Before you buy.…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
RE: increase ROOTSIZE
ROOTSIZE is set during initialization of the database server. Just like any dbspace add another chunk to increase the size of the dbspace. So if you want to increase the size of the root dbspace, you just add another chunnk to the root dbspace using onspaces. Don -----Original …
increase ROOTSIZE
Hi, I read "Informix Handbook" and "Informix Admin for IDS-9.20" but could not find a way to increase rootdbs size. Could someone please give a quick procedure to do it. I would like to increase ROOTSIZE from 20000 to 30000 for both Online 5.x and IDS 9.2. Thanks, Thanh Sent v…
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 …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
rootdbs size error msg
It may be that to increase the physical log while the engine is online the engine needs to allocate the entire new logfile before dropping the old one. In this case you may not have room in the dbspace for both. Try this: 1) Shutdown 2) Edit the ONCONFIG file and increase the P…
initialization script
I'm having problems configuring the initialization script which starts informix server on boot. What I have is this: #!/sbin/sh # # Copyright (c) 1993, 1997 by Sun Microsystems, Inc. # All rights reserved. # #ident "@(#)autofs 1.5 97/12/08 SMI" #su - informix case "$1"…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
RE: IDS2000 on Red Hat 6.2
Increase the size of rootdbs ?? Paul Watson WF Software Ltd Tel: +44 1436 674729 Fax: +44 1436 678693 www.wfsoftware.com/informix > -----Original Message----- > From: Ian Thurbon [mailto:ian_thurbon@omnis.net] > Sent: Wednesday, August 23, 2000 11:15 > To: informix-list@iiug.or…
Re: IDS2000 on Red Hat 6.2
From: Ian Thurbon <ian_thurbon@omnis.net> > >I am having difficulty in starting my IDS2000 server. I have just >installed the server on Red Hat 6.2 and I am getting an error when >issuing the oninit -l command. >The errors are as follows - >"oninit - Not enough room in ROOT DBspa…
IDS2000 on Red Hat 6.2
All, I am having difficulty in starting my IDS2000 server. I have just installed the server on Red Hat 6.2 and I am getting an error when issuing the oninit -l command. The errors are as follows - "oninit - Not enough room in ROOT DBspace. requested 12038k, ONCONFIG value 'ROOTSI…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
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…
Posting from the Informix-list
i want to initialize the database server but i'm taking this message "cannot find message file. check INFORMIDIR and DBLANG" what can i do ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmai…
RE: Database initialisation
From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> > >My logical logs are 64000K of 12 nos. And physical log of 8192K. 12*64000 + 8192 + other bits in rootdbs ~= 776830K at a guess. >-----Original Message----- >From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] >Sent: Wednesday, …
RE: Database initialisation
My logical logs are 64000K of 12 nos. And physical log of 8192K. thsnks, Srini -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Wednesday, August 09, 2000 3:34 PM To: Srinivas Sreekumar; informix-list@iiug.org Subject: Re: Database initialis…
Re: Database initialisation
From: Srinivas Sreekumar <SRINIVAS_SK@inf.com> > >I am trying to initialise a database (multiple residency) when I give >oninit >-i the following error occurs. >oninit: Not enough room in ROOT DBspace. > Requested 776830K, ONCONFIG value 'ROOTSIZE' 200000K. >oninit: Fatal…
RE: Database initialisation
Your onconfig probably has numerous things going into the root dbspace. Your logs will go into the root dbspace when you initialise. Your phydbs may go into your root dbspace. The sysmaster and sysutil databases will also have to go into the root dbspace. Something like ( LOGF…
Database initialisation
Hi all, I am trying to initialise a database (multiple residency) when I give oninit -i the following error occurs. oninit: Not enough room in ROOT DBspace. Requested 776830K, ONCONFIG value 'ROOTSIZE' 200000K. oninit: Fatal error in shared memory initialization In my o…
Re: How Much space do I really have?
From: "Loven, Isaac" <Isaac.Loven@team.telstra.com> > >An ontape -s to disk takes up 500Megbytes. >If this is so, why does onstat show we have used 49.8% of the disk >????????? Because you have your physical and logical logs in the rootdbspace!!!!!!!!!! >We have a 2 Gig Disk a…
Informix 7.31 and Windows2000
Somebody has installed it on Windows 2000 ? The Instance Manager can't initialize shared memory.. Thanks in advance. -=SIMO=-…
Re: Performance comparison btn Informix and SQL Server
From: wu@paris.dvs1.informatik.tu-darmstadt.de (Ming-Chuan Wu) > >I include the outputs of the onstat's cammands as follows. >The onstat's commands are given, while the IUS is running my test queries. > >---include begin >==========================================================…
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…
Converting chars to ints
I have a char field that contains numbers (they are initially scanned so are stored as chars). In dbaccess can I convert them to ints so I can SUM them. Currently I output them and sum them with awk. Cheers…
initialization problem
Hello everybody! I gotta problem. I get an error while initializing informix. oninit: Fatal error in shared memory creation. Version; IDS 2000 on SCO 7.1.0 I undrestand that the total memory (i:e memory segments) that informix intends to grab is exceding the maximum OS limit f…
error when running oninit
Hello, when trying to run oninit i get the following error: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags, asfcode=' 25507' What goes wrong ? Many thanks in advance for your help, Regards, Bernd…
initialize-segmentation falt
I use RedHat6.0 and informix ids7.3 when initialization with onmonitor, there is a segmentation fault I think that the problem is caused shared memory... I heard that in linux, I should set the kernet parameters..but I don't know how to do it..…
Re: Removing a TEST Informix Instance
From: "Sue Athey" <sathey@bepc.com> > >I have a second instance of Informix on a single Unix server that I would >like to remove. Besides dropping the databases and dbspaces (not including >sysmaster, and root, temp and log dbspaces) what else do I need to do? Is >there an unin…
Removing a TEST Informix Instance
I have a second instance of Informix on a single Unix server that I would like to remove. Besides dropping the databases and dbspaces (not including sysmaster, and root, temp and log dbspaces) what else do I need to do? Is there an uninstall feature or do I just have my tech su…
Re: Slowness
Boscia wrote: > Informix Dynamic Server Version 7.31.UC5 -- On-Line -- Up 8 days 14:54:51 > -- 491520 Kbytes How much memory You have? OS needs some memory too. > ROOTSIZE 1500000 # Size of root dbspace (Kbytes) You need such a big rootdbs really? Only 3 Mb …
Initialization-Error
I'm trying to initialize an Informix 7.30 UC6 instance for testing on an HP715 workstation (128 MB RAM): Therefore I've created a cooked device (dd if.... bs... count... of=rootdbs), set the ownership and rights to informix:informix resp. 660 and configured all the rest (as it is…
Re: Error: dbspace chunk
To initialize Informix you must be user informix and the environment variables must be correct. Please refer to my responses below. Don Jerry Chimutanda wrote: > Hi people, > > I'm in my 4th weeek trying to get Informix up and running! > > The following are extracts from some…
OUT OF SEMAPHORES -25580
I am trying to initialize an informix database (7.3 UC2) running on SCO Openserver 5.0.4 but I keep getting this message (2) failure, system out of semaphores oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '-25580' What is wrong Thanks…
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…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
query sysmaster tables for index information
Any recommendations on how I might query sysmaster tables to reconstruct index build commands in SQL? (or is this even possible?) My initial search through the sysmaster and user sys___ tables did not succeed. Thanks for the help. Ben…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
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…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
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…
Problem with IDS 7.31UC5
Hi, is there a known problem with SCO OpenServer 5.0.5 and IDS 7.31.UC5 ? I cannot initialize my Informix server. It doesn't come back from an 'oninit -i'. Thanx…
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…
problem on initialization
Hello, I always get error on database initialization after system crash. The system complained with command "oninit" likes: Cannot find message file. Check INFORMIXDIR and DBLANG The file "online.log" records with something like: Event alarms enabled. ALARMPROG = '/opt/info…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
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: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Role of DBSPACETEMP (II)
Henk van der Geld wrote: > If I create a temp table and DO NOT specify the WITH NO > LOG option, the temp table will ALWAYS be created in the root dbspace, > even if I specify DBSPACETEMP=tempdbs in my environment. BUGS FIXED IN THE 7.31.TC5 RELEASE 116590 TEMP TABLES WITH L…
Remote SQL socket query
Hi, DBSPACETEMP is also an environment variable. Environment variables will be evaluated when you initialize your connection. If you would run the query in a seperate process it will be possible to modify the DBSPACETEMP environment variable before you start the query. Regards,…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
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…
runtime does not log the program name that produces the error?
Does the program work ok in debug i.e the 4gi ? ( Assuming your on Unix ). If so then you probably need to initialize FORM fields and values accepted from them.…
Re: network down error
> From: Don Johnson <DJohnson@usdl.com> > > > >We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get > >around 100 users connected new users cannot connect to the database. > >Onmonitor gives the error "Network Down". When you check shared memory with > >onstat i…
Re: network down error
From: Don Johnson <DJohnson@usdl.com> > >We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get >around 100 users connected new users cannot connect to the database. >Onmonitor gives the error "Network Down". When you check shared memory with >onstat it says that …
Setting up onconfig
Steve burk wrote: > Does anyone know how to or have an example setup file (onconfig) to > setup informix for linux. Also can you use a file for the database or do > you have to use a partition? > Thanks > > ROOTNAME rootdbs # Root dbspace name > ROOTPATH /dev/hda3 # P…
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…
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…
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
Enterprise Replication not active (62)
Why initialize the ER had the error message "Enterprise Replication not active (62)"? My server is 7.30 on HPUX. Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
dbspace not empty
Hi Thanks for all the suggestions about the database reorg - when I finally managed to export all the data I ran an oncheck -pe and 5 of my chunks had data in them and they weren't related to any of my databases - see attached oncheck -pe. Any idea how to clear them out as I ca…
Re: move dbspace/chunks on NT
Jay Walters wrote: > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? > > TIA, Sure. Save data from the dbspace containing your chunk (dbexport, unload, onunload). Remove all data from the dbspace. Drop …
Re: move dbspace/chunks on NT
Jay Walters wrote: > > Is there any way other than backup/restore to move a chunk on NT to > another disk. Can I move the root dbspace this way? Not even that way. On UNIX you would use symbolic links but these are not available on NT. You stuck with the original disks. Art …
move dbspace/chunks on NT
Is there any way other than backup/restore to move a chunk on NT to another disk. Can I move the root dbspace this way? TIA,…
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…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
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…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Re: oninit problem on AIX 4.3.2
May be your logs be big decrease them SR At 01:48 PM 9/9/99 +0200, you wrote: >Having installed Informix, I am now ready to initialize and start creating >dbspaces, but when I run oninit -i, I get the following obscure message : > >oninit: Not enough room in ROOT DBspace. > …
RE: oninit problem on AIX 4.3.2
Check the following parameters in your $ONCONFIG file PHYSFILE LOGFILES LOGSIZE > -----Original Message----- > From: SC [SMTP:simon.clennell@gdbi.com] > Sent: Thursday, September 09, 1999 7:49 AM > To: informix-list@iiug.org > Subject: oninit problem on AIX 4.3.2 > > Ha…
Re: oninit problem on AIX 4.3.2
From: "SC" <simon.clennell@gdbi.com> > >Having installed Informix, I am now ready to initialize and start creating >dbspaces, but when I run oninit -i, I get the following obscure message : > >oninit: Not enough room in ROOT DBspace. > Requested 389764K, ONCONFIG value 'R…
oninit problem on AIX 4.3.2
Having installed Informix, I am now ready to initialize and start creating dbspaces, but when I run oninit -i, I get the following obscure message : oninit: Not enough room in ROOT DBspace. Requested 389764K, ONCONFIG value 'ROOTSIZE' 128000K. oninit: Fatal error in shar…
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…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
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…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
Root partition
Root partition? If you mean root dbspace, then you can add a chunk without any problem. I don't know about increasing the size of the initial chunk. -- Bashar Chalabi CTL, London Webber Valerie H wrote in message <7oumlp$ib$1@news.xmission.com>... > >Has anyone had experience i…
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: Table Creation
Alvin The DBSPACE where the database was created. Murray Wood ----- Original Message ----- From: Alvin Palacios <apalacio@mnl-hub.dhl.com> To: Informix Mailing List <informix-list@iiug.org> Sent: Friday, 30 July, 1999 17:15 Subject: Table Creation > > All, > > Here's the scen…
GLS initialization failed,
Hi, Anybody here who can help me with this error - message? What does it mean ? Your "cron" job on goofy1 /home/informix/logbook produced the following output: GLS initialization failed, error -23101 Thanks…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Re: Initialization question
--- Octav Chiriac <com@netinfo-moldova.com> wrote: > Could you post the results of following command: > ls -l /INFXDATA/ol_chunk > Here: -rw-rw---- 1 informix Informix 0 Jul 27 13:55 /INFXDATA/ol_chunk > Additionally: > ROOTSIZE and ROOTPATH from ONCONFIG ROOTPAT…
Re: Initialization question
Could you post the results of following command: ls -l /INFXDATA/ol_chunk Additionally: ROOTSIZE and ROOTPATH from ONCONFIG and the amount of free space on the filesystem when ol_chunk is located (of course if it not a link to a raw device file). And what do you mean by …
Re: Initialization question
So, here's the oninit -ivy output: Reading configuration file '/home/informix/etc/onconfig.ol_andris'...succeeded Creating /etc/.infxdirs ... succeeded Creating infos file "/home/informix/etc/.infos.ol_andris" ... "/home/informix/etc/.conf.ol_andris" ... succeeded Writing to inf…
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…
Re: Initialization question
Ok. I don't remember when this error message happenes, but you could try checking: 1. The file ol_chunk has the right ownership and group (informix) and the right permissions (660, rw-rw----) 2. There is enough disk place on the filesystem you have create the file ol_ch…
Initialization question
Hi! I'm trying to install IDS 7.21 on UNIX. I created file, named it 'ol_chunk' and concatenated it to /dev/null (don't know why... just follow the manual). And I set the ONCONFIG parameter ROOTPATH to this file. IS it enough? Will the oninit command create primary dbspace its…
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…
Contentets of a chunk
> > We use DBSPACETEMP=temp different of root dbspace. > > We have a problem with a chunk in root dbspace. Sometimes it grows When you are using SELECT INTO TEMP WITH NO LOG - this goes to the tempdbspace, but when SELECT INTO TEMP - this goes to the root dbspace. In other words…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
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…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
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.…
Re: oninit / oninit -i
Andreas Lommel wrote: > Here I have a Informix-DB on 7.30 on Solaris. Which is the difference > between starting the database with ONINIT and ONINIT -i ? A big difference, The -i initializes your database.…
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…
dbspace and the table
How can I identify in which dbaspaces the table is located?…
DBSPACE
Author : T.Jalaludeen E-mail : jala@hpsgm99.sgp.hp.com Hai, I created a database in INFOMRIX 7.23 - HP UX. I created tables also. But later I found thatthe transaction logging has not been turned ON for this database, so droped the database and created using "CREATE DATABASE <d…
Re: DBSPACE
"T.Jalaludeen" wrote: > > Author : T.Jalaludeen > E-mail : jala@hpsgm99.sgp.hp.com > > Hai, > I created a database in INFOMRIX 7.23 - HP UX. > I created tables also. But later I found thatthe > transaction logging has not been turned ON for this database, > so droped the databas…
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…
DBSPACE size
In article <37244F3E.301B4680@uco.es>, Aurelio <i52sacaa@uco.es> wrote: > > It is possible to create a rootdbspace during instalation larger than 30 > Mb ? > > Sure, Depending on how much space you have in the file listed in ROOTPATH (see your system admin?) in your $ONCONFIG…
Rename Dbspaces
Does anyone know of a safe way to rename a dbspace? I can't drop and recreate the dbspace, because it's the "home" for a database, and the database is too large for dbexport/dbimport.…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
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…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
Re: How to find out tables in a dbspace?
>My root dbspace is getting pretty huge. Logs are in their own dbspaces. >How do I findout what tables are there in a given dbspace? >There should be away to figure this out by looking at sysmaster? I'm sure you can, but I don't have manuals to hand. However, oncheck -pe (or tbc…
How to find out tables in a dbspace?
Hi: My root dbspace is getting pretty huge. Logs are in their own dbspaces. How do I findout what tables are there in a given dbspace? There should be away to figure this out by looking at sysmaster? Any pointers will be appreciated. System config: IDS 7.24 UC6 IBM AIX 4.2.1 …
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
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?…
How define the dbspace where an index must to be created?
When I created a table with primary and foreing key informix define an index automatically for each key, that is fine to me but I need to define these indexes in other dbspace than root dbspace. Somebody know how to do it? Thanks. -- Luis M. Ramos V�lez GM GROUP, Puerto Rico lram…
Create DBSpace...
Hi folks, We're trying to automatize our database installation throughout hundreds of sites and it is straightforward to use onspaces command to create desired dbspaces. In an NT 4.0 (SP3) box with Informix 7.23 TC1, a 500 MB of dbspace can be created in as long as 20 *MINUTES*.…
oninit: Fatal error in shared memory creation
Can someone please point me in some direction on this? I am trying to set up Online Workgroup Server v7.2+ on a Sun Ultra2 running Solaris 2.6. We are attempting to use a cooked file (which seems to be generated fine for the root). I am configuring through onmonitor-->Parameters-…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
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.…
Re: ASF_INIT_DATA error in linux
mdevlin8648@my-dejanews.com wrote: > > I downloaded online dynamic server for linux and have installed it > but when i attempt to initialize it i get an error that reads > Initializing ASF ...oninit: Fatal error in initializing ASF with > 'ASF_INIT_DATA' flags; asfcode = '25507'.…
ASF_INIT_DATA error in linux
I downloaded online dynamic server for linux and have installed it but when i attempt to initialize it i get an error that reads Initializing ASF ...oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507'. what is this and where fo i look to dorrect …
Problem installing IDS 7.23TC6 on NT4 with SP4
Hi all, the DB initialization at the end of the install process seems to hang = ("Dynamic server is being initialized ..."); the "Dynamic = Server"-Service is started, the Message Service seems to be the problem. = Anybody any idea? Thanks for your help, Arno Arno A=DFmann Co…
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…
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…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
dbaccess error on NT
When I try to go into dbaccess, on NT, I get the following error:- "could not initialize the security subsystem" Any Idea?…
dbaccess error on NT
When I try to go into dbaccess, on NT, I get the following error:- "could not initialize the security subsystem" Any Idea?…
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: Can't drop dbspace?
On Mon, 16 Nov 1998, Kit Nevin wrote: > Due to a couple of circumstances, a dbspace we've created can't be > dropped...we're running online 7.22 on Solaris 2.6 using raw disks > partitions. The circumstances were a) root was still the partition owner > when the dbspace was creat…
Can't drop dbspace?
Due to a couple of circumstances, a dbspace we've created can't be dropped...we're running online 7.22 on Solaris 2.6 using raw disks partitions. The circumstances were a) root was still the partition owner when the dbspace was created (and was changed to informix prior to the at…
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…
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 …
Problem initializing
Hi, It's been a while since I've created an instance and were using a 3rd party app from HP called Praesidum that uses Informix underneath. The platform is HP-UX 10.2 with Informix 7.11.UC2 During the initial install of Praecidum the Informix online instance is initialized for …
Re: TEMP Tables
Shew Leong wrote: > > Hi, > > Is there a limit to the number of temp tables you can create? > > My stored proc creates 5 but Informix errors out with error -131 - basically > ran out of space. > > Stats - Solaris 2.6 - Informix 7.2.3 No no limit, however, temp tables not created…
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…
Informix on SCO
Where can I get some information on how to configure Informix Onlie Dynamic server on SCO. I'm stuck on the Root DBspace chunk. when tring to initialize the shared memory.…
Re: Lawson newsgroup
Does anyone know the answer to my original question which was "Where can I find out the correct procedure for initiating a new newsgroup?" I feel I ought to know, but I don't! Thanks Neil…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
Oninit Fatal Error
Hi All, Anyone seen this type of error before ? (Im running oninit -i) oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '- 25580'. Cheers Len…
Re: How to add space to a database??
Saleem Mohammad wrote: > > Hi > Can someone tell me how to add space to a database instance? You can either create a new dbspace or append more space (additional chunks to use the vernacular) to an existing dbspace. You can do this using the onspaces utility (onspaces without…
Re: Cooked Files
Go ahead and specify the offset. The additional chunk will overwrite neither files on the existing file system nor the tables in the existing cooked files so long as the chunk you are adding is for the same instance of Informix that you created the initial cooked file. Rene…
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…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Re: dbimport and size of rootdbs
Neil Truby wrote: > > Maybe I've misunderstood what you've done. but it seems to me that the most > likely explanation is that on System A the database resides in a dbspace > other than root and, when you've run the dbimport, you've failed to use > the -d option. Thus the utilit…
Installation of ID 9.1.4
Hi, I am trying to install IDS 9.1.4 on a Solaris 2.6 box. Using raw devices for the root dbspace. Installation went on fine but when it came to oninit -i I get the error message - root dbspace not owned by userId Informix and group Informix. As suggested somewhere in the Admi…
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: 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…
Re: RAW-Device - oninit
Edward, The permissions have to be granted on the physical (raw) device and not the symbolic links.The permissions on /dev/rdsk/c0t1d0s6 should be informix:informix and on /dbspaces/rootdbs should be root:sys and nothing else..!! Hope this helps, Regards, Girish Punjabi giris…
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: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
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: replacing mounted rootdbs as raw diskspace
Neil Truby wrote: > > Art S. Kagel wrote: > > > Yes, raw space is significantly faster. To do this: > > > > 1) bring the engine down: onmode -ky > > 2) copy the rootdbs file to the raw device: > > dd if=/datafs/rootdbs of=/dev/rdsk/sd2d bs=2k count={rootsize in pages} > > > > 3)…
Re: replacing mounted rootdbs as raw diskspace
Art S. Kagel wrote: > Yes, raw space is significantly faster. To do this: > > 1) bring the engine down: onmode -ky > 2) copy the rootdbs file to the raw device: > dd if=/datafs/rootdbs of=/dev/rdsk/sd2d bs=2k count={rootsize in pages} > > 3) delete or rename filesystem copy of …
Re: replacing mounted rootdbs as raw diskspace
sukumar konduru wrote: > > Hi > > Our "rootdbs" has been created as mounted file system rather than raw > disk space. Our database is in another dbspace which is created as raw > diskspace. > > Is it really improves performance if we use raw diskspace rather than > unix file s…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
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…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
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: +…
Re: Initial extent size < first extent
Thanks to all who answered my question on the initial extent size being < the first extent size specified. Sujata ***************************************** Sujata Soman E-Mail: ssoman@omm.com O'Melveny & Myers, Los Angeles ******************************************…
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…
Sizing dbspaces
Does anyone have any recommendation or guidelines we can use in determining a base sizing strategy for rootdbs and physicaldbs. I am most conerned about physicaldbs. I used the formula in the Admin guide to determine a size for physicaldbs but I am not sure if the result was in…
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…
corrupt dbspace
I am running Informix ODS 7.22 on AIX V 4.1. I accidentally removed a file from AIX that Informix ODS had listed as a chunk in a dbspace (that I was about to remove anyway). I don't back the system up since it is our test system. All I want to do is remove the dbspace and all…
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: DBSPACEUP Environment Variable
Jay Aymond wrote: > > If the environment variable "DBSPACEUP" is set to indicate the size of sort file > for distributions during an "update statistics" --- what dbspace does it use for > the sort file? If there is a temp dbspace, does it use that? By priority: PSORT_DBTEMP (l…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
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.…
Memory not Initialized
I am running netscape enterprise server 2.0 with livewire pro and cannot get my server side Javascript (Livewire) to connect to the databases. When I try to run onmode I get the following message... Message 19511 not found. When I then try to start up the server using ./start.…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Initial Extents
Is there an upper limit to initial extents? I'm running ODS 5.02 and I've got one table at 846,000 pages, and several at 300,000-400,000 pages, including indexes. Calculating the extent size at 4KB per page, my largest initial extent size is around 3,385,000 KB. Is this reasonabl…
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
Re: root dbspace chunk offline how recover ?
In article <34CE1679.5F6C@credo.ie>, Peter Groarke <peter.groarke@credo.ie> writes >Hi, >Informix 7.23 installed. I have the root dbspace (containing >the logical + physical logs) on one disk which is now >banjaxed. > The other dbspaces are on a separate, good disk. >I know the s…
root dbspace chunk offline how recover ?
Hi, Informix 7.23 installed. I have the root dbspace (containing the logical + physical logs) on one disk which is now banjaxed. The other dbspaces are on a separate, good disk. I know the steps for bringing back a non-root dbspace chunk when it goes offline, but how do I bring …
help.
Hi, is there anybody that could help me? I had to install Online dynamic Server on a Tandem machine (mips processor). Everithing seems goes right until we give the "oninit" commadn, when we receive a message that we did not initialize shared memory and there is'nt root dbspace. …
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…
Help needed: Raw Device on SGI
HELP HELP I have the problem, that I can not install raw devices as datachunks on a Silicon Graphics machine. Has everybody done this? How are the disks partitioned/initialized?? Regards Al G.…
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…
Prob with Initializing
Hi Info'mix guys , I am installing a new Online 7.23 engine on a HP-9000 Machine. I had created a cooked file by name s_chunk(using cat /dev/null >) An error came when after all initializing was done oninit : Cannot open path/s_chunk'. errno = 4 during shared m…
Variable Initialization
Hi Users... I am facing a peculiar problem in one of my esql/c program. The program has in the EXEC BEGIN & EXEC END SECTION around 100 fields. one of the stmt is double qty_a, global_seq=1, global_ctr; While compiling its gives me an error Error -33040: Object…
Re: root dbspace full. Question?. Informix 5.00 UC3
Gabriel Leglise wrote: > > The aplications (Dbaccess) running on Informix 5.00 > UC3. > > In one moment the root dbspace is completed very fast > and > the others programs can=B4t run. > > Ej.: tbstat -d|grep rootdbs > > Space …
root dbspace full. Question?. Informix 5.00 UC3
The aplications (Dbaccess) running on Informix 5.00 = UC3. In one moment the root dbspace is completed very fast = and the others programs can=B4t run. Ej.: tbstat -d|grep rootdbs Space Free dbspace …
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…
onstat -d,onstat -D
Can anyone tell me the difference between a dbspaces address with a flag of 1 and a dbspaces address with a flag of 1001...... Tony Reynolds, NEC Group, Birmingham , UK 8-)) tr-2959@necgroup.co.uk tonyreynolds2@compuserve.com…
Replication on INFORMIX ?
Hi Guys, I'm new in this nw and need u'r help ... we're trying Informix Dymanic Server 7.22 on SCO and soon also for our SUN Solaris ... it's running well but I have difficulties with the REPLICATION Features ... this's actually the reason we migrated to SQL my quez are : (as s…
Re: stale dbspace info
David Williams wrote: > > 1. dbexport all databases > 2. shudown online > 3. Edit onconfig file and remove any references to dbspaces > other then you root dbspace. (check PHYSDBS,LOGDBS,DBSPACETEMP) > > 4. Note the dbspaces and chunks you wish to keep. > (pathn…
Re: stale dbspace info
In article <64v5ht$ffl@cssun.mathcs.emory.edu>, chris@dvs1.informatik.th-darmstadt.de writes > >Hi ! > >Recently we had a power loss which caused a hard disk damage in turn. >The disk contained several primary chunks as cooked file space for >dbspaces. > >Although the dbspaces ar…
Re: DBTEMP variable and sorted rows
> There are about 150 MB of free disk space. We're only sorting about > 10,000 rows. > Could it be some file system limitation? Are the files really created in $DBTEMP or is a (root-)dbspace used instead ? (you could check the free space in sbspaces using an "onstat -d" frequent…
invalid dbspace
I have been receiving this message for awhile..it hasn't seemed to affect normal functionality...but, I still would love to know what this message means: Warning: Invalid dbspace 'tmpdbs1' listed in DBSPACETEMP. lrwxr-xr-x 1 informix informix 19 Oct 16 1996 tmpdbs -> /d…
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: Help - 567: Cannot write sorted rows. 28: No space left o
> On 26 Aug 97 at 13:54, Bill Bertovich wrote: > > > Error: > > 567: Cannot write sorted rows. > > 28: No space left on device > > Uhhh, sounds like you're running out of disk space... How is your > temp space set up? Can you monitor it at the time you're running the > que…
Reading a file with 4GL
Does anyone know how to read data from a text file into a 4GL program? I want to read data from a configuration file and initialize some program variables. Thanks in advance, Mike…
Re: How do I initialize the root dbspace?
Bill Bertovich wrote: > However, I ran into a problem (running out of space again) while loading up > a customer's database. So, I thought that now would be a good time to > clean up some of the crap. So here is what I did. > > 1) I exported the databases (2) we needed to save a…
Re: How do I initialize the root dbspace?
In article <5ras3u$2io@cssun.mathcs.emory.edu>, Bill Ennis <ennis@ssax.com> writes >Hi, > >You've a several things mesing you up. Hopefully, I will identify >them all. > >For starters, the rootdb space will be used as the home of your >logical and physical logs when you reinitial…
Re: How do I initialize the root dbspace?
Hi, You've a several things mesing you up. Hopefully, I will identify them all. For starters, the rootdb space will be used as the home of your logical and physical logs when you reinitialize. This means that you need enough space for all logical and physical logs plus space fo…
How do I initialize the root dbspace?
Hi, Informix 7x, Solaris 2x. Being new to Informix, we made a lot of typical novice mistakes when we first installed it, 2K logical log sizes, underestimated db sizes resulting in dbspaces with many chunks, etc. Since we are a development company and we only use the databases …
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: rootdbs can be moved to larger chunk?
In article <33B7A4DE.7E56@informix.com>, Chris Jenkins <chrisj@informix.com> writes >Hi Cosmo/Bill, > >Two options: > >1. Add more chunks to the original rootdbs dbspace. You will > *never* be able to free the primary chunk. It has critical > information in it. > >2. …
Re: rootdbs can be moved to larger chunk?
Hi Cosmo/Bill, Cosmo Lee wrote: > Bill Glidden wrote: > > In article <33B403D4.68D6@echonyc.com> you wrote: > > : Can a rootdbs be moved to a larger chunk? We have a rootdbs in a 20MB > > : chunk. We'd like to just move it to one of the larger chunks. Is there > > : a way to …
Re: not initialized
On 23 Jun 1997, Thuc Nguyen wrote: > I installed Online 7.22 on HP-UX 10.20 today. Alright, with you so far... > I started up engine and received error message. > > "share memory not initialized for INFORMIXSERVER "whse". Hrm. Sounds like the engine didn't start. > I looked…
Re: not initialized
Look in the message log file Thuc Nguyen wrote: } I installed Online 7.22 on HP-UX 10.20 today. } } I started up engine and received error message. } } "share memory not initialized for INFORMIXSERVER "whse". } } I looked at everything (sqlhosts, /etc/services, onconfig.coris) …
not initialized
Make sure that your onconfig environment variable points to onconfig.coris and that INFORMIXSERVER is set to the same value as DBSERVERNAME in onconfig.coris. Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Monday, 23 June 1997…
Re: not initialized
Make sure your box is in /etc/hosts…
not initialized
I installed Online 7.22 on HP-UX 10.20 today. I started up engine and received error message. "share memory not initialized for INFORMIXSERVER "whse". I looked at everything (sqlhosts, /etc/services, onconfig.coris) Is there something I am missing? Thanks in advance for your…
REQ : how do I add space to a 5.0 database?
Hi We are using a network monitoring system (Strataview), which uses an Informix database as repository (Apparently it is a 5.0, on a Sun machine). We have some space problems with the database, and we don't want to be purging tables monthly, so the other solution is to add mor…
Re: help: oninit -i -> error
In article <33970E81.2335@dvs1.informatik.th-darmstadt.de>, Christoph Liebig <chris@dvs1.informatik.th-darmstadt.de> writes >Hi ! > >Recently our disk holding the informix raw partition failed :( > >We are using online dynamic server 7.1 on solaris 2.5. > >Currently I am trying t…
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Re: ERwin vs Designer/2000
well said. I believe the initial question was...? -- Robt ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~.... Robert Miller Oracle DBA robt.miller@airmail.net (214) 532.6558 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^~~~~.... Any opinions expressed are my own and do not …
SETUP: Unable to initialize database server.
I installed Ows712nt on a NT 4.0 machine and I am getting the following error message during the installation process: Unable to initialize the database server. Please help. Thanks…
Re: Informix startup (oninit) problem
Verify that informix informix 660 is the ownership/permissions on /informix/devices and make sure it is a valid partition, then try an offset of 2 for ROOTOFFSET. Rob Donat. ptsui@aptnet.com wrote: > > I get the following errors when trying to do an "oninit -i" to > bring up th…
Re: Informix startup (oninit) problem
ptsui@aptnet.com wrote: > > I get the following errors when trying to do an "oninit -i" to > bring up the informix instance for the first time. > ---------------------------------------------------------------------- > oninit: Cannot open chunk ''. errno = 2 > oninit: Fatal error…
Re: root dbspace
In article <5da2pk$brh@cssun.mathcs.emory.edu>, tr-2959@necadmin.necvenues.co.uk ("Tony_Reynolds(Accounting & Purchasing)") wrote: > > I have a test machine running Online 7.1. > On performing a VERY large query I received an error message > saying that there was no free disk sp…
Re: root dbspace
Tony_Reynolds(Accounting & Purchasing) wrote: > > I have a test machine running Online 7.1. > On performing a VERY large query I received an error message > saying that there was no free disk space to write sorted rows into > a temporary table. On examining the space available i…
root dbspace
I have a test machine running Online 7.1. On performing a VERY large query I received an error message saying that there was no free disk space to write sorted rows into a temporary table. On examining the space available in the rootdbs 32252 pages remained out of 575000. I sh…
Informix equivalent to Oracle dbms_pipe?
Is there a (free?) Informix equivalent to the Oracle dbms_pipe package? The dbms_pipe package allows a pipe-like connection from a stored procedure to a Unix process. It's nice for being able to initiate downstream processes based on trigger firings and such. Thanks, Mark…
Dropping a dbspace.
We are trying to drop a bad chunk. The chunk is a cooked file and is the only chunk in that dbspace. When I try to drop the chunk I get the following message. % onspaces -d ch_dbspace1 WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The…
Re: Online: init problem: chunk timestamp invalid
Thanks, that was exactly the problem! I was trying to initialize via onmonitor, not `oninit -i`. Since I had only initialized a database from scratch once before, I had no recollection of using `oninit -i`.…
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
Re: Restoring backup tape failure
jdevlin wrote: > > When I try to restore a full backup from tape I get the following > error: > > Restoring system control information, please wait ... > Rootpath = /dev/db/rootdbs,Offset = 0 K, Size = 102400 K. Mismatch in configuration file. > > My TBCONFIG environmental variab…
Restoring backup tape failure
When I try to restore a full backup from tape I get the following error: Restoring system control information, please wait ... Rootpath = /dev/db/rootdbs,Offset = 0 K, Size = 102400 K. Mismatch in configuration file. My TBCONFIG environmental variable is set to tbconfig and $IN…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
Extents overlap
Hello, Just after database initialization of I-OnLine v7.0 on RS6000 'oncheck -ce' reports: Extents overlap There are no more databases, only 'Sysmaster'. Please comment. Sigitas Tumas S.TUMAS@kaunas.omnitel.net Sekasoft, Kaunas, Lithuania…
Re: oninit -i refuses to work
@augsburg.net wrote: > > We had an existing database and wanted to drop it. > We shut down the working database and took it offline. > > We just tried oninit -i and got the response > > oninit: Not enough room for ROOT dbspace. > Fatal error initializing shared memory. > > Why? A…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
problems initializing
Has anyone using Informix ONLINE Engine 7.10 UD1 running under SCO 3.2.5.0 (ie SCO V) had the following when trying to initialize(oninit -iy). We basically can't get anyof our systems up and are stumped!! Informix has not been of much help so I thought I would put it out on …
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
Re: Online 5.05 - bringing on mirrored dbspaces at a later date?
We didn't initialize our dbspaces as potentially mirrored, what can we do to get around this?…
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: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
Freeing up temp dbspace
I have on-line 7.11UC1 on Solaris 2.4 and I would like to know how I can free up temp dbspaces without bouncing the engine. It seems like one of my developers has a bad select statement and it fills up my temp dbspaces and crashes, but on-line does not clean after the crashed pr…
Backing up using ADSM ?
Is Informix enabled for backing up using ADSM ? Is anyone doing this ? Does the backup have to be initiated from the database manager or can done through ADSM's scheduling facilities ? TIA Phil Nelson DBA Scottish Widows Fund…
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: Online 5.1, How to remove a chunk
Hi, You have to drop the dbspace in order to free up the chunk and the dbspace has to be empty when you drop it. Thanks Ryan…
Re: Online 5.1, How to remove a chunk
You can't remove a chunk in version 5.x. This is possible in version 7.x. If the chunk is in a non-rootdbs dbspace, you could remove all data from the dbspace, then drop the dbspace to reclaim chunks.…
good C++ library for accessing Informix?
Is there a good C++ library for accessing Informix Online databases? This will be used for a large application, initially on a Sequent. Thanks for any help. I will summarize back to the net if I get useful responses. Dean Thompson MAYA Design Group thompson@maya.com…
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: Restructuring root dbspace.
shawn.raymond@CCGATEWAY.AMC.EDU ("shawn raymond") wrote: Please correct me if I'm wrong... Shawn I believe the only way out of this one is to re-initialise the rootdbs. Unless Informix have a tool I don't know about, you can't drop chunks. > Hi, > > We have 4 chunks in …
Restructuring root dbspace.
Hi, We have 4 chunks in our root dbspace and I would like to remove the last 2 and recreate the first 2 on seperate disks. How do you keep the reserved pages, the system catalogs and any other important information intact? Thanks for any feedback! …
Re: Initializing record variables
}From: Gabriel Beccar-varela <gabriel@ccnet.com> }Date: 26 Feb 1995 13:25:21 GMT }X-Informix-List-Id: <news.11821> } }jcarr@coredump.vr.net ("Jim Carr") wrote: } }> Does anyone know of a quick way to initialize every element of this }> record to "N"? } } Try initialize blah.* to …
Re: Initializing record variables
jcarr@coredump.vr.net ("Jim Carr") wrote: > > > Does anyone know of a quick way to initialize every element of this > record to "N"? > Try initialize blah.* to 'N'. I know it works when you initialize to NULL. I am not sure to any other value.…
Find names of all databases in a DBSPACE
Is there a way to get a list of all of the databases in a dbspace? My dbspace is very dynamic and I need a way to get this list. Using Informix Online 5.x on Sun Sparc SunOS 4.1.3c David Clough…
Re: dbexport/dbimport problems
On Wed, 25 Jan 1995, jerry wrote: > If I am not mistaken, the default location for a table is the same > dbspace as the database was created it, this is not always the > root dbspace. True. To clarify, If you create a database without explicity specifying a dbspace, it ends up…
dbspace Q
i am looking for any pgms that might help monitor "space hogs". it would be nice to be able to get a listing of databases found under a specific DBSPACE along with its owner and size. i thought i saw a news thread along this topic a few months ago. thanks, jim ________…
4gl menu statement ver 4.10
Upon initial entering of menu statement I want to determine which command will be highlighted instead of the default of the first command being highlighted. So far I haven't been able to get this accomplished. Is it possible? Thanks ~…
Re: Mirroring
Ti Lian Hwang writes: |We have a new HP9000 machine with 2 fast SCSI disks and 2 slower |disks. | |We are using informix mirroring on them. | |Is there advantages or disadvantages if the mirror copies are both |in the in the slow disks, or a mix of slow and fast disks ? | |I mea…
Mirroring
We have a new HP9000 machine with 2 fast SCSI disks and 2 slower disks. We are using informix mirroring on them. Is there advantages or disadvantages if the mirror copies are both in the in the slow disks, or a mix of slow and fast disks ? I mean Disk A (slow) Disk B …
Re: 4GL Static variable initialization for SCCS 'what' command
In article <38470r$j24@news.acns.nwu.edu> ** none ** writes: > When we develop C or ESQL/C programs, we can include a static > variable initialized to the appropriate SCCS codes for storing > revision information in our executables (accessible with the > UNIX 'what' command).…
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
Need help, lost connection to dbspace |
Hi, I have an access problem with Informix Online V 5.01. I destroy my old root-dbspace, if I call tbinit. (Yes, I know that was a stupied operation) All database have their own dbspaces. My Question is, can I change internally the root-dbspace that I can recover my old database…
problems with Online V4.11, ISQL V10 and Novell Netware V3.12
We installed INFORMIX Online V4.11 on Novell Netware V3.12. Unfortunately, we can�t use INFORMIX ISQL V4.10 frontend : ISQL hangs while displaying initial screen. Could anyone help us? Thanks in advance. Stefan…
dbspace lost
Platform: Everex 486 running Interactive 3.2 and Informix Online 4.00.UE1. Recently, we took a power hit that caused some damage to our file system. Specifically, the device file Informix writes to was lost. Should I reinstall Online or can I just re-create the device file? Al…
Re: tbcheck problems HP9000 G30
[ Bill Glidden writes: ] > Joe, > > It is because the physical log is not located in the root dbspace. It is a known > problem, and can be duplicated by creating an OnLine instance and moving the physical Can I have more specifics here. We are currently running many engines non…
Prevent users from creating databases?
Is there any way to prevent users from creating databases? Or at least to prevent them from creating databases in the system dbspace? Or even a way to change the default place for databases from system dbspace to another dbspace? Thanks in advance. -- Rick Hamel Database Admi…
tables in dbspace (Online 5.x)
Is there a simple way to find which tables are in a dbspace? (Or, what dbspace a table is in?) -Brian ------ brena@hcia.com…
Re: >RE:"Could not write to a temporary file" error
Every time that I've seen the Could not write to temp file error, it's been the root dbspace. Do 'tbstat -d' while you're running the pgm and see if any chunks get near 0 free ??? Bill *8o\\…
DBspace Question
I'm looking for a way in a sql statement to have on-line return me based on a given table name the dbspace name that the table is located in. The following sql statment returns the dbspace number the table is located in but what I need is the actual dbspace name. select h…
dbspace for database
Yes I know I have antique software, and yes I am sure you've answered this before...but I need to know now, and cannot find it in Walt's excellent archives... On a UNisys 5000 platform, running Turbo with 2.10.03G SQL... 2 databases were created. tbmonitor shows rootdbs, and 2 o…
ESQL/C, sqlda, and datetime columns
Is there some other initialization I need to be doing before the fetch? Thanks in advance for any help. Henry P. henry@is.internic.net InterNIC Information Services…
Default dbspace?
This has probably already been discussed to death, so please reply by e-mail. Is there a way with OnLine v4.0 or v4.1 to make the default dbspace something other than the root dbspace? Thanks. -- +--------------------+-------------------------------------------------------+ |…
Cooked dbspace...
A client of of ours was playing with OnLine, and created a chunk on the cooked file system. When he was done, he decided "Okay, I'm through." and did an "rm mychunk" from. Note that he didn't bother to drop the dbspace inside of OnLine. So now he has a dbspace that OnLine thinks …
Dropping a dbspace
Hello, I am currently using the Informix Turbo engine. I tried to drop a dbspace the other day and couldn't do. Does anybody have info on how to do this? Thanks ! Brian MacWilliams USAMC - SIMA LEAD CHAMBERSBURG PA…