Oninit® Archive
Results for “onstat -g pqs”
IFX 14.10 FC14 License File
it seems FC13 license can work with FC14 package: onstat -V IBM Informix Dynamic Server Version 14.10.FC14 ------------------------------ ke chen ------------------------------…
How to restrict access for a user to Informix by IP?
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE AIX 7.1 We have several application servers and LDAP based authentication. How to prevent a user's connections from any but the application servers' IPs? ------------------------------ Sincerely, Dennis -------------------------…
Defragment sbspace
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE Please, how to defragment (repack) a sbspace after plenty LOBs been deleted? ------------------------------ Sincerely, Dennis ------------------------------…
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 ------------------------------…
Load progress - raw tables
I used to know this, but I'm getting old....whilst loading a raw table how can I watch the progress re: num rows? onstat -g pqs doesn't help, nor does select count(*), etc. I know why the normal methods don't work internally - just wondered if anyone else remembers how? Thanks! M…
INT to SERIAL in-place alter
Hi, IBM Informix Dynamic Server Version 11.70.FC5XE My question is, why MODIFY INT to SERIAL does not use in-place alter? ------------------------------ Sincerely, Dennis ------------------------------…
PDQ - Why does its performance suck sooooo bad?
Jared: Did you try DS_NONPDQ_QUERY_MEM without PDQ set? Send me schema and sample queries for one or two queries and I'll see what there is to see Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com --…
IO WAIT
Is that the real query or just an example? You may not be able to review the one query in isolation, as there may be more going on to stretch out your execution time to 12 seconds. Get an explain plan and look at the query statistics at the end to see if this was using the expe…
flags (onstat -g ses)
That's the same set of flags as in ' onstat -u ' I'd say. For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one. ------------------------------ Andreas Legner ------------------------------…
How to know what edition is installed ?
I think that when there is no suffix on the version, that that is Enterprise Edition: IBM Informix Dynamic Server Version 12.10.FC6XC <-- custom build, but no suffix IBM Informix Dynamic Server Version 14.10.FC3 ------------------------------ Mike Walker ------------------------…
Are there hidden gotchas w.r.t. moving sysadmin tables?
Steps to move sysadmin https://www.ibm.com/support/pages/moving-resetting-sysadmin-database-new-dbspace-ibm-informix-dynamic-server-ids ------------------------------ Gaurav Kumar ------------------------------…
Informix Mirroring?
Informix will read different pages from both sides of the mirror regardless of whether PDQ is enabled or not. Art…
Fast Recovery after correct shutdown
When the engine is down –what is the last line in the online.log ? If it is not IBM Informix Dynamic Server Stopped then the engine was not shutdown properly Cheers Paul…
How do I determine which edition I m running?
John Miller used to have a web page on this but I'm pretty sure it disappeared. If you execute a onstat - or an oninit -Version and see: IBM Informix Dynamic Server Version 12.10.FC10AEE -- On-Line ...... this is Advanced Enterprise Edition IBM Informix Dynamic Server Vers…
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…
PDQ mixed with OLTP
Hi, First of all good morning to all of the members just want to ask if anyone had done mixing PDQ with OLTP on their database? Our database is mostly OLTP with a batching process running every 12 MN of weekdays up until 3AM, I am wondering if I can use PDQ for the batching proc…
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.…
DS_NONPDQ_QUERY_MEM not changing
I would concur with Jacques that it probably is a defect. I recall trying unsuccessfully to change PDQ related values myself via "onmode -wm" in an older version but never raised a PMR about it. However it worked in a 11.70.FC7W1/12.10.FC9 test instances for me just now. It has …
Is PDQ only for DSS?
Hello all!! IBM's docs says "Parallel database query (PDQ) is a database server feature that can improve performance dramatically when the server processes queries that decision-support applications initiate." (source: https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/c…
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…
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)…
opentable memory leak
Original post: No AUTOINDEX as far as I can tell. Turning off PDQ avoids the issue and I can live with this until permanent fix is found. Thanks, Andrew Response: It's a APAR in 12.10.xC5. APAR IT09544. The description talks about auto-index path, but the real trigger is an…
RSS/HDT Sec - Different Query Plans???
This took long enough but we have resolved this issue. DS_TOTAL_MEMORY was set WAY higher on the system with the poor query plan. We were not using PDQ but it affected this query anyway. IBM is putting a defect together to address the issue. thanx for all the replies, dan…
Looking For Senior Informix DBA
Walt, I spoke to my boss about you in particular. He is willing to consider a remote candidate this time around providing they do not get one locally. Please apply online. Lemme know if you need help finding the req. Thanx, Dan -----Original Message----- From: ids-bounces@iiug…
Fetch time on 12.10FC4
This begs the real question. What is a fast fetch time? Time to fetch the first row? OR Time to fetch all rows? By default the Informix Optimize assumes you want the fastest time to fetch all rows. If you are only measuring the time to fetch the first row then this could be an …
Informix DBA Needed
My company is looking for an Informix DBA. I know this is not the job board but I am not the hiring manager or HR so I did not want to post there. The following is a copy of the actual posting. I can help guide you to the right people if you need it but that is all except for a r…
RE: moving database tables from one dbspace to ano
To add to Art's recommendations ... DS_TOTAL_MEMORY is a very important setting for maximizing use of PDQPRIORITY. It's the memory allocated for PDQ queries out of the virtual portion and guideline is 90% of SHMVIRTSIZE. The biggest benefactor of this is sort memory. Use SET EXPL…
Unfamiliar SQLCODE values using JDBC with Informix
Yes... On Sun, Feb 15, 2015 at 11:10 PM, Mitchell, Jeffrey J. <JJMitchell@west.com> wrote: > The confusing thing about this is that the procedure never really > executes. We > have "logging" in the procedures - start/stop times, parameters passed in, > return string, etc. Other…
IO Wait and PDQ
I have a session running against Informix 11.7 FC7 database. The SQL is running a join against 2 tables, each with 10 fragments a piece. 1 of these tables is stored under cooked chunks due to the sensitivity of contained data. The user specifies SET PDQPRIORITY 4 prior to startin…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Optimising index builds
> On 19 January 2014 at 11:10 NEIL TRUBY <neil.truby@ardenta.com> wrote: > > >> Is DS_TOTAL_MEMORY set high enough to permit significant in-memory sorting? > > I changed DS_TOTAL_MEMORY to 300GB and reduced BUFFERPOOL to 160GB. Now > nothing gets written out to the DBTEMP_SORT fi…
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.…
Poorly Optimized SQL
Thanks David. I am ashamed to admit, but I am still a PDQ novice.…
Do not set the PSORT_NPROCS ?
Folks, I see the following rules on 11.70 info center. In rule 2: "Do not set the *PSORT_NPROCS* environment variable", What negative impacts it would cause if we set the *PSORT_NPROCS* in index creating process? Thanks, Frank http://pic.dhe.ibm.com/infocenter/idshelp/v117/in…
RE: TimeSeries update statistics recommendations [
Good question. Update statistics on a table with a time series column will not play a role in how TimeSeries operations/functions like Apply or AggregateBy behave on the time series elements in the time series column. It may help the optimizer with queries on the base table as wi…
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,…
Using PDQPRIORITY to throttle certain queries
Hoping to get some opinions on this. We have a public website that is currently using our main production database (IDS 11.50.FC6). The main query used by the website uses a single table that typically has 50K to 100K rows. The query typically completes in 0.4 to 0.5 seconds. …
SET PDQPRIORITY in an IF...THEN block?
All: I have some SP code that has a SET PDQPRIORITY N directive inside an IF ... THEN block that checks the application configuration table to see whether PDQ is enabled. Can anyone (Art, ideally) confirm whether or not this will actually work to control PDQ and will NOT use PD…
Use of fragmentaion for tables
If you fragment a table, say by expression, I know that using PDQ will result in the use of parallel scan threads. If your application (it is a third party app) does NOT use PDQ, is it still "useful" (better performance) to fragment tables? Will parallel scans still occur, or wil…
Help about PDQ
Where I put the command set PDQ priority in the application 4gl Thanks Wanderlei…
doubt about parameters (PDQ)
I need to know how to turn on and off the PDQ via application thank you very much Wanderlei - Intera Consultoria…
What are best onconfig parameters for a DSS app
See below: Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organiza…
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…
Fw: Optimizer
One thing Peter, have you tried running this query under SET OPTIMIZATION LOW? You have 10 tables in there, I'm willing to bet that a significant portion of the runtime is optimizing the query since there are 3,628,800 query plans that have to be examined and have cost calculated…
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 …
why phantom pdq message in wee hours?
This involves running IDS 11.70.TC1IE on Windows 2008 Server os. I see this each morning at the same time in the ids log file: 01:11:01 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 10. It is reset to …
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…
Collation Type doubts
Thanks John... It solved my problem!!! I'm planning the migration to 11.7 for the next months. Regards, Alberto. -----Mensagem original----- De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de John Miller iii Enviada em: quarta-feira, 20 de julho de 2011 16:24 Pa…
why does DS_NONPDQ_QUERY_MEM have the prefix "DS"
In Informix Administrator's Reference, I see: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is available for a query that is not a Parallel Database Query (PDQ). My questions are: Now that DS_NONPDQ_QUERY_MEM is for NONPDQ, why does it…
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.…
Explain Plan for Open cursor
The big answer is "Generally, no.". However, there are additional parts to that answer and sometimes the answer is "Sort of.". Any query that is prepared with replaceable parameters in the WHERE clause is only partially optimized. There is a final optimization step that takes the…
Re: System Freezes
Hello, I noticed you have DUMPSHMEM 1 on your onconfig file. Maybe some engine is freezing your engine, trying to dump your memory to the disk? I suggest you to turn off your shared memory dump, and observe the engine behaviour after that. Best regards. Em 12/01/2011 11:14, Ru…
RE: System Freezes
I'm noticing this on a top after a system freeze: 550 processes: 317 sleeping, 63 running, 168 stopped When the system comes back, the stopped process number starts dropping quickly. Within a few second, all the stopped process start running and I see something like this: 550…
RE: System Freezes
This HP rx6600 has an integrated iLO. I tried connecting to that via SSH and starting a console window, but the console login froze too. I can move around the ILO menu during the freezes, but the connection to HPUX also freezes there. We are running a vendor provided ERP and t…
Re: System Freezes
Do you have a console that you can use for monitoring rather than relying on a telnet type session ? I had an issue last week on an AIX box that kept dropping connections, not allowing a connection, 'downing' print queues etc. Identified the issue as a SAMBA validation issue on s…
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…
534: Cannot open EXPLAIN output file.
Dear Informix Gurus, Need your advice & help in solving the below issues. I was trying to get the SQL Plan for some queries which is taking few minutes. But I am encountering with an error number:-534 I tried to sort out the issue using finderr utility. ---------------------…
Re: limit on query length in Informix IDS 11.50
On Wed, Sep 29, 2010 at 9:21 PM, Gentian Hila <genti.tech@gmail.com> wrote: > I will try dbaccess. > > No it's not a lot of tables joined, it's just a whole lot of > calculations that cognos does not do internally but sends them over to > database and apparently the version 8.4 …
Re: Mach11 questions
I not sure if this help to clarify any doubt... What the manual says (the last paragraph): http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_2012.htm Isolation Levels for Secondary Data Replication Servers If the UPDATABLE_SECONDARY configurat…
functional index - create with parallel sort
Cesar, Are you using PDQ in which level? How are the Parallel Database Query (PDQ) Configuration Parameters in your instance? You should use PSORT_NPROCS and PDQ >1, actually. In my environment to create indexes in parallel I usually use PDQ Priority High, but the MAX_PDQPRIORI…
PDQ and Growth Edition
I'm doing an upgrade from 9.40 to 11.5. For reasons unrelated to the upgrade process I want to buiold a new 11.5 server and dbexport/dbimport from 9 to 11.5 This is taking much longer than I planned for because I'm using IDS 11.5 Growth Edition, which disables PDQ, so the index…
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…
Possible optimizer problem?
The change in pagesize will have a large impact on the optimizer. Just to highlight a few items: 1. Sequential scans is I/O (or page) based. A scan of the same size data will take half the I/O operations. And the optimizer is well aware of this fact. 2. cluster, a value the opt…
Re: ERROR 770 on IDS 11.50 FC6
Hi Omar, I've had the same error, only on version 10, the cause could be completely different in your case. Here the cause was a stored procedure created with PDQ > 0 set in the environment. When the stored proc was dropped and recreated with PDQ = 0, the problem disappeared. H…
Re: Looking for Expert Opinion regarding Informix SE 7.x history and its future, if any
You asked for: A short paper from someone who has intimate knowledge about Informix history since it was sold to IBM. The focus is on Informix SE 7.x, nothing else, since we have no budget for IDS. We need impartial opinion about the demise of SE 7, the failed attempt to port it…
Doubt in Update statistics, resolution and confide
Hi Celso, Just for better understand , what update exactly have the performance problem? med ,high or both? what values of resolution/confidence used? The PDQ make all differ with update statistics high, use more memory and they intend to use light scan and avoid the indexes...…
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…
Seeing one oninit working hard while others are no
Where is the capture parameter? I really only see the EXPLAIN_STAT enable. Is that it? If I turn it off, will that possibly improve anything? # SQL Statement Cache Configuration Parameters ################################################################### # STMT_CACHE - Control…
RE: temporary dbspace usage
>I open pdq already. >set pdqpriority 100; >select ....; > >in the onconfig file >the parameters are setted >and ds total memory set 4G > >onstat -g mgm monitor the pdq use normally. Did you set environment PSORT_NPROCS? If not, try setting it to 3 or to 4. HTH, Paul M.…
temporary dbspace usage
I open pdq already. set pdqpriority 100; select ....; in the onconfig file the parameters are setted and ds total memory set 4G onstat -g mgm monitor the pdq use normally.…
Re: How to estimate query cost before execution
Turn PDQ on You can then limit the resources available to PDQ queries and even I think limit the number of PDQ queries that can run. This will mean that other queries and still run and your slow, complex queries will take even longer. I say bring back SCAFS!…
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…
On SP's performance (kinda weird)
Omar Mu�oz wrote: > Hi. > > I catched a SP whichs take 10 seconds in perform. I checked that SQL on it was correctly written, used indexes, and so on (anyway, it's not a complex one, it uses a primary key and only returns one record), but I realized that central SQL takes a…
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…
fragmented table and pdq
In testing we want to play with testing of setting pdq to 5 across the board, we have always run pdq at - except when indexing or updating stats. What we found when pdq is set this sql does not stop at the first 5000 records. IDS is 11.5.FC3 Os is Solaris 10 set pdqpriority 5;…
Question about sysindexes.clust
Have you considered running PDQ with this process? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com…
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…
Meaning of DS_NONPDQ_QUERY_MEM
Dear All.... http://publib.boulder.ibm.com/infocenter/idshelp/v111/index.jsp I refered to this document of IDS 11.1 , and found the following statements: Use the DS_NONPDQ_QUERY_MEM configuration parameter to increase the amount of memory that is a available for a query that is…
PDQ and HPL
I just performed an HPL unload an re-load ona fairly meaty table. It took about 3 hours to re-enabled the indexes. Although I set PDQPRIORITY in the session that started the onpload, it didn't use PDQ. I then dropped and re-created the indexes again, this time through dbaccess…
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.…
Informix sql Error 211 + Isam error 101
Hi, I'd suggest to check: - with oncheck -cc and -cDI that there's not any corruption / inconsistence in the catalog or in the table that you want to access. - if there is any open file descriptors limit that was reached at the operating system level or at the session level. I…
RE: Functional Indexes?
Ian Michael Gumby wrote: > It would be nice to see an example of a DB2 inline trigger. Well, I try very hard to be nice. It's a challenge sometimes: Here is a trivial example: CREATE TABLE T(id INT); CREATE TRIGGER trg BEFORE INSERT ON T REFERENCING NEW AS N FOR EACH ROW WHEN (E…
DW query tuning - explain on
OK - I've tried the queries with PDQ set to 0 & 5 in dbaccess, run times are almost exactly the same. One underlying question I have, does this version, of IDS 10.00.FC3X6 (non-XPS) Informix support star transformation?…
how to reduce the PDQ ready queries
Hi, I use PDQ in my application, then use onstat -g mgm monitor the pdq state, Queries Average # Maximum # Total # -------------- --------------- --------- ------- Active 3.5 +- 4.4 18 172 Ready 14.5 +- 4.8 21 64 the ready queries always retain around 14, How can i reduce read…
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…
Re: IDS Features - MAX_PDQPRIORITY
On Dec 27, 4:36 pm, Dave <In4Mix...@gmail.com> wrote: > Hello, > > Aside from fragment elimination, are there any other features that are > enabled by IDS that result from setting MAX_PDQPRIORITY to 1 (or > greater)?? > > Any help would be greatly appreciated. At PDQPRIORITY 1 o…
Migrating data between Informix Platforms without
I've had similar issues with Brio reports. One possible fix is to force the report generation to use PDQ. In this way, the BUFFERS are not flushed and you get to use lightscan buffers. I've been able to up the RA_THRESHOLD/RA_PAGES significantly with no ill effects to OLTP and im…
Re: Has any Informix DBA had to do the following?
On Oct 29, 1:40 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Oct 29, 9:45 am, "Ian Michael Gumby" <im_gu...@hotmail.com> wrote: > > > Here's an interesting situation. > > > Had a long running query that seemed to go no where. Like it got lost. > > Usually when this happen…
query plan from session cache
Hi, is it possible to retrieve the query plan(s) for an already running SQL (or for SQLs from the session cache)? The problem: When I run the 'slow' SQL (with set explain) it runs fast and well optimized - but the application runs the same SQL much slower. Regards, Andreas Kut…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: THREE EXCELLENT QA ANALYST'S AVAILABLE
Cesar Cruz said: > I hope some day some people could understand the meaning of IIUG In the meantime, there's always CUNT. And you, Joel, are definitely one. > ----- Mensaje original ---- > De: joel <joel.recruter@gmail.com> > Para: informix-list@iiug.org > Enviado: martes, 29 d…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
Re: Informix Marketing Brainstorming Forum
TBP wrote: > Although a Single CPU VP does limit many (all?) of the PDQ / > fragmentation side of things. I'm not sure that it does. You can still get fragment elimination and you can still run queries with multiple threads. Regards, Ben.…
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: -211 file not open
I wanted to post back an important note on how this issue was resolved for us. If we turned off the PDQ (Parallel Database Query) option we no longer received a -211 SQLCODE with -101 ISAM. Don't know why this is the case. Is there perhaps a defect in the engine in how it tracks …
PDQ on a single processor system
Hi, can sombody tell me if I can benefit from PDQ on single processor system ? According Informix performance guide, multiple treads are started when when PDQ is used, but can i benefit from this wif one physical processor is available only ? I am afraid the extra work to manag…
Informix dbimport blob data slow
> I don't think dbimport uses PDQ so you might want to consider using the > myimport utility available from the IIUG repository which loads in > parallel. I don't think this is exactly the same as PDQ but it may help > speed things up. I think it does for import builds. However…
Re: SAN and dbspace layout.
And don't forget that one day you might like to use PDQ - fragmented tables across multiple dbspaces. Think multiple LUN's, HBA's and how you route your switches if you ever go down this path.…
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…
onperf.....who uses it?
I never use onperf but xtree is packaged separately (xtree) and I use it all the time. Version 10 does have onstat -g pqs that has the same information in a character format. Also use set explain statistics with onstat -g pqs. Xtree stand alone is much quicker than running it fro…
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…
IDS 10.0 performance on RedHat
> These are based on multipe runs of a dbimport, and of populating a single > large-ish table then building a couple of indexes thereon, utilising PDQ, > thereafter. how many table fragments? why use dbimport and not HPL or similar to load the table? With dbimport you are likel…
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?…
IDS - Running temp dbspaces on RAMDISK
Another try could be to increase DS_NONPDQ_QUERY_MEM significatntly: Must be >= 128 and <= 0.25 * DS_TOTAL_MEMORY DS_NONPDQ_QUERY_MEM 65536 # Non PDQ query memory (Kbytes) $ onmode -wm DS_NONPDQ_QUERY_MEM=65536 (IDS 10) Could decrease IO into temp spaces.…
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/…
dostats
Is there a way to have dostats update specific procedures? I would like to set PDQ on several, but not all. Thanks…
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!…
Re: IDS Feature Request List (including potential new requests).
Serge Said >The standard example that I keep hearing is a hand woven scrollable >cursor where I want to walk resubmit the same query over and over offset >my the pagesize (#lines on by screen). >My answer to that is typically to use a scrollable cursor to begin with. We can't us…
SQL statement performance bad in 4gl, flies in isq
On 1/11/06, ifxmaillist.... <ifxmaillist@quanta.co.nz> wrote: > If the sql runs fine in isql, then it cannot be the sql or the database. I > have never seen an sql do anything different in an application to what it > does in isql / dbaccess. It will be something else in the appli…
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: Two table join
If you think I or anyone else is wrong, don't be shy - continue the thread publicly, I promise not to be upset. All of us learn that way. Certainly I have been mistaken in the past and will continue to make errors in the future. You might also try the comp.database.informix group…
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…
Join threads
Hi all, When i set PDQ priority on the session and run a query involving joins on table,how can i know whether the server is using the parallel join strategy or not. what is the utility to monitor the parallel joins. Bye.…
Informix Dynamic Server information Centre
Great new utility just posted under IDS 10 on the docs site has uses for other products and versions than just IDS 10 so take a look even if you are not using 10 yet!! http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp…
Cannot find message file. Check INFORMIXDIR and DBLANG.
im trying to run the oninit -i in the command prompt when the message appear... we installed... IBM Informix Dynamic Server 9.40 IBM INFORMIX-4GL Rapid Development System Version 7.32.UC2 IBM INFORMIX-4GL Version 7.32.UC2 set up sqlhosts, services, onconfig, path... but when tr…
question about pdq memory
If you have a certain amount of memory configured in the DS_TOTAL_MEMORY parameter in onconfig, does that mean your engine reserves that memory only for pdq queries where you have pdqpriority set ? In other words, if you are not running any queries with pdqpriority set, is that m…
Re: HPL and PDQ
"Tisha" <loden@networkip.net> wrote in message news:8085cdee.0408240701.35b83299@posting.google.com... > Neil, > > Did you get this to work with onpload in 9.4? I have used HPL alot in > past releases and never gotten it to use the pdq settings for an index > build. My work aro…
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: HPL and PDQ
Neil, Did you get this to work with onpload in 9.4? I have used HPL alot in past releases and never gotten it to use the pdq settings for an index build. My work around has always been to build the table with no indexes, load the data using hpl, and then build the indexes in a…
Re: HPL and PDQ
--0__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25 Content-type: multipart/alternative; Boundary="1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25" --1__=08BBE466DFCDAC258f9e8a93df938690918c08BBE466DFCDAC25 Content-type: text/plain; charset=US-ASCII Content-tran…
Re: HPL and PDQ
> Hi Neil, > > How are u running the onpload. Are you using ipload or onpladm? > If that is the case then we might not be passing these environment > varaibles to onpload. onpladm.…
Re: HPL and PDQ
--0__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: multipart/alternative; Boundary="1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462" --1__=08BBE466DF93E4628f9e8a93df938690918c08BBE466DF93E462 Content-type: text/plain; charset=US-ASCII Content-tran…
HPL and PDQ
IDS 9.40FC3W2 on HP-UX11.11 I'm running an onpload (HPL) run job which is loading 35m rows to a table then enabling the indexes. The index "enable", which I understand to be an ordinary build in a different jacket, is taking much longer than I'd expect. I can see from the marve…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: how release threads?
make sure when you update statistics for procedure you set pdq to 0...the stored procedures that help facilitatemay be mutltithreading if you do not and the thread count will increase until evetually you get an exception error which might crash the engine.…
Re: Dropped users on AIX 5.1
Hi CKGeier@nwc.edu, That almost sounds like an aging issue. In the a simlilar vein, I had a smililar problem that took me forever to figure out. The DBA here before me had an update statistics script that ran at 100 pdq and within that script he had set "update statistics for pro…
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…
Re: PDQ not used ?
Thanks a lot for your help ! I found my problem. I mixed some things up... I set pdqpriority=100 in my sqlstatement (embarassed...).. WinSql didn't give me an error on it. But Right now, it works great ! Thanks a lot ! Bjorn "Bjorn De Waele" <bjornREMTHIS@pandora.Be> wrote …
Re: PDQ not used ?
Hi Bjorn. Try the following. % dbaccessdemo7 Execute the following sql via dbaccess set pdqpriority 100; select * from customer; Another terminal onstat -g mgm e.g) Here is a results of my test. [tsutoo@bygzam ~]tsutoo731ud7% onstat -g mgm Informix Dynamic Server Version 7.3…
RE: PDQ not used ?
Hi Bjorn. Make sure your parameter of onconfig file. DS_MAX_QUERIES # Maximum number of decision support queries DS_TOTAL_MEMORY # Decision support memory (Kbytes) If the avobe parameter is space, probably PDQ will not run. Specify DS_MAX_QUERI…
PDQ not used ?
Hello everybody, here's our Informix newbie again :) I'm just new in the company and nobody is a real informix specialist in our IT-team, so I try to pull it to me. I know that I should follow a course but we have no time for that cause the new server need to be live in 3 week…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: PDQ memory / non-PDQ memory
sumGirl said: > This is likely obvious, so feel free to treat me like a know-nothing > bimbo. If I must. :o) Actually, I can't. There's no joy in it when it gets offered up on a plate like this. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa g…
RE: PDQ memory / non-PDQ memory
Formally, PDQ memory is not 'reserved' when PDQ is not running. It is accessible to other sessions .... This is theory. In fact, this memory can't be allocated to memory-hungry subsystems, such as buffer cache. If other sessions allocate a lot of memory from the same pool (V se…
PDQ memory / non-PDQ memory
This is likely obvious, so feel free to treat me like a know-nothing bimbo. If I dedicate X amount of memory to informix and set Y available to PDQ - is Y amount available to non-PDQ processes when not in use? Or is it always reserved and sitting around doing nothing when I am no…
PDQ priority
We have an application written in Java (server side JBOSS application server) and would like to give certain users a higher priority. I don't want to set it via the environment variable since that would raise the priority for everyone. It it possible to set the PDQPRIORITY via ja…
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…
set explain analysis
post the query plan and someone will take a look Tina Moriarty wrote: > > I've recently learned how to use set explain to analyze sql > statements. Now I need to know what to do with the information. I > was able to greatly improve one process by adding indexes to the > tables…
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…
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…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
Re: PDQ and 940
Paul, I am using the same verision 9.40 fc2, Solaris 2.8 and do not see this. Rich "Paul Watson" <paul@oninit.com> wrote in message news:3FCBA46A.2F42895@oninit.com... > Sun Solaris 2.8 64bit > 9.40.FC1/2 > > I can't turn off PDQ unless it's done in the onconfig. Queries > t…
PDQ and 940
Sun Solaris 2.8 64bit 9.40.FC1/2 I can't turn off PDQ unless it's done in the onconfig. Queries that were running under 9.30 now take forever as long and spawn 20+ threads Anybody else seen this -- Paul Watson # Oninit Ltd # Growing old is mandatory Te…
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?…
Workgroup Edition or Enterprise
Olmedo Monteverde wrote: > Nope. Between other features, PDQ is not available. Actually, I think it's more subtle than that - Fragmented tables are not available, but PDQ is. Fragmented tables are the premier beneficiary of PDQ with large queries, however PDQ does have other us…
Re: Informix limitations, should we be using Oracle?
I read all you post and it was very interesting... I have only 2 thing to say and have in count that I don't know anything about XPS: 1. In IDS 9.x, you can't select a NULL, you can use it in an UPDATE, INSERT or DELETE. You can workaround this by creating an sp sp_genull() who…
re: Informix limitations, should we be using Oracle?
I must have been offline during this discussion. I ran across it today looking for something else. Although late, I will add my .02. (embedded). The next time one of these come around and I'm not visible - please alert me to it? cheers j. > > Hi, > > We are trying to implem…
Re: dynamic SPs
Kristofer Andersson wrote: > Doesn't anyone have an opinion on this? Is it safe or do I risk > running into bottlenecks (such as locks on the system tables that hold > SPs) if I repeatedly create, execute and immediately drop stored > procedures? You do run into some risks of th…
Re: PDQ
Attachment is missing!!! Gorazd "Rajib Sarkar" <rsarkar@us.ibm.com> wrote in message news:bn8r6t$2v2$1@terabinaries.xmission.com... > > Actually, Obnoxio is kind of right ..:-) Although this parameter is not > new, this parameter has been "upgraded" to accomodate a) More memory…
Re: PDQ
On Wed, 22 Oct 2003 19:14:12 -0400, David E. Grove wrote: Yes! This is why my dostats utility explicitely sets PDQPRIORITY to zero (or a value specified with the -P option) for stored procedure updates regardless of the PDQPRIORITY value in the user's environment (or specified …
Re: PDQ
On Thu, 23 Oct 2003 04:50:06 -0400, Mark D. Stock wrote: > Obnoxio The Clown wrote: > >> David E. Grove wrote: >> >>>>makes a big difference to stuff like index creation and update stats. >>> >>>We learned to be careful with PDQ and UPDATE STATISTICS. >> >> There is a new enviro…
Re: PDQ
Mark D. Stock wrote: > Anyway, thanks for the update. In what version was this parameter > "upgraded"? I think 7.31xC6, somewhere in the 9.30 stream (xC4?) and 9.40. Not too sure of 9.30. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"…
RE: PDQ
Rajib Sarkar [mailto:rsarkar@us.ibm.com] > > Actually, Obnoxio is kind of right ..:-) "Kind of right"? "Kind of right"? Cheeky! :o) -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"…
Re: PDQ
Mark D. Stock wrote: > > Obnoxio The Clown wrote: > >> David E. Grove wrote: >> >>>>makes a big difference to stuff like index creation and update stats. >>> >>>We learned to be careful with PDQ and UPDATE STATISTICS. >> >> There is a new environment variable (DBUPSPACE?) which,…
Re: PDQ
Rajib Sarkar wrote: > > Actually, Obnoxio is kind of right ..:-) Although this parameter is not > new, this parameter has been "upgraded" to accomodate a) More memory for > sorting b) To print out the progress of update stats (explain plan). It's lucky I added the proviso, "Unl…
RE: PDQ
Great paper ! a few months ago i got an error when running update statistics for a very big table : "Not enough space for sorting" ... or something like that . My IDS Version is 7.31.UD1 How can I avoid this error? By Using DBUPSPACE environment Variable ? Thanks in advance …
Re: PDQ
Obnoxio The Clown wrote: > David E. Grove wrote: > >>>makes a big difference to stuff like index creation and update stats. >> >>We learned to be careful with PDQ and UPDATE STATISTICS. > > There is a new environment variable (DBUPSPACE?) which, when used with PDQ > will allocat…
Re: PDQ
> makes a big difference to stuff like index creation and update stats. We learned to be careful with PDQ and UPDATE STATISTICS. In a past job, I had been working mainly with a data warehouse. In that environment, I made constant and effective use of PDQ, and didn't think anyt…
PDQ
Hi guys, since the price-differences betwen IDS 9.4 and IDS 9.4 WE are not marginal, I wondered, whether it's worth to buy a IDS 9.4 in order to be able to use PDQ. May be it's better, to invest the difference-amount in better hardware. Does anyone of you have expieriences in u…
Informix Upgrade - Some general questions
1. What version of Informix can you not reference rowid by "rowid"? What release would/could it become an issue. We strive to maintain backward compatibility in our products in order to ensure ease of upgrade/reversion. Rowid is supported in IDS 9.40 and there are no plans to el…
Re: Product Defect Query no longer available????
On Tue, 2 Sep 2003 09:19:18 -0500, kernoal.stephens@autozone.com wrote: > >https://www-927.ibm.com/software/data/informix/support/pdq/ > >PDQ alive and well! > > Verified . . . .…
ALTER FRAGMENT goes walkabout
Neil Truby wrote: > [stuff] hmmm - is your engine setup in such a way as to encourage PDQ index builds? If so, perhaps the ALTER FRAGMENT is not triggering the much faster PDQ builds?…
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…
RE: PDQ Woes
PDQPRIORITY sets the amount of PDQ resources that will be used by a query. When you set it to 75 it means that it will use 75 percent of PDQ resources (Memory, Threads, etc.). When you run onstat -u you saw multiple threads not multiple sessions. If you run onstat -g sql <sid> fo…
PDQ Woes
OK, so a user job has been running now (we joke not), 2 days on one little select, ok its lots of data. So I kill it, my box was grinding. I run it with MAX PDQ at 10, it crawls, my box crawls. I set PDQPRIORITY=75 (I know, but I'm the admin and no-ones gonna …
Re: FW: PDQ
Dirk Moolman wrote: > > I have 5 CPU VPs, so this shouldn't be the problem. I've been meaning to > read a bit more about PDQ - I've just been a bit busy. > > I touched a little on PDQ in 7.30 I'm now working with 9.21FC1 and have > to just touch up on PDQ again. I did set th…
RE: PDQ
While we're on the topic. XPS 8.31 has implicit PDQPRIORITY. In other words the optimizer can decide what to allocate for your query. cheers j. > -----Original Message----- > From: Dirk Moolman [mailto:dirkm@reach.co.za] > Sent: Wednesday, February 07, 2001 7:06 AM > To: info…
RE: PDQ
PDQ gates on CPU VPs as well? Something new. cheers j. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@erols.com] > Sent: Wednesday, February 07, 2001 3:20 AM > To: informix-list@iiug.org > Subject: Re: PDQ > > > How many CPU VPs do you have? PDQPRIORITY 50 im…
FW: PDQ
I have 5 CPU VPs, so this shouldn't be the problem. I've been meaning to read a bit more about PDQ - I've just been a bit busy. I touched a little on PDQ in 7.30 I'm now working with 9.21FC1 and have to just touch up on PDQ again. I did set the PDQ parameters in the onconfi…
RE: PDQ
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_01C09058.C3BD1BEA Content-Type: text/plain; charset="iso-8859-1" PDQ is a resource. If there is insufficient of that …
FW: PDQ
This is a multi-part message in MIME format. ------=_NextPart_000_0060_01C08E29.BB8B3640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I think it has to do with the type of query I run, that some queries use PDQ and others not ........ Dirk -…
PDQ
This is a multi-part message in MIME format. ------=_NextPart_000_005A_01C08E0D.B35BA2A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I just ran into something very strange. I am running to queries on my system (doing my weekly maintenanc…
RE: Informix, SQL Server or Oracle
Have you ever worked with O_~!@#$. OPS full install > 2.5 Gig with more than 45000 files. {Excluding data or install CD files}. Just to get backup working, what a mission. No easy ontape, but use scripts, RMAN, Legato or just leave it and start searching for a Informix job. Can…
Informix, SQL Server or Oracle
Having implemented a GIS both on Informix and Oracle, I would choose Informix every time. The ease of configuration, loading data and the speed of GIS queries, Informix won every time. We used the GIS for mapping and 3D modelling of our ore bodies. Cheers Hans Gigi M John <gi…
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…
Retrieving product name
Hi all, Is their a system table somewhere on an informix server that stores the product name. For example 'Select owner from systables where tabname = � VERSION� will return the version of the server. I would like to be able to tell if a server is a Universal server or a Dynamic …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Re: How to search for a string in a TEXT field
Hi, :-( SELECT name, REPLACE(text,"ZNOTREADY","found") AS your_output FROM tablewithtextfield; Blobs are not allowed in this expression. I use Informix Dynamic Server Version 7.31.UC2A…
People Soft and Informix 7.2
Informix DSA 7.2 Platform: Sun SPARC SunOS 5.5.1 4 CPUs Has anyone found it advantages to turn PDQ on with PeopleSoft version 7.01? TIA Cheryl L. Kendricks Sr. Database Analyst H.E. Butts Grocery San Antonio, Texas…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Re: DS_MAX_QUERIES & DS_TOTAL _MEMORY parameter
These parameters are used by Informix to determine the amount of resource to allocate for a Parallel Database Query (PDQ) DS_MAX_QUERIES - this specifies the maximum number of PDQ that can be execute at any given time. This parameter is quite subjective based on the number of …
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
Re: Informix 7.3 on Linux -25580 Error
Tomas sayeth: > > > >Yes I know, I was talking about the _new_ datatypes (in 9.2) not opaque > and distinct... > > > >(If you don't understand my english we can turn to norwegian instead) To which his Clownship wondered: > > > Which data types? At which point Tomas clarified:…
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…
PDQ PRIORITY
Hi All, I have IDS 7.3 under Win NT., In the onconfig file I have set the max_pdqpriority=100 and also I have set the environment variable pdqpriority=100, when I see onstat -g mgm it still shows me the max_pdqpriority=0. Can anybody pls.tell me the reason or help me out ? Th…
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…
PDQ PRIORITY
Hi All, I have IDS 7.3 under Win NT., In the onconfig file I have set the max_pdqpriority=100 and also I have set the environment variable pdqpriority=100, when I see onstat -g mgm it still shows me the max_pdqpriority=0. Can anybody pls.tell me the reason or help me out ? Th…
PDQ on ANSI Databases
Hi All, I've been trying to execute a parallel database query (PDQ) on an ANSI database. But everytime I run onstat -g mgm it doesn't register it as a PDQ and no resources were allocated. I tried doing this on a non-ANSI database and they were no problems. BTW, I am using IDS …
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…
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…
Query in Indexes...
There usually isn't a major problem disabling indexes. Enabling them can be difficult if queries against the table are left unhindered, because they now will run much slower than normal preventing the enable sql from getting the exclusive lock on that table that it needs. The ob…
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…
PDQ question
We have a fragmented table (round robin) in two dbspaces with two detached indexes in a third dbspace. All dbspaces are on different disks. PDQ priority is set to 100, the machine has two processors Selecting all rows (sequential scan) results in 3 Informix threads and evenly d…
Washington Area Informix User Group Newsletter Archive Update
Washington Area Informix User Group Newsletter I have just finished converting the last year of our newsletters to html and they are available at http://www.iiug.org/~waiug/ This is the place to find the news about our past meetings, plans, links to other Informix related mater…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
ODBC and PDQ
I'm hoping one of you can help me. I want to set up ODBC data sources on NT and 95 client machines such that PDQ is set or not set on a per data source basis. For example, I've got data source X and data source Y. Data source X has PDQPRIORITY unset. Data source Y has PDQPRIO…
informix dynamic server on linux help
Hi all, I am an informix newbie, and i have problems running it on redhat linux 6.0. The installation went just fine, but now when i start dbaccess and try to create a new database i get this error message: 25584: Network driver can not access server program /opt/informix/lib/sq…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
Re: IDS PDQ
From: sfcawley <sfcawley@interaccess.com> > >Is PDQ an option that has to be turned on? Is it an option that would be >recommended for an OLTP application (or is it DSS specific functionality)? > >I would like to ensure optimum performance from my production server and >am not s…
IDS PDQ
Is PDQ an option that has to be turned on? Is it an option that would be recommended for an OLTP application (or is it DSS specific functionality)? I would like to ensure optimum performance from my production server and am not sure if PDQ is appropriate in an OLTP environment.…
PDQ
Is PDQ an option that has to be turned on? Is it an option that would be recommended for an OLTP application (or is it DSS specific functionality)? I would like to ensure optimum performance from my production server and am not sure if PDQ is appropriate in an OLTP environment.…
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…
SPL Workstation - new IDE for Informix
SPL Workstation is a professional integrated development environment for Informix server-side applications. It provides Informix back-end developers with easy-to-use powerful tools to develop, debug, analyze and tune a performance of stored procedures, triggers and SQL statements…
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…
PDQ
Can anyone offer any rough guidelines for using PDQ? Mainly, what percentage of SHM_VIRT_SIZE should be allocated to DS_TOTAL_MEMORY for DSS? Thanks, Andrew Ford Simplified Telesys 5000 Plaza on the Lake Suite 170 Austin, TX 78746 United States (512) 425-9767…
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…
How to set pdq in a 4gl? (no manual and online manual doesn't come up!)
how to set pdq in a 4gl? (no manual and online manual doesn't come up!)…
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.…
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…
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…
PDQ & WorkGroup Server 7.3 UC5
Does anyone know if PDQ works in Workgroup server? I cant seem to get more than one thread for a query which uses an index that is fragmented over 3 dbspaces. I have read that PDQ will only generate 1 thread on early versions of WG, but thought that this had changed in 7.3. 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.…
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…
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…
Re: PDQ
Art, I have PSORT_DBTEMP set to /tmp and that is implemented on physical memory, mounted on swap space.Make it, in this case sense to create mutiple directories, /tmp/psort1, /tmp/psort2,.. and set PSORT_DBTEMP to them. I create four indexes in parallel. Does it speeds up to gi…
RE: PDQ
You want to be careful about dumping huge amounts of data down to /tmp if it is really a memory filesystem. Remember they are major difference between a tmpfs and ufs/vxfs etc. I can bring our E10000 12CPU domain to standstill when generating .5GB file in /tmp Paul Watson …
PDQ
I noticed a performance decrease instead of a performance increase when using PDQ with creating indexes. The create indexes are done one/with: * Informix 7.23.UC6 on Solaria 2.5.1. * System: SUN E4000 with 6 CPU's and 5.3 GB internal memory. * Informix has four CPU, NO…
RESIDENT and PDQ
Can anyone explain what resident = 1 means and what the advantage of setting it is ? More performance ??? What effect does the PDQ-Parameters have ? GREETINGS OLAF…
RE: PDQ
PDQ makes a BIG difference on my sysytems when building indexes. > ---------- > From: Sadagopan, Sathish, CFCTR[SMTP:sadagop0458@att.com] > Sent: Monday, March 22, 1999 10:06 AM > To: informix-list@iiug.org > Subject: RE: PDQ > > The number of scan threads to be used durin…
Re: Re[2]: PDQ
> PDQ has nothing to do with index creation. You can not optimize these kind > of tasks with PDQ resources. Performance degration during index creation > is a consequence of allacation of PDQ resources that is supposed to used > by that process. Actually, PDQ has everything to d…
RE: PDQ
The number of scan threads to be used during the index build and the amount of memory used are affected by PDQ parameters,Aren't they ? Sathish Sadagopan -----Original Message----- From: Yerli, Gursoy [mailto:gursoy.yerli@tmssc.brooks.af.mil] Sent: Monday, March 22, 1999 9:53 A…
RE: PDQ
Albert, PDQ has nothing to do with index creation. You can not optimize these kind of tasks with PDQ resources. Performance degration during index creation is a consequence of allacation of PDQ resources that is supposed to used by that process. You can de-allocate PDQ resource…
Re: PDQ
From: wisse <wisse@kabelfoon.nl> > >I noticed a performance decrease instead of a performance increase when >using PDQ with creating indexes. > >The create indexes are done one/with: > > * Informix 7.23.UC6 on Solaria 2.5.1. > * System: SUN E4000 with 6 CPU's and 5.3 GB inter…
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…
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?…
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 …
PDQ questions
Hi all. Some questions about de PQD. I have the above producs: Informix ODS Ver 7.24.UC2-1 Informix I4GL Ver 6.05.UD2 This products are running on some Sun platforms with Solaris 2.4 The questions are: a) The ODS Administration manual (Ver 7.2) say in chapter 18: "On…
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: OnBar - Legato
Daniel: Below is a write-up my co-worker did on some quick and usefull steps in getting onbar/HDR/Legato running. I hope they help. ---jmiller John Miller -------------------------------------------------------------------------------- Steps Required to Use ONBAR/Legato back…
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: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
Job Posting in Everett, WA
Everett Public Schools-Human Resources-3715 Oakes Avenue Everett, WA 98201-(425) 388-4710 POSITION JOB #: 98-52-DATABASE ADMINISTRATOR [Informix] -INFORMATION SYSTEMS AND TECHNOLOGY REPORTING RELATIONSHIP Reports to the Director of Information Systems and Technology SALARY $55…
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: 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…
People Soft and Informix 7.2
Informix DSA 7.2 Platform: Sun SPARC SunOS 5.5.1 4 CPUs Has anyone found it advantages to turn PDQ on with PeopleSoft version 7.01? TIA Cheryl L. Kendricks Sr. Database Analyst H.E. Butts Grocery San Antonio, Texas…
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 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: +…
Informix PDQ & PeopSoft
We are running peopleSoft Finanacials and Informix Dynamic Server 7.2x. In IDS 7.2x, you can no longer turn on PDQ at the instance level, so we are trying to turn on PDQ at the environment level for our batched reporting jobs. Since all of our PeopleSoft users are untimate…
PRESS: Informix in the News
List of Informix related articles. Format: PUBLICATION "Article Name" Summary of Article [Date, Location in Publication, Author] Informix in the News --------------------------------- (05/09/98) INFORMATIONWEEK "Informix Posts First-Quarter Profit" After suffering a net loss l…
Informix PDQ & PeoplSoft Financials
I�m an Informix DBA, and we are running PeopSoft Financials 6.x and Informix Dynamic Server 7.2. I would like to turn on Informix�s PDQ feature to speed up some of our nightly batch jobs, but to do so, I need to set the PDQPRIORITY environment variable. Since all of our users…
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…
Metacube & PDQ
When a user logs into Metacube several queries are run to verify a valid user and download table and filter definitions. Because of our configuration file PDQPRIORITY setting (90) these queries are considered under the domain of the Memory Grant Manager (MGM). This is ok except…
How can I read the header tape of the archive created by ontape?
I have Informix Dynamic Server 7.23.UC1. I would like know the tape header structure created by ontape.…
Re: Here comes the Database "TREASURE CHEST"
In article <34EB207F.398F@frm.com>, neutrino@frm.com writes: >... >Points why you should consider Linux as database server: > >1. LINUX was used for creating the mega-hit movie "TITANIC"!! > Linux has a installed base of 14 Million in US alone. How does a great workstation for…
Re: Performance question
I apologize for not sending the onconfig parameters. SHMTOTAL 768000 SHMVIRTSIZE 348000 DS_TOTAL_MEMORY 614000 DS_MAX_SCANS 1000 MAX_PDQPRIORITY 60 DS_MAX_QUERIES 8 OPTCOMPIND 2 Willie L. Meeks <wmeeks@harrahs.com> wrote in article <01bcefc3$7f535480$57011814@willie>... > I ha…
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: Stored Procedures and querries.
From "Incorporating Stored Procedures and Triggers into Your Informix Databases Training Manual" Version 01-95 Page 6-128: When a stored procedure is created all optimization will be attempted at that time. If the tables cannot be examined at compile time (they may not exist o…
Re: Query to find indexes for a specific table
Jerry Gitomer wrote: > > Is there a query I can set up that will permit our computer > operators to determine if an index exits on a table? > I know that I can go into DBACCESS and see the indexes for > a table, but I don't plan to on premises when the third shift > operator sta…
Re: Performance question
Try increasing the DS_TOTAL_MEMORY to a bigger number , depending on your queries , assign 50 or 100 MB and see the difference. Willie L. Meeks wrote in message <01bcefc3$7f535480$57011814@willie>... >I have a question related to PDQ. Can any one explain to me why when you >run…
Re: Performance question
Willie L. Meeks wrote: > > I have a question related to PDQ. Can any one explain to me why when you > run a query with PDQ enabled it appears that your cpu vp's don't work as > hard. PDQ will only buy you much of anything if you have your data fragmented. Have you taken a look…
Performance question
I have a question related to PDQ. Can any one explain to me why when you run a query with PDQ enabled it appears that your cpu vp's don't work as hard. It appears to me from the results I have observed from my DSS system that if I excute 50 without PDQ enabled the box works har…
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…
PDQ Not working
Greatings, I just received DSA 7.22.UC2 on HP-UX 10.20, and am unable to get it to satisfy a Query using PDQ. When I run the same query with 7.11, it works fine. The output of 'onstat -g mgm' shows that no querys have run with PDQ on the 7.22 engine. PDQPRIORITY is set at 30,…
Washington Area Informix User Group Newsletters - Online
Washington Area Informix User Group Newsletters Online at: www.iiug.org/~waiug/ Updated: 07/16/1997 - Please Note new web site ---------------------------------------------- We have converted our newsletters to web documents; and they are available for on-li…
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: Changing OnLine mode during restore...
In article <5otqpq$lj2@cssun.mathcs.emory.edu>, Richard Thomas <richardt@TheMusicStore.co.uk> writes > >...I know, I know, it was an accident, OK!! > >This morning I came in to work and restored OnLine onto our test >machine (a routine operation following a level 0 archive on our…
Re: Help: Reducing Extents
Hi, Chad asked: > I am running a electronic document management system (EDMS) that uses > Informix 7.22 as a back end to manage the documents. The EDMS system > warns me when there are database problems that slow performance. In > this case it warned me that there were too man…
Re: PostgreSQL Version 6.0 RDBMS database... - Its FREE!! ( AND BUGGY )
> PostgreSQL Version 6.0 is free database, complete source code is given > to you and is a VERY POWERFUL Relational Database System compliant > with ANSI SQL92 and SQL89 for very LARGE ENTERPRISE with VAST diverse > hardware platforms and Operating systems. Since it is free even …
Informix and PDQ
( still trying to post to Usenet after all these weeks . . .) Hopefully, this message will get through . . . I am the DBA of a small Informix shop in Atlanta, GA. We have been operational under Informix 7.13.UC1 for well over a year. The system appears to be tuned well. I wou…
Re: Online V7 and Parallel Queries
> > Is it true that PDQ, parallel queries in OnLine V7.x will use both > primary chunks and mirror chunks to retrieve data concurrently when > performing a query expected to return large volumes of data??? > It is true Michael Strother…
Re[2]: Multiple Residency / Multiple Processors
Thanks Kate, that gives me a starting point. Some others have expressed interest in what I find, so I'll post my results in a couple of months. ______________________________ Reply Separator _________________________________ Subject: Re: Multiple Residency / Mult…
Re: Multiple Residency / Multiple Processors
Each server sees the CPUs separate from the other configs, SO you can make all three environments (3) CPU machines. PDQ is a separate issue. You may want to turn off PDQ on the large machine, and turn it on for the other two, since PDQ jobs always have a lower priority than non…
Re: out of virtual shared memory
In article <53bidq$gqf@cssun.mathcs.emory.edu>, mailgw!hpx400!Trevisol_R oberto/bbb_cak@srv3-poa.nutecnet.com.br writes >>In article <530p0d$o12@cssun.mathcs.emory.edu>, >>Ralph.Halter@pac.panmail.com writes >>>Hi all! >>> > >>>When I saw this message today I checked with onstat …
Re: Overall unstableness of Informix
In article <322E1112.3F8C@transre.com>, "Juan R. Guzman" <jguzman@transre.com> writes >Michael Silver wrote: >> >> We have had an Informix (7.12.UC2) database running on an HP for over a >> year. We have been utterly disappointed with it. It crashes about >> once-a-week. We ru…
Re: PDQ on 7.12
>} >We are running 712UC2, on a dual proc. HP model K w/512MB RAM. What a >nightmare. PDQ is useless, and OPTCOMPIND is turned off. If we edit a >table structure while someone is in the table, we crash the database, How can you do this when someone is in the table, it should …
RE: PDQ on 7.12
}---------- }From: barryleb@atl.mindspring.com[SMTP:barryleb@atl.mindspring.com] }Sent: Wednesday, August 07, 1996 3:20 PM }To: informix-list@rmy.emory.edu }Subject: Re: PDQ on 7.12 } }TASHKOP@kiwi.co.nz (Peter Tashkoff) wrote: } }>Morning all }>We are considering enabling PD…
PDQ on 7.12
Morning all We are considering enabling PDQ on DSA 7.12/Solaris 2.4. We had previously disabled this facility due to the bug in 7.10 where it didn't handle the lower level threads. So... we are seeking comfort from people that might already be running PDQ enabled over 7.12 or lat…
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…
PDQ on 7.10 single processor engine - FYI
In my zeal to set up PDQ on my single proccess cpu machine to prepare for my multiple processor machine (yeah I got more then one machine to support) in a UNIX AIX 4.1.3 environment. I set the configuration values for PDQ even though I identified to the engine via the MULTIPROCE…
PDQ parameters in OnLine 7.11
Has anybody any experience with using PDQ in OnLine 7.11? I heard that sometimes they can give error -208 when running SQL queries. Moreover, on my platform (ICL Sparc server) the PDQ parameters put through "onmonitor" are incorrectly written in the $ONCONFIG file eg. the value …
Problem using PDQ with Online 7.1
Has anyone had any problems using PDQ and Online 7.1, especially with regard to the PDQ PRIORITY variable being ignored. i.e. all queries passing through the memory grant manager. Thanks in advance Brian Davies Lintel Software Consultancy Ltd, Chester, England.…
Re: Re: Execution Plan: Infx 5.01
On Fri, 19 Jan 1996, Fred BON wrote: > > Hi, > > > > I used to work with database, but I'm new to Informix. Could you tell > > me how to obtain the execution plan of a request ? And, how to update > > the statistics of the index ? To perform this operation, is there another > > m…
PRESS: ARBOR SOFTWARE AND INFORMIX ANNOUNCE PARTNERSHIP...
Thought you might find this interesting. -Dan FOR IMMEDIATE RELEASE Contacts: Marguerite Padovani Arbor Software …
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?…
PRESS v[DINFORMIX ANNOUNCES PLAN FOR NEW OPEN ENTERPRISE GATEWAY TO BE BASED ON TECHNOLOGY FROM INFORMATION BUILDERS
INFORMIX ANNOUNCES PLAN FOR NEW OPEN ENTERPRISE GATEWAY TO BE BASED ON TECHNOLOGY FROM INFORMATION BUILDERS Middleware Solution Will Provide Transparent Data Access to More Than 60 Data Sources and 35 Hardware Platforms MENLO PARK, Calif., (July 27, 1994) -- Informix Software,…
Re: Help: SQL query optimizer
In <anique.732967452@sun-4> anique@sun-4.cs.uct.ac.za (Anique Van der Vlugt) writes: >I am presently involved in a project for a SQL query optimizer for INFORMIX. >Has anyone done any research in this field or knows of anyone who does? I >am also interested in any articles rela…
Informix's 18-Month Plan (OST article)
[The following article appeared in the July 20, 1992, issue of _Open_Systems_Today_. It is posted with permission. WH] ------------------------------------------------------------------------------ Informix Reveals 18-Month Plan By Dan Richman San Jose -- Informix executiv…