Oninit® Archive
Results for “onstat -f”
Not enough room in ROOT DBspace
Hi Jack, thanks for your response. I already created physical and logical log dbspaces, moved the physical log to that dbspaces and created the rest of the logical logs in the other dbspace. But I was wondering why the first dbspaces is the ROOTNAME Thanks…
script to check status of dbspaces & chunks
Hi All, I need to write a shell script to check the status of all dbspaces & all chunks of an instance & send an email if any of dbspaces/chunks got corrupted/dropped/inconsistent etc Can any body help me in this regards? Regards…
New installation on SUSE Linux
Here is my sqlhosts file: ksotinfx01 onsoctcp ksotinfx01 istartrain2 ksotinfx01_shm onipcshm ksotinfx01 ksotinfx01 istartrain onsoctcp ksotinfx01 istartrain I'm confused by the istartrain2 in the first line, but I am copying another config file over from our production server, …
Resync RSS server
Hello I need to re-initiate synchronization between a primary server and the RSS. They re currently connected, active prim :/prod/dbown>onstat -g cluster ... Server ACKed Log Applied Log Supports Status (log, page) (log, page) Updates ids_tlv_rss 0,0 0,0 No ASYNC(RSS), Connected,…
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 ------------------------------…
Buffer wait occurs when performing INSERT in multiple sessions
Hi Mike, Thanks for your response. Setting the IFMX_AIXKAIO_NUM_REQ environment variable requires restarting the instance, so we will consider it later. The result of onstat -F is shown below. Foreground writes 0 LRU writes 305769353 Chunk writes 9225920 The settings in onconfig …
Temp dbspace usage
Glad we could help :-) https://www.oninitgroup.com/faq-items/dbspaces-how-to-list-temp-dbspace-contents ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
database list under dbspace
Amit: select name, dbinfo( 'dbspace', partnum ) as dbspace from sysdatabases where dbinfo( 'dbspace', partnum ) = 'datadbs_1'; name art dbspace datadbs_1 name forums dbspace datadbs_1 name nologging dbspace datadbs_1 name logged dbspace datadbs_1 name pinn…
onstat statement
Dears, Kindly let me know if I run onstat - g stm command to check current sql statement which give the Session ID but sometimes if I try to kill the session by onmode -z <id> , it doesn't kill the session. So do I need to connect the session id with onstat -k session id ? kindly…
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…
Physical Log size
Hi Dirk, I don't know your system but unless you have a specific reason to suspect the physical log size, I don't think it is a likely cause, especially as it is quite large already. I would start by looking at what is happening during your slow checkpoints. Do you have output …
how to change the default location of rootdbs
I have installed innovator-c 11.7 with default settings. when I do onstat -d /usr1/Informix/ol_informix1170/dbspaces/rootdbs /usr1/Informix/ol_informix1170/dbspaces/plogdbs /usr1/Informix/ol_informix1170/dbspaces/llogdbs /usr1/Informix/ol_informix1170/dbspaces/datadbs /usr1/Infor…
Recovery mode stucked
Hi All Informix experts. I am just starting to work with Informix. Our Informix was undergoing a reboot and I am trying to bring it up. I am running into the errors below, where the server is stuck in Recovery mode. Can someone please let me know what I would need to do to ove…
listener-thread@soc_be.c:3073: err = -25582:
Adding Version details Informix Version : IBM Informix Dynamic Server Version 12.10.FC6 O/S Version : Red Hat Enterprise Linux Server release 6.9 Thanks & Regards, Karthik Rajan…
Connection Refused
Hi Jack, thanks for your response. The onstat -m says: "Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 03:17:51 -- 478208 Kbytes Message Log File: c:\\\\INFORM~1\\\\ol_gechenique.log Wed Mar 21 08:21:34 2018 08:21:34 DR: DRAUTO is 0 (Off) 08:21:34 Informix Dynamic S…
storagepool free space recovery
Hello everyone, I dropped a storagepool dbspace using 'onspaces -d' instead of the function 'drop dbspace to storagepool'. How do I return the free space to the storagepool? Is there a function to list the contents of the storagepool? Thanks, Benoît…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Which dbspace does a database occupy
IDS 11.50.FC5 Solaris 10 I have several dbspaces and databases. How can I tell which dbspace a particular database is in? Thank you. Larry sorensen…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Question on tuning
I'd really first try to establish whether the time is lost on Informix=20 server side, or whether it's the java application and/or its communication = to the server and the server spends a lot of its time waiting on the=20 client. -> you'd monitor the java application's server s…
Can you resize a dbspace?
Depending on how you started this backup & restore using STDIO, it might=20 be perfectly expected that you've got to control-C it after it has=20 completed. E.g. ontape -s -L 0 -F -t STDIO | ssh machine=5Fb ~/imp=5Frest.sh with imp=5Frest.sh being: #!/bin/bash . set=5Fix=5Fenv…
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…
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…
LRUS_MIN MAX DOES NOT WORK
When dirty buffer is over 4000 (resulut of onstat -R), I check onstat -F and I found that my 8 cleaners are in state "I".…
sysmaster tables for onstat -u and onstat -g ath
Greetings. In my quest to produce Perl scripts that consolidate the output of onstat commands, it has been mostly straightforward to break up a line into into its component pieces of data. For example, onstat -u, every line has exactly one string in every column. Not so for som…
onstat -a order
Hi All, On Informix v.12.1, what is the order of the results for 'onstat -a'? Our file is 234MB large, so I'm breaking it down into the individual pieces. I've gotten to the 'onstat -g all' section, but am stuck on the section with the heading: Thread Thread id Cancelled I/Os C…
Fast recovery slow
Thanks Mark, I send the relevant part of the engine log. You can see that the logical recovery is slow. 19:48:13 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized. 19:48:13 Started 1 B-tree scanners. 19:48:13 B-tree scanner threshold set at 5000. 19:48:13 B-…
12.10.FC6 Mac port released
IBM Informix 12.10.FC6 release for Mac OS is officially available! John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS)…
onstat -d
I am sure it must exist Does someone have a script to give a pretty layout of onstat -d ............. The dbspace, and following that the chunks belonging to that dbspace ? My company decided not to stick to naming conventions, and now I am trying to match dbspaces with chunks …
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.…
Long checkpoint
A good start is to monitor 'onstat -F' continuously through the checkpoint. This will show which chunks are being flushed during a checkpoint. A common scenario is having everything waiting on a single chunk to flush towards the end. You can also monitor 'onstat -u' and check th…
stopping ifxclone
Hi, We are running Informix 11.70.FC7. We started ifxclone to re-setup an RSS server, though we had to stop the RSS server in the middle of the clone. We used onmode -ky to stop the RSS server. However when we try to restart ifxclone again, we get the following error message on …
Re: Identify the sessions which using all tempspac
Done! Meanwhile: http://www.oninitgroup.com/listing-temp-dbspace-contents Regards, Doug Lawry…
onstat -d
Hi, I see a line in onstat -d output that say metadata Size Free Bpages Metadata 17324 4005 17324 I see the free space was drastically reduced when I run cdr commands. My question is, what will happened with that space if it gets empty ? Thanks in advance. --001a11c11a8c11f…
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,…
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…
virtual segment question
Run onstat -g mem and see which sessions are using the memory. David. > On 03 June 2014 at 06:17 CHUAN LU <luchuan@cn.ibm.com> wrote: > > > onmode -F doesn't do help. > > > ******************************************************************************* > Forum Note: Use "Reply"…
Onstat -d
Hi, Every day I run onstat -d command, and notice that every 3 or 4 weeks rootdbs has from 2 to 8 free pages less. Why this happend? Enviado desde mi iPhone…
Problem dropping dbspace
A little more information, in case it is helpful. The cause of the corruption is that the raw devices were accidentally allocated to a second instance while still allocated to this instance. Both instances have flagged these devices as offline. The original plan was to drop thes…
onload question
When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the database came from dbspace 1, write it t…
RE: onload question
Solaris 10 - Sparc IDS 11.50.FC5 When using the onload -d dbspace option, when the original database was unloaded from two dbspaces, does the -d option overwrite both the original dbspaces and write them both to the specified dbspace? If so, is there a way to say, if the databa…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
onstat -g ath
It signifies the thread is bound to a vp. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 01/29/2014 05:59:00 AM: > From: "BILL GLIDDEN" <bglidden1962@gmail.com> > To: ids@iiug.org, > Date:…
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.…
Problems of I/O due to too many cleaners?
onstat -F shows: Fg Writes LRU Writes Chunk Writes 0 37898980 47060501 These are the configuration: cleaners=120 LRUs=510 lru_min_dirty=2 lru_max_dirty=4 CKPTINTVL=300 300 chunks buffer size = 2k chunk size = 2k In this case if I want to increase more buffers I should further…
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,…
onstat errors
Hi Art We are old dostats fans. Last version we compiled is: dostats: Features Version 6.00, Source Revision: 1.172 ! Copyright 1996-2009 by Art S. Kagel. License for private usage (including use by commercial enterprise for its own needs) is granted. Commercial and exploita…
onstat & SMI
Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.…
ifxclone
I finally got my grid and CDR setup to work (with a little help from you guys) and then decided I'd try making it easier by using ifxclone...now I can't get that to work :/...I've created the files for the spaces that the source has on the target. I've created the sqlhosts and on…
LRU Queues - more or less
onstat -F shows 0 LRU Writes…
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…
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 …
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…
Re: Problems with long checkpoints
On 27/09/2011 22:48, Sean Baker wrote: > > The avg. time for sm_dbspace0 is quite a bit worse than dbs1. As a shot in the dark, we're going to create the dbspace on the same storage that dbds1 is on, just to rule out the NFS volume. Here's onstat -F, but I'm not sure how to in…
Determine Dbspace Pagesize
What query can I run vs. sysmaster or system catalog tables to determine the pagesize for a given dbspace?…
Help! Broken server destroys customer demo...
Here's some more information, the output of an oninit -v command: Checking group membership to determine server run mode...succeeded Reading configuration file 'C:\\\\PROGRA~1\\\\IBM\\\\Informix\\\\11.70/etc/ONCONFIG.ol_matdemo'...succeeded Checking config parameters...succeeded…
Over 1,000 days of 24x7 database uptime!
On 29.07.2011 20:38 Lester Knutsen wrote: > From one of our customers, their Informix server hit 1,000 days today > .... congratulations;) > > IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line -- Up > 1000 days 00:31:45 -- They beat mine just bit ... IBM Informix D…
Dbspace restore
Several large tables located in a single dbspace of a database were inadvertently truncated. I attempted an onbar restore of the dbspace but received the following error message in onbar log: "Storage space <dbspacename> is not down so it will not be restored." But I've restore…
Dbspace restore
A user accidentally truncated tables all located in a single dbspace of a database, but I'm unable to restore the individual dbspace as a warm onbar restore -- onbar log grouses "Storage space <dbspace> is not down so it will not be restored." However, I've been able to …
Setting up HDR- First Time -11.70 Innovator-C
Hi, I am setting up HDR for the first time. onstat - on primary shows IBM Informix Dynamic Server Version 11.70.UC2IE -- On-Line (Prim) -- Up 0:11:5s onstat - on secondry shows IBM Informix Dynamic Server Version 11.70.UC2IE -- Fast Recovery (Sec) -- Up 00s onstat -m on sec…
ISAM error 197: Partition recently appended to
Informix Dynamic Server Version 9.40.UC5 SUSE Linux Enterprise Server 10 (i586) I have done a level 0 backup directed to /dev/null and tried again. still it is throwing the same error.…
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…
onstat -l
I'm seeing a couple of extra lines in the output of 'onstat -l', which I can't find documented in the 11.50 administrators guide and references. The lines in question look like this: Buffer Waiting Buffer ioproc flags L-1 0 0x1 0 L-2 0 0x1 0 The exact lines varies (L-1 through…
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…
Shared memory problem
IDS 9.40 UC4 on Linux (yes, I know ...) 1. Initialising the instance with a shared memory connection it just hangs at: 01:09:26 Maximum server connections 0 01:09:26 Dataskip is now OFF for all dbspaces 01:09:26 On-Line Mode 01:09:26 Building 'sysmaster' database ... Never…
Raw Devices
Currently we are using our database on IDS 11.50.FC6 and our dbspaces are on UFS file system.Can we transfer our existing dbspaces on raw disk and how we do it , Also how much down time is expected.…
Extent and DBSpace
Hi, I have a database space issue due to the 2Gb limit on a DBSpace. How do you force the next extent of a table to be on another DBSpace. Thanks Andrus…
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…
how to analyze bottleneck in informix db
Have you considered using OAT (OpenAdmin Tool). It has a report to show what users are waiting on? http://www.openadmintool.org/ John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 01/29/201…
can't kill a session using "onmode -z session id"
Hi All, I encountered problem on my DB. I am dropping a table and it hanged. I decided to close the window by clicking the "X" button. When i checked, the table still exists when i use dbaccess-> table-> info. But when i try to select from the table, the message is table does no…
shared memory not initialized for INFORMIXSERVER
IDS 7.31 UNIX SCO 5.0.5 20:34:14 Requested shared memory segment size rounded from 8000KB to 8192KB Wed Oct 28 20:34:15 2009 20:34:15 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 20:34:20 DR: DRAUTO is 0 (Off) 20:34:20 Requested shared memory segment size …
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
Move a table to particular DB space
Hi All, How we can a move a particular table from one dbspace to another dbspace? Please help. Thx…
Curiosu about a message in bar_act.log
What does this message mean in bar_act.log? "n percent of [dbspace name] has been backed up."…
oninit -r
We tried "oninit -m"... IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line (CKPT REQ) -- Up 00:03:33 -- 488472 Kbytes Blocked:CKPT Some information: - before this problem, the system was in a cdr replication state and we would disable this executing an "oninit -D", wh…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: help with sessid
emaus wrote: > Hi all: > > MAX_PDQPRIORITY 80 # Maximum allowed pdqpriority > DS_MAX_QUERIES 20 # Maximum number of decision support queries > DS_TOTAL_MEMORY 4000000 # Decision support memory (Kbytes) > DS_MAX_SCANS 1048576 # Maximum…
Need a Way to create sysutils & sysadmin DB
Hi, Using IDS 11.5 , 1)Have any way to migrate sysutils & sysadmin DB to different DBSPACE? 2)Or create in different dbspace? rgds schillache…
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 ?…
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
ontape -r idle
Hi, When i run ontape -r to restore database, it didn't return any abnormallies, but it remain hangs/idle. Server remain at Fast recovery mode and i am able to run onstat command. Please help. I have paste the output and error log information below. Kindly review. Thanks # ontap…
dbschema -f all versus onstat -g prc?
Hi everyone. If I want to get a definitive list of all of the UDR's (stored procedures) in an IDS 9.4 FXC21 database I would think dbschema -f all -d DB_NAME would show them. However when I execute: dbschema -f all -d DB_NAME it comes back with "No procedure" However when I exe…
btree invalidation
I have the following line in the output of onstat -g mem btree inval V c000000054330028 1745338368 149991704 1704431 213054 I'm care about that because the last week the number of memory segments (onstat -g seg) has increased and onmode -F has no efect. I've noticed that …
Problema con logs
buenas tardes necesito saber si se puede salvar esta base de datos. tengo el siguiente problema: # oninit -vp # onstat -m 13:20:52 Onconfig parameter VP_MEMORY_CACHE_KB modified from 21822020 to 5455505. 13:20:52 Dataskip is now OFF for all dbspaces 13:20:52 Logical Log Files ar…
Dbspace creation
Hi, I have 3 hard disk partitions hda5, hda6, hda7. I would like to create dbspace in each of this file system partitions. hda5 - dbspace1 hda6 - dbspace2 hda7 - dbspace3 We wish the dbspaces to have the size equivalent to the partition size. I have created the dbspace1 usin…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
If there were no onstat...
IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the cu…
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…
Speed issues 9.4
I am not sure what has happened but over the last week we went from zero complaints about speed to a lot of complaints. No app changes. The DB Server is a Sun V490 with 24 FC 15k drives configured as Raid 10. Checkpoints are averaging 0 seconds. IBM Informix Dynamic Server Ver…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
what is using tmp dbspace ?
Is there a way to tell what session is using the tmp dbspaces ? Thanks, floyd…
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…
Rename Dbspaces
Hi All: I can rename logs dbspaces online ??? Thanks _________________________________________________________________ Regístrate en el nuevo Windows Live Messenger beta. [1]¡Haz click aquí! References 1. http://g.msn.com/8HMAESAR/2734??PS=47575…
Re: Physical restore
mohitanchlia@gmail.com wrote: > Version: IDS 10 > > What does this mean ? > > 20:19:45 DR: Reservation of the last logical log for log backup > turned on > 20:19:45 Data replication type and state information reset. To start > DR, use > the 'onmode -d' command and wai…
Fragment by partition
Version: Informix 10 I have couple of questions regarding fragment by partition in same dbspace: 1. Is there any limitation as to how many partition a dbspace can have. 2. Is partition name unique to dbspace or unique to index/table. Logically it should be unique to dbspace as …
table wise statistics
onstat -g ppf and onstat -f iof ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 7/31 10:27:53 Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall stati…
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…
long checkpoints on informix
On 13 jul, 14:49, "Obnoxio The Clown" <obno...@serendipita.com> wrote: > Sakura.g...@gmail.com said: > > > if u need anything else just tell me > > onstat -F > onstat -R > > -- > Bye now, > Obnoxio > > "I'm astonished anyone pays real money for this crap." > -- Cosmo > > "Cluster…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: Digital UNIX V4.0F + 7.31.FD1 Performance
so, ein erstes Feedback! Werte bei onstat -P ergeben folgendes: Percentages: Data 56.87 Btree 40.33 Other 2.80 onstat -R 8 buffer LRU queue pairs priority levels # f/m pair total % of length LOW MED_LOW MED_HIGH HIGH 0 F 35745 97.9% 35000 0 34996 4 0 1 m 2.1% 745 0 743 2 0 2 f…
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…
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
Dbspace script
Hi, Is there a script or utility that can review your current layout of dbspaces and then create a script of "onspaces" commands to duplicate the environment?…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Informix Installation Crashed
Can you give us the contents of files: /etc/hosts /etc/hosts.equiv /etc/resolv.conf /etc/conf/cf.d/stune $ONCONFIG $SQLHOSTS Also, which exactly versions and patches of SCO OpenServer and IDS do you use? For example, you could use SCO OpenServer 5.0.6 + some patches (I cannot re…
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
Informix Installation Crashed
When trying to install IDS 7.3 on SCO Openserver Release 5, I am getting following error continuously ... can any body help where should I do??? In fact the "Setup" hangs, when "Launching sysmaster database ...", and then it crashes. Early response will be highly appreciated. …
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
Listing all the tables in using a dbspace in Informix
Is there a way to list all the tables which use a specific dbspace as well as their sizes in Informix. regards V…
Onspaces Segmentation fault
Hi all, I have just finished reinstalling my IDS 10 for linux, on suse 9 for workgroup. I initialized the DB instance nicely (oninit -iv) the rootdbs plus its mirror was created fine. But when i type onspaces (with or without the parameters), puff!!! the thing throws "Segmentat…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Dropping DBSpace
Hi All, I want to Drop a DBSpace and it has 2 chunks. When I tried to drop DBSpace, the error message "DBspace is not empty" I tried to drop secondary chunk first and cannot drop primary chunk first, still its same message "Chunk not empty" Is there is any way to drop the DBSp…
Determine which tables and indexes are in which dbspaces
I am trying to run a SQL against system tables that will show me which tables are in each dbspace and then correlate their indexes to see if the indexes are in the same dbspace. I know have some indexes in dbspaces that have tables in other dbspaces and want a query that will sh…
temp dbspace
Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or …
RE: Trouble restoring database on test/recovery system
> So I tried oninit -r and I get a different problem, my log files fill > up and then the process stops. We are using the alarm script > to backup > the logs to disk. This doesn't seem to work and I can't seem to do > anything to get the log file cleared and remove the Blocked:…
RE: Trouble restoring database on test/recovery system
Have you followed the paths to find what devices your temp0-6 actually point to? Maybe the problem is with your test server (can it still see those devices). Norma Jean Sebastian ERP Support Administration GIS- Enterprise Technical Services -----Original Message----- From: inf…
Trouble restoring database on test/recovery system
Trouble restoring database on test system (IDS 9.40.HC3 on HP-UX 11i (11v1) Yesterday when I was restoring the production database on the test/recovery server I got some errors I never gotten before. I have done this processes 20-30 times in the last 2 years and never had any …
RE: need help - infformix is down - restart got index failed
OK Neil, I ran an experiment....... hsap10% oninit -v ........ Initializing 127 flushers...succeeded Initializing log/checkpoint information...succeeded Opening primary chunks...succeeded Opening mirror chunks...succeeded Initializing dbspaces...succeeded Validat…
Onstat Reference
It's taken a while but I've finally got our onstat reference pages (www.oninit.com/onstat) up to data with all the recent (ish) stuff. The V11 changes will be in place when the V11 Beta goes public. I'm happy to be told where they are wrong. If you like it then use it, if you …
File System Backup....
is your filesystem on the same devices as your informix dbspaces? what does the sar i/o activity report?…
Dbspace Down
Hi, I have IDS 9.3-TC1 on Win 2000 SP4. When I run the command onstat -d two dbspaces are marked as down. Is there a way to bring them up? 2e351680 8 0x5 8 2 ND informix primenic01 Thanks, Vasilis…
To recover dbspaces
Hello� they can help me with sintaxys of the command ONSPACES to recover dbspaces. I execute it this way: $onspaces -s dbspace_name -p /dev/informix/chunk01 -o 0 -O Warning: Bringing chunk back online. Do you really want to continue? (y/n)y Verifying physical disk space, pleas…
License Extension
Help.. I need a license extension for the IBM Informix Dynamic Server Version 10.00.FC3R1TL which I downloaded to do a evaluation. How can I get the license extened..my project is in the final stages .. Dhaya Commercial bank…
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…
record locked
a combination of onstat -k and onstat -u…
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…
Getting ISAM error 116 during update statistics
Thanks for all your support this problem is solved by increasing the shared memory value in that server :-) On 5/26/06, ART KAGEL, .... <kagel@bloomberg.net> wrote: > > > Increase DS_TOTAL_MEMORY from the default and increase SHMVIRTSIZE to > accomodate > the extra memory. Also …
help on onstat
hi, please help me how to leave onstat -i mode? thanks…
Re: oninit -i problem
your database did come online 17:01:41 Dataskip is now OFF for all dbspaces 17:01:41 On-Line Mode 17:01:41 Building 'sysmaster' database ... 17:01:41 Checkpoint Completed: duration was 0 seconds. some minutes later someone stopped it 17:08:28 Informix Dynamic Server Stop…
oninit -i problem
online log out put Sat May 20 17:01:32 2006 17:01:32 Event alarms enabled. ALARMPROG = '/u/informix/etc/log_full.sh' 17:01:37 DR: DRAUTO is 0 (Off) 17:01:38 Informix Dynamic Server Version 7.31.UC5 Software Serial Number AAC #J876311 17:01:38 Informix Dynamic Server Init…
Database Creation Error
I am using HPUX 11.11 for Informix 7.31 when I run oninit -i I get this on the log. The database does not initialize. My file settings are as follows > > SERVICES > srvr0001 8001/tcp #Informix port > > sqlhosts > ok_srvr onipcshm 10.0.6.2 …
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
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?…
who locks a record?
onstat -k followed by an onstat -u…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Restore Problem
I am tyring to restore a production backup to a spare box to get some deleted rows from one table. I am getting the following error when trying to restore: 22:38:04 Event alarms enabled. ALARMPROG = '/ifxapp/informix/etc/alarmprogram.sh' 22:38:04 Booting Language <c> from module…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
RAID 5 hardware and different dbspace ?
Is there a interest to separate tables on different dbspaces if disks are managed by a RAID 5 hardware…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
IDS 9.4 on XP64
This involves IDS 94 installation on XP64. C:\\Program Files (x86)\\Informix>oninit -iy gls function get_mt_locale failed, error -23101 C:\\Program Files (x86)\\Informix>set | find /I "locale" CLIENT_LOCALE=EN_US.CP1252 DB_LOCALE=EN_US.8859-1 SERVER_LOCALE=EN_US.CP1252 The log…
Performance tuning: troubling long checkpoints and other issues
My bad, the server only has 2Gb of Ram, which I now recall to be the max for this platform. BUFFERS was decreased because the system began to swap since the number of user sessions has increased. We do have one set of disks that is running hot. They were all nicely balanced a …
Increased extent size, but still hit max extents
The table is in a DBSPACE of related tables. Other "schemas" are in their own dbspaces, and each dbspace has its own group of chunks. Can I infer from your question that if Informix can't find a 20M contigous area, it will just choose the next larger? Which would imply that I ne…
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Temporary dbspace
Many of my current systems have just one temporary dbspace. Is there any mileage to be gained by adding a second temporary dbspace on a multi-processor system but with only 2 disks which are mirrors of each other? Some reports and queries are not performing as well as they did …
Relocate Informix database from Raw slices to filesystem
Thats sounds promising. So effectively add a mirrored chunk to each dbspace using onspaces and then drop the original chunk. Can you do this for the rootdbs dbspace too...? Matt…
Re: IDS 10 erratic run times
1. Try running onmode -F before each run (free shared memory segments/blocks and general tidy up memory structures). 2. What does onstat -g stk <thread id> give for the sqlexec (or sessions threads) and the kaio threads during the freeze? Repeat several times to see what func…
Re: Long checkpoint duration
Keith wrote: > During the checkpoint, do you see activity from the flushers? Does No activity at all! > onstat -F show them active. Do you see write activity for those guys > with onstat -u? Do you see chunk writes with onstat -D? No nothing, it really seems to "hang". But t…
Long checkpoint duration
During the checkpoint, do you see activity from the flushers? Does onstat -F show them active. Do you see write activity for those guys with onstat -u? Do you see chunk writes with onstat -D? What's your checkpoint interval? lru max dirty? lru min dirty? How big is your phs…
Re: Change chunk name
scottishpoet wrote: > on 7.31? thought you could only drop chunks on 9? > informix> onspaces -V IBM Informix Dynamic Server Version 7.31.UD8X8 Software Serial Number ACN# informix> onspaces Usage: onspaces { -a spacename -p pathname -o offset -s size [-m path offset] | …
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…
Transaction Rollback
onstat -x…
how to find a dbspace for a table
Can someone show me how to find which dbspace a table is on in database? I used below SQL but dbspace shows as 0 select trunc(partnum/16777216) dbspace, sum(nrows*rowsize) bytes, tabname from systables where tabtype = 'T' group by 1,tabname order by 1; Thanks for your help. T…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
RE: Informix 7.23 connection problem
Our NETTYPE is set: NETTYPE tlitcp,1,100,NET NETTYPE ipcshm,1,250,CPU We did onmode -ky, oninit -y and onstat -m shows: INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 00:10:35 -- 38704 Kbytes Message Log File: /var/informix/online.log 11:04:01 Checkpoint Completed: dura…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
identifying objects in a dbspace
Hi, I've dropped an index of a fragmented table from a dbspace, but to my surprise the dbspace still has used pages. I would have thought the dbspace would be empty. When rebuilding the index, the used pages do not seem to be reused. Then when I try to drop the dbspace I rece…
Slow writing data into BLOB through JDBC
> Is the BLOB column stored in a regular dbspace or in a blobspace? Any > BLOB data stored in a regular dbspace will go through the buffers . . > . > JWC The BLOB is in dbspace. I will create a blobspace and make a test again. Thank you for your help. Georgi Cholakov…
Inconsistent Dbspaces
This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C4AB83.56BABA80 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys Can anyone tell me what procedure u take when you have Inconsistent Dbspaces ?? What could cause …
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Urgent replication problem
I don't know how big your database is but is it possible to backup the primary and restore it to the secondary. Basically you are starting over. We do it all the time after a release. We modify so much we found it better to break replication and then redo the replication steps t…
Re: Urgent replication problem
Bjorn De Waele wrote: > Hello alexey, > > > > 1. the onstat -g dri gives me on the secondary a last dr ckpt from -1/-1, so > this is definitely wrong > 2. the netstat -a shows me a connection on port 4049 with the primary > 3. onstat -m gives me : > > Informix Dynamic Server 2000…
RE: Urgent replication problem
Hello alexey, 1. the onstat -g dri gives me on the secondary a last dr ckpt from -1/-1, so this is definitely wrong 2. the netstat -a shows me a connection on port 4049 with the primary 3. onstat -m gives me : Informix Dynamic Server 2000 Version 9.21.TC3 -- Fast Recovery (…
virtual memory segments added
onstat -g mem displays the pool names (first column) onstat -g afr <poolname> displays the allocated fragments by address. If you run onstat -g seg, you get the logical address of the shared memory segments. Somthing like... for f in `onstat -g mem | cut -d ' ' -f 1 ` do o…
dbspace down
I have stopped the database with onmode -k and now it refuse to come up saying that it will need restore of dbspaces. What is the best way to restore the database and make the engine online. Any inupt is highly appreciated, thanks Mukund sending to informix-list…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Logical logs from rootdbs to own logspace
I want to set-up a logspace dbspace - easy enough. But how do I tell informix to use this logspace dbspace instead of rootdbs?…
Re.slow response
Hi, Here is the output of onstat -p, buffers read/write looks good. Checkpoint is always 0-2 secs, and checked couple of other things nowhere I can find the problem/issue. I do have perf. manual for reference. We have fiber disk with cache 512 mb, we are planning to put 2 gb cac…
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…
Re: high buffer wait ratio
"Andrew Hamm" <ahamm@mail.com> wrote in message news:c6276a$7263f$1@ID-79573.news.uni-berlin.de... > miyaki wrote: > > Hi David, > > > > Here's partial of the onstat -g spi output, sorted by > > the number of loops. > > > that's not quite sorted properly - try > > onstat -g s…
high buffer wait ratio
Andrew Hamm wrote: > > What's the output of > onstat -g iov | head -7 WRONG!!! I mean, what's the output of: onstat -g iof onstat -g iov onstat -F | head -7…
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…
Do I need more KIO's
You've got virutally no buffers, only 6000. Without knowing how much memory you have in the box I look at running this to 50000, or even 100000 and see what happens I'd set the tapeblk to 1024 instead of 16 Do you really want your logs to be thrown way? ltapedev = /dev/null I'd…
Onstat -D / onstat -u mismatch
IDS 9.21.UC6, Solaris 2.8 building an ETX index, into logged smartdbs, onstat -u shows the nreads column ticking up. The nwrites is remaining at zero. Onstat -D shows heavy reads on one smartdbs where the data is, and heavy writes on smartdbs where the index is heading. onstat…
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: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
Dropping a dbspace
I have a bad dbspace I wanted to drop (and recreated). But I have some problem. Here is the output form onstat -d: 5010c7d8 1 0x20001 1 1 N informix dbroot_test3 5020dcb0 2 0x20005 2 1 ND informix dbdata 5020de00 3 …
Curious problem starting IDS 7.31ud2, Suse8.2
If online is started using oninit -y the engine crashes per below.it will come up fine using oninit -py. Anyone seen this and know how to cure the problem? Up until recently the server would start fine with oninit -y. Mark 17:04:27 Informix Dynamic Server Initialized -- Share…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
RE: database restore with ontape -r on Informix Online Dynamic Server 7.31 on Linux
"Colin Bull" <c.bull@videonetworks.com> wrote in message news:btmcr4> That will make it a lot tidier, should be able to use a case statement. > I will revise next week sometime. > http://www.smooth1.demon.co.uk/ifaq06.htm#6.33 6.33 What status codes does onstat return? On 21st …
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…
Re: onstat -F
Hi Andy. You can find Administator's Reference. Here is a part of manual. onstat -F Use the -F option to display a count for each type of write that flushes pages to disk. You can interpret output from this option as follows: Fg Writes Is the number of times that a foreground …
onstat -F
What does the "data" column in onstat -F output signify? Where is this documented? Thanks Andy…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
Re: Informix in offline mode
Jonathan Leffler <jleffler@earthlink.net> wrote in message news:<vOEsb.11220$6c3.10434@newsread1.news.pas.earthlink.net>... > Eyal Goren wrote: > > I am trying to install a product that is based on Informix server > > (7.2). > > > > The problem is that after Installation, and reb…
onstat -d anomaly
Yesterday I upgraded a server on 9.4 demo to the actual 9.4 . I had backup up the spaces to another disk(root,data,physical,logspace,tempspace). (This is cooked space on win2000.) I let the install replace all files. Then I restored the spaces with COPY. Then I changed ONCONFIG …
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…
ontape -r. How do i know its working ?
OK. It bombed. Any idea what the stuff below means ... oninit: Fatal error in shared memory creation Physical restore failed - could not fork server connection Program over. "Jack A" <jacka8@excite.com> wrote in message news:79cb48187430df1afa179eb63392bbc3@news.teranews.com…
Re: Multiple Temp dbspaces
You might want to check your DBSPACETEMP entry - it looks from your post like there's white space between the dbspace names - Informix will stop parsing at spaces, tabs etc. and will only pick up the first dbspace listed. HTH -- Phil@oninit.com…
Re: dbspace ?
Where do we all begin? A dbspace is an area where databases, tables, etc can be stored. It is not just one file, it is more likely to be a number of files or more likely devices. When a database is created it will have a base dbspace where all tables will be created unless othe…
dbspace ?
Hi, Sorry, I am a little bit new in Informix. We need to modify the structure of a table, and the system allways answer that the disk is not big enough. They say it's because the dbspace is too small. Questions : - is the Dbspace a file or just allocation ? - is there ONE dbsp…
Help !!! Cant get IDS 9.2 UP
I was killing an ontape process and picked up the incorrect process id ( parent id ). I ended up killing an informix process. Now when I try to bring up informix i get the following error ... 22:13:59 Loading Module <BUILTINNULL> 22:14:04 Requested shared memory segment size r…
Panic
GlacierJust booted a server (win2000) running IDS 7.3. This was on the end of the log: 16:07:04 Dataskip is now OFF for all dbspaces 16:07:04 Init operation complete - Mode Quiesent 16:07:04 Checkpoint Completed: duration was 0 seconds. 16:07:04 Checkpoint loguniq 1160, log…
Is there a 2gb dbspace limit NT 4.0, IDS 7.3?
Is there a 2gb dbspace limit on Windows NT 4.0, IDS 7.3?…
Rename a dbspace
Hi, Does someone know an easy mean which permit me to rename a dbspace contening just a separated index ? Thanks in advance. Best Regards Fred…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
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…
Maximum server connections 0
Get following message in the online.log.All client can't connect to IDS. I found the "Maximum server connections 0" in the log file.So I thing the problem is related about the message. I search the problem in the internet,but I can't get solution. Give me a hand. Thank in advance…
regarding check point
hai all, thankyou for the reply. i had following error meaages Informix Dynamic Server Version 7.30.UC7 -- On-Line (CKPT REQ) -- Up 00:05:31 -- 81080 Kbytes Blocked:CKPT ARCHIVE Message Log File: /informix/online.log 22:54:15 Rollforward of log record failed. iserrno = 191 22:…
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…
onstat flags
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_000_01C2C163.7472F850 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2C163.7472F850" ------_=_NextPa…
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
RE: onstat
On Tue, 30 Jan 2001 dr_pablo@my-deja.com wrote: >> I have seen vendor-supplied scripts, which use the following >> exit codes from "onstat". I do not know where they are documented. > >Here's the URL to the FAQ page containing the info: > >http://www.iiug.org/resources/faq/ifaq0…
RE: onstat
I got this email awhile back: >PEOple, > >For those of you who do not know, it is very tough to determine the *real* >status of IDS. "onstat -" will return, stating that the server is "online" >but many times it is in the process of a "fast recovery", etc. In >addition, "onsta…
RE: onstat
The exit codes were posted into a FAQ at the IIUG web site at one time. Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Bogdan Neagu [mailto:bogdan.neagu@alcatel.com] Sent: Monday, January 29, 2001 11:17 AM To: informix-list@iiu…
RE: onstat
Hi Bernstein. Please visit following site. >exit codes from "onstat". I do not know where they are documented. http://www.informix.com/informix/iuc/ppt/ts_ids.ppt And search "onstat". Regards. -- Tsutomu Ogiwara Technical Group & Red Brick Group, Informix Sales Promotion …
Re: onstat
At 11:17 01/01/29 -0500, Bogdan Neagu wrote: Hi Bogdan. When the meaning of the question is different, I'm sorry. onstat returns the following. The server status is expressed as a number 0 Initialisation 1 Quiescent 2 Recovery 3 Backup 4 Shutdown 5 Online 6 Abort Regards. >…
RE: onstat
I have seen vendor-supplied scripts, which use the following exit codes from "onstat". I do not know where they are documented. integer inf_dwn1=255 # Informix mode is down integer inf_dwn2=-1 # Informix mode is down (60_USAP2) integer inf_init=0 # Informix mode is Initia…
onstat
Hi all. I was told by our DBA that onstat has different exit codes depending on the engine's mode (or mood). So, if I test $result (in C shell) or $? (Bourne / Korn shell), I should get a numeric value. My tests show 1=Quiescent, 5=On-Line. Does anyone know what these values …
onstat -b
Hello all, Below is the output of onstat -b : informix@test:/usr/informix> onstat -b Informix Dynamic Server Version 7.30.UC8 -- On-Line -- Up 6 days 21:06:56 -- 506592 Kbytes Buffers address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist 31427e88 0 …
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!…
DR: Cannot connect to primary server
We have 7.31 on Solaris_x86 5.7. The secondary server suddenly said 16:47:22 DR: ping timeout 16:47:22 DR: Receive error 16:47:23 DR: Receive Btree error 16:47:24 DR: Turned off on secondary server and keeps on saying 12:28:20 DR: Trying to connect to primary server ... 1…
Fragmented dbspaces
Yup, dbspaces *not* fragmented tables. Our system holds about 75Gb on a mixture of 4.3Gb & 9Gb disks, raw chunks, HP-UX 10.20, IDS7.31. When it was built we ran some predictions re. growth and so on based on the figures given to us by the business analysis group, upon which we ba…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
bug in onstat -t ?
onstat -t gives following output (look at column npages): Tblspaces n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns resident 17 c0000000995f8908 0 1 100001 10000e -9223372036854775558 250 0 0 5 0 120 c0000000995f8d78 …
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
Dropping a dbspace
Hello All, Can somebody please help me with this. When I try to drop a dbspace, it says can not drop it. db space not empy. How do I find out what is there in the dbspace. Please help. Regards Aboo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
onstat on IDS2000
Hello all IHAC with IDS2000 ans the output of onstat -d is the following : Informix Dynamic Server 2000 Version 9.20.UC3X4 -- On-Line -- Up 6 days 16:59:45 -- 459440 Kbytes Dbspaces 500d1d08 6 8001 6 1 N S informix usersbs0101 Chunks address chk…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
��� ������ ������ ����?
�����������! ����������, ��� ������ ������ ���� � ����������� �� ����� � dbspace-�. ______________________ With best wishes, Kirill Solomko, JSC Protoka…
dbspace is down ...
When I try to drop the dbspace, it reports following ... $ onspaces -d rootdbstest WARNING: Dropping a DBspace/BLOBspace. Do you really want to continue? (y/n)y WARNING! The dbspace you wish to drop has been disabled. There may be database catalog entries for tables or indices…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
dbspace is down ...
Sorry for MIME format ... I have no alternative ... BUT PLEASE HELP ME ... IX: OWS 7.2, OS: SCO UNIX During my initial years as IX DBA, I tried to create two instances of informix ows 7.2. For this I created a dbspace using COMMAND CENTER from my windows station. then I put thi…
DBspaces and IECC
I have installed IECC on an NT4 machine with a 36 gig hard drive. I have created a dbspace on the D drive that is currently 7Gig. The D drive has 24 gig of free space, but Informix is not seeing it. When I try to add space to the dbspace it tells me that there is no free space…
RE: Error building 'sysmaster' database.
Whats in /tmp/buildsmi.6889 ??? Paul Watson # WF Software Ltd # If in doubt Tel: +44 1436 674729 # make it up Fax: +44 1436 678693 # www.wfsoftware.com # > > Sorry, > > Still the same error... > > 15:21:08 Dataskip is now OFF for all dbspaces > 15:21…
Re: Error building 'sysmaster' database.
Andy, Here is the latest try... Wed Aug 30 09:29:54 2000 09:29:54 Event alarms enabled. ALARMPROG = '/export/home/informix/etc/log_full.sh' 09:29:54 Booting Language <c> from module <> 09:29:54 Loading Module <CNULL> 09:29:54 Booting Language <builtin> from module <> …
Re: onmode -F
We had a similar situation with IDS 7.30.UC7XB several months ago. Occasionally, when we'd run "onmode -F", our engine would go out to lunch and force us to shutdown/restart. After upgrading to IDS 7.30.UC7XL the problem went away. If you continue seeing the problem I'd contact…
Re: onmode -F
I've never seen aproblem using onmode -F. Note that if you run onstat -g seg you can identify which and if any segments will actually be freed by onmode -F. These will be 95% or more unused meaning only overhead pages have been allocated. If a segment is not unused onmode -F w…
Re: onmode -F
Of course, it's a question of onmode -F....not onstat -F J. M�ki <jukka.maki@tieto.com> wrote in message news:4aQo5.264$_03.12419@read2.inet.fi... > Has anybody been facing a problem when running onstat -F > We had problems with logical logs, they didn't got backed up. > We are …
onmode -F
Has anybody been facing a problem when running onstat -F We had problems with logical logs, they didn't got backed up. We are using onbar. After rebooting Informix everything has been always ok !. Now I tried onstat -F, because I think it's a kind of memory fragmentation problem.…
Optimizing dbspace
Hello, I have a quite large table that acquires about 3 million rows a month. Every two weeks we purge the data by unloading it to a backup and deleting the "old" information. We do run 'update statistics' every time when deletes are performed. But it looks like it does not opt…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
RE: High BR ratio
Upping LRU's to 128(and probably CLEANERS too) would probably be a good start. Hope this helps, Will >===== Original Message From "Abdel Rashed" <abdel0296@hotmail.com> ===== >Hello, > >I read in past postings that a BR ratio over 10 will reduce performance. >Right now my system…
High BR ratio
Hello, I read in past postings that a BR ratio over 10 will reduce performance. Right now my system has a BR ratio of 10.46. What is the best way to lower it? I am puuting some onconfig variables an onstat -v and onstat -R in my message. LRU = 30 LRU_MAX_DIRTY = 2 LRU_MIN_DIRT…
RE: Primary chunk sanity check error
Have you tried using DATASKIP to get by this? Will >===== Original Message From "Prashant Kompella" <prashant@hartingdale.com.au> ===== >Hi, > >When we try to startup a restored Online 7.23 instance, we are getting the >following error: >"Fatal error initializing shared memory."…
onstat -u
I have a telnet user who consistently is walking out the door without logging off. Here's how I assume I should go about killing the user, with the problem listed below. 1. Do a who -u | grep username (identify tty port) 2. Do a onstat -u | grep username (to identify session i…
Re: Logical logs
On 5 Jun 2000, at 16:59, Srinivas Sreekumar wrote: If you can't make a backups continuos with ontape -c you have to change LTAPEDEV to null and change the LOG_BACKUP_MODE to CONT Bye > Hi All, > > I have a informix database of 7.30 where in the logical log is getting > full …
Logical logs
Hi All, I have a informix database of 7.30 where in the logical log is getting full very frequently. > What might be the reason. I think the "size" / "physize" of each log is > very less. I am giving below the output of "onstat -l". Is there any > parameters in onconfig tha…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Creating Dbspace
I am trying to create a new dbspace with a size of ~2Gig. When I specify the path to the cooked file to use it tries to verify the disk free space and always fails at around 1 gig. I know that I have plenty of free space on the disk so I can't figure out what the problem is. I…
Altering DBSPACE
Hello group, We have created all of our tables in dbspace "st_ux01_001". Now the "dbadmin" want to move all of our tables to dbspace "st_ux01_002". In Informix dokus we didn't find any command to alter a dbspace. The only way we know to alter the dbspace is, to export all data…
DBSPACE by table
There is a table in sysmaster who contains dbspace for every table. Thanks in advance. -- Francisco Gaspar SISTEL (Servicios Inform�ticos de Software y Telecomunicaciones, S.L.) Avda. Los Jarales, 4 03010 Alicante Tel: 96 593 00 80 Fax: 96 593 01 53…
Error in message log : shared memory base address illegal
Hi guys, Sun May 21 00:00:02 2000 01:08:58 INFORMIX-OnLine Stopped. 01:27:27 shmat: [EINVAL][22]: shared memory base address illegal 01:27:27 using 0xc0000000, needs 0xc2691000 01:27:27 Could not create single shared memory segment with resident and non-re sident …
Dbspace in CDROM
Hello, Can I create a dbspace for readonly in a CDROM? If it is possible, how can I do it? Regards. Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Onstat
Are you executing onstat with -r 1 option? It happens sometimes. Try with -r 5 option. Vinod Bhansali --- Srinivas Sreekumar <SRINIVAS_SK@inf.com> wrote: > Hi all, > > I recently installed Informix dynamic server > 7.31.UC6 on HP UX 11.0 > > I am getting an error while running …
RE: Onstat
I had a low value for the shared memory kernal parameter for my unix server. When I increased it it started working.. Thansk, Srini -----Original Message----- From: Marat [mailto:maratkotik@mail.ru] Sent: Monday, May 15, 2000 7:41 PM To: informix-list@iiug.org Subject: Re: Onst…
Onstat
Hi all, I recently installed Informix dynamic server 7.31.UC6 on HP UX 11.0 I am getting an error while running onstat. "Changing data structure forced command termination. " can someone interpret this message for me and tell me the action to be taken. Thanks, Srini…
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…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
DBSpace is disabled
Hello. I've a big problem: one DBSpace is disabled (chunk marked as Inconsistent), Informix ODS is off-line and I dont have an archive. I think exists an utility, that brings that inconsistent chunk On-Line. May be some body can give me it . Operating system is AIX 4.2.1.0, Infor…
Index Dbspace
As I determine through tables of sysmaster dbspace that it has assigned an index? Thank * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful…
What does DIRECTIVES ONCONFIG parameter mean?
Can anybody shed some light on the usage and meaning of the $ONCONFIG parameter DIRECTIVES. As can be seen from the following extract, it would appear to have been changed from 0 to 1. However, the $ONCONFIG file itself has a zero within it. I am guessing the engine has overridde…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
DBs in a dbspace
This is a multi-part message in MIME format. --------------DB252259E0E5E1E7CD818FAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, Good moring. Please help me in finding the dbs in a dbspace. What is the easiest way. Regards Aboo ---------…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: Informix-NT performance
From: ivon4388@my-deja.com > >I have big problem with HP LXr 8000 with >4xprocessors Xeon 400, 1Mb, 2048 RAM, NT 4 Server >Enterprise Edition, SP4 and Informix Database. >After rising user sessions over 1000 the average >CPU time on all processors(all thy are allowed >for Informi…
NSF subsystem error
We have this morning encountered the following error twice. The impact of this is that no new connections to the engine are allowed, but people currently attached have no problems working. In both cases we have had to bounce the engine to give access to all users. Most users conn…
TEMP dbspaces
Hi I have peculiar problem with temp dbspaces on IDS 7.22 UC1 and HP-UX 10.2. We defined tempdbs1,tempdbs2 as TEMPDBSPACES and 50000 pages for each dbspace. This system was configured two years back and using for development. This IDS server never be shutdown until necessary. …
List tables per dbspace
I am trying to generate a list of the Informix tables per each dbspace. My sysfragments table only contains the indexes. I have dbspaces that are filling up and am trying determine which tables could possibly be moved to another dbspace (while still being aware of application c…
DBSPACES and RAID
Hi Has anyone had any experience of setting up DBSPACES on a RAID 5 machine (in particular - running linux) I'm trying to make sure that there won't be any problems when I do the final port off the (un-RAIDed) HP machine to a RAIDed linux box - so would appreciate any advice in …
Fatal error in Buffer Manager
I have just installed the IDS.2000 engine and I am getting this error when I run oninit -i: 11:09:38 Informix Dynamic Server 2000 Initialized -- Complete Disk Initialized. 11:09:39 Checkpoint Completed: duration was 0 seconds. 11:09:39 Checkpoint loguniq 1, logpos 0xc0 11:0…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: Dbspaces
You don't like betty then:-)) "Art S. Kagel" wrote: > > > # Database/Table/Index Owner DBSpace Created Logging NLS > === ====================== ======== ================== ========== ========== === > 1 flintstones kagel dbspace4 …
Dbspaces
Hello, Can I find that which dbspace containing the database and tables. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
onstat -u
I am running Informix 8.2 on HP-UX 11.0. When I issue onstat -u command it shows the following: address flags sessid user tty wait tout locks nreads nwrites Under flags option: There are seven flags, the Seventh place flag is I know B,C,D,F; but it also shows M sometime. …
RE: Long check points
You can also look at the following LRU_MIN_DIRTY LRU_MAX_DIRTY LRUS CLEANERS also the number virtual processors doing your i/o. This depends on whether or not you are using KAIO. If you would post your version, platform, onconfig file, onstat -p, onstat -F, onstat -D, onstat -m…
detecting fragmented dbspace...
Sunil Bhaskarla wrote: > > Hi, > Which tool will provide me with detail information about fragmented dbspace? oncheck -pe Reports all extents by dbspace and what table each belongs to. Art S. Kagel…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
RE: Ontape -r
Did you roll forward all of the logical logs? If you do not do a complete restore of the system I believe you are required to roll forward all of your logical logs to make them consistent with the rest of your instance. Will >===== Original Message From "Anne Shelp" <shean@mcds…
Ontape -r
Hi all, I was testing the capabilities of ontape to read an archive. I restored our test database from the last tape. I took informix offline and ran ontape -r develop. Message returned that the physical restore of develop completed. The online.log follows. The problem is now w…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
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…
Re: Dirty LRU exceeding the LRU_MAX of 2%
Hi >Andrew Lawrenson wrote: >Kernoal.Stephens@AUTOZONE.COM wrote in message ><80csie$ad9$1@news.xmission.com>... >> >> >> >> >>Here is what I am seeing. In onstat -R the dirty q's are over 2% dirty. >>onstat -F shows all the flushers as Idle. >> >>I know I have seen this in the …
Re: Dirty LRU exceeding the LRU_MAX of 2%
More information to this problem. RAID5 is already being used before I started here please don't flame me for using raid5. Please send me the information about the use of raid5 so I can educate my sys admins. They think it is great. I have searched the iiug cdi but can not find …
Re: Dirty LRU exceeding the LRU_MAX of 2%
KAIO is on. I think the application is doing a lot of work and not commiting. Would this hold the buffers until checkpoint or until commit? "Art S. Kagel" <kagel@bloomberg.net> on 11/10/99 05:13:07 PM Please respond to kagel@bloomberg.net To: Kernoal Stephens/STS/AUTOZONE c…
Re: upgrade to IDS 7.30 UC2-1
From: "Ralf Peters" <RalfP.remove.@marlows.com.au> > >After we upgraded to version 7.30 UC2-1 IDS running under DG/UX 4.20, the >engine seems to run like a dog , nothing else has changed. it seems that >after running update statistics it is even worse . > >ONSTAT - R >Informix …
Dirty LRU exceeding the LRU_MAX of 2%
Kernoal.Stephens@AUTOZONE.COM wrote in message <80csie$ad9$1@news.xmission.com>... > > > > >Here is what I am seeing. In onstat -R the dirty q's are over 2% dirty. >onstat -F shows all the flushers as Idle. > >I know I have seen this in the post but cannot find it in search. > >…
DBSPACE / DBSIZE
I am forced to inherit and maintain and Informix database for now. I studied the Informix book(s) over the weekend and have yet to find what I need. I hope to be a master some day as well, but for now I need immediate help with these questions: How do I determine the c…
Strange ONCONFIG parameter situation....
Hi All, I am running IDS 7.31 on a HP-UX box(OS: HP-UX 10.20). A strange thing has just happened to me this morning. As a matter of course, I ran the command: oncheck -cR (to check the reserved pages) ......an error occured in the validation - the error I got was: Validat…
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…
onstat & SMI
Hi, does anybody knows what query (queries) I must run to produce same output as onstat -u command? I'm not sure for flags, which fields in SMI represents those flags. Thnx in advance.…
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: CPU usage problems when using KAIO in V7.3? on SINIX.
From: mike@inftec.be (Mike Aerts) I've forgotten where I was going on this one... :-) Still, let's see: (Can you resend these onstats after "normal" usage, too?) > > onstat -p > >Informixx Dynamic Server Version 7.31.UC2 -- On-Line -- Up 00:06:37 - > 76384 Kbytes > >Profil…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
DBSPACE Problem.
Hi , I am running informix 730 uc8 server. One of the DBSPACE status (dbase5) showing disabled. Server in Quiscent mode. I am unable shutdown or bring up to Multiuser mode. Actual size of chunk used for dbase5 is 2044 Mb but its not showing the correct size. Pl find the online…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Ontape -r failed
I am trying to do a restore of a level 0 backup. It is failing with an error "Physical restore failed - [db_sort ] Invalid DBspace list. I am getting this error eventhough the dbspaces and ids on the backup tape matches exactly to the dbspace list in onmonitor. Any ide…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
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?…
Onstat command
This is a multi-part message in MIME format. --------------DE4F14609E17179D45AF0716 Content-Type: multipart/alternative; boundary="------------73DD82890539D87E4735A41C" --------------73DD82890539D87E4735A41C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: …
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Increasing RAM problems
I have problems when I increased RAM from 64MB to 128MB (Dual Intel Pentium 133 MHz) informix.log looks like: Tue Aug 3 08:45:36 1999 08:45:36 Event alarms enabled. ALARMPROG = '/oms/InformixOn/etc/log_full.sh' 08:45:39 DR: DRAUTO is 0 (Off) 08:45:40 INFORMIX-OnLine Initial…
onstat -z
Is there any way to tell the last time someone ran "onstat -z"? This seems like it should actually be logged in the online.log file rather than having to rely upon my fellow DBA's to communicate the fact that they reset things. Especially when I have to monitor hundreds of syste…
error in OnLine initialization(can't create 'sysmaster'
Hi, plattform: Solaris2.5,IDS7.23UC1 After initializing OnLine,this is what is written in "online.log": 17:32:42 Event alarms enabled. ALARMPROG = '/informix/etc/log_full.sh' 17:32:43 DR: DRAUTO is 0 (Off) 17:32:44 INFORMIX-OnLine Initialized -- Complete Disk Initialized. 1…
# of chunks for a dbspace !
Hi Users, In an Informix IDS 7.3 / SAP 4.5B environment what is the maximum number of chunks that can be assigned to a growing dbspace. Thanks in advance Pramod ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
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…
onstat
Hello after executing an onstat following message appears in the first lines: "Changing data structure forced command termination" What does this mean? Why does the Profile (as in a normal onstat) not appear and the onstat view only shows me the sessid? Regards André…
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 …
logical logs at 100%
For some reason the networker software, legato is having some trouble - and the following output from onstat -l gives me concern. In the interim, while the legato software is being worked on, is there anything i should do ? do a fake level 0? INFORMIX-Universal Server Version 9…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
size of dbspace
Hi, I have a IDS 7.30 on solaris. I will transfer a import a datadase from NT environment. Which size shall I create for the dbspace for my database ? Thanks…
RE: Unixware 7.1 crash with Informix 7.30 UC2
Hi All, Our development machine used to run Informix 7.2 on HP UX 10.20, and we try to upgrade to Informix 7.3. The installation run OK, and the database service was available. But, then a few minutes later, the server rebooted. It happened few times, and we decide to return bac…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Informix 7.3 UC5 on RH Linux 5.2
I looked in /usr/include/sys/error.h and see that error 22 is related to an invalid argument of a program spawned by the init process. Call Informix support. Aris A <aris@mozcom.com> wrote in message news:7j5884$g4i$1@news.mozcom.com... When I tried to run "oninit -i" on my …
onstat options....
Hi Users, Which is the best site(s) / Book(s) to explain in detail all the columns of different options in onstat. There are a few changes in onstat results from 7.2x to 7.3.... so need something which explains all these. Thanks in advance, Pramod ___________________________…
Re: Online Config Changes
From: "Carlson@WHSmith" <carlson1@bellsouth.net> > >Not necessarily. The variables can be reconfigured within the ONCONFIG >file while the engine is up; they won't take effect until the engine is >bounced. There's quite a bit of stuff that can be set dynamically. For example, o…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
SCO & INFORMIX:Network driver cannot bind a name with the port
THANKS VERY MUCH TO EVERYONE responded. Especially to "Sistemas & Soluciones SRL" <sissol@amnet.com.pe> who drawn my attention to SEMMNU kernel parameter. Informix release doc says set it to 100. Well, with this value of 8192 I was able to get 653 threads through shared memory …
Re: onstat
In article <7hpivn$l4u$1@news.gte.com>, michael.talbot@telops.gte.com says... > Hello, > > Question from a unix/informix neophyte: > > > > When I issue the onstat command I get the following reply. Does anyone know how to resolve this? > > /tmp-> onstat > shared memory not initi…
Re: onstat
Either the environment variable INFORMIXSERVER is not set (or isn't set to the correct value) or the Informix database engine is down. What is the value of DBSERVERNAME in the ONCONFIG file? John Carlson Informix DBA WHSmith USA Hello, > > Question from a unix/informix neophyt…
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…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
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 ?…
Cleaners
Please forgive me if this is posted twice ----------------- Online 7.24UC3 Solaris 2.5.1 Given that Cleaners are assigned to chunks in the order that the chunks are created (and I don't know the order) how can I determine which cleaner from onstat -F) is assined to which chunk? …
DBA problems
I am able to connect to Online thru SQL or 4gl it runs fine. But whenever we try to run a 'MS-Query' the database crashes giving the message 'Connect failed'. The error no returned is 25587 which reads as follows - -25587 Network receive failed. A system call has failed. Do a D…
ONSTAT
HI folks, looking for help using onstat -g que I would like to know if Enterprise Replication is working I don't know the meaning of this output.. Any help will be really appreciated. Thanks Javier Puente…
onstat columns
Does anyone have a listing, even partial, of on onstat command column meanings? Informix's references are completely unhelpful, or nearly so, in describing, for example, what the "q-limits" column of "onstat -g ntd" means or how it's calculated, except for saying that the comman…
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: onstat -u / onstat -g ses Problem
Informix Netherlands advised to start the database with the environment variable SINGLESEG_OFF=1. Try it! Regards Hans Bosma Database Administrator NCCW(Netherlands Ing Thoralf Bihlo wrote: > > I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server > 7.30 UC6. >…
REQ: Problem with onstat -u / onstat -g ses
I´ve got an HPUX 10.20 / Serie 800 Server with Informix Dynamic Server 7.30 UC6. My SHMVIRTSIZE is 32k and onstat -g seg shows that I have just one Segment. When I try an onstat -u or onstat -g ses I get the Error: >Changing data structure forced program termination< during the …
unexpected error message
Hi, this weekend, I was tunning my database, and I changed the LRUs and CLEANERS parameter from 32 to 128. on startup, the engine showed the following message: Sun Mar 28 10:10:36 1999 10:10:36 Event alarms enabled. ALARMPROG = '/baan/informix/etc/log_full.sh' 10:10:42 DR: …
onstat -l
When my machine is blocked in a CKPT, onstat -l shows ... Buffer Waiting Buffer ioproc flags L-1 57c6ab54 0x1 0 L-3 57c69884 0x1 0 ... which is not documented anywhere. I can guess what it means, but does anyone know what exactly it means (and what flags ar…
checkpoint duration too long
Are your checkpoints as a result of the checkpoint interval being reached? (onstat -m, onstat -F). What are your LRU_MAX and MIN values? Neil liuzhao@371.net wrote in message <7dkhfa$a05$1@news.xmission.com>... > >plogdbs: 79.8M >llogdbs:600M >datadbs:1000M >my ONCONFIG file: >…
Dbspaces and indexes
Hello, Is it possible to determine what dbspace an index resides in? I know generally the index resides in the same dbspace as the table, but there are exceptions. There dont seem to be any utilities to tell you where the index resides. I am sure there is a query from the SMI …
Empty dbspaces.
When I clear a dbspaces, solely in use for tables from tables with "alter fragment ...." then I see with onstat -d that the dbspace isn't completely empty however looking in the sysfragments tables for the datbases I found the dbspace isn't in used. Also oncheck -pt shows me that…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Rename a dbspace
v7.24 UC6 on HP-UX 10.20: Does anyone know if this is simple? The reason I want to do so is that I need to move a large database from one server to another, with onunload/onload. There is a (glaring) bug in onload whereby you must load the database into a dbspace with the same…
tables in dbspace
Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska…
IDS v7.24 UC6 onload
I had a strange situation using onload. I wanted to copy database A from Server 1 to Server 2. I used onunload to unload the database (on Server 1 it resided in dbspace X). When I tried to onload it into Server 2, specifically into dbspace Y, the load failed with a "no such db…
Re: --- URGENT ---- URGENT --- URGENT ---
--Boundary_(ID_M4M3EvWp+U0+L035cVHHMg) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Arturo Hope you have a backup. Looks like the instance was reinitialized (oninit -i) because sysmaster database was rebuilt. If you have…
--- URGENT ---- URGENT --- URGENT ---
This is a multi-part message in MIME format. --------------7CBD6C89E2D53C1C9B4072F6 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a serious problem: my company database has disapeared. The last thing I know, was a change sugested by an infor…
priority question
Hi everyone. Can the priority be raised on a particular session? For instance, if I have this onstat -u: INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 57 days 00:27:52 -- 224688 K bytes Userthreads address flags sessid user tty wait tout locks nreads nw…
Re: Blocked:CKPT-dbimport hangs
Olaf <bjv@wsx.wsex.com> wrote: One thing is obvious from your 'onstat -l' (and from very frequent checkpoints also) - your physical log is 75% full. > Physical Logging > Buffer bufused bufsize numpages numwrits pages/io > P-2 0 16 26285 1734 15.16 > …
? on DATA REPLICATION
Girish.B.Manmadkar@bankamerica.com wrote in message <7acm54$d5v$1@nnrp1.dejanews.com>... >Hi there !! > >I have couple of questions for new DATA REPLICATION site here... > >1> Do I really need to have mirrored chunks in DR ? Oh yes !! rootdbs, phylogdbs & datadbs minimum on the…
Re: onstat -F output
This reinforces the idea from yesterday, that you do not have enough pages updated between checkpoints to force LRU writes, given your current settings. Note that during the measured period, you have only 66,897 page writes. Owing to the imprecise amount of time ('almost an hou…
Re: onstat -F output
On Fri, 12 Feb 1999 richard_kofler@my-dejanews.com wrote: > In article <79v8ge$d5j$1@news.xmission.com>, > Joseph Cullipher <joseph@cannonexpress.com> wrote: > > > > Hi all, > > I have Informix 7.30.UC2 running on SCO 5.04 and have noticed this on > > my onstat -F output > > >…
Re: onstat -F output
> Hi all, > I have Informix 7.30.UC2 running on SCO 5.04 and have noticed this on > my onstat -F output > > Fg Writes LRU Writes Chunk Writes > 0 0 18463 > > address flusher state data > 874484c4 0 I 0 = 0X0 > 87448974 1 …
onstat -F output
Hi all, I have Informix 7.30.UC2 running on SCO 5.04 and have noticed this on my onstat -F output Fg Writes LRU Writes Chunk Writes 0 0 18463 address flusher state data 874484c4 0 I 0 = 0X0 87448974 1 I 0 …
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
RE: onstat -t
onstat -t shows tblnum in hex. So you can link it with hex(partnum) of systabnames to get your tablename. HTH Sathish -----Original Message----- From: David Tamburin [mailto:david.tamburin@protegrity.com] Sent: Wednesday, January 27, 1999 4:16 PM To: informix-list@iiug.org Subje…
onstat -t
Hello, Is there anyway to tell what the actual tablenames are when you execute a onstat -t ? I know that tblnum is the tablespace number, but what can this be related too to tell me something useful? Thank you david.tamburin@protegrity.com david Tamburin…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
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*.…
checkpoint time > 15 sec.
michael wallace wrote: > > I am currently running informix 7.3 on an IBM S70 with 2GB men and 4 > CPU's, and 10 mirrored ssa 4.5 GB disks. > CHKPTINVL 300 > LRU 8 > LRU_MIN_DIRTY 2 > LRU_MAX_DIRTY 3 > PAGE_CLEANERS 4 Recommendatations are hard without more info li…
dbspace full
Hi friends , Now we face a problem , a dbspace is full but we do not want to add disk space for this dbspace , there are 4 databases located in this dbspace , I know delete rows in the tables will not release the spaces , we must drop some tables or do the tbcheck/dbexport/dbimp…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
What is "listener-thread: err = -952" in online.log?
Hello, What causes the following error "listener-thread: err = -952" in online.log? Thanks in advance Greetings, Ditmar den Engelsen ------------------ Message Log File: /informix/ONLINE/online.log 01:00:00 listener-thread: err = -952: User's password is not correct for th…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Server Initialization on IDS 7.30
Is Enterprise Replication involved? If so, this sounds like the server used to exist and the other servers might be trying to issue a cdr_connect. Alanoly Andrews wrote: > Hi, > > Can someone explain the following strange behaviour of IDS 7.30? > > Hardware: IBM S70 > OS: AIX …
dbspace error
hi all: I accidentaly delete the chunk filr for a dbspace, now I droped the database, when I try to remove the dbspace, it gives me a internal error. How would I delete a dbspace while it's chunk file is gone? thanks yan…
Server Initialization on IDS 7.30
Hi, Can someone explain the following strange behaviour of IDS 7.30? Hardware: IBM S70 OS: AIX 4.3 Informix: IDS 7.30 In trying to bring up a Server for the first time with "oninit -i", the server does come up, but without the sysmaster db. The log contains several pages of th…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
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…
Tables in dbspaces
Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve…
unloading a dbspace
I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database which has tables spread across 9 dbspaces and two of them are smart blob spaces. What I would like to do is to unload each dbspace, copy the file to another instance of online to restore into a dbsp…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
onstat -u
I was running an 'onstat -u' command and have been receiving the following message: "changing data structures forced command termination" I was wondering if any of you have seen this message and might know what it means and how to correct it? David Meyer Guerilla Software…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Database Partition
Ravi Verma wrote: > I have the following questions regarding Database Partitioning. > > 1. Is it possible to take one or more partition off line while the table itself is online? Yes. You need to set the DATASKIP on. However, if there are other tables or partitions of other t…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: DBSCHEMA doesn't show the DBSPACE????
roger.bruening@metrokc.gov wrote: > > When running DBSCHEMA, the only table that shows the dbspace that it was > placed on is one where a fragmentation scheme is in place. As I recall, the -ss option will show the dbspace name for all tables other than those that reside in the "…
onstat -h
Does anyone have any info about the meanings of the output of the onstat -h (hash chain info) in IDS 7.3? It's not in the hardcopy or in the 7.3 Admin manual, and I'm trying to document it. Thanks, joe -- -------------------------------------------------------------------------…
Attaching VP CPUs to real CPUS on AIX
Hi I am experimenting with the /usr/sbin/bindprocessor command on aix 4.1.5 to pin VP CPUs to real CPUs on an 8 CPU RS6000. What real benfits does this provide ? Does it ever screw anything up ? ( I had a down system today after changing too many things at o…
Re: Attaching VP CPUs to real CPUS on AIX
Graham mitchell wrote: > > Hi > > I am experimenting with the > /usr/sbin/bindprocessor > command on aix 4.1.5 to pin VP CPUs to real CPUs > on an 8 CPU RS6000. > > > What real benfits does this provide ? > Does it ever screw anything up ? > ( I had a down system t…
onstat commands
Does anyone know of a source that describes all of the onstat commands? The 7.x manuals are pretty good, but some of the explanations are a bit brief. ==================================================================== Harold Luse Phone: (970) 491-4120…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Table corruption after system reboot
Hi all, I'm running Informix OnLine 7.12.UC1 on aTandem CM 1450 NonStop-Ux B32 IPM 10. Rebooting the system after a regular shutdown ( Application shutdown, Informix shutdown (onmode -ky), UNIX shutdown), I got the errors as shown in the following logs. The table involved is …
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Removing a chunk
BlackStar escribi�: > Is there anyway I can remove a chunk from a DBSPACE without deleting > the DBSPACE? Can I do it online? > > Thanx > Standard Disclaimer You should use "onspaces -d <dbspace> -p <chunk-pathname> -o <offset>". And remember that the chunk must be empt…
Removing a chunk
Is there anyway I can remove a chunk from a DBSPACE without deleting the DBSPACE? Can I do it online? Thanx Standard Disclaimer…
onstat
I tried to run onstat not as user informix and i got onstat:Share memory:permission denied. The env. looks fine , the informix server is up. I am running 7.23. You have to have Informix priv. to run onstat ? Thanks Gabriel Weisz…
Re: onstat
Gabriel Weisz wrote: > > I tried to run onstat not as user informix and i got > onstat:Share memory:permission denied. > The env. looks fine , the informix server is up. > I am running 7.23. You have to have Informix priv. to run onstat ? No. Check the permis…
Onbar with Online 7.23
I'm seeing a strange problem with on bar (Av 20000 / Ux 4.20) under v.23 When i issue "onbar -r", i get the following in the log (there included a page that contains the description of the log file) for example : If the backup finished at logical log 36 and then i issued "onbar -…
online 7.2 problem !!
This is my online.log last lines afer init online 7.20 : 11:08:01 Error: Unable to reset open files limit, must run as super-user 11:08:01 Event alarms enabled. ALARMPROG = '/opt/Informix/V7/etc/no_log.sh' 11:08:02 DR: DRAUTO is 0 (Off) 11:08:02 INFORMIX-OnLine Initialized …
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
onstat -t output
Hi, The output of onstat -t shows zero in the column 'nrows' , whereas ' nused ' and 'npdata' have non-zero values . Why is this so ? TIA Sathish…
DBSPACE - DATABASE
in which "systables" can i read the relation between dbspace to databases????…
Dbspace Question.
Hi, I'm sure of the 6 dbspaces assigned to a perticular database. Also I'm sure that no other tables from any other databases are residing there. When I drop that database and look at the chunks, I get the following output. 99d04108 35 20 0 1000000 998796 PO…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Onstat -R
Hi Roger, The onstat -R commadn give you the listing of the LRU queue's and there status. Eachr LRU queue consists out of two parts. A free and a modified list. The letters f and m indicate wheter it is a f(ree) or m(odified) queue. The LRU length is the numer of pages that are …
Onstat -R
Can someone explain the onstat -R headings.. Is the percentage free or used. Been digging thru the texts.. examples but little explanation? INFORMIX-OnLine Version 7.24.FC4 -- On-Line -- Up 4 days 17:40:47 -- 36320 Kbytes 8 buffer LRU queue pairs # f/m length % of pair…
oninit problem, create_vp: cannot allocate memory.
Hi there, When I oninit, the database is working OK, but the online.log has some errors as following: Wed Jun 10 09:53:05 1998 09:53:05 Event alarms enabled. ALARMPROG = '/local/informix/log_full.sh' 09:53:08 DR: DRAUTO is 0 (Off) 09:53:09 INFORMIX-OnLine Initiali…
dbspace question
Currently my dbspace is spread over 5 different chunks on several small and slow hard-disks. After replacing these disks with a larger and faster one, is it a good idea to merge the small chunks into one large chunk ? If yes, is there an easy way to do that ? Detlef Liem…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
onstat -g ...
Hi guys, Where I can find explainations about the output format (headers and key words) reported after executing onstat -g ... In the Informix Administrator's Guide there is an explaination of all other options of "onstat", but for "-g" option I did not find detailed informati…
onstat -k
Thanks to everyone who answered the onstat -k tblsnum question. I appreciate it. ==================================================================== Harold Luse Phone: (970) 491-4120 Veterinary Teaching Hospital Fax: (970) 491-1275 Colorado S…
onstat -k
How would one link the tblsnum field of an onstat -k with a table name? Locks address wtlist owner lklist type tblsnum rowid key#/bsiz 3008c64c 0 4004a354 0 HDR+S 100002 230 0 3008c680 0 40042814 0 S 100002 22f …
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…
onstat -u
Here's a good question. Sample: 4004d214 Y--P--- 4999 dbolte 91 40c936d8 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 …
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…
onstat and tbstat
Hi, We have just upgraded from 5.x to 7.x. Those tbxxxx files are now onxxxx files, but they still exist lots of tbxxxx like tbstat, tbmonitor, and so on, are these files different from the new version onstat and onmonitor or they are the just the same but with different names??…
Create Index Problem.....
Hi, I've created one databse in a perticular dbspace with one table. If I create an index on that table using 'in dbspace' clause, sysextents table in sysmaster database reports it But if I create the same index without 'in dbspace' clause, it doesn't report it. Why ? ? Abhay …
dbspaces question ....
Hi, Environment : OSD 7.23uc4 HP-UX 10.20 We have all 2Gb disk chunks ( told by Unix Admin to me ). I tried to run onspaces command for the size more than this and I found that I can allocate 2.048Gb Also existing allocation of disk space leaves gaps of few Mb in be…
Re: Database DBSpace
mbaumgartner@cardhealth.com wrote: > > I have a database created in a non-root dbspace. I would like to relocate the > database, not any tables, to another dbspace without unloading/exporting the > database. Is it possible to relocate a database to another dbspace? > > Mark Bau…
Dbspace Question ----
Hi, If there are 2 informix servers on one machine and I create a dbspace for the first server which overlaps one of the dbspaces for the second, what will happen ? Does it gives error or I'll loose the data ? Thanks in advance. Abhay Mannur.…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
memory, rootdbs problems
I had an informix DB up and runing on a HPUX 10.20 system running through Livewire and Netscape Enterprise Server 2.01 to publish data to the web. I had to rename the system (new ip and hostname) and remove the external Jaz drive and now my informix db engine wont work anymore. …
Database DBSpace
I have a database created in a non-root dbspace. I would like to relocate the database, not any tables, to another dbspace without unloading/exporting the database. Is it possible to relocate a database to another dbspace? Mark Baumgartner Cardinal Health…
mirroring
What dbspaces should I mirror? Of course rootdbs is a give. thanks…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
Re: Virtual Shared Memory increases with Online/Optical
I have had several Informix engineers suggest that running onmode -F while the system is under load is a VERY risky thing to do. Under some circumstances, the request for memory can hit before the command to release finishes executing. BOOOMMMMM!!!!! -d David Williams wrote i…
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…
Re: onstat -d,onstat -D
I believe it in indicates that table in dbspace has been dropped. -Lin "Tony_Reynolds(Accounting & Purchasing System") <tr-2959@mail.necgroup.co.uk> wrote: > Can anyone tell me the difference between a dbspaces address with a > flag of 1 and a dbspaces address with a flag of 100…
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: change log size
Hi, Chi-fung You can change the size to edit the onconfig file,$ONCONFIG file in the $INFORMIXDIR/etc/ or to do "onmonitor" of command following is the file: ...... # Logical Log Configuration LOGFILES 15 # Number of logical log files LOGSIZE 500 # Logical log size (Kbytes) …
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…
Onstat Utility
Hi, I'm using onstat -g ath and see threads that are slleping forever. What could this be? Are users not exiting properly from Informix? How do I kill these processes. Thanks Bob…
onstat and threads
Hi, I'm run onstat -g ath and I see threads that are sleeping forever. Do I kill these processes and what could it possibly be from. Users not exiting properly? Bob…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: onmode -F
In article <33A6805F.167E@uk.ibm.com>, Daniel Williams <danny@uk.ibm.com> writes >Zeljan Silje wrote: >> >> Hi, >> >> in "Performance Guide Version 7.2" I found recommandation to run onmode >> -F using cron facility. >> Does anyone has experience with this, and how often should I…
Re: onmode -F
Zeljan Silje wrote: > > Hi, > > in "Performance Guide Version 7.2" I found recommandation to run onmode > -F using cron facility. > Does anyone has experience with this, and how often should I execute > onmode -F using cron? > I am using Informix OnLine7.22 on AIX4.2. > > Thanks …
Re: UserID/Password error.
In article <5nq0m7$1n8@cssun.mathcs.emory.edu>, Rajesh Koilpillai <rajeshk@hcla.com> writes >Hi > > I have tried all the suggestions which some of u have suggested. > But still i get the following error in 'online.log' when i try > to start my server on a Solaris …
UserID/Password error.
Hi I have tried all the suggestions which some of u have suggested. But still i get the following error in 'online.log' when i try to start my server on a Solaris 2.51 machine. - Rajesh Email : rajeshk@hcla.com 15:32:51 Error: Unable to reset open files limit, must run…
Re: Hit 956 error when bring up informix Online Dynamic Server
Walter, Thanks. Problem solved after add in "singsun2.sing.cig.mot.com" in the hosts.equiv. Walter S. Tyszka wrote: } } > Hello, } > } > When I startup informix online dynamic server (version 7.12.UC1), it } > always give warning message saying Network deamon is down. I get th…
Re: Hit 956 error when bring up informix Online Dynamic Server
} Hello, } } When I startup informix online dynamic server (version 7.12.UC1), it } always give warning message saying Network deamon is down. I get these } messages in the online.log: } } : } 19:09:42 Dataskip is now OFF for all dbspaces } 19:09:42 Quiescent Mode } 19:09:42 …
Hit 956 error when bring up informix Online Dynamic Server
Hello, When I startup informix online dynamic server (version 7.12.UC1), it always give warning message saying Network deamon is down. I get these messages in the online.log: : 19:09:42 Dataskip is now OFF for all dbspaces 19:09:42 Quiescent Mode 19:09:42 Checkpoint Complet…
Re: Onstat question
}> }>When we use the Onstat -u , sometimes we get this display: }> }>onstat -u }> }>INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes }> }>Userthreads }>address flags sessid user tty wait tout locks nreads nwrites }>332c020 -…
Onstat question
When we use the Onstat -u , sometimes we get this display: onstat -u INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 332c020 ---P--D 0 inf…
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…
onstat options
Hi, What are the best indicators of response time, trans/sec, and general load for monitoring an informix database... using the onstat program? Any help would be appreciated. Thanks Mark~…
Re: onstat
Steve Romankiw wrote: } } In onstat, what does "total" refer to. } } . } . } 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } 0 } 13 active, 128 total, 44 maximum concurrent } } Thanks. } } Steve Romankiw } Executive Risk Inc. For Online 7.1, the total fi…
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…
Re: onstat
Carol Davies wrote: } } Steve Romankiw wrote: } > } > In onstat, what does "total" refer to. } > } > . } > . } > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 } > 0 } > 13 active, 128 total, 44 maximum concurrent } > } > Thanks. } > } > Steve Romankiw } >…
Re: onstat
Steve Romankiw wrote: > > In onstat, what does "total" refer to. > > . > . > 1192132c Y--P--- 537 winterm - 12434068 0 1 240 > 0 > 13 active, 128 total, 44 maximum concurrent > > Thanks. > > Steve Romankiw > Executive Risk Inc. From the Informix Administrat…
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…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
Re: Slow system ?! - using Informix 7.x on Sun Sparc 1000
I agree on the LRU MIN/MAX - I have one database set to 2/4. I think, however, the 300 secs on the checkpoint int is ok, and doesn't let your database go too far into left field between checkpoints. Use onstat -F to see how many LRU vs. Chunk(checkpoint) writes you are doing. Se…
Re: ONDBSPACEDOWN config parameter
At 08:30 AM 1/22/97 -0500, you wrote: >Recently, I discovered the importance of the ONDBSPACEDOWN parameter in >ver 7.1. When performing a warm restore on a non-critical down chunk, >our users began complaining of problems. We found the hard way that our >ONDBSPACEDOWN was set …
Removing a DBSpace
I'm having some trouble removing a DBSpace from an old Online 5.0x server. I created a temporary space to test some things, finished the testing, and deleted the database I had created, but it complains that the space isn't empty. Here is the "tbcheck -pe" output: Chunk: 4 …
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
dbspace
Hi Before I was hired, another non-DBA SA wrote a script: create database coris that went to rootdbs automatically, I believe It showed as Database Name Owner In Dpspace When Created Log Status coris informix rootdbs 01/24/96 B but It should be Database Name Owner I…
onstat documentation
Does anybody have any good documentation for onstat? In case it varies to much from one version to the other I have online 7.11UC1. thanks…
Drop db chunk
At one time, I accidentally add a chunk to a wrong dbspace. Is there a way to remove this wrongly added chunk so that the chunk may be allocated to the right dbspace? Edmund To an Informix novice Chinese University of HK…
AW: What happens when ?
Hi, One possible solution is to dump the correct dbspaces with dd on tape. After restoring the correct archive, it might be possible to overwrite the restored dbspaces by dumping the dbspaces back.(This works with Infomix 5, maybe with 7) Robert…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
Re: problems initializing
In article <4qm7tq$um3@portal.gmu.edu>, Alwyn E Goodloe <agoodloe@osf1.gmu.edu> writes > Has anyone using Informix ONLINE Engine 7.10 UD1 running under SCO 3.2.5.0 >(ie SCO V) had the following when trying to initialize(oninit -iy). > > We basically can't get anyof our systems …
problems initializing
Has anyone using Informix ONLINE Engine 7.10 UD1 running under SCO 3.2.5.0 (ie SCO V) had the following when trying to initialize(oninit -iy). We basically can't get anyof our systems up and are stumped!! Informix has not been of much help so I thought I would put it out on …
Fraged Tables/Onunload 7.13uc1
If a table is fraged across multiple dbspaces, and the indexes are created in a different dbspaces of its own, will onload work successfully if the table was droped and then reloaded? I know I can specify the dbspaces in which I want to load the table on the command line, but wh…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Informix v7.x Problem on Digital Unix: 2GB Limit
I think that you can solve the problem by creating a dbspace composed by 2 or more chunks of 2 Gb. Then, when you create the database you must specify this special dbspace. The load of the information will work fine! Bye Paulo Nunes (p.nunes@mail.telepac.pt)…
HELP Upgrade from 5 to 7
HELP, 02-Apr-1996 I am trying to upgrade from 5.06.uc2 OnLine to version 7.11.uc1 on a Sun running Solaris 2.4. Informix delivered the "INFORMIX-OnLine Dynamic Server Migration Guide Version 7.1" and I tryed to do the upgrade as described in this manual. One of the ste…
Temporary dbspace
I have created a temporary dbspace. It is referenced by the onconfig file parameter DBSPACETEMP. It was made larger recently because our reports explicitly create temp table using the "WITH NO LOG" option and the temp tables created by 2 specific reports can get pretty big. It i…
ONSTAT question
Hi there. onstat -u (version 7.1) sometimes shows a user thread with position 1 of the flag field set to Y. The Informix manual says it means "Waiting for condition". I cannot find anything else. What is a condition, and why is my thread waiting for it? Thanks for any help Ba…
Re: Q: Memory Leaks with cursors
Thanks to all who posted me messages. Really, freeing the cursor solved the problem. One moment to add. After freeing cursors Informix doesn't fully frees memory. Perhaps is't usefull from time to time (once 10 or 30 or 60 minutes) to issue 'onstat -F' on UNIX. Best regards, Mi…
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.…
online crash
Dear All, I have come across this problem with online 7.10.UC1 on a Spacr 5 running Solaris 2.4. I have a cursor that does a count on 1 table with a where cause of 1 = 1. The count works but when the cursor is closed it brings the engine down (see online log below). This progra…
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...…
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…