Oninit® Archive
Results for “onstat -p”
Re: Checkpoint durations
<david@smooth1.co.uk> wrote in message news:a9b22443-9ba1-44c3-b2f3-830da196ade2@v4g2000yqa.googlegroups.com... > On 29 Nov, 20:38, "Neil Truby" <neil.tr...@ardenta.com> wrote: >> <da...@smooth1.co.uk> wrote in message >> >> news:f09d1744-ab19-4e08-9a9d-4e6f8cdf14a4@y18g2000yqn.g…
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 ------------------------------…
%Cached using onstat -p vs %Cached using onstat -g buf
I am on Informix 11.70, and I am grabbing metrics to record. One of them is the buffer write% for each server. When running onstat -p , it shows the %cached as 90.60 . However when actually calculating the %cached, it yields 80.20. The 80.20 value aligns with the value from onsta…
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…
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…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
Moving Instance
If it's just the executables and such, then yes you could. If you have any chunks in that directory (I hope not!) then no. Make sure the engine is offline before you do so. Modify the MSGPATH and such that may be pointing to the "old" location before bringing the engine back up.…
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)…
Long checkpoint
A good start is to monitor 'onstat -F' continuously through the checkpoint. This will show which chunks are being flushed during a checkpoint. A common scenario is having everything waiting on a single chunk to flush towards the end. You can also monitor 'onstat -u' and check th…
Session "Waiting on a transaction"
Hello, I'm using Wildfly application server (JEE server) together with Informix 12.10.FC5 as the database on Oracle Solaris SPARC 10. It's using distributed (XA) transaction using 2 databases on the same instance in this case. On start up the server gets stuck at some point and …
SSD RAID selection
We are going to replace our existing SAN with a newer model EMC SAN. We are placing our dbspaces on SSD drives only. EMC recommended us to use storage pools with RAID-5 (4+1). We found that database forums are more in favor of RAID 10, if compare RAID 5 with 10 (strong recommenda…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
wait for mutex
Folks, Normally I do not see S---- in output of onstat -u, but now I see. Any comments? Thanks Frank RHEL 6 [informix@walter ngdc_er_20140820]$ onstat -u IBM Informix Dynamic Server Version 11.50.FC8 -- On-Line -- Up 00:38:50 -- 11847728 Kbytes Userthreads address flags sess…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Error -556 on @ reference
In IDS_A have a stored procedure do_some that has a insert into a local table. In IDS_B have a stored procedure do_some that does: call base@IDS_A:do_some(); Calling this sp works ok. In IDS_C i try to run: call base@IDS_B:do_some(); Fails with error -556 Cannot create, drop,…
Stored Procedure Returning -668
We use Jenzabar CX and we are trying to add a trigger to a table that calls a stored procedure which eventually makes a system call. When a user logs in it takes them to a menu. For some this trigger/stored procedure works. For others it does not. For the ones it doesn't work f…
What are best onconfig parameters for a DSS app
Good to know!.. I was looking through the docs on DSS features of 1170 and couldn't find the TMU (Table Management Utility) for high-performance loading of tables. OK, so now I'm going to do lots of reading and begin to design a good model for conducting category analysis in ord…
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 …
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…
clean temporary dbspaces
Hi, v11.50 FC8 , AIX 6.1 I need to perform a maintenance in the area of temporary dbspaces. I have to remove some temporary dbspaces. As there is no option to reset the on-fly DBSPACETEMP, so I set the DBSPACETEMP variable in the profiles of users to not use the dbspaces I need…
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.…
LC_MONET
Hi, I have session in informix which contain 'LC_MONET' in TTY field of onstat -u i cannot understand what is LC_MONET Userthreads address flags sessid user tty wait tout locks nreads nwrites 1544675a8 ---P--- 1644033 informix LC_MONET 0 0 0 0 0…
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…
Queries waiting for mutex
Hello all, Yesterday afternoon we ran into a problem. All sessions selecting or modifying data stopped responding to users. Onstat -u showed all of these sessions in a status of waiting for mutex 'S--P---'. After gathering onstat -a and onstat -g all information, I restarted Inf…
wait for mutex ... IDS hang....
Hi, Folks, Build Version: 11.10.UC2 Build OS: AIX 5.3 We had IDS hang that seems caused by Waiting for Mutex. I attached some info and question embedded below. Hope experts can give some ideas. Thanks a lot! Frank (1) No waring info in Online log. (2) onstat -u's output in…
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…
SMI table to read the 'onstat -P' information from
Hi all, I was wondering if there's a way to read the 'onstat -P', i.e. the 'Print partition buffer summary' information from a SMI table? I wrote a script to print out the contents of the buffers, but it would be more elegant to be able to do everything on SQL, instead of having…
why so many informix threads on idle systems ?
Please post the output of onstat -g ath. It's better than onstat -u wh= en looking at threads. M.P. = From: "KARL OLIVER" <karl.oliver@maf.govt.nz> = = To: ids@iiug.org = = Date: 04/06/2010 06:32 PM = = Subject: why so many informix threads on idle systems ? [19509] = =…
How to check informix DB bottlenecks
I am using IDS 9.4, AIX 5.4. onstat -p shows => onstat -p IBM Informix Dynamic Server Version 9.40.UC6 -- On-Line (Prim) -- Up 23 days 15:06:08 -- 2251504 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 1220612817 3198664750 2251555606 45.…
can't kill a session using "onmode -z session id"
Hi All, I encountered problem on my DB. I am dropping a table and it hanged. I decided to close the window by clicking the "X" button. When i checked, the table still exists when i use dbaccess-> table-> info. But when i try to select from the table, the message is table does no…
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…
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…
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…
Question about sysindexes.clust
I can provide you with a copy of the onstat -p but don't have the others. I will get them in future tests (I'm hoping we are almost done for now). On Tue, Nov 18, 2008 at 3:32 PM, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > Eric Rowell wrote: > > Any suggestions would b…
Re: Smoke and mirrors...
InDeep wrote: > Ian Michael Gumby wrote: >> To your point. Yes IDS will perform much better that either Oracle or >> DB2 in a VM environment. > > Let's not make sweeping statements without facts. I am glad you said this, as my first reaction was that this was typical Gumby BS. B…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
H E L P!
Dear All, I shall be grateful if someone can tell me how to kill the user process (stop the process the user is running)as some time the users forgets to sign off. Follwing is the onstat -u output, ( the preview compress the mail,individual columns will not appear, for example. …
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…
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.…
Urgent Req: Informix DBA @ Atlanta, GA
Dear All, Please let me know if you or any of your friend is interested in this opportunity. Informix DBA Location: Atlnta, GA Duration: 7 Months+ Rate: $Open Required Skills: Informix database administration on UNIX/Linux, Informix database upgrade experience from 7.31 to cur…
Re: Hands-free Administration
"Chris Youll" <nospam_cyoull@comcast.net> wrote in message news:C62dnV3Z9MkWJjnanZ2dnUVZ_g2dnZ2d@comcast.com... >I have been trying to follow the resurgence of Informix IDS and the new >cheetah product line. In the "Chat with the Labs" presentations and the >IBM Web site a grea…
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…
Real basic oncheck onmonitor question
With oncheck you're safe with the -p options, with onmonitor you're safe as long as you don't go into the Parameters menu (which is disabled for users other than informix) or if you do, don't save any changes. To safely look what config parameters are being used use onstat -c.…
help ! How can capture the SQL?
Hello, For what it#s worth you can get the sqls from the syssqlstat table I believe it is. This includes all SQLs though not just those causing sequential scans. If you experiencing performance problems? What OS are you using? I can provide you with a couple of scripts that will…
How to find the location of logical log file
On Aug 20, 8:32 am, Veeru71 <m_ad...@hotmail.com> wrote: > Given a logical log file, wow can we find out its location > (dbspace) ? > onstat -l doesn't show this info. > Thanks It actually is in the onstat -l output. The "begin" column is the physical address of the begining o…
Buffer waits
HI, Folks, Just curious, we have a quite number of buffer waits(onstat -p) and we know they were caused primarily by a sequential scan of a large table. As I observed, the percentage (onstat -R) of the free buffers was still high (> 90%) when the session claimed a buffer wait(o…
table wise statistics
onstat -g ppf and onstat -f iof ----- Original Message ----- From: Nandkishor Singare <ids@iiug.org> At: 7/31 10:27:53 Hi, Informix 9.4 on AIX 5.3 I want to get the statistics like lockrequests, sequential reads, writes for individual tables. onstat -p gives me overall stati…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
tty value
HI, Guys, I am wondering the TTY values from onstat -u. It is normally a number, but the folowing looks..... Any idea? AIX 5.3, IDS10 UC5 Tahnks, Frank IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 18:50:39 -- 77088 Kbytes Userthreads address flags sessid …
Performance profiling a UDR in Java
I've developed a Java UDR that I need to increase performance on quite a bit. Can anyone suggest a profiler (preferably free, maybe even something that snaps into Eclipse) that will allow me to see what's taking so long? Does the krakatoa jre allow standard socket connections fo…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
onstat -p
Dear forumers, Attached is the "onstat -p" command : Do you think my bufwaits is high ?? Or is there anything significant from this information that need attention for performance reasons ? -------------------------------------------------------------------------------- ------…
onstat -p
The following is the output of onstat -p, I am curious why numckpts: 2325 < ckpwaits : 2683 ? How is that possible? Thanks, Frank informix@erika $ onstat -p IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 36 days 02:20:10 -- 1976640 Kbytes Profile dskreads pagr…
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…
Finding table names from the output of onstat -g p
I'm having a brain lapse this morning. How do I convert the partnum in onstat -g ppf into a table name? DT…
Data Replication
Hi, We are using the IDS 7.31 of informix on TRU64 unix. We have a Primary db. server which replicates to secondary db. server. In case of a failure with the primary server. (OS level, Disk error ), is there any way to configure the database onconfig parameter to ensure that th…
Rogue user session
Hi, Informix Dynamic Server Version 7.31.UD7, solaris 8 I've got a rogue user session connected to my instance that I need to remove, if possible without bouncing the engine. snippet frm onstat -u 4ef13618 T--P--- 32885750 userxyz console 539f5f5c 0 0 0 0 4ef1d618 T--…
onstat -p stats
Hi We are having IDS 7.31 UC3 on HP-UX when I entered onstat -p, %cached(4th column from left) is showing 0.00 ,it is for reads i think. But earlier it was showing 90%. What could be the problem? Is this normal? How to get it back to 90%? Pl help.. Suresh…
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…
A question of load . . .
( Unfortunatly, none of us thought to save any of that data when things started slowing down, so all we've got is what we can remember. ) In answer to several: 3 oninit processes were the only things really eating cpu time. There were a few other processes that would show up us…
record locked
a combination of onstat -k and onstat -u…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
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…
Performance issue after 732 to 94fc6 upgrade
Sorry, the previous posting of with the onstat output file did not have the sequence of onstat commands. They were in order: informix211 /tmp$ onstat -g cac >> retwa.stats.out informix212 /tmp$ onstat -p > retwa.statsdone.out informix213 /tmp$ onstat -d >> retwa.statsdone.out inf…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
who locks a record?
onstat -k followed by an onstat -u…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
Optimizing a BaaN installation
--- onstat -u --- Informix Dynamic Server 2000 Version 9.21.TC7 -- On-Line -- Up 05:42:45 -- 1078592 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites 25e63018 ---P--D 1 informix - 0 0 0 186 3067 …
Re: IDS 10 - documentation questions
Oops! I mean IBM Informix Dynamic Server Version 10.00.TC3ET Althought the release notes (idse_win_release_notes_10.0.html) start with:- "Release Notes for IBM Informix Dynamic Server Express Edition for Windows Platforms 10.00.TC3E, 1 July 2005 " so it is TC3E or TCE3T? and …
Re: Sql to concatenate multiple rows to a single row / column
Thank you SaltTan - it works beautifully. BTW, we have IBM Informix Dynamic Server Version 9.40.FC6.…
Re: Oninit from cron leaves engine in permanent fast recovery
Also check the release notes....under $INFORMIXDIR/release. On AIX do you need to create a KAIO device (aiodev??) or something. And run something like strload? Make sure NOAGE = 0 in onconfig as it may not be supported. Check RESIDENT = 0 in onconfig as I have seen it not suppo…
RE: Onstat -P output
Hi Leona. If anything I say in here evokes a response 'I know that dummy'(-:)) I apologize. Given your profile, Onconfig and the fact that you are running an OLTP I would suggest you make the following changes to your onconfig. Some are calculations, some out of experience: You…
RE: Onstat -P output
Based on your description, it sounds like you're hitting a table without an index that has grown in size and a single SQL/SPL/UDR is to blame. I've attached a script called "qio" to the bottom of the post, it will show you the SQL's in the system that are the biggest I/O users. …
RE: Onstat -P output
Hi, The processing is OLTP. A SUN 4800 server with 4 CPUs at 750MHZ each. The overall CPU activity is about 65%. The server has a total of 1.8TB (18 disks of 73GB). Out of this 400GB is allocated to the file system and the rest is configured like this: 6 for RAID 10 and 5 for RAI…
RE: Onstat -P output
What, precisely, is it that you are unhappy with? Are you OLTP, DSS? How many CPU's? How many hard drives? What is your overall CPU activity? What does you I/O look like? Etc, etc, etc ... -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-lis…
Onstat -P output
--0-1958201504-1124376709=:23030 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition: inline Hi, I'm using IDS9.21 UC6 running on a SOlaris 8.0 Operating system. The output of the onstat -P is not acceptable and I would ap…
Max Locks Forever
How would one find out the "maximum number of locks in use" for a period. lockreqs from onstat -p does me no good. I have a system that is stressed for memory and I'm running 100000 locks. They probably could do ok with less. This is 9.40.TC2 on Windows sending to informix-list…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Transaction Rollback
onstat -x…
Re: Informix to Oracle Migration
rkusenet wrote: > "Data Goob" <datagoob@netscape.net> wrote > >> The downside is that the development team must know how to provide >> transactions >> that do not block readers without help from the database engine. I've >> worked >> in one system using SQL-Server where this is …
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
dropping chunk
The offset used is 0. onspaces -d arcdatdbs -p /dev/vg_archive/rlvol34 -o 0 -y Remove the link /dev/vg_archive/rlvol34 to /dev/vg_database/rlvol34 rm /dev/vg_archive/rlvol34 Run a level 0 archive to /dev/null onspaces -c -d temp5dbs -t -p /dev/vg_database/rlvol34 -o 0 -s 2048…
Re: Opinions on usercpu & syscpu in onstat -p
Darren_Jacobs@carmax.com wrote: > Just wanted to get some opinions on the usercpu and syscpu meaning in the > onstat -p output. I can't remember if I read in Lumbley's guide or not, > but if usercpu exceeds the amount of lapsed time this indicates the system > could benefit from…
RE: Opinions on usercpu & syscpu in onstat -p
On a 6 way box, assuming you have say 5 CPU VPs, then no. 150951 + 5282 = 156233 total CPU usage over a period of 67740 seconds you would have 5 * 67740 = 338700 total seconds of CPU usage available So, your using a little less than half. If you are trying to determine if you…
RE: Opinions on usercpu & syscpu in onstat -p
On a 6 way box, assuming you have say 5 CPU VPs, then no. 150951 + 5282 = 156233 total CPU usage over a period of 67740 seconds you would have 5 * 67740 = 338700 total seconds of CPU usage available So, your using a little less than half. If you are trying to determine if you…
Fw: Opinions on usercpu & syscpu in onstat -p
Sorry, the total elasped time is 11.5 hours or 41400 seconds. TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 04/07/2005 01:03 PM ----- Darren_Jacobs@car max.com Sent by: To …
Fw: Opinions on usercpu & syscpu in onstat -p
Sorry, the total elasped time is 11.5 hours or 41400 seconds. TIA ----- Forwarded by Darren Jacobs/7001/Carmax on 04/07/2005 01:03 PM ----- Darren_Jacobs@car max.com Sent by: To …
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat -…
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat…
Opinions on usercpu & syscpu in onstat -p
Just wanted to get some opinions on the usercpu and syscpu meaning in the onstat -p output. I can't remember if I read in Lumbley's guide or not, but if usercpu exceeds the amount of lapsed time this indicates the system could benefit from more physical cpus. Below is an onstat…
onstat -P shows high percentage of other pages
Hello, we switched recently from IDS.7.31.FD2 to IDS.940.FC5. We have 16000000 BUFFERS configured (16 Mio). 48 minutes after a database restart onstat -P showed the following BUFFER usage: Data 36.83 Btree 22.21 Other 40.96 The 40.96% other were not unused pages (partnum 0), b…
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…
onstat -p
We are running IDS 9.3 on Tru64. Most of the onstat -p statistics quit being accumulated 3 days ago and I = have no idea how to restart accumulation without restarting the = instance. What/how causes the stats to not accumulate? How do you begin accumulation again? Copy of onst…
RE: Memory resident tables
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_01C4E77E.F198B930 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
Memory resident tables
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_01C4E467.C99EF9E0 Content-Type: text/plain Hi all, S.O: Solaris 8 ENGINE: IDS 7.31.UD8 In the last days I put some …
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p Êched=91.21 and to be 98 Thank's ========================================================== Profil…
onstat --p
Hi: Considerations can recommend me that parametros and/or deberia to make for being able to improve the performance of my motor, because deacuerdo when coming out of onstat - p %cached=91.21 and to be 98 Thank's ========================================================== Prof…
Re: SQL Tracing tools?
IDS v 9.4 (and maybe earlier) supports 'dynamic explain' to capture sql statements for a specific session: onmode -Y <session id> 0|1 A file is then created with the following name: sqexplain.out.<session id> For example, if you wanted to capture the sql statements for se…
RE: SQL Tracing tools?
Sebastian, Norma J. wrote: > > You said sqlidebug and sqliprint are "internal tools". > Would that be internal as in onstat used to be 'internal'/undocumented > feature.... > Or are they "internal tools" as in you have to get them from IBM? > I've checked the SQL syntax and refe…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
onstat -p - before and after some changes made in attempts to enhance peformance
Hi forum. I have pasted a before and after copy of "onstat -p" and I am hoping to get your take on what you think seems to have gotten better/worse based on just that info. I made some changes to my buffers, cleaners, lrus and check point intervals - largely based on input from y…
Relationship between Êche read and bufwaits parameters
Hi, I'm study onstat -p output and I have one question: somebody know the best relationship between Êche read and bufwaits parameters? Because I don't found too much in the performace guide, only Êche read must be grater than 90%. Thanks Paola…
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.…
BUFFERS! Arghhh!!! Please help before I do something silly!
On Tue, 27 Apr 2004 16:29:36 -0400, sumGirl wrote: My last should say (about using the onstat -P output): "and you can drop BUFFERS by the number shown in 'other' on that line with no production effect" Sorry about that. Art S. Kagel…
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…
Re: how to tune buffer allocated to index data?
Nebojsa Sevo <DELETE_mips@zg.htnet.hr> wrote in message news:<qp0b50hrfiu73mgtt9unvvs9cnpccv84bk@4ax.com>... > How did you get those informations? > From "onstat" (which option) or something else? > > Thanks > > nebojsa >> Simple.. onstat -P | tail -5 >> Cheers…
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: 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…
Re: DiskRead-Cache always 0.00%
Manuela Biel wrote: > Hi, > > since a few days without any revelant changes in the informix-configuration, > out Disk-Read-Cache is always zero. > > Example: (onstat -p) > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 803475051 834961363 238…
DiskRead-Cache always 0.00%
Hi, since a few days without any revelant changes in the informix-configuration, out Disk-Read-Cache is always zero. Example: (onstat -p) Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 803475051 834961363 238511699 0.00 5432438 16547952 67235…
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…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
onstat -P buffer percentages
Percentages: Data 28.23 Btree 36.69 Other 35.08 What is in Other and why would it be so large?…
moving the physical log
According to the IDS 9.4 docs, I can move the physical log like this: set IFX=D:\\IFMXDATA\\ol_bronco copy nul D:\\IFMXDATA\\ol_bronco\\physpace.001 onspaces -c -d physpace1 -p %IFX%\\physpace.001 -o 0 -s 8192 onparams -p -s 8192 -d physpace1 -y ontape -s -L 0 The IDS bitches o…
how to use onstat -P
How to use onstat -P(not -p) to tell informix server's performance question:? -- Posted via http://dbforums.com…
Re: onstat -p Funny
On 04 Okt 2003, Paul Watson <paul@oninit.com> wrote: > OS: Solaris 9 > > Everything is working fine, no problems as far I can tell then > all of a sudden our monitoring picks up a read cache drop and > I get the following onstat -p. The DBserver is for a website, > traffic leve…
RE: onstat -p Funny
Payl, Just make 'onstat -z' to correct the problem, which is caused by the 'bufreads' couter overflow ------------------------------------------ Alexey Sonkin Senior Database Administrator > -----Original Message----- > From: Paul Watson [mailto:paul@oninit.com] > Sent: Saturd…
onstat -p Funny
OS: Solaris 9 Everything is working fine, no problems as far I can tell then all of a sudden our monitoring picks up a read cache drop and I get the following onstat -p. The DBserver is for a website, traffic levels haven't changed, and there are no background jobs, and I'm see…
ontape -r. How do i know its working ?
OK. It bombed. Any idea what the stuff below means ... oninit: Fatal error in shared memory creation Physical restore failed - could not fork server connection Program over. "Jack A" <jacka8@excite.com> wrote in message news:79cb48187430df1afa179eb63392bbc3@news.teranews.com…
Re: lock table overflow
After bringing the server online for about 2 hours, onstat -p shows" ovrlocks = 12 ovrbufs = 23 bufwaits = 265372 lokreqs = 64million+ In onconfig: LOCKS = 20,000 BUFFS = 200 Does this seem reasonable? If not, what values would be appropriate? What other parameters should I che…
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…
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???…
RE: TBLSPACE_STATS
Hi, In the machine notes for ids 9 I find the next text: "16. In this release, partition profiling can be disabled by setting a new configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file. When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will …
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…
onstat -p all zero
Thanks for your reply Jonathan Leffler, I do have a performance problem, some users have complained of 'slows' with the OLTP part of the application. But this hasn't been quantified yet. Without an accurate definition of 'slows' I decided to investigate the performance anyway. T…
RE: equiv to onstat -P in systables?
sysprofile > -----Original Message----- > From: Big Swifty [mailto:kevin_burdish@timeinc.com] > Sent: Thursday, February 08, 2001 1:29 PM > To: informix-list@iiug.org > Subject: equiv to onstat -P in systables? > > > Hey all! > > Is there an equivalent to onstat -P in systables …
equiv to onstat -P in systables?
Hey all! Is there an equivalent to onstat -P in systables I can't seem to find anything in the documentation. Thanks in advance!! Please respond to kevin_burdish@timeinc.com as well as the group. Thanks, Kevin…
Unable to attach to shared memory
Thanks for all the input... I check everything! This server got a complete physical. Of course, all file permissions were correct (suid and all), all chunks were owned properly. However, ONE thing did escape my first attempts at find the problem. A simple KAIOON=1; export KA…
Re: 7.31 performance problem
Yes I have. KT > Have you run update statistics? onstat -p shows a lot of sequential scans.…
RE: Btree Percentage
Does the engine need to be recycled? -----Original Message----- From: hanna_shaw@my-deja.com [mailto:hanna_shaw@my-deja.com] Sent: Tuesday, December 12, 2000 11:24 AM To: informix-list@iiug.org Subject: Re: Btree Percentage Hi, Frank, Thanks for your help. It's new for me. I n…
Performance: where should I look ?
Hello to the masters of IFX, Since Sep-2000 I'm reading this newsgroup regarding performance problems. I managed to double the performance thanks to you all. Even if the users weren't complaining about the performance, checking some parameters/ratios at a daily/weekly basis mad…
RE: Btree Percentage
You are probably being impacted by one of the following bugs: 121515 115327 Look at Informix's TechInfo Center for more details. Before using NOLRUPRIO, check your release notes to ensue that bug# 111681 has been fixed in your release. 111681 - NOLRUPRIO DOES NOT WORK AND C…
Btree Percentage
hanna_shaw@my-deja.com schrieb: > > Hi, > > We have a performance problem in one of our production box for a long > time. I found the percentage of Btree in the box is really high. Here > is the tail part of output of 'onstat -P': > > Percentages: > Data 3.38 > Btree 95.41 > Oth…
What requires an IDS Linux?
Hello What requires an Informix Dynamic Server Linux a desktop and/or a network version of Linux? Thanks in advance Jacqueline Romero Miranda…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: Owner of Table
From: chris <cwalz@mayn.de> > >hi, >yes their is a way. update systables! i did it and got no probs WARNING: This is unsupported. If you do it and something breaks, Tech Support will just laugh at you. >GP wrote: > > > I'd like to rename the owner part of a table. I had a tabl…
Re: HewlettPackard XP 256
Me too, although I think one of my pigs stilts is broken. ----- Original Message ----- From: Obnoxio The Clown <obnoxio@hotmail.com> To: <aboo@syd-co.au.dhl.com>; <saviop75@hotmail.com> Cc: <informix-list@iiug.org> Sent: Friday, November 10, 2000 4:45 AM Subject: Re: HewlettPack…
Re: The RAID Shuffle...
From: "Mr. Anonymous" <mranonnymouse@yahoo.com> > >Hello from the intensely-contested electoral state of Florida. Lucky old you. >I've been shoveling my way through a disaster of a db (inherited from an >admin whose idea of research was glossy full-page magazine ads) and am >ab…
Re: HewlettPackard XP 256
From: "Aboobacker VADAKKUMURI VALAPPIL" <aboo@syd-co.au.dhl.com> > >RAID10 is not yet supported in XP256. If XP256 would have support RAID10, >it Oh, really? >would not make much difference in Performance becuase most of the data will >be >cached. If you have a 4GB cache in XP2…
Re: ..just IX
From: "smooth1" <smooth1@iclway.co.uk> > >jwillis@lcc.net wrote in message <8tal58$lju$1@news.xmission.com>... > > > >It just occurred to me IX is roman numeral 9 > >which is the current Informix version number. > > > >Maybe they could change the name to that, and then > >the nex…
shared memory question
The size of resident segment depens on the onconfig parameters like BUFFERS, LOCKS & CONFIGSIZE (for XPS). Hence u cannot directly control the resident segment size but changing the above parameters will change the size requirements. U can find more details in Performance Guide…
Re: Diferents RAID levels.
From: "Isidre PONS ROCA" <ipons@dtgna.altanet.org> > >Platform : Informix 9.24.UC1 on Solaris 2.6 9.20 or 9.14? There is no 9.24? >We are planning how can increase the performance of our storage system and >do it more secure. >Art, Obnoxio and others say "never use RAID 5 (this…
Re: question about the number of oninit processes
From: Chris Warwick <chris.warwick@alcatel.com> > >This is a multi-part message in MIME format. Please don't post MIME >I am on a Sun running Solaris 7, and I notice there is a set of 10 >informix processes all called oninit, all consuming 17% of my virtual >memory. > >I am dea…
Onstat -P
Hello all, I am hoping you can clear up something for me. I am curious about the onstat -P command. The Admin Guide/Manual for 7.3x has one pithy statement about "display for all partitions the partition number and break up of pages in the buffer pool belonging to the partitio…
Re: RAID or JBOD
From: malc_p@my-deja.com > >Here's the can, there's the can opener, go and get the worms out of the >can. > >Okey-dokey guys, the $64,000 dollar question: > >450-table, 75Gb IDS7.31 OLTP (insurance) database on HP-UX 10.20 4-way. >Slowing up, parameters more or less tuned to opti…
Re: Switch from AIX to NT???
From: "Doug Fossmeyer" <dfossmeyer@gmx.net> > >----- Original Message ----- >From: "Karl & Betty Schendel" <schendel@kbcomputer.com> > > > In article <8t9mgt$nn4$1@nnrp1.deja.com>, thamus <thamus@my-deja.com> > > wrote: > > [snip] > > > Linux has better performance (depending on …
RE: Switch from AIX to NT???
From: Hannes Visagie <visagi_h@mtn.co.ug> > >4. And for the few lucky ones, where GSM Mobile, dial in from our NOKIA >9110 >cell phones. Absolutely remote management anyware/anytime. > >SMS {GSM-Short message service} keep us updated of what is happening on our >servers. {Warnin…
Re: Switch from AIX to NT???
From: thamus <thamus@my-deja.com> > > > >I would not laud the performance/scalability/etc. of NT over UNIX, >but, > > >yes, I > > >use it, and yes, it works fine for my applications. My applications? > > >Letting > > >dumb end users have a good database at a reasonable price. T…
Re: Switch from AIX to NT???
From: SPasco@unibiz.com > >From: SPasco@unibiz.com > > > >I wouldn't say it's a WAY bigger pain in the ass than on AIX. Scripting >on > >UNIX is just easier. > >Unless you are fluent in NT Scripting. > >"NT scripting"? Is that one of those oxymoron things, like "military >intell…
Re: Switch from AIX to NT???
From: SPasco@unibiz.com > >I wouldn't say it's a WAY bigger pain in the ass than on AIX. Scripting on >UNIX is just easier. >Unless you are fluent in NT Scripting. "NT scripting"? Is that one of those oxymoron things, like "military intelligence"? Ha ha ha. Funny. WSH - windo…
Re: manipulating data files
From: triggerfish2001@hotmail.com > >I have just basic knowledge of perl. The task I need to accomplish is as >follows: > >source file needs to be converted to target file. > >source file will be a fixed column length ASCII file of data. > >target file will be a PIPE ('|') sepera…
Re: logical log space
From: "adiosadios" <adiosadios@crosswinds.net> > >The initial install of 7.31 has the rootdbs too small and the llogdbs sits >next to it on the same spindle. I need to increase the rootdbs, which >means >either moving the rootdbs-or-killing the llogdbs, extending the rootdbs, >a…
Re: logical log space
I thought the rootdbs had to be contiguous...hp-ux pextent 0-256 or 0-384... lemme re-read the wonderful manuals and hold my questions... thanks Doug ----- Original Message ----- From: "Obnoxio The Clown" <obnoxio@hotmail.com> To: <adiosadios@crosswinds.net>; <informix-list@iiu…
Linux Cannot attach to shared memory. errno = 43:
I've recently installed IIF 2000 with IDS 9.21.UC2 on a Mandrake 7.1 Linux box. After I initialized the DB and started oninit I can do 'onstat -p' once and everything works great. The second time I do 'onstat -p' I get: onstat: Cannot attach to shared memory. errno = 43 I can't…
Re: SE 7.24 performance
From: "r_hao" <r_hao@hotmail.com> > >We have a table with about 14 million records. This table was part of >database running on Linux machine(SE 7.2 too). Since you got a better HP >UNIX (10.2) machine, we moved it to HP UNIX. However, the performance of >SELECT sql (we only do t…
Insert performance is poor
Tony Flaherty wrote: > >TBLSPACE_STATS 1 > > This has a huge (allegedly 20-30%) processing overhead, it should be turned > of (0) unless you are trouble shooting a specific problem. > This is'nt quite right. TBLSPACE_STATS hardly affects performance (but allows you to retrieve…
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: monitoring online!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!(newbie)
From: Simbarashe.Pangeti@icl.com > >Well people i have changed my onconfig .My aim is to increase performance >How best can i monitor the effects of my changes .. which tools should i >use >( which onstat) some thing else .. What parameters should i look at to show >an increase i…
Fwd: FW: HewlettPackard XP 256
All: Recently I have benchmarked four storage subsystems from as many vendors. HP's XP256 did NOT perform well using Raid 5. Using OUR production data simulating OUR environment. The test environment was: - HP V2500 12 cpu - 8 gig ram - I/O depending on vendor . …
Re: HewlettPackard XP 256
From: "Art S. Kagel" <kagel@bloomberg.net> > >I'd bet that RAID10 will give you 50% better performance than RAID5 and >100% more safety for your data. Mmmm...Well, I asked HP here all the difficult questions, and they gave me all the evasive answers. So my guess is that the XP25…
Re: HewlettPackard XP 256
From: edem <sztuka@wsisiz.edu.pl> > >I've seen article about RAID 5 and Informix goes very bad, and i have >question: >did anyone have experience with Hewlett Packard XP 256 and RAID 5 and >Informix? How are they working together? >We have XP256 and RAID 1, and our local HP serv…
Re: Informix Training Courses
From: "Ioannis Demetriades" <demetriades@dial.cylink.com.cy> > >I am interested in attending one of those informix training sessions on >"Informix Dynamic Server Advanced Performance Tuning" and I would like to >get some feedback about the course from people who have done it. It…
Re: Size of blob,clob
I've the function length on html parameter type, I've tried select length(lld_lobsend(object)::clob::html) from table where id = nn; this solution works but the response time is as it count one byte at a time or like performing a file download, is there another way for…
Re: Informix SE 7.2x Performance Problems - Limitations?
From: <aw@topsystem.de> > >We have customer that runs a SE-7.23-Server on a Siemens RM600-420 (Reliant >UNIX 5) who has severe performance problems. There are about 10 users with >up to 3 connections from NT-Workstations. �The database design does not >include relationships but t…
Re: Update statistics?
From: "Daniele" <lele2110@hotmail.com> > >Someone can tell me where I can find the reference for this ? >I'am using Informix Online 7.30 http://www.informix.com/answers/ Performance Guide and the SQL Syntax manual. ________________________________________________________________…
onmode -F
Has anybody been facing a problem when running onstat -F We had problems with logical logs, they didn't got backed up. We are using onbar. After rebooting Informix everything has been always ok !. Now I tried onstat -F, because I think it's a kind of memory fragmentation problem.…
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…
poor performance revisted
Obnoxio The Clown wrote: > > > >onstat -P | tail -5: > > > > > > > >Percentages: > > > >Data 6.77 > > > >Btree 92.40 > > > >Other 0.82 > > > > > > This looks ugly. What is the output of > > > > > > onstat -B | grep " d0 " | wc -l > > > > 0 > > Hmmmm...what's the smiley for rai…
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…
FW: Mystery Session
Kirk, We first experienced this with 7.31 TC2 and the problem is still observed in 7.31 TC5. My discussions with informix technical support suggest a buffer overrun on the logon name of the session. So instead of displaying user 'informix' it displays garbage. AFAIK it is a…
Re: Performance Tweaking
From: "Obnoxio The Clown" <obnoxio@hotmail.com> > >From: "AJ" <aj@acck.edu> >> >>I have an HP9000-800 series D270 two way running HPUX 11.0 and Informix >>7.3 >>Dynamic Server. >>I also have 1 Gig of memory installed, 3x 600 meg swapspaces, 100000 >>BUFFERS, 63 LRUs, NUMCPUVP=2, …
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…
RE: What is bufwaits (onstat -p)
>===== Original Message From "Mark D. Stock" <mdstock@mydas.freeserve.co.uk> ===== >"Art S. Kagel" wrote: >> >> The bufwaits indicates when a thread has to wait to read a page into a >> buffer from disk usually this is caused by the LRU Queue to which the thread >> has hashed to …
Re: What is bufwaits (onstat -p)
"Art S. Kagel" wrote: > > The bufwaits indicates when a thread has to wait to read a page into a > buffer from disk usually this is caused by the LRU Queue to which the thread > has hashed to acquire a buffer being locked by another thread trying to do > the same thing or needing…
RE: What is bufwaits (onstat -p)
I have one question. From your message: -- Pages that get both update and read activity or pages that get updated by multiple users are the source of bufwaits. The odds of two users with incompatible access modes hitting the same page at the same time is little affected by the …
Re: What is bufwaits (onstat -p)
Bufwaits have little or nothing to do with LRU contention nor with reading in a page from disk. As Vinod said it does occur when one has to wait on a buffer because another is accessing it. The counter is not incremented because one waits to get access to an LRU. It is increme…
What is bufwaits (onstat -p)
Hello friends, What is bufwaits? Is it incremented when somebody has to access a buffer but has to wait as somebody else is accessing the buffer? I have read somewhere that bufwaits can be reduced by increasing the BUFFERS parameter in onconfig. I agree increasing BUFFERS param…
problem with onstat -p "pagreads" value decrementing
Hi, Has anyone noticed a problem with the pagreads stat in onstat -p being decremented in what looks like a random way? I parse the output of onstat -p regularly and store the output into a csv file. I've noticed that after an unpredictable amount of time the value gets decrem…
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…
Re: onstat -p
From: "Colleen M. Morrow" <Colleen_M._Morrow@jonesday.com> > >I am using IDS 7.31.UC6, recently upgraded from 7.24. When I run onstat >-p, there's an additional line of output that doesn't seem to be documented >in the Answers Online manual. Does anyone know what these fields a…
onstat -p
_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please not…
Client-Server problem with informix
Hi to all 10 days ago I had a problem with date field (error number -1205, month and day exchanged...) I wrote a client-server application (in PowerBuilder, but this shoudn't be important) who retrieves and stores data from an informix database server (OnLine 7.0). There is a …
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…
RE: rootdbs size?
Hey, so I am a copy cat. I never claimed anything I said was original Will >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> ===== >From: William Rice <ricew@operamail.com> >> >>onstat -c >>onstat -m >>onstat -d >>onstat -D >>onstat -p >>onstat -P | tail -5 …
RE: rootdbs size?
From: William Rice <ricew@operamail.com> > >onstat -c >onstat -m >onstat -d >onstat -D >onstat -p >onstat -P | tail -5 >onstat -R >onstat -F >onstat -g seg I feel like I'm stuck in a time loop! ______________________________________________________ Get Your Private, Free Email a…
HELP! Informix Dynamic Server 7.3
I'm trying to install a new IDS on Linux (RedHat 6.1) on a cooked file. Everything looks right, but upon oninit, I receive the following: oninit: Cannot open chunk '/u1/naf_chunk'. errno = 2 oninit: Fatal error in shared memory initialization Log reflects: 09:11:07 Informi…
UDR Support in Informix Dynamic Server.
Can someone tell me what exact version of Informix Dynamic Server that first supported C User Defined Routines. I've tried searching for this on their website with no joy. (their advanced search doesnt work at all !) Rgds, Peter. Sent via Deja.com http://www.deja.com/ Before y…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: Sysprofiles + onstat -p : ovuserthreads
D.Penfold@Libertel.nl wrote: > > I hope you cheeky chappies at IIUG have a moment or two to answer my > question: Well none of the chaps or chapesses at IIUG are very cheeky and the Clown is not around at the moment. ;-) > I'm comparing onstat -p + sysprofiles, ovuserthreads is…
Sysprofiles + onstat -p : ovuserthreads
I hope you cheeky chappies at IIUG have a moment or two to answer my question: I'm comparing onstat -p + sysprofiles, ovuserthreads is not in sysprofiles. I assumed that ovuserthreads would be incremented every time someone tried to connect after max connections (NETTYPE) had be…
Re: Informix-NT performance
From: ivon4388@my-deja.com > >I have big problem with HP LXr 8000 with >4xprocessors Xeon 400, 1Mb, 2048 RAM, NT 4 Server >Enterprise Edition, SP4 and Informix Database. >After rising user sessions over 1000 the average >CPU time on all processors(all thy are allowed >for Informi…
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…
onstat -u ....waiting on condition
Hi I was just looking at the output from onstat -u 3b706d2c Y--P--- 97984 3b70d958 Y--P--- 121881 3b710860 Y--P--- 100957 3b71167c ---P--- 121893 3b711fe4 Y--P--- 113791 3b71b1b0 ---PR-- 121842 3b7230ac Y--P--- 100952 3d96c014 S--PR-- 121894 3d96fd38 Y--P--- 104413 3d9714bc Y--P…
Re: Urgent-ontape backup problem.
<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html> Well you've likely got this problem licked by now but in case you haven't, <br>I've seen something like this before on one of our engines. If I remember <br>correctly I had to backup the logs first (check <i>on…
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…
btree percentages at 95%
Hi all.... We have been analyzing the performance of a particular job and I was wondering if anyone has insight into the following question. The analysis shows that the buffers have 96% btree data and only 3% data. Might this be a symptom of the index bug which shows up in syst…
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…
Tracking conditions
If a thread is waiting for a resource which is a "condition", is it possible to find out what that condition is? informix@Lawson $ onstat -u | grep robink e2bdf798 Y--P--- 55397 robink - e62c2608 0 1 101 0 informix@Lawson $ onstat -g con | grep e62c2608 …
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…
ovbuff vs. fgwrites question
This may be a stupid question but you know the old saying..... I noticed an increase in 'ovbuff' on the onstat -p. This is a very small database running on NT and so I increased my buffers. I then realized that this number is the same as my 'fgwrites'. Is this one and the sa…
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: Performance Problem with many buffer wait
Hi all informix expert, Thank you very much for all of your advice. And I have tuned the informix parameter to BUFFER=40000 (old 20000) LRUS=32 (old 16) CLEANERS=16 (old 8) and the database is still under monitoring, see whether it have improvem…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
Re: onstat -p, oncheck -pr
Kevin, I wrote that article for Tech notes and thought it was on my web site but it is not yet...sorry. But an older version is in our user group newsletter and that on the web at: http://www.iiug.org/~waiug/iugnew81.htm#Exploring the Informix OnLine Utility - ONSTAT I also ha…
Re: onstat -p, oncheck -pr
Yes, I checked it out and also ordered hard copies of old issue..Thanks alot. Art S. Kagel wrote: > Most recent TechNotes issues are ONLINE on the Informix WEB Site in the > TechInfo Center under <publications>. If you are not a member of TechInfo > Center you can enroll free …
Re: onstat -p, oncheck -pr
Most recent TechNotes issues are ONLINE on the Informix WEB Site in the TechInfo Center under <publications>. If you are not a member of TechInfo Center you can enroll free if you have a supported serial number or support contract number. Art S. Kagel Kevin Kim wrote: > > Than…
Re: onstat -p, oncheck -pr
Thanks, That's what I need, however I don't have "Vol8 No1" I should order it from Informix. Art S. Kagel wrote: > Kevin, there was a good discussion of most of the onstat output fields in > a TechNotes article, I think Vol 8 No 1 IMS. Check the Informix site for > th…
Re: onstat -p, oncheck -pr
Let's start again. From: Kevin Kim <Kevin.K.Kim@pop.mcit.com> > >The reason that I posted it was because manual is not comprehansive, >it doesn't discuss below paramaters in detail and not all.. What exactly do you want to know? I think the manuals are very comprehensive, you j…
Re: onstat -p, oncheck -pr
Kevin, there was a good discussion of most of the onstat output fields in a TechNotes article, I think Vol 8 No 1 IMS. Check the Informix site for the online versions on the TechInfo Center area (registration is free if you have any current support contracts on your Informix pro…
Re: onstat -p, oncheck -pr
From: Kevin Kim <Kevin.K.Kim@pop.mcit.com> > >This is a multi-part message in MIME format. >--------------9F2C17A3F05AEA91164B575F >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >Can anyone tell me what all below means, I need to know all not just …
onstat -p, oncheck -pr
Can anyone tell me what all below means, I need to know all not just some. Also, if you know others (e.g. oncheck, onstat) please help.. I know most but not all.. dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached isamtot open start read write …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
Re: FW: Upgrading from version 4.1.2 to 7.2.4
Valerie IMHO, your question is too general. Monitoring tools are mainly onstat (and oncheck to check for disk structures). I would take a quick look at the online log (onstat -m) and do an onstat -p for profile information and post these here for help. HTH Sujit Webber Valerie…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
read and write cache percentages
In article <7mrhba$pd7$1@nnrp1.deja.com>, Vic Newman <klball@my-deja.com> wrote: > We are running 7.2 on hp 9000 with approx 240 users. I noticed the > write cache percentage was 67%, the read cache percentage was 97%. Is > the 67% ok. Are there any paramenters we should b…
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…
Write cache low
Hi everybody there Following is onmonitor performance statistics and onconfig file listing. Can somebody help me improve write cache please ? STATUS: Profile Userthreads Spaces Databases Logs Archive ... Display system profile information. -----------------------------On…
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: Performance problems
There are a very large number of sequential scans (onstat -p)!! Have you run update statistics medium as described in the release notes? Can you really run the application on 2000 buffers? There is a HUGE number of buffer waits - the obvious answer to the question is no! You w…
Performance problems
System : IBM RS6000 model suz580 AIX v 4.2.1 (Single processor) (73.3 Specint92 134.6 Specfp92) Informix : Version 7.3 UD6 We upgraded 2 weeks ago from Online Version 5.05 to version 7.3. With version 5.05 the performance was ok, but since the upgrade we have big performance pro…
Online Config Changes
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_01BEA792.AEE11024 Content-Type: text/plain Hello all, Can I dynamically change BUFFERS and RA_THRESHOLD without having …
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: Effect of disk striping on disk layout
From: John Bejarano <jbejaran@my-dejanews.com> > >My new company has an INFORMIX server that is agonizingly slow. Much of >this may be due to the application running against it, but I can tell >that disk I/O on this system was poorly implemented. I've suggested >ways of balanci…
Monitoring documentation
Hello all, I am trying to document things that need to be monitored on our database (7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more suggestions for things to look at. Here is what I have so far. Locking number of currently held locks - (onstat -u) …
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
onstat -u problems
Whenever i run onstat -u i receive following message INFORMIX-OnLine Version 7.13.UC1 -- On-Line -- Up 5 days 01:49:50 -- 30456 Kbs Userthreads address flags sessid user tty wait tout locks nreads nwrites b028010 ---P--D 0 root - 0 …
Re: onstat -p output
Hey, >I was just curios to see some new things in onstat -p output which i >have not seen in any previous version. >Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 7 days >04:05:56 -- 306416 Kbytes >.... >gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs…
onstat -p output
Hey Guy's, IDS 7.30UC2 on Solaris 2.5.1 I was just curios to see some new things in onstat -p output which i have not seen in any previous version. Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 7 days 04:05:56 -- 306416 Kbytes Profile dskreads pagreads bufreads …
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: priority question
Dianne I am only guessing here, since I never had to do this sort of thing, but the Unix pid corresponding to the session id can be found from onstat -g ses <session_id> where session_id = 52697 in your example. On some Unix systems priority can be increased by root by decreasin…
priority question
Hi everyone. Can the priority be raised on a particular session? For instance, if I have this onstat -u: INFORMIX-OnLine Version 7.23.UC1 -- On-Line -- Up 57 days 00:27:52 -- 224688 K bytes Userthreads address flags sessid user tty wait tout locks nreads nw…
converting Informix Online 5.1 esql/c to Dynamic Server esql/c?
Hi converting Informix Online 5.1 esql/c to Dynamic Server esql/c? What is the easiest way to do this? Is there a parser that could do this? edward…
RAID Technolgy
We are using Informix Online Dynamic Server 7.2. We are going in for a new DEC UNIX Server with RAID Technolgy. It incorporates mirroring at the hardware level. So is it not necessary to do mirroring using Informix?. Can anybody give suggestions regarding mirroring and other feat…
Informix on Linux
Does anybody know how much a copy of Informix Dynamic Server would run me for use on Linux?? Thanks in advance -steve…
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?…
configuring LRU MIN/MAX,clarification
Could You please explain this with a little more detail? Also why pagreads and not bufreads ? TIA Sathish Sadagopan <snipped> If your bufwaits (onstat -p) is more than a few % of (pagreads + bufwrits) then you are experiencing LRU contention and need to increase LRUS. N.B. - …
Informix Dynamic Server 7.31?
Is any information available regarding the release of IDS 7.31 for Unix? We have Sun E3000 and E4000 machines and are experiencing problems with both 7.30.UC3 and 7.30.UC5 and are curious about 7.31. Thanks. Carleen Avant Naval Safety Center Internet < cavant@safecen.navy.mil …
STRING FUNCTIONS
Are there functions for manipulating varchar type, like upper() or lower() in Informix Online Dynamic Server 7.2? Thanks in advance.…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: Run your eyes over this onstat -p listing
Greg, Give us a hint about what doesn't look right. At first glance, it looks like a tuning issue. Things are working, and not all that bad, but could stand for improvement. Also some waiting for locks, but if you have a lot of users that might be OK. What's your message log lo…
Run your eyes over this onstat -p listing
------ =_NextPart_000_01BDC4B8.1CFE5B20 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable All, Attached is a copy of an onstat -p losting sent to me by a o/s team who = I deal with on a daily basis. This just does not look right. I have m…
Re: seqscans (onstat -p)
Number of sequential scans executed. Onstat -p has a mediocre definition in the back of Volume 2 of the Administrator's Guide. cajt wrote: > What does mean seqscans in onstat -p ? > > Thanks Cajt -- Vic Goldberg Manager, DBA Team, Acting Manager, Technical Integration Cornell…
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…
seqscans (onstat -p)
What does mean seqscans in onstat -p ? Thanks Cajt…
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: Negative cached in onstat -p
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
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…
latch/lock , buffer - questions.
Hi All, 1) When a thread needs a buffer to read in data , does it acquire any latches/locks.How is the allocation done ? 2) What is the difference between locks and latches. 3) If i want to track , the number of times a PARTICULAR user's operations caused his threads to wai…
Re: Negative cached in onstat -p
In article <35AA769E.D785208B@biztravel.com>, tomg@biztravel.com (Tom Grenier) wrote: > While looking at the stats last weekend -- my % cached was negative. > Didn't seem to have any affect on anything, and I did a onstat -z to > reset everything, but wondered what happened to c…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Negative cached in onstat -p
Tom Grenier (tomg@biztravel.com) wrote: : While looking at the stats last weekend -- my % cached was negative. : Didn't seem to have any affect on anything, and I did a onstat -z to : reset everything, but wondered what happened to cause it. Any thoughts? Tom, You've overflowed…
Negative cached in onstat -p
While looking at the stats last weekend -- my % cached was negative. Didn't seem to have any affect on anything, and I did a onstat -z to reset everything, but wondered what happened to cause it. Any thoughts? INFORMIX-OnLine Version 7.22.UC2 -- On-Line -- Up 51 days 08:41:21…
Re: -461 error on connect.
Ray O'Hagan wrote: > Hi, > > I have a stored procedure which system() calls one > of our applications. This application itself tries > to connect to the database, but I'm continually getting > a -461 (File Open Error) when I try to connect. Has > anyone come across this before ?…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Online seems to be blocked
Hi, Sometimes at one of my customers Informix Online seems to be blocked. Users cannot work any more, when you try to start onmonitor it hangs too. Also, it is no more possible to shutdown Informix by onmode -ky. Most of the users are "Waiting for an event" (status Y in onstat …
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
onunload fails! help.
I try to onunload the demo database "stores7". machine>onstat -u INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 00:41:21 -- 10544 Kbytes Userthreads address flags sessid user tty wait tout locks nreads nwrites a2ac018 ---P--D 1 informix - …
Re: Online 5 to 722 Performance
Art S. Kagel wrote: > > Paul Watson wrote: > > > > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > > except the 722 runs 75-100% slower than 5. All the index's have been > > rebuilt and updates statistics have been run as per the release notes. > > …
Re: Online 5 to 722 Performance
Paul Watson wrote: > > This weekend upgrade a server from Online 5.x to 7.22.UC5. Everything went > except the 722 runs 75-100% slower than 5. All the index's have been > rebuilt and updates statistics have been run as per the release notes. > > I think I might be seeing the re…
Re: Transaction Throughput Analysis
The problem with onstat -p commit and rollback count, is that it only counts begin commit/rollback blocks and not standalone statements that don't use a transaction. The numbers are therefore the wrong ones to be compared against other DBMS's Art S. Kagel wrote: > darren@systea…
RE: Followup: [?]Menu development tool documentation
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_000_01BD752E.9E54669E Content-Type: text/plain Uhmmmmm... I beg to differ, Jake. At a previous job, we did just exactly wh…
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…
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…
onstat -g dic output
<HTML> Hello, <P>Can somebody explain me the outcome of onstat -g dic <tablename>. <P>- What means all the output. <BR>- What can I do with it. <P>Regards, <P>Albert Wisse</HTML>…
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.…
onstat counter size
Could anyone tell me at what value the onstat counters wrap. I am particularly interested in the following: onsta -D page I/O for chunks onstat -g iof disk I/O for chunks onstat -p server profile (I/O, ISAM, CPU) onstat -g glo virtual processes From observation…
Re: HELP!! oninit -i fails ... Help
Thanks for the input. Since I was doing an "oninit -i" I resolved it like this 1) Saved the environment variables 2) Saved the onconfig, sqlhosts and /etc/services files (Critical ones) 3) Ran installonline 4) Performed an oninit -i with my onconfig, sqlhosts and /etc/services …
Re: HELP!! oninit -i fails ... Help
Sham Vaidya wrote: .... > After performing an "oninit -i" with the original initialization > and shared memory parameters without any dbspace except root > dbspace and its chunk, the error I get in onmonitor > is "WARNING: Network Down". I tail the log file & it mentions > that I…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
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…
Re: Informix security questions
David Williams wrote: > > In article <345E3F4C.654A@bloomberg.com>, "Art S. Kagel" > <kagel@bloomberg.com> writes > >James Woodger wrote: > >> > >> I have two basic security questions about Informix: > >> > >> 1. Is it true that if a user has execute permission on a stored proc, …
Re: Informix security questions
In article <345E3F4C.654A@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >James Woodger wrote: >> >> I have two basic security questions about Informix: >> >> 1. Is it true that if a user has execute permission on a stored proc, >> then the stored proc will be allowe…
Re: Informix security questions
James Woodger wrote: > > I have two basic security questions about Informix: > > 1. Is it true that if a user has execute permission on a stored proc, > then the stored proc will be allowed to perform any table reads or > updates (regardless of the original user's security profil…
Re: Informix security questions
At 09:59 AM 11/3/97 -0500, you wrote: >I have two basic security questions about Informix: > >1. Is it true that if a user has execute permission on a stored proc, >then the stored proc will be allowed to perform any table reads or >updates (regardless of the original user's secu…
Informix security questions
I have two basic security questions about Informix: 1. Is it true that if a user has execute permission on a stored proc, then the stored proc will be allowed to perform any table reads or updates (regardless of the original user's security profile). In other words, stored proc…
Re: NLS with Online workgroup server
Philippe Verdy wrote: > All information about Informix in the registry are now stored under the > following keys: > HKEY_LOCAL_MACHINE\\Software\\Informix: global installation settings > HKEY_CURRENT_USER\\Software\\Informix: user-level profile, which is one of: > HKEY_USERS\\*\…
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: bufreads in onstat -p output
Madison Pardon me if this is a stupid question, but how do I reconfigure the dictionary to be larger if this is the problem? TIA Sujit Pal ---------- From: SaTriGuy[SMTP:satriguy@aol.com] Sent: Sunday, August 31, 1997 5:27 PM To: informix-list@rmy.emory.edu Subject: Re: b…
Re: bufreads in onstat -p output
>Hi guys, > > I am facing a problem with an application suddenly becoming slow. The > interesting thing which I noticed when this application was running > was that the bufreads display in onstat -p output was increasing at an > alarming rate. I am setting this to…
bufreads in onstat -p output
Hi, Sorry for resending the message. I forgot to mention in my earlier message that I am running Informix ODS 7.22 UC2 on Sun Sparc 5000 on Solaris 2.5.1. and the application is an esql-c program. Ketan. >Hi guys, >I am facing a problem with an application suddenly …
bufreads in onstat -p output
Hi guys, I am facing a problem with an application suddenly becoming slow. The interesting thing which I noticed when this application was running was that the bufreads display in onstat -p output was increasing at an alarming rate. I am setting this to …
Re: onstat -p seqscans
tony edwards (tony.edwards@bellsouth.co.nz) wrote: : Hi, : : Does anyone know if the seqscans in an onstat -p increments for : sequential scans on temporary tables ? : Cheers, Tony. I don't think so. I've used a script similar to one posted on this thread to watch my scans, an…
Re: onstat -p seqscans
tony edwards wrote: > > Hi, > > Does anyone know if the seqscans in an onstat -p increments for > sequential scans on temporary tables ? > > Cheers, Tony. Try the following sql to see which tables have seq_scans. select dbsname, tabname, seqscans from sysmaster:sysptprof; Kern…
onstat -p seqscans
Hi, Does anyone know if the seqscans in an onstat -p increments for sequential scans on temporary tables ? Cheers, Tony.…
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 question
}> }>When we use the Onstat -u , sometimes we get this display: }> }>onstat -u }> }>INFORMIX-OnLine Version 7.12.UC1 -- On-Line -- Up 11 days 20:31:52 -- 142096 Kbytes }> }>Userthreads }>address flags sessid user tty wait tout locks nreads nwrites }>332c020 -…
Re: Onstat question
Bringing online down and up is not a solution, because the "problem" you have is kinda random. I had the same one, and I called the tech support. The message "Changing data structure..." is due to concurrent access to shared memory. I.E., onstat -u reads data from the shared memo…
Re: Informix 5 Performance Issues
On 17 Apr 97 at 18:22, David Williams wrote: } In article <5j4i8s$c7p@cssun.mathcs.emory.edu>, Billy Wheeler } <billy@west.co.za> writes } >Remember - YMMV, etc: } > } >On 16 Apr 97 at 17:04, Phantom173 wrote: } > [SNIP] } >> significant given the facts stated above. He is argu…
onstat
In onstat, what does "total" refer to. . . 1192132c Y--P--- 537 winterm - 12434068 0 1 240 0 13 active, 128 total, 44 maximum concurrent Thanks. Steve Romankiw Executive Risk Inc.…
Re: Two databases, same name, same machine
brianma@compans.com wrote: > What I would like to know is can I run two seperate databases with the > same name on the same machine under Online 5 --- SNIP --- > Also, any ideas as to how system performance might be affected by > this? > > Any suggestions most welcome. -- You c…
Re: 4GL replacement for isql menus
<massive snip to save bandwith> Q: Need to stop users getting to command line from ISQL user menus and perform screens using '!'. A1: set $SHELL to /dev/null in .profile/.login. but 1: then users can't run shell scripts from the user menu. 2: users could modify .profile/.l…
Re: 4GL replacement for isql menus
Dirk Schmidtpott wrote: > > Ian Goddard wrote: > > > > I need to replace the isql menus with something which will prevent the > > users from shelling out with "!". > > > > My immediate thought was to write a 4GL program to look something like > > the original and to use sysmenus …
Re: 4GL replacement for isql menus
Ian Goddard wrote: > > Dirk Schmidtpott wrote: > > > > Ian Goddard wrote: > > > > > > I need to replace the isql menus with something which will prevent the > > > users from shelling out with "!". > > > > > > My immediate thought was to write a 4GL program to look something like …
Re: Retrieving Dates from Informix Into Powerbuilder
STEVE_LOYD@HP-SanJose-om1.om.hp.com wrote: > > Item Subject: cc:Mail Text > > > > Hello... Any Informix / Powerbuilder developers, > > With my .profile informix DBDate=MDY4/ matching my NT International > short date format on the client, I have the following symp…
Re: Retrieving Dates from Informix Into Powerbuilder
STEVE_LOYD@HP-SanJose-om1.om.hp.com wrote: > > Item Subject: cc:Mail Text > > > > Hello... Any Informix / Powerbuilder developers, > > With my .profile informix DBDate=MDY4/ matching my NT International > short date format on the client, I have the following symp…
Retrieving Dates from Informix Into Powerbuilder
Item Subject: cc:Mail Text Hello... Any Informix / Powerbuilder developers, With my .profile informix DBDate=MDY4/ matching my NT International short date format on the client, I have the following symptoms: 1. Dates can be entered and retrieved correct…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: System tuning
Jon McNeill sez: > We recently encountered similar sounding performance problems using > Informix 7.11UC2X?? on a HP K400 with 2 processors and 1280M (!) of RAM. > We had almost 99% cache hits, with still extremely sluggish performance. Our > final performance tuning victory cam…
Re: System tuning
Jon McNeill sez: > We recently encountered similar sounding performance problems using > Informix 7.11UC2X?? on a HP K400 with 2 processors and 1280M (!) of RAM. > We had almost 99% cache hits, with still extremely sluggish performance. Our > final performance tuning victory cam…
Re: Sybase MPP shows excellent scalability to 128 CPUs
NRaden (nraden@aol.com) wrote: : >I'll mee-too this....who cares? Just another pseudo-benchmark from : another : >pseudo-database company.....I'll believe it when I see audited TPC : results. : I don't think TPC results are even relevant. What do they have to do with : decision…
Re: Sybase MPP shows excellent scalability to 128 CPUs
In article <48bmjs$hje@newsbf02.news.aol.com> nraden@aol.com (NRaden) wrote: : : > I don't think TPC results are even relevant. What do they have to do with > decision support, which is clearly the target market? > : : > Perhaps, but given your response, I wonder if you've built…
Re: Informix 7.1 Online Performance Questions??
Scott T Miller (scottm@minerva.robadome.com) wrote: : 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 i Scott, Look at some of the Unix utilities such as sar, iost…
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 …
Re: Monitoring table access
In 7.1 you can use DB/Cockpit Table Profile view, that provides table profiling information noted by Rick (and much more) in the real time. Beginning from 7.1 UD1 table profiling information is available even if table is not currently opened. Vitaly On Fri, 13 Oct 1995, Rick…
Re: Preventing Bang out of Perform
hoinj@cc.tacom.army.mil wrote: : I wrote a Unix shell script which serves as a menu system for users : to run Informix reports, forms, etc. The script is invoked at login via : .profile, and the TRAP command prevents users from breaking out of the : menu with the delete …
Preventing Bang out of Perform
Hi, I'm a first time caller. I wrote a Unix shell script which serves as a menu system for users to run Informix reports, forms, etc. The script is invoked at login via .profile, and the TRAP command prevents users from breaking out of the menu with the delete key. …
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?…
onstat -p (compress)
[ Article crossposted from comp.databases.informix ] [ Author was Graeme Sargent ] [ Posted on 13 Apr 1995 13:40:47 GMT ] John R Worachek (jworache@jcpenney.com) wrote: : What does compress mean within onstat -p output? The number of times a page compression has taken place - i…
Re: onstat -p (compress)
John R Worachek (jworache@jcpenney.com) wrote: : What does compress mean within onstat -p output? The number of times a page compression has taken place - ie the number of times a slot table has been shuffled to make contiguous space out of fragmented space (within a page). -- …
onstat -p (compress)
What does compress mean within onstat -p output? RSAM Version 7.10.UC1 -- On-Line -- Up 49 days 20:55:29 -- 19768 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 499 565 157608 99.68 1169 2056 28596 95.91 isamtot …
Wanted:Oracle Database Administrator(DBA):US-TX-Austin
Database Administrator -- Provide database administration for a large state of the art, World-wide ORACLE 7 database. Activities to include database design, trigger and stored procedure development, resource management, SQL and PL/SQL development and performance tuning, optical …
Re: Optimizing Many-Table Joins
mmueller@calvin.bellahs.com (Michael Mueller RD) writes: >Can anyone tell me the tactics that the query optimizer uses for >optimizing joins, especially queries joining a large number (e.g. >4) >of tables? What is the max number of tables allowed in a query? >How does this comp…
how to autostart INFORMIX in UNIX using rc.local
> > Does anyone know the command to start informix automatically in the > /etc/rc.local? > > I have tried tbinit and tbmode but to no avail. > > Your immediate assistance is appreciated and thanked for in advance! > Check your PATH and TBCONFIG vars. # our start engine script: …
Help with 4.1 NLM version
Does anybody use Informix On-Line for Netware version 4.1 We have a copy of this version to use as the development platform for new project using PowerBuilder as the front end and we get horrible performance. The SQL we are using seems straight forward and the tables are not tha…
Re: CPU usage
Half an aeon ago, Graeme Sargent asked: >From: uunet!pyra.co.uk!graeme (Graeme Sargent) >Subject: Re: CPU usage >Date: Thu, 17 Jun 1993 18:36:02 GMT >X-Informix-List-Id: <news.3589> >In <1vaodqINNndm@emory.mathcs.emory.edu> > eric@carsinfo.com (Eric E. Bardes) writes: …
Re: network security
> > We have a system set up with two RS/6000s, one as our database > server and one as a "software server". Our users rexec a command from > their PCs to run our application on the latter machine. We run I-Net > and I-Star for the communications between the machines. The users…