Oninit® Archive
Results for “USEOSTIME”
DB taking delay of 15 min to get connected.
Hi Edcel, Thank you for the swift response, could you please let me know where I can find the configuration parameter NS_CACHE ? Thanks, Siddharth…
SBSPACE
Config changes do not replicate. Configuration strictly is per server, so need to changed per server too. On the other hand, what would the secondaries need SBSPACENAME for? Are they updatable? And of course in case of fail-over you want your new primary to be already configured…
Error: INFORMIXDIR /home/informix is not owned by group
Thanks a lot Paul !!!!! I am able to proceed ahead. DB configuration is successful. ------------------------------ Dinesh Gulve ------------------------------…
An accurate timestamp in a stored procedure
Hi Art, I don't think it depends on USEOSTIME, it works well also with USEOSTIME 0. And careful with the microseconds: e.g. a value of 153 first had to be left padded to full six digits 000153 before any decision on how many digits after the dot you're interested in. Also: OUT in…
Informix 15 is out! Well sort of...
Interesting - can we assume identical server configuration? ------------------------------ Andreas Legner Dev Engineer HCL Software ------------------------------…
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 ------------------------------…
OS upgrade and Informix Server
Good point David. Also take copies of kernel configuration for the same reason. ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------…
Table and index defragment
This is an interesting solution, regarding the index propagation features that exist since version 12.10.xC12W1 ... I would like to have some details of the configuration for local ER, because all the attempts I made to configure the local ER so far, none worked .. !! SP --------…
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…
verifying ontape archives with archecker
You're missunderstanding how archecker works. You can't pass your backup file to the standard input of the archecker. You need to set up the archecker configuration file usually located in $INFORMIXDIR /etc/ac_config.std and there you need to configure where the backup file is l…
Connections over SSL
Clients need to have read permission on the files configured in SSL_KEYSTORE_FILE and SSL_KEYSTORE_STH .…
Cross-Server Query permissions
Is there any user mapping configured? Probably that is the reason... Just guessing... HTH Alexandre Marini…
configure sds with raw device
Hello all, I am looking for advice on how to configure Informix SDS. We are using Informix 12.10.FC10 Workgroup and are running on AIX 7.1. No Informix secondary server or cluster software is configured. And DBSPACE consists of raw device, not cook device (file system). I woul…
Problems with archecker restore
By the way, the problem is with AIX machines, i don't have that problem with the same configuration in LINUX…
Bufferpool configuration
Hi informix community, on a SPARC M10-1 Server we have a informix 12.10FC10 instance. Currently this instace use a buffer pool with around 7GB. Now i have the chance to configure the buffers up to 40GB. I would like to use the following configuration of the buffer pool: BUFFER…
BUFFERPOOL Configuration
Hi, I saw an excellent video post from AdvancedDataTools https://www.youtube.com/watch?v=Wgw1bAWl_Hg regarding sample BUFFERPOOL configurations 1.3 GB Memory for Buffer - Linux OLTP System - BUFFERPOOL size=2k,buffers=1500000,lrus=32,lru_min_dirty=10,lru_max_dirty=20 2. 12 GB …
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…
informixhq agent start problem
can you share your agent configuration file…
Configuring backups
Can anyone clarify me on how to configure an hourly backup. Like below: Level 0 on every monday Level 1 on Everyday Level 2 on every 2 hours…
SSC Configuration Parameters
What are the suggestible configurations values for below parameters in the OLTP environment with IDS 12.10 database running in windows server 2012R2 STMT_CACHE STMT_CACHE_HITS STMT_CACHE_SIZE STMT_CACHE_NOLIMIT STMT_CACHE_NUMPOOL…
Machine configuration
Hello, can you any clear my confusion what it exactly mean. output for "onstat -g osi" in our production database. IBM Informix Dynamic Server Version 12.10.FC8 -- On-Line (Prim) -- Up 6 days 00:41:06 -- 4929792 Kbytes Machine Configuration.... OS Name Windows OS Release 6.2 O…
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.…
storesdemo
see new AUTOLOCATE configuration parameter - in docs as well as in your onconfig.…
HDR Configuration
Hi Friends, After a lot of study and IIUG members help, we are ready to implement HDR in production environment. But I need your help to get move forward to successfully implement HDR without any issues. Which is the best approach to get high performance and without any data lo…
Monitoring SPL Executions?
Thank you for the idea... But, ADTMODE = 1 informix@ifmx-prod-anc>onaudit -c Onaudit -- Audit Subsystem Configuration Utility Current audit system configuration: ADTMODE = 1 ADTERR = 0 ADTPATH = /opt/informix/aaodir ADTSIZE = 50000000 Audit file = 0 ADTROWS = 0 informix@…
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…
Implementing HDR on Windows 2012 R2 Servers
Actually apart from the steps i followed, what need to be configure to get the trusted connection between servers.…
Automatic Failure in HDR Setup
Thanks for your response. Is there any other than cmsm.cfg.sample to configure for automatic failover.…
Configuring HDR
We have a primary and secondary setup in PROD that I am trying to mimic in dev with version 11.5 I watched Lesters webinar, and he mentions the use of an rhost file. On other searches, I see some people use hosts.equiv file When I look for both of these in our PROD environment,…
Internal error in routine sqoptim
Hi, I cannot find MULTI_INDEX_SCAN on configuration file. It's new parameter need to add into our config file? Thank You…
Copy a database from one instance to another
Larry, Sounds like the tape device is not configured on server 2. have you tried 'ls -l /dev/rmt ' ? Mark…
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)…
connection Manager
Hi All How exactly connection manager works with ? Can anyone help me configure connection manager, I have heard that it has some bugs, is this so? Thanks Jaya…
Problem with sysdate in SPL
Hello everbody We have a problem with sysdate in spl. The fractions of second is same during all executing of store procedure. The version of IDS is 11.50 FC9GE in Solaris Sparc 10. In the onconfig set USEOSTIME in 1. I created a table with camp datetime and two store procedu…
Problem with time
Pedro: So if you replace these two lines: let teste = "sleep 1" run teste with these two: with the next command the error occours sleep 1 the time does not advance, but either way you are getting the timestamp from the 4GL CURRENT verb. Correct? From the 4GL manual: If C…
Informix temp spaces
Hi Thanks for the answers, then I will leave configuration as it is and I will play with adding more tempdbs with "T" flags…
SSL configuration
Hi , ifx 11.50FC9X6 and 12.10 FC4 , AIX 6.1 GSKIT 7 and 8 The client side , will access using JDBC I'm trying configure a SSL connection and I not sure what happen here... At my first tests all appear works fine (ifx11.50 + GSKIT 7) and I successfully connect using SSL. But wi…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
USEOSTIME Performance Degradation ?
The need has arisen for sub second granularity with CURRENT. Question is does turning this on result in any noticeable performance degradation and if so is it more system wide or specific to just the application ? AIX 6.1. Informix 11.70.FC7 Thanks, Mark…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
when use IfxDataReader.GetIfxDateTime to NULL valu
Hello, The version of Informix products in my environment is: Database server: AIX IBM Informix Dynamic Server Version 10.00.FC5 IBM Informix CSDK Version 2.90 IBM-ESQL Version 2.90.FC4 Client: PC Windows IBM Informix-ESQL 3.70.TC5DE.…
Connect 4GL to Informix Server
Thanks. I have the remote server trusted, but there are any others configurations? Because if i do this (for example): ssh informix@192.168.1.122 the password is required.…
connection manager SLA point to DBALIAS not workin
http://www-01.ibm.com/support/docview.wss?uid=swg21635513 a technote for Configuring the Connection Manager for PAM Authentication Thanks…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Btree scanner
Just curious, is there a way to evaluate if the configured B-tree scanners are working well or not, .... Thanks, Frank --20cf306f750442377604d3fa2ab2…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
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,…
Strange ...
Hmm, never saw this one before, no. I was told that with USEOSTIME 0 the server retrieves system time periodically but keeps track of the time itself in-between pings. WIth USEOSTIME 1 every call to CURRENT or TODAY calls the system's gettimeofday() function to get the exact time…
RTO_SERVER_RESTART configuration parameter
hello all we currently have this parameter disabled. I am looking for feedback on experiences using this parameter versus how we are doing it, which is to use the CKPTINTVL configuration parameter. thanks tom…
CPU informix
Thank you very much. Now I understand how to configure the CPU.…
IDS 7.31 UD5 data(base) recovery
Informix Dynamic Server Version 7.31.UD5 I understood that IDS 7.31 entered End Of Support in September 2009 ( 2 and a half years ago) I hope this is not a business critical system…
enterprise replication time to replicate data
IBM Informix Dynamic Server Version 11.50.FC6 Question for enterpise experts Does anyone know a command that will give me time that it takes to replicate data to a node? for example i update on server a and it replicates to server b . How long did it take? cdr view profile gives …
Issue creating RSS replication
Hi, The steps mentioned in the previous post have been followed. The issue was with the wrong HA_ALIAS configuration. That was rectified and RSS is up & running. Regards, SB…
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…
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.…
How to get Current Timestamp past seconds.
You need to activate the parameter USEOSTIME in your onconfig file ad rebounce your engine. You can go up to 5 digits after the decimal point. By default you can have up to 3 digits of precision. Khaled BENTEBAL khaled.bentebal@consult-ix.fr Le 04/01/11 18:06, Knox, Ernest a é…
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…
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…
Configuration changes for additional processors
We're running Informix 10.00.FC9 HPUX 11iv2 (Itanium) Last weekend, I added a second DUAL core processor to our HP rx2260 server (so now we have a total of 4 processors - i.e. 2 dual core). I changed the following: MULTIPROCESSOR from 0 to 1 SINGLE_CPU_VP from 1 to 0 VPCLASS …
INFORMIX CONFIGURATION
Good Day, how do i check the Informix Configuration and the DBS Configuration(is this the same thing)?? I did a restore of the database and are working on the disaster recovery steps but i'm not sure how or where to start to check the informix\\\\DBS configuration.. Help will …
Post-Upgrade HPL issue
Could be an issue with poorly configured swap on the server - stay tuned.…
Different instances with markedly different times
I have two useless ideas: 1- Overload the OS function that IDS uses (is it gettimeofday()?) and give it some "intelligence" 2- Convince IDS development to use an internal time keeper instead of relying on the OS to do it (this is probable what Oracle does?) Regards. On Fri, A…
Re: performance improvements for dbimport?
On 10.03.10 01:44, FRANK wrote: > Frank , > What is your Virtual memory size configuration? > Frank > SHMVIRTSIZE 262144…
Extents Monitoring
Hi, We are using "IDS 11.50.FC3W1". The table configuration is having a single fragment (defauit). Regards Kasi…
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…
Query
Yes, I know we have a licensed. Should I proceed for configuration and how to start? Please advice me.…
Looking for real configuration data
[Sorry if you receive multiple copies of this message.] [Please feel free to forward the message to others who may be interested.] Hi, We are a computer systems research group at the Computer Science department at Rutgers University, and are conducting research on simplifying t…
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…
Anyone playing with this sort of configuration?
I know that there's been talk of using SSDs, but there's an offshoot of ssds on PCI-e cards. Was wondering if anyone has been playing with IDS 10, or 11 using SSDs on the primary, then doing replication to a server with SAS drives and some more space. I'm assuming that the OLT…
How to set up dbaccess environment???
All: I have researched how to configure the dbaccess environment and have not found anything on this topic. My goal is to configure the dbaccess environment to accept the "Backspace" as designed instead of getting "^H" when the key is pressed and/or "^[[3~" for the "Delete" key…
IO problems and perf
Hi again :) I have some IO problems what cause probably the performance problems I had. So I'm running 11.5FC4, and only IDS on this server, and I've got 2 processors, here are some of my config params : DIRECT_IO 1 RESIDENT -1 USEOSTIME 1 I'll make a test by resetting RESIDENT…
Re: Help on ER ; remote/cyclic synchronization
Thank you Madison, Your answer helps me to finish my ER configuration.…
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…
ODBC-Server Middleware
Hi all We are looking for an ODBC driver which meets the following specifications: Must-have: - Resides on a server/host - May be configured only on the server - Dirty read is configurable per Data Source - Read only is configurable per Data Source - Certified to IDS 11.5 FCx …
DB Monitoring
There is not information about the duration 'time' taken in monitoring. You could as for your programmer insert the following statement inside the application before and after the statement to get the time as beggining and at end of statement: select current from systables where…
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…
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 function to generate GUID/UUID
Ah my understanding of the db2 function was it was unique on a particular DB2 data base at a table level. - being a combination of the DB2 partition number and a timestamp... T"The system clock is used to generate the internal Universal Time, Coordinated (UTC) timestamp along wi…
Configuration feasability
HPUX 11.0 Informix 9.40.FC4 Hello all, I support the Informix database which uses Baan. The Instance is around 350Gb in size and the level 0 backup is taking around 6-7 hrs a night to run. The customer has requested we investigate the possibility of moving 1 baan company (70Gb o…
Useostime Question on Solaris
Does any one have any test/experience on the cost difference on setting USEOSTIME to 1? Bruce Simms Data Base Services TALX Corporation 2330 Ball Drive St. Louis, MO 63146 Phone (314) 214-7703 FAX (314) 983-3238 bsimms@talx.com…
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…
Informix onconfig file configuration
Hello, We recently moved from a quad proc (hyper threaded to 8), 8GB RAM to a 2 socket dual core, 16GB RAM server. In order to maximize the cores and RAM what entries need to be modified, if any? Thanks, Jared…
USEOSTIME issue
We have the following: IBM Informix Dynamic Server Version 10.00.FC6 HP-UX om4db1 B.11.11 U 9000/800 4126011100 unlimited-user license We started the database with USEOSTIME 0 When you do a date on the system it says the time is Tue Dec 4 15:09:58 CST 2007 But if you do a s…
Update from Digital 7.31.FD1to ....
Back to one of the origional issues, performace goes South when there are 150 users on the box. Believe this issue has been discussed before, how many NETTYPE threads can be configured of each configured CPU. You have configured 3 CPU's but list: NETTYPE soctcp,8,50,NET # Config…
Datetime data type
Yes. Enable sub-second timing in the server by setting: USEOSTIME 1 in your ONCONFIG file and bounce the engine instance. There used to be overhead to turning this on so it's a configurable and not the default. Current OS's have a very light weight implementation of gettimeofday…
Timestamps into a TRACE logfile - current time in stored procedures
Hello list, what can I do to get timestamps having fractions of seconds into a TRACE created using TRACE PROCEDURE. What I have is: TRACE <sometext>; select dbinfo('utc_to_datetime',sh_curtime) into _trace_ts from sysmaster:sysshmvals; TRACE _trace_ts; But also casting like se…
IIUG TV
Great job on the video work!! I look forward to seeing more! -t- -- -- Informix Dynamic Server Database Engine -- http://www.informix.com --…
Re: admin tools like PC client
Mike, What version of Informix are you using? Informix SE? Informix OnLine? Informix Dynamic Server? Most Informix versions these days come with a product call I-Connect that needs to be installed on the PC and rovides the Informix ODBC drivers.…
Error when initializing
06:36:20 IBM Informix Dynamic Server Version [b]10.00.UC6TL[\\b] I believe this is likelt ot be a new ish instance to a newish user of the software…
configuration problem
i Successfully install informix dynamic server 10 on aix 5.3 without demo After that i set envirnomental variables export INFORMIXDIR=/informix export PATH=$INFORMIXDIR/bin:$PATH export INFORMIXSERVER=demo_on export ONCONFIG=/informix/etc/onconfig export INFORMIXSQLHOSTS=/infor…
configure database on other system
Hi all, I want to configure a database on another system because of capacity problems. I want to store my customers data on that other machine. I'm am running on SuSe 10.1 with IDS 9.40. Is there anywhere some documentation about this topic? Thanks for any information!! D…
configure database on other system
Hi all, I want to configure a database on another system because of capacity problems. I want to store my customers data on that other machine. I'm am running on SuSe 10.1 with IDS 9.40. Is there anywhere some documentation about this topic? Met vriendelijke groeten / Sincère…
ids-config
Obnoxio The Clown wrote: > I've taken the dramatic step of setting up a SourceForge project so that > we can build a semi-intelligent configuration tool as a user community > project. > > https://sourceforge.net/projects/ids-config > > We've heard a lot of talk, are we going to s…
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…
SNMP configuration
I am trying to monitor an IDS9.40 instance with HP OVO using SNMP. I have run the runsnmp.ksh script and now have the following processes running: root 25857 25854 2 Feb 22 ? 94:11 onsnmp -norion_prod_shm -k5 -p5 -l/tmp -g32 -r4 informix 25854 1 0 Feb 22 ? …
RE: Listing all the tables in using a dbspace in Informix
I tried using oncheck -pe <dbspace name> and got the following message WARNING: Cannot access configuration file $INFORMIXDIR/etc/$ONCONFIG. V…
IDS Multiplexing Configuration
Hi all, I tried configuring the IDS installed on a Windows 2003 Server to handle multiplexed connections, according to IBM Informix Performance Guide: 1. Set nettype to sqlmux 2. Added to "Options" the value "m=1" in the SQLHOSTS registry, for the corresponding dbservername. …
Configuring IDS for multiplexing
Hi all, I tried configuring the IDS installed on a Windows 2003 Server to handle multiplexed connections, according to IBM Informix Performance Guide: 1. Set nettype to sqlmux 2. Added to "Options" the value "m=1" in the SQLHOSTS registry, for the corresponding dbservername. …
PHP & IDS
I am trying to configure PHP 5.1.6 on Red Hat Linux 5 (64 bit) with PDO_INFORMIX. The configure seems to ignore the flag --with-pdo-informix. Is there a PHP version required for the PDO_INFORMIX, i.e. will it run with PHP 5.1.6 or should it be PHP 5.1.2? Has anyone tried this ye…
Informix produces error -1263 after system time is changed
Also I forgot to mention that the onconfig USEOSTIME is set to 1 (gets time from the host)…
Re: how to configure this?
Jonathan Leffler wrote: > calyanram@hotmail.com wrote: > >> performance of SGSINHS002, There are 2 instances in this box. >> OS HPUX.9.x > > > You're joking? Aren't you? > > HP-UX 10.x is out of service, let alone 9.x. > > Is this PA-RISC or Itanium hardware? 32-bit or 64-bit? …
Re: how to configure this?
calyanram@hotmail.com said: > Old Server Memory Configuration : > 1. 4 GB RAM > 2. 4 CPU M/c > > New Server Memory Configuration : > 1. 16 GB RAM > 2. 2 CPU M/c > > these new instances has a boosted memory configuration for databases. > These configuration will result is total me…
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…
RE: CUURENT in Stored Procedure
Colin Dawson wrote: > CURRENT will take the timestamp value at the point the SP started > execution. Or the statement that invokes the stored procedure if it is invoked as part of another SQL statement, rather than via EXECUTE PROCEDURE. > USEOSTIME=0 force the DB to take it's …
CUURENT in Stored Procedure
I use SCO OpenServer 5.x and Informix 7.x My USEOSTIME is set to 1 (Seems if this only enable the fraction part) The date_stamp is declared as DATETIME YEAR TO FRACTION(5) Maybe this question was asked before, but I would like to ask it again. If I use CURRENT at different place…
CUURENT in Stored Procedure
I use SCO OpenServer 5.x and Informix 7.x My USEOSTIME is set to 1 (Seems if this only enable the fraction part) The date_stamp is declared as DATETIME YEAR TO FRACTION(5) Maybe this question was asked before, but I would like to ask it again. If I use CURRENT at different place…
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…
Initialising Informix
My file settings are as follows SERVICES srvr0001 8001/tcp #Informix port sqlhosts ok_srvr onipcshm 10.0.6.2 ipcs0000 ok_tcp onsoctcp 10.0.6.2 srvr0001 onconfig DBSERVERNAME ok_srvr # Name of…
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?…
ONTAPE verification - was RE: anybody using Archecker with Onbar ?
archecker -tdvs.... and configure the AC_CONFIG file. Superboer.…
Re: removed database
if the need to restore databases inidivdually is a requirement then you could configure IDS such that you can put each database in its own dbspace and warm restore that dbspace…
Re: Table Editor for Multiplatforms
Enhancements in Version 4.3 ..... also supports the Informix Dynamic Server 9.x. http://www.ibm.com/software/data/db2imstools/db2tools/db2te/…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: MaxConnect
"Sounds like a poorly configure TCP stack, have you tweaked the tcp settings ? " Which setttings? To what values? How do I tweak them?…
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…
vonfiguring jdbc local
thank you very much it works fine in regular connections my problem is that i want this connection to work via "office connect 4" which works fine via office 2000 but in office 2003 gives me only the first record by the way when dealing with a DB who does not need locales config…
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: Need Help with recovery of 7.31
ahum most likely in log_full.sh which is configured as alarmprogram in $ONCONFIG. having this is a recept for disaster... Superboer.…
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: Configuring remote tcp connections.
Hi, I've got this line on my $ONCONFIG file: NETTYPE ipcshm,1,120,CPU # Configure Poll thread for nettype I need this line. How can I define other NETTYPE values? Can you show me an example of two distinct configurations? Regards, Nuno Paquete…
Configuring remote tcp connections.
Hi group, I need to configure my Informix system to accept remote tcp connections. This Informix DB is running on an AIX server. Here is the output of /informix/etc/sqlhosts file: porto onipcshm portonova sqlexec lisboa onipcshm portonova …
Re: IDS 10 erratic run times
Neil, I have seen anything similar when we had AUTORAID configured on a system Sometimes the disks ran as RAID 10 and other times as RAID 5 depending how the AUTORAID decided to configure them When RAID 10 the performance was great When RAID 5 our perfromance was woeful…
Re: Performance hit with USEOSTIME = 1 on AIX?
Sean Baker wrote: > We're running IDS 9.40.FC4 on AIX 5.2. > > We would like to use DATETIME YEAR TO FRACTION(3) for a new application. I've searched through CDI and found several references to performance hits when you set USEOSTIME = 1, including the Informix docs (Admin Ref: …
Performance hit with USEOSTIME = 1 on AIX?
We're running IDS 9.40.FC4 on AIX 5.2. We would like to use DATETIME YEAR TO FRACTION(3) for a new application. I've searched through CDI and found several references to performance hits when you set USEOSTIME = 1, including the Informix docs (Admin Ref: 4 to 5 percent performa…
IDS 10 disk configuration
We are migrating one of our HP-UX 11i database servers to a new disk array and upgrading it from IDS 9.3 to IDS 10 at the same time. Current disk array is an attached SCSI RAID 5 array, forgive me Art. The new array is a HP XP128, RAID 5 as well but it was installed before I had…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
RE: HPLoader Configuration
As part of the CREATE TABLE statement. Should be in the SQL:Guide to Syntax. Martin Fischer Database Administrator Associated Grocers, Inc. NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. An…
RE: HPLoader Configuration
Hi, Martin But how I indicate it, load to "dbspace8"? Regards, --- Martin_Fischer@agsea.com escribi�: > This is how I do it using the onpload GUI interface as I haven't played > with the CLI as of yet. IDS9.3 on AIX 5.2 > > create your new table (No indexes) > > in the HPL…
Re: HPLoader Configuration
I have been look in for manuals but I don't find it ( yet) on IBM's Portal. Do you have the link to it? Regards, --- Superboer <superboer7@planet.nl> escribi�: > > 2 ways onploadadm (check manual) and ipload (check manual) > > easiest way is ipload. set your display correctl…
Re: HPLoader Configuration
I'm curious, can you simply use the pipe as a FILE in the device array and bypass the "cat - > /tmp/myfifo" and "cat /tmp/myfifo" PIPECOMMANDs? Will the unload job open the pipe for writing and block until the load job opens the pipe for reading or is the "cat" necessary? We've…
RE: HPLoader Configuration
This is how I do it using the onpload GUI interface as I haven't played with the CLI as of yet. IDS9.3 on AIX 5.2 create your new table (No indexes) in the HPL GUI, Components | Devices create a pipe device array and the pipe command should be '/usr/bin/cat' back at the main…
RE: HPLoader Configuration
That's the problem I don't know how to do it. Have you an example or something that can help me? Regards, --- Martin_Fischer@agsea.com escribi�: > Or one could create HPL load jobs that copy from table to table bypassing > the need to unload to files altogether. There was …
RE: HPLoader Configuration
Or one could create HPL load jobs that copy from table to table bypassing the need to unload to files altogether. There was not alot of information in the initial post to determine a proper solution. Martin Fischer Database Administrator Associated Grocers, Inc. NOTICE: This …
Re: HPLoader Configuration
You may create a device array to unload the table to two or more files in parallel. So you won't hit the 2GB limit. Art S. Kagel wrote: > Cesae Cruz wrote: > >> --0-1996201718-1118093043=:74317 >> Content-Type: text/plain; charset=iso-8859-1 >> Content-Transfer-Encoding: 8bit >…
Re: HPLoader Configuration
Hi Art, It's possible modify this filesise limit? --- "Art S. Kagel" <kagel@bloomberg.net> escribi�: > Cesae Cruz wrote: > > --0-1996201718-1118093043=:74317 > > Content-Type: text/plain; charset=iso-8859-1 > > Content-Transfer-Encoding: 8bit > > PLEASE DO NOT POST MIME TO TH…
HPLoader Configuration
--0-1996201718-1118093043=:74317 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I need know how i can configurate/setting the HPloader for dowloand from dbspace1 and upload the same Table on dbspace8 ( 39,000,000 Records ) I tryed with onunloa…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
Re: Need help!! Sql to Informix Migration
And wich one will be the best configuration for TCP Processing, not Batch Processing.... I have increased the number os Buffers, but not the LOCKS, and also increased the number of cleaners and LRU Thank you…
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…
Configuration Parameters - Spreadsheet
Hi Everyone, I started to put together a spreadsheet that would calculate onconfig parameters based on a given set of values - such as memory, # cpus, # users etc etc. But, before I re-invent the wheel, I thought I would ask if anyone has such a spreadsheet or if one is availabl…
New Server Configuration
We are moving our informix database and software application to new hardware in a few weeks. I am looking for any suggestions on how to configure the hardware and informix for optimal performance. HARDWARE: SunFire V440 (4 CPU, 8GIG RAM) Sun StorEdge 3510FC (12 disks - 36gb/ea) …
Raw disk device setup in Suse Linux 9
In Red Hat Advanvced Server 2.1, setting up raw disk devices was rather straightforward - primarily, you defined the mapping in the /etc/sysconfig/rawdevices file and the configuration was saved. In Suse Linux version 9, we are trying to do the same thing, however the documentat…
chunk capacity
we are using BM Informix Dynamic Server Version 9.40.UC2X3 on Linux Kernel 2.4.21 the command 'onstat -d' shows ... Expanded chunk capacity mode: disabled how can I change this mode to 'enabled'?…
Re: Where are the fractions of a second of CURRENT?
It depends on the OS. Some OS make a light-weight function which returns the current machine time in ms. Others have to go deep into the kernel to get it. The USOSTIME 0 is rather fast because we keep the time in seconds at a fixed memory location in shared memory. However, …
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Change Informix Time
Hi, We use USEOSTIME parameter to decide how Informix will use the time either from Operating Systems (OS) or will handle itself. If I use time maintained by Informix, how can I change if required some time ? With Regards, Indranil Deb…
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Veritas Configuration
<html><div style='background-color:'><P><BR><BR></P> <DIV> <DIV class=RTE> <P>Hi all,</P> <P>The customer is running informix 7.31 on sun solaris intel platform. The veritas is running on different server. Sun Solaris version is 2.6 and Veritas version is 4.5</P> <P>After se…
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…
Informix onbar on veritas configuration
<html><div style='background-color:'><DIV class=RTE> <P>Hi all,</P> <P>Can any one please tell me the configuration steps for onbar backup and restore on veritas software.</P> <P>The customer is running informix 7.31 on sun solaris intel platform. The veritas is running on differ…
Configuring ISM
Hello Gurus, Would like to know if the block size for tape write can be configured in ISM for backing up using onbar. We have IDS 7.31 UD5 on HP Unix 11i Your assistance would be highly appreciated. Prasad S Shetty ____________________________________________________________…
Omnis and Informix
Hi, Has anyone seen this problem in any of your environments? The configuration is based on: IDS 7.31 FD (HP 11i 64 bit version) OMNIS using Informix Client SDK 2.80 We setup the setnet32 and set up a default configuration (dbservername, = protocol, ...). The OMNIS applicatio…
Dose anybody have the dbtop script in the Troubleshooting informix course?
Dears, I study the Troubleshooting ibm informix dynamic server course. At the module 4 exercise need the dbtop script. Dose anybody has this dbtop script and post for me? Thanks. Philip Yeh.…
dbaccess configuration file
Hello ! Well i know that it had already been discussed here.... but maybe things have changed since the last time. So this is it : Is there a way to configure dbacces so that it start with some default option: I mean , i'm tired of typinh each time => set lock mode to wait; a…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [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,…
On Nettype Configuration
Hi forum, Looking for high level thought on these two configurations for Nettype. Using soctcp,,500,NET (without # of poll threads) for nettype value in onconfig. If left blank does it take a default value. vs. soctcp,4,500,NET (with # of poll threads) for nettype value in onco…
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…
Read only connection
Hi. I have installed IBM Informix Connect 3.82 32 BIT driver for connecting to a Informix Dynamic Server 9 for Linux. I have configured the driver and works fine but I don't know if I can restrict read access. Is there any option for configure the driver in a read only connectio…
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…
Conexiones tcp's se pierden y se congelan.
NETTYPE ipcshm,4,100,NET # Configure poll thread(s) for nettype NETTYPE soctcp,4,100,CPU # Configure poll thread(s) for nettype creo que las conexiones de TC/IP son tipo NET y no CPU, connectivity information page 3-30 Administration Guide…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
Where can I get the client API?
Hi, does anyone knows where to get the client API for Informix Dynamic Server 7.x? Perhaps we want to access the server via api directly. Kind regards, Joachim Engel.…
Informix optimizer
Hi, Does anyone know if the Informix Dynamic Server (7.31 or 9.4) database optimizer uses star schema optimizer techniques? Thank you, Tony…
TRUNCATE TABLE command in 9.3?
I am aware that Informix Dynamic Server previously has not included the TRUNCATE TABLE command. Does anyone know if 9.3 or 9.4 include this command?…
Linux fgl_getenv
Informix Dynamic Server Version 9.30.UC3 on Linux. Do I have to do something before I can use the fgl_getenv call in a stored procedure? When I try I get 674: Routine (fgl_getenv) can not be resolved.…
informix 9.4 configuration - DRAUTO
hello all! we are upgrading to 9.4 (on 11i) from 9.21 on HP-UX 11. We are running HDR and I noticed that our current config file does not have an entry for DRAUTO. The config parameters listed in the 9.4 manual (Admin Reference) does not list DRAUTO. Can someone enlighten me on w…
IDS Multiple servers configuration
Hello, I have installed informix IDS on AIX. I want to use 2 databases, say DB1 and DB2. I want two informix server on the same machine, say SERV1 and SERV2. I want thant each server "sees" only one database. SERV1 accesses DB1 and cannot access DB2 SERV2 accesses DB2 and cann…
Data Space Configuration
I have to create a test instance, and I have 8 gigs of space to work with. I have to do this on 2 different servers. On one server, there is 4 gig available on 2 separate logical drives, and on the other server, there is 8 gig on 1 logical drive. Hardware RAID is used (but I am n…
SPINCNT configuration parameter in 5.10
Informix Version 5.10 Hardware: HP-K 4-way that was upgraded from a single cpu. OS: HP-UX 10.20 The application runs on the server and uses shared memory connections. I am working on cpu bottlenecks and I found the following. According to the book 'Informix Performance Tuning S…
how to configure a informix datasouce in Websphere 5 with replication
All, I'm trying to configure a datasource in Websphere 5 to a replicated infomix database .I'm using the JDBC Driver 2.21 JC4, But I can't find the parameters names to setup. Does someone know how to configure this? I,d like to have an automatic switch to the secondary server in…
DataBase Conection
Hi, thank's people who help me, i could configure the servers without problem, and they are working. Thank's a lot best regards. Erick…
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…
Current time in Stored Procedures
There is one more problem about that. Informix really gives better accuracy with " USEOSTIME 1". Unfortunately, the 'Current' time doesn't change while the stored procedure is running. That is, even with USEOSTIME=1 it's impossible to measure the duration of the stored procedure …
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…
Configuration problem with Four J's
Hi all, DATABASE SERVER: UNIX: Informix Dynamic Server 7.31.FC4A Windows 2000: Informix Dynamic Server 9.40 WINDOWS 2000 machine: Informix Connect 2.70 (C:\\Programmi\\Informix\\Connect): I created connections to the databases and I tested them with ILogin Informix Client SDK 2…
Informix - ODBC - Linux configuration
Hi all, I'm desperate looking for the way how to configure Informix 7.30 - ODBC - Linux - WinXP I found some articles talking about the odbc.ini - file, but I don't find what exactly to mention in there and where to put the file. Can anybody help me? thanks, danny…
Re: fractions
Arnel CUETO (DHL PH) wrote: > Gurus, > > I have some inquiries regarding the expression 'CURRENT' used in SQL. > Refering to the statement below : > > select current year to fraction(5) from [table_name] > > would produce a result: > > 2003-06-20 11:34:35.00000 > 2003-06-20 11:34…
RE: fractions
Can you then do computations on these fractions ? -----Original Message----- From: ART KAGEL, BLOOMBERG/ 65E 55TH [mailto:KAGEL@bloomberg.net] Sent: Monday, June 23, 2003 2:55 PM To: informix-list@iiug.org Subject: Re: fractions If you set the ONCONFIG parameter USEOSTIME to 1 …
Re: fractions
> THIS IS A MESSAGE IN 'MIME' FORMAT. Your mail reader does not support MIME. > Some parts of this will be readable as plain text. > To see the rest, you will need to upgrade your mail reader. --PART.BOUNDARY.2960.4671.p057.1056378754.6737 Content-Type: text/plain Content-Trans…
Re: fractions
> THIS IS A MESSAGE IN 'MIME' FORMAT. Your mail reader does not support MIME. > Some parts of this will be readable as plain text. > To see the rest, you will need to upgrade your mail reader. --PART.BOUNDARY.2960.4671.p057.1056372870.3922 Content-Type: text/plain Content-Trans…
Re: fractions
On Mon, 2003-06-23 at 09:38, Arnel CUETO (DHL PH) wrote: > Gurus, > > I have some inquiries regarding the expression 'CURRENT' used in SQL. > Refering to the statement below : > > select current year to fraction(5) from [table_name] > > would produce a result: > > 2003-06-20 11:3…
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Informix ODBC
Anyone knows how to configure the ODBC for informix, I got the Informix connect. but dont know how to configure. Please help. Franklin…
Help on SetNet32 with SDK 2.80
All the environment variable are seting correctly, however the error persists in occurring. Which would be the cause, in view of that all the configuration is correct? Thanks Denis…
Configuration error message
Hi, When I configure Informix Dynamic Server 7.31 UD1-1 on AIX 5.1. It displays the following messages: exec(): 0509-036 Cannot load program onmonitor because of the following = errors: 0509-130 Symbol resolution failed for /usr/lib/libc.a(aio.o) = because: 0509-136 Symbol kaio_…
reg: configuration of ONBAR
hi all, if anybody help in configuring ONBAR and ISAM as i am receiving forllowing error 2002-08-15 11:18:55 10278 10277 /informix/bin/onbar_d -b -l -c 2002-08-15 11:18:56 10278 10277 WARNING: BAR_BSALIB_PATH is undefined; trying default path. 2002-08-15 11:18:56 10278 10277 ER…
Locks
Best practice it to implement an optimistic locking protocol. Each table that is actively updated should have a timestamp column defined as DATETIME YEAR TO FRACTION(5) and if the table is to be fragmented create it WITH ROWID and you should run the instance with USEOSTIME set to…
CURRENT on AIX
Sorry I just noticed that our config file now sets USEOSTIME=0. This is my problem I am sure. Paul Howard wrote: > I have IDS 7.31 on AIX 4.3. Does anyone know how to get the CURRENT > function to return fractions of seconds. > > CURRENT year to fraction(5) always returns 00000…
Informix Linux Install-missing info
I can't find any info on configuring. . . INFORMIXSERVER and sqlhosts I've been through docs at www.informix.com and turned up nothing. How should these be configured to get SE/ISQL/4GL on Linux working? THanks -- --- Michael J. Kuhn mkuhn@csd.clark.net Computer Systems D…
A problem with enterprise replication
Have you opened a case with tech support? The 406 error indicates that memory could not be allocated. It could be that the configuration files has SHMVERTMAX set a bit low.…
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…
spanish DB_LOCALE configuration
Hello everybody: I?m trying to configure the LOCALE environment variables in NT Server with Informix 7.22TC1 for spanish Language. Would anybody give a hint? Thanks…
configure odbc
hello, i'm french and i'm doing install datastage server. i must configure odbc how i do i have a server nt, i don't install odbc office i have a server ingres II now i install a server datastage. i do and i must configure odbc what am i do ? In french Menu D�marrer --> Param�tr…
Informix v Oracle
Hi Is there a function in Informix Dynamic Server 2000 that is like Oracles CREATE SEQUENCE that uses NEXTVAL/CURVAL and %ROWCOUNT, ect? Thanks for all contributions Jordan jbruce@asaglobalserv.com…
Re: precision in the date/time field
From: jobmail@my-deja.com > >Thank you for the advice. I still cannot get the decimal part printed >correctly, though, even when I change USEOSTIME from 0 to 1. Did you recycle the instance? >In article <8sm5ot$ea12@www.informix.com>, > "Sergey E. Volkov" <sve@raiden.bancor…
precision in the date/time field
Thank you for the advice. I still cannot get the decimal part printed correctly, though, even when I change USEOSTIME from 0 to 1. In article <8sm5ot$ea12@www.informix.com>, "Sergey E. Volkov" <sve@raiden.bancorp.ru> wrote: > Try to set USEOSTIME=1 in onconfig. > > Good luck…
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 …
Time change.
If you ONCONFIG file has USEOSTIME 0 there may be a short period until the engine queries the system again to determine the system time when CURRENT and similar functions will return the old time (or a time derived from it) as without USEOSTIME set to 1 the engine only queries th…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
server configuration
hi i'm a new informix user :-) my firm will buy ME an informix server for ids2000 And i can choose... which simple advice can you give to me ? number of harddrive, processor, internal memory, tape device type ... thx !!!! :-)…
OnBar unsing on NT not as Informix user
Do you know how can I configure Informix 7.30TC7 to run onBar as a simple user/NT admin? Andor Rozsnyai GE Medical Systems Hungary Software Developer…
bde delphi and informix databases
does someone know how to configure the delphi bde for informix databases ??…
RE: NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2
Thanks for the reply. >You definitely have the LRU Priority scheduling bug, I reckon. OK that's the good news...... >Here's a post from The Mighty Art Kagel: Thanks for that, knew of it as Art keeps referring to it, but couldn't find it, was in the process of searching for it…
Informix & ODBC Setup
Hi All, Can Informix ODBC DSN read the configuration parameters from a file instead of Windows registry? If yes, how? Thanks, Nick.…
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…
Re: Optimize Buffer and Shared Memory Configuration
From: lkcho@my-deja.com > >Currently we are running Pentium III 800 MHz, 640 MB memory. We are >running SCO OpenServer 5.0.5 and Informix 5.10c. May I know what is >the best configuration, or how to optimumly configure buffer >configuration for Informix and shared memory for SC…
Optimize Buffer and Shared Memory Configuration
Currently we are running Pentium III 800 MHz, 640 MB memory. We are running SCO OpenServer 5.0.5 and Informix 5.10c. May I know what is the best configuration, or how to optimumly configure buffer configuration for Informix and shared memory for SCO OpenServer. What is the for…
Create user in Informix Dynamic Server
Hello all I`m new in INS. Could you help me? I have Database server with one user Informix. How to create another user to Database?…
Informix ODS on Win 2000?
Does Informix Dynamic Server V7.31.TC5 for Intel Pentium Windows NT 4 also run on Windows 2000? Thanks for any help. Guy Dillen ITP…
JDBC informix driver configuration
I'm having troublings in configuring the JDBC driver to access to informix database. Could anyone tell me about a solution for configure the driver in Netscape Enterprise Server 4.0 running under Windows 2000 Server?. Thanks.…
Onaudit......?
Hello, Hi to all, Does somebody knows where there is a manual o summary about the onaudit for Informix in NT?. How to configure it and how to use it. Thanks.…
SE- Read performance problems
Hi, Do you know any configuration parameters that improve performance for Informix SE SELECT/FETCH operations ? (I use ESQLC under Solaris7 x86) Can i increase buffers ? My configuration "setlitcp" is important for performance ? Thank you Liliano Sent via Deja.com http://www.d…
Informix cost???
Someone can said how much does Informix cost? I need to know: -Informix costs -cost for client Thanks very much. I need the last version of dynamic server for Unix. Ciao, Berna…
Replication
Hello everybody. I would like to know if it is possible to replicate an Informix database between a UNIX-based 7.32UC2 Informix Dynamic Server and an linux-based IDS2000 without problems. Thanks in advance. jhernandez@geuropa.com…
i.Sell configuration
Has anyone had experience configuring a Netscape Connection Module for Informix i.Sell? I am currently having problems getting the connection module to work when the HTTP Server is on a different machine than the i.Sell application server. Kirk Sent via Deja.com http://www.dej…
NETTYPE question
I have a question regarding the NETTYPE parameter. Which one of the following is more efficient? And does each configure communication parameters for 256 users? In other words, does the first NETTYPE parameter configure 4 poll threads of class CPU each capable of handling 64 u…
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…
Problems with IDS 7.30.UC10-1 for Linux
Hi, how are the the described kernel parameters concerning the shared memory (in IDS_7.3) configured in Caldera Linux 2.3 ? Thanx, Andi…
Re: IDS 7.3 : Stored procedures tuning
From: Thomas Parsli <thomas.parsli@startsiden.no> > >"Obnoxio The Clown" <obnoxio@hotmail.com> writes: > > > From: Leonids.Voroncovs@dati.lv > > > > > >Obnoxio The Clown wrote: > > > > > > > > > >WinNT > > > > > > >knows millisecond ! So I do not really understand what is the > >…
RE: IDS 7.3 : Stored procedures tuning
>Obnoxio The Clown wrote: > >> > > >WinNT >> > > >knows millisecond ! So I do not really understand what is the problem ! >> > > In your onconfig file, set USEOSTIME to 1. >> >Doesn't works! >> All together now: "USE A REAL OPERATING SYSTEM!!!" :-) > >Out of topic. We are speakin…
Re: IDS 7.3 : Stored procedures tuning
On Fri, 7 Apr 2000 Leonids.Voroncovs@dati.lv wrote: > Obnoxio The Clown wrote: > > > > > >WinNT > > > > >knows millisecond ! So I do not really understand what is the problem ! > > > > In your onconfig file, set USEOSTIME to 1. > > >Doesn't works! > > All together now: "USE A RE…
Re: IDS 7.3 : Stored procedures tuning
On Fri, 7 Apr 2000, Obnoxio The Clown wrote: > From: Leonids.Voroncovs@dati.lv > > > >Obnoxio The Clown wrote: > > > > > >The CURRENT function always returns result wich precision is > >'truncated' to > > > >second format (fraction part of datetime is always 000) : '2000-04-04 >…
Re: IDS 7.3 : Stored procedures tuning
From: Leonids.Voroncovs@dati.lv > >Obnoxio The Clown wrote: > > > > > >WinNT > > > > >knows millisecond ! So I do not really understand what is the >problem ! > > > > In your onconfig file, set USEOSTIME to 1. > > >Doesn't works! > > All together now: "USE A REAL OPERATING SYSTEM…
Re: IDS 7.3 : Stored procedures tuning
Obnoxio The Clown wrote: > > > >WinNT > > > >knows millisecond ! So I do not really understand what is the problem ! > > > In your onconfig file, set USEOSTIME to 1. > >Doesn't works! > All together now: "USE A REAL OPERATING SYSTEM!!!" :-) Out of topic. We are speaking about I…
Re: IDS 7.3 : Stored procedures tuning
Daniel Bonesana wrote: > > Try this > > # method for Dynamic Server to use when determining current time > USEOSTIME 1 # 0: use internal time(fast), 1: get time > from O > S(slow) You should check with Tech Support. There was a malingering bug in the NT versi…
RE: IDS 7.3 : Stored procedures tuning
Daniel Bonesana wrote: > Try this > > # method for Dynamic Server to use when determining current time > USEOSTIME 1 # 0: use internal time(fast), 1: get time > from O > S(slow) Doesn't works!…
Re: IDS 7.3 : Stored procedures tuning
Obnoxio The Clown wrote: > >The CURRENT function always returns result wich precision is 'truncated' to > >second format (fraction part of datetime is always 000) : '2000-04-04 > >15:21:54 000'. I get this result either in an SQL statement or in a SP. I > >read that CURRENT rely…
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…
sqlhosts configuration
Hi all, When I build my sqlhosts file, is the hostname field the result of the "uname -n" command or "hostname" command ? If I use DNS this two commands will not give the same result... Thanks. -- Thierry ACHAINTRE Architecte Syst�mes et R�seaux - EURIWARE thierry.achaintre@e…
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…
Have anybody installed IDS 7.3 on Windows 2000?
Hi. I get a 'system error 1005' when it tries to configure install and then it shows 'Install in progress' window infinitely. Thanks.…
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…
Posting from the Informix-list
Hi list, I have following paramters in onconfig. NETTYPE ipcshm,1,60,NET # Configure poll thread(s) for nettype NETTYPE tlitcp,2,250,CPU # Configure poll thread(s) for nettype I wanted to know how can I find active no of connections through each type at a given …
q: data type datetime question ?
tedchyn@yahoo.com wrote: > > sir, how is informix store datetime field ? is millisec part of datetime > field ? When you define the DATETIME column you specify the resolutiion and preceision. The maximum is: DATETIME YEAR TO FRACTION(5) which will hold 5 decimal digits of prec…
Configuring onbar
Hi all I am having trouble configuring onbar. So far I have: 1. Installed the IECC on both my UNIX box and Windows box 2. granted DBA privileges to a user who is on both the windows and UNIX boxes. 3. Specified the backup parameters in the BAR Wizard I'm using windows NT and Sol…
System catalogue
Hello! Can anybody explain me how I can create trigger on "informix".systables? (The server I deal with is Informix Online Dynamic Server 7.3.) Max…
Re: Exists Tupel Queries ?
At 09:16 AM 01/28/2000 +0000, Obnoxio The Clown wrote: >Ah, bugger! I suppose this means I have to read *another* manual. :-> Actually, it's worse than you think. First, you can create a UDR that returns a SET/MULTISET/LIST result, and drop the function into the from clause…
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…
informix and xntpd
For all of its internal timestamps, such as those used to mark updated pages, Informix uses a sequential integer (kind of like a SERIAL column) so the mechanics of Informix should not be affected. If USEOSTIME is not set Informix periodically gets the time from the system for us…
Anyone use Informix CLI 2.50.WXX ?? 16 bits.
If you are using Informix CLI 2.50.WXX 16 bits can you tell me what is your system configuration and if it handle DBCENTURY? Thanks.…
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 JDBC Proxy
Does anyone know if it's possible to configure the length of the data in IfxJDBCProxy servlet ? Thanx. David. Sent via Deja.com http://www.deja.com/ Before you buy.…
system configuration
I have a dilemma. we are runnig informix IDS on a Sun E3000 with 6 200Mhz processors and 1 gig of ram. our performance is very poor. We have spent most of the last year tweaking the engine but our traffic increases and performance remains poor. We are now looking to upgrade o…
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…
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…
RE: CURRENT
Major bug, what can I say...8) (USEOSTIME = 1, right? ) Andris Shirons ---------- From: Leonids.Voroncovs@dati.lv[SMTP:Leonids.Voroncovs@dati.lv] Reply To: Leonids.Voroncovs@dati.lv Sent: Thursday, October 14, 1999 8:46 AM To: informix-list@iiug.org Subject: CURRENT Hi c…
setnet32 configuration
Hi, I have a problem with the Informix - Client. The environment: setnet32 Ver 9.20 2.20 TC1 When I log in as local administrator on my NT 4.0 WS I install the client, and the I configure it in the environment (server, informixdir) After it I log in as noirmal user in a domain th…
Re: vmstat -s
>What does "revolutions of the clock hand" mean in a vmstat -s? > >I read somewhere that if "revolutions of the clock hand" > "uptime" then you >have major problems. We have a system that just recently had "revolutions of >the clock hand" = 10 and uptime was 2 days.... needless t…
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…
administration tools
hi i´ve been trying to configure administration tools in a win98 box and when i try to use setnet32 to configure it keeps saying that it can access the registry anybody knows how to solve this? many thanks Roberto Leong…
DBCENTURY configuration
Please does anyone out there know how long i.e. hours/days it takes to configure the DBCENTURY variable on a single UNIX AIX v4.3 server? We will be upgrading soon to Informix v7.3 but I need to know the timescales and procedure for configuring DBCENTURY. Any reply would be grate…
Re: Enterprise Replication (CDR) and Day light saving.
ER uses the output of the time() function to evaluate the time of the transaction. It does not use localtime(), or ctime(). You should be using the correct TZ variable in you system so that you don't have to manually change the time, but instead the system automatically changes …
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Using gnu gcc to compile c4gl/ 4GL on AIX
Hi Is it possible to configure either c4gl or 4gl to use gnu C on our AIX box? Thanks in advance D. Escott email: ravage@rtype.com…
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.…
onstat -g iov
Hi users, Is it possible to configure the number of kio vps shown by "onstat -g iov" Thankx ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com…
Tape Configuration.
I have Informix 7.30.TC7 on NT SP3,in the onconfig file i have the next line for tape device : tapedev \\\\.\\Tape0 when i try to run the following comand c:\\informix\\bin\\ontape -s -U intelview the following message appear : the value specified for TAPEDEV or LTAPEDEV on the o…
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…
shared memory error SCO install
In article <3771800C.6FF8BF38@saw.net>, Brian Adams <adams@saw.net> writes: > Why are getting this error "Fatal error inshared memory creation" > > You have to set the kernel-parameters documented in $INFORMIXDIR/release/en_us/0333/IDS_7.3. I use this script: #!/bin/sh echo SHM…
informix tools Y2K issues
Primary Y2K issue is related to the use of 2-digit year input in 4gl code. When inserting or updating a date or datetime field, a "2-digit" year will always default to "19xx" -- regardless of the system clock ( 1999, or 2000+). If you have 2-digit year input, it is often possibl…
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…
Shared Memory on Linux
How do I configure Redhat Linux to get rid of the Shared Memory Error when I try to start Informix (IDS 7.3)? Thanks. Aris…
Informix Timestamps
Pascal Brenner wrote: > > Is anybody here know if we can use the timestamps of Informix in an > application ? > By timestamps, I mean the one which are updated when a row in inserted or > updated. > And if yes, how can we ?? Informix does not have a TIMESTAMP data type, ala Syba…
Kernel configuration
We have added 128 Mb of Ram to our Sun sparc station running ver 2.6. I want to know that how to best configure Kernel so that online (7.13 UC) can make efficient use of the added memory . Thanks Mukund --------------------------------------------------------------------------…
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…
Name Lengths
I am gathering information on the maximum allowable name length for tables and field in various databases. What are the limits for Informix? Are these limits configurable? Thanks. --Jim…
SETNET Configuration
Folks, I'm looking for a solution to the problem of linking to different DB's on different boxes using COGNOS report writer. The problem is that the linkages are made through SETNET, and I need two different environment, host and server setups. These setups can be saved to a fil…
Installation and configuration
We want to install Informix 7.30 on Solaris. Who has information about problems and traps ? What are the basic thoughts about the installation ? Perhaps there is a consultant who can help us ? PLZ 64584 Thanks…
Installation / configuration
Hi In the next days I would like to migrate my server 7.23 for NT 4 to Informix 7.30 / Solaris. First I must install and configure the server. Who knows some tricks and tips and - traps ? What are the difficulties ? Thanks…
Need help w/ setup of sqlcmd
I recently downloaded sqlcmd version 40 and I'm trying to install it on an HPUX 7.10 system. I'm having difficulty setting it up. Is there any documentation out there for the configuration section of the makefile? Or is there a pre-existing configuration that I can use? Any h…
Starting Informix Dynamic Server !
Hi Gurus, Just wondering is there any difference in starting the informix engine as root user versus as Informix user. ? The reason why I ask this question is , the IDS 7.23 UC6 on HP-UX 10.2 crashes due to a bug (declared as bug by Informix Technical support)when we start in…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Re: UTC, time zone support for datetimes
This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. ---559023410-758783491-918867284=:3031 Content-Type: TEXT/PLAIN;…
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?…
onstat -c , no output
Hi, "onstat -c" shows only the first two lines of output. informix online ver ..up 3 days... configuration file ..... The configuration parameters are not outputted.Why does this happen ? (online 7.14 on NCR MP-RAS) TIA Sathish Sadagopan…
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.…
How-to configure an ODBC-connection through Proxy
Hi, Can anyone give me some guidelines on how-to configure ODBC, setnet32 and the proxy-server to connect to an Informix-databaseserver? Thanks, John Leerentveld<jl@ibt.nl>…
Netscape Enterprise Connection for Informix Dynamic Server
Hi: Does anyone know the procedure for setting up a Netscape Enterprise Server to connect to an Informix Dynamic server on a remote machine? Michael…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Informix and RAID
Are there any whit-papers or other info on configuration of a data wharehouse and RAID? I will be configuring an 8.2 server and am considering hardware RAID over fragmentation. Any suggestions? Thanks in advance! Craig Lessor…
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: informix fraction
On Fri, 28 Aug 1998 tolga@login.com.tr wrote: > Has anybody tried to use datetime fraction in stored procedure or etc? Yes. > I have a problem with this: > In dbaccess, followin sql statement does not do what i want: > select current year to fraction(5) > In result,there i…
Re: informix fraction
tolga@login.com.tr wrote: > > Hi everybody, > Has anybody tried to use datetime fraction in stored procedure or etc? > I have a problem with this: > In dbaccess, followin sql statement does not do what i want: > select current year to fraction(5) > In result,there is no fract…
Re: informix fraction
On 28 Aug 98 at 6:32, tolga@login.com.tr wrote: > Hi everybody, > Has anybody tried to use datetime fraction in stored procedure or > etc? I have a problem with this: In dbaccess, followin sql statement > does not do what i want: > select current year to fraction(5) > In res…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
On Tue, 28 Jul 1998 14:40:44 -0500, Ben Jazi <bjazi@fallschurch.esys.com> wrote: >What are the major differences between INFORMIX-OnLine Dynamic Server >7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? No, IDS 9.x is the ORDBMS. This autumn the 7.3 and 9.x code lin…
Re: OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
Ben Jazi wrote: > > What are the major differences between INFORMIX-OnLine Dynamic Server > 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? > > Thanks, > Ben I don't know the differences in detail but you could check the following pages, where IDS 7.3 is described …
OnLine Dynamic Server 7.2 Vs INFORMIX Dynamic Server 7.3
What are the major differences between INFORMIX-OnLine Dynamic Server 7.2 and INFORMIX Dynamic Server 7.3? Is it ORDBMS vs RDMBS? Thanks, Ben…
Informix computer Base classes
Has any body used the Informix computer base training classes. I am wondering if any of the computer based training classes: "Informix Dynamic Server System Administration" or the "Managing and Optimizing Informix Dynamic Server Databases" is good. Thank You…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Informix Pricing
I would really appreciate some comments and input on pricing strategy of Informix On-Line V.5.10. I was told for the Unix platform, the minimum configuration is 30-license, regardless of the host being a single user machine or multi-user system. What's the "street" price for a m…
FW: TUXEDO config file.
> Could someone please share a copy of a ubb configuration file ? > This is the configuration file for an INFORMIX-TP/XA application that > uses > ESQL/C with TUXEDO. > > thanks. > >…
Informix Dynamic Server 7.3
Hello, Since I'm planning a Data Warehouse, I would to do it with the new version of Dynamic Server. Impressions, stability and on which platform? Regards. Fernando _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Fernando Collalti Phone: +…
Re: Timestamp Column.
Nils Myklebust wrote: > > On Wed, 29 Apr 1998 13:40:36 -0400, "Art S. Kagel" > <kagel@bloomberg.com> wrote: > > >pedrocr@dicoruna.es wrote: [Original question SNIPPED] > >Informix does not support type TIMESTAMP. You can use DATETIME along > >with a DEFAULT constraint and an UPD…
Re: Timestamp Column.
On Wed, 29 Apr 1998 13:40:36 -0400, "Art S. Kagel" <kagel@bloomberg.com> wrote: >pedrocr@dicoruna.es wrote: >> >> Hi all. >> >> I want to add a column of type timestamp in a table. (Informix Online 7.1) >> It's posible? >> In the manual i don't find the data type timestamp. >> I…
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…
Re: in place of I-Net
I forgot to indicate that when you log on to : http://oplweb.openlinksw.com:8000 for the live Web Configurator & Rule Book Demo Use the username "guest" and password "guest" to get in. Kingsley…
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: USEOSTIME and performance
>>>I have been asked to check the performance differences between USEOSTIME >>>on and off. I expected the that there would be a slightly better >>>performance (4-5% according to manual) with USEOSTIME = 0/No. This >>>isn't the case on the tests done, in fact it is exactly the r…
RE: USEOSTIME and performance
>---------- From: satriguy@aol.com[SMTP:satriguy@aol.com] >Sent: Tuesday, February 24, 1998 2:10 AM >>I have been asked to check the performance differences between USEOSTIME >>on and off. I expected the that there would be a slightly better >>performance (4-5% according to m…
Re: USEOSTIME and performance
SaTriGuy wrote: > > >I have been asked to check the performance differences between USEOSTIME > >on and off. I expected the that there would be a slightly better > >performance (4-5% according to manual) with USEOSTIME = 0/No. This > >isn't the case on the tests done, in fact i…
Re: USEOSTIME and performance
>I have been asked to check the performance differences between USEOSTIME >on and off. I expected the that there would be a slightly better >performance (4-5% according to manual) with USEOSTIME = 0/No. This >isn't the case on the tests done, in fact it is exactly the reverse. …
Re: USEOSTIME and performance
David Williams wrote: > > In article <34EAD1EA.218B@mcmail.com>, Paul Watson <watson@mcmail.com> > writes > >I have been asked to check the performance differences between USEOSTIME > >on and off. I expected the that there would be a slightly better > >performance (4-5% accordin…
Re: USEOSTIME and performance
In article <34EAD1EA.218B@mcmail.com>, Paul Watson <watson@mcmail.com> writes >I have been asked to check the performance differences between USEOSTIME >on and off. I expected the that there would be a slightly better >performance (4-5% according to manual) with USEOSTIME = 0/No…
USEOSTIME and performance
I have been asked to check the performance differences between USEOSTIME on and off. I expected the that there would be a slightly better performance (4-5% according to manual) with USEOSTIME = 0/No. This isn't the case on the tests done, in fact it is exactly the reverse. With…
Re: Instance dates
julian.richards@orange.co.uk wrote: > > I am working on Y2K issues and i am thinking of trying to run multiple > instances at different dates on the same platform. > Does anyone know how the date is derived and if it possible to remap the > command. The engine determines the cur…
Informix on Linux?
I noticed somewhere that Informix DB server runs also aon Linux. Is that true? And if how to configure Informix & Linux? thanx Damijan…
RE: Time measurements
---------- From: Billy Wheeler[SMTP:billy@west.co.za] Sent: Wednesday, January 28, 1998 4:59 AM To: Georg Winkens; informix-list@rmy.emory.edu Subject: Re: Time measurements >On 28 Jan 98 at 10:03, Georg Winkens wrote: >> Does anybody have experience in doing time measureme…
Re: Time measurements
On 28 Jan 98 at 10:03, Georg Winkens wrote: > Does anybody have experience in doing time measurements for SQL > queries that take less than 1 sec.? > > I have a SQL script with a sequence of select statements and I would > like to know the elapsed time for each of the statements…
Re: Upgrading Informix from Online engine to Dynamic Server
Seth Grimes wrote: > > Jane Vohden wrote: > > > > I have been talking with Informix about upgrading our site from the > > 5.xx Online engine to 7.2x Dynamic Server. They said there was no cost > > I don't think that anyone has pointed out the mistaken terminology > h…
What's the difference between ODS 7.22 and 7.23?
What's the difference between Informix Online Dynamic Server version 7.22 and version 7.23? Thanks in advance. Bill Westphal Rodney District Council mis@rodney.govt.nz…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
DS_TOTAL_MEMORY configuration
We are trying to configure our instance of Informix ODS 7.23 to support pdq. Using the default DSS parameters (DS_TOTAL_MEMORY and DS_MAX_QUERIES are blank), we get 208 errors when running queries with aggregate functions and PDQPRIORITY>1. Our first guess was to increase DS_TOT…
Re: Onperf
Set up the sampling frequenzy in the menu Configure -> Onperf Configuration -> Data Collector Options -> Sample Interval Regards, Roland…
Onperf...
The hyperhelp usefully says: " To configure the buffer depth or the sampling frequency, you must use the edit configuration item in the graph tool. " Hmmm.... :-) -- Ciao, Billy Nose to the ear in Dubai, home of sun, fun and 100% humidity... For a good time, call: http://ww…
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: value for TODAY
Cosmo Lee wrote: > Hari Muthuswamy wrote: > > Where does Informix gets the current date. Does it get from the > > Operating System? > > For example, > > from DBACCESS, when I run a statement like > > 'Select * from today' where does Informix get the date for > > 'tod…
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…
INFORMIX SCO ON REDHAT 4.1
Hi, how do I configure RedHat 4.1 to run INFORMIX ONLINE 5.1 (for SCO) ? Thanks in advance to anyone's trouble. Manuel…
INFORMIX (SCO) on RedHat
Hi, how do I configure RedHat 4.1 to run INFORMIX ONLINE 5.1 (for SCO) ? Thanks in advance to anyone's trouble. Manuel…
Machine Configuration
Hi everybody. We have a version 7.20 of Informix OnLine Dynamic Server on a DEC 2100 with 3 CPUs, 1 GB of RAM and 60 GB of Storage Array. Everything is OK, but we want to find the best configuration for the disk array. We have 2 disks array of 30 GB each, on 2 different control…
Machine Configuration
Hi everybody. We have a version 7.20 of Informix OnLine Dynamic Server on a DEC 2100 with 3 CPUs, 1 GB of RAM and 60 GB of Storage Array. Everything is OK, but we want to find the best configuration for the disk array. We have 2 disks array of 30 GB each, on 2 different control…
Re: Setting Unix System Time fools Informix
Greg McClure wrote: > > We are running Informix 7.20.UC2 on two DEC Prioris machines running SCO > 3.2.5.0. We are running with DRAUTO=2. Normal state is one machine On-line > Primary, the other Secondary. When we change the time on one of the Unix > boxes, Informix decides to ma…
Re: HELP! YEAR 2000 BUG: How will it affect you?
Dave Wotton <Dave.Wotton@it.camcnty.gov.uk> wrote: >tom.kustner@emjay.com (Tom Kustner) wrote: >> >>The year 2000 *is* a leap year. >> >>If you still have doubts, go to >>http://www.year2000.com/y2karchive.html and check the FAQ. >> >>Tom Kustner >> >> >This is just the last o…
Re: DATETIME fraction missing
Yahoo! fraction missing again :-) Billy's rite, provided that 1) you're talking OL 7+ (many of us are still stuck to OL 5 :-) 2) your os does actually support fractions ciao, Marco ____________________________________________________________________________ rem radioterapia, whi…
Re: DATETIME fraction missing
} From: Sood_Niraj/SO@instru.fi } Subject: DATETIME fraction missing } } We have a customer running Informix OnLine 7.01 on a HP800, = } } HP-UX 10.01. } } Their problem is that although a table field is defined as containing a } DATETIME including fractions, the fraction…
Help with configuration
Hi everybody, I am new using DSA. I am configuring the way in which i sould stablish the spaces for the databases.I have 8 disks of 2Gb for this . In 5.01 i used dbspaces and chunks. So the question is: There is another kind of way to hang data? The chunks sould be a partition of…
Re: CURRENT date precision
> > I'm using a DATE YEAR TO FRACTION(3) field as a key in a table. I'm not > > getting the precision I expect in the following statement: > > > > LET var = CURRENT YEAR TO FRACTION(3); > > > Firstly check your release notes. Not all platforms support sub-second precision. If > …
Re: CURRENT date precision
Kevin DeWitt wrote: > I'm using a DATE YEAR TO FRACTION(3) field as a key in a table. I'm not > getting the precision I expect in the following statement: > > LET var = CURRENT YEAR TO FRACTION(3); > > My var variable ends up with a precision to seconds only. No milliseconds! >…
Re: CURRENT date precision
Set the following FIELD in your Configuration File: USEOSTIME 1 This is for a 7.X engine. ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Da…
Re: Informix 4GL Bug Impacting Datetime Fields
The bug is now 3 digits on my AIX 4.1.4 OS system with Informix 7.12UC2 IBM RS6000: defined column tm_last_update datetime year to fraction(5) It value returned in one case: tm_last_update 1996-07-10 15:27:51.30300 -----------------------------------------------------------…
Re: Informix 4GL Bug Impacting Datetime Fields
On 8 Jul 1996 08:38:25 -0400, cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) wrote: >If you set the USEOSTIME=1 in your config file you could suddenly see the >fraction of a seconds appear. This config variable applies to 7.X engine. >The default is 0. In your orginal post Jam…
RE: Informix 4GL Bug Impacting Datetime Fields
Assuming your platform/OS supports it, you also must set USEOSTIME to 1, in your $ONCONFIG file. Jon ----------------------------------------------------------------------- Jon C. Vemo jvemo@cyberspace.com Bothell, WA USA ---------- From: marco greco[SMTP:marcog@ctonline.it] …
Re: Informix 4GL Bug Impacting Datetime Fields
If you set the USEOSTIME=1 in your config file you could suddenly see the fraction of a seconds appear. This config variable applies to 7.X engine. The default is 0. In your orginal post James you did not include what engine you are using. Hopes this helps! ---------------------…
Re: Informix 4GL Bug Impacting Datetime Fields
John H. Frantz wrote: > > James Fischer wrote: > > > > I came across an interesting problem that may be > > of concern to other Informix 4GL developers.<SNIP> > > The only tool available within 4GL to get > > the time of day is the 4GL "current" function, > > but don't expect to …
Re: Informix 4GL Bug Impacting Datetime Fields
Dennis J Pimple wrote: > > James Fischer wrote: > > > > The "current" function will never return a > > value other than zero for the fractional part > > Not true. It's not a bug; your platform is missing some math libraries required for fractional > seconds. I've written datetime…
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…
Informix-Net on AIX
We are having problems configuring Informix SE version 6 to work on a tcp/ip network with Win 3.11/Informix-Net for Windows 5.01. Any help concerning the configuration of /etc/sqlhosts file is greatly appreciated. Please reply by mail Thank you…
Re: Is your organization ready for the Year
The *real* problems aren't the RDBMS based data, and somehow I don't think running the U.S. gov't on 286's is the answer! The real problem is the poorly designed applications - primarily COBOL/IMS that only *stored* 6 digit dates in PIC format ( or some such nonsense ). ;^} Th…
Re: YEAR 2000 SOLUTIONS CONFERENCE -- CALL FOR PAPERS (long)
Did you hear the news? On Sat, 25 Nov 1995 16:41:14 -0700 (MST), our ether buddy Roy Hann <rhann@nisku.blackgold.ab.ca> spaketh thusly: :)On Mon, 20 Nov 1995, Peter Zuckerman wrote: :)> * * * * * CALL FOR PAPERS and PRESENTATIONS * * * * * :)> :)> :)> …
RE: Datetime display
I believe there are two things to look at. First, the precision your are requesting, I believe, is not supported all platforms. Check the $INFORMIXDIR/release files. Secondly, and this turned out to be the case on my platform (Sequent), in your $ONCONFIG (assuming your using OnL…
Re: displaying date/time in SQL
Trish, You might try adding the following statement before and after your test select: SELECT current FROM systables WHERE tabid = 1 The "SELECT current" portion will return the current time. The "FROM systables..." is a trick used to select the time once and only o…
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?…
config.manag.tools wanted
We are currently evaluating - Intersolve PVCS - Softool HCC/Harvest as possible tools for our Configurations Management. Does anyone know about them in Informix environment? Does anyone know of any similar tools/packages for Configurations Management? All help appreciate…
Re: Informix 4.x problems with SCO Unix
Greeting. I would verify that Informix is using EXACTLY the same configuration of your machine. I have had a problem where they had a different configuration and it worked for them. Hope it helps.…
Re: HP9000+LVM+Online
There is no problem using LVM with Informix, either raw or cooked. As you can see from previous posts, it is in use and it has been tested extensively. As always, depending on your specific configuration ( including kernel, LVM, and Informix configuration) the performance chara…
Re: Encina Transaction Processing
With this mailing list it's similar to the Tuxedo mailing list - the host imc.com is not reachable. There is no entry in the nameserver. Please check your configuration! thanks Bergler Heimo Ungerdorf 116 A-8200 Gleisdorf E-Mail: heimo@softline.co.at…
Sizing/Configuration
Hello all! There was a discussion going on within the walls of our office the other day about how to plan/size systems for implementation of Informix databases and products. Some of these considerations include 3-rd party software for which we are a VAR, but most especially …
Basic Configuration?
Hi all, I'm going to use Informix on Sun SPARCserver 670 model 120. I like to get more information about basic configuration (like memory requirment) and ref site. So if you are Informix users on Sun, Could you please give me your configuration information and what type…