Oninit® Archive
Results for “onstat -g sch”
Problem with disk ownership
Hi, As someone else has mentioned you don't have to use the name of the device Linux gives you and with udev you can create a block device in a directory off /dev: In your example it could be modified to: KERNEL=="sda3", NAME="informix/data01", OWNER="informix", GROUP="informi…
IDS 14.10.FC13 compatibility with other Informix tools
If you use sqlhosts with the CSDK then either use 4.50.12 or wait for the new version 4.50.14 tentatively scheduled for release a week from today. Using CSDK 4.50.13 and above with sqlhosts will return an Error -79716. ------------------------------ Daniel Karwatka -------------…
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 ------------------------------…
Informix future...
Scott, Is there a scheduled date (or quarter) for 15.1? Ballpark? Best regards, -Snorri ------------------------------ Snorri Bergmann ------------------------------…
Memory issue on Informix primary server
hi, with 14.10 you have more tasks running in the scheduler than with 11.70, may be you haven't launch it in version 11.70. Jacques ------------------------------ jack rage ------------------------------…
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 ------------------------------…
Non Critical DbSpace drop
There is an environment variable that will tell Dbinfo not look at partnum zero entries, if it has made a release it will be the latest. But might be scheduled for the next release Cheers Paul Paul Watson Oninit LLC +1-913-387-7529 www.oninit.com Oninit® is a registered trademark…
What are the changes to InformixHQ?
Wow.. InformixHQ will start automatically through the scheduler. Very cool! 😆 Thank you very much for sharing the script. ------------------------------ SangGyu Jeong Software Engineer Infrasoft Seoul Korea, Republic of ------------------------------…
ADO - activex data object
What do I require, to connect "ado activex data object" to Informix ? AIX 7.2 IBM Informix Dynamic Server Version 12.10.FC9W1 Regards Dirk…
Version 14.10 bug
I am no aware of any interim patch scheduled before .FC2. ------------------------------ Art Kagel ------------------------------…
sysadmin task control
Hi Alexandre, Thanks for your reply, my question is about controlling tasks and specify specific hours to execute them. Because I am verifying that some of them run on production time and sometimes I need to deactivate scheduler.…
Repliction Checking
You can look at the scheduler task "ifx_ha_monitor_log_replay_task" in the sysadmin:ph_task . It calls the procedure "ifx_ha_monitor_log_replay" which you can look at and maybe use it as a starting point for what you want?…
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.…
BUFFERPOOL Configuration
Hi Benjamin/Art, Let me start by thanking both of you for your brilliant answers and inputs regarding the subject. Let me do some back story on our server to fully explain our case : We have an informix server running on IBM AIX which starts I think from version 9.7 (or earlier…
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.…
Retoring the onbar backup
Hi friends, I want to restore our onbar backup from linux server to windows server, our onbar backup is scheduled through OAT.what is the procedure to restore?. Please help me on this. Thanks…
Issue in production server.
Update Statistics are automatically scheduled by Open Admin Tool. I have moved the data using DBEXPORT form Old server to DBIMPORT to new server, how can i miss BLOB's and CLOB's.…
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.…
Cannot find sysadmin:ifx_setupdwa function
Many thanks Martin for your response, The scheduler is running, I have the same problem. Is there any script to manually register those udrs?…
IIUG2017 - Session Schedule Available
Hi Everyone, If you have been waiting for the Conference Session Schedule for IIUG2017, it is now available* at http://iiug2017.org/schedule/ Tutorials are on Thursday and will be posted soon. A reminder that Tutorials are included with paid registration. It isn't too late to …
Chunk symbolic links
It's rootdbs. Issue is solved, there was a problem with the link file. This thread can be closed. Thank you.…
Add disk slice, live?
Maybe it would be better to try it as an actual experiment. I can interrupt the mirror, and try it. The only thing is that I don't know that a success in a nearly quiescent system would mean success in a loaded system. Still, if it crashes, I will definitely know that I should s…
rootdbs full
Hi I have activated the scheduled "kill user by timeout task in OAT", and then a few days my rootdbs has become full, so the question how can I avoid that my rootdbs become full by this functionnality enabled. for info, my loogs are on a specific dbspace. thanks…
IDS 12.10 on HP-UX- DS Total Memory
Hi, Here our current memory configuration config for IDS 11.10 SHMVIRTSIZE 3000000 # initial virtual shared memory segment size SHMADD 1800000 # Size of new shared memory segments (Kbytes) EXTSHMADD 8192 # Size of new extension shared memory segments (Kbytes) SHMTOTAL 0 # Total…
Identify process ID for the multiple informix inst
onstat -g glo or onstat -g sch are your friends. Both would list all=20 'virtual processors' (oninit processes) running for a given instance from=20 Informix perspective, also providing OS process id (pid) information. HTH, Andreas From: "medkba" <medkba@gmail.com> To: ids@iiug…
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 …
widows batch file for informix Update statistcs
Hello, does any one has windows batch file(script) to run update statistics and need to run it with schedule task. Thanks…
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…
Panic analysis
Folks, IDS 12.10 FC4, Linux 6. The following log is the only info we have about the crash ( no other info dumped ) You can see it was struggling to add lot memories segments before Panic .... The Panic was a also VERY curious one with some unexpected process terminated ... Wha…
SCHAPI table estimate_compression
Hi Frank, yes, it's debatable if this automatic estimation makes sense. But this scheduler task is still enabled by default. At least you can easily disable this task using the following SQL against sysadmin database: "update ph_task set tk_enable = 'f' where tk_name = 'mon_com…
SCHAPI: [mon_checkpoint 8-4514] Error
Bevis - I see these msgs often and they're never an issue or related to a current issue. They're from the Scheduler API (SCHAPI). The first one is from a task that captures checkpoint info to the sysadmin database from sysmaster I believe. My impression is that "can't delete row…
Raw or cook devices?
When you say it doesn't support raw devices, do you actually mean it doesn't support raw devices in the form of /etc/raw/rawX ? I don't use SUSE but I am pretty sure that on all modern Linux distributions you can use udev to configure raw devices. An example on RHEL which might…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Fatal error in ADM VP at mt.c:14100
Hi, We have faced issue on almost of all instances after giving following error . 00:47:24 Fatal error in ADM VP at mt.c:14100 00:47:24 Unexpected virtual processor termination, pid = 5482, exit = 0x9 Kindly guide us what cause this issue ? We are using IDS 11.50FC8W3…
Auto Update Statistics
Informix 11.50.FC8 - solaris environment After reading the documentation, it appears that AUS is scheduled to run over the weekend, by default, and all "UPDATE STATISTICS" commands that do not have time to execute are saved. My question is, "How configurable is AUS?". I would l…
version support schedule
Folks, Where is the page of the IDS versions supporting schedule ? Thanks Frank --001a11c3bb8a3e6c7104fdb1563e…
IIUG2014 Schedule Now Available at iiug2014.org
Hey Everyone, The IIUG2014 Schedule for Sunday to Wednesday is now available online at iiug2014.org/schedule (Thursday Tutorials will be added to the schedule ASAP). There are still a couple of days left until online registration closes April 20th, if you want to attend the con…
Licensing : VPU needed ?
The calculation of the VPU depends on the processor, the IBM computer can be found here: https://www-112.ibm.com/software/howtobuy/passportadvantage/valueunitcalculator/ vucalc.wss To understand the sub-capacity licensing, you can look at these two sites: http://www-01.ibm.com/so…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Error -1215 Value exceeds limit of INTEGER precisi
Hi, It's: IC89509 SCHEDULER MIGHT LOG SCHAPI ERROR -1215 MESSAGES IN ONLINE LOG http://www.ibm.com/support/docview.wss?uid=swg1IC89509 Ben.…
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.…
Unload via OpenAdmin Task Scheduler
Is it possible to unload an Informix table using the OpenAdmin Task Scheduler? I have created a task with the execution statement as unload to Turret_DnB_Table.txt delimiter "|" select sales_off from livturdb:turret_ar_dnb_table; Thank you John…
OpenAdmin Tool
I have created a stored procedure(function) which is a series of select statements into temp tables with the last select into a permanent table. The procedure is located in a user db. I have scheduled this procedure using the OpenAdmin Tool via the Task Scheduler activity. Receiv…
IIUG 2013 Conference Schedule
Hey Everybody, If you're attending the conference in April, the schedule is now available at iiug2013.org so you can start planning what sessions you want to attend. https://www.iiug.org/conf/2013/iiug/session_grid.php Thursday Tutorials are not included on the schedule (yet),…
backup IDS windows
Can you help me to schedule some archive and backup of logs using IDS Windows 11.7? tks henrique_lima_2000@yahoo.com.br henriquelima@uol.com.br…
Informix on Linux on VMWare
Keith Simmons wrote: > Hi > > It looks like I am going to have to migrate an IDS instance from Solaris > to Linux. > Current machine is a 16Gb dual chip SPARC T5120 with twin path, fibre > attached disk (Raid 1) running IDS 11.5 on Solaris 5.10. > Target machine is likely to be s…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Scheduler Status
IDS 11.7 I know how to stop and start the scheduler: execute function task ("scheduler start"); execute function task ("scheduler stop"); ..... but how do you check the status, to see if it is running or not ? ________________________________ NOTE: This e-mail message is sub…
RE: Informix 11.50 EOL
Has anyone heard of when Informix 11.50 is scheduled for EOL? Larry…
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,…
transaction count
There is a task already defined in the scheduler for this version to copy the sysprofile at the interval you define. Makes pretty graphs and everything. I capture every 5 minutes. I think the default is 15 minutes. The results are stored in a sysadmin:table. You can push them to…
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…
Efficiency of the Informix Virtual Processors
Dear All, IDS 11.50.FC8W2 on Hp-UX 11.23 (12 core - 55 GB mem to informix) No other instance running on this machine. I was reading a post by john on http://www.jfmiii.com/informix/?p=194 It say that if the efficiency drops below 80% (onstat -g glo output) then there seems to …
Task vs Sensor
Hi, All, IDS11.50 FC8 We normally use OS cron jobs to complete all these type of activities. We are evaluating the IDS Scheduler approach. It seems to me that Task can do whatever Sensor's function, is it true? The main goal of a Sensor is collecting the statistics data, whic…
Strange connection issue
Peter, Check and see if you have the scheduler task enabled that kills off stale or not used connections. Thanks Kernoal…
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 …
Informix job scheduler issues
IDS 11.50.fc5 HP-UX 11.31 (11i V3) PA-RISC I have created a function that I would like to execute on an hourly basis. I created an entry in sysadmin:ph_task: insert into ph_task ( tk_id , tk_name , tk_description , tk_type , tk_dbs , tk_execute , tk_delete , tk_start_ti…
migration checklist 7.31 to 11.7
Art: Interesting point... you would not use the tests specified in the migration book? I read part of the migration guide from IBM that I downloaded (thanks to the contributions of IIUG!) and found these were key migration tests. I guess IBM doesn't like to tout the third party s…
ph_task scheduled tasks
Hi, I am using the ph_task table to schedule a task to delete data from a table. I have a question around this. 1. In the event of no data present in the table how to verify if this scheduled task actually got triggered? Regards, Prasad…
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…
VPCLASS cpu on sun/oracle M4000 machine
Hello, I have an IDS 11.50.FC6 instance on an M4000 oracle server with 4 CPUs with 4 cores * 2 threads each. The OS (Solaris 10) 'sees' a total of 32 CPUs. The thing is, I'm trying to tune the cpu VPCLASS onconfig parameter so that this instance is able to use more CPU power, but…
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…
Fatal error in ADM VP at mt.c
I've the following messages in online.log of an 9.40.FC9 informix dataserver : 17:52:55 Fatal error in ADM VP at mt.c:12703 17:52:55 Unexpected virtual processor termination, pid = 1466506, exit = 0x90009 17:52:55 invoke_alarm(): /bin/sh -c '/bases/informix/pcampcam/admin/ontap…
Scheduler Error
IDS 11.50.FC5 I have just noticed that none of my scheduled tasks seem to have executed since 11-29-10, when about half of the AUS statements executed. I have the following entry in my informix log: 20:34:05 SCHAPI: thread dbWorker1 task post_alarm_message(15-160390) shutting d…
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…
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…
Initialization of Java virtual processor failed
when trying to install a java udr i'm getting the following nessage: 9444: Initialization of Java virtual processor failed: (cannot create gc file) Can anyone help? Here is the statment: execute procedure install_jar( "file:$INFORMIXDIR/extend/krakatoa/examples/Env.jar", "env_…
shared memory parameters
If you are running version 11 you can use onstat -g osi (for operating system information) to get many of the interesting kernel and system information settings. This command works when the database is online or offline (like onstat -m). John F. Miller III STSM, Support Architec…
OAT SQL Explorer - Live vs Saved Data
OAT is using a task in the Task Scheduler to save off of the SQL trace data. So you can configure how often IDS saves SQL trace data by modifying the schedule of the task. If you go to the OAT Task Scheduler -> Scheduler page, find the task named "Save SQL Trace". Clicking on …
Scheduler error message
IDS 11.50 FC4 on Redhat Enterprise 5 I'm seeing the following in my online.log file 01/13/10 09:15:00 SCHAPI: Error -206 The specified table (mon_syssqltrace) is not in the database. 01/13/10 09:15:00 SCHAPI: Type: SENSOR, Name: Save SQL Trace, Location: NULL. 01/13/10 09:15:00…
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…
The Scheduler and Update Statistics
IDS 11.5.FC5, AIX 5.3 I am about to start my investigation into the new AUS subsystem with 11.50 and had a few questions I would like to ask. Is anyone currently using the AUS facility to generate and run update statistics? If yes, does the statistic scripts generated by this t…
Seeing one oninit working hard while others are no
I think we are running into a condition where only one virtual processor is trying to do a majority of the work on a remote server via synonyms. When you look at all the oninit modules running on the remote server, it looks like only one is really taxed: ps -ef |grep oninit hd…
Schedule execution of oncheck commands
Hello, friends. We´re on IDS 11.50.FC4 on a linux_64 environment. On our old instances (9.40), we had a script to run regularly, some oncheck commands on our instance. Does it applies also to the 11.50 version? Is it needed to execute on a regular basis, or not? Thanks and rega…
Database Job Scheduler
Hi, we are looking to replace Maestro Job Scheduler - IBM Tivoli Workload Scheduler - program that enables scheduling and monitoring 'batch' jobs automatically by processing prepared job control language statements. Can you tell me if you are using some other Job Scheduler a…
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…
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…
Odd Performance
IDS 10.00.UC8 Solaris 10 I am playing with our new Solaris server - I just increased the VPCLASS parameter to VPCLASS cpu,num=32,aff=64-95,noage from cpu,num=5,aff=13-21,noage. Our new server has 132 virtual processors available: uname -X NumCPU = 128 psrinfo -pv The physical…
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.…
Long Spins
Hi, The IBM IDS document says: "To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features." But wait for other to advice you, I'm sure the IDS guru's will suggest you a so…
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…
Re: MSC virtual-processor class too loaded aft....
Hi, first of all, thank you very much John and Jacques for your answers. The IDS engine allocated another vp msc (I supose due to the high load of the first one). I have tried without success (at the moment) to catch operations that msc vp is doing with the following command: …
MSC virtual-processor class too loaded after migra
Hi, After migration our DWH from IDS 10FC9 to IDS 11.5FC3 (Under SLES 10 SP2) I found that msc vp class (Miscelaneous System Call) are too loaded, as you can see in the following onstats: Can anybody tell me the reason, or can point me to the correct documentation to understand…
LTAPEDEV to /dev/null from onmonitor
Kindly Ignore this as another thread is open with same content.…
IDS hangs; IBM diagnoses resident memory problem
Never had an issue with " RESIDENT " but then again currently we are not using it. Too many things sharing the server. Are you sure you aren't running into a memory leak like the descriped in the following: IBM APAR: IY91677: ADD MEMORY CACHING FOR LIBS GETUSERATTR/PUTUSERATTR…
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…
Error -23197 from scheduler
Using 11.50 X1, am seeing the following error in online log: ... 17:58:56 SCHAPI: Error -23197 Database locale information mismatch. 17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics Evaluation, Location: NULL. 17:58:56 SCHAPI: Type: TASK, Name: Auto Update Statistics…
ontape causing problems with IDS 9.4
Hi. The OS is AIX 5.2 The problem with the archives actually occurs from ontapes scheduled in the cron.…
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: IDS 11.5 licence question: virtual versus physical processors ?
Martin Thole wrote: > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. > > How many processor licences are neces…
Re: IDS 11.5 licence question: virtual versus physical processors ?
"Martin Thole" <mth@o-b-s.de> wrote in message news:48e3667f$0$6617$9b4e6d93@newsspool3.arcor-online.net... > We are planning to migrate our database server to a VMware server. > The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 > cores), > but the (virtual)…
IDS 11.5 licence question: virtual versus physical processors ?
We are planning to migrate our database server to a VMware server. The new machine will be a HP BladeServer with 2 Quadcore-processors (=8 cores), but the (virtual) Linux-OS will only use 2 (virtual) cpu cores. How many processor licences are necessary ? Which database editons (…
Vertias Netbackup Policy/schedule?
Hi everyone. I know this may be a little off topic. When using Veritas netbackup with Onbar does anyone know where the backup schedule info is kept? I believe it is the so-called POLICY file but I can't find that file anywhere. Thanks, Will…
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…
How to Get PID to Kill IDS process
I would first of all call into Informix Support when you have an instance that is hung and not responding to onmode -ky. You should be able to get to the Down Systems group in this scenario and one of the engineers there can help you diagnose why the engine is in that state. You…
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…
Hardware advice please
Hi all, I am looking for advice on what servers to buy to replace our existing informix db servers. We have to replace them, because they are dinosaurs and could pack up at any moment. Unfortunately I don't really have any idea what would be good to get as I've never been involve…
segmentation fault with c4gl
Hi Henrique Lima, This code has been scheduled to run every day once through the crontab utility. Initially it was working. So, this implies that the problem is occurring after running the program several times. Thanks for your response. Regards Kiran.…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
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…
Analysis of activities during checkpoint.
Hi Vartika, Please check this link. You can add but not drop virtual processors of the AIO, PIO, LIO, TLI, SHM, SOC, and STR classes. http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ad ref.doc/adref308.htm Thanks.. Amitava E - id : amitacha@in.ibm…
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.…
Veritas Netbackup to schedule onbar
Hi everyone. I have a IDS 9.4 database that uses Veritas netbackup to schedule the onbar backups on a Unix AIX machine. General question...If I were to need to do an onbar restore there is no reason why I would not just do a typical command line driven onbar restore...is that cor…
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 database virtualization
Hi, I saw one running on XEN Linux. The VM was running in paravirtualization mode.The usual OS-dependent functionality was OK: no age, processor affinity, raw devices, direct I/O. It did not have UDRs and datablades. Performance was about the same as running IDS in the domain0 (…
CPU-VP issue
Straight from the doc: "On a single-processor computer, allocate only one CPU virtual processor. On a multiprocessor computer, do not allocate more CPU and user-defined virtual processors, combined, than there are CPUs on the computer." Mike…
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…
IIUG Conference
When can I expect to see a detailed conference schedule released? Thanks Peter…
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…
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…
IDS 10.0
Hi, While setting up a test environment, a question concerning the correct setting for NUMCPUVPS popped up. We have a Hitachi SAN with fifty-seven 52 GB chunks allocated to this instance. Memory is 8 GB $ uname -X System = SunOS Node = test_1 Release = 5.10 KernelID = Generic_…
CPU Help
First, thanks for your time here. You're right it is confusing. I ran topas and noticed (Online Virtual CPUs: 8, Online Logical CPUs: 16) Does that mean 16 physical cpus? I have 167x4gb dbspaces. Your suggestion then would be: VPCLASS cpu,num=15,aff=1-15,noage VPCLASS aio,num=16…
Physical Processor to Virtual processor mapping.
Hello Everyone, We had recently retired one of the cluster nodes and are running the two Informix instances in the same node. We have also added additional CPUs to this node. Solaris version 9 IDS version 9.40 FC4 mpstat CPU minf mjf xcal intr ithr csw icsw migr smtx srw sys…
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…
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…
Re: RSS Feeds for Product Lifecycles
On a somewhat similar note, do you or anyone know when a particular release is going to come out? Is there a schedule? The last release for 10 was ~January, and I'm wondering when xc7 is going to come out. -Nate…
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.…
Cheetah available at PA
Cheetah is already available at Passport Advantage (electronic delivery) Media and documentation are scheduled for July 30. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...…
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.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: Memory leak on AIX 5.3
On Apr 2, 2:06 pm, "Eric Rowell" <erow...@gmail.com> wrote: > Please look at the APAR's already supplied (All memory leak issue IBM > provided me are listed below, some are fixed) as AIX has at least a > few issues with memory access issues. > > Also if you notice the Service Pac…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: Mapping cpuvp's to IBM virtual processors ....
On Thu, 2007-02-22 at 17:27 -0500, ART KAGEL, BLOOMBERG/ 731 LEXIN wrote: > For soctcp use 1 or 2 NET VPs (a net VP should handle over 200 connections > efficiently but I like to keep that below ~150 myself). I added 2. > > #LRUs controls contention between users. In order to re…
Re: Mapping cpuvp's to IBM virtual processors on p
Your assumption is partially correct. You don't NEED all 6 CPU's allocated to CPU VPs, but it's a good thing. The IDS scheduler will allocate sessions to CPU VPs as needed so it's possible that one or a few logical CPUS will be harder hit than the others. That said there are tuna…
Mapping cpuvp's to IBM virtual processors on pSeri
We're currently running a read-only instance of IDS 10.0FC6 on AIX 5.3 TL-05. The logical partition (LPAR) hosting IDS has 2.4 physical CPU's, divided into 6 logical CPU's. Running nmon's cpu monitor shows CPU 0 at about 50% used, CPU1 used occasionally, and CPU 2-5 are idle. I'm…
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…
VP error
IDS 9.4 error in log file. Database restarted and no errors reported. Any ideas on the seriousness of this error? 23:31:18 Fatal error in ADM VP at mt.c:12243 23:31:18 Unexpected virtual processor termination, pid = 499808, exit = 0x90009 23:31:19 invoke_alarm(): /bin/sh -c '/ho…
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…
CPU idles
> Hi, > > First: it is possible to set the NUMCPUVPS parameter to a > higher value than actual processors in the system. This > sometimes leads to better response times. (when you encounter > idle time on your CPU (using sar) and the number of active > threads is not decreasing).…
Holy Sh
So maybe the "marketing blitz" you referred to in your other thread is starting to roll out?…
Re: onmode -ky hangs [7652]
Hi Frank, Sorry for late reply! If 'onmode -ky' does not work, you can kill all oninit processes. Another way, run 'onstat -g sch' and get the PID for 1st CPUVP and kill that PID. It will take the informix server down. Thanks, Sanjit ---------[ Received Mail Content ]-----…
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…
running a procedure based on a schedule
Hello, Is there any way to schedule a procedure in IDS 9.40 to run at a certain time and day ? Thanks a lot…
Re: VP memory cache (was IFX_FOLDVIEW)
Guy . wrote: > > What is this "Virtual Processor Memory Cache"?? > > This feature is fallout from Informix revisting the world of benchmarks, as is the other xC5 feature, Fastpoll. > Well IDS 10.00.xC5 is out now. And the release notes do not mention (even though this was menti…
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?…
Informix maintenance and support schedule
Hi All, Some place in the Passport Advantage site is the schedule for when Informix maintenance and support for the various version will end. Anyone know where I can find it? Thanks Doug McAllister…
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/…
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 …
HP-UX KAIOON
Alex wrote: > I try to run Informix with async. kernel io on a HP Itanium 4 Processor ... > onconfig entry: > VPCLASS kio,num=2,noage > > > BUT, after initializing with oninit there is obviously no usage of the > kernel async driver. > > > The command output of "onmode -p…
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…
Informix 9.4 und MSSQL2000
Hi, For Datawarehouse anaylsis, we need to import data from our Informix Server to Our MSSQL 2000 Server. We are using DTS, this works as long as you start this packets maually. If we try to use to schedule these Jobs, it is not working. Are there special ODBC or whatever driv…
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!…
onstat -g iog
You won't see 2 even though you think you have only 2. You would see 6 aio classes if you didn't add one dynamically. I believe some of the threads are using the AIO class of virtual processors which can be broken down as: aio because NUMAIOVPS =1 (in your onconfig) adm (administ…
Re: cannot start with 4 AIO virtual processor
On Windows platforms IDS is KAIO only, hence in most cases there is no need for more than 1 AIO VP. In IDS versions prior to 9.30.TC6 this limit was enforced and an error was generated when a higher value was used. With KAIO systems the AIO VP is still used for some tasks such …
Re: cannot start with 4 AIO virtual processor
informix can only be run with 1 aio vp under windows. Any other value results in the server being started with 1. Unless 9.40 and 10.x are different (haven't checked)? Regards Stefan ********************************************************************** This email and any fil…
Re: cannot start with 4 AIO virtual processor
BTW, i forgot to tell... the ontape failed and, although, it can be a tape's problem we can cover all posible aspects... we have 4 cpu and 3 of them are assigned to informix and 4gb in ram with 131072 buffers...…
Re: cannot start with 4 AIO virtual processor
"Jaime Casanova" <systemguards@gmail.com> wrote in message news:1137432864.044113.214560@g43g2000cwa.googlegroups.com... > Hi, > > OS: NT4 > IDS 9.21 > > Last saturday i was trying to make a level 0 backup so i execute: > ontape -s -L 0 > > And it gives me this message: > > Warni…
cannot start with 4 AIO virtual processor
Hi, OS: NT4 IDS 9.21 Last saturday i was trying to make a level 0 backup so i execute: ontape -s -L 0 And it gives me this message: Warning: Dynamic Sever 2000 cannot start with 4 AIO virtual processor, limit exceeded. Started with 1 AIO virtual processor. I didn't configure…
Re: why can't XPS 8.x be opensourced
Yes - 8.51 is the scheduled last release. A number of existing clients are well aware of this, and are still choosing to use XPS. As I mentioned, they are heavily invested in people, hardware, etc...and without a doubt know that XPS is the best product for what they are doing as…
RE: MULTIPROCESSOR settings on a multiple CPU server with
>MULTIPROCESSOR Specifies that you are running on a multiprocessor computer I was getting tripped up on: Running on a Multiprocessor Computer If you are running multiple CPU virtual processors on a multiprocessor computer, set the MULTIPROCESSOR parameter in the ONCONFIG file t…
FW: Informix versus Oracle Spatial
This is awesome work. I think it touches on some very salient points, especially regarding virtual processors and threading. It is amazing that Oracle technology could have gone so wrong despite the amount of money they have as a company, and how they could not come up with a b…
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.…
Crash of the instance
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
Posting from the Informix-list
Hi all, Informix Dynamic Server Version 9.30.UC2X7 Suse Linux msp275 2.4.21-190-smp Chrash: 15:32:25 Maximum server connections 20 16:00:21 Logical Log 21747 Complete. 16:00:23 Logical Log 21747 - Backup Started 16:00:23 Logical Log 21747 - Backup Completed 16:00:23 Fatal…
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…
SqlAnywhere and the Windows Task Scheduler
I've got a scheduled task that is supposed to execute a batch file that is supposed to interface with a SqlAnywhere 5.0 database in order to do create some CSV files. When I execute the batch files manually they work fine. But when the task scheduler tries to execute the batch …
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: Chav
Captain Pedantic wrote: > "David E. Grove" <david_grove@correct.state.ak.us> wrote in message > news:112v15f1uo1dne3@corp.supernews.com... > >>>How about the "Ch"-- hard or soft? >>> >> >>Like "schedule", "cheese", or "charade"? > > > The "ch" in "Schedule" and in "Cheese" are pr…
Re: Chav
Captain Pedantic wrote: > "David E. Grove" <david_grove@correct.state.ak.us> wrote in message > news:112v15f1uo1dne3@corp.supernews.com... > >>>How about the "Ch"-- hard or soft? >>> >> >>Like "schedule", "cheese", or "charade"? > > > The "ch" in "Schedule" and in "Cheese" are pr…
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…
IDS 10 Download?
So many questions... I have played with multiple buffer pools and different page sizes... creating a dbspace with an 8k page size..oh wow! Make size is only 16K though...oracle (where I guess this idea came from) allows 64K! onstat -h (buffer hash chain info) gives two outputs …
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…
More CPUVPs than processors
Mark wrote: I've always found that for any CPU faster than about 400MHZ (~600 for x86 CPUS) you can run at least 2 CPU VPs per CPU. Now that CPUS are MUCH faster and multi-pipelined and multi-virtual CPU's, you can likely make that 3 or 4 or 5 times # physical CPUs. I think th…
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 ? …
Could not fork a virtual processor: errno = 12
Hello The past week I had a problem with a memory bank of my SUN450 with solaris 8 The problem is already fixed, but I try to rebuilt a secondary instance with HDR y it is no possible, the steps are the same i had used alltimes: onstape -s -L 0 in the primary server in stanard …
DB-Crash
Hi Everyone, IDS: Version 9.30.UC2X7 SuSe Linux 2.4.21 We received the following error messages in our log file: 12:26:42 Logical Log 11992 Complete. 12:26:44 Logical Log 11992 - Backup Started 12:26:44 Logical Log 11992 - Backup Completed 12:26:45 Fatal error in ADM VP at…
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 :-)…
CPU Binding
Hello Everyone, I just wanted to clarify how does IDS determine the number of processors a UNIX box have? Our new server(Sun Fire E6900) uses the UltraSPARC IV processor, which is using the Chip Multithreading(CMT) technology. Through CMT, 20 additional virtual processors are sp…
Informix, TSM (ADSM), and Scheduled Database Backups
We have Tivoli Storage Manager (TSM) 5.1 running on AIX 5.1. TSM is used to backup several AIX servers running Informix, several Informix databases, a couple of Windows servers, and a few developer Windows desktops. All of the AIX and Windows system backups are scheduled via TS…
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'?…
How to set NSR_CLIENT in scheduled backups?
Hi! We have a cluster of two UNIX systems (Sun Solaris 9) each capable of running the same instance of an Informix database server IDS 9.40.FC3. Now we have a problem of getting our scheduled onbar backups back up to the same Legato Networker client resource name.…
How many physical processors we need to support 32K THREADS in IDS.
Hi Team, Informix IDS supports upto 32K threads according to most IDS realease notes. My question is What sort of a machine you are looking at to support this many threads?? This came to my mind when considering max. num of threads(or connections that matter) that each CPU or NE…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: 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…
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…
onbar & Legato -whole system backup
When I start a scheduled backup from Legato Networker 7.1.1 server, I can see in my hp-ux informix 9.21 client that it starts "onbar_d -b L 0" processes. Is there a way to say Legato to start a whole system backup like "onbar -b -w L 0"? Besides that, I tried setting the DO_LOGF…
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…
Re: Unexpected Virtual Processor Termination - HELP!
On Tue, 18 May 2004 08:13:07 -0400, Joel wrote: Bounce both engines. Remote synonyms are usually more trouble than they are worth. Could be better to use ER to replicate the needed data on the other server in a separate local database and access it from there. Art S. Kagel >…
Unexpected Virtual Processor Termination - HELP!
We have two SCO-Unix servers, one runs our order entry and acct software, the other runs the warehouse/inventory control software. Each server has an Informix DB, IDS version 7.30 UC2. The inventory control DB uses synonyms to provide access to data in the order entry DB, and vi…
Setting up JVM on 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html ) and compiled the examples (in extend/krak…
Setting up JVM on IDS 9.30HC5, HP-UX 11i
Hi chaps Having a problem setting up our server for Java UDRs; I have followed all the procedures in the manuals and William White's developerworks article (www-106.ibm.com/developerworks/db2/zones/informix/library/samples/db_java1.html) and compiled the examples (in extend/kraka…
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…
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: Virtual Processors and CPU-Load
Markus, With 2 Xeon (multithreading) CPU's it really makes sense to allocate 4 CPU VP's (not 2 as You did) to use CPU power more efficiently. The other thing to investigate is the 'BUFREADS by partition' statistics. Please, pay very close attention to those tables and indexes t…
RE: Virtual Processors and CPU-Load
Dont post MIME Have you run the correct update stats? In Informix monitor users -- onstat -u the ready queue -- onstat -g rea the sqls -- onstat -g ses {session number} You need to determine which sessions or parts of the application are causing the load. With 200 users you…
Virtual Processors and CPU-Load
Hi all, we are a little bit confused concerning the CPU-Load of our Informix-Database-Server. (9.4 UC3, RH9 2.4.20) We use a 2-Xeon (3.0 GHZ)-Dell-Server and both CPU's are mostly at 99.9%! All tables and indexes (DBSpaces, Extents, ...) are optimized to the best of our knowledg…
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…
Re: RES: Pentium 4 hyperthreading
Linux has support, IDS does not care whether the CPU is physical or a hyperthreaded virtual CPU. It will use it if you tell it to. Art S. Kagel Julio Cesar wrote: > Speaking on Affinity Processors, does anyone know if the IDS 9.40 has > support for this feature on Linux? > AF…
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…
large disks
Maybe. I haven't fully thought through the problem. Nor have I bench marked the configurations. But I do suspect that things such as striping get in the way of all of the IO scheduling logic that we have in place. So by using a single larger chunk, basically we should be elim…
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…
Reduce # of CPU: license cost
IDS 7.3 Customer is looking into possibility to reduce the no of CPU that is running in database server. Reason: cost saving since current charges for Informix license is based on CPU. Question: How to do that without physically removing the CPU ? Can that be done by reducing t…
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…
Unexpected virtual processor termination
Please help me for resolution of an Informix Error : 17:06:14 mt.c, line 10188, thread 9, proc id 8335, Unexpected virtual processor termination, pid = 8336, exit = 0x9 . 17:06:14 Assert Failed: Unexpected virtual processor termination, pid = 8336, exit = 0x9 17:06:14 Who: Sess…
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.…
Scheduling onunload
I am running IDS 9.3 on Windows NT (first mistake). I want to back up my database using onunload, but since it asks you to mount the tape and press RETURN, I am not sure how to schedule this to have it run automatically. Is there a way to buypass pressing ENTER?…
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
Hi, dsolalinde, You must to change the relative to the point in server you updated. The BUFFERS parameter can be bigger than before. I dont know how much BUFFERS you have but you can increment more memory to this parameter. Did it based in the LRU size, and its near to BUFFERS /…
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…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
Onbar Backup?
Hi, I am running Level-1 backup on IDS 9.4.UC1 ,SunOS 8. My question is even though multiplexing is on and set to 8 in the onconfig as well as on the Netbackup side. (Veritas Storage Manager ), the Level-0 backups take about 12 Hours to complete for backing up 90 dbspaces. Each…
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…
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 …
Shared mem connections and semaphores
HeadingDescriptionFormatvpThe virtual processor ID.DecpidThe system process ID for the process running this virtual processor.DecclassThe class of virtual processor.StrsemopsThe number of times this virtual procesor went idle and performed a semaphore operation to wait for work.D…
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…
balancing virtual processors
How do I get the kio's to be more balanced? I'm on a Proliant 7000 4-cpu box using NT4.0. C:\\\\WINNT\\\\system32>onstat -g iov Informix Dynamic Server Version 7.31.TC2 -- On-Line -- Up 08:00:59 -- 1643008 Kbytes AIO I/O vps: class/vp s io/s totalops dskread dskwrite dskcopy …
is index reorganization needed for good performance
Yes Indexes do need to be reorganized periodically. Fragmented indexes can be more of a performance issue than fragmented tables. If you are using indexes heavily, set up a schedule to reorganize the high use indexes where you are doing a lot of inserts and deletes.…
Informix Lockup (Wierd)
----- Original Message ----- From: "Phillips, Rob" <RPhillips@ce-a.com> To: <ids@iiug.org> Sent: Thursday, January 30, 2003 8:14 PM Subject: Informix Lockup (Wierd) [184] > Occasionally I am experiencing Informix locking up. It won't accept any db > connections, or process any S…
RE: # of instances per machine
I like having 2. One XPS setup, one IDS setup for the OLTP needs. I wish there was conncetivity between them. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 2:42 AM > To: informix-list@iiug.org > Subje…
what is busy waits?
hello, in the onstat -g sch output illustrating VP scheduler statistics. What are busy waits? can anyone explain in detail? bye sudhakar -- Posted via CNET Help.com http://www.help.com/…
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/…
RE: # of instances per machine
It depends. What version are you running? If version 5 then perhaps that might be a good rule. I would not consider running 7.x+ on less than 4 CPUs. It also depends on whether these instances will all be active at the same time, if they can swap out...... However. I am hig…
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…
# of instances per machine
If the question is 'should' you configure, the answer is ONE! Certainly for a production server. If you have man CPUs then you can likely get away with 2-4 with enough memory. Art S. Kagel Christian Eriksson wrote: > > Hi! > > I wonder if there's any recommendations about how…
FW: what does lngspins mean?
Longspins are spin locks that virtual processors have spun more than 10,000 times in order to acquire. To reduce longspins, reduce the number of virtual processors, reduce the load on the computer, or, on some platforms, use the no-age or processor affinity features. Dirk Reach …
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…
Error using crontab
Hi, When I'm using crontab to do scheduling, it never works. I notice that 1 minute after the time that I specify in the schedule, a message appear in my prompt like this: awf_web sendmail[1845]: unable to qualify my own domain name (awf_web) -- using short name Is there any pa…
Re: Backup Scheduling
Dear Impy, Thanks for reply. I tried the command : at 01:00am /EVERY:m,t,w,th,f,s -f at_onbar_l1 at_onbar_l1 is the filename contains the command. But it won't work. The message : at: bad time specification Your clues, please... Thank you. Best Regards, Chelsia…
Re: Backup Scheduling
herp, my assistance was for UNIX :) Ok, try removing the am from the 01:00 brett chelsia wrote: > > Dear Impy, > Thanks for reply. > I tried the command : > at 01:00am /EVERY:m,t,w,th,f,s -f at_onbar_l1 > > at_onbar_l1 is the filename contains the command. > But it won't work.…
Backup Scheduling
Hi, Happy New Year to all of you. Have a nice holiday? Btw, I need your help to do scheduling using onbar and ontape. What are the scripts? I've already tried using "at" command to do onbar backup, but it runs for only one time, not every day. I've also already tried "crontab" c…
Re: Backup Scheduling
Morning, yes, at is for single jobs, cron details: minute hour day_of_month month weekday command minute 0 through 59 hour 0 through 23 day_of_month 1 through 31 month 1 through 12 weekday 0 through 6 for Sunday through Saturday command a shell command Plenty referen…
RE: Backup Scheduling
cron or at are good scheduling tools. -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of chelsia Sent: Friday, December 22, 2000 4:28 AM To: informix-list@iiug.org Subject: Backup Scheduling Helloooo... D…
Backup Scheduling
Helloooo... Does anybody know how to run backup scheduling using onbar and ontape? And MERRY CHRISTMAS + HAPPY NEW YEAR!!! Thank you. -- Best Regards, Chelsia…
RE: Backup Scheduling
Hi chelsia In unix you would have to use the unix cron to schedule the job. In windows you would use the "AT" to schedule jobs Donald -----Original Message----- From: chelsia [mailto:chelsia@allworkforce.com] Sent: Thursday, December 21, 2000 18:28 To: informix-list@iiug.org S…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
RE: Assert Failed: Unexpected virtual processor termination, pid
nope. but oncheck was being run. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: 30 November 2000 18:12 To: yfwoi@tpl.com.sg; informix-list@iiug.org Subject: Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0…
Re: Assert Failed: Unexpected virtual processor termination, pid = 74 095, exit = 0x100
Did someone kill an oninit process? From: Woi Yew Fong <yfwoi@tpl.com.sg> > >Can somebody tell me what could have happened to IUS the based to the >following extaraction from online.log? > >============= extraction from online.log ================ > >16:13:14 Assert Failed: U…
Assert Failed: Unexpected virtual processor termination, pid = 74
Can somebody tell me what could have happened to IUS the based to the following extaraction from online.log? ============= extraction from online.log ================ 16:13:14 Assert Failed: Universal Server must abort 16:13:14 INFORMIX-Universal Server Version 9.14.UC1 16:…
RE: affinity process problem
Does your Informix release support the AFF_SPROC and AFF_NPROCS parameters on AIX? From: http://www.informix.com/informix/resource/pubs/ids/0731uc6/ibm0731m.txt ================================= MACHINE SPECIFIC NOTES …
FW: questions onstat -g
Sorry, wrong answer. onstat -- doesn't explain the columns to you, it just gives you the onstat options. I've been looking for column explanations myself. Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Beh…
RE: questions onstat -g
do an onstat -- and you will get alll -----Original Message----- From: Marat S. Salimov [mailto:maratkotik@mail.ru] Sent: Tuesday, November 21, 2000 4:30 PM To: informix-list@iiug.org Subject: questions onstat -g Where can I find reading about meanings of onstat -g ... columns.…
questions onstat -g
Where can I find reading about meanings of onstat -g ... columns. By example onstat -g ioq: dskcopy onstat -g sch: busy wait, spin/waits…
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: Article on the Informix SPLIT
> Maybe they're trying to spell septic (the 'c' is silent, like in 'shedule' instead of > 'schedule'). That could explain a lot. (sorry for the late response, but I've been > sick) Felt a little septic did we? cheers j.…
RE: USERTHREADS / TRANSACTIONS
I think they are mixing Informix versions 5.x use's these not 7.x There is a bug with Informix and BMC, need 7.31.uc5 or higher. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Rolf.Schoepfer@swisscom.com [mailto:Rolf.Schoepfer@swis…
RE: USERTHREADS / TRANSACTIONS
The parameters USERTHREADS and TRANSACTIONS no longer apply to IDS 7.31. As a matter of fact the database server does not limit the number of users/connections, except of course if YOU explicitly set them. Don -----Original Message----- From: Rolf.Schoepfer@swisscom.com [mailto…
USERTHREADS / TRANSACTIONS
Hi We are going to use Patrol for montoring an IDS 7.31 RDBMS on Reliant UNIX 5.44. Patrol monitors many parameters, two of them are USERTREADS and TRANSACTIONS which can be seen with onstat -ux. BMC ( company who develops Patrol ) says, that there's a limit of both of them. In …
RE: question for affinity (AFF_NPROCS,AFF_SPROCS)
From $INFORMIXDIR/release/en_us/0333/IDS_7.3 on AIX: 7. The Processor Affinity feature (ONCONFIG variables AFF_SPROC, AFF_NPROCS) that allows the pinning of CPU VPs to physical processors in a multi-cpu configuration is NOT supported in this release. On AIX 4.2.1, the b…
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: Scheduling SQL statement
In addition to Lars' suggestions there is the venerable: dbacces databasename - <<EOF --- SQL Stuff --- EOF Art S. Kagel NEWS wrote: > > Is there a way that I can put SQL statements in a file and run them from > cron? I am on Informix 5 on SCO. The manuals refer to being abl…
Re: Scheduling SQL statement
NEWS <gary.berger@odnss.com> wrote: > Is there a way that I can put SQL statements in a file and run them from > cron? I am on Informix 5 on SCO. The manuals refer to being able to supply > a file of inputs instead of going interactive. The programs it sites are > dbaccess and…
Re: Scheduling SQL statement
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> There are many ways of doing this, <p>echo "sql stuff" | dbaccess <database name> <br>E.G. <br>echo "select count(*) from <what ever you have of tables>" | dbaccess <database name> <p>or <p>cat <fil…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
How to schedule ontape command
Hi How can I schedule ontape command because it requires Return Key to be pressed after executing the command? Thanks M Usman musman@iffco.com Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Oninit & Instance
Found in "onstat -g glo" Individual Virtual Processors Section -- Class CPU. Neil, Stephen & Edward, thanks for your help. Nick Kataria <kataria.nick@emeryworld.com> wrote in message news:8jdblp$c3e$1@news.cnf.com... > Hi All, > > If I have a process ID of an oninit process (fr…
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…
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…
FW: Arizona Informix Users Group (AIUG) Meeting Postponement
-----Original Message----- From: Deborah Decorrevont [mailto:deborah_decorrevont@choicehotels.com] Sent: Friday, April 07, 2000 4:20 PM Subject: AIUG Meeting Postponement The vendor scheduled for the AIUG meeting on April 12th has run into some internal scheduling conflicts and …
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…
KAIO in AIX
Andre Ngo <andre@fiscal.org.jm> wrote in message news:8augdc$aj7$1@nnrp1.deja.com... > Hi all!!! Hi . > I came to a deadlock tying to figure this one out. > Is there a way to add more KAIO to the engine? Number of kio threads is equal to the number of CPU virtual processors in…
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…
Re: CPUvps
Steven wrote: > > Hi, > > Got the following on my IDS 7.24UC4X1 on HPUX10.20 (5 CPUs, 9 CPUvps) That's a ratio, if my maths is up to it, of 2 VPs to 1 CPU!!! > pri:informix 23> onstat -g glo|grep cpu > class vps usercpu syscpu total > cpu 9 …
CPUvps
Hi, Got the following on my IDS 7.24UC4X1 on HPUX10.20 (5 CPUs, 9 CPUvps) pri:informix 23> onstat -g glo|grep cpu class vps usercpu syscpu total cpu 9 192149.07 15658.73 207807.80 vp pid class usercpu …
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…
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…
when informix-server down ?
Andreas Lommel wrote: > > Hi,- I think it`s better when I bring the informix db-server from time > to time down and start the server new. My question: Can I see when > it`s the right time (memory, ..) PLATFORM and VERSION info? There should be no need to bounce the engine perio…
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: Assert Failed: Unexpected virtual processor termination
> Hi gurus, > > IUS Version 9.14.UC6 > O/S = HP-UX 10.2 > > Way back in August before I stumbled across this list > IUS crashed and the online.log showed: > > "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" > closely followed by: > "Assert Failed: Unexpected virtu…
Assert Failed: Unexpected virtual processor termination
Hi gurus, IUS Version 9.14.UC6 O/S = HP-UX 10.2 Way back in August before I stumbled across this list IUS crashed and the online.log showed: "Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem" closely followed by: "Assert Failed: Unexpected virtual processor termin…
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: oninit question
1) seems to indicate that we are in quiescent mode. No! it indicates that the oninit process was instantiated with the -s flag. 2) Are all of these processes necessary Yes! have a look at onstat -g sch 3) can I safely kill them off? No comment. 4) What started all of …
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…
automation of ontape on NT
I tried running the ontape facility from the NT scheduler. I included all the necessary environment commands. It does not work. Am I doing something stupid. Is there a way of automating backups on NT. Allan…
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…
Program for OOPSLA Workshop on Java and Databases
The schedule for the workshop is now on-line at: http://www.soi.city.ac.uk/~akmal/oopsla99.dir/workshop.html and http://www.sdm.de/g/oopsla/ Regards, akmal Sent via Deja.com http://www.deja.com/ Before you buy.…
CPU VPs & logical buffer util. & read ahead util.
In article <938074971.13201.0.nnrp-07.c1ed6ac3@news.demon.co.uk>, Fergus Hayne <fhayne@brand-rex.com> writes >Hi All, > >Hoping someone can give me some pointers regarding my config. > >Thanks in advance. > >HP K460 >4 CPUS >4Gb Memory >2 instances of Informix OnLine >2 Baan inst…
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…
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…
RE: [Question]OnBar
The following website contain tools from Maury Tiller for troubleshooting and tuning onbar performance. By following his step-by-step procedure you can determine where the bottleneck lies. It also contains programs which he mentioned during a technical session at the Informix So…
[Question]OnBar performance problem
I have question about OnBar performance. One of my site uses OnBar with Informix Product : Informix 7.23UC1 System : IBM SPNODE OS : AIX 4.1.3 Backup Device : StorageTek TAPE Array Storage Manager : SCH Storage Manager The StorageTek TAPE Array can backup multiple host via netw…
[Question]OnBar
I have question about OnBar performance. One of my site uses OnBar with Informix Product : Informix 7.23UC1 System : IBM SPNODE OS : AIX 4.1.3 Backup Device : StorageTek TAPE Array Storage Manager : SCH Storage Manager The StorageTek TAPE Array can backup multiple host via netw…
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…
Re: Affinity
FYI.. On Solaris, if one want to use O/S Process binding then do following - onstat -g sch will give you the pid of CPU VP - Use "pbind -b" command to assign the pid of CPU VP to specfic CPU which you can collect from "mpstat" command. - Also if you want to see that your CPU …
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…
Informix performance Issues
Dinkar Rane wrote: > > We are facing serious informix performance issues, to the extent that > usres are not willing to use the system. Ouch . . . it must be bad . . . > The system is a data warehouse implementation. The data size including > indexes etc. is about 8 G. It is ru…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
RE: Serious performance issues
There appears to be HUGE contention with this application. This is an application issue. large number of latch waits (wait for OS resource - see admin guide on latches) large number of lock waits Do you have lock mode row? (not the default) You have a large number of seque…
64 bit IDS
Does anyone know the status of the 64 bit version of IDS? Supposedly, a June release had been (re)scheduled. Any news? David Grove…
RE: Serious performance issues
Hi Bill My $0.02... I notice in your "onstat -g ioq" output, all your kaio queues are showing pretty high (up to 85 in once case!) maxlen's. According to my Informix instructor, a maxlen > 25 indicates that disk requests are not being serviced fast enough. The first step in rem…
Re: Serious performance issues
Bill, How many tli poll threads are you running? If a tli poll thread runs on a cpuvp it will generate semops and busy waits like you see on vp 7. Look at the NETTYPE parameter. BTW. I know you are a Sequent/Informix user from previous posts. What revs are you running and ho…
RE: Serious performance issues
One thing I forgot to mention in the last email, the only other major change was that we introduced referrential integrity via primary/foreign key constraints which was not on the previous database. We've had several issues with that already (mostly locking related issues where …
RE: Serious performance issues
What is the effect of the application / database redesign? You dont say what hardware configuration, OS, Informix versions .... If IDS, have you run update statistics medium? Do you now have the right indexes for the new application? Can you trace a slow sql from onstat -g se…
Serious performance issues
In the past few weeks, we went through a major upgrade of our database where we completely redesigned a large portion of the database structure, migrated the data, and updated the applications. Since that period, we've had serious performance problems. We went from a system tha…
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…
RE: Memory Usage on Informix 7.24
Hi Lee, What onstat commands are you running? I think you might be trying to mix apples and oranges here. We are using Sun (2.5.1) as our OS and Informix 7.24UC3. I don't know anything about NEC machines. Output from the Sun ps command can show you the size of a process=20 …
Memory Usage on Informix 7.24
LEE Hsin wrote: > > Hi, everybody=20 > > I have a question and hope you could give me suggestions. Now, we are = > developing an application on NEC UP machine (UNIX) with Informix 7.24. = > After starting up Informix, we use onstat utility to see how many memories = > used by Inf…
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…
Informix 7.3 on NT Slow when replication across WAN
Hi, I have recently setup a Informix Replication server from Informix 7.3 running on Solaris 2.6 to a new Single PII 450 processor box running NT SP3 (256 MB Mem). When replication starts the processor sits at 100% for up to 20 mins Even though There were only 3 entries in the t…
RE: NET or CPU VP Class : confusing NETTYPE recommendations
Mario, My company is running a SUN E4500 in our production environment as the DB server/CI. We are running SAP R/3 (3.1H). The E4500 has 6 Processors and 4 gig memory. We have 3 E3000 application servers connected to the CI. Here is what I have notice when moving poll threads of…
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…
RE: Processor affinity
Yes, its possible to determine which physical CPU's the VP's run on. We are running Sun Solaris as our O/S and it looks like you might be also. Using the pbind command, I can list which physical CPU's process are bound to. Then, using onstat -g sch, get the pid's of the oninit pr…
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…
Re: onstat -g sch , Busy Waits ?
Jay Aymond wrote: > rdavis@rmi.net wrote: > >In article <78kcue$kng$1@nnrp1.dejanews.com>, > > darren_m_rogers@my-dejanews.com wrote: > >> Hi, > >> Could anyone explain what may cause a large number of 'busy waits' ? > >> Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00)…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
RE: onstat -g sch , Busy Waits ?
According to "Informix, DBA Survival Guide" by Joe Lumbley, on page 260, Monitoring Virtual Processors, "When a CPU VP does not have a thread to run, the process performs a 'busywait' . This is a loop of instructions designed to wait a short time". So comparing CPU VP Number 3, …
onstat -g sch , Busy Waits ?
Hi, Could anyone explain what may cause a large number of 'busy waits' ? Informix Dynamic Server Version 7.30.UC5 (HPUX-11.00) VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 1495 cpu 29 31 967 2 1…
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?…
Need help on OmnibackII backup Scheduler
Hi, everyone. I have set up a OmnibackII backup process, tested the backup by manually submit it. Every thing worked fine. Then, I scheduled it to run at a particular time. But no backup process ran when the specific time is reached. It didn't give me any error message, and sche…
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.…
Re: oninit & user threads
onstat -g sch will tell which vp is in which oninit process. This doesn't change. onstat -g act will give you the running threads. Steve Berg On Mon, 21 Dec 1998, Sean Kelsey wrote: > Yuletide greetings to one and all ! > > Chit-chat over, lets get on with my question... > > …
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…
Re: IDS & Workgroup Edition
John H. Frantz wrote in message <366D3928.E7586C67@rl.is>... >I'm finding it hard to determine what the essential differences in >functionality are between plain IDS and the Workgroup Edition. I've >gathered the following information from various sources, but I'm not >sure if it'…
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…
Scheduled Backup of informix on Nt
Steve Start the schedule service to logon as domain\\informix. Works good last a long time. And then issue your AT commands to run your job at night. Kevin -----Original Message----- From: steve [mailto:bismuth@globalnet.co.uk] Posted At: Wednesday, November 18, 1998 11:…
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…
Scheduled downtime for www.informix.com
All Informix users and customers: The Informix internet site (http://www.informix.com) will be taken down Sunday, October 4, from 8:00 AM CDT to 9:00 AM CDT for routine maintenance. Please make a note of this downtime for future reference. This will effect the following Informi…
Re: about virtual processors
> > Hmmmm....meaty stuff as usual, thanks for taking the time to > explain....so is the "timeslice" kernel tunable available generally and > if so could you point me in the right direction to read up on it and/or > use it?? > > Thanks > > Greg > You might try 'The Magic Garden' …
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: about virtual processors
Art S. Kagel wrote: .> .> Greg wrote: snip...... .> .> Hi Greg. It is not Solaris so much as having FAST CPUs. I have seen .> that on a system with only 2CPUs of speeds up to 150MHZ that there is .> no significant gain from more CPU VPs then nCPU-1. On our DGs which .> use 32 …
Re: about virtual processors
Greg wrote: > > Art - > > I can't tell you how giggly I am that you seem to be coming around to my > long held assertion that the "conventional wisom" of: NUMCPUVPS = > realCPUs-1 (or so) ain't necessarily so.....could it be your switch to > Sun/Solaris that's changing your mind…
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:…
Re: about virtual processors
Art - I can't tell you how giggly I am that you seem to be coming around to my long held assertion that the "conventional wisom" of: NUMCPUVPS = realCPUs-1 (or so) ain't necessarily so.....could it be your switch to Sun/Solaris that's changing your mind?? Most of my (admittedly…
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: about virtual processors
For a 2CPU system most of us recommend using only a single CPU VP. Based on this, set: MULTIPROCESSOR 1 NUMCPUVPS 1 SINGLE_CPU_VP 1 NOAGE 1 AFF_SPROC 0 AFF_NPROCS 0 This is because IDS does not take advantage of only two CPUs well due to the overhead of managing the addit…
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…
about virtual processors
hi all: Could someone explain a little bit about virtual processors and their configurations? I am running workgroup dynamic server on sun solairs 2.6 with 2 sparce 300 mhz cpu and 256 meg of rams. how many vp should i assign to io and cpu, what's the relationship, an…
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: Dynamically adding shared memory segs
Bill Weaver wrote: > > Today for some reason we've added 5 shared memory segments dynamically. It almost never happens > that we even have 1 added since I've worked to size our initial segment to avoid this. How can > I tell what is causing us to add so many all of a sudden? > …
schedule a program to run base on data in a table
how can i schedule a program to run based on data in a table (e.g. run this program if the count of orders for this customer is 10)…
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…
ontape for logical log backup
is there a way to implement the backup of logical logs from a script using ontape? If you have such script, and it can be scheduled with cron, I would like to see it. Thank you zeida heavener broward county zheavener@co.broward.fl.us…
Re: onstat -g sch
In article <6m99tq$9s5$1@news.xmission.com>, Luse Harold <hluse@vth.colostate.edu> writes > >Would anyone know what the semops, busy waits and spins/wait columns are >in onstat -g sch? > semops = semaphore operations busy wait = when Online needs to obtain a latch and cannot it…
onstat -g sch
Would anyone know what the semops, busy waits and spins/wait columns are in onstat -g sch? VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 86938 cpu 0 0 0 2 81346 adm 0 0 …
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: Virtual Processors
I had the same problem. It happens with big queries and you cant stop it really. The VP usually uses what it needs. The best option is to turn NOAGE off, so that the processes age and allow the OS some use of the CPU. Rgds, Jason On Mon, 08 Jun 1998 11:46:55 GMT, darren@syste…
RE: Virtual Processors
Darren, You might check your NOAGE and AFF_SPROC / AFF_NPROCS settings, and then see what your release notes say about those parameters. If this is just occurring when you run specific programs, what is the PDQ_PRIORITY that you are using when you run them? HTH. Paul Mosser O…
Re: Virtual Processors
You need to send us some more info. Is this a SMP box? How many CPU's? What applications are causing the problem? CPU bound Informix engine is not necessarily a bad thing, but if the entire system is slowing down then you need to tune a few things. What to tune depends on wha…
Re: Virtual Processors
darren@systeam.co.uk wrote: : I have a problem with a customer's site with a CPU virtual processor which : seems to be running out of control. It occours when I run one or two : programs, the CPU VP is taking about 90% of the system CPU time, and therefore : bring the system to a…
Virtual Processors
I have a problem with a customer's site with a CPU virtual processor which seems to be running out of control. It occours when I run one or two programs, the CPU VP is taking about 90% of the system CPU time, and therefore bring the system to a general go slow. The Informix engi…
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…
Re: AIO virtual processor
Also sprach <dwillem@ibm.net> : :In the event viewer of Windows NT (4,0), everytime the server is started, we :see the next warning : :INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, :limit exceeded. Started with 1 AIO virtual processor. : :What to do …
AIO virtual processor
Hi, We're running Informix 7.23TC1 on a Digital Alpha 4100 with 3 processors. In the event viewer of Windows NT (4,0), everytime the server is started, we see the next warning : INFORMIX-OnLine Database Server cannot start with 2 AIO virtual processors, limit exceeded. Started …
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…
Re: Informix training (classes) in North Carolina
check out www.informix.com - there should be a list of training sites there and a schedule. Sorry I can't tell you where to look therein - folow your nose. cheers j.…
Re: Informix training (classes) in North Carolina
Kevin Bass wrote: > > Where can I find Informix training (classes) in North Carolina? Check out the course catalog, schedules, and facility maps on the Informix Web site: www.informix.com Art S. Kagel…
Re: Informix Scheduling on NT
You could also use the Metacube Scheduler of Informix I don't know if they're selling it as a separate product though. bye, Zandy zandy@skyinet.net In article <354426FC.82748C17@cs-controlling.de>, "Volker Fr�nkle" <VFraenkle@cs-controlling.de> wrote: > > Hello norli, > ther…
Re: Informix Scheduling on NT
Hello norli, there is a 'at' command on the DOS-BOX of NT. You have to start your Scheduling Service, then you can work with 'at'. There are also, some freeware-schedulers. Yours, Voker norli schrieb: > Hi all, > > Is there a way I can schedule some database processes, ie. Up…
Re: Informix Scheduling on NT
This is a multi-part message in MIME format. --------------0A1D2EF7C96F00589B2AA8D0 Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit You can use the at command. This can be issue…
Informix Scheduling on NT
Hi all, Is there a way I can schedule some database processes, ie. Update a table monthly, on NT? I'm running Informix Online 7.22 on NT 4.0. There should be something like the cron job on UNIX right? Really need help... Thanks! - norli -…
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…
Re: poll threads
Bill, We have recently gone through (and still experience some connection problems) the same problem. In our environment, we had the following settings: DATABASESERVER sparky_shm DATABASERVERALIAS sparky_tcp NETTYPE tlitcp,4,500,CPU # This number is hi…
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…
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…
Re: slow performance
Thuc Nguyen wrote: > > 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.... [SNIP] > …
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. _____________________________…
Re: ideal backup schedule
In article <6eccug$u1$1@news.xmission.com>, ANTS <sui@naseej.com> writes > >Hi, > >We have informix 5. We are doing level 0 backup every night but we dont keep >any back up for the log. > >What is the ideal backup strategy? Is it to take a level 0 like every period >of time but t…
ideal backup schedule
Hi, We have informix 5. We are doing level 0 backup every night but we dont keep any back up for the log. What is the ideal backup strategy? Is it to take a level 0 like every period of time but to take the logical logs continuously?? Regards, Nien ===========================…
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…
Multi-threading with INFORMIX 7.23
Is anyone aware of any problems or issues concerning Multi-threading with INFORMIX 7.23?…
Re: Cant Schedule a dbexport on NT
} I want to do a dbexport every night on my NT server. Ive written a program } (dumpit.exe) which does this just fine when I run it manually from the Command } Line Utilities. However, when I attemt to put it in my scheduler, nothing } happens. } } Ive started my scheduler (Con…
SCHEDULING TASKS IN INFORMIX
Hi all: I am developing an Informix OLGWS-based system on Windows NT 4.0. Is there any possiblity of scheduling tasks (e.g., to run a determined SP every night at 3:00) without the use of external programs ???? I Know it is possible with MS-SQL Server, so I guess it must be…
Cant Schedule a dbexport on NT
> Hey all - > > I want to do a dbexport every night on my NT server. Ive written a > program > (dumpit.exe) which does this just fine when I run it manually from the > Command > Line Utilities. However, when I attemt to put it in my scheduler, > nothing > happens. > > Ive start…
Cant Schedule a dbexport on NT
Hey all - I want to do a dbexport every night on my NT server. Ive written a program (dumpit.exe) which does this just fine when I run it manually from the Command Line Utilities. However, when I attemt to put it in my scheduler, nothing happens. Ive started my scheduler (Con…
SCHEDULING TASKS IN INFORMIX
Hi all: I am wondering if there is any possibility of scheduling some tasks on Informix OLWGS 7.0 Say, I would like to run some stored procedures every day at 00:00 hours. Can I manage to do that ??? Or do I need an external application ??? Thanks in advance, Alex. -- …
Re: Questions on INFORMIX 7.13 and CPU VPs
sujata_soman_at_omm-la2-infotech-001@internet.omm.com wrote: > 1. Is it true that we can configure only one NETTYPE connection on the > CPU VP ? Currently, both my NETTYPE connections ( SOC and SHM ) are > configured on CPU VPs. If my assumption is true, does INFOR…
Re: Questions on INFORMIX 7.13 and CPU VPs
In article <638pt8$2h7@cssun.mathcs.emory.edu>, sujata_soman_at_omm- la2-infotech-001@internet.omm.com writes > > Hi everybody, > Some more questions for everybody. Feel free to answer > . I have a lot of questions on CPU VPs and performance. Here goes: > > some b…
Questions on INFORMIX 7.13 and CPU VPs
Hi everybody, Some more questions for everybody. Feel free to answer . I have a lot of questions on CPU VPs and performance. Here goes: some background info: OS -AIX 4.1 Informix : 7.13 UC1 Number of CPUs - 8 1. Is it true that we can co…
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: gfd virtual processor class...
June - sounds reasonable, thanks. I'll have to count tomorrow & see if they jive. Greg (from my alter ego at home...) June Tong wrote: > > : I was looking through the output of "onstat -g ioq", and it occurs to me > : I don't have a clue what VP type "gfd" is (see snippet belo…
Re: Cannot fork a virtual processor
Mark D. Stock wrote: > > Enigma wrote: > > > > Hi, > > My informix ODS went down when I tried to put it to online. I'm > > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > > online.log is > > Cannot fork a virtual processor errno=12. > > This hap…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
Re: gfd virtual processor class...
: I was looking through the output of "onstat -g ioq", and it occurs to me : I don't have a clue what VP type "gfd" is (see snippet below). Can : anybody clue me in?? It's not a VP type. It's an I/O queue. I think it's Global File Descriptor (or something like that). Basica…
Cannot fork a virtual processor
Hi, My informix ODS went down when I tried to put it to online. I'm running a informix 7.14 on a IBM AIX 4.2 machine. The error in the online.log is Cannot fork a virtual processor errno=12. This happens only intermittently. It seems to indicate there is insuffici…
Re: Cannot fork a virtual processor
Enigma wrote: > > Hi, > My informix ODS went down when I tried to put it to online. I'm > running a informix 7.14 on a IBM AIX 4.2 machine. The error in the > online.log is > Cannot fork a virtual processor errno=12. > This happens only intermittently. It seems to…
gfd virtual processor class...
I was looking through the output of "onstat -g ioq", and it occurs to me I don't have a clue what VP type "gfd" is (see snippet below). Can anybody clue me in?? plsaphp1:informix 1> onstat -g ioq INFORMIX-OnLine Version 7.21.UD3 -- On-Line -- Up 26 days 06:59:37 -- 175552 K…
Re: Informix crashing UNIX on HP
On Thu, 02 Oct 1997 16:19:24 +0200, "Mark D. Stock" <mdstock@informix.com> wrote: >Silvester_Valiente@tnt.com.au wrote: >> >> Has anyone had an experience where Informix 7.23 UC4 caused Unix to >> Panic and shutdown. >> >> We are experiencing the problem when the virtual portion…
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…
RE: scheduling Informix stored procedures on NT
Vinitha How about: dbaccess dbname <<! EXECUTE PROCEDURE spname; ! If you want to use your original form, ie: dbaccess dbname <spname your spname file should have "EXECUTE PROCEDURE spname;" (where spname is the name of the SP you created in the database). HTH Sujit -----…
scheduling Informix stored procedures on NT
Hello, I am trying to run certain Informix stored procedures at scheduled time intervals on NT. For scheduling , I put the "dbaccess <dbname> <spname?" command in a batch file and try to run it with the "at" command on NT. This is not working. In fact even if I try running dbacc…
HPUX 10.20-7.22 Restore problems
We have an HPK250, single processor, 160 meg mem, Informix 7.22. When I try to restore from a level 0 archive tape, the machine hangs completely. We have to use "the big switch" to reboot. Tried several configs - up to 64000 initial virtual, cutting down the off recovery threads…
Re[2]: Year 2000
I have gone into Microsoft Schedule+ and right-arrowed until I got to Feb. 2000. 29 is there, plain as can be. Dianne…
Java and Informix Dynamic Server 7.x
Hi friends! I am trying to do server-side java cgi programming to connect to I-ODS 7.x. Do you know how I can do that? I heard it is possible to use the jdbc-odbc bridge( intersolve or openlink's), but the performance is too slow, because of jdbc to odbc and odbc to jdbc convert…
Re: onstat -g sch
}>From ilist@rmy.emory.edu Mon Jun 2 13:30:44 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id NAA15009; Mon, 2 Jun 1997 13:29:47 -0600 }>Received: (from ilist@localhost) by rmy.r…
Re: onstat -g sch
: Notice I have 7CUPVP's but vp 8 seems to be doing all the work. ANYONE : know what the heck is going on. : I just happen to notice this one day. I have been suffering from poor : performance since the upgrade from 7.13 but I can't quit figure out what : the problem is. i ha…
onstat -g sch
I am running 7.22.uc1 on Solaris 2.5, 8CPU, 7CPUVP's the following is the output from onstat -g sch. Notice I have 7CUPVP's but vp 8 seems to be doing all the work. ANYONE know what the heck is going on. I just happen to notice this one day. I have been suffering from poor pe…
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: Informix 5 Performance Issues
Remember - YMMV, etc: On 16 Apr 97 at 17:04, Phantom173 wrote: > We have been told by a consultant that a move to Informix 7 would > benefit us because (a) Informix 7 would reduce the number of connects > (and therefore processes) associated with the elephants, and (b) it > wou…
informix training
anybody know where i can find a schedule for informix courses, specifically data wharehousing. TIA brian…
4gl exam
Has anyone taken the test yet? I am scheduled for next Wednesday, (production problems this week), and was wondering about difficulty. You can e-mail me if you like. Chris Burton cburton@gte.net…
Re: HP/Raid5/Performance Lessons
David Williams wrote: > > In article <330C89FB.2578@cobe.com>, Edward Bidinotto <edbid@cobe.com> > writes > >If you are running or wish to run with Raid on HP here are some things > >that we recently ran in to. > >Onstat -g sch showed the CPU vp's basically spinning their wheels.…
Re: HP/Raid5/Performance Lessons
In article <330C89FB.2578@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >If you are running or wish to run with Raid on HP here are some things >that we recently ran in to. > >Machine Configuration: > >HP-UX 9.04, 6 cpu's, 1.6 gig mem, 32 gig raid (MTI), 600+ users some shm…
HP/Raid5/Performance Lessons
If you are running or wish to run with Raid on HP here are some things that we recently ran in to. Machine Configuration: HP-UX 9.04, 6 cpu's, 1.6 gig mem, 32 gig raid (MTI), 600+ users some shm and some tcp, Infx 7.11 uc1, around a 30 gig database Initially our informix insta…
Re: Tuning CPUVPS/AIOVPS
In article <32FFA371.749@cobe.com>, Edward Bidinotto <edbid@cobe.com> writes >On 7.11 if you run > >ONSTAT -G SCH > >What does the busy waits column mean? Is 0 a good number for AIO or CPU >VP's? >Does it mean that there are sufficent AIO or CPU vp's and nothing is >waiting or is…
Re: HELP: MEANING OF onstat -g sch output
In article <5ds4qr$hg4@cssun.mathcs.emory.edu>, Rick Ward <wardr@gusco.com> writes >Edward Bidinotto wrote: >> >> Can anyone explain what the output on onstat -g sch means especially the >> column >> "busy waits"? Does a high number in that column mean that the vp is >> staying b…
Re: HELP: MEANING OF onstat -g sch output
Edward Bidinotto wrote: > > Can anyone explain what the output on onstat -g sch means especially the > column > "busy waits"? Does a high number in that column mean that the vp is > staying busy > or that it is staying idle? > > We need to find out from the following output if we…
HELP: MEANING OF onstat -g sch output
Can anyone explain what the output on onstat -g sch means especially the column "busy waits"? Does a high number in that column mean that the vp is staying busy or that it is staying idle? We need to find out from the following output if we need to add cpuvps or delete also if w…
Tuning CPUVPS/AIOVPS
On 7.11 if you run ONSTAT -G SCH What does the busy waits column mean? Is 0 a good number for AIO or CPU VP's? Does it mean that there are sufficent AIO or CPU vp's and nothing is waiting or is it just the opposite saying that all of the VP's are being used up and you need more…
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 …
Index Re-org
Using: ONLINE DSA V7.13 Can anyone tell me if they re-organise indexes on tables automatically ? If you do, do you: 1. Schedule it periodically (weekly, daily, etc) 2. Schedule it automatically (when some statistic gets beyond a tolerance level) 3. Run the script unattend…
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…
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: MULTIPROCESSOR OPTION 7.13
In article <01bbcb91$cc1befe0$654750c6@irwin.interaccess.com>, irwin@objectsoft.com says... > > > >Allen Jantzen <allenj@ndr.com> wrote in article ><327fa20d.27552573@news.netline.net>... >> The Informix DSA Administrators Guide, version 7.1, page 10-18 says >> >> "On some two-pr…
Re: MULTIPROCESSOR OPTION 7.13
Just my 2 cents worth: I have a HP T500, T520, and 2 K200's which all have two processors. I found that running with the MULTIPROCESSOR set to two was the way to go. My performance while running config'd as one cpu was good, but sometimes I'd see the one cpu at 100% while the o…
MULTIPROCESSOR OPTION 7.13
The Informix DSA Administrators Guide, version 7.1, page 10-18 says "On some two-processor computers, you should only run one CPU virtual processor because the overhead of synchronizing the two virtual processors offsets the benefit of distributing the processing" Of course, us…
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: Query Retrieval
Srirama Sundararajan Rajagopalan <rajagopa@nps.med.ge.com> wrote: :Hi Folks: :I am working on improving the query performance in informix 7.1. :I already have unique indexing on this table and besides optimizing :the query, virtual processor technique, is there any other techni…
Query Retrieval
Hi Folks: I am working on improving the query performance in informix 7.1. I already have unique indexing on this table and besides optimizing the query, virtual processor technique, is there any other technique that can be employed to improve the query retrival time in informix…
Re: Good Informix bug found
In article <3223B8C4.7588@cyberramp.net>, Greg <greg@cyberramp.net> writes >June Tong wrote: >> snip..... >> >> What gets locked up and what do you kill -9? I'd be really surprised if it's >> really locked up; more likely it's just taking a long time to return a result. > >On 7.…
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: Oninits Running Amok...
In article <4rtnsa$e2@server2.codetel.net.do>, Tom Hay <nomad@codetel.net.do> writes >Yes, I've seen it too, on Version 7.10D1 on a uniprocessor HP-UX, and >I don't like it either. The machine virtually stops for around 30 >seconds. Can't offer any explanation, though ... sorry !…
Re: Oninits Running Amok...
OK - got some more info...it looks like the only time the CPUVP's run amok is when our Powerbuilder client connects across a slow (dialup) IP link and is downloading client code changes from a table (Select...) that contains updated app code in BLOB's. This would explain the lac…
Re: Oninits Running Amok...
In article <31D9457E.5C90@eds.com>, Greg Moye <msmcl301.gmoye01@eds.com> writes >We have 7.13.UC2 running on Solaris 2.4 w/ 2 Sparc CPU's. I occasionally >see both CPU VP's chewing CPU like crazy, yet there's few if any Buffer >Reads or any other evidence of productive work goin…
Informix routines - are they thread-safe?
Hello, Have Informix routines been modified to be thread-safe?…
lastest compare against oracle
can anyone provide some new information on the rdbms wars between informix and oracle. I know oracle blasts informix for the poor performance, transaction logging, record locking mechanisms and informix touts the performance gains on the methodology for using threads instead of p…
Re: Anyone used the MetaCube product?
Just received the latest version of Informix Training schedule and, indeed, there is training for MetaCube. Have heard zero info on it. Why the secrecy...as compared to blowout with Illustra? Who knows? Thoughts?…
HP K200 and Online 7
We are experiencing SEVERE performance problems trying to upgrade from Online 5 to Online 7. Online 7 runs about 400 percent slower than Online 5 up until +- 400 processes. (Confirmed by Informix S.A). Online 7 performance never degraded even when the load went above 400 process…
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…
OKI-IUG MEETING CHANGE
OKI-IUG MEETING CHANGE The meeting of the OKI-UIG scheduled for tomorrow, Thursday May 16 has been re-scheduled for next week, Thursday, May 23. The reason for the change is due to Microsoft cancelling. Any questions, please contact me at (513) 985-6004 or…
Re: LRU writes
brian, we should keep this either as private e-mail or just to the list, as i get two messages for everything that gets send out! not a big deal, but kind of a pain. the advantage of the list is that other people can see it and throw in ideas. it can be difficult to diagnos…
Re: 7.x performance issue on DEC Alpha
Hi Rakesh. I do not understand what you meant by the Alpha2 uses the Alpah 1's database. Are these databases on two machines cross mounted under NFS ? Anyway, since you have one of those 2 CPU machines I am including a mail that was sent to this news group specifically about the …
Re: 7.x performance issue on DEC Alpha
tolly brumbelow <tolly.brumbelow@bridge.bst.bls.com> writes: > Are you running the same application on both Alpha 1 and Alpha 2 ? >Have you checked to see if swapping is taking place on the unix side? >(if so you may have the buffers set to high) >Are you running update stats on…
Re: onstat -g questions
On 22 Apr 1996, Rajiv Jauhari wrote: > Has anyone used the "onstat -g sch" and "onstat -g spi" > commands to help tune the performance of Informix 7.1 on an SMP? > If so, can you explain the exact meanings of the various columns? I recently made an adjustment based on the info …
Re: unexpected virtual processor termination
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---1503566844-140477562-830393090=:47444 Content-Type: TEXT/PLAI…
Re: unexpected virtual processor termination
Sounds like someone issued a Kill -9, while it was holding locks? Anyway I suggest you turn on your montoring program/script (if you do not have one, I got one to watch engine and another one to watch user's) and see what processes are actually occuring at that time. If you want …
unexpected virtual processor termination
We use Online 7.11 on IBM RS6000 AIX 4.xx (32 MB RAM) for development tasks. Often, while 4GL program is being compiled, Online shuts down. In online.log file one writes: "unexpected virtual processor termination, attempting to bring system down". This virtual processor is msc. …
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.…
Backing up using ADSM ?
Is Informix enabled for backing up using ADSM ? Is anyone doing this ? Does the backup have to be initiated from the database manager or can done through ADSM's scheduling facilities ? TIA Phil Nelson DBA Scottish Widows Fund…
<No Subject Supplied>
>On occassion we can see that the 'oninit' process associated with the CPU >virtual processor of Informix is taking 100% of the CPU. Is there a good >way now to track this down to which Informix sessions are actually using >this CPU time? >Is there a better, more direct way to …
Re: processes sspawned by 7.1
>I noticed there are a lot of processes names oninit -s >spawned by the database engine on start-up. Can someone >enlighten me as to why this is. I'm sorry I'm not familiar >with the new engine and am just groping along. You get an oninit process for every Virtual Processor (V…
Re: processes sspawned by 7.1
Carol Stimmel (stimmel@fsl.noaa.gov) wrote: : Hi, : I noticed there are a lot of processes names oninit -s : spawned by the database engine on start-up. Can someone : enlighten me as to why this is. I'm sorry I'm not familiar : with the new engine and am just groping along. …
Re: Informix dual processor scalability
In article <DJ6CHK.5zx@dsbc.icl.co.uk> smb@oasis.icl.co.uk "Stuart Britt" writes: > Using Informix on 1 processor we achieve good performance. If we switch to > 2 processors, then our performance actually degrades. We have been given > some advice on tuning the system for dual…
Re: Informix dual processor scalability
According to my rusty memory, the reason for this is something about the overhead necessary to handle multiple processors only being overwhelmed by the performance increase after three processors. So you should tune as tho' you only have a single processor... :-( HTH. }Does any…
Re: Looking for a good job Scheduler / Batch Processer
>I am looking for a Unix software package to help us schedule jobs to run >automatically in a timely efficient manner. Cron? :-) -- Cheers, Billy "Have you got it yet?" (c) Dazza, 1995…
Re: Looking for a good job Scheduler / Batch Processer
>I am looking for a Unix software package to help us schedule jobs to run >automatically in a timely efficient manner. Cron? :-) -- Cheers, Billy "Have you got it yet?" (c) Dazza, 1995…
Re: Looking for a good job Scheduler / Batch Processer
>I am looking for a Unix software package to help us schedule jobs to run >automatically in a timely efficient manner. Cron? :-) -- Cheers, Billy "Have you got it yet?" (c) Dazza, 1995…
Re: Informix dual processor scalability
Stuart Britt writes: |> Does anyone have any info on the following problem? We are using Informix |> version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP |> machines. |> |> Using Informix on 1 processor we achieve good performance. If we switch to |> 2 processor…
Re: Informix dual processor scalability
: smb@oasis.icl.co.uk (Stuart Britt) writes: : Does anyone have any info on the following problem? We are using Informix : version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP : machines. : : Using Informix on 1 processor we achieve good performance. If we…
Informix dual processor scalability
Does anyone have any info on the following problem? We are using Informix version 7.10.UC1 for Intel UnixWare 2.01 on single processor and SMP machines. Using Informix on 1 processor we achieve good performance. If we switch to 2 processors, then our performance actually degra…
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…
Informix 7.1 Online Performance Questions??
Hi, I'm trying to develop a performance profile / model for an application that has been developed using the Informix Online Dynamic Server v7.1. The Server is being called by programs written in "C", which use the ESQL interface. My question is the following: I am observing …
Informix Data WareHouse Seminar (FREE)
Informix has scheduled a free morning seminar on Data Warehousing. Location: Ft.Lauderdale, Florida The Westin Hotel, Cypress Creek Date: September 14, 1995 Time: 8:30am-12:15pm There may be more seminars scheduled in other locations. For more info: 1-800-647-6522…
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: FREE ORACLE SOFTWARE!
Can you e-mail me the schedule for the symposium here in San Diego. I'm very interested in attending. Tnx Joseph Tan Hao hao@mail.sdsu.edu…
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…
Re: HELP - training schedule !
Maury HSU (maury@PROBLEM_WITH_INEWS_GATEWAY_FILE) wrote: : Hello, : I'm planning to take some INFORMIX courses in USA, : Does anyone could elm me the training schedule? Check out the following Web URL: http://www.informix.com/informix/services/educat/edu.htm -- %%%%%%%%%%%…
Re: HELP - training schedule !
Nick, The problem is that many of us don't have access to anything but mail. I would love to check out the informix www page, but I CAN'T. I haven't even been able to get ftp-by-mail to work, so if someone won't mail me the information I need I'm out of luck. } } On 10 May 1995…
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: HELP - training schedule !
On 10 May 1995, Maury HSU wrote: > Hello, > > I'm planning to take some INFORMIX courses in USA, > Does anyone could elm me the training schedule? > > Thanks, > Maury HSU > maury@rc4002.taiwan.hp.com > Maury, I'd send this direct to you if it weren't for the message in y…
HELP - training schedule !
Hello, I'm planning to take some INFORMIX courses in USA, Does anyone could elm me the training schedule? Thanks, Maury HSU maury@rc4002.taiwan.hp.com…
Re: Database Backup Schedules
>OnArchive now supports compression, though its S/W compression being >done by >OnArchive. This is going to slow down your archive times, since additional <cycles are now required to perform the compression. On the otherhand, However you spell it, I believe the phrase would be …
Re: Database Backup Schedules
> Clem Akins writes: > > Now that we have a clue, here's the real deal... > > We got a big digital linear tape (DLT) drive that holds 20GB, and we > > do a level 0 every day. There are several things to beware of, though: > > Informix won't support > > tape-drive level compre…
Re: Database Backup Schedules
At 10:09 AM 5/3/95 -0500, Clem Akins wrote: >> From: 15SAS133.HQAMC@MHS.SAFB.AF.MIL (Davis, SrA Jeff) >> To: informix-list@rmy.emory.edu >> [clipped] >First, RTFM. OnLine Administrator's Guide (v5.0) pg3-40. Joe Lumbley's >book probably has good things to say (though I don't …
Re: Database Backup Schedules
On Wed, 3 May 1995, Clem Akins wrote: > Now that we have a clue, here's the real deal... > We got a big digital linear tape (DLT) drive that holds 20GB, and we > do a level 0 every day. There are several things to beware of, though: > Informix won't support > tape-drive leve…
Database Backup Schedules
> From: 15SAS133.HQAMC@MHS.SAFB.AF.MIL (Davis, SrA Jeff) > To: informix-list@rmy.emory.edu > > We are taking responsibility for a turn-key system and are in the initial > phases of setting up maintenance schedules. One of our first tasks is to > come up with a Informix database …
Database Backup Schedules
To all, We are taking responsibility for a turn-key system and are in the initial phases of setting up maintenance schedules. One of our first tasks is to come up with a Informix database backup schedule. Our database will initially be about 18 to 20 gigs large and will grow a…
Re: Scheduling processes in Informix
paolof@hrp.no (Paolo Fantoni) wrote: > >I am trying to call an external program (that is actually a .4ge program) from >within an Informix procedure, every 5 minutes. I have tried with the Unix cron > but with bad results. Does anyone know how to handle such a problem? >I have In…
RE: Scheduling processes in Informix
You did not say what your bad results was when using cron. However, It may very well have dealt with the environment the 4ge program had at the time of execution. I think you can correct your results by executing a shell script from your cron. In the shell script you will need …
Scheduling processes in Informix
I am trying to call an external program (that is actually a .4ge program) from within an Informix procedure, every 5 minutes. I have tried with the Unix cron but with bad results. Does anyone know how to handle such a problem? I have Informix SE 4.0 on Interactive Unix 3.0. Th…
Re: report writer(generator)
try IQ for WIndows...simple to use.... requires a network solution at this time character based version scheduled for near future…
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.…
Schedulers Compatible with Informix
We are looking for a scheduling/computer managed instruction product that runs with Informix. Specifically, we need to be able to automatically schedule hundreds of students to thousands of classes over a peiod of several years. Standalone schedulers/CMI products would also be …
Informix Corporate Calendar Schedule
The following has been cleaned up a bit. I tried to remove all "Informix only) events. The rest "may" be of interest to the Informix Users Community. If you have questions contact your local Informix representative or as a last choice, send me a note. --Bill RE: CORPORAT…
crontab command
Has anyone used the crontab command to schedule a job (run script file automati cally everyday)? I am using the command to schedule it and it works fine except that the error log is saved in /tmp disk. According to help, it should send mail back to me with errors but I am not ge…
Re: Informix Truck Schedule
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!uunet!charon.amdahl.com!amdahl!nsc!pyramid!infmx!billd From: billd@informix.com (William Daul) Newsgroups: comp.databases.informix Message-ID: <1992Feb19.020221.21275@informix.com> Date: 19 Feb 92 02:02:21 GMT References: <1992Feb5.18…
Re: Informix Truck Schedule
Path: emory!sol.ctr.columbia.edu!spool.mu.edu!uunet!hela.iti.org!widener!logsysv!larry From: larry@logsysv.UUCP (Laurence Sigmond) Newsgroups: comp.databases.informix Message-ID: <94@logsysv.UUCP> Date: 17 Feb 92 18:46:58 GMT References: <1992Feb5.182628.27030@informix.com> <1618…