Oninit® Archive
Results for “DBSPACETEMP”
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
I am able to execute the query you provided even if the temp dbspace is down But actually i need to display dbspace name as well,so i am using the following query which gave the error select name,fname,is_offline,is_recovering,is_inconsistent from sysdbspaces dbs, syschunks chk…
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 ------------------------------…
Ifx 14.10xc8 - ISAM error: operation illegal on a DR Secondary
Hello Andreas, Reading your suggestions carefully I realised that the dbspace that contains the database was configured with a page size = 16K and that the tempdbs was in 2K. So I created a tempdbs16 with a page size of 16K and changed the DBSPACETEMP=tmpdbs16:tmpdbs and the erro…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
Temp dbspace usage
Hello everyone, Hope all are safe and healthy in this pandemic. How can I check which query/session or activity is using more Temp dbspace. We have total 32 GB temp dbspace (16 temp dbspaces with 2 gb chunk each). Currently gets warning message for Temporary dbspace is 94% used …
Index page size recommendations
Art, Not sure whether you saw my previous post. The online docs say: You can specify a page size for a standard or temporary dbspace if you want a longer key length than is available for the default page size. You had said that all temporary dbspaces were created using the ser…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
Table and index defragment
So look here... Attached indexes become non-fragmented indexes in the same dbspace as the new non-fragmented table. Constraints that do not use Detached indexes become non-fragmented indexes in the same dbspace as the new non-fragmented table. Fragmentation strategy of Detached i…
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…
Re: IDS 12.10 - temporary dbspaces locked
If temporary dbspace operations are a bottleneck for that server workload, then yes, using a ram disk will speed up things. I have not done it in production, but the following articles may be of help: https://www.oninitgroup.com/ram-disk-and-informix http://www-01.ibm.com/suppo…
IDS 12.10 - temporary dbspaces locked
Hi, I have repaired that my systems have several locks over temporary dbspaces on syslocks. I have seen some information about using RAMDISK to improve performance. Can somebody give some help about this? How to do it and if it is the case, how can I detect that kind of concurre…
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…
Users using temporary dbspaces
Hi, I need to know a list of users who are using a temporary dbspace in a moment. I have tried with combination of "onstats" and a SMI's sentences, but i can't find the way to do it, if it is possible...Can anyone help me? Regards…
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…
rootdbs is full message
Thank you for your response. I checked rootdbs using 'oncheck -pe rootdbs' so I'm thinking to your first opnion but that message occured several time, so how can I not make that message? Add temporary dbspace? or other way? and how can I find operation that using high cost te…
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?…
dbspace soft links to storage
Hi all, Regarding using soft links for dbspaces, I understood how I do it for a dbspace, make a soft link in $INFORMIXDIR/storage/chunks to the dbspace on the storage and then add the dbspace using the soft link as the path. But do I do it for the rootdbs ? since it is created at…
Creating a dbspace with a non-default page size
Hi, My environment : IDS 12.10 FC6 with HP-UX 11.31 I'm creating a new instance for a datawarehouse and I want to use the option -k pagesize of the command "onspaces". I want to use the non-default size only for data dbspaces, not for root, logical, physical or temporary dbspac…
use of dbspaces?
Gurus: If the entire database is cached in the bufferpool, does it matter how the database tables and indices might be physically deployed in dbspaces? I typically observe read cache hit rate to be 99.99% and write rate to be 98%. The database layout hasn't been modified for o…
srt* files PSORT_DBTEMP DBSPACETEMP strange
This is a very opaque area of the engine. I wrote a blog post about user-generated temporary tables which touches on this topic a while ago: https://informixdba.wordpress.com/2015/03/29/temporary-dbspaces/ What specifically is causing the srt files to be created. I see you can …
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
Backup is Blocked:ARCHIVE when temp space being us
The backup doesn't shift transaction activity to DBSPACETEMP. It just saves the before image of all the changed pages (first time each page is changed) in DBSPACETEMP. But it does this after the backup effectively starts and it seems that your system got hang at the checkpoint wh…
Change temporary dbspaces size
Dear friends of the forum: I know you probably consider this too basic question, but I want to make: Resizable need temporary dbspaces. I have 8 temporary dbspaces, with a size of 1 GB each, but need about 30 GB to run well the update statistics high. What is most advisable ?…
DBSPACETEMP Best Practice
Hi, We are running Informix 11.70.FC7 on Solaris. We have data in both 2k and 8k dbspaces and indexes in 4k dbspaces. What is the best practice regarding temp spaces. Do we need to have a temp space for each size dbspace? Thank you, --Dave --001a114242a4f4c48d052a51e11c…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
Chunks Down Help
Hi restore the dbspace from your last archive, if you don't have an archive you must call the support, they have tools to quickly bring up dbspaces.…
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
Informix temp spaces
Hello everyone I have Informix 11.7 with UNBUFFER databases. I'm playing with informix temp dbspaces. I have create 8 temp dbspaces 4 are createt with "T" flag and 4 without, like regular dbspace. All 8 dbspaces are added in DBSPACETEMP on onconfig file. While monitoring temp…
WARNING: temporary DBspace tmp_4k_dbs is full
Hi, We are running informix version 11.7 dataserver on AIX 6. We have two dbspaces listed in our DBSPACETEMP onconfig parameter in the following order : tmp_4k_dbs,tmp_dbs. Both dbpsaces are 4k page size. From time to time we encounter the following message "WARNING: temporary …
Insufficient space in temporary dbspaces
Hi, >>>> My IDS log is reporting "Insufficient space in temporary dbspaces" and I think I have enough space. IDS: IBM Informix Dynamic Server Version 12.10.FC5WE Platform: CentOS release 6.6 Spaces: | [informix@lpsalxids ~]$ onstat -d | | IBM Informix Dynamic Server Version 12.…
View with left join.
Hi Marco/Fouad, I would be interested to see the DBSPACETEMP set up. I know the engine has logic that means it will look at all the spaces listed in DBSPACETEMP and if none of them has enough free space to create the temporary table, it will use ROOTDBS instead, regardless of h…
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,…
force DBSPACETEMP
Hi, We are running informix 11.70.FC7. Is there a way to force a session name to use a specific DBSPACETEMP? Can this environment variable be set via sql? We are trying to find a way, perhaps via sysdbopen that if a specific user name connects then set their DBSPACETEMP to a cer…
Root db space fills up
The instantiated view is approximately 160 MB and the dbspace added is 2GB. It seems that the database doesn't even try to use the new dbspace. I've looked at what is in the different dbspaces during execution of the select query against the view and the temp table appears in the…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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…
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…
DBSPACETEMP, sorting, temporary tables...
Hello gurus, Temp dbspaces are for sorting and for temporary tables. These dbspaces are actually disk spaces. We don't have a way to sort or to create temporary tables in memory, do we? Memories are getting less and less expensive, wouldn't it be much faster to use memory instead…
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?…
temporary dbspace question
HI, I defined 8 temporary dbspace ,everyone is 5GB. DBSPACETEMP TMPDBS01,TMPDBS02,TMPDB03,TMPDBS04,TMPDBS05,TMPDBS06,TMPDB07,TMPDB08 sometimes ids report tmpdbs01 is full, "create temp talbe " will only write to tmpdbs01 dbspace. but sometimes ids report TMPDB03 is full or TMP…
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.…
How to set up temporary space per session
Hi, I have an application that creates large temporary tables, causing temporary dbspaces are full. This hurts the entire instance. At the moment it is not possible to change the application. One solution would be to increase the size and / or amount of the temporary dbspaces, b…
Emergency, Error 271
IDS 11.50 FC 9 (ultimate) I have a program that runs in parallel, multiple instances at the same time (20 instances), this program is launching the same queries on the same table, and after a few instances the error code 271 is displayed. I checked the space and dbspace is not s…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Re: Strange behaviour when using a view in 11.....
Very odd. At this point with normal dbspace in DBSPACETEMP and TEMPTAB_NOLOG set, the only temp tables in rootdbs should be ones creates with an explicit IN clause. Art On Jun 7, 2012 2:50 PM, "STEVEN MITTELSTAEDT" < steven.mittelstaedt@gmail.com> wrote: > Art, Thanks for the r…
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…
DBSPACETEMP - IDS 11.50.FC7
I am encountering an issue on my production database server with my temporary dbspaces filling. Whilst investigating this, it seems that not all of the temporary dbspaces as listed in the onconfig are being utilized! DBSPACETEMP tempdbs01:tempdbs02:tempdbs03:tempdbs04:tempdbs05:…
DBSpace Full?
We are trying to insert data into a table and get the following error WARNING: DBspace dldata1 is full Seems pretty straight forward... except the space is not full. Only the last chunk added is full. (see onstat -d below) informix@psdb03sat:~> onstat -d | grep 19 8e33ee80 …
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
onbar dbspace restore with fragmentation
Five minutes after my data warehouse project's weekly ETL script for its logged database completed, an assert failure occurred and the informixserver halted at a checkpoint. When I forced it to continue, the instance remained online but an entire dbspace with constituent chunks …
DS_NONPDQ_QUERY_MEM and hash table
Hi, In the hash join, Do the hash table being stored in DS_NONPDQ_QUERY_MEM or other area in the virtual segment? if it was stored in the DS_NONPDQ_QUERY_MEM , the size of the hash table is large than the DS_NONPDQ_QUERY_MEM ? what the additional data should be stored? Is it in …
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…
DBSPACETEMP IN SDS CLUSTER
I have a Cluster SDS, secondary server is setup as UPDATABLE_SECONDARY 1 my application is connected through CM, When an user is connected to Secondary Server i recived. -229 Could not open or create a temporary file. -131 ISAM error: no free disk space. I checked "onstat -d" a…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
stupid question time
John, Whether or not the temp tables are logged would also play a role in where they are created. Art Kagel has beat it into my head that is the reason for having a "non temp" dbspace listed in your onconfig DBSPACETEMP parameter. But I would still go beat up a developer just t…
clean temporary dbspaces
Hi, v11.50 FC8 , AIX 6.1 I need to perform a maintenance in the area of temporary dbspaces. I have to remove some temporary dbspaces. As there is no option to reset the on-fly DBSPACETEMP, so I set the DBSPACETEMP variable in the profiles of users to not use the dbspaces I need…
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 …
Query to list temporary tables
Does anyone here have an sql query for me, for selecting temporary tables, their owner, and the dbspace they reside in ? Dirk ________________________________ NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.za/SUPPORT/LEGAL/Pages/EmailDisc…
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.…
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.…
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…
Re: DBEXPORT IN RSS NOT WORKS
I think it's a BUG. It will work if you use just one tempdbs. Set DBSPACETEMP=dbstemp1 on RSS secondary, then bounce engine (RSS secondary).…
Number of dbspaces
Hi, I have a database of 250 GB of user data. How many dbspaces is suitable for optimal performance: - For OLTP transactions ? - For queries ? - For backup using onbar ? Currently, I have 30 dbspaces configured. Is there any strategy or tip that I can use? Please, provide any i…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
DBEXPORT IN RSS NOT WORKS
HELLO!!! We have an environment RSS with IDS 11.50.FC7 on HP-UX 11.11. We want to do our backup method a dbexport on RSS side.. but appears the following message, after set STOP_APPLY=1, we run dbexport database command: "The operation cannot be performed on this RS secondary s…
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.…
Page size for DBSPACETEMP?
Is there any performance reason to have the Temp Dbspaces anything other than the default page size? Informix 11.10 and 11.50 Linux Redhat 4 and 5 Our current system has standard dbspaces and bufferpools of 2, 4 and 8. Our Temp Dbspaces are 4K. I am wondering why they were ev…
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…
Comparing by Date, Time & Seconds columns
> Oh, I forgot to add in that the informix database is a read only DR > server. So, we are not able to alter the table structure, create > stored procedures/functions or temp tables... It's a pain in the neck > dealing with the vendor and informix. I wish there was an easy > sol…
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…
Get Session Env variables
How can I get/monitor session environment variable information from the Database? We are using IDS 11.50.FC4. Specifically, I would like to see which DBSPACETEMP a session is using based on what that particular application sets it to. --Dave…
Data Dbs suddenly went Full
Hi, We've faced an issue where the dbspace kept on reducing and suddenly it reaches dead level. Then we've added space, but after adding space into it, the old space is being shown as well, as it never being used. After monitoring log file, we've found "temporary DBspace tempdbs_…
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…
Doubt about DBTEMP environment variable
Hello, folks. We´re running IDS 11.50.FC4 on a linux_64 machine. As the official documentation says: "If DBTEMP is not set, the database server creates temporary files in the /tmp directory and temporary tables in the DBSPACETEMP directory. See DBSPACETEMP for the default if DBSP…
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…
temp space question
So I was under the impression if you run a query that requires implicit sorting and needs temp space, and you have nothing set in the environment like PSORT_DBTEMP, it would use the DBSPACETEMP parameter from the onconfig file. Mine is: DBSPACETEMP wto_tmp1:wto_tmp2:wto_tmp3 Yet…
RE: temporary dbspace usage
>I open pdq already. >set pdqpriority 100; >select ....; > >in the onconfig file >the parameters are setted >and ds total memory set 4G > >onstat -g mgm monitor the pdq use normally. Did you set environment PSORT_NPROCS? If not, try setting it to 3 or to 4. HTH, Paul M.…
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."…
temporary dbspace usage
this question I ask several days ago, but not resolve, so rewrite again,:-) I have a production environment, 6 temp dbspaces in use which have 4G for each, 24G total. OS: HP-UX IDS: IDS 10.00 FC8 temp dbspace: tempdbs01,tempdbs02,tempdbs03,tempdbs04,tempdbs05,tempdbs06 In my envi…
temporary dbspace usage
Hello, I have a production environment, 6 temp dbspaces in use which have 4G for each, 24G total. OS: HP-UX IDS: IDS 10.00 FC8 temp dbspace: tempdbs01,tempdbs02,tempdbs03,tempdbs04,tempdbs05,tempdbs06 In my enviroment, when several sessions run at then sam time which have sort…
Update stats impacts insert performance
Hi, Thanks for detailed answer. But still I am a bit confused that; Why do we need to run update statistics low for column "aaa" when we alreayd hve run "high update stats" on this column? As Art said that if PDQPRIORITY is set, PSORT_NPROCS & DBSPACETEMP are no more effective. S…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
WARNING: Next backup of DBspace rootdbs must be le
Hi, thanks for answering, yeah we add chunks to dbspaces, but we had not added chunks to rootdbs y physical y logical logs dbspaces. For example today and May 26 i added chunks to normal dbspaces and we didnt get the WARNINIG NEXT backup message. What other reason it could cause …
Re: Upgrade to 10 Failed
chang the link name of root dbspace file, it can't be same as rootdbs.…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
how to save the removed chunks by mistake
Someone want to drop a dbspace and remove the chunk file by mistake. Server can not restart owing to the down chunk. Can not drop dbspace or chunk by 'onspaces' or 'onmonitor'. Any way to solve this problem ?…
Finding the session which uses a particular temporary table
I need to know what session or sql is consuming high temporary space due to other session are affected (-264 Could not write to a temporary file.) I have two temporary dbspaces (tmp1 and tmp2, 1 GB c/u). I get from sysmaster: tabname type nptotal dbspace…
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…
DBSPACETEMP
I note in the IDS 11.5 infocenter: "The dbspaces that you list in the DBSPACETEMP configuration parameter must consist of chunks that are allocated as raw UNIX® devices." Looking back to the IDS 10.0 manuals I see the same single quote... (well hidden!) I also note that windows …
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…
DBSPACETEMP on 11.5
I have recently upgraded to IDS 11.5 FC2 on HP-UX from IDS 9.4. I seem to be experiencing difficulties with my Temp dbspaces. I have five 128Meg temp dbspaces created. In 9.4 a single program could use all 5 spaces when building a temp table. What I am seeing in 11.5 is that only…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
insert performance on fragmented table
I added another dbspace and the insert time was cut in half. Thank you Paul Sullivan…
Migration to a new storage
We will use a new storage for dbspaces. How I can migrate data from old storage to new the new storage. Can I use ‘dd’ for it? I will move dbspaces by ‘dd’ and re-link my dbspaces on new storage.…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
Is there a downside to creating large chunks?
I am running a Baan ERP system on Informix 11.50/HPUX that has 5800 tables. I want to spread these across 8 dbspaces. Is there a disadvantage or advantage to creating 1 chunk per dbspace initially? Thanks, Andy…
IDS 9.4 DBSPACETEMP versus /tmp
Hi everyone. Kind of a sanity check question of you don't mind. I have a situation where I have an IDS 9.4 database that has a tempdbs dataspace that is not big enough to handle some sort intensive queries. According to what I am reading by simply changing the ONCONFIG parm DBSPA…
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.…
RE: what is using tmp dbspace ?
Hi, With this SMI query you can find out the names, dbspace of creation (rootdbs or temp dbspaces), database, owner (userid), timestamp, type of temp table (logging vs non-logging), disk space used, of each of the temporary tables that are currently created on the system: How t…
Re: what is using tmp dbspace ?
Hi. If you use oncheck -pe your-temp_dbspace you'll see existent temporary tables with their owners, which would be people who is using temporary space. I hope you find this useful Omar --- Floyd Wellershaus <floyd@fwellers.com> wrote: > Is there a…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
One temp space fills and 4gl fails
The DBSPACETEMP environmnt varibale is not set. The tempspaces are defined in the onconfig file on this system. # DBSPACETEMP: # OnLine equivalent of DBTEMP for SE. This is the list of dbspaces # that the OnLine SQL Engine will use to create temp tables etc. # If specified it mus…
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…
Temporary Restore of 1 dbspace
Hi guys, anyone available who can help me out ? Is there a possibility to restore 1 single dbspace (backup done with networker) in a different location without interfering with production ? (If necessary in a new instance) In fact we need to recover the info of 1 column in 1 s…
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…
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 …
Restoring Specific dbspaces
IDS9.40.FC4 HPUX11.0 Hello all a few questions for you regarding restoring specific dbspaces. The customer we support has added a test company (within baan) into a specific dbscpace, if this testdata becomes corrupt would it be feasible to restore this dbspace only? When restor…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Types of dbspaces
Hi all: In INFORMIX+HDR that types of dbspaces support ???? Thanks _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/…
Re: 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…
Temp dbspace in RAM
Hi, Jonathan The server works as mix of OLTP and OLAP systems and there are many operations with temp dbspaces (I can see that) . So I'd like to try another technique to speed up 'temporary' actions.…
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: 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…
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: Solaris: temporary tables in /tmp VS in a temporary dbspace
Rupan3rd wrote: > Hi Gurus out there! > > Using IDS 10 on Sun Solaris 10. > > I have a question about Informix performance when using a dedicated temporary > dbspace (properly setup and declared in DBSPACETEMP in onconfig) versus using > the default location of temporary tables (…
Re: Solaris: temporary tables in /tmp VS in a temporary dbspace
/tmp is NOT memory in Solaris... it is SWAP space.. so if fill /tmp you are running out of swap space. It is a raw device (faster than a filesystem but slower than RAM... SWAP!!! Hope it helps...…
RE: need help - infformix is down - restart got index failed
"Sebastian, Norma J." <NormaJean.Sebastian@tellabs.com> wrote in message news:mailman.370.1164298908.29126.informix-list@iiug.org... >> The end of the oninit -v may give some clue. It says: Initializing DBSPACETEMP list Checking database partition index…
Re: Solaris: temporary tables in /tmp VS in a temporary dbspace
search for "IDS - Running temp dbspaces on RAMDISK" in this news group; ------------------------------------- ahum not supported... if you do decide to use it; make sure that you have a couple of real temdbspaces configured. if the machine reboots your ramdisk tempspaces are go…
Re: Solaris: temporary tables in /tmp VS in a temporary dbspace
Ehr... nobody have a clue? TIA R. Rupan3rd wrote: > Hi Gurus out there! > > Using IDS 10 on Sun Solaris 10. > > I have a question about Informix performance when using a dedicated > temporary > dbspace (properly setup and declared in DBSPACETEMP in onconfig) versus > using >…
Solaris: temporary tables in /tmp VS in a temporary dbspace
Hi Gurus out there! Using IDS 10 on Sun Solaris 10. I have a question about Informix performance when using a dedicated temporary dbspace (properly setup and declared in DBSPACETEMP in onconfig) versus using the default location of temporary tables ('/tmp', which on Solaris is …
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
Performance tuning suggestions needed
calyanram@hotmail.com wrote: > DBSPACETEMP prd2_sg_tmpdbs1,prd2_sg_tmpdbs2 # Default temp [snip] > dbspaces Kindly suggest me to perf tuning for the above. No idea without information Neil has requested but your syntax is wrong here: should be a colon not comma separated li…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
Re: estimate sort space for oncheck -cI
Floyd Wellershaus wrote: > Oh yea the Index is huge. I do have DBSPACETEMP set up to 3 different > temp dbspaces, but it seems some sorts MUST go to filesystem and will > not use DBSPACETEMP. > If you have PSORT_NPROCS set and PSORT_DBTEMP set then IDS will use those filesystems…
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: DBSPACETEMP
Howie What do you mean by random ?? It is possible to specify more than one dbspace in DBSPACETEMP and they can be a mixture of unlogged (marked as temp) and logged dbspaces. They will be used in a round-robin basis by the engine to allocate space for temp tables (each existing …
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
Help! I've dropped temp dbspace and can't recreate it
Beau Nanaz wrote: > IDS 10.0, Linux 2.4.21 64-bit > > Hi family. You may HAVE to bring the server down, remove the old dbspace from dbspacetemp and restart it, but try just re-setting DBSPACETEMP to a list that does NOT contain the dropped dbspace, or call the new one something …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Blade registration
is DBSPACETEMP set to anything? if not try setting it and try registering the balde again…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Cannot put online a restored database
Hi. We are probing a new machine (Sun E890) with IDS 9.40 FC7. One of the tests was perform an ontape to backup our data an then perform a restore. There's no abnormal messages in online.log, but when I tried to bring database to quiescent mode with oninit -sv I got the next: .…
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!…
PSORT_DBTEMP versus DBSPACETEMP
I know I have read postings in c.d.i which say to use DBSPACETEMP over PSORT_DBTEMP. Plus I read this in the manual: <begin snip> Important: It is recommended that you use the DBSPACETEMP parameter or the DBSPACETEMP environment variable for better performance of sort operations…
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.…
Re: Temporary dbspace
On Fri, 4 Nov 2005 14:53:44 -0000, "Doug Lawry" <lawry@nildram.co.uk> wrote: >Hi Malcolm. > >There is a "gotcha" here. I was involved with a single temp dbspace system (I >think you know which one!) which behaved differently if a second was added. To >illustrate, if you ran > > …
Re: Temporary dbspace
bozon wrote: > Temp tables with no log are fragmented across the temp dbspaces as are > other things (like sorting merge files, it seems like index builds and > group by's use a merge sort algorithm). So I think it is a benefit to > have more than one temp dbspace. I never though…
Re: Temporary dbspace
MWeallans@panacea.co.uk said: > > > > > > > Obnoxio said yes. Ok so what difference will it make? It will be faster. > > "Obnoxio The > Clown" To: > "mweallans@panacea.co.uk" <mweallans@panacea.co.uk> > …
Re: Temporary dbspace
mweallans@panacea.co.uk said: > > 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? Yes. -- Bye now, Obnoxi…
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…
Performance problems/System generated temp tables
Jeff wrote: > I've got an OLTP system that has developed poor performance. I > eventually tracked it down to excessive DBSPACETEMP I/O by monitoring > onstat -D. The pages read/written to the temp space far exceed the I/O > on our data spaces. > > It's been suggested in a previou…
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:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
RE: DBTEMP
For temporary files ids will use: PSORT_DBTEMP if not defined he will check DBSPACETEMP environment var, if not defined will check DBSPACETEMP in the ONCONFIG, if not defined will use /tmp. used for the following operations: ORDER BY/GROUP BY UNIQUE/DISTINCT, SORT-MERGE-Join, …
Re: DBTEMP
Dirk Moolman wrote: > I am trying to understand the environment variable DBTEMP better. I am > using DBSPACETEMP in my onconfig, but the DBA who created the system I > work on, also included DBTEMP in the user .profile Outdated. Not really used anymore, replaced with DBSPACETEM…
DBTEMP
I am trying to understand the environment variable DBTEMP better. I am using DBSPACETEMP in my onconfig, but the DBA who created the system I work on, also included DBTEMP in the user .profile I want to know what exactly gets written to the DBTEMP directory. I found the followi…
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…
RE: explicit TEMP table in rootdbs?
Temporary Tables ============= Temporary tables are always untyped tables. The following CREATE TABLE statement creates a temporary table: CREATE TEMP TABLE transient (col1 integer, col2 char(20)) After a temporary table is created, you can build indexes on the table. Howe…
RE: explicit TEMP table in rootdbs?
Temporary Tables ============= Temporary tables are always untyped tables. The following CREATE TABLE statement creates a temporary table: CREATE TEMP TABLE transient (col1 integer, col2 char(20)) After a temporary table is created, you can build indexes on the table. Howe…
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…
need to get sorts to use temp dbspaces
We are having sort files being created in the OS, when doing large order by's. According to the performance manual, if DBSPACETEMP is created correctly, these implicit sort files should be created in the temp dbspaces, unless PSORT_DBTEMP is set. I noticed one thing in the perfo…
Re: sysmaster slow
Floyd Wellershaus wrote: > --0-1611837224-1106318424=:47941 > Content-Type: text/plain; charset=us-ascii > > HI Art, > >>>Anyway, you can move the temp table IO's off root by adding one or more > > of the non-temp dbspaces to DBSPACETEMP. << > > I am not sure I know what you mean…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: Stripe and Mirror Everything?
On Thu, 16 Sep 2004 12:51:14 -0400, David E. Grove wrote: It'll reduce the IO overhead, but archives will still copy all those pages that were written and rewritten to the tapes. TEMPDB spaces are not archived! Art S. Kagel > "Claus Samuelsen" <csa@eye-bee-em.com> wrote in me…
Re: Stripe and Mirror Everything?
"Claus Samuelsen" <csa@eye-bee-em.com> wrote in message news:41494202$0$212$14726298@news.sunsite.dk... > > I would certainly consider two dbspaces - the root dbspace and a > temporary dbspace. In a logged database transaction record writing > (which is typically the most io inte…
IDS 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: DBSPACETEMP Variable [3248]
Keith I believe that it is new in V9. I have found references in V9.2 and V9.4 documentation to the same statement regarding the use of raw disk for dbspaces listed in DBSPACETEMP. See http://publib.boulder.ibm.com/epubs/pdf/ct1syna.pdf page 63 (1-31). Regards David Linthwai…
RE: DBSPACETEMP Variable [3248]
David Is this something new in 9.? (4 ??). I can find no reference to it in my 7.3 manuals and it doesn't 'feel' right as follows:- If DBSPACETEMP is not set the engine will use root dbspace for all its temporary tables/sort files. Suppose this is on cooked space, will the engin…
RE: DBSPACETEMP Variable [3248]
Keith The following is an extract from the administrators reference manual: ".....The list of dbspaces can contain standard dbspaces, temporary dbspaces, or both. Use a colon or comma to separate the dbspaces in your list. If both standard and temporary dbspaces are listed in t…
RE: DBSPACETEMP Variable [3248]
See Below -> -----Original Message----- -> From: David Linthwaite [mailto:dlinthwaite@lintel.co.uk] -> Sent: Thursday, July 15, 2004 4:37 PM -> To: informix-list@iiug.org -> Subject: RE: DBSPACETEMP Variable [3248] -> -> -> Anthony -> -> A few things to check: -> -> 1. The envir…
RE: DBSPACETEMP Variable [3248]
Anthony A few things to check: 1. The environment variable takes priority over the 'onconfig' setting. Perhaps unset the environment variable in case it is being picked up incorrectly. 2. onstat -c reads from the configuration file on disk and is therefore not necessarily what…
DBSPACETEMP Variable
I'm running into a situation where temporary tables created by "SELECT ..... INTO TEMP tmptablename" are using space from the root dbspace instead of our temp dbspace. Both the onconfig and environment DBSPACETEMP variables are set to the temp dbspace that is flagged as temporary…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
RE: High LRU writes on temporary dbspace
Run this sql against the sysmaster database. It should give you some clue as to who is creating the temp tables. SELECT d.name[1,5] dbspace , trim(n.dbsname) || ":" || trim(n.owner) || ":" || trim(n.tabname) table , i.ti_nptotal allocated_pages FROM systabnames n …
High LRU writes on temporary dbspace
Hi! Let me ask... This is small system on IDS 7.31. It was 190'000 pages writed in temp dbspace less than 1 hour on LRU writes. What can be a type of this pages? Neither permanent tables data pages no temp tables data pages... Indexes? - it is OLTP system with less then 1000 tr…
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?…
IDS 9.30 consumes too much temp dbspace
There is a bug in 9.30.UC3 where the temporary dbspace on the secondary server in a HDR pair is not released after use. Can be worked around by bouncing the secondary. I believe this is fixed, certainly in 9.40.UC3. Crystal Reports can also be very inefficient as many if not all…
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…
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,…
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: Location of temp tables
In IDS 7.3, Temp tables will use the DBSPACETEMP in the following way: Create Temp Table with no log --> Temporary DBSpace from DBSPACETEMP Create Temp Table --> normal DBSpace from DBSPACETEMP (or dbspace of current database, if a normal dbspace is not specified) Select...…
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 …
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
What is in my dbspace
Try oncheck -pe. This will report the contents of all dbspaces/chunks.…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
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…
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…
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…
Dbspaces access
Hi All, Does anyone know how to obtain a report of a dbspaces more accesed, read / write, by sap or informix I really need this information, thanks in advance!! Luis Arturo López Caballero Proyecto ASARE - Modulo Base Mexico D.F. Tel. 01(55)52294400 Ext. 85705…
delete down dbspace
Hi, I have a down dbspace, I am not able to do anything with it, there is no needed data inside, how I am able to delete this dbspace. (the dbspace has one chunk). Thanks Sven…
DBSPACETEMP
Hi All, I´ve got 2 qeustions: 1) are there known problems between tempdbspace and Informix 7.31? 2) what happens if i set DBSPACETEMP in onconfig to other dbspaces and NOT to a tempdbspace? Thanks in advance, Alex…
Re: Growing dbspace
On Fri, 19 Jan 2001 app@not.allowed wrote: > Dear Informix experts, > > I have problem with my dbspace that suddenly growing in size . Within one > night it grows by almost 40,000 pages where in normal case should be > between 1000 - 2000 pages daily. > Do you think because of t…
question on how to list tables in a DBSPACE?
Hi, Does anyone have some type of scripts that list All DBSPACE for an Informixserver, and all tables in each DBSPACE + how much bytes they take? Thanks!…
Re: temporary space - doesn't scale?
> What is the value of DBSPACETEMP? Sorry. Here it is: DBSPACETEMP tempdbs # Default temp dbspaces tempdbs was created using: onspaces -c -d tempdbs -t -p ~informix/links/chunk2 -o 0 -s 2000000 matt…
RE: DBSPACETEMP Problem.
Have you tried editing the onconfig file. Make sure that you do not have spaces between the two tmpdbspaces . It should : tmpdsb1,tmpdbs2 Niraj -----Original Message----- From: Steven Mastandrea [mailto:stevem@cstech.com] Sent: Tuesday, December 12, 2000 9:24 PM To: informix-li…
DBSPACETEMP Problem.
To my understanding you should be in a logged database. If this is the case use the following sintax if you want your temp tables to be created in your temp dbspace(s): (1) select * from orders into temp duh with no log (2) create temp table (col1 int, ...) with no log Otherwis…
DBSPACETEMP Problem.
I am having a problem with Informix Dynamic Server Version 7.31.UC2 on a Solaris 2.6 machine. I have created 2 1g temporary chunks called temp1 and temp2, whose onstat profile is listed below: c296e50 3 2001 3 1 N T informix temp1 c296f10 4 …
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Dropping Temporary Dbspaces
Thanks, Mark! I went ahead and built the instance without the tempdbs. I'll migrate the tempdbs chunk later in the week when I have the planned downtime. Best regards, Edmund Nigel Gall <-- Making IT happen! --> Senior Information Systems Specialist Process Plant Services Limi…
Re: Dropping Temporary Dbspaces
Nigel Gall wrote: > > Hi! Can I drop a temporary dbspace without re-initializing the instance? > > In reviewing the manual for IDS 7.3, on page 14-19 it states that one should > run oncheck -pe to examine if any logs or tables reside in the dbspace > before removing. When I run…
Dropping Temporary Dbspaces
Hi! Can I drop a temporary dbspace without re-initializing the instance? In reviewing the manual for IDS 7.3, on page 14-19 it states that one should run oncheck -pe to examine if any logs or tables reside in the dbspace before removing. When I run it, I get the following for …
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…
Novice Question about DBSPACETEMP
The environment variable, if set, will override the DBSPACETEMP onconfig parameter for that session. Otherwise, the onconfig parameter will be honored. What's tricky is -- if the database has logging, you need to use the "with no log" clause with your sql statements for it to …
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…
Force dropping a dbspace
I have a temporary dbspace I'm trying to blow away, and I can't seem to do it with 'onspaces -d tempdbs' because it claims the space is not empty. I checked the contents of the dbspace with 'oncheck -pe' and all it showed to be in the dbspace was a series of tblspace tblspace's …
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…
Why is rootdbs busy?
According to onstat -g iof, rootdbs appears to be the busiest chunk in the system with 10 times more dskwrite than any other chunk. The performance guide states that "When you do not specify dbspaces in the DBSPACETEMP parameter or the client DBSPACETEMP environment variable, Dyn…
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…
DBSPACETEMP/tmp
There is a comment in the onconfig.std as shipped with IDS 9.20, saying that: "... If specified it must be a colon separated list of dbspaces that exist when the DS system is brought online. If not specified, or if all dbspaces specfied are invalid, various ad hoc queries will c…
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…
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…
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…
Re: tmp space problem
From: "cdlvj" <ljanda@checkstop.com> > >What is the environment variable to move the work space from /tmp as my >create index are failing. > >I thought it was DBTEMP, but that does not work. PSORT_DBTEMP or DBSPACETEMP -- the former for filesystem, the latter for dbspaces... ___…
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
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…
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. …
DBSPACETEMP (<<< sigh >>>)
We are experiencing some strange behaviour regarding our use of the $ONCONFIG/UNIX Environment parameter DBSPACETEMP. I have followed earlier discussions with interest (thanks, Art, for your succinct "pecking order" clarification), but am still surprised at the results we are fi…
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Re: DBSPACETEMP and Raw DIsk
From: Eric The Half A Bee <glynb@my-deja.com> > >Could somebody out there confirm that it's ok to create temporary >dbspaces referenced within the DBSPACETEMP section of $ONCONFIG if the >system is utilising raw disk. I seem to recall recently seeing a Yes. >comment that DBSPAC…
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
DBSPACETEMP and Raw DIsk
Could somebody out there confirm that it's ok to create temporary dbspaces referenced within the DBSPACETEMP section of $ONCONFIG if the system is utilising raw disk. I seem to recall recently seeing a comment that DBSPACETEMP only applied to cooked disk but am finding this hard …
Role of DBSPACETEMP (II)
Henk van der Geld wrote: > If I create a temp table and DO NOT specify the WITH NO > LOG option, the temp table will ALWAYS be created in the root dbspace, > even if I specify DBSPACETEMP=tempdbs in my environment. BUGS FIXED IN THE 7.31.TC5 RELEASE 116590 TEMP TABLES WITH L…
Remote SQL socket query
Hi, DBSPACETEMP is also an environment variable. Environment variables will be evaluated when you initialize your connection. If you would run the query in a seperate process it will be possible to modify the DBSPACETEMP environment variable before you start the query. Regards,…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
Re: Role of DBSPACETEMP
---- you wrote: > Hi, > > We have some questions about of the role and the effect of the envvar > DBSPACETEMP. Sometimes I read that in databases that are logged, > temporary tables are logged by default and WILL NOT BE CREATED IN > 'DBSPACETEMP'. In that case it is necessary to…
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
Role of DBSPACETEMP
Hi, We have some questions about of the role and the effect of the envvar DBSPACETEMP. Sometimes I read that in databases that are logged, temporary tables are logged by default and WILL NOT BE CREATED IN 'DBSPACETEMP'. In that case it is necessary to use the WITH NO LOG option …
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: ROWIDs and fragmented temporary tables
"Henderson, Scott" wrote: > > Is there a quick fix? No. > Yep. We have started changing the code that use rowid's on temporary tables. > Your problem has nothing to do with temp dbspaces. I don't agree. In this case the problem is indeed in using more than one temporary dbspac…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Re: ROWIDs and fragmented temporary tables
<com@netinfo-moldova.com> wrote in message news:80ogam$kaj$1@nnrp1.deja.com... You must create your tables as CREATE TABLE ... WITH ROWIDS. By default fragmented tables don't have rowid column. ------------------------------------------------- With best regards, Yuri Dovgart SA…
ROWIDs and fragmented temporary tables
Hello, I have a question regarding ROWIDs on fragmented temporary tables. I've just installed and configured an Informix server (7.30) and I configured it to use three temporary dbspace. I've got a surprise discovering that some of applications use rowid columns on temporary tab…
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…
error message - unable to open input file 's'
"Weimer, John - CHARLOTTE" wrote: > I am getting these error messages with "oninit -y", any ideas.... > thanks in advance... john > Informix Dynamic Server Version 7.31.UC2 > DataGeneral 3650 UX > ... > Initializing log/checkpoint …
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…
Problems with DBSPACETEMP
Hi, we have IDS 7.30.UC8 running here on a Sun Solaris 2.6 box. We've encountered a problem with DBSPACETEMP: we've set this parameter to dbs1:dbs2 (and we tried also dbs1,dbs2) in the onconfig file. After starting a big print job IDS claims temporary space to collect the data. B…
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…
Backups terminated by client
In article <7rupae$eau1@www.informix.com>, "Peter Komanns" <p.komanns@sindata.it> wrote: >The fact is that when you run ontape -s all changes in the database are >recorded in the current temporary dbspace; ontape uses the temporary >dbspace, too. If that dbspace fills out, ontape…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
which tables are in a specific dbspace?
Hello! How can I get, which tables are in a specific dbspace? thanks Gabor…
dbspaces on NT
Hello, somewhere I read :-)) that IX DBSPACE is limited to 2GB and NTFS to 4GB. I have 10GB HDD for Informix only (IDSWE 7.30) and PII server. Exists better solution than 5x 2GB NTFS? Thanks Leos…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
altering DBSpaces
I will be adding some chunks to a BLOB space this evening. In the past I had been told by Informix to run an oncheck command after changing DBSpaces but I cannot recall what flags for oncheck. Can anyone help me out?…
Sizing DBSPACETEMP
Any one have any suggestions on sizing the database temp spaces? What option for onstat or Unix command do you use to monitor db temp space? thanks in advance!! Val Valerie H. Webber Valerie.H.Webber@m1.irs.gov 704-569-1002 x107…
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.…
Ontape --- out of disk space
I am getting an error from our ontape level 0 backups. The error message reads "ISAM error --- no free disk space". During the backups, there is quite a bit of database activity (inserts, deletes, updates). I believe that this error is caused by ontape having to preserve chang…
# 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…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
Contentets of a chunk
> > We use DBSPACETEMP=temp different of root dbspace. > > We have a problem with a chunk in root dbspace. Sometimes it grows When you are using SELECT INTO TEMP WITH NO LOG - this goes to the tempdbspace, but when SELECT INTO TEMP - this goes to the root dbspace. In other words…
dbspace sizes
I am configuring a 7.3 IDS engine on a SUN box. I configured a 4 GB volume on 1 disk. I created a dbspace on the volume with the first chunk at offset 0 and a size of 2 GB (approximately). I try to add a second chunk, with an offset of 2GB and a size of 2GB but Informix won't …
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
dbspacetemp / lock mode / ontape
Hello, i have some questions about dbspacetemp under WINNT 1) How can I set the DBSPACETEMP environment variable for every session constantly. In the File "setenv.cmd" ? 2) Do I have to set the environment variable in the "setenv.cmd" and (!) the configuration paramete…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
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…
Re: dbspaces for Temporary tables
Jay Walters wrote: > > I am running IDS 7.3 on NT sp 3 24x7 web OLTP environment. Do people > use onspace -t type dbspaces in this environment (no mirroring?), > regular dbspaces, or filesystem (no mirroring on NT Wks) for their temp > tables. I don't have a lot of disk spindle…
dbspaces for Temporary tables
I am running IDS 7.3 on NT sp 3 24x7 web OLTP environment. Do people use onspace -t type dbspaces in this environment (no mirroring?), regular dbspaces, or filesystem (no mirroring on NT Wks) for their temp tables. I don't have a lot of disk spindles to play with either unfortu…
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 ?…
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.…
RE: Create index very slow
[cutting] > > > >DBSPACETEMP itemp:temp2 > > I'd go for at least 3. Ideally on different disks and controllers [cutting] Paul Watson # WF Software Ltd # Any answer given Tel: +44 1463 674729 # could be totally Fax: +44 1463 678729 # fictitious www…
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 …
Re: Informix 7.24 Temp Tables Not Dropping
jeffm@lysander.co.uk wrote: > > In article <7d74rd$hrt$2@news-1.news.gte.net>, > June Tong <june_t@hotmail.com> wrote: > > jeffm@lysander.co.uk wrote: > > > > > I have a system running IDS 7.24 on HP-UX 10.20. Some software is creating > > > temporary tables using 'SELECT...IN…
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…
DBSPACETEMP question
Hi, I'm sure I've seen this mentioned before but I can't find the thread now :o( I set up DBSPACETEMP in my onconfig to be a list of five dbspaces on five different disks. All of the dbspaces are marked as temporary. Reading through my online administration course …
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…
Informix 7.24 Temp Tables Not Dropping
June Tong wrote in message <7d74rd$hrt$2@news-1.news.gte.net>... [snip] >I don't know what the manuals say (don't actually have any, anymore, and can't >be bothered trying to open up the PDF files), but it's important to distinguish >between temporary dbspaces and DBSPACETEMP. D…
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…
Re: DBSPACETEMP & PSORT_DBTEMP
Create a dbspace called tempdbs that is set up as temporary. Then set your DBSPACETEMP variable to it. You can have the tempdbs use the /sort2 directory, but the DBSPACETEMP=tempdbs is what needs to be in the environment settings. To: informix-list @ iiug.org cc: (bcc: Ka…
Re: DBSPACETEMP & PSORT_DBTEMP
John Coyle wrote: > > Hi everyone, > > I have not set DBSPACETEMP within my onconfig file > because I have chosen to use environment variables to > point to other locations. According to both the > Administrator's Guide (page 14-27) and the Performance > Guide (page 2-39), if th…
DBSPACETEMP & PSORT_DBTEMP
Hi everyone, I have not set DBSPACETEMP within my onconfig file because I have chosen to use environment variables to point to other locations. According to both the Administrator's Guide (page 14-27) and the Performance Guide (page 2-39), if the environment variables are set t…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
question about temp file error
In article <36B8D538.53FE@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Yan Zhu wrote: >> >> hi all: >> I am running online 7.22 on solaris 2.6. I ran a sql which suppose >> to group and sort on 10 different fields. I ran it, and it came back >> with the followin…
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…
Tables in dbspacetemp
Does anyone here know of a way to identify what tables are in any given temporary dbspace? I have looked into some of the systables, but wasn't able to see anything that jumped out at me. I contacted Informix Tech support, but the engineer I got didn't know of any script or code…
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.…
Re: temporary tables and informix hang
Des wrote: > > Our users recently reported that their informix system (7.?) was having > problems. A transaction had hung. They reported messages to the effect > that /tmp was full. This was where they were creating temp tables. /tmp > itself still appeared to be 40 % free. They …
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
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 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: DBSPACETEMP problem
michaelaadams@my-dejanews.com wrote: > > In article <707bk6$m86$1@news.xmission.com>, > ipons@dtgna.altanet.org (Pons Roca, Isidre) wrote: > > When any user execute "create temp table a (a char(80))" the > > temp table was create at rootdbs. (?�) > > > > The Online system…
Re: DBSPACETEMP problem
In article <707bk6$m86$1@news.xmission.com>, ipons@dtgna.altanet.org (Pons Roca, Isidre) wrote: > When any user execute "create temp table a (a char(80))" the > temp table was create at rootdbs. (?�) > > The Online system has defined a DBSPACE temp. > The user have def…
Re: DBSPACETEMP problem
In article <707bk6$m86$1@news.xmission.com>, ipons@dtgna.altanet.org (Pons Roca, Isidre) wrote: > When any user execute "create temp table a (a char(80))" the > temp table was create at rootdbs. (?�) > > The Online system has defined a DBSPACE temp. > The user have def…
AW: DBSPACETEMP problem
I think, the user must create his tables like this: create temp table xxx(x char(99)) in tempdbs with no log; (if tempdbs is your defined dbspace for Temp) Normally online creates all tables in rootdbs. I think, this is the point. bye Andy M. Bettin > ---------- > Von: i…
Re: DBSPACETEMP problem
Hola Isidre, Yes, everything you described is normal behavior. If you want the temp table to be created in the DBSPACETEMP setting then you have to use the WITH NO LOG clause when creating explicit temporary tables with CREATE TEMP TABLE ... or SELECT ... INTO TEMP ... . Hope t…
DBSPACETEMP problem
Hi all. Can any one help my? I've detectec de next problem (is'nt a heavy problem, but is very tedious): When any user execute "create temp table a (a char(80))" the temp table was create at rootdbs. (?�) The Online system has defined a DBSPACE temp. The user have de…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
Engine not using DBSPACETEMP in onconfig.pro
This is a multi-part message in MIME format. ------=_NextPart_000_001C_01BDF608.9F827460 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am running Informix OnLine Version 7.24.FC5 and having a problem with = it using the root space…
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…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
Re: DBSPACETEMP problem
peter_young@my-dejanews.com wrote: > > We have a problem with temp tables in our setup. We are getting invalid > dbspace in out log file(see out output below). Our DBSPACETEMP is set to the > following > > DBSPACETEMP tempdbs # Default temp dbspaces > > in the onconfi…
DBSPACETEMP problem
We have a problem with temp tables in our setup. We are getting invalid dbspace in out log file(see out output below). Our DBSPACETEMP is set to the following DBSPACETEMP tempdbs # Default temp dbspaces in the onconfig and the environment variable (DBSPACETEMP) also…
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 …
DBSPACETEMP
Does anyone have or know of any script, tools, sql, etc., that will monitor the entire temp space of a DSA instance. ?? In other words, display all the temp tables and processes that using the dbspace defined as the DBSPACETEMP. ?? Thanks for you help.. Tim…
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…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
Re: Temporary Space Issue
In article <01bd9a08$c42fe150$57011814@willie>, Willie L. Meeks <wmeeks@harrahs.com> writes >Greetings all, > >I have a problem related to temporary dbspace usage. It is a known bug in >7.14 related to temporary spaces not rolling i.e.( When a query attaches to >a temporary spac…
Re: Temporary Space Issue
Willie L. Meeks wrote: > > Greetings all, > > I have a problem related to temporary dbspace usage. It is a known bug in > 7.14 related to temporary spaces not rolling i.e.( When a query attaches to > a temporary space it will not roll to the next temporary space). I know you do…
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…
Temporary Space Issue
Greetings all, I have a problem related to temporary dbspace usage. It is a known bug in 7.14 related to temporary spaces not rolling i.e.( When a query attaches to a temporary space it will not roll to the next temporary space). Example currently I have 11 temporary dbspace d…
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…
Re: Temporary dbspaces
Jonathan Myatt wrote: > > A quick question for the gurus... > > If I have four temporary dbspaces defined, will a large sort which > creates a large temporary table use all four, or can the temp table > not "span" dbspaces? Would I be better off consolidating the available > spac…
Re: Temporary dbspaces
In article <3576713C.79705C38@jonners.cix.co.uk>, Jonathan Myatt <jon@jonners.cix.co.uk> wrote: > > A quick question for the gurus... > > If I have four temporary dbspaces defined, will a large sort which > creates a large temporary table use all four, or can the temp table > n…
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: +…
Bad performance with DBSPACETMP enabled
I'm currently using OnLine 7.23 on a HP K460 server. I have one big table (appr. 1 GB) for which we do an "UPDATE STATISTICS HIGH" on a regular basis. When using 3 temporary dbspaces on raw devices, the running time for this task is about 2 hours. If I dont't use temporary dbsp…
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…
Wierdness Again
As a follow on to my last mail, the DBSPACETEMP problem seems to have miracurously cleared up. I can only think that this was some sort of bizarre side effect of our logical logging problems. Thanks again for the help everybody. Regards Lee Robertson…
Re: [Fwd: Correct Answer]
Hi, Below is the excerpt from INFORMIX Dynamic Server Administration: When you create an explicit temporary table using the IN dbspace option of CREATE TEMP TABLE, OnLine stores the temporary table in that dbspace. When you do not use the IN dbspace option of CREATE TEMP TABLE, o…
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.…
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
Re: 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…
Re: DBTEMP
Bill Weaver wrote: > > You basically reiterated both my point and my question. I HAVE DBSPACETEMP set > in the onconfig file (I didn't have the environment variable DBSPACETEMP set > however, only in onconfig)! The engine IS using the temp spaces defined by > DBSPACETEMP. Howe…
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…
Re: onstat -d,onstat -D
I believe 1001 indicates that the dbspace is a blobspace. I know that 2001 indicates that the space is a temporary dbspace. "Tony_Reynolds(Accounting & Purchasing System") wrote in message <67972r$caj@cssun.mathcs.emory.edu>... >Can anyone tell me the difference between a dbspa…
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…
Re: dbimport filling up /tmp?
Mark Collins wrote: | ||Q1. Does dbimport fill up /tmp with all kindsa stuff? | |You say you set env. var. DBTEMP to try to get the temp tables created |in /var/tmp, but my copy of the DSA Performance Guide says: | | When you do not specify a location with the DBSPACETEMP | …
Re: NON-EMPTY TEMPORARY DBSPACE. Can we upgrade with this non-e
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > > Hi all, > This actually refers to a previous chain of e-mail regarding the "Contents > of TEMPDBS", where we had a problem of a non-empty temporary dbspace ( with > non-empty chunks ) We finally found out the bu…
NON-EMPTY TEMPORARY DBSPACE. Can we upgrade with this non-e
Hi all, This actually refers to a previous chain of e-mail regarding the "Contents of TEMPDBS", where we had a problem of a non-empty temporary dbspace ( with non-empty chunks ) We finally found out the bug # 61442, had INFORMIX dial in and reset the chunk. Now this was our d…
RE: Question on the contents of tempdbs
This is a known bug. What you need to do is contact Informix support and have them dial in and drop the temporary DBspace for you. Also, since this type of fix has to be unsupported you will need to have a full backup before getting them to dial in :) Cheers, Tony.…
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: ISAM error: no free disk space
Steve Levis wrote: > > Folks, > I am running a ESQL/C query on a 50MB database and getting > the following error messages. > > # 229: Could not open or create a temporary file. > # 131: ISAM error: no free disk space > > There is over 200MB free in /tmp and more that 1GB in t…
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…
Error 179 - any ideas??
I set up a test instance on a server, with a copy of our production database, for testing. I kept BUFFERS very small - 500 I think. The server application failed with 179 errors (no more sort space). This suggests a problem with DBSPACETEMP. It's certainly true that my settin…
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: PSORT_DBTEMP and DBSPACETEMP
In article <5p4p7e$bil$1@picasso.op.net>, root@candle.pha.pa.us writes >I am working on optimizing postgrSQL's psort function >(www.postgresql.org), and found it curious that postgreSQL uses the same >name, psort, for that piece of code as Informix. > >Do they come from a common …
Re: PSORT_DBTEMP and DBSPACETEMP
ibogorad@lhr-sys.dhl.com wrote: : In article : <B5EA844F2DE58DEB.0A67072B0CAC1F49.38844D7C19E18CCC@library-proxy.airnews.net>, : Hari says... : > : >Hi, : > : > I am working on INFORMIX ONLINE Dynamic Server. I have come across a : >problem where when I do a sort using Sequenti…
Re: PSORT_DBTEMP and DBSPACETEMP
Hari Muthuswamy wrote: > > I am working on INFORMIX ONLINE Dynamic Server. I have come across a > problem where when I do a sort using Sequential Scan it blows up during > the weekends and sometimes during night time. ( SQL ERR:567 ISAM > ERR:28). This means the disk is full.…
Re: PSORT_DBTEMP and DBSPACETEMP
In article <B5EA844F2DE58DEB.0A67072B0CAC1F49.38844D7C19E18CCC@library-proxy.airnews.net>, Hari says... > >Hi, > > I am working on INFORMIX ONLINE Dynamic Server. I have come across a >problem where when I do a sort using Sequential Scan it blows up during >the weekends and som…
PSORT_DBTEMP and DBSPACETEMP
Hi, I am working on INFORMIX ONLINE Dynamic Server. I have come across a problem where when I do a sort using Sequential Scan it blows up during the weekends and sometimes during night time. ( SQL ERR:567 ISAM ERR:28). The PSORT_DBTEMP is pointing to the logical logs dire…
Re: SELECT DISTINCT(columname) and TEMP dbs
In article <5lfn8b$42k@cssun.mathcs.emory.edu>, Jeff Craig <settler@emor y.mathcs.emory.edu> writes > >I am trying to execute a simple query such as: >SELECT DISTINCT(columnname) > FROM ANYTABLE >; > >There are approximately 40 million rows in ANYTABLE. The query runs >forever, …
SELECT DISTINCT(columname) and TEMP dbs
I am trying to execute a simple query such as: SELECT DISTINCT(columnname) FROM ANYTABLE ; There are approximately 40 million rows in ANYTABLE. The query runs forever, and the only activity I can see is major temporary dbspace reads and writes. I have tried forcing a light sca…
Re: backups
In article <336BEBBC.2B80@hal-pc.org>, Daniel Walker <dwalker@hal- pc.org> writes > >Customer is running ontape -s l 0 on HP/UX 10.2 using 7.2 informix. They >say they are getting errors from backup that there is not enough >temporary table space.??? I have not heard of any requi…
Where is dbspace?
On a raw disk(instance product) I created a database test. On other instance(training) on the same raw disk and fisical area other database with thehe same name was created. I deleted the second database and dbspace but on the first instance I can't access, drop the database tes…
Re: Replication 7.11
David Williams wrote: > > Try tbstat -c to get the current configuration on the seconary BEFORE > ontape -p and check it matches the primary configuration with only > the root dbspace and temporary dbspaces including (dbspace has a > T against in in onmonitor). > > Some…
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…
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 …
Temp Table/dbspace problem
I am having a problem with an Informix application. The DBSpace that the application uses gets filled seemingly when large queries are performed. After the error occurs we have examined the DBSpace via TBMonitor and it is full. However when we add the sizes of all the tables re…
Re: Incompetence!
I don't know exactly what the problem you encountered is since you did not describe the error code that you received. However, I'm going to take a guess that you might have run out of space in the dbspace that the temporary table was being created in. Try creating a dbspace for…
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…
Re: "bad primary chunk" with temporary dbspace
We have been experiencing similar problems under 7.12 and have corrected them by modifying the actual dbspace name within the roodbs. Determine if your dbspace name is bad by doing the following: do an 'oncheck -pP 1 4 | pg' . This will dump the page for chunck 1 ( where rootd…
Re: "bad primary chunk" with temporary dbspace
We have been experiencing similar problems under 7.12 and have corrected them by modifying the actual dbspace name within the roodbs. Determine if your dbspace name is bad by doing the following: do an 'oncheck -pP 1 4 | pg' . This will dump the page for chunck 1 ( where rootd…
Re: "bad primary chunk" with temporary dbspace
Neil, I too have experienced this when restoring my 7.X engines. Informix also informed me that it was a bug that is "supposedly" fixed in later 7.1X releases. What I've had to do is: Since all of my path's in Informix are symbolic links, I just created another symbolic link …
Re: "bad primary chunk" with temporary dbspace
In article <3298581B.6D5A@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >I'm running OnLine v7.13 on a Sun Sparc20; Solaris 2.4. I've had to >restore my instance to a dump. When i bring up OnLine I see the console >message Bad primary chunk '/dev/rdsk/informix_1', …
"bad primary chunk" with temporary dbspace
I'm running OnLine v7.13 on a Sun Sparc20; Solaris 2.4. I've had to restore my instance to a dump. When i bring up OnLine I see the console message Bad primary chunk '/dev/rdsk/informix_1', although this doesn't appear in the OnLine log. The log does show that my tempbds is in…
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…
Re: Misunderstood DBSPACETEMP ?
David Williams wrote: > > This is odd - Check Informix Online Dynamic Server > Admin. Guide, Volume 2 Version 7.1 Page 38-18. > > "The DBSPACETEMP configuration paramaters is a list of dbspaces used > to globally manager the storage of temporary tables" > > "If bot…
Re: Misunderstood DBSPACETEMP ?
Stefan Weideneder <stefan@www.weideneder.de> wrote: >Hi folks, >has anyone some experience with DBSPACETEMP ? Starting with version >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests >with temporary tables. Now I wonder, if I was wrong. >My problem: >I create …
RE: Misunderstood DBSPACETEMP ?
} } >Hi folks, } } >has anyone some experience with DBSPACETEMP ? Starting with version } >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests } >with temporary tables. Now I wonder, if I was wrong. } } >My problem: } } >I create two dbspaces, dbs1 ( a regular one )…
RE: Misunderstood DBSPACETEMP ?
>Hi folks, >has anyone some experience with DBSPACETEMP ? Starting with version >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests >with temporary tables. Now I wonder, if I was wrong. >My problem: >I create two dbspaces, dbs1 ( a regular one ) and tempdbs1 ( a…
Re: Misunderstood DBSPACETEMP ?
David Williams <djw@smooth1.demon.co.uk> wrote: > This is odd - Check Informix Online Dynamic Server > Admin. Guide, Volume 2 Version 7.1 Page 38-18. > "The DBSPACETEMP configuration paramaters is a list of dbspaces used > to globally manager the storage of temporary table…
Re: Misunderstood DBSPACETEMP ?
Stefan Weideneder wrote: > > has anyone some experience with DBSPACETEMP ? Starting with version > 7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests > with temporary tables. Now I wonder, if I was wrong. > > My problem: > I create two dbspaces, dbs1 ( a regular …
RE: Misunderstood DBSPACETEMP ?
Stefan As I understand it, DBSPACETEMP is an onconfig configuration parameter. = Setting it from the environment should have no effect. The application = will create the temp table in the default dbspace or where the database = was created. In the onconfig file, you need to set…
Re: Misunderstood DBSPACETEMP ?
Stefan Weideneder <stefan@www.weideneder.de> wrote: >Hi folks, >has anyone some experience with DBSPACETEMP ? Starting with version >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests >with temporary tables. Now I wonder, if I was wrong. >My problem: >I create …
Re: Misunderstood DBSPACETEMP ?
Hi Stefan, If you set DBSPACETEMP in the ONCONFIG file or in the environment OnLine stores temporary tables in one of the listed Dbspaces. Note that the Environment DBSPACETEMP overwrites the ONCONFIG value. Your DBSPACETEMP list contains the Dbspace dbs1 and so OnLine can stor…
Re: Misunderstood DBSPACETEMP ?
In article <325A9392.1C99C17C@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >Hi folks, > >has anyone some experience with DBSPACETEMP ? Starting with version >7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests >with temporary tables. Now I…
Misunderstood DBSPACETEMP ?
Hi folks, has anyone some experience with DBSPACETEMP ? Starting with version 7.0 ( an inofficial version ) until 7.12UC1 I've made a few tests with temporary tables. Now I wonder, if I was wrong. My problem: I create two dbspaces, dbs1 ( a regular one ) and tempdbs1 ( a dbspa…
Re: Help restoring a dbspace with Online 7.12
Phuoc Ho wrote: > > I get a segmentation fault (core dump) everytime I try to > restore a dbspace with: > > ontape -r -D dbspacename > > I can do full database backups and restore. Informix Support can't > seems to trace the problem. > > I am using Online 7.12 on HP unix 9.x > >…
Temp tables not getting removed
Greetings, I am working on an HP-UX 10.01 system running On-Line 7.13.UC1 the the ESQL/C and ISQL packages installed. Lately, I've noticed a problem with temp tables not getting cleaned up. Initially I had DBSPACETEMP defined as the same dbspace as my root dbspace. After runn…
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…
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)…
Re: Temporary dbspace
I found out the DBTEMP should not be set at all. This is nologer used with the 7.x DSA online engines. ------------------------------------------------------------------------- Cheryl Kendricks Internet: cherylk@spamis.jcdc.doleta.gov OR chery…
Re: Temporary dbspace
cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) wrote: >Do you mean that if I create a dbspace and do not denote it as a temp >dbspace, yet include it in my DBSPACETEMP in my profile and configuration >the engine does not realize this as a TEMP DB space? There are 3 places to >…
Re: Temporary dbspace
Do you mean that if I create a dbspace and do not denote it as a temp dbspace, yet include it in my DBSPACETEMP in my profile and configuration the engine does not realize this as a TEMP DB space? There are 3 places to identify temp db space: On UNIX w/ AIX in the user's .prof…
Re: Temporary dbspace
pfinkel@cbnews.cb.att.com (paul.d.finkel) wrote: >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 c…
Re: Temporary dbspace
paul.d.finkel wrote: > > 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 re…
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: Temporary questions
>1. How can I get info in which dbspace a table was created ? oncheck -pt or oncheck -pe >2. How can I get list of tables created in one dbspace ? oncheck -pe >3. Where (dbspace) are explicit temporary tables created ? In your DBSPACETEMP. HTH. -- Cheers, Billy. --------…
Temporary questions
Dear all, could anybody answer the following questions, please. 1. How can I get info in which dbspace a table was created ? 2. How can I get list of tables created in one dbspace ? 3. Where (dbspace) are explicit temporary tables created ? If I have set the enviroment vari…
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-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
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...…
Alter table.
Hi, Is there anyway i can add a new column to a table without the temporary table being created? The problem i have is that i don't have enough dbspace left, but the table has millions of rows, how can i add a new column to the table without running out of dbspace? If anybody h…
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…
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…