Oninit® Archive
Results for “onstat -g sts”
What is the load on an individual listener or sqlexec thread?
this help at all ? The CPU time shown for a thread is updated each time the thread yields and is based on the change in clock time since the thread last started. For threads such as the poll threads, which spend the majority of their time in an OS call such as s…
Segfault since CSDK 4.50.FC10 with LVARCHAR and CLIENT_LOCALE different from DB_LOCALE
I will open another thread for ifx_var_init() usage. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
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 ------------------------------…
ESQL/C conversion error with CLVCHARPTRTYPE
Hello Andreas! Thanks for your answer. I will open another thread for the new issue one of a customer has detected. Seb ------------------------------ Sebastien FLAESCH ------------------------------…
flags (onstat -g ses)
That's the same set of flags as in ' onstat -u ' I'd say. For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one. ------------------------------ Andreas Legner ------------------------------…
Slow Running Query
If like multiple rows , then how can be checked which thread id we need to compare ? Regards Amit P ------------------------------ AMIT PATEL ------------------------------…
User Defined Routine (UDR) example required - OSAD Array
Hi Paul, I just changed the FUNCTION registration adding STACK=65536 and PARALLELIZABLE (I remember you suggested that in an email), and I am also now running the SQL statement after ISOLATION DIRTY READ as I had the filling the engine is trying to put that huge SELECT as a trans…
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…
Not sure if I have a problem with CKPs
Sorry. My reference to Madison's comment is this thread: http://members.iiug.org/forums/ids/index.cgi/read/31286 DG…
blocked records
Use "onstat -k" for threads holding locks and "onstat -u|grep L" for sessions waiting for a lock…
Bufferpool configuration
Hi, a recent thread titled "BUFFERPOOL Configuration" dealt with most of these issues. Ben.…
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…
Using complete CPU core instead thread
Hi, is it possible to configure informix to use the whole core per VP instead of only one thread using affinity ? Let's say that now we have cpu=6,aff=(0-5),noage Condidering that there are 2 threads per core, if I configure informix to use only one thread per core, would it use …
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
sid vs pid
Thanks. I thought the process ID was for a DBMS process. I probably had process confused with thread.…
Update Statistics
If you are seeing wait() at the top of the stack, then that means that the process is waiting on an IO completion. If you are constantly seeing wait() on top of the stack, then that implies that there might be a configuration issue. Perhaps your buffer size is too small, or your …
How to avoid blocking checkpoints?
Dear Friends: Many thanks to all who helped me, such as Art Kagel, Jacques Renaut, Andreas Legner, etc. My configuration was as follows: ############################################################# # Shared Memory Parameters LOCKS 200000 # Maximum number of locks BUFFERS 300…
Chunk symbolic links
It's rootdbs. Issue is solved, there was a problem with the link file. This thread can be closed. Thank you.…
Execute SQL statements in parallel (esqlc)
Thank you John & Sathyanesh for the quick responses. I will take a look at the writing the esql/c thread routines. Regards, Steve…
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)…
Hyper threading
IDS 12.10.fc5 IDS 9.40.fc5 Aix 6 and 7 We have just moved our Informix systems to a Power 8 system ... previously we were on a Power 7. I remember something from last years conference about Hyper threading ... and if it should be used or not ... but I don't remember .. nor can I …
Error System Block
Double your stack size ? <quote> 14:13:53 Assert Failed: yield_processor: Stack overflow in thread 67767 </quote> The stack trace from the af is always useful, if you are using datablades and/or custom UDRs the default stacksize is usually too low Cheers Paul -----Original Me…
opentable memory leak
Original post: No AUTOINDEX as far as I can tell. Turning off PDQ avoids the issue and I can live with this until permanent fix is found. Thanks, Andrew Response: It's a APAR in 12.10.xC5. APAR IT09544. The description talks about auto-index path, but the real trigger is an…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
ISAM error: illegal key descriptor (too many parts
IDS 11.50 FC2 HP UX 11.23 Noticed below errors while running onchecks on a couple of databases. Dropped and re-created the indexe. Would like to know the cause for these bad index pages. Data in these tables are 10 years old. HP confirmed no hardware issue. Everything seems to b…
btscanner running v/s ready
Thank you Art. I believe the active (running) threads also don't run too long, they just get captured by the monitoring as a coincidence. I will monitor for the behaviour that you explained to ensure the active threads of btscanner don't run too long.…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
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,…
Sequences & Locks
Hello We hit a table extensively (and with multi threaded) for a next key value to be returned and of course it is running into deadlocks, etc. We are looking to move this to sequences - are there locks involved with sequences in a multi threading scenario? thanks tom…
Threading in Informix 4GL
Hi, in the context of: Informix 4GL 7.50 Without C/Java procedures. Without RUN external program. Can i EXECUTE a prepared statement (an insert) whitout waiting for the result or the error, like doing it in other thread. There is an insert in a table for statistic/logging p…
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…
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 …
informixdb & threading?
Has anyone used informixdb [1] (to acccess an Informix engine) with threading? Even if I allocate separate connections local to the threads the application immediately seg-faults or dies with a massive stack trace. [1] <http://informixdb.sourceforge.net/> Python 2.7, openSUSE 1…
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…
infos about waitstates
On 18 Jul., 09:07, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi, > > I'm searching for detailled informations about waitstates and how to > interpret them and how to react. > > Examples: > > buf ready > > aio > > mt yield n > > running > > buffer > > m…
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.…
Single threaded vs. Multi threaded
Wow, it's been a while since I worked on Informix 5 :-) In Informix, Version 5, UNIX controlled everything. For each user that connected, a process was created and UNIX controlled process switching. This is a single-threaded architecture model. Due to the size of servers back wh…
Scheduler Error
I did end up having to restart the server in order for the AUS Refresh task to run. Now, the real problem is that the dbworker threads failed again (after about half of the update statistics statements) with the following message in the log: 22:07:25 SCHAPI: thread dbWorker1 tas…
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…
proper way to create rawdevices in Red Hat Enterprise 5.5
This is unnecessary and will quite possibly be slower. See other recent thread: https://groups.google.com/group/comp.databases.informix/browse_thread/thread/61a4908ebbadb977 Regards, Doug Lawry…
Memory Management
oh..also think around 300 threads connected to this database.…
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…
Re: Slow OS calls on one chip type - resolved!
<david@smooth1.co.uk> wrote in message news:b570f216-1b06-487a-bf71-598ca121de34@a16g2000vbr.googlegroups.com... On 19 May, 18:39, "Neil Truby" <neil.tr...@ardenta.com> wrote: > "Neil Truby" <neil.tr...@ardenta.com> wrote in message > > news:82pgrnFo58U1@mid.individual.net... > >…
thread bp_priosweep
what exactly does this thread? have something with LRUs priority??? Is it tunable? $ onstat -u IBM Informix Dynamic Server Version 11.50.UC6W2 -- On-Line -- Up 00:30:34 -- 915248 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites .... 5c06ad0 Y--P--D…
System.FormatException with CSDK 3.50 TC4DE
Changing the Thread's CurrentCulture to Invariant Culture fix this: System.Threading.Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture; Ty.…
Buffer Waiting ( onstat -l )
The number of times that threads (sessions) had to wait to obtain a buffer. It's measure of system concurrency.…
soctcppoll and soctcplst
Hi, What is the difference between a thread called soctcppoll and soctcplst ? I'm confused with the output of onstat -g ath…
User thread
I'm using Informix 11.5 developer edition and some Windows services are acusing an ODBC error (Cannot create user thread). Informix is installed on Windows. What can I do to fix up this problem?…
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…
Assert Failed iserr = 124
Hi All, Our IDS v7.31 ud8, which is a HDR secondary pair failed suddenly and was found in a hung state. I had to recycle the engine to bring it up and now its running fine. This has occured second time within last 2 months. But I could not analyse the reason from af** files. on…
Physical CPU Statistics
Hello, We are using SunOS 5.10 Generic_125100-09 sun4v sparc SUNW, Sun-Fire-T200 machine. That is 6 Core with 4 threads/Core machine on which multiple IDS instances are running and each instance is using separate threads of each core. Is it possible for us to find out that which…
ida11.5 FC5 help
/home/informix/bin/onstat -g sts: IBM Informix Dynamic Server Version 11.50.FC4 -- On-Line -- Up 43 days 14:56:59 -- 4532148 Kbytes Stack usage: TID Total Max Current Thread Name bytes % bytes % 2 65536 2671 4 1616 2 lio vp 0 3 65536 2671 4 1616 2 pio vp 0 4 65536 4455 6 1616…
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…
how to force disconnect user threads?
How can I force disconnect user threads from Informix IDS? Thanks.…
await_MC3 ??? How release a thread?
Hi Folks, We migrate a server to 11.50 FC4 on Solaris 9. Some queries which runs on a table stored in 17 dbspaces by round robin with detached indexes are running very slow. If we search only the index it runs well, but if i increase a column who is not in the index, it runs v…
Question about the status of the thread
Environment: Informix 7.31 64 bits HP-UX 11i Hi, I see the output of onstat -g ses and I have one question. Please, anybody knows which is the diference between the status "sleeping(Forever)" and "sleeping(secs: 2)" ? When is "forever" and when is "secs: x" ? Thanks in advance.…
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 …
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…
LTAPEDEV to /dev/null from onmonitor
Kindly Ignore this as another thread is open with same content.…
syspools
>IDS11.10 UC2, AIX 5.3 > >Run the following query on syspools, and attached the partial result list. > >po_name "mt" occupied much of the memory. > >what "mt" means? what is the major jobs of "mt"? > >Thanks, Frank I belive the "mt" stands for Multi-Thread. That pool would be us…
Re: sqldetach not returning
> What is the stack for the thread calling sqldetach and the output of > onstat -g stk <tid> for the corresponding IDS thread? i´ll try to collect this information when the problem happens again.…
listener-thread: err = -27001
Hi, Guys, Build Version: 11.10.UC2 Build Number: N158 Build Host: vach Build OS: AIX 5.3 Build Date: Thu Oct 25 22:56:40 CDT 2007 GLS Version: glslib-4.50.UC2 We repeatedly receive the following error msg in online log, 19:43:34 listener-thread: err = -27001: oserr = 0: errstr…
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…
Re: Weird one
You lost me there Gumby. Never heard of cpu's having stacks. I've heard of processes having stacks and threaded processes actually have multiple stacks. Maybe you can elaborate what you mean? On Sep 25, 10:17 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just out of curi…
RE: Weird one
Your grandmother must have loved you - did she eat a lot of eggs ? Paul Watson Tel: +1 913-400-2620 Mob: +1 913-387-7529 Web: <http://www.oninit.com> www.oninit.com Failure is not as frightening as regret. If you want to improve, be content to be thought foolish and stupid. …
RE: Weird one
Solaris isn't Linux and there are a lot of potential differences under the cover even if both OSs are POSIX compliance. Get down low enough, there are even differences in the same OS but on different hardware platforms. (I don't think your book deals at that level.) There are a …
Re: Weird one
Read the Solaris Internals book by Jack Mauro ??? Ian Michael Gumby wrote: > Just out of curiosity, and this may not be at issue... > > On a multi-core /smp Linux box, does each CPU have its own stack or does > it share the same stack? > > If they share the same stack, how does …
Weird one
Just out of curiosity, and this may not be at issue... On a multi-core /smp Linux box, does each CPU have its own stack or does it share the same stack? If they share the same stack, how does one track to see if their are thread contention issues. Meaning if Thread A from the s…
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…
Re: threads still running?
If the routine contains a query sufficient complex to benefit from parallelism or from fragment elimination and you wanted those options to be always available to any user no matter what their current PDQPRIORITY is. This problem is why my dostats utility resets PDQPRIORITY to z…
RE: threads still running?
Thanks.I see now that that was the problem. The script that updates stats had set pdqpriority 80 at top and never change it before it updated stats for 'routine'. What would be an example of "routines that are known to require PDQPRIORITY set" ? I mean what type of task would th…
threads still running?
This involves ids9.4.tc2 on windows 2000 server. I have been trying to find out why so many connections are open on a server that has at most 20 users on it and the onstat -u may show something like: 2053 active, 2688 total, 2648 maximum concurrent. If I do "onstat -g ses" an…
Re: net statistics from shared memory ?
On 6 Aug, 20:10, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > We are currently running our c programs through esqlc and also shell scripts. They attach to the database SERVER that is associated with shared memory. > > In the near future we are going to separate the database …
segmentation fault with c4gl
On Mon, Aug 4, 2008 at 10:35 PM, KIRAN KUMAR <kirang001@hotmail.com> wrote: > The renamed code is exactly the same replica of the existing code. It looks > into the same data set. At first, I too expected the same problem of array > bounds and increased the array size to a good e…
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…
View thread info?
Hi Experts, We use an informix database as database layer for an ERP application. We encounter high CPU usage of the informix server while the ERP application is hardly used (low number of active users). The high CPU load always starts at the same timepoint in the morning and en…
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.…
Parameter tuning?
Pls see the instance profile and shared memory parameters below. The problems I noticed are 1. low read-cache-hit 35% 2. low write-cache-hit 79% 3. a lots of bufwaits and seqscans What do you advice? Informix Dynamic Server Version 7.31.UD3 -- On-Line -- Up 158 days 02:30:01 --…
IDS 9.4 multithread help with new hardware
I am looking at a Sun cool thread server to replace a Sun v880 server that is going back on a lease soon. My interest in the cool thread server is power/heat reduction. We have a small computer room that has maxed out our air conditioning. I am being told the cool thread server…
informix 9.3 to 9.4 issue
Hello, I'm having some serious issues with a production instance of Informix and I can't figure out why. I'd been running 9.30.UC7 for over a year solid, no complaints. Monday night, I installed 9.40.UC8 and its been awful. What am I missing? I've been tweaking ONCONFIG and I'm…
ontape -s -L 0 performance on Win2k3_x64
Of course there are Transaktions running, but over night there should not be so much ! I've got the same performance when trying a backup in worktime !!! The SAN is connected via 4GBit FC Adapter and I am able to reach a troughput of about 260MB/sec when copying files with Windo…
checkpoints Excessively slow
hi all we have IDS 7.31 UC4 on unix with 2GB Memory Since yesterday the system has become too slow with excessive checkpoints: 01:04:38 Checkpoint Completed: duration was 5439 seconds. 01:52:52 Checkpoint Completed: duration was 1931 seconds. 04:06:37 Checkpoint Completed: dura…
Informix thread working with a index
Hi all, I was trying to monitor an internal informix thread. I get a table with 8 million records. I do between 1000 and 5000 insert to this table daily. Every night I update statistics to whole database. There is a thread that it gets a session id but I can't see what it's doi…
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…
assert failures
Hi, Any ideas on this assertion failures notised in message log of Informix on HP-UX 11i ( what kernel paramiters HP-UX are response for this sytuation ) IBM Informix Dynamic Server Version 7.31.FD9 10:43:51 Who: Session(769, upos604@ldfb010pr, 9407, -1123270840) Thread(7946, sq…
Maximum concurrent users threads
Can someone tell me the formula that produces the maximum concurrent number portion of the onstat -u command? Is this based on what is defined in NETTYPE? ----------------------------------------- This message and any attachments may contain confidential information or trade sec…
Listener-Thread Error 25571
Today we saw hundreds of lines in our message log with the following error. The database pretty much came to a halt and nobody could connect or do any work. Only bouncing the engine cleared up this issue. 17:15:47 listener-thread: err = -25571: oserr = 0: errstr = : Cannot cr…
Replication performance problem related with DRINTERVAL
Hi, we are moving our application from tru64 to aix. Our application is an real time application and performance is very important. We are doing some tests on informix on the new platforms. But replication seem a bit strange. test is an 10.000 update row update in a table that …
Re: IDS on a Mac?
I thought the title of the thread was "IDS on Mac OSX". Why don't you just create a new thread and move all the Oracle vs. Informix and all the personal bashing over there????…
Display servicename/port no. of listner or user thread
Version: Informix 10 How do I display which listner or user thread is listening to which port. I am looking for something that tells me which thread is using ports/service names listed in sqlhosts. I tried onstat -g ath and onstat -g glo.…
Re: NETTYPE NET/CPU
> Read more about NETTYPE and have few more questions: > > 1. What determines the polling cycle of poll thread having class of > CPU VP. You mentioned it polls only periodically. What does it do when > it's not polling ? A poll thread running on a cpu vp will poll at a minimum o…
BAR_MAX_BACKUP - not spawning parallel threads
Version : 10 We are running onbar -b -l with BAR_MAX_BACKUP = 4 and BAR_NB_XPORT_COUNT = 10. But when I check the number of onbar process I just see one onbar_d process. I was expecting atleast 4 processes. Why is it just spawning one process. Is it because our SHMTOTAL is 0.…
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: 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.…
Checkpoint times
Hi, we encounter enhanced checkpoint times on a production instance. I have tried to modify some parameters which results in less checkpoints, but still long (at least for our system). Actual config is Sun 280R, 4GB Ram, 2 Processors, Solaris 9 (Sparc), IDS 10.00FC6. Checkpoint …
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…
Server fails to come online
Zokovic, I've looked & killed all oninit process, but when i again run oninit -v i get the following message: Checking group membership to determine server run mode...succeeded Reading configuration file '/home/informix/etc/onconfig.suse'...succeeded Creating /INFORMIXTMP/.infx…
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…
IDS 9.49 UC2 -> UC7 PDQ changes?
Schuran, Sven said: > Hi, > > We changed from UC2 to UC7 on a Linux box with 2.4 kernel. > > With the same configuration, UC7 runs out of memory, but I don't know why. > > PDQ is enabled. When I disable PDQ everything works fine. > One thing, the working sessions nearly all have …
Re: Anybody seen a very fast wild cat out there?
FInally, AUTO_AIOVPS is not explained that well. "the database server |automatically increases the number of AIO VPS and flusher threads when the |server detects that AIO VPs are not keeping up with the I/O workload" What threshold determines this? Couldn't adding more and mor…
IDS 10 instance can't initialize dbspace
PHYSFILE specifies the size of the physical log. PHYSDBS specifies the name of the dbspace that contains the physical log. When you initialize disk space (oninit -i), the PHYSDBS value must be equal to the ROOTDBS value. Refer to - Size of the Root Dbspace - for more info http:/…
Thread Migration Statistics
Hi, onstat -g sch gives two informations: VP Scheduler Stats and Thread Migration Statistics. I'm looking for any information about Thread Migration Statistics. Does anyone know what is it about? What does it mean: 'steal-at steal-sc idlvp-at idlvp-sc inl-polls Q-ln'? I couldn't…
NETTYPE's poll thread number
Hi, My box has singel processor , NUMCPUVPS =1 . A lot of user will access this server, maximum will be 1500 user threads. How shoud I set up the NETTYPE in onconfig file. On informix's manual , says poll thread should not be greater than NUMCPUVPS . and user thread can no…
Holy Sh
So maybe the "marketing blitz" you referred to in your other thread is starting to roll out?…
listener-thread: err = -25573
IDS 10.00.FC4 Solaris 10 New server, New Database Database has been up for 6 days. Received this error last night: 08:36:56 listener-thread: err = -25573: oserr = 13: errstr = : Network driver cannot accept a connection on the port. System error = 13. 08:36:57 listener: poll ret…
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…
To change extent and next size of huge table
TQ, disk space is a problem. We will try once we got the disk will update the thread then. Thanks again. Regards. Shani…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
sporadic listener-thread errors
Hello, we are seeing listener-thread errors sporadically (once or twice a day): OS: HPUX 11.11 IDS: 9.40FC7W3 Error messages in the message log on server side: listener-thread: err = -25580: oserr = -1: errstr = : System error occurred in network function OR listener-thread: e…
Initialising Informix
My file settings are as follows SERVICES srvr0001 8001/tcp #Informix port sqlhosts ok_srvr onipcshm 10.0.6.2 ipcs0000 ok_tcp onsoctcp 10.0.6.2 srvr0001 onconfig DBSERVERNAME ok_srvr # Name of…
Maximum number of extends
http://groups.google.de/group/comp.databases.informix/browse_thread/thread/c8d12b3def081d8b/6181761f44b780de…
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: Onstat -g sts
Vaclav Boura wrote: Version and platform info would help a bit. Shutdown and restart IDS then open a case with IBM. Art S. Kagel > Hello all, > I have this problem : > > 01:08:38 Found during mt_shm_free 4 > 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) > 01:08:38 Bad block…
Re: Onstat -g sts
Vaclav Boura wrote: Version and platform info would help a bit. Shutdown and restart IDS then open a case with IBM. Art S. Kagel > Hello all, > I have this problem : > > 01:08:38 Found during mt_shm_free 4 > 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) > 01:08:38 Bad block…
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/…
Onstat -g sts
Hello all, I have this problem : 01:08:38 Found during mt_shm_free 4 01:08:38 Pool 'sscpool3' (0x7000000e0e22040) 01:08:38 Bad block header 0x7000000f7fd1000 blk-64 07000000f7fd0fc0: 00000000 00000000 00000000 00000000 ........ ........ 07000000f7fd0fd0: 00000000 00000000 0…
Re: Thoughts on Logical Log use requested
malcolm weallans wrote: > You miss the point entirely. > Well, (tongue in cheek) use "WITH NO LOG" (because this is the Logical > Log use thread)! > > Not enough potato EEEEEEEEEEEEEE Actually, I didn't miss the point, I just felt that the thread was regarding logical log usage …
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
Shouldn't network poll threads run in NET VP's?…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
RE: increase file limit 2gb for IDS 7.31 ontape -s -L 0 with
Right. And just to avoid confusion: This 2 GB file size limit is for files only, i.e. when ontape is writing to a file in the file system. It does not apply when ontape is backing up to a real tape device. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germ…
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.…
Database Crash
When even we reach around 1700 Userthreads, the database crashes. Find below part of the informix. 10:46:50 Maximum server connections 136 10:50:48 shmat: [ENOMEM][12]: out of available data space, check system MAXMEM 10:50:48 shmdt: errno = 22 10:50:48 create_tcb: cannot a…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
RE: stack overflow locking sysprocplan
some more details, the file names are cogdmif.ini (called as the informix gateway file in cognos) and ifdba.dll (DMS IF-Library Gateway) -----Original Message----- From: Savio Pinto (s) Sent: Friday, July 22, 2005 2:26 PM To: 'jda'; informix-list@iiug.org Subject: RE: stack ove…
RE: stack overflow locking sysprocplan
you may need to open a case with cognos, we had somewhat similar problem when we upgraded cognos (in our case cognos was on windows server, csdk was 2.81 and ids 9.4 on hp ux), it turned out be a problem with the cognos driver for informix (i don't remember the name of the .dll …
stack overflow locking sysprocplan
We are experiencing the following problem and have yet to resolve it completely even after an IBM support call. When users run reports in Cognos's Impromptu that use views with stored procedures calls with them, the user will lock sysprocplan and prevent other users from doing a…
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:…
Informix IDS 9.4 failed to initialized shared memory
I just installed Informix IDS 9.4 on Mandrake 10.1 Kernel 2.6.x I setup the onconfig file. the following are some of the parameters I set: # Root Dbspace Configuration ROOTNAME rootdbs1 # Root dbspace name ROOTPATH /home/informix/dbspaces/rootdbs1 …
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…
Join threads
Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.…
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…
many threads for process ?
We are running a batch process, and when monitoring it, I see a huge amount of threads associated with it, and most of them are waiting. One of the tables in the query is fragmented, but it only has 10 fragments, so I wouldn't expect to see more than 10 scan threads. Any ideas ? …
hpkaioaddseg: ASYNC_ADDSEG failed, errno = 1 --> please help
Hi everybody! we tried to increase the size of SHMVIRTSIZE previously it was 94000 and SHMADD 8000 I tried to change SHMVIRTSIZE to 110000 and got an error... 18:42:36 HPUX Version B.11.00 -> Using flag/select style KAIO 18:42:36 hpkaioaddseg: ASYNC_ADDSEG failed, errno = 1 …
DRINTERVAL
It would be interested to know which threads are running that are consuming so much cpu (onstat -g act) and what are they doing (onstat -g stk <tid>). You could try some profiling of the oninit as well to gather more info. On the other hand maybe this cpu usage is not a bad sig…
AW: Too many open files to the master oninit process
pls. see your previous thread :-)…
STACKSIZE.
Hello, I recently resolved an issue with STACKSIZE on one of our test databases by using the following thread: http://groups.google.com/groups?q=yield_processor:+Stack+overflow&hl=en&lr=&selm=7qnkgs%24nq1%241%40nnrp1.deja.com&rnum=2 Thanks to those that contributed to this and…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
RE: error during export procedure-"File size limit exceeded"
Hi Cristian. Yep, this is restriction in 7.x, 9.2, and 9.3. In 9.4 does not have this restriction. OR Use sqlcmd of Jonathan Leffer or utlity of Art S Kagel. Both utility exists http://www.iiug.org . HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: cristizahario…
Re: error during export procedure-"File size limit exceeded"
On Mon, 27 Sep 2004 06:40:19 -0400, Cristian Zaharioiu wrote: Yes. All Informix utilities in versions earlier than 9.40 are limited to creating files smaller than 2GB (except when writing to tape). Art S. Kagel > hello all, > > i am running dbexport procedure on the database …
RE: error during export procedure-"File size limit exceeded"
This is the 2Gb limit of 9.21. Upgrade to 9.40. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Cristian Zaharioiu > Sent: Monday, 27 September 2004 10:40 p.m. > To: informix-list@iiug.org > Subject: error…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Informix Tuning Problem
My server run very slow for this few weeks.. I've checked the %cache go 99%.. Hardware : IBM - H80 , 4 CPU , 2G Ram , HD x 2 dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 25899 119543 30538756 99.92 97670 146260 2077545 95.30 ONCONFIG : - …
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: how release threads?
This is a multi-part message in MIME format. --------------020301030302090906080606 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Well, at least I have discovered what status await_MC%d in onstat -g con (or onstat -g wai) of thread means…
Re: how release threads?
make sure when you update statistics for procedure you set pdq to 0...the stored procedures that help facilitatemay be mutltithreading if you do not and the thread count will increase until evetually you get an exception error which might crash the engine.…
how release threads?
dear all we have an java application running on websphere 5 and using jdbc connection pooling accessing data in IDS 9.40.FC3 on AIX 5.2, pdqpriority=1 there is 20 connections-user session used by appserver and reused within connection pooling by many users however, the number …
Onbar uses sqlexec threads or???
Hi all, Onbar questions regarding the buffer cache..... (I'm using IDS 7.31.FD6X3 on Sun Solaris 64 bit, with Veritas Netbackup for Onbar) My onconfig : BUFFERS 800000 BAR_MAX_BACKUP 12 BAR_RETRY 2 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 Would this be ? : 800,000 buffers * …
Re: Multiple user threads
On Thu, 15 Jul 2004 11:58:49 -0400, Bjorn De Waele wrote: PDQ threads assigned to a session usually are not released. The session keeps them assigned in case they are needed again. I suppose this cuts overhead in heavily PDQ dependent sessions. It should be harmless. However…
Multiple user threads
Hello everybody, we're using version 9.40.T7 Our max_pdqpriority is 100. Right now, I see much this behaviour with onstat -u. Informix creates plenty of user threads. If I set with the max_pdqpriority with onmode -D to 0. Then I get a single user session which shows me sometim…
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…
Explain offset
Bjorn De Waele wrote: > This is exactly what I mean. Ok, I got the point about that offset. > Probably for not overwriting each other. > > But do you need to implement this always? Under Windows, you can > give raw disk space or use the NTFS. Do you need the offset too > when you…
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…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
listener-thread: err = -408
Dear Sir, I found error in online.log when i type in shell command the following onstat �m Thu May 27 08:06:29 2004 08:06:29 listener-thread: err = -408: oserr = 0: errstr = : Invalid message type received from the sqlexec process. Then I use the finderr to get more informa…
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.…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list…
listener-thread: err = -27004
Hi Gurus I am having this problem on my test server that on the windows 2000 server. And i am using IDS 9.4. It was ok after install and get this error after restart. And need your help. Thanks Punithan sending to informix-list sending to informix-list…
Re: Possible poplong bug in 4GL 7.32.FC2 on True64 V5.1 2650 alpha
On Tue, 20 Apr 2004 02:39:42 -0400, J?rg Spilker wrote: > Hello, > > i���m confused. We recently changed our environment from True64 V4.0 1229 > alpha to V5.1 2650 alpha and also our 4GL developement tools from 7.20.UE3 > to 7.32.FC2 (and also Dynamic server from 7.x to 9.x). > …
I added memory - now what should I change in onconfig to take advantage of it?
sumGirl wrote: replies have gone to your other posting - better let this thread die...…
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…
listener-thread: err = -25572
Sometimes on Win2000, when I stop the IDS, it will not restart with a reboot. The message in the log says: 13:48:06 IBM Informix Dynamic Server Version 9.40.TC2 13:48:06 listener-thread: err = -25572: oserr = 48: errstr = : Network driver cannot bind a name to the port. Syste…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: multi thread - Informix
That's a very old version of the CSDK, not a particularly buggy one that I remember though. The thing to be careful of in using ESQL/C with multi-threaded apps is that only one thread can use a particular connection to the server at a time. In order for multiple threads to shar…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
New Threads - Analysts
OTC Spake: > > My main moan is that they gave / give too much > credence to analysts who say > that if they do anything to promote IDS they will be > downgraded because of > a confused database strategy. And we all know that > the analysts are always > right. > Market Analysts a…
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…
multi thread - Informix
Dear All, We have a multi thread C++ program. The threads fetch data (with prepared cursor) from an Informix DB parallel, but we got coredump (not always) The operating system is: ReliantUNIX-Y 5.45 B2005 RM600 4/768 R4000. We uses the following packages: PKGINST: SIthread…
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…
Fw: Informix thread management
I suppose I deserve this for switching machines and not correctly updating my mail account. cheers j. ----- Original Message ----- From: "Jack Parker" <jack.parker4@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <informix-list@iiug.org> Sent: Tuesday, January 06, 20…
Re: Informix thread management
Thanks Jack, I've read your article now and it's certainly quite informative. I'm still not clear on exactly what DS memory stores and what it allows you to do, and how come parallelisation is still able to happen on the system I am currently working on where IDS 7.3 has default…
Threads waiting on buffers (TWOB)
Well, Once again, our company is faced with the "threads waiting on buffers" (TWOB) issue. At a certain point, a ton of threads suddenly start waiting on a specific buffer (they show 'B' in the first flag of onstat -u). Onstat -X shows that they're almost all waiting on the same…
Re: Informix thread management
Thanks you Norton for shutting that down. cheers j. -.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- / ... --- / -.. --- / .. .-.-.- ----- Original Message ----- From: "Jack Parker" <vze2qjg5@verizon.net> To: "Andy Kent" <andykent.bristol@virgin.net>; <in…
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.…
Re: Informix thread management
OK, but on the other hand I *have* seen very small queries get blocked when for some inexplicable reason IDS calculated a DS_MAX_QUERIES of 6, which is a mystery in itself. (They haven't set the DS values in the onconfig, but according to the calculation in the manual it should b…
Re: Informix thread management
Thanks for a most informative post Art - as ever. On the site I'm on at the moment users often connect with PDQPRIORITY=HIGH and I'm sure I've seen several run at the same time and not get blocked. They just don't seem to get to do much in the way of parallel processing - though…
RE: What do session statuses mean?
Wait master consumer. eg. a scan thread waiting for a consumer thread like a sort thread, join thread etc. Regards, Bill > -----Original Message----- > From: andykent.bristol@virgin.net [SMTP:andykent.bristol@virgin.net] > Sent: Monday, December 15, 2003 4:43 AM > To: informix-…
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: Informix thread management
--0__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: multipart/alternative; Boundary="1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E" --1__=88BBE769DFCB1A1E8f9e8a93df938690918c88BBE769DFCB1A1E Content-type: text/plain; charset=US-ASCII Content-tran…
Informix thread management
This is a multi-part message in MIME format. ------=_NextPart_000_0043_01C3C0D8.C5ED7B90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit BlankHi All, I have fragmented my database & now want to use the parallel database feature of Inform…
listener-thread err -930
Hi Folks: I've just got a listener-thread err -930 on a new instance I put up last Friday. This box is in my test bed and is not critical but I would like to know why when I load data from my production server on this test server then shutdown Informix it generates this -930 er…
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.…
Listener-thread errors
We are running IDS 7.31.UD5 on SCO OpenServer 5.0.5. We have a recurring problem when approaching 128 active user threads. We begin to see the following in our logs: 11:00:28 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. At …
Engine's re-setting
Thanks to everyone, I send the onconfig file's portion about the memory and processores: about the processor: MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit number of cpu vps to one N…
Threads waiting on buffers
Ok, so Informix tech support and I haven't been able to figure this one out. I'm hoping someone else is familiar with this problem and knows how to fix it. Every now and then, often while we are experiencing peak load, but not necessarily, our Informix engine gets into a state w…
JDBC thread hogs processor while query executes.
I'm developing a mutli-threaded Java application on Linux and am finding that when I execute an sql statement the thread that executes the statement just waits for JDBC to return with the results, and does not give up the processor to let other threads have a go while it is waiti…
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…
A Sleeping Thread - Or is it?
I am running an update statement on a single-cpu configured HP box w/ IDS 9.30FC2. The thread says that it is sleeping (Forever), yet the the update statement is working it's way thru the table. It wakes up once in a while, says it's running, then goes back to sleep. There is cur…
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…
oninit: Fatal error in shared memory creation
What is the problem when your shared memory is not allocating and attatching? This is what I get ############################################## $ oninit -iyv Checking group membership to determine server run modesucceeded Reading configuration file '/sw/informix/etc/tbcedn.prod'…
No thread isolation-- Unusual or Common?
Just had an experience in which a user attempted to run a very long SQL query. ("Long" in the sense that just to view the text of the query required about a dozen screens when looking at it with onstat) The SQL involved over 170 tables and UNION ALLs. However, the selectivity …
new scan threads
I was tuning my informix with the onconfig and env variables, when I saw the output of onstat -g ses <sesid> with something like this: tid name rstcb flags curstk status 78 sqlexec b154a5b4 ---P--- 67400 b154a5b4 sleeping(secs: 3) 112 scan_1.0 b1553554 ------- 68296 b1553554 run…
msg during start up of memory and shmem
Hello all, I have a question about a msg in online.log during start up. My shvirtsize is 491520 and onstat - reports memory allocation of 1,292,456. The hp-ux 11.00 shmmax is 1.6 gig and maxtsize_64 (code space) is 1.6 gig. I would think I have enough mem allocated in unix a…
exchange thread?
hello, can anyone explain me what is an exchange thread ? and the concept behind it. bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
Nettype
Tony Woods schrieb: > > Hello all, > > NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype > NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype > > Does the above setting mean that 3 poll threads will handle 384 connections > or each of th…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
Nettype
Hello all, NETTYPE ipcshm,1,200,NET # Configure poll thread(s) for nettype NETTYPE soctcp,3,384,CPU # Configure poll thread(s) for nettype Does the above setting mean that 3 poll threads will handle 384 connections or each of the 3 poll threads will handle 384 c…
Checkpoints getting longer
Hi , I wonder if someone can give us an advise on the most effective way to reduce the checkpoints duration. IDS 9.21, Sun-Solaris 5.8, 1G RAM, max number of users is 600. Database is very right intensive, and during last moths and a half duration of the checkpoints grew from …
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…
Re: IDS 9.20 panic
No registered datablades. We aren't really using any extended functionality of IDS 9.20. The engine is just being used to support, principally, a bought-in Financials package written in COBOL with an Informix interface, and some 4GL/VisualBasic applications. As mentioned previ…
RE: IDS 9.20 panic
You might want to increase your STACKSIZE config parameter to something like 128. Are you calling functions/procedures recursively? Don -----Original Message----- From: Neil Truby [mailto:ntruby@netcomuk.co.uk] Sent: Monday, October 16, 2000 2:05 PM To: informix-list@iiug.org …
IDS 9.20 panic
IDS 9.20 FC2 on HP-UX 11.0 Has anyone come a similar error to the one below? I've had it twice now, once on a production instance and once on a test. Tech Support aren't coming up with much. I wonder whether to escalate it: thanks Neil 11:08:45 Checkpoint loguniq 43086, lo…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
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?…
Re: IDS 7.31 on DEC Unix
From: "remove (_at_) to reply" <mips_at_@zg.tel.hr> > >On Fri, 07 Jul 2000 12:59:58 BST, "Obnoxio The Clown" <obnoxio@hotmail.com> >wrote: > > >What did they use to do the port? It's in the release notes... > >Here is the part from IDS_7.3 > ================…
Re: IDS 7.31 on DEC Unix
On Fri, 07 Jul 2000 12:59:58 BST, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > >What did they use to do the port? It's in the release notes... >________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http:…
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…
Onbar with Legato
Machine: HP 11, Informix 7.3UC2. I have two questions regarding onbar with Legato backup. 1. I am trying to take logical logs to go to disk and feed to Legato. Is there any script in the s/w repository to handle this ? or what is the best way to do this. 2. If I run onbar…
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…
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…
tlitcppoll thread assert failures
Set the ONCONFIG file to save a core dump. If it happens again load the core file into a debugger and get a stack trace from the debugger to send to Informix. I had to do that for years as the DGUX releases do not do the stack trace thing ever. BTW the first trace says it's fr…
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…
threads and informix ...
Hi all, I have an application which creates multiple threads and tries to connect to a database . The command to compile the application is -> > esql -e -g -thread <filename> When I use the -thread option the message displayed is -- esql: When using -thread, the THRE…
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…
Re: onstat -g Question
onstat -g arc undocumented. In versions 7.30.uc5 and earlier the date xx/xx/2000 displays as xx/xx/10 (bug). |--------+-----------------------> | | Jochen | | | Platzer | | | <jps@magnet.a| | | t> …
linking question for csdk 2.30uc11
Environment: solaris 2.6 using informix csdk 230uc11. Problem: I am using C++ csdk to create an application dynamic .so library. This library also has some other third-party .so library dependencies. The final library is about 18M big. When this library is linked with a small tes…
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…
Max number of connection?
Hi, my name is Darko. My system: OS SCO OpenServer 5.0.4 IDS 7.30 UC2 When a number of threads come to "magic number of 112" the system rejects the next thread. Somtimes it hangs IDS. In online.log I found err 27001. I tried to rise a number of pool threads and listner threads…
Multi-threading. Where would I find the DCE libraries?
Andy Lennard wrote: > > Hi all, > > I'm trying to go multi-threaded, but where would I find the DCE > libraries for Solaris2.6? I do not think that ESQL/C uses DCE threads on Solaris. I believe that it uses either the POSIX or Sun thread library based on a commandline parameter…
RE: stack overflow in NewEra
> Hi, > Could anyone help me with this? I'm having IDS 7.2x running > on AIX 4.21. And a Informix NewEra as a > client. I keep getting "stack overflow" when doing a search. > > regards. I thought I would get in quick before the mobs tell you a story about choosing a development …
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…
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: Way temp dbspaces are filled
Get rid of the spaces in your onconfig list. You have DBSPACETEMP tempdbs1, tempdbs2, tempdbs3, tempdbs4, tempdbs5 change it to DBSPACETEMP tempdbs1,tempdbs2,tempdbs3,tempdbs4,tempdbs5 Let me know if this works. You will have to bounce. I had the same problem in…
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%
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: Creat dbspace error
"Mark D. Stock" wrote: > > David Williams wrote: > > > > Will add to FAQ. > > Okay, thanks. I will dig out the release notes on the subject for you as > soon as I am back in the orifice. From $INFORMIXDIR/release/*/*/IDS_7.3: --------------------------------------------------…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
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…
Compiling with thread libs
Platform : Solaris 2.6 INFORMIX IDS/UD Version 9.14 UC6-1 INFORMIX LIBASF LIBRARY Version 7.24.UC8 INFORMIX-Connect Version 2.20.UC1 INFORMIX EMBEDDED SQL for C Version 7.24.UC8 INFORMIX LIBGEN LIBRARY Version 7.24.UC8 INFORMIX-Universal Server Version 9.14.UC6 INFORMIX LIBOS LI…
Version 7.31 FC2 on HP_UX 11.0
In article <JTcB3.84$xa4.1135@news.colt.net>, "Bashar" <bashar@ctl.com> wrote: > Stupid question, maybe, but have you tried increasing the stack size? > > -- > Bashar Chalabi > CTL, London > Actually a very good question. I have just in the last several days increased the STAC…
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…
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…
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.…
Does the Informix (not Intersolv) ODBC driver support threads and thread safety?
Hi all, I'm looking at whether the 2.8 and 3.3 Informix ODBC drivers (the ones I heard Informix built themselves) support threads, and if so, are they thread safe. Ciao Fuzzy :-)…
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.…
oninit trace to user
Since oninit will run many Informix threads, it would be difficult to determine which thread is running on which oninit. My guess would be that some combination of onstat -u, onstat -g ath, or onstat -g ses would give you what you need. John Carlson Informix DBA WHSmith USA js…
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…
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…
Re: shared memory error SCO install
Brian Did the instance crash or was brought down abnormally prior to startup? If so, the shared memory segments are probably still hanging around - use ipcs to view and ipcrm to remove. Do you have multiple resident instances? If so you could be specifying the same SERVERNUM. En…
shared memory error SCO install
Why are getting this error "Fatal error inshared memory creation" Here is a copy of the possibly relevant partsof our config file: ROOTNAME rootdbs # Root dbspace name ROOTPATH /usr/informix/data/db_space # Path for device c…
4GL Array Cursor Position?
I was calling another function from within the input array. However, that function called the original function that contained the the original input array. By changing it to call a different function with a different input array based on the number of stacked windows, it seems …
Problem with shared memory
System : IBM RS6000 model F50 AIX v 4.2.1 (Dual processor) 512Mb memory On this system we have 2 informix instances running : 1 Informix version 7.3 UD6 (Recently upgrade from version 5.05) 1 Informix version 5.05 UC2 (Running for several years on this machine) We had the follow…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Out of buffer?
Hi, I got the following error message from an Informix IDS 7.30: <<Informix Dynamic Server>>> WARNING! Buffer pool size may cause Dynamic Server to get into a locked state. Recommended minimum buffer pool size is 4 times maximum concurrent user thre…
Multi-thread capability and non-threaded applications ...
I'm working on a UNIX/Solaris system, and we're just about to move to a version of Informix (7.33 [?]) that supports each individual thread having its own connection to the database, which is something we really want our applications to have. Unfortunately, we link into librarie…
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…
Checkpoints taking to long!!
Hi I've run into a problem with the checkpoints on my production system - they used to be all around 0 seconds long with the occasional 3 second checkpoint - now they have increased to more like 10-15 seconds average with a top of 20 seconds. We are running 730UC5 on a Sequent …
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…
Multi-threading
We are using what I think is an older version of Informix (our manuals say version 7.2). Currently, I'm tyring to use informix-esql/c to interface a multi-threaded server with our Informix database. I'm having a great deal of trouble and - after spelunking through the manuals - I…
Multi-threaded client ?
Is it possible to make a informix client that is multi-threaded process ? In other words, one unix process can act as multiple clients for Informix server with many threads ? Thanks in advance, from Eunsook.…
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…
Threads - Urgent
Hi all, We have an application using Informix esql/c. From my program, I query a table in another database using scroll cursor. After processing the data, I close and free the cursor, but the user thread is still maintained for the program, till I exit from the program. I woul…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
Upgrade Dynamic Server 7.13 - 7.24
I need to upgrade Informix Dynamic Server version 7.13 to version 7.24. Can anyone advise of any problems they may have had whilst doing this?…
thread safe version of informix 4gl
Does anyone know if there exists a thread safe version of informix 4gl. Thanks. William…
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
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…
Poll threads
A quick question. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ibm1 infmx_service3 And the onconfig file has the following DBSERVERALIASES and NETTYPE entries: …
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…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Multithreaded process - connect problem
Check the ESQL/C manuals, I believe you can only have one active connection thread to a particular server. You could have multiple connection threads to different servers, but only one can be active at any given time. Arun David Ferguson wrote: > G'day > I am writing a multi-…
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…
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…
Q: Linking a MULTITHREADED ESQL/C application
Hi Informix Gurus! we want to use ESQL/C in a multi-threaded application developed for Sun Solaris-2.6. esql requires some special thread library other then lipthread or libpthread: esql: When using -thread, the THREADLIB environment variable must be set to a support…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Threaded Process
Given a process with two threads, each with their own "active" connection to the same database make different select queries concurrently, will the queries be executed and acted upon concurrently by the server? Or will the first thread to submit the query cause the other thread t…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Boycott Microsoft
Can we get the Indian government to nuke this thread? -------- Stan Hixon the baby DBA hixons@cgprinting.com…
Re: Boycott Microsoft
die useless thread - die.…
sid <--> tid
Hi everyone. How I can determine, to what user session (sid) belongs thread ( tid ) Thanks. Serg…
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…
poll threads
What's the best way to monitor poll threads to determine if you need additional ones? We have been having a problem with sessions taking a while to actually make a database connection. When additional poll threads were added, this problem seemed to go away. My question is what…
Re: Unixware 2.1.2/Informix Online 7.23: Online won't boot: ulimit '-s': mystery error
Cosmo Lee wrote: > > We're running Online 7.23 on Unixware 2.1.2 on a SuperMicro dual- 180MHz > Pentuim Pro machine. > > We just upgraded from Unixware 2.1.1 to 2.1.2. Immediately we had a > problem, Online would not boot. Double-checked all the kernel > parameters in the relea…
Unixware 2.1.2/Informix Online 7.23: Online won't boot: ulimit '-s': mystery error
We're running Online 7.23 on Unixware 2.1.2 on a SuperMicro dual- 180MHz Pentuim Pro machine. We just upgraded from Unixware 2.1.1 to 2.1.2. Immediately we had a problem, Online would not boot. Double-checked all the kernel parameters in the release notes - everything fine. T…
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…
slow performance
Hi I am running ODS 7.23 u4 on HP 10.20 So many users complained about slow performance...I looked at "top".... IDLE has been around 21% %WCPU 36% == (command) oninit %CPU 35% == (command) oninit The partial onconfig info.... NETTYPE ipcshm,1,50,NET # Override sqlh…
Thread process and Informix license
Is anybody know if i need a license per process or per thread ? I have a multi-thread process that performs parallel connections to a database. Do I need a license for each of the thread or only for the process ? Thanks for responding. -- Regards. _____________________________…
Pardon me. Question on news reader
I've always been seeing IGNORE THREAD/WATCH THREAD options in most news reader. I wonder what do they actually do and how best to make use of them. Sorry for posting the mesg here. LeeKB…
Multiple threads
Hi! I am using IUS 9.12 and web datablade on Solaris 2.51. I installed Netscape Enterprise Server 3.0 to use NSAPI to improve performance. I know it provides multithreading and removes connection overhead. When, however, more than two NSAPI requests are arrived at web server at …
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: multithreaded servers
Peter Weigert wrote: > > hi folks! > > does anybody know wether informix thinks about supporting a > multithreaded applicationserver with one session per thread > (the global sqlca interferes the multithread support). Esql 7.21+ supports multi-threaded applications. A task can …
Question : ESQL, Threads, DCE ???
Hi, When I was compiling for multithreads, I got following error : esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. This is on Solaris5.5 Does this mean that informix is supporting only DCE …
multithreading question (DCE) ???
I get an esql error " esql: When using -thread, the THREADLIB environment variable must be set to a supported thread library. Currently supporting: DCE. Does this mean that POSIX are not supported. Thanks, Sachin ___________________________________________________________…
ESQL/C System-Descriptor-Area
Hi Informix-Gurus! Does anyone know, whether System-Descriptor-Areas, created by ALLOCATE DESCRIPTOR ... DESCRIBE ... are thread-safe like Cursors and prepared statements, or not? It seems, that they are not thread-safe. Thanks in advance Markus Bschorer mb@alphatron.de…
Re: Poll Threads
Harold, >NETTYPE ipcshm,1,100,CPU # Configure poll thread(s) for nettype You are telling online to use one CPU poll thread for shared memory connections. Either take this line out or change it to 3. Jason…
Poll Threads
I have a question about poll threads that some of the gurus may be able to answer. We are starting to use our first multi-processor machine (specifics below) and I don't see any evidence of it running multiple threads for a single user. The TFM is a little vague on the use of p…
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…
Multi_Thread Programming
Hello everyone!! I have OnLine7.11.UC1 running on HP-UX 10.X and ESQL/C 7.11.UC1. I would develop a Database application using multi-thread programming technique. but there is a problem I can't solve. I know Informix OnLine7.11 support multi-thread environment. When threads esta…
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: Multi Thread App
Alexander Jaremenko wrote: > > Hi All, > I'm about to write multi thread application with ESQLC. I would like to > know how ODS would treat multiple threads doing sql requests - as > separate DB - user sessions ? > Happy New Year! ODS/ESQL-C versions 7.21 and later support thr…
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: Deamon Threads
> Right now we are seeing that there are almost 700 informix threads on >the primary instance. I get this using 'onstat -u'. All these threads >are owned by informix. The Flags field of the 'onstat -u' o/p has >"Y--P--D" (Y - waiting on a condition, P - Primary thread for a ses…
IBM RS/6000, AIX4.1.5, and DS7.23
Has anyone experienced memory problems with running Online DS7.23 on a PowerPC based RS/6000 (2 CPUs) with AIX 4.1.5 as the OS 256MB physical and 448MB paging? We seem to experience a major slow-down in system performance which seems to be related to quite a bit of memory swappi…
IBM RS/6000, AIX4.1.5, and DS7.23
Has anyone experienced memory problems with running Online DS7.23 on a PowerPC based RS/6000 (2 CPUs) with AIX 4.1.5 as the OS 256MB physical and 448MB paging? We seem to experience a major slow-down in system performance which seems to be related to quite a bit of memory swappi…
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
Re: 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. > > The "sleep forever" threads are threads that will be remain dormat until they are activated by some o…
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…
Re: Online Crash
Try debugging the shmem.* file to see what the user was doing. Use onstat -i shmem.*, and use the onstat commands without the "onstat" and the "-". I had a similar problem on 7.13 and narrowed it down to a varchar value being accessed as an integer. funny but …
Online Crash
Hi I am running INFORMIX ONLINE 7.23 UC1 on SGI Challenge IRIX 6.2 When server crashes I got messages ------------------------------------------------ af.dcd4aa5 09:17:57 09:17:57 Assert Failed: Internal Error - Segmentation Violation 09:17:5…
Re: Information about tables in use?!
Mr Cheuk Kong Lo wrote: > > I'd like to know if there is a way to find out what tables are in use > by a user (thread). Any possible of knowing what row is current in use > by a user (thread) as well? > Onstat -g opn shows open tables by thread id. Onstat -k will show locked ro…
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…
Blocking of user threads
Hello, We are using Informix Online 7.13. The problem is that usually the user threads get blocked and if the applications which was accessing the thread exit the database which that thread was accessing gets blocked. Hence to access that particular database once again we need t…
Re: Shared Memory allocation error
In article <5j3fd5$bt0@cssun.mathcs.emory.edu>, Mark Stannard <mws@appi.ci.in.ameritech.com> writes >All: > >I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. >When I run a query on a view that joins many tables online begins >allocating additional shared mem…
Shared Memory allocation error
All: I am having a problem with online ver 7.10.UD1 running on AIX 4.1.4.0. When I run a query on a view that joins many tables online begins allocating additional shared memory until it hits an illegal address. At this time the query hangs but the engine stays up. If anyone c…
Re: Shared Virtual Memory Question/Engine Shutdown
In article <5d9913$cq5@cssun.mathcs.emory.edu>, Mario Estrada <marioestrada@guate.net> writes >Hi Carol! > >Error 22, is a Unix error indicating hat an invalid argument has been passed, >in DSA terms, it means that the shared memory requested by oninit >cannot be allocated. > >1)…
Re: Need clarification of 7.2 threaded clients
Philip Walden wrote: > > The Informix-esql/c 7.2 manual describes threaded esql/c programs. It > says that a process can have multiple "active" connections. One active > connection per thread. However it also says that only one connection can > be "current" at any time. > > What …
Re: Oracle vs Informix comparison
The point is that firing a trigger is a more expensive operation that a thread that sniffs the logs and 2pc is ... well 2pc. -- Mark…
HELP I'm in crisis
Hello, System: HP HP9000 E35, 132MB RAM, Online 7.12.UC3 These are my NEW Shared Memory Parameters: LOCKS 2000 # Maximum number of locks BUFFERS 30000(old=5000) # Maximum number of shared buffers NUMAIOVPS # Number of IO vps PH…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: 439 Error
Madan, It is my understanding that ESQL/C is not thread-safe until v7.20 and beyond. Ken G. Informix, CSE -- Boca Raton…
Re: Loads of Paging Happening
Fernando writes: }We have a Delphi application that runs for more than an hour, the paging on }the }system is incredible!! After less than an hour the system "sits down"...... }I'm not able to use the system anymore. Not even thake the engine off-line. }The system is HP 9000 E35…
Re: Incredible paging on the system
Collalti, Fernando wrote: > > Hello, > > We have a Delphi application that runs for more than an hour, the paging on > the > system is incredible!! After less than an hour the system "sits down"...... > I'm not able to use the system anymore. Not even thake the engine off-line. >…
Incredible paging on the system
Hello, We have a Delphi application that runs for more than an hour, the paging on the system is incredible!! After less than an hour the system "sits down"...... I'm not able to use the system anymore. Not even thake the engine off-line. The system is HP 9000 E35 with HP-UX 9.0…
Re: client failures with informix 7.2
This problem is noticed by me in the AIX platform too. However I do not find this 'dummy thread syndrome' while using dbaccess.…
Re: Informix libraries MTSafe ?
Yes; version 7.2 provides thread-safe ESQL/C. I think you have to use DCE threads at the moment, and you certainly have to compile and link with a -thread option. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> }From: Shimon Gonen <sgonen@titan.com> }Date:…
Informix libraries MTSafe ?
Are informix libraries MTSafe? Our application is threaded on Solaris. Can you access a database concurrently from 2 or more threads in the same process? Just want to read different tables in the different threads. Thanks. -- Shimon Gonen…
Re: Error on Informix Online
In article <31FC21E7.57AE@west.co.za>, Mark D Stock <marks@west.co.za> says: > >Kino wrote: >> Hi, >> I hope you apoligize my english. I have a HP900 with HPUX 9.04 and Infomix >> Online 7. When i execute this select >> <Vital stuff snipped due to STUPID news reader not allowing …
Re: Error on Informix Online
mauro@pc03.ronchiato.it (Kino) wrote: :Hi, :I hope you apoligize my english. I have a HP900 with HPUX 9.04 and Infomix :Online 7. When i execute this select :SELECT bas_doctes.*, ana_enaz.*, bas_tipdoc.*, bas_lineac.*, smc_iart.*, : ana_copa.*, ana_agba.*, bas_tiplis.*, ana_ali…
Error on Informix Online
Hi, I hope you apoligize my english. I have a HP900 with HPUX 9.04 and Infomix Online 7. When i execute this select SELECT bas_doctes.*, ana_enaz.*, bas_tipdoc.*, bas_lineac.*, smc_iart.*, ana_copa.*, ana_agba.*, bas_tiplis.*, ana_aliq.*, bas_agente.*, bas_bolfis.*, ana_enan.*…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
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: TCP SOCKETS ON ONLINE 7.10.UC2 ON SILICON GRAPHICS IRIX 5.3
In <3173EA9F.758C@erbamatta.arch.unige.it> Serafina Raneri <sraneri@erbamatta.arch.unige.it> writes: > >Has anybody ever tried to configure tcp/ip sockets on a Silicon Graphics >with Irix 5.3 and On-line 7.10.UC2. >I tried with this results!!!! > >Tue Apr 16 11:43:24 1996 > >11:4…
Controlling those Nasty CPU VP's
Platform=HP-UX 9.01 Informix 7.11 UC1 How can you control a session thread in a CPU VP from monopolizing the system CPU? We had a single thread take about 90% of the CPU while performing an update.…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
Re: ** FOR IMMEDIATE RELEASE - RECORD-BREAKING TPC-C RECORD!! **
Pablo I missed the beginning of this thread. I would really appreciate it if you could forward me the original messages. Thanks Chantel Van Niekerk CHANTEL@CASA.CO.ZA…
More NewEra Conundrums
Hi folks, here's some more NewEra conundrums. I am trying to retain similar functionality in a NewEra application as I have in a pre-existing 4GL system. Of question here are "zoom" screens. When data changes in a specific field (on insert or on update), if the user has enter…
Re: 7.x, determining a unix process from a session/thread
In article <40aspa$f1l@oscar.cc.gatech.edu>, Carlos Ugarte <cau@cc.gatech.edu> wrote: >With onstat and onmonitor you can determine some information >about each thread, but I haven't figured out yet how to determine >what user process is tied to that thread. Can anyone give a Bu…
User Threads
Does anybody know much about the number of concurrent user threads variable in the /usr/informix/etc/onconfig.std file? We're running an application, and receiving the message "You have exceeded the maximum number of user threads" Can I just up the number of threads in the config…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: C-ISAM to Informix conversion ???
See my reply to the thread on CISAM to ISQL, it will help if you can work out a possible schema. -- Martin How…
Multithreaded software with ESQL/C 7.10.UC3
Informix Gurus, We are trying to write multi threaded software using Online 7.1 and ESQL/C 7.10.UC3, on an IBM RS6000 AIX 4.1.1. The program seems to hang arbitrarily once threads are created. Is Online 7.1 and ESQL/C 7.1 thread safe? Are there any other libraries we need to …
Re: Error write to device AUX???
mfm@mindspring.com wrote: > We have noticed a few of our client machines running I-net have been > getting the error "Cannot write to device AUX" when the I=net > connection is first madeto the remote (unix) database. > [...snip...] > This error doesn't appear to an Informix err…
Re: Want to sort CHAR field NUMERICALLY in ACE report (SOLVED)
Thanks to those who replied.. I followed up with the solution in the previous thread.…
epilogue: I4GL / C parameter passing
Fellow netters, This is a summary of information I gleaned from an earlier thread, relating to using C functions with an Informix 4GL program. If you do not do or plan to do such mixed programming, then this message may not be of interest to you. First off, many thanks to Jona…
Informix Programs using ESQLC
Hello, I am running Informix Version 5 on an Alpha OSF/1 V.1.3 and am able to compile and link my programs using ESQLC. However, when I try to run programs that do database updates, inserts or deletes, I keep getting this error: axphvy.pa.dec.com> informixtp Program now in mai…
Re: Systables in local cache (was: Correcting Next Extent problems).
}From: uunet!pyra.co.uk!graeme (Graeme Sargent) }Subject: Systables in local cache (was: Correcting Next Extent problems). }Date: 1 Mar 93 10:20:09 GMT }X-Informix-List-Id: <news.2727> }In <1993Feb23.160915.5802@informix.com> (Dave Kosenko) writes: }>Contrary to what the manuals…
Systables in local cache (was: Correcting Next Extent problems).
In <1993Feb23.160915.5802@informix.com> davek@somerset.informix.com (Dave Kosenko) writes: >While Jonathan is correct, I will venture to say that this entire >discussion is misguided. Contrary to what the manuals lead you to >believe, having more than 8 extents will not have an…
Need help to interface I4GL and C
Hello netters ... I've a question about interface between Informix 4GL and C ... I want to call 4GL functions in a C modules... my problem is the parameters !! In the manual, they explain how to pass arguments to C functions called by 4GL program .. but not in the other way .. …
Re: memory allocation under AIX 3.2
}Date: Tue, 1 Sep 92 18:35:28 +0100 }From: Manuel Monteiro <uunet!ssf.pt!mm> }Subject: memory allocation under AIX 3.2 }X-Informix-List-Id: <list.1423> } }I had the following problem when upgrading from AIX 3.1 to AIX 3.2. } }In a esql/c program, when you pushquote((char *)str, s…
memory allocation under AIX 3.2
Hi Informix AIX gurus, I had the following problem when upgrading from AIX 3.1 to AIX 3.2. In a esql/c program, when you pushquote((char *)str, strlen(str)), what is really pushed into the stack is the pointer to the string, not the contents of the string (I didn't know that 'c…