Oninit® Archive
Results for “DATASKIP”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
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…
New installation on SUSE Linux
Here is my sqlhosts file: ksotinfx01 onsoctcp ksotinfx01 istartrain2 ksotinfx01_shm onipcshm ksotinfx01 ksotinfx01 istartrain onsoctcp ksotinfx01 istartrain I'm confused by the istartrain2 in the first line, but I am copying another config file over from our production server, …
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 ------------------------------…
Want to DROP an empty rootdbs chunk
Server Studio (see screen shot pasted below) shows a fair amount of fragmentation (disk fragmentation, not Informix fragmentation) in the rootdbs (i.e. chunks 1 & 8). Since table extents are contiguous, to avoid having to create dozens or hundreds of small tables, should I repac…
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
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…
RE: The rowid column does not exist in the user table.
onstat -g cfg full AUTOLOCATE You might inadvertently have got a (signle-fragment round-robin) fragmented table -> check 'oncheck -pt' or query systables/sysfragments for table in question. BR, Andreas ------------------------------ Andreas Legner ------------------------------…
The rowid column does not exist in the user table.
Yes Paul. The table is fragmented by AUTOLOCATE feature. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------…
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…
Fragments and Extents
Hi, I am facing some problems with some tables that are growing fast and getting fragmented. I have looked for some kind of procedure to identify and correct this. Can someone give me some help to solve this problem? Thanks in advance, SP…
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…
Recovery mode stucked
Hi All Informix experts. I am just starting to work with Informix. Our Informix was undergoing a reboot and I am trying to bring it up. I am running into the errors below, where the server is stuck in Recovery mode. Can someone please let me know what I would need to do to ove…
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…
Connection Refused
Hi Jack, thanks for your response. The onstat -m says: "Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 03:17:51 -- 478208 Kbytes Message Log File: c:\\\\INFORM~1\\\\ol_gechenique.log Wed Mar 21 08:21:34 2018 08:21:34 DR: DRAUTO is 0 (Off) 08:21:34 Informix Dynamic S…
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.…
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 am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
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?…
Alter fragment online
I checked the documentation on alter fragment for version 11.7 and find that can be used to move the storage from a dbspace to another in this way: ALTER FRAGMENT ON TABLE <tablename> INIT IN <new_dbspace> http://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.sql…
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…
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…
Fast recovery slow
Thanks Mark, I send the relevant part of the engine log. You can see that the logical recovery is slow. 19:48:13 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 19:48:13 Started 1 B-tree scanners. 19:48:13 B-tree scanner threshold set at 5000. 19:48:13 B-…
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.…
stopping ifxclone
Hi, We are running Informix 11.70.FC7. We started ifxclone to re-setup an RSS server, though we had to stop the RSS server in the middle of the clone. We used onmode -ky to stop the RSS server. However when we try to restart ifxclone again, we get the following error message on …
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
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,…
Attach fragment from a table in another database
Hi Folks (capitalized! :-) My client just asked me the wildest question: > if there is a fragment associated with one database like dbase_1@my_server, > can that fragment be detached and moved to another table on another database > like dbase_2@myserver? Actually, he asked if…
query to find partition size in fragmented table
How can we find the size of a partitioned table in term of extents or pages allocated. For non-fragmented tables we can get the results as provided in following link: http://www.informix.com.ua/articles/sysmast/sysmast.htm But these queries do not work for fragmented tables.…
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…
Informix V12 Fragmentation
In previous versions of Informix IDS - I believe that if you included a 'remainder' clause in a table fragmentation statement, that queries over that table would not have any fragment elimination (assuming that a where clause has filters that matched fragmentation scheme). Is tha…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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…
fragment estimate_compression Partition is not in
Hi, We hae Linux Redhat 6.5 X86_64 and IBM Informix Dynamic Server Version 12.10.FC3E I get lots of this kind of error messages, where could i start finding reason for them? 15:36:05 fragment estimate_compression Partition is not in a consistent state for partnumber 5243371 15:…
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…
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?…
fragment NONE
Hi, I fragmented a talbe using month function . dbschema -d cbsbg -t aapf30 -ss DBSCHEMA Schema Utility INFORMIX-SQL Version 11.50.FC7 { TABLE "cbsbg".aapf30 row size = 220 number of columns = 21 index size = 38 } create table "cbsbg".aapf30 ( aa30dpnoa char(11), aa30dpnok ch…
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.…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Resident memory size vs. Virtual memory size
Hi, Check for this bug , APAR= IC77372 : ABNORMAL ALLOCATION OF VIRTUAL MEMORY SEGMENTS WHEN CREATE INDEX ON FRAGMENTED TABLES. rgds schillache…
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,…
ifxclone
I finally got my grid and CDR setup to work (with a little help from you guys) and then decided I'd try making it easier by using ifxclone...now I can't get that to work :/...I've created the files for the spaces that the source has on the target. I've created the sqlhosts and on…
Fragmented tables
Hi, Is there a way (a sql script maybe) that would create a list of all tables in a database that are fragmented and what fragmentation expression was used without going through dbaccess,table,info,fragment menu? I can do this using dbschema on a specific table but only for tho…
Table Partitioning
Is it possible to partition/fragment a table while keeping it in a single tablespace.…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
WHere did my data go?!
IBM Informix Dynamic Server Version 11.50.FC8W2XB on Solaris: I fragmented a table into multiple dbspaces to see how long it would take. No problems with all this, all 64 million rows fragmented, about 16m into each database: set pdqpriority 95 ; alter fragment on table <tablen…
Does my oncheck -cI db:table hungs?
follow up question... => oncheck -cI db:tab_history Validating indexes for db:informix.tab_history... Index tab_hist_x1 Index tab_hist_x2 Index fragment in DBspace dbidx09 Index tab_hist_x3 Index fragment in DBspace dbidx09 How can i check if this still running? it's been…
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 …
Best way to move table contents to another
btw, there is no interval fragmentation in 11.1. so if i were to specify fragments per date, i'd have to specify all dates.. in informix 11, does it allow fragmentation within the same tablespace? thanks…
Segregation of indexes in separate dbspaces still valid?
As a budding Informix DBA in the last century, I was told that placing indexes in a dbspace dedicated only to indexes and apart from the table's data enhanced performance. Is this still true? Even with the advent of SAN technology? and using Informix fragmentation (data partiti…
question about fragment
Hi, I have one table need to be fragmented, totally it's 8 partitions,I have two choises,the first one is all those partition on the same dbspace, the second one is use 8 different dbspace to do the fragment. What's the performance difference between them? thanks for your time.…
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 …
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…
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…
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...
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'...succeeded Checking config parameters...succeeded…
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…
Advantages of Fragmenting Across DBSpaces
Is there any advantage to spreading table fragments across distinct dbspaces if bulk storage is managed via SAN?…
To Fragment or Not to Fragment?
Hi Guys/Gals, IDS 11.50.FC5 O/S AIX 5.3 I am working on one of my inherited instances and I am wondering when fragmentation becomes advantageous. More specifically, I have a table with approx. 300,000 rows. Would fragmentation (by expression) help me on this or is it just too s…
Fragmented index question
IDS 11.70.fc2 Aix 6.1 I have a question for the experts...When fragmenting a non unique index, you can fragment the index by a column that isn't part of the index .. So, when it's an unique index, why does the column being fragmented by .. have to be part of the index? Peter P…
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 …
can't attach fragment if surviving tab has primary
is it true that I can't attach fragment if surviving table has primary key? it it seems like I must do drop, attach fragment & recreate a primary key. Is there a way to bypass that? it is time consuming and cumbersome…
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.…
Fragmented spaces
Hi to all is there another way than dbexport/dbimport to defragment the spaces used by a database (the fragments are not contiguous). thanks in advance…
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 …
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.…
FInd Row Id in Partition Table
Hi, How can we identify RowId for a Partition/Fragmented Table in IDS 11.50.FC6. Thanks.…
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…
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 I Move a Fragment?
Good Morning people, Is it possible to detach a fragment from a fragmented table and reattach it to another dbspace? IDS 11.50.FC5 on AIX 5.3. thanx, dan…
fragment performance
Aix 6.1, ids 11.50.fc7 Just looking for opinions on the following, when fragmenting a table ... what is the performance difference between fragmenting the table into separate raw devices .. or a single raw device with named partitions...assuming that the devices are all part of …
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…
Shared memory problem
IDS 9.40 UC4 on Linux (yes, I know ...) 1. Initialising the instance with a shared memory connection it just hangs at: 01:09:26 Maximum server connections 0 01:09:26 Dataskip is now OFF for all dbspaces 01:09:26 On-Line Mode 01:09:26 Building 'sysmaster' database ... Never…
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…
fragmented indexes?
v11.50.fc5 Aix 6.1 A general question... We have a table that will be fragmented by a fiscal week id, ie. 201101 ... We are also going to fragment the index. If the index is also fragmented by fiscal week, is it best to have that as part of the index column list. Obviously it do…
Table Fragmentation
Hi! I have an historic table (5 months) with about 30 millions record per month. Our primary problem is that deleting old data takes too long (we have some indexes in that table). So I start making some tests with fragmentation. I fragment my table with a date expression (monthly…
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…
Move table from rootdbs to a different dbspace
Thank you very much Art. I will check this command.. ALTER FRAGMENT ON TABLE tablename INIT IN dbspace1;…
shared memory not initialized for INFORMIXSERVER
IDS 7.31 UNIX SCO 5.0.5 20:34:14 Requested shared memory segment size rounded from 8000KB to 8192KB Wed Oct 28 20:34:15 2009 20:34:15 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 20:34:20 DR: DRAUTO is 0 (Off) 20:34:20 Requested shared memory segment size …
Fragmentation of Table
Hi All, We have huge table that will save old data into that table. How should i fragment that table so that it will have any bottleneck on the DB?…
Extents Monitoring
Hi, Can we increase the number of pages for a single fragment ? Or is it the only way to survive this type of scenario by having our table in multiple fragments ! Regards Kasi…
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…
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."…
oninit -r
We tried "oninit -m"... IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up 00:03:33 -- 488472 Kbytes Blocked:CKPT Some information: - before this problem, the system was in a cdr replication state and we would disable this executing an "oninit -D", wh…
dbspace utilisation in Informix 5x
Hi Bob, Thanks for your advice. But in case the table is fragmented among multiple dbspaces in v7 or v5 (dont know whether fragmentation is supported in v5), how can we identify that? Prabal…
TABLE AN INDEX REORG
Fragmenting a table by month using 12 fragments to hold 24 months of data is not the most efficient method. I have a much larger table with many more fragments. When it comes time to purge data, I delete all rows from the fragment and then drop the fragment. The released fragment…
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…
Re: help with sessid
emaus wrote: > Hi all: > > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority > DS_MAX_QUERIES 20 # Maximum number of decision support queries > DS_TOTAL_MEMORY 4000000 # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum…
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…
Index fragmentation
IDS 10.0FC9 on Solaris 10 I have a site where an index has hot the 16g limit for a tablespace. It seems from the fine manual that you cannot fragment an index across dbspaces round-robin (I suppose this is meaningless), only by expression. But I don't really want to do this; I j…
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.…
fragmentation question
Running IDS10.0.uc5 on aix5.3. We have a table that has some bad queries written against it that are having poor performance now. It is also a pretty wide table, lots of varchars. We aren't going to re-write the queries at this minute, but instead I am going to fragment the table…
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 ?…
Re: retrieving data from the table in chunks for paging
If the table is not fragmented then use the hidded "rowid" column. select * from invoice where rowid between 0 and 100; If the table has fragments you might be lucky in that it was created "with rowids". L.S.…
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…
ontape -r idle
Hi, When i run ontape -r to restore database, it didn't return any abnormallies, but it remain hangs/idle. Server remain at Fast recovery mode and i am able to run onstat command. Please help. I have paste the output and error log information below. Kindly review. Thanks # ontap…
Fragmentation
( Okay all, I have officially given up on trying to respond from work. Here is what I tried to write. ) You are fragmenting the index with this statement, but you said it is the primary key of your table. Can't you just fragment the table this way? The index will get created imp…
Fragmentation question
(Sorry all, big brother encrypted my last response again=2E Retrying)=0D= =0A=0D=0A=0D=0A=0D=0AYou are fragmenting the index with this statement, but= you said it is=0D=0Athe primary key of your table=2E Can't you just fragm= ent the table this=0D=0Away? The index will get create…
Problema con logs
buenas tardes necesito saber si se puede salvar esta base de datos. tengo el siguiente problema: # oninit -vp # onstat -m 13:20:52 Onconfig parameter VP_MEMORY_CACHE_KB modified from 21822020 to 5455505. 13:20:52 Dataskip is now OFF for all dbspaces 13:20:52 Logical Log Files ar…
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…
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…
Where records the fragment table's partnum ?!
True dat Art - In addition if you look at the output from oncheck -pt the part that says... Partition partnum 11534338 Partition lockid 10485815 ...Will tell you if the table is fragged or not. The Partition partnum entry corresponds to the first fragment's partnumber, the Par…
insert performance on fragmented table
I'm running IDS 10.0.FC6. I fragmented the glpca table in my SAP database into 2 fragments by round robin. The fragments started to reach the 32 GB limit. So I added another dbspace. Now the first two fragments have reached the 32 GB limit and are no longer being written to. The …
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Expansion of round-robin fragmentation
Hi all, we have to change the fragmentation strategy of a fragmented table. The present strategy is round-robin with 5 fragments. Because the limit of 16777216 pages per fragment of the table in question will be reached soon we consider to change the round-robin strategy to e.g.…
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.…
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…
Tech Tip du Jour: For the peanut gallery
http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-strategies. html Happy now? -- Bye now, Obnoxio http://obotheclown.blogspot.com/…
Tech Tip du Jour: For the peanut gallery
http://obotheclown.blogspot.com/2008/07/tech-tip-du-jour-fragmenting-strategies.html Happy now? -- Bye now, Obnoxio http://obotheclown.blogspot.com/…
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.…
best way to move user tables out of rootdbs
Mark. The Alter Fragment statement looks promising. I'll check it out. Thanks…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
Re: Moving a table
I think this is what your looking for... alter fragment on table <mytable> init in <newdbspace>…
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…
add fragment
HI, Folks, IDS11.10 UC1, AIX5.3 We tried adding a fragment to a table and got the following( attached info ), any comments are appreciated. I got a similar result form IDS10 UC5 also long time ago. Thanks, Frank =====SQL====== alter fragment on table ds_head add partition pt…
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…
Re: Physical restore
mohitanchlia@gmail.com wrote: > Version: IDS 10 > > What does this mean ? > > 20:19:45 DR: Reservation of the last logical log for log backup > turned on > 20:19:45 Data replication type and state information reset. To start > DR, use > the 'onmode -d' command and wai…
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 …
Index Fragmentation
I've come across a table which has index fragementation as follows: create table "blah".tabwhatever ( pk_id serial not null , ...... fragment by expression (mod(pk_id , 10 ) = 0 ) in data_dbs01 , (mod(pk_id , 10 ) = 1 ) in data_dbs02 , (mod(pk_id , 10 ) = 2…
Fragmenting Indexes
Version: IDS 10 I am currently looking at various fragmentation strategies for Indexes that have keys of type CHAR. I have following questions: 1. Columns that have value of "000987" but is a CHAR, which strategy makes more sense, doing the fragmentation by using SUBSTR or usin…
MI5 Persecution: Usual targets of such abuse 10/10/96 (5526)
Can't we do something about this wanker? Shame a simple DROP statement (or even a FRAGment!) won't work......…
IDS 9.4
Dear Mr. Clifton, I have checked the table with oncheck -cIx and the following is the response, which is repeated many times. Validating indexes for baj:swx.log_record... Index dev_pri_tran Index fragment in DBspace bajdbs Index duptran Index fragment in DBspace bajdbs Ind…
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…
add fragment
IDS10 UC5 AIX 5.3 Tried adding a new fragment, threw a error, any idea? Thanks, Frank Error: alter fragment on table ds_head add partition pt5 (datatype_name [1,2] = 'MS') in dbdata04 ; # ^ # 776: Alter fragment error: unable to move row(s) to new fragmentation scheme. # # 11…
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: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: Informix Marketing Brainstorming Forum
TBP wrote: > Although a Single CPU VP does limit many (all?) of the PDQ / > fragmentation side of things. I'm not sure that it does. You can still get fragment elimination and you can still run queries with multiple threads. Regards, Ben.…
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…
Re: Informix Installation Crashed
Can you give us the contents of files: /etc/hosts /etc/hosts.equiv /etc/resolv.conf /etc/conf/cf.d/stune $ONCONFIG $SQLHOSTS Also, which exactly versions and patches of SCO OpenServer and IDS do you use? For example, you could use SCO OpenServer 5.0.6 + some patches (I cannot re…
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
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…
Onspaces Segmentation fault
Hi all, I have just finished reinstalling my IDS 10 for linux, on suse 9 for workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus its mirror was created fine. But when i type onspaces (with or without the parameters), puff!!! the thing throws "Segmentat…
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 …
RE: need help - infformix is down - restart got index failed
OK Neil, I ran an experiment....... hsap10% oninit -v ........ Initializing 127 flushers...succeeded Initializing log/checkpoint information...succeeded Opening primary chunks...succeeded Opening mirror chunks...succeeded Initializing dbspaces...succeeded Validat…
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Fragment by expression and extent size
Hi, When I try to fragment a table, how to specify the extent size and next extent size. Thanks Sven…
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…
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: 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…
fragmentation
I have a table, ds_archive, I just run alter fragment on table ds_archive add partition pt7 (archive_dt >= datetime(2008-01-01 00:00:00) year to second) AND (archive_dt < datetime(2009-01-01 00:00:00) year to second ) in dbdw1 before rmd; and added the fragment pt7(see below)…
fragmentation
I have a table, ds_archive, I just run alter fragment on table ds_archive add partition pt7 (archive_dt >= datetime(2008-01-01 00:00:00) year to second) AND (archive_dt < datetime(2009-01-01 00:00:00) year to second ) in dbdw1 before rmd; and added the fragment pt7(see below). …
fragmentation and partition
I have fragmented table ds_archive. Originally, the "remainder" was stored at dbdata02 dbspace( not defined as "partition"). After I altered the fragment( used "partition" and moved the "remainder" from dbdata00 to dbdw01), somehow a piece of data is still left at dbdata02. …
RE: Fragmentation questions involving Primary Keys and unique indexes
There are restrictions on creating indexes on fragmented table: it is only possible to create a unique fragmented index if it contains the fragmentation column (columns). There are three possible approaches to creating Primary key on a fragmented table: 1. create Primary key wit…
Re: Fragmentation questions involving Primary Keys and unique indexes
Zev Berezin wrote: > Hi All, > > > > Tech Specs: O/S Solaris 9 � IDS 7.31.FD7 > > > > I was playing around with fragmentation recently when I came across a > couple of interesting questions. > > > > Question 1) > > I came across a seemingly inconsistency when fragmenting a t…
Re: Fragmentation questions involving Primary Keys and unique indexes
Zev Berezin wrote: > Hi All, > > > > Tech Specs: O/S Solaris 9 – IDS 7.31.FD7 > > > > I was playing around with fragmentation recently when I came across a > couple of interesting questions. > > > > Question 1) > > I came across a seemingly inconsistency when fragmenting a tab…
Fragmentation questions involving Primary Keys and unique indexes
Hi All, Tech Specs: O/S Solaris 9 - IDS 7.31.FD7 I was playing around with fragmentation recently when I came across a couple of interesting questions. Question 1) I came across a seemingly inconsistency when fragmenting a table that contained a Primary Key using a fragment…
fragmentation error
I have the script and problems. case 1 ) If I have a remainder partition, it has synatx error, create table "informix".ds_arch ( dataset_name varchar(255,44) not null , archive_site char(10) not null , path_name varchar(250,50), archive_dt datetime year to second ) fragment…
alter fragment question
actv20@gmail.com wrote: > Hi all > > I have a table that is currently fragmented across two dbspaces and has > reached the page limit for a single dbspace (16,000,000 pages). I need > to add additional dbspaces to the fragmentation scheme and I was > intending to fragment across …
compaer LOAD and ALTER... ATTACH
HI, I am using IDS9.4 and attaching a fragment to a fragmented table. The table has two indexes are fragmented by default. I found, (1) ALTER FRAGMENT ON table ATTACH... is very resource consuming, slow and failed (complained : No More Space). I also found it wrote and read many…
Getting ISAM error 116 during update statistics
Thanks for all your support this problem is solved by increasing the shared memory value in that server :-) On 5/26/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Increase DS_TOTAL_MEMORY from the default and increase SHMVIRTSIZE to > accomodate > the extra memory. Also …
Re: oninit -i problem
your database did come online 17:01:41 Dataskip is now OFF for all dbspaces 17:01:41 On-Line Mode 17:01:41 Building 'sysmaster' database ... 17:01:41 Checkpoint Completed: duration was 0 seconds. some minutes later someone stopped it 17:08:28 Informix Dynamic Server Stop…
oninit -i problem
online log out put Sat May 20 17:01:32 2006 17:01:32 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 17:01:37 DR: DRAUTO is 0 (Off) 17:01:38 Informix Dynamic Server Version 7.31.UC5 Software Serial Number AAC #J876311 17:01:38 Informix Dynamic Server Init…
Fragment data and idx
Hi gurus: I have IDS 7.31.UD7 I have a table with high reads and inserts, this table have fragment by expression on 4 dbspaces. The 7 index for this table, must be fragment on other dbspaces or must be on 1 dbspaces. What say the expertise ?? Thanks in advance…
Database Creation Error
I am using HPUX 11.11 for Informix 7.31 when I run oninit -i I get this on the log. The database does not initialize. My file settings are as follows > > SERVICES > srvr0001 8001/tcp #Informix port > > sqlhosts > ok_srvr onipcshm 10.0.6.2 …
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 …
Indexes on a Fragmented Table
Hi, If a table is fragmented by expression, should all of its indexes be fragmented (regardless of whether they're unique or non-unique)? At one time, I was told to keep any unique indexes non-fragmented in a separate dbspace. Platform: IDS 9.40.FC3 / AIX 5.1 Thank you.…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Restore Problem
I am tyring to restore a production backup to a spare box to get some deleted rows from one table. I am getting the following error when trying to restore: 22:38:04 Event alarms enabled. ALARMPROG = '/ifxapp/informix/etc/alarmprogram.sh' 22:38:04 Booting Language <c> from module…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
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!…
IDS 9.4 on XP64
This involves IDS 94 installation on XP64. C:\\Program Files (x86)\\Informix>oninit -iy gls function get_mt_locale failed, error -23101 C:\\Program Files (x86)\\Informix>set | find /I "locale" CLIENT_LOCALE=EN_US.CP1252 DB_LOCALE=EN_US.8859-1 SERVER_LOCALE=EN_US.CP1252 The log…
Release of space in a table
alter anindex_from_that_table to cluster, alter fragment on table <yourtable> init in ..... warning if the remaining table is huge then be aware of long trx rollbacks Superboer.…
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…
fragmentation factor
I am working on a system monitoring tool which allows the capture of information from a system rather than just monitor the data. As part of this exercise I want to somehow indicate how fragmented a dbspace and/or complete IDS system is becoming. Obviously the perfect state is …
ROWID functionality
rowid is not unique for fragmented tables. but then maybe the logical log record will include the fragment id for fragmented tables?…
partitioning
Does anyone have an example of fragmenting a table into the same dbspace ... using the new v10 feature of naming a partition ...…
SERIAL8 on a Fragmented Table
No, I checked the ONCONFIG file and CDR_SERIAL is not set. From what I have read CDR_SERIAL is only used for enterprise replication. I did just find the following link though. It may have something to do with what I'm seeing but I'm not sure. I think a serial8 incrementing by…
Re: Change chunk name
scottishpoet wrote: > on 7.31? thought you could only drop chunks on 9? > informix> onspaces -V IBM Informix Dynamic Server Version 7.31.UD8X8 Software Serial Number ACN# informix> onspaces Usage: onspaces { -a spacename -p pathname -o offset -s size [-m path offset] | …
Re: Enough of the "DB2" thread, let's talk about Fragmented Tables
Hi, depending on your fragmentation schema and the queries, you may get "fragment elimination", i.e. IDS finds out that it may not need to read certain fragments at all, since there will not be any data in these fragments that match the query. If fragment elimination happens, yo…
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…
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…
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: ONCHECK -CI
herbO via DBMonster.com wrote: > Can the message "Index fragment in DBspace" that is returned from the > execution of "oncheck -ci" be eliminated? Dropping the table or the index > and recreating in new dbspaces has not done so for me. Huh? What's the problem? It's just tellin…
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…
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…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
RE: Informix 7.23 connection problem
Our NETTYPE is set: NETTYPE tlitcp,1,100,NET NETTYPE ipcshm,1,250,CPU We did onmode -ky, oninit -y and onstat -m shows: INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 00:10:35 -- 38704 Kbytes Message Log File: /var/informix/online.log 11:04:01 Checkpoint Completed: dura…
Re: Unloading to two destinations
How would range-based fragments do the trick without needing to add a column to the table to determine whether or not the row is to be kept? The deletion rules are complex (and involve more than one column) so to-keep fragmentation couldn't be achieved with the existing schema. A…
Fragmentation of database stored on SAN
Hi Garth We use frags very successfully - just one 'gotcha' is to remember that if you use a REMAINDER IN... clause that the engine will include that path in all searches even though the fragmentation strategy steers a query absolutely to a single fragment. Caused much headscratc…
fragmentation
Hi: It wanted to know that type of fragmentation is but the optimal one: 1. Using line of commandos 2. Recreating totally the table And it wanted to know as of of these two types of fragmentation he is but the optimal one: example1: Begin work; set lock mode to not wait; lock ta…
fragmentation
Hi: It wanted to know that type of fragmentation is but the optimal one: 1. Using line of commandos 2. Recreating totally the table And it wanted to know as of of these two types of fragmentation he is but the optimal one: example1: Begin work; set lock mode to not wait; lock …
Re: Rowids in Informix Databases
Art S. Kagel wrote: > On Tue, 12 Oct 2004 07:32:44 -0400, Vijay Kumar wrote: > > ROWID is not a REAL column in the table (unless the table is fragmented that > is). It is the relative address of the row which is simply treated as if it > were a column. If your table is fragment…
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'?…
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…
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?…
Fragmentation Strategy
This is a multi-part message in MIME format. ------_=_NextPart_001_01C44480.FDBFBD00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work for a company that works with medical aid claims from members.=20 We currently use Solaris 9,…
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: 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…
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…
Table fragmentation
Hi all. We're preparing to roll to a new version of our application software. The process will entail creating a copy of our current database for them to use as they install/test the new software. This seems like an opportunity to make some adjustments. Are there any good/bad e…
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,…
Re: Table has no rows but has lots of pages
> ALTER FRAGMENT ON mytable INIT IN <dbspacename or fragment expression>; Does this rebuild the table? OK, not exactly an issue with no rows, but could be if you still had some left ... Andy…
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…
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 …
Curious problem starting IDS 7.31ud2, Suse8.2
If online is started using oninit -y the engine crashes per below.it will come up fine using oninit -py. Anyone seen this and know how to cure the problem? Up until recently the server would start fine with oninit -y. Mark 17:04:27 Informix Dynamic Server Initialized -- Share…
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…
Fragmentation usage
This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C3D9F2.8168FC00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Blank Hi All, Please somebody help me on this....... I have a stored procedure which uses a …
Fragmentation usage
This is a multi-part message in MIME format. ------=_NextPart_000_0007_01C3D9EC.A9EDF780 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Blank Hi All, I have a stored procedure which uses a table which has millions of records & hence fr…
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.…
Re: Informix in offline mode
Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<vOEsb.11220$6c3.10434@newsread1.news.pas.earthlink.net>... > Eyal Goren wrote: > > I am trying to install a product that is based on Informix server > > (7.2). > > > > The problem is that after Installation, and reb…
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…
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…
Help !!! Cant get IDS 9.2 UP
I was killing an ontape process and picked up the incorrect process id ( parent id ). I ended up killing an informix process. Now when I try to bring up informix i get the following error ... 22:13:59 Loading Module <BUILTINNULL> 22:14:04 Requested shared memory segment size r…
Panic
GlacierJust booted a server (win2000) running IDS 7.3. This was on the end of the log: 16:07:04 Dataskip is now OFF for all dbspaces 16:07:04 Init operation complete - Mode Quiesent 16:07:04 Checkpoint Completed: duration was 0 seconds. 16:07:04 Checkpoint loguniq 1160, log…
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?…
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…
Fragmentation
I'm trying to reorg one of our databases. In doing so, I want to = utilize "fragment=20 by expression" on several tables. I've made the change to the schema: create table "cshbet".tjrnl ( acct_id integer not null , counter integer not null , session_id integer, cr_date datetime …
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…
Fragmentation
Hi, We have a huge reporting table. We plan to fragment it into 6 dbspaces ( 84/6 gb in each ). Table structure - create table "e50kadm".rep_data ( date_upload date, entity char(6), ctry_cd char(2), adr_curr char(3), maj_accnt_cd char(3), maj_accnt_desc char(27), accnt_no cha…
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…
Maximum server connections 0
Get following message in the online.log.All client can't connect to IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance…
FRAGMENT expression
I'm planning to fragment some tables and indexes, and use the MOD expression. But I have one problem that one indexed column is a VARCHAR, and I think this is not possible with MOD. All the other tables and indexes I will fragment by the MOD expression, I can use columns with INT…
regarding check point
hai all, thankyou for the reply. i had following error meaages Informix Dynamic Server Version 7.30.UC7 -- On-Line (CKPT REQ) -- Up 00:05:31 -- 81080 Kbytes Blocked:CKPT ARCHIVE Message Log File: /informix/online.log 22:54:15 Rollforward of log record failed. iserrno = 191 22:…
is index reorganization needed for good performance
Yes Indexes do need to be reorganized periodically. Fragmented indexes can be more of a performance issue than fragmented tables. If you are using indexes heavily, set up a schedule to reorganize the high use indexes where you are doing a lot of inserts and deletes.…
Table Fragmentation
Hi, thanks for your suggestions, I was run the update statistics but the problem continues. Somebody know some tools for view table distributions on disks? Thanks again.. Paola Quoting "Jonathan Le...." <jleffler@us.ibm.com>: > > > > > Yes -- RTFM. > > ALTER TABLE ADD (newcol…
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…
fragmentation
I'm going to load a database and I want some tables to be store in some particular dbspace. What should I write before the semi column ? I remenber something about In dbspacename. Can somebody tell me the right sintax. Create table ........ { } ; Ed…
Fragmentation on a column type datetime
Please include the where clause of the fragmentation and the where clause of the query. "mohamed.afe...." <mohamed.afeilal@ To: ids@iiug.org meditel.ma> cc: Sent by: Subject: Fragmentation on a column type datetime [163] forum.subscriber@ iiug.org 01/29/2003 02:16 PM We fragme…
Fragmentation by Expression......
Hi, If you happen to know of an effective way to define a fragmentation by expression, do let me know. I am just too lazy trying to figure out a strategy for a table of 450M records. Thanks Abraham ===== *************************************************** Abraham Kirubakaran En…
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!…
FRAGMENT privileges - no SELECT?
IDS 2000, 9.21.UC2, Linux. One of the (several) objectives of FRAGMENT(ing) a table BY EXPRESSION can be to enhance the granularity of security permissions over table data, providing row-group-level security. CREATE TABLE employee ( employee_id INTEGER NOT NULL PRIMARY KEY,…
DR: Cannot connect to primary server
We have 7.31 on Solaris_x86 5.7. The secondary server suddenly said 16:47:22 DR: ping timeout 16:47:22 DR: Receive error 16:47:23 DR: Receive Btree error 16:47:24 DR: Turned off on secondary server and keeps on saying 12:28:20 DR: Trying to connect to primary server ... 1…
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…
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…
Data stored by fragments.
Let's say you need to roll out data from 6 months prior. Add a month column and fragment based on it's value. Each month you add a new fragment for the coming month and after the new data are loaded you drop the oldest fragment: Create table rolling_data ( ... data_month small…
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…
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…
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: Error building 'sysmaster' database.
Whats in /tmp/buildsmi.6889 ??? Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > > Sorry, > > Still the same error... > > 15:21:08 Dataskip is now OFF for all dbspaces > 15:21…
Re: Error building 'sysmaster' database.
Andy, Here is the latest try... Wed Aug 30 09:29:54 2000 09:29:54 Event alarms enabled. ALARMPROG = '/export/home/informix/etc/log_full.sh' 09:29:54 Booting Language <c> from module <> 09:29:54 Loading Module <CNULL> 09:29:54 Booting Language <builtin> from module <> …
Re: MS Access performed faster than Informix in 800000 row tests
How fragmented is the Informix table, disk space wise? The same question for Access table.…
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…
Index Fragmentation
Hi, I have a performance issue with a fragmented tables/indexes. My question is how the attached index, which does'nt contain fragmented key column, gets fragmented? What strategy it uses? What happens internally? for example - CREATE TABLE tb1(a int, b int) FRAGMENT BY …
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Fragmented tables
"Richard E. Hassler" wrote: > > For non-fragmented tables ROWID is the physical location of the row in > the database. Can SE 7.2 have fragmented tables? If so how do you know > when the table is fragmented? SE does NOT support table fragmentation you need to move to IDS. Art…
Re: Fragmented tables
Hello Richard, the feature "Fragmentation" is not available in SE Richard E. Hassler <Hassler.1@osu.edu> schrieb in im Newsbeitrag: Hassler.1-F91F23.10461826062000@nntp.service.ohio-state.edu... > For non-fragmented tables ROWID is the physical location of the row in > the data…
Fragmented tables
For non-fragmented tables ROWID is the physical location of the row in the database. Can SE 7.2 have fragmented tables? If so how do you know when the table is fragmented?…
RE: Primary chunk sanity check error
Have you tried using DATASKIP to get by this? Will >===== Original Message From "Prashant Kompella" <prashant@hartingdale.com.au> ===== >Hi, > >When we try to startup a restored Online 7.23 instance, we are getting the >following error: >"Fatal error initializing shared memory."…
Extents and Fragmentation
Hi guys, I'm a pretty new DBA, so if I sound ignorant, forgive me. In one of my busiest databases, we have a 40 million row table with 212 extents (about 3 MB)and several 4-10 million row tables with close to 200 extents. From what I read read in the past two weeks, this is a v…
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…
Error in message log : shared memory base address illegal
Hi guys, Sun May 21 00:00:02 2000 01:08:58 INFORMIX-OnLine Stopped. 01:27:27 shmat: [EINVAL][22]: shared memory base address illegal 01:27:27 using 0xc0000000, needs 0xc2691000 01:27:27 Could not create single shared memory segment with resident and non-re sident …
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.…
Detaching Fragments
We have a very large table that is fragmented by expression over 12 dbspaces. There is 1 Primary Key and 6 Indexes. Is there a way to detatch one of those fragments without locking the table due to spending hours on an index rebuild? =( Thanx, query_gurl Sent via Deja.com ht…
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…
Fragmentation Question
Hi All, I am relatively new to this, so please bear with me. I am seeking clarification on the handling of fragments created with the alter fragment... We are running INFORMIX-OnLine Version 7.23.UC11 on RS/6000 AIX 4.2.3 My understanding from the manuals is that when a table …
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…
What does DIRECTIVES ONCONFIG parameter mean?
Can anybody shed some light on the usage and meaning of the $ONCONFIG parameter DIRECTIVES. As can be seen from the following extract, it would appear to have been changed from 0 to 1. However, the $ONCONFIG file itself has a zero within it. I am guessing the engine has overridde…
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…
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…
Fragmentation opinion wanted.
>Subject: Fragmentation opinion wanted. >From: Paul Howard paulhoward@home.com >Date: 09.03.00 19:03 W. Europe Standard Time >Message-id: <8a8pop$s8m$1@news.xmission.com> > > >We have IDS 7.31 and AIX 4.3 > >I am being told by my software vendor that I should not fragment tables …
Fragmentation by expression
I have an Informix DS 7.30 UC9-1 on a HP-UX 10 box. I want to implement fragmentation on a table but want to split it up according to what week number a date in the table falls in. Can this be done or am I attempting the impossible?? Any help or suggestions would be greatly appr…
NSF subsystem error
We have this morning encountered the following error twice. The impact of this is that no new connections to the engine are allowed, but people currently attached have no problems working. In both cases we have had to bounce the engine to give access to all users. Most users conn…
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 …
Fatal error in Buffer Manager
I have just installed the IDS.2000 engine and I am getting this error when I run oninit -i: 11:09:38 Informix Dynamic Server 2000 Initialized -- Complete Disk Initialized. 11:09:39 Checkpoint Completed: duration was 0 seconds. 11:09:39 Checkpoint loguniq 1, logpos 0xc0 11:0…
Re: best procedure for table moving one dbspace to other
"Art S. Kagel" wrote: > > In WGS which does not support fragmentation, and so apparently ALTER > FRAGMENT, you will have to either use ALTER INDEX...TO CLUSTER or export/ > import. Mmmm, interesting point. As I understand it, the two products are identical. So you can technicall…
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…
best procedure for table moving one dbspace to other
echo "alter fragment on table TABLE init in DBSPACE" | dbaccess -e DB…
Detaching a Fragment
I was wondering if anyone can help answer a question about ALTER FRAGMENT DETACH. I've looked at the manual, newsgroups, and even tried Tech Support (I've been waiting a week for a reply) and I can't get a definitive answer. A little background IDS 7.31 HP/UX table schema CR…
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…
Fragmented table
Hi, all Is there anyone who can give me some advices on how to check if a table is a fragmented table, and the table is createt in which dbspace(s)? Thanks a lot. Harry…
Error Code -786
Hi all, When I run an SQL like: Alter fragment on table A attach B; (my table B is not fragmented. ) I get an SQL error code of -786, whhich says Non fragmented table being attached is not in the attach list. What does this imply and how do I overcome this. Thanks Manoj…
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…
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…
RE: Ontape -r
Did you roll forward all of the logical logs? If you do not do a complete restore of the system I believe you are required to roll forward all of your logical logs to make them consistent with the rest of your instance. Will >===== Original Message From "Anne Shelp" <shean@mcds…
Ontape -r
Hi all, I was testing the capabilities of ontape to read an archive. I restored our test database from the last tape. I took informix offline and ran ontape -r develop. Message returned that the physical restore of develop completed. The online.log follows. The problem is now w…
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…
best way to fragment existing large table?
Problem: 1 table containing in excess of 19,000,000 rows that is contained in one dbspace, not fragmented(obviously), and with more extents than I care to mention. I need a way to slowly (over the course of several days so as not to interfere with production) fragment the table …
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…
Strange ONCONFIG parameter situation....
Hi All, I am running IDS 7.31 on a HP-UX box(OS: HP-UX 10.20). A strange thing has just happened to me this morning. As a matter of course, I ran the command: oncheck -cR (to check the reserved pages) ......an error occured in the validation - the error I got was: Validat…
Fragmentation rotation
Release: 7.30uc2 Platform: AIX 4.3.2 Preface: I seem to recall this topic being discussed but could not find any references in the iiug archive. I have a table which is fragmented by time. I am keeping 122-123 weeks of history, one week per fragment. As time…
Fragment Exclusion
I would like a sanity check on my fragmentation scheme. Does anyone know why the following fragmentation clause would NOT allow fragment exclusion in a select. I know if you have a default clause Informix can't exclude fragments, but I think the 'OR' is supported in fragment ex…
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: 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…
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…
Speed of "alter fragment"?
I'd like to fragment two large tables in three or four fragments, based on dates -they're 20.000.000 rows * 18bytes and 43.000.000 rows * 54 bytes. (The rest of the tables are too small to bother with) There's two large indexes on both tables and I'm planning on detaching them, …
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?…
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.…
Increasing RAM problems
I have problems when I increased RAM from 64MB to 128MB (Dual Intel Pentium 133 MHz) informix.log looks like: Tue Aug 3 08:45:36 1999 08:45:36 Event alarms enabled. ALARMPROG = '/oms/InformixOn/etc/log_full.sh' 08:45:39 DR: DRAUTO is 0 (Off) 08:45:40 INFORMIX-OnLine Initial…
error in OnLine initialization(can't create 'sysmaster'
Hi, plattform: Solaris2.5,IDS7.23UC1 After initializing OnLine,this is what is written in "online.log": 17:32:42 Event alarms enabled. ALARMPROG = '/informix/etc/log_full.sh' 17:32:43 DR: DRAUTO is 0 (Off) 17:32:44 INFORMIX-OnLine Initialized -- Complete Disk Initialized. 1…
# 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…
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…
it's not realy a fragmentation but ..??
Hi, something seams strenge to me. Ihave created a table in one dbspace, and an index in an ather dbspace(( CREATE TABLE ... IN dbspace1); (CREATE INDEX ... IN dbspace2)). normaly it's a simple detached index, but informix insert a entry in the sysfragments tables indicating that…
Fragmentation and Optimizer
Hi people, I'm with some kind of problem using fragmentation. Here is the situation: I've send this DDL to my database server (Informix Universal Server 9.14 TC1 - WIndows NT). ------------------------------------------------------------------- create table fragmenta ( …
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…
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…
RE: Unixware 7.1 crash with Informix 7.30 UC2
Hi All, Our development machine used to run Informix 7.2 on HP UX 10.20, and we try to upgrade to Informix 7.3. The installation run OK, and the database service was available. But, then a few minutes later, the server rebooted. It happened few times, and we decide to return bac…
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: Informix 7.3 UC5 on RH Linux 5.2
I looked in /usr/include/sys/error.h and see that error 22 is related to an invalid argument of a program spawned by the init process. Call Informix support. Aris A <aris@mozcom.com> wrote in message news:7j5884$g4i$1@news.mozcom.com... When I tried to run "oninit -i" on my …
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
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…
ALTER FRAGMENT
I could find ALTER FRAGMENT on my on-line Informix manual but again dbaccess and older manuals did not seem to have this SQL construct. Q: Does IDS 7.2x support ALTER FRAGMENT?? Thanks in advance! "A" > >IDS 7.2x does not support view containing UNIONs. IDS version 7.3x >does…
Re: create view as table unions - Syntax Errors?
I could find ALTER FRAGMENT on my on-line Informix manual but again dbaccess and older manuals did not seem to have this SQL construct. Q: Does IDS 7.2x support ALTER FRAGMENT?? Thanks in advance! "A" > >IDS 7.2x does not support view containing UNIONs. IDS version 7.3x >does…
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
It is possible to create a rootdbspace during instalation larger than 30 Mb ?…
Re: Physical sizing of tables
How about using ALTER FRAGMENT ON TABLE <table> INIT IN <the same dbspace name> ? HTW, Harinath Venkata Svenska Handelsbanken New York…
DBA problems
I am able to connect to Online thru SQL or 4gl it runs fine. But whenever we try to run a 'MS-Query' the database crashes giving the message 'Connect failed'. The error no returned is 25587 which reads as follows - -25587 Network receive failed. A system call has failed. Do a D…
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.…
unexpected error message
Hi, this weekend, I was tunning my database, and I changed the LRUs and CLEANERS parameter from 32 to 128. on startup, the engine showed the following message: Sun Mar 28 10:10:36 1999 10:10:36 Event alarms enabled. ALARMPROG = '/baan/informix/etc/log_full.sh' 10:10:42 DR: …
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…
Strping or fragmenting
Decisions, decisions. I'm about to migrate a 30-ish Gb system onto a new machine. Currently, the database is using Informix mirroring, which I'm perfectly happy with. What I'm not happy with is the layout. The tables are in various dbspaces, most of which have had many chunks ad…
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…
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…
Re: --- URGENT ---- URGENT --- URGENT ---
--Boundary_(ID_M4M3EvWp+U0+L035cVHHMg) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Arturo Hope you have a backup. Looks like the instance was reinitialized (oninit -i) because sysmaster database was rebuilt. If you have…
--- URGENT ---- URGENT --- URGENT ---
This is a multi-part message in MIME format. --------------7CBD6C89E2D53C1C9B4072F6 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a serious problem: my company database has disapeared. The last thing I know, was a change sugested by an infor…
? on DATA REPLICATION
Girish.B.Manmadkar@bankamerica.com wrote in message <7acm54$d5v$1@nnrp1.dejanews.com>... >Hi there !! > >I have couple of questions for new DATA REPLICATION site here... > >1> Do I really need to have mirrored chunks in DR ? Oh yes !! rootdbs, phylogdbs & datadbs minimum on the…
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…
Problem doing ALTER FRAGMENT...ATTACH
Ugh. Platform: DG/UX R3.1, ODS 7.12.UC1X7. Will be upgrading soon, don't worry :). Problem: I have a huge table that I am trying to attach a fragment back into. This table has 53 fragments based on expressions. I am using the ALTER FRAGMENT...ATTACH...AFTER syntax to do my A…
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?…
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*.…
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.…
What is "listener-thread: err = -952" in online.log?
Hello, What causes the following error "listener-thread: err = -952" in online.log? Thanks in advance Greetings, Ditmar den Engelsen ------------------ Message Log File: /informix/ONLINE/online.log 01:00:00 listener-thread: err = -952: User's password is not correct for th…
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…
Re: Server Initialization on IDS 7.30
Is Enterprise Replication involved? If so, this sounds like the server used to exist and the other servers might be trying to issue a cdr_connect. Alanoly Andrews wrote: > Hi, > > Can someone explain the following strange behaviour of IDS 7.30? > > Hardware: IBM S70 > OS: AIX …
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…
Server Initialization on IDS 7.30
Hi, Can someone explain the following strange behaviour of IDS 7.30? Hardware: IBM S70 OS: AIX 4.3 Informix: IDS 7.30 In trying to bring up a Server for the first time with "oninit -i", the server does come up, but without the sysmaster db. The log contains several pages of th…
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: 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 …
Fragmentation and ESQL
All, this was originally going to become a question, but we figured it out, so now it's become a general FYI. We've been having a performance problem involving ESQL 7.22 (C and COBOL), IDS 7.30.UC3 and a fragmented table. The statement went something like this: SELECT * FROM …
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…
Re: Fragmentation..
At 09:59 PM 28-10-98 +0000, David Williams wrote: > Any idea when the 8 million limit on locks will be increased? It would >be nice to make it dynamic... > > If you have a fixed size array, just use the C realloc() function to > expand it.. I hear that this is a part of the 9…
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.…
Re: Fragmentation..
In article <36310BF4.BD305A69@hotmail.com>, June Tong <june_t@hotmail.com> writes >Art S. Kagel wrote: > >> (Actually I think that 4K page systems can hold 4095 chunks >> and dbspaces, but I'm not sure of that.) > >No, the limit is 2047 chunks and dbspaces on 4K page systems as w…
Re: Fragmentation..
Art S. Kagel wrote: > (Actually I think that 4K page systems can hold 4095 chunks > and dbspaces, but I'm not sure of that.) No, the limit is 2047 chunks and dbspaces on 4K page systems as well. June -- june_t@hotmail.com Grounded in Palo Alto, living on KitKat bars…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Fragmentation..
Gursoy YERLI wrote: > > Hi folks, > > Is there any constraint on database or table to create fragments. Only the trivial ones, ie no two fragments of the same table/index can reside in the same dbspace and fragments cannot reside in temp dbspaces. Beyond that the sky is the limi…
Fragmentation..
Hi folks, Is there any constraint on database or table to create fragments. Gursoy YERLI…
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…
Re: Informix database reorganization
You can reorganise your tables one at a time using ALTER FRAGMENT. You don't actually have to fragment your table across multiple dbspaces when you do this. Neil Truby Londis Holdings London, UK…
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…
Re: Database Partition
Ravi Verma wrote: > I have the following questions regarding Database Partitioning. > > 1. Is it possible to take one or more partition off line while the table itself is online? Yes. You need to set the DATASKIP on. However, if there are other tables or partitions of other t…
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: Fragmentation
ckchan5@my-dejanews.com wrote: >I am using Informix 7.24 UC5, and I did fragmentation for all my tables and >indexes, the questions are : - > >1) How to check back all the fragmentation style ? (Round robin or expression) >2) How to know which dbspace use for each table fragment…
RE: Fragmentation
ckchan5@my-dejanews.com wrote > > I am using Informix 7.24 UC5, and I did fragmentation for all my tables and > indexes, the questions are : - > > 1) How to check back all the fragmentation style ? (Round robin or expression) > 2) How to know which dbspace use for each table fra…
RE: Fragmentation
The simple way is to run a dbschema with the -ss option of the database and look at the output. Regards, David Ashby -----Original Message----- From: ckchan5@my-dejanews.com [mailto:ckchan5@my-dejanews.com] Sent: Tuesday, 15 September 1998 11:01 To: informix-list@iiug.o…
Fragmentation
I am using Informix 7.24 UC5, and I did fragmentation for all my tables and indexes, the questions are : - 1) How to check back all the fragmentation style ? (Round robin or expression) 2) How to know which dbspace use for each table fragmentation Regards -----== Posted via De…
Re: altering extent sizes
Kate_Tomchik@homedepot.com wrote: > > What does it mean to alter fragment init? It's an SQL command that initiates fragmentation across dbspaces or removes fregmentation from a table. However, if you use it on an unfragmented table so: ALTER FRAGMENT ON table1 INIT in dbspace1…
Attaching VP CPUs to real CPUS on AIX
Hi I am experimenting with the /usr/sbin/bindprocessor command on aix 4.1.5 to pin VP CPUs to real CPUs on an 8 CPU RS6000. What real benfits does this provide ? Does it ever screw anything up ? ( I had a down system today after changing too many things at o…
Re: Attaching VP CPUs to real CPUS on AIX
Graham mitchell wrote: > > Hi > > I am experimenting with the > /usr/sbin/bindprocessor > command on aix 4.1.5 to pin VP CPUs to real CPUs > on an 8 CPU RS6000. > > > What real benfits does this provide ? > Does it ever screw anything up ? > ( I had a down system t…
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…
Table corruption after system reboot
Hi all, I'm running Informix OnLine 7.12.UC1 on aTandem CM 1450 NonStop-Ux B32 IPM 10. Rebooting the system after a regular shutdown ( Application shutdown, Informix shutdown (onmode -ky), UNIX shutdown), I got the errors as shown in the following logs. The table involved is …
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…
Onbar with Online 7.23
I'm seeing a strange problem with on bar (Av 20000 / Ux 4.20) under v.23 When i issue "onbar -r", i get the following in the log (there included a page that contains the description of the log file) for example : If the backup finished at logical log 36 and then i issued "onbar -…
online 7.2 problem !!
This is my online.log last lines afer init online 7.20 : 11:08:01 Error: Unable to reset open files limit, must run as super-user 11:08:01 Event alarms enabled. ALARMPROG = '/opt/Informix/V7/etc/no_log.sh' 11:08:02 DR: DRAUTO is 0 (Off) 11:08:02 INFORMIX-OnLine Initialized …
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…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
fragment question
When fragmenting by expression, can the following be done : a).... fragment by expression dat1 < "01011990" in dbspace1, remainder in dbspace2 I believe it can be done. When row is updated, is it moved to appropriate dbspace ? But b)... fragment by expression …
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…
oninit problem, create_vp: cannot allocate memory.
Hi there, When I oninit, the database is working OK, but the online.log has some errors as following: Wed Jun 10 09:53:05 1998 09:53:05 Event alarms enabled. ALARMPROG = '/local/informix/log_full.sh' 09:53:08 DR: DRAUTO is 0 (Off) 09:53:09 INFORMIX-OnLine Initiali…
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…
V7.3X Attach/Detach Fragment - Avoiding Index Rebuild
Hi, Informix proclaims that IDS V7.3X is smarter when it comes to Attach/Detach of a fragment using 'Alter Fragment On Table x Attach/Detach...'. They claim Index rebuilds can be avoided when Detaching if the index fragmentation is identical or highly parallel to the table fra…
Re: Fragments
Albert Wisse wrote: > > Hello, > > I want to verify if I am right: > > I think using fragments make sense in the following case: > > My hardware is: Sun Enterprise server with 4 * 250 MHZ CPU's (NUMCPUVPS > = 3) > Internal memory 1280MB > Sparc En…
Re: Fragments
In one sense - yes. But Online also uses fragmentation for process spawning. So even if you have two fragments on the same drive it will help because the engine will spawn two scan threads, one per fragment instead of just one. Fragmentation is a good thing - just be sure you …
Fragments
Hello, I want to verify if I am right: I think using fragments make sense in the following case: My hardware is: Sun Enterprise server with 4 * 250 MHZ CPU's (NUMCPUVPS = 3) Internal memory 1280MB Sparc Enterprise Network Array (SENA) disk-subsystem The disksubsystem has…
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: +…
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
Memory locked fragments in 7.23
Has anyone worked with locking table fragments in memory in 7.23?? How does it work? What is the command?…
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: 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, rootdbs problems
I had an informix DB up and runing on a HPUX 10.20 system running through Livewire and Netscape Enterprise Server 2.01 to publish data to the web. I had to rename the system (new ip and hostname) and remove the external Jaz drive and now my informix db engine wont work anymore. …
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…
fragmentation index
Hi Art, I need your explanation below, is this correct ? When i ran sql script using about 6 tables, where from one of this list table i'm use is index fragmenting. This sql script it took an hour, but when i remove the table which use index frament, it only took 5 minute. He…
Fragment by expression
I have a 200 million, 50GB table that I would like to improve query performance on. I am evaluating using Fragmentation by Expression. 90% of the queries use a date column as part of the where clause. I was wondering if anyone has used only the month (12 fragments) for the fra…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
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…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
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…
non fragmented tables
What is the best method to find non fragmented table and fragment those non fragmented tables Thanks in advance BALA bala.peddi@fmr.com…
Re: fragmentation and sqexplain
> The Question : what does fragments: 0 vs. fragments: 1 mean ? This indicates that only one fragment will be searched in executing this query. If it required multiple fragments, you would see something like "fragments: ALL" or "fragments: 0,1". The number of the fragment that…
fragmentation and sqexplain
Hi everybody, I have tested 2 fragmentation strategy's : 1. create table "wxs".fragm1 ( id serial, tijd datetime year to second ) fragment by expression tijd < '1997-03-01 00:00:00' and tijd >= '1997-01-01 00:00:00' in sub_space1, tijd < '1997-05-01 00:00:00'…
fragment by date expression
Hi, in one of our table 'dta' , the old records are not physically deleted , we have a field 'dtadte' that might content the date of the suppression. This table is now growing very fast, and I want to cut the number of rows to scan by fragmenting the table in the following way:…
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…
Re: Fragmenting tables/indexes
Kate_Tomchik@HomeDepot.COM wrote: > > Hi. We have a system that we have fragmented based on Date so that when we > purge our system on a daily basis we simply drop the oldest fragment. This > part works > superbly, but retrieval of records seems to be unneccesarily slow. I > b…
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…
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: UserID/Password error.
In article <5nq0m7$1n8@cssun.mathcs.emory.edu>, Rajesh Koilpillai <rajeshk@hcla.com> writes >Hi > > I have tried all the suggestions which some of u have suggested. > But still i get the following error in 'online.log' when i try > to start my server on a Solaris …
UserID/Password error.
Hi I have tried all the suggestions which some of u have suggested. But still i get the following error in 'online.log' when i try to start my server on a Solaris 2.51 machine. - Rajesh Email : rajeshk@hcla.com 15:32:51 Error: Unable to reset open files limit, must run…
Re: Hit 956 error when bring up informix Online Dynamic Server
Walter, Thanks. Problem solved after add in "singsun2.sing.cig.mot.com" in the hosts.equiv. Walter S. Tyszka wrote: } } > Hello, } > } > When I startup informix online dynamic server (version 7.12.UC1), it } > always give warning message saying Network deamon is down. I get th…
Re: Hit 956 error when bring up informix Online Dynamic Server
} Hello, } } When I startup informix online dynamic server (version 7.12.UC1), it } always give warning message saying Network deamon is down. I get these } messages in the online.log: } } : } 19:09:42 Dataskip is now OFF for all dbspaces } 19:09:42 Quiescent Mode } 19:09:42 …
Hit 956 error when bring up informix Online Dynamic Server
Hello, When I startup informix online dynamic server (version 7.12.UC1), it always give warning message saying Network deamon is down. I get these messages in the online.log: : 19:09:42 Dataskip is now OFF for all dbspaces 19:09:42 Quiescent Mode 19:09:42 Checkpoint Complet…
NUMCPUVPS and Fragments
On page 2-11 of the Informix Performance Guide Manual (Ver. 7.2), it states that "queries perform best when the number of scan threads is a multiple (or factor) of the number of CPU VPs". It then gives the example of having 6 CPU VPs, and a table with 10 fragments, and suggestin…
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…
Fragmentation Strategies
Hello, We are considering using fragmentation by expression for some of our tables. Here is our problem: we want to fragment by the 1st two char's of the column. i.e. col_1[1,2] = "XY". Does anyone have any thoughts on this? Would this hinder performance? Also, if yo…
Re: FRAGMENTATION
Javier Puente wrote: > > Hi Folks, I am trying to define an strategy of table fragmentation, and > i have a doubt. > Is there someway in which can i define a remote chunk or dbspace in > another server without use NFS.???? > > Thanks in advance, > Javier Puente Hi Javier ! Th…
Re: FRAGMENTATION
informix@noboagye.noboa_corp.com.ec (Javier Puente) wrote: :Hi Folks, I am trying to define an strategy of table fragmentation, and :i have a doubt. :Is there someway in which can i define a remote chunk or dbspace in :another server without use NFS.???? I would be very caref…
Re: FRAGMENTATION
Javier Puente wrote: > > Hi Folks, I am trying to define an strategy of table fragmentation, and > i have a doubt. > Is there someway in which can i define a remote chunk or dbspace in > another server without use NFS.???? > > Thanks in advance, > Javier Puente I really don't …
FRAGMENTATION
Hi Folks, I am trying to define an strategy of table fragmentation, and i have a doubt. Is there someway in which can i define a remote chunk or dbspace in another server without use NFS.???? Thanks in advance, Javier Puente…
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…
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…
Fragmented Table
I have recently taken over a project with over 300 stored procedures. Because of this, sysprocbody and sysprocplan are tremendoulsy interleaved/fragmented. Is there a way to correct this? I wasn't sure about running index clustering or dropping and re-creating system tables. TI…
Re: ONDBSPACEDOWN config parameter
At 08:30 AM 1/22/97 -0500, you wrote: >Recently, I discovered the importance of the ONDBSPACEDOWN parameter in >ver 7.1. When performing a warm restore on a non-critical down chunk, >our users began complaining of problems. We found the hard way that our >ONDBSPACEDOWN was set …
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 …
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…
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…
Re: problems initializing
In article <4qm7tq$um3@portal.gmu.edu>, Alwyn E Goodloe <agoodloe@osf1.gmu.edu> writes > 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 …
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…
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)…
HELP Upgrade from 5 to 7
HELP, 02-Apr-1996 I am trying to upgrade from 5.06.uc2 OnLine to version 7.11.uc1 on a Sun running Solaris 2.4. Informix delivered the "INFORMIX-OnLine Dynamic Server Migration Guide Version 7.1" and I tryed to do the upgrade as described in this manual. One of the ste…
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…
Re: Fragmentation and Extent Size
Well, actually I didnt specify extent size in my ALTER FRAGMENT SQL. Apparently the default for a table must be 1/2 the original size (even though I fragmented across six disks). The original included indexes, the new fragments didn't. They too were (grossly over) allocated se…
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.…
Re: Informix 7.10 fragmentation
We had problem with 7.10.UD1. When selecting from fragmented tables using the column on which the fragmentation was based, no rows would be returned. I can verify that this is fixed in 7.11.UC1.…
Re: To fragment or not to fragment - opinion
Jon C. Vemo (jvemo@cyberspace.com) wrote: : Chris - : Can you elaborate a bit. Your response has me very concerned, as I am = : about to implement fragmentation. I thought that with fragmentation, if = : a query could rule-out a fragment, it would not scan it. This a = : signifi…
RE: To fragment or not to fragment - opinion
Chris - Can you elaborate a bit. Your response has me very concerned, as I am = about to implement fragmentation. I thought that with fragmentation, if = a query could rule-out a fragment, it would not scan it. This a = significant piece of functionality which, according to you,…
To fragment or not to fragment - opinion
Whatever you choose to do, be aware that when fragmenting the optimiser will need to search all fragments (or all index fragments) when processing your query. In fact in INFORMIX-OnLine 7.10.UD1 even if your table is not fragmented but it's index is in another dbspace, when you …
To fragment or not to fragment - opinions requested
On a SMP (4 processors) system is it better to fragment all of the tables using round robin, or should the tables be put is different or the same Dbspace? My main concern is for performance on a database that is normalized and uses several joins on queries. Yes we will be chang…
online crash
Dear All, I have come across this problem with online 7.10.UC1 on a Spacr 5 running Solaris 2.4. I have a cursor that does a count on 1 table with a where cause of 1 = 1. The count works but when the cursor is closed it brings the engine down (see online log below). This progra…
Table Fragmentation
We are currently running Informix 7.1, and are more than a little disappointed with the 'improved' performance we were promised when migrating from Informix 6 to 7. We are now hoping that by implementing some of the new 7.1 features, we will at least get back to the same performa…
7.1 Fragmentation
When utilizing the table fragmentation under 7.1, will the hash expression allow dbspace exclusion during queries? Which would be more beneficial for a decision support system, hash rule fragmentation of range rule based fragmentation. Are there advantages to putting detached i…
Re: Fragmentation
-> Regrads You mean "defrags", don't you! :)…
Re: Fragmentation
hsprint@aol.com (HSPRINT) wrote: >Is there an equivalent to the DOS defrag for Informix tables? Our >application is purging about 20 old records a day in some of the tables >and I am concerned about the efficient use of space. First you can check to see what is going on. Run …
Fragmentation
-> Is there an equivalent to the DOS defrag for Informix tables? Our The easiest thing to do is either ALTER an INDEX TO CLUSTER or unload/reload the tables. -> application is purging about 20 old records a day in some of the tables and -> I am concerned about the efficient us…
Re: Fragmentation
In article <3ttpat$f9c@newsbf02.news.aol.com> hsprint@aol.com "HSPRINT" writes: > Is there an equivalent to the DOS defrag for Informix tables? Our > application is purging about 20 old records a day in some of the tables > and I am concerned about the efficient use of space. …
Fragmentation
Is there an equivalent to the DOS defrag for Informix tables? Our application is purging about 20 old records a day in some of the tables and I am concerned about the efficient use of space. Thanks. Howard Schwartz HSPRINT@AOL.COM…
PERFORM and fragmentation
I am trying to query a table in 7.01 using PERFORM in isql 4.10. When I try to generate a form a use it for a query, I receive the following errors: Rowids do not exist on the table The cursor or statement is not available Is this error caused by fragmenting the table across …
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…
FRAGMENTATION ? (FWD)
J> Date: Mon, 12 Jun 1995 11:25:46 -0700 > From: johnl@informix.com (Jonathan Leffler) > To: timothy.hood@sltrib.com > Subject: Re: FRAGMENTATION ? (FWD) J> Can you justify this with some version numbers? > A real bummer I've hated was how you can't drop and create a table i…
FRAGMENTATION ? (FWD)
J> Date: Mon, 12 Jun 1995 11:25:46 -0700 > From: johnl@informix.com (Jonathan Leffler) > To: timothy.hood@sltrib.com > Subject: Re: FRAGMENTATION ? (FWD) J> Can you justify this with some version numbers? > A real bummer I've hated was how you can't drop and create a table i…
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?…
FRAGMENTATION ? (FWD)
I> From: inf_bb@hermes1.sps.mot.com (Bob Baskett) I> the following fragmentation sql statement creates the table but the load > fails due to the given error: I> CREATE TABLE "informix".fragbyexpnorem > ( > c1 CHAR(1), > c2 SERIAL NOT NULL > ) > FRAGMENT BY EXPRESSION > (…
Fragmentation and OLTP
We are in the processes of developing an OLTP application, which will be accessing an Informix 7.1 server, running on a SMP system (Sequent). We are trying to determine what, if any, fragmentation strategy, is the right one. I've previously thought of fragmentation as benefitting…
Re: fragementing a table w/ unique indx
I belive that the problem is that you cannot fragment a unique index. Since you can operate against a fragmented table when one of the fragments is down, the unique index cannot be enforced. When you created the table without fragmentation, then fragmented it, the unique index …
Informix Fragmentation
I'm planning on using Informix's "fragmentation" feature. However, I'm getting a lot of opposition from some folks that have the "I don't understand how it works therefore it must not work" mentality. I'm sure we know some people like this. So, anyway, I have a couple question…
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…
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 ________…
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 …
remote dbspace
Is anybody define a dbspace on a remote machine...!!! with online 5.0. Thanks...…
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…
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…
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…
systabauth fragmentation
In one of my databases the systabauth table is fragmented into 10 segments. What's the best way to fix a system table when this happens. I usually unload the table, recreate it and reload. But, I'm afraid to try anything like this with a system table. Thanks, Cathy Cathy J. S…
Fragmentation
> > > > In the good old days of SE, a table with a high level of activity > > (i.e. deletions/inserts) became riddled with old data row slots > > which were available for re-write, and the index began to look like > > swiss cheese. To correct this periodic unload/loads or c…
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…