Oninit® Archive
Results for “DBSERVERALIASES”
kill idle session
database sysadmin; select sid, username, dbinfo('UTC_TO_DATETIME',connected) conection_time, current - dbinfo('UTC_TO_DATETIME',connected) connected_duration from syssessions order by 4 desc,2,3…
Unexpected RSS authentication failure for 'leap16_2_c_tcp' during the Initialization Phase.
If HA_ALIAS is set and DBSERVERNAME is set to the relevant TCP connection and all onmode commands use the same setting as the HA_ALIAS then the issue is transient due to locking on a specific table as reported in the message I placed above when starting more than one HDR / RSS ar…
IDS 14.10.FC13 compatibility with other Informix tools
If you use sqlhosts with the CSDK then either use 4.50.12 or wait for the new version 4.50.14 tentatively scheduled for release a week from today. Using CSDK 4.50.13 and above with sqlhosts will return an Error -79716. ------------------------------ Daniel Karwatka -------------…
DRDA redirection to HDR primary
Hi Gerd. Could you share your connection string to CM? I'm trying to connect via JDBC (ifxjdbc.jar). Thanks, ------------------------------ Victor Huaquisto Email: victor.huaquisto@gmail.com Lima-Perú ------------------------------…
oncheck warning,What impact will it have on the future?
Ok, I make sense. Althrough I can't see that parameter in ONCONFIG, but it really exists with default value. ------------------------------ chuan lu ------------------------------…
Cannot connect to Informix database via Python
Yep, 30081 I know as DRDA connection error (https://www.ibm.com/docs/en/db2/11.5.x?topic=errors-sql30081n-tcpip-communication), which is quite expected if there's no DRDA port/listener configured. -> you'll need another listener (DBSERVERALIASES entry) in your onconfig and a rela…
Large memory segment vs smaller ones
No ONCONFIG changes are required. ------------------------------ Doug Lawry Oninit Consulting ------------------------------…
HDR Issue
Hello Boycho , Thanks for your reply. Changing hostname with IP Address in SQLHOST file worked. Looks from Unix level hostname not taking the IP Addressing. Thanks again. Regards Amit Patel ------------------------------ AMIT PATEL ------------------------------…
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 ------------------------------…
Error -25546 in connection manager 4.50.FC10
Milan, It seems to me the right place for 'SQLHOSTS LOCAL' is outside CLUSTER definition, i.e. just after LOGFILE. Does CMALARMPROGRAM react on the error? If so, what does it output? ------------------------------ Sincerely, Dennis ------------------------------…
Question of dostats
Thanks Art. Another question, Is TCP connection preferred to other type of connection (e.g, shm, ssl, ....) for running dostats ? Thanks Frank…
Informix HA Cluster and CM
Thanks so much David, that clears many of my questions. From what I have read on the CM, it only routes the connection request. It uses its local sqlhosts file to accommodate the connection or any sqlhost on the primary instance or HDR. The next question is. My current single i…
Replication of Informix
Gerd I don't believe that matters. If you wanted to keep your HDR traffic separate from your user traffic, an option would be to create the HDR connection with an INFORMIXSERVER setting defined as part of DBSERVERALIASES and operating through a different port. Koonjul, Is port 16…
restore through STDIO
HI, ifxclone can change the onconfig on the target instance E.g. it will turn off DIRECT_IO and can also change bufferpool entries! Regards, David. ------------------------------ David Williams ------------------------------…
JDBC & TLS/SSL
Yes the SSLCONNECTION=true is required regardless of using the SQLHOST file. The driver looks to this parameter to setup the TLS to make the connection. It does not look at the SQLHOST protocols for this purpose. The point is valid that if the SQLHOST file has enough information…
Problems with temporary dbspaces
Hello, Change the DBSPACETEMP entry in onconfig file , separated them with semi colon (;), instead of comma (,). Rebounce ids, and see whether the error disappear. Hope it works -Fauziah-…
ontape does not finish the backup: tape full
TAPESIZE in the onconfig set to zero? Backups to disk running into a tape full and asking for a second tape should not happen. Hal Maner M Systems International, Inc.…
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…
Phys Log Size Inconsistency?
Disregard. I confused the ONCONFIG parm with the actual phys log. Forgot to actually run onparams! My total bad. DG…
RSS: Different # CPUs?
Those were my thought exactly. But, was uncertain whether RSS required identical settings in ONCONFIG as the primary. Thank you. DG…
Connection Managers not forwarding connections
Hi, We had an upgrade for the whole informix cluster and after bringing up all the servers , couldn't resync HDR with primary because it was always causing checkpoint blocked on the primary. Afterwards, I noticed that the connection managers aren't forwarding traffic, restarted t…
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…
onmode bug discovered (-wf)
Don't believe in a bug here. When starting the server he knows about the onconfig-file from the environment variable ONCONFIG. If you change this variable when the server is running it will not know the new value. Assuming that variable is only read once during the startup of th…
Re: 12.10.FC9 1809 Error
The sqlhosts file ol_serv onipcshm 192.168.1.2 on_servername ol_serv_tcp onsoctcp 192.168.1.2 9088 - The parameters DBSERVERNAME, DBSERVERALIASES, SECURITY_LOCALCONNECTION and NETTYPE # DBSERVERNAME - The name of the default database server # DBSERVERALIASES - The list of up t…
Connection Refused
Dear colleagues: I have the following problem: My PC has a 64-bit Windows 10 installed, and I have an Informix 7.31 TD6 engine installed, which works perfectly. I also have the SQL Editor installed, and it connects without any problem to said engine. As I also have to run a 16…
Does DBD::Informix support SSL connections ?
Does DBD::Informix support SSL connections ?…
HDR is not working
Post your last 30 lines from C:\\\\Connection_Manager\\\\tmp\\\\cm.log and your Connection manager sqlhosts…
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.…
Re: HDR Question
Do you mean to put the ip in the /hosts file instead of the server name? Or are you talking about /etc/services file where I have the DBSERVERNAME and port?…
HDR Question
Hi, if you have serverA as the primary and serverB as the secondary. For the Services file configuration, do you just need one entry on serverB that says what port serverA can communicate on or do both servers need an entry in their services file. So, it would be: name from DBS…
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…
keep-alive in sqlhosts
Hi all, we have the problem that longer lasting remote client sessions on informix databases are interrupted by the firewalls, particulary when no packets were sent. It's possible to configure the port on the firewall to extend the time before the connection is interrupted. The …
Creation of another IDS instance
Dear All, In my CentOS 7 linux server we installed IDS 12.10FC8. Now we need another instance for another database project. How to do this. I am very new to Informix. 1. What steps need to follow. 2. What are the prerequisites. 3. How to differentiate both configuration files l…
cdr autoconf serv failed...
... > make sure s1 and s2 are the servers' main names (DBSERVERNAME rather than any of DBSERVERALIASES) ... That was the reason. But in ER Guide I read only: "...Verify the format of the sqlhosts file. The network connection (not the shared memory connection) entry must be immedi…
Connection Manager for HDR in Windows server
Thanks Mr.Art But still little confusion. On the host of each client application, create an sqlhosts file entry for each service-level agreement (SLA) in each Connection Manager configuration file. My SLA is sla_1, which is configured in the connection manager cmsm.cfg file. n…
OAT is not connecting to database server
I am giving the fully qualified hostname. but not connecting…
ROOTDBS file
I did not find the AUTOLOCATE parameter in onconfig file as well as onconfig.std file also. Im using IDS 12.10 FC8 version…
Rebuid sysmaster database and effects in a HDR/RSS
Actually I created the hosts.equiv file on both servers contains the hostname and user of opposite server. But the connection is not establishing. I unable to connect through DBACCESS to other server. It is promoting for username and password. So i think trusted connection is no…
Update Statistics
what kind of things could I check in the onconfig file. They are working on getting me IBM technical support help, but that will be a few hours away.…
HDR Implementaion
Please give the detail steps for trusted connection of hosts…
Connect informix using Active Directory account
We are using sssd with ldap here , not sure if my sqlhosts entries are correct.…
HDR Cannot connect
I think I found one issue. From the literature: DBSERVERALIASES must not include uppercase characters So that means my newserverS is no good. I thought that is what Lester used in his webcast, but I must be mistaken.…
sqlhosts file
Pretty much, yes. Sometime folks will put an entry for the shared mem connection name for the other system with the TCP details. Art On Apr 25, 2017 14:58, "BENJI LONG" <ruggedmouse@hotmail.com> wrote: > For the sqlhosts file, if you have two servers (primary and secondary for…
IDS 12.10 - Query Slow
Hi, I means value on onconfig 12.10 same or better than value onconfig IDS 11.10. i don't copy onconfig file and put on IDS 12.10. I already rebuild of your statistics is highly. We don't have performance issue for overall our system, only a few program, especially program runn…
DBSERVERNAME in an HDR environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary server or they must be diferent ? I asking this because I have synonyms in and external server pointing to the primary server, but in the case th primary fail and the secondary be…
DBSERVERNAME in an HDR Environment
Hi, In an HDR Environment, the DBSERVERNAME of the primary server must be the same of the secondary or they must be differents ? Thanks in advance.…
DBSERVERNAME Best Practice Pri/HDR/RSS
Are there any suggestions related to best practices for naming the DBSERVERNAME in a Primary/ HDR/ multiple RSS cluster? Would it be ok have the exact same DBSERVERNAME for all instances in the cluster i.e. PRI / HDR / and multiple RSS servers? Then use separate names for HA_ALI…
RSS INSTALLATION
Wat should I put on dbservername and dbserveralias ?…
ON-Bar database server is dismissing the logical
Thanks Art and Martin. IDS bounce worked as onconfig was changed for LTAPEDEV earlier. Thanks, ~ Pravin Bankar…
Reports making Informix to hang
Hi, Sqlhosts does not exist in Widnows, it's located into regedit of Windows, in the Sqlhosts of regedit, I have as follow: Sqlhosts directory and under that I have: INSTANCE_NAME and under taht I have these parameters: Host: ip_adress Protocol: onsotcp Service: Instance name r…
Re: jdbc connect to cluster
sqlhost part : ifx_lab_ps group - - c=1,e=ifx_proxy_ps_2 ifx_proxy_ps_1 onsoctcp lab-informix-0004.xunta.local 9095 g=ifx_lab_ps ifx_proxy_ps_2 onsoctcp lab-informix-0005.xunta.local 9095 g=ifx_lab_ps…
DBSPACETEMP Parameter
Hi, The DBSPACETEMP Parameter in onconfig file create automatically the temporally dbspaces ? Or They must be created with onspaces utility. Thanks in advance.…
jdbc connect to cluster
https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.jdbc_pg.doc/id s_jdbc_048.htm for example jdbc:informix-sqli://INFORMIXSERVER=g_primary; SQLH_TYPE=FILE;SQLH_FILE=sqlhosts; USER=my_user_name;PASSWORD=my_password; INFORMIXCONRETRY=2;INFORMIXCONTIME=10;LOGINTIM…
is it possible to change server name on the sqlhos
Hi, I have multiple instances and one of the instance require to change IP address (I.e. cluster package ip) on the sqlhosts file. Is it possible change sqlhosts file at the time other instance online? Verision: 11.50 HP-UX Thank you --001a113fbc0e4fda99052e5608e7…
DBSERVERALIASES entries not displaying correctly
I added two new entries to DBSERVERALIASES ( both wtn_* are new). They were also added to /etc/services and sqlhosts. I restarted the instance after this. The Informix client would not connect to the wtn_ connection. Upon doing 'onstat -c | grep -i dbserver' I do not see the 'wt…
Sqlhost entry on the client server
Hi All, I have two client server and one database server. In the database server sqlhost file defined as db1 onipcshm serverA sv db1.1 onsoctcp ServerA sv db2 onipcshm serverA sv1 db2.1 onsoctcp ServerA sv1 etc/services sv -750 sv1 -7002 Client A db1 onipcshm serverA sv db1.…
Instances not starting after installing 64 bit sql
Thanks Keith, Is there any other workaround to keep the existing instances and corresponding databases? Does creating a new mount point for installing IDS as the INFORMIXDIR could help (with onconfig file, sqlhosts, etc) from old directory? Regards, Sameer…
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…
BTS fails after ontape Restore
Hi Mark, Backup is done by 'ontape -s -L 0' Restore was done with 'ontape -r' No extra special parameters. And as I was typing this email, I was collecting the appropriate BTS-related lines from the 4 onconfig's in play (we use a special 'backup' onconfig for ontape). Lo and b…
RSS and SQLHOSTS groups
Hi, We are running Informix 11.70.FC7 on Solaris. We tried using groups in the SQLHOSTS file to connect to an RSS server though we received the error below. Aside from using the connection manager, is there a way to use something similar to groups so that if an application alway…
RSS DBSERVERNAME
Good Morning, We are running Informix 11.70.FC7 on Solaris. Is there a best practice recommendation when setting up RSS on whether to use DBSERVERNAME or DBSERVERALIASES for the communication between the primary and RSS nodes? I recall at one of the IIUG Conference sessions som…
Trusted Connection
Hi everyone, How do I create a synonym in a Server that runs informix 11.7 FC7 on HPUX itanium pointing to a table in a Linux distriubution with informix 11.7 FC7? It always gave me a password error. Thanks André Luiz Rufino…
Root db space fills up
as metioned above, maybe you need set TEMPTAB_NOLOG in you onconfig file…
Error Message in online.log file
Hi André. What setting do you have for ALRM_ALL_EVENTS in the $ONCONFIG file? I have found "alarmprogram.sh" can loop if set to 1. Regards, Doug Lawry…
Connection Manager
Started Connection Manager successfully. It is pointing to 2 servers (Primary/Secondary HDR). I log into the secondary server and run 'onstat -g cmsm'. It shows me the connection manager name/version, cluster name, even failover arbitrator/order/timeout details. It completely lea…
SQLHOSTS for HDR
What are the benefits to defining groups in sqlhosts for an HDR pair? I have had some issues with multiple instances (each with an HDR secondary on a separate server) where I left the group definitions out and came across some unexpected behavior when dealing with failover. After…
RSS not working
Fee disk space on the chunk partition ok on the RSS server? Can you post your onconfig?…
Setup HDR
Sounds like the onconfig has the same STACKSIZE but what both servers read in at initialization is different. Bounce both servers and see if it's fixed.…
Physical Log size 2000 is too small
Hi, the onconfig we are using is from a inf version 9.7 wherein no PLOG_OVERFLOW_PATH located in it. I tried adding it to the onconfig and put a location but the inf instance when restarted still always fails. As for the onmode command we are always using onmode -ky maybe it's b…
ERROR doing ontape
Thanks for your response! So, is it possible to create a new dbspace then set it in $ONCONFIG and restart the instance? best regards…
virtual segment question
Did you try to increase the number of locks in the LOCKS parameter in Onconfig? Lloyd…
ontape error message
Increase the value of TAPESIZE parameter in onconfig and try the backup. Lloyd…
Onconfig name
Hi, I am developing a JDBC application, and need to read from within SQL the onconfig environment variable. From with IDS 11.70, I can extract the need information using the query: select trim(env_value) env_value from informix.sysenv where env_name = 'ONCONFIG'; The code nee…
block connections sysdbopen
Hi, As I can block access to odbc connections within sysdbopen?…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Problmes using ontape with an IBM TS2900 changer
The TAPEDEV section in the onconfig is as follow: TAPEDEV /dev/IBMTape0 TAPEBLK 512 TAPESIZE 0 We have played with the TAPEBLK from 512 to 4096 to no avail.…
Sessions Connection Info
onstat -g env <sid> ?? > Hi, > > I am running Informix 11.70.FC7W2. We have 1 DBSERVERNAME and 3 > DBSERVERALIASES defined. How can I tell from the DB side which NAME the > sessions are connected to? > > --Dave > > --089e01493e161914c004e96f50f5 > > > ***************************…
VB6 connection string to ids 11.5 64bit failing
Thanks That resolved the issue. I created a 32 bit connection.…
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.…
How to set up temporary space per session
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger…
sqlhosts file
On UNIX, the sqlhosts file contains connectivity information that is loaded from the default location in $INFORMIXDIR/etc/sqlhosts, when the database server is started. My problem is, the sqlhosts file gets changed after the server is started, and I do not know where or how I ca…
Re: SLA Not Working with Kerberos Enabled Service
please take a look http://www-01.ibm.com/support/docview.wss?uid=swg21635513 that article explains how to use PAM DBSERVERALIAS, you can try the same way with 'csm' options, define support1 sqlhost options same as test1_tcp_1 in CM side sqlhosts file like support1 onsoctcp <cmh…
Connect 4GL to Informix Server
Thanks. I have my sqlhosts file in both, 4gl programs and informix server: ol_resp onsoctcp 192.168.1.122 ol_service…
recover SQLHOSTS file
Hi, We have Informix Dynamic Server Version 9.40.FC9 running on HP-UX B.11.23. We have 21 instances running on the server. All of a sudden the SQLHOSTS file has turned to zero size (not sure how), all the entries are lost. we are not able to access any of the databases. Is there…
Server Install Weirdness:
You need to change your SQLHOSTS entry to use the IP address of the host and then restar your Informix server.…
How to connect Java/JDBC with Connection Manager
Thanks for the help, please also tell me that if this sqlhosts path is the file path at the client environment side (i.e. in my case windows path, where I need to create an identical sqlhosts) or it is the sqlhosts path at the Informix Server side i.e. $INFORMIXDIR/etc/sqlhosts? …
Auto Update Stats
Hi, I have one more query. I have the below entries in onconfig file for AUS AUTO_STAT_MODE 1 STATCHANGE 10 USTLOW_SAMPLE 0 Now all my tasks(mon_table_profile,Evaluator and Refresh) running fine at scheduled time. Now when I remove the above entries in onconfig file, still al…
cant access DBSERVERALIASES
IBM Informix Dynamic Server Version 11.50.FC9 Linux wldbt633 2.6.32-358.2.1.el6.x86_64 #1 SMP Wed Feb 20 12:17:37 EST 2013 x86_64 x86_64 x86_64 GN U/Linux can anyone help please I have set up a DBSERVERALIASES but cant connect to it entry in $ONCONFIG DBSERVERALIASES dbt633_ec…
test connect
Hi All, Is there any other alternative select statement just to check the database connection?. I'm doing "select count(*) from systables". IDS 9.4 Solaris 5.7 thank you,…
Modify dbservername on a online informix 11.70 ser
Hello I need to change dbservername and dbserveralian in a online informix. Is there some issues documented? Is there anything in the rootdbs about dbservername? I have been thinking about to follow this stages: Shutdown database Modify environment variables Modify onconfig …
Invalid ASF API parameters
The port number is defined in the sqlhost file…
DB_locale or local naming convention
Hi, I already mention the informix version. IBM Informix Dynamic Server Version 11.70.TC1IE…
Connecting to a remote server
Something else interesting: I can connect as callj from the client if I connect explicitly to the ksotinfx01 server, and put my password in.…
Page size
Where do you set the page size when configuring Informix? I don't see it in the ONCONFIG anywhere.…
Re: manually edit onconfig?
You should never install the new version over the current one. If something goes wrong in the upgrade you'll have much more work to recover. Regards On Mon, Dec 17, 2012 at 6:38 PM, June Nebab LKINY <jnebab@gmail.com> wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. I…
RE: manually edit onconfig?
I would give a try to the new onconfig_diff utility, it seems to help you identify and correct some of them.... Check it out! https://www.ibm.com/developerworks/mydeveloperworks/blogs/idsteam/entry/how_to_use_the_onconfig_comparison_tool_onconfig_diff3?lang=en Regards. Alexand…
Re: manually edit onconfig?
I'm a big fan of copying the current settings into the new ONCONFIG file. It gives you a good chance to see the new parameters, like those you mentioned - all of which were available in 11.70.xC5 BTW, so someone used an older ONCONFIG instead of editing the new one last time. By…
Re: manually edit onconfig?
Figure out what each of the new ones do, whether you want to use them or not, then add them to your old onconfig. Ideally on a test environment. j. On Dec 17, 2012, at 1:38 PM, June Nebab LKINY wrote: > Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version o…
manually edit onconfig?
Planning an upgrade to 11.7UC6GE from 11.7UC5GE. Installing new version on same $INFORMIXDIR and on same server. I noticed new onconfig params (ie: AUTO_READAHEAD, NUMFDSERVERS, etc) that are in the UC6GE onconfig.std that are not in my $ONCONFIG. What is the proper way to dea…
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,…
SQLHosts File
Hi I've trying to find out the effects/impact of changing the SQLhosts file on a running engine. Background. I have a live running engine on a server and want add a second instance to undertake some testing. Obviously this will need entries in the SQLhosts file, can I make these…
Same server name on the same host
Version : ids 9.4 Can I set up 2 instance which has the same server name ? What if I set 2 different SQLHOSTS files ?…
Error # 40002
Also set AUTO_REPREPARE 1 in your $ONCONFIG file. Regards, Doug Lawry…
sqlhosts setup enterprise replicatiion window - un
thanks for that Art I had missed out an entry in sqlhosts in registry. Replication now working between windows and UNix servers. Now managemnet tell me to try Informix on Linux !…
Re: help with informix on windows oncheck -pr erro
I have changed DBSERVERNAME to lower case name and stopped insatnce NOw it wont even start. Get no messages at all in log tried starts <name> from command line and also tried starting services from services menu any ideas anyone?…
help with informix on windows oncheck -pr error
IBM Informix Dynamic Server Version 11.50.FC9DE I am installing informix on windows for first time / I assume oncheck performs ok on windows as on Unix. When running oncheck -pr i get following message. > C:\\\\Users\\\\oliverk-admin>oncheck -pr Invalid character(s) in DBSERVERN…
Full db restore from 1 server to another
Thank you. I was able to resolve this issue. The problem is that, i commented out the sqlhosts parameter pointing to the machine1. both machine1 and machine2 should exists in sqlhosts. REgards,…
use of connect statement
Version 11.5 FC8W2 on Linux Does anyone know of a way to prevent a user from using the CONNECT statement to connect to the database as another user? The users are connecting using dbaccess. I've limited the menu options on dbaccess so they can't use that to change users, but th…
SQL query involving multiple IDS instances
Just added the entrance to $INFORMIXDIR\\\\etc\\\\sqlhosts refered to the other instance and the service in /etc/services and worked like a charm. Thanks a lot mates!…
doubt about parameters (PDQ)
Sorry people, I meant the MAX_PDQPRIORITY 100 onconfig parameter.…
client connection to a multi connection manager sy
Thank, Just a couple of questions. What does this usl section indicates??? "SQLH_TYPE=FILE;SQLH_FILE=/informix/sqlhosts" Does this mean that the application has to go to the sqlhosts file to get the hosts addresses ????…
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…
dotnet and connection manager
HI, A partner write the application using dotnet. currently they use HDR on IDS11.50 FC8,but they don't use connection manager. Do anybody know whether connection manger could reroute the connection request from DOTNET? thanke for your time.…
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 …
HDR not working
Thanks for input Looks like trusted connections are the problem. Working on solution. Rgds Derrick Muller…
NOFUZZYCKPT: onconfig parameter or environment variable?
Is NOFUZZYCKPT an onconfig parameter or an environment variable? Is there any definitive documentation? Still running IDS 10 on Linux.…
Testing the 'free' versions - moving from Dev edition to Innovator-C
Art, thanks - I've gone for the separate INFORMIXDIR install (just had to change $INFORMIXDIR, $PATH and some paths in $ONCONFIG) and it's come up just fine.…
Spatial Data
hello reading thru the manual states that the ONCONFIG parameters for SBSPACENAME and SYSSBSPACENAME must be set for the default sbspace. We are running an HDR pair and have the parameters set on the Primary Server - does it also need to be set on the Secondary Instance ? thank…
Connection Manager
I have setup an RSS server but I am having problems getting it working properly with Connection Manager. Here is what I am running. IDS 11.70.FC4GE CSDK 3.70.FC4DE ServerA - Primary server ServerB - SDS ServerC - RSS The connection Manager config file is - NAME conn_man LOG 2…
Enterprise Replication Problem
hi Hard to say whats going on. anyway if you have not done so already ,for the 3 servers to talk to each other you need to have entries in all sqlhosts files for the servers. So in sqlhosts file for A you need to have entries for B and C for host B the sqlhosts file has to have e…
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…
HDR setup- Network driver system error
nike_SP is a shared memory connection and hence not in /etc/services Is repeating DBSERVERNAME in DBSERVERALIASES an issue or just not good practise. I have repeated this in the past and the HDR has worked correctly. Not sure what I am missing or where the mismatch is in this s…
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.…
Problem with .net
Hi, I try to connect with iLogin and winsql(i run scripts from winsql) Both clinents correctly connects to db, i can modyfy tables, procedures etc. The firewall isent problem, i try to connect from localhost, so network settings arent problem(I hope they arent:)…
ontape -p/r with changed ROOTPATH
Jack Parker Wrote: ================================================================================ Not sure if you noted that you also need to change your $ONCONFIG = ROOTPATH to point to what is on the backup image. j. ==========================================================…
need refresher on DBSERVERNAME/ALIASES/NETTYPE/SQL
Hello, Please point me to a good refresher document about setting INFORMIXSERVER and it's relation to DBSERVERNAME/ALIASES and relation to NETTYPE and relation to SQLHOSTS... the system i have inherited seems to have all users log in to the onsoctcp connection instead of shared…
ER errors after 11.7 FC2 upgrade
I've found the root of the issue. It was entirely usage of a shared memory connection vs the DBSERVERNAME value, which is something we were advised to do years ago by a consultant. Making this be a tcp connection instead made the entire issue go away.…
How to test conection from Windows PC to Linux ?
Protocol is "onsoctcp". Service is the port number corresponding to the service name in the sqlhosts file. Art On Mar 23, 2011 7:24 PM, "HERNANDO DUQUE" <hduquec@hotmail.com> wrote: --bcaec50160c7000ca5049f312df7…
JDBC Connection Problem
On Mar 11, 3:41 pm, Mark Jamison <maj...@me.com> wrote: > Localhost is your likely problem > > JDBC is not resolving the sqlhost entry. > > Best solution would be to either use your machine name or a * > > I used to run into the same problem on my MacBook pro Thank you for the h…
question about Query with joined view
Have you tried "IFX_FOLDVIEW 1" in your environment or $ONCONFIG file? Regards, Doug Lawry…
IDS Error: CDR DEFINE SERVER
Hi, My sqlhosts is OK now. I rebooted the instances and tried again, but the error continues. Have any idea? tks, Hugo…
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…
informix dropping idle connections
Cesar this script appears to kill idle unix login sessions not database connections…
How to change database instance name
On Mon, Nov 22, 2010 at 06:40, ANDREW LEMIN <a_lemin@hotmail.com> wrote: > I have done a search on this and I can find how to change the name of the > database engine in Windows (there's even a tool to help), but how do you > change > the database instance name on a Linux setup?…
sqlerr:-243 and isam err:-111 in esql/c
This "may" be a good place for USELASTCOMMITTED set to all in the onconfig.…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
Re: Connecntion Manager x DBSERVERALIASES
On Mon, Oct 18, 2010 at 3:13 PM, Cesar Inacio Martins < cesar_inacio_martins@yahoo.com.br> wrote: > Thank you Jonny! > I test this parameter on xC7 and don't work.. let's wait for xC8 .. > > Regards > Cesar > > Cesar, test it on 3.70.xC1... It should be there. -- Fernando Nunes…
Re: Connecntion Manager x DBSERVERALIASES
Just a correction, The CM isn't to smart like I said. They appear be capable to identify listeners of localhost and not try do redirect client connection to them . But about not redirect to services / network what the client ins't capable to use, isn't true. I execute a new test …
Re: Connecntion Manager x DBSERVERALIASES
Just a correction, The CM isn't to smart like I said. They appear be capable to identify listeners of localhost and not try do redirect client connection to them . But about not redirect to services / network what the client ins't capable to use, isn't true. I execute a new test …
Connecntion Manager x DBSERVERALIASES
Hi, csdk 3.50 xC7 ifx 11.50 xF7 - Linux. I got a issue here to configure the Connection Manager over a HDR cluster and theirs DBSERVERALIASES. On the configuration of the two instances, exists some aliases what not should be considered to client connectivity. I already notice…
Connecntion Manager x DBSERVERALIASES
Hi, csdk 3.50 xC7 ifx 11.50 xF7 - Linux. I got a issue here to configure the Connection Manager over a HDR cluster and theirs DBSERVERALIASES. On the configuration of the two instances, exists some aliases what not should be considered to client connectivity. I already notice…
Primary Slowness when RSS is active
You need to set LOG_STAGGING_DIR parameter in onconfig of the rss…
Memory Management
oh..also think around 300 threads connected to this database.…
Import restore issue
> I set the DBSERVERNAME and DBSERVERALIASES with the same names from > both servers. This will not work, the DBSERVERNAMEs will need to be unique to each engine. Why not set the DBSERVERNAME of the engine running on inftest1 to inftest1 and inftest2 on inftest2. After this is…
Can't access sysindexes remotely
Hi, We are using IBM Informix Dynamic Server Version 11.50.FC6 using Platform: SunOS 5.10 Generic_125100-09 sun4v sparc SUNW,Sun-Fire-T200 Thanks…
Re: RE: new onconfig parameters added onconfig fil
Typically, I make a copy of the onconfig.std, naming it something like cheetah_online. Then I open up both the old and new onconfig, side by side, and copy from old to new. Obviously, the new onconfig has new params that were not addressed in the old onconfig and may have elimina…
Re: RE: new onconfig parameters added onconfig fil
Isn't that what I said? "If you simply just bring up the instance using your old onconfig, I believe that you will get whatever the default is for the new parameters, even though you do not mention them in your old ONCONFIG." -----Original Message----- From: ids-bounces@iiug.or…
new onconfig parameters added onconfig file 11.5
hello folks Can any one tell me at what stage the new onconfig parameters are added to the onconfig file when upgrading from 11.10 to 11.5. I have converted two instances from 11.10 to 11.50 One onconfig file has the new parameters at the end of the file the other doesnt have any…
command failed -- Enterprise Replication not activ
Thanks for the response. I changed the sqlhosts files so g_cdrdev1 and g_cdrdev2 groups are defined on both servers. I ran the command: cdr define server --connect=cdrdev1 --init g_cdrdev1 the first time I got: connect to cdrdev1 failed INFORMIXSERVER does not match either DBSE…
Re: performance improvements for dbimport?
Thanks for all your valuable input. I changed some parameters now: 21:09:27 Onconfig parameter BUFFERPOOL modified from size=2K,buffers=262144,lrus=8,lru_min_dirty=5.0,lru_max_dirty=10.0 to size=2K,buffers=524288,lrus=8,lru_min_dirty=10.0,lru_max_dirty=50.0. 21:09:27 Onconfig p…
BACKUP_FILTER in onconfig
Hello, when I using BACKUP_FILTER in $ONCONFIG, parameter for "The tape block size, in KB, for backing up logical logs" is NOT LTAPEBLK, but it is TAPEBLK. Everything work fine (LTAPEBKL for logical log) when I turn off BACKUP_FILTER ... This is happening with ontape, with BAC…
Re: Two instances on same machine,conerr=-25592
On Mon, Feb 8, 2010 at 14:13, Ljiljana Zivanovic <ljiljana@mizuhocap.com>wrote: > > we are testing IDS 11.50.FC4 on SunSolaris 10. > > I am setting up two instances on the same machine and I have following > > connectivity problem. > > Server 1 > > SERVERNUM 1 > > DBSERVERALIASES…
Suspending HDR temporarily?
> So, do I need to also edit the sqlhosts file on the primary? But, then I would have to bounce the primary, right? (That's production, can't do that.) DG…
garbage text in SHMNOACCESS parameter
On Jan 21, 8:15 am, Ian Michael Gumby <im_gu...@hotmail.com> wrote: > Just a guess. What's the hex value for that string? > grep ^SHMNOACCESS onconfig SHMNOACCESS �����������" ������� grep ^SHMNOACCESS onconfig |cut -c17- �����������" ������� grep ^SHMNOACCESS onconfig…
Re: Imported Restore with TSM and 2 engines with same DBSERVERNAME
Yes. :) Only, you have to find the actual number (logical log unique ID) and pass it on the command line to the "onbar -r -l -n <#>" command. Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management IBM Deutschland Research & Developm…
dbaccess with onsocssl
Can dbaccess use an onsocssl connection? Running IDS 11.50.FC4 on hpux11.23…
Re: Imported Restore with TSM and 2 engines with same DBSERVERNAME
Martin, Thanks for the reply. Can I avoid this query by object_name by instructing the restore to stop at the last known logical log in the ixbar file? onbar -p onbar -r -l -n <last logical log in ixbar> Thanks, Andrew ----- Original Message ----- From: "Martin Fuerderer" <…
Re: Imported Restore with TSM and 2 engines with same DBSERVERNAME
Hi, yes, ON-Bar uses the CopyID fields (high and low) to ask the SM for backup objects, normally. This is why this CopyID info is diligently kept in the sysutils database and the ixbar-file (for cold restore scenarios). But I say "normally", because there is an exception: After…
Re: Imported Restore with TSM and 2 engines with same DBSERVERNAME
When performing a cold restore will onbar ask TSM for the unique storage manager object by supplying the copyid_hi and copyid_lo fields from columns 7 and 8 in the ixbar file? If so, that makes a lot of sense and would explain how onbar/TSM knows which /engine1/engine1/rootdbs/0…
Imported Restore with TSM and 2 engines with same DBSERVERNAME
IDS 10.00.UC5 I have a production Informix engine with a DBSERVERNAME of engine1 running on server1 backing up to TSM and I have a test Informix engine with a DBSERVERNAME of engine1 running on server2 backing up to TSM. Both instances have SERVERNUM set to 1. Does anyone know…
CDR connect error
Hi while trying to set up a new replicate and working on a very long queue (up to 80.000.000 length whatever) there appear connection errors in the message log: 17:26:57 CDR: Re-connected to server, id 5, name <grp_sun1> 17:27:19 CDR NIF receive failed asfcode: -25582 oserr 6…
ODBC - Database Locale Information Mismatch------W
Well, nevermind. I was using a created DSN-less connection in the app so configuring the ODBC connection did no good! I would still like to know how to set this (DB Locale) in the connection string, but the ODBC setting works...…
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…
RSS can only use DBSERVERNAME?
Prior to the 11 versions, HDR could be setup on a private IP or NIC and you can assign a connections listed in DBSERVERALIASES to handle HDR traffic between your servers. Now with RSS it seems like it only works with DBSERVERNAME and will not properly establish a connection if …
DYNAMIC_LOGS in ONCONFIG
Good afternoon, We occasionally have a programmer than needs a large amount of log space to move a very large table. Instead of fiddling with the HTXHWM and LTXEHWM in the ONCONFIG file, has anyone successfully setup DYNAMIC_LOGS with IDS 10.00 on HPUX? Where would the dynamic …
Unsufficient buffer size for error message
Hi Please check your online.log and check also your onconfig file. thanks.…
help:root can't logon "log mode ansi database"A
create database db01 in dbs01 with log mode ansi grant dba to root grant connect to root dbaccess using root 387 no connect permission i don't know why??please help??…
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…
server startup
Is this the way you have things configured? (I got this from your earlier posts): DBSERVERNAME ol_ids_1150_1 # Name of default Dynamic Server DBSERVERALIASES svc_drda # List of alternate dbserver names and sqlhosts has svc_ids_1150_1 onsoctcp host svc_ids_1150_1 The first col…
Connection Manager - restrict connections
Greetings all, In a world where multiple DBSERVERALIAS values exist, is there a way to restrict which ones the Connection Manager tries to establish connections through? As a brief example, If I have these values in the ONCONFIG file: DBSERVERNAME aspbeL1 DBSERVERALIASES hdr1P…
Re: Connection manager redirect
A Network error, because the client at the public network can't connect directly to the IDS server at the private network, it's for that reason we use the connection manager between them. We want to know if always the connection manager is used only to the initial connection to t…
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 …
connect through java using group_name con mgr
Hi Kamran Your connection manager log showed the client was correctly redirected to your primary at port 9202 which looked fine. Please check your JDBC version as suggested by Jinming. If your JDBC version is correct, you can try the following steps to isolate the issue. You s…
IFX SE processes
Note: I haven't worked with SE in a long time! I have a client's server that I'm trying to dbexport from 7.24 SE. I can't seem to get exclusive access. I see a couple root-owned processes writing to log files from boot time. Any chance these are ISTAR-like network listeners? One…
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…
oninit fails reporting problem with DBSPACETEMP
But in my ONCONFIG file, i have mentioned the tape device as STDIO…
How to connect database resides on different host
Thank u guys!! I am now able to connect to the database!!…
Informix IDE
What are my options for IDE's to connect to Informix both free and nonfree. I know there is Data Studio and Toad is able to connect. What do most users here use?…
TCP problem upgrade 9.40 to 11.50
Art I added a new nickname in the /etc/hosts 180.180.169.151 informix.orgrimmar orgrimmar loghost And Modified the sqlhosts with this nickname: pruebatcp tlitcp orgrimmar 1528 The instance is runnig...and online. I belive the problem is the dot in the name of de machine. T…
-25588 error after CPU & fiber channel failure
John, See if the app can connect if it uses the network connection (carsitcp) instead of the shared memory connection. Mike…
Changing TAPEDEV from script
sed -e 's/^TAPEDEV/TAPEDEV NEW-TAPEDEV/g' onconfig > onconfig.other export ONCONFIG=onconfig.other after finishing just set the ONCONFIG to your default and delete onconfig.other Sebastian…
Connection Pool
Hello everybody! I have been looking for this issue for some hours and I wasn't able to find anything. How can I use the connection pool for IDS 9.4? I'm developing in C# of Visual Studio .NET. Until now I have been using Oracle. And to use the connection pool, I only had to u…
slow connections
IDS 10.00.FC7 on AIX 5.3 on IBM P550 server Greetings fellow IIUGgers, I'm getting sporadic slowness establishing connections OR complete connection timeouts. Not sure what could cause such behavior, the server is 95% idle. Any recommendations where to look? I can provide other …
Re: Configuring IDS for multiplexing
does NETTYPE sqlmux place any limits on # of sessions/connections. The output from onstat -a shows max connections of 120 consistently. NETTYP tlitcp,3,250,NET should allow up to 750 connections.…
connecting to informix
I am trying to connect to Informix using an existing application with a field for a connection string. Using the ODBC driver works great, however I would like to use the .NET driver for performance reasons. Is there a way to specify the string use that driver instead of the curr…
onint - cannot open chunk error 2
Jon - Post or email me a copy of your user informix env., your onconfig file, and your sqlhosts file - are there other informix instances setup on this host? Mike…
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…
Syssessions connected
I am attempting to write something to cleanup all the disconnected sessions on my 11.10 server automaticly. 9.4 never had this problem but my problem now is, the sysmaster-syssessions.connected variable. Should show some sort of time yet it is an integer variable. I found it ful…
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…
IDS error -- onmonitor
Our OS is Solaris 9 Sparc. While compiling the information you requested, I examined the sqlhosts file yet again. The sqlhosts file created during the installation of IDS 11.5 looked like this: demo_ids ontlitcp FQDN.for.colostate.edu.machine 9088 I had initially created my own …
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.…
Connection Error
Hi Guys, I trying to connect to informix database with a specific user name. No trouble if I do it using login and password before I run dbaccess utilility. But, when I tried to do it using the connect option of dbaccess, and typing user name and password, enginne gaves me the …
replication on informix v. 7.31
> -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LINDA COLE > Sent: Thursday, May 15, 2008 6:44 AM > To: ids@iiug.org > Subject: Re: replication on informix v. 7.31 [12127] > > primary1 and secondary1 are the aliases for the i…
Re: connect && rename && connect
Thanks Radhika, but that doesn't fix the problem. I don't want to disconnect my current connection and I don't want to switch to a connection to the server (but I will have to!). I will report the bug, as soon as I know how to do it. Thanks Jonathan. On 5/6/08, Radhika Gadde …
connect && rename && connect
Why am I getting an SQLCODE == -425, ISAM error == -107? I haven't found anything in the online documentation about making an implicit connection when renaming a database. onstat -u doesn't reveal any other connection different from anydb. $ uname -a SunOS since 5.10 Generic_127…
Informix DRDA Gateway Issue.
Can you post the sqlhosts file from each machine? Mike…
connection ?
I'm trying to verify if a user is connected to the database by my shared memory connection ... is there a table or onstat that can give this to me. I've looked at the onstat -g env and that shows the proper INFORMIXSERVER, but I'm not sure if they connected that way or with the T…
JDBC Connection
I'm trying to connect to an Informix DB V7, using the jdbc driver. The connection string I'n using is; jdbc:informix-sqli://<HOST>:<PORT>/<DB>:INFORMIXSERVER=<SERVER_NAME> I'm not sure the info I'm being given is correct. I can ping the host. Where can I see what the DB and SER…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >> mosserp@wellsfargo.com wrote: >> >>>>> RESIDENT 0 # Forced residency flag >>>>> >>>>> >>>> (Yes = 1, No = >>>> >>>> >>>>> >>>>> >>>>> >>>> Don't know HP model numbers, but it this is a PA-RISC machine, you >>>> almost have to …
RE: onconfig recommendations
> mosserp@wellsfargo.com wrote: > >>> RESIDENT 0 # Forced residency flag > >>> > >> (Yes = 1, No = > >> > >>> > >>> > >> Don't know HP model numbers, but it this is a PA-RISC machine, you > >> almost have to set RESIDENT to -1 to prevent poor performance > >>…
Re: onconfig recommendations
mosserp@wellsfargo.com wrote: >>> RESIDENT 0 # Forced residency flag >>> >> (Yes = 1, No = >> >>> >>> >> Don't know HP model numbers, but it this is a PA-RISC machine, you >> almost have to set RESIDENT to -1 to prevent poor performance >> due to the >> archi…
RE: onconfig recommendations
> > RESIDENT 0 # Forced residency flag > (Yes = 1, No = > > > Don't know HP model numbers, but it this is a PA-RISC machine, you > almost have to set RESIDENT to -1 to prevent poor performance > due to the > architectures restrictions of only four active shar…
connection issues
Hi all, we are having issues with connections not being released timeously from the database. We are running IDS 10 FC5 on an HP/UX box. Users connect to the database over ODBC or via the informix native drivers on to an onsoctpc connection to the database. We either run into…
What is IPA abbreviation ?
Hi all IBM INFORMIX DYNAMIC SERVER 10.00 PRODUCT RELEASE bug_number 168928 description WITH NON-DEFAULT PAGE SIZE AND ACTIVE IPA'S, TABLE LEVEL RESTORES FAIL product_code ONUTILS component_code ARCHECKR What is IPA ? Thanks…
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
[Fwd: Re: onconfig recommendations]
Kennedy, Randy wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for given > platform. > > Current Server: HP rp5405 …
Re: onconfig recommendations
On Jan 2, 11:09 pm, "Kennedy, Randy" <RKenn...@scottsdaleaz.gov> wrote: > Would like to receive some feedback on our onconfig setup for current > platform. This is the 3rd physical server that the database has moved > to and just want to ensure we are using the best settings for…
onconfig recommendations
Would like to receive some feedback on our onconfig setup for current platform. This is the 3rd physical server that the database has moved to and just want to ensure we are using the best settings for given platform. Current Server: HP rp5405 4-Way (650 MHz) with 8GB RAM. 1 …
Newbie question-please don't shoot me
I have a newbie question. Please pardon my lack of knowledge with this. I have a Unix server (HP) that houses 2 9.4 Informix database servers (IE: there are 2 separate onconfig files that have unique INFORMIXSERVER parm values). The informix engine stopped (I think because the un…
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…
Monitor connection of remote users
Our OS is HPUX 11.23 - IDS 10.00.FC6. We have recently acquired the FOURJs Genero BDL product and are currently developing browser based applications. My question deals with tracking and monitoring user connections. All users will have a unix account and password that grants a co…
Number of users
Hi Can I limit users connection ? I want to limit just 90 users to connect in Informix ( 9.40 , HP-UX PA Risc 64-bit ) Thanks Ricardo…
Error 25588 : IDS 7.31UD1 on Solaris8
Hello, I did some more tests and I found out that after 50 connections, the next one cannot connect anymore!!! Kurt.…
BAR_MAX_BACKUP and BAR_WORKER_MAX
What's the difference between BAR_MAX_BACKUP and BAR_WORKER_MAX. Both seem to be doing parallel/concurrent log backup. Which one should be specified in onconfig ?…
shared memory not initialized
-----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org]On Behalf Of tom.priore@gmail.com Sent: Wednesday, August 08, 2007 2:55 AM To: informix-list@iiug.org Subject: shared memory not initialized I have just installed Informix 10 o…
DR: Cannot connect to primary server
I know the feeling. Working with HDR sometimes makes my head spin as well. Take care. Clifton M. Bean Informix DBA / AIX System Admin Currency Technics & Metrics Phone: (972) 812-1411 x244 -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On …
Backup worked...restore doesn't...
ids-bounces@iiug.org wrote on 07/20/2007 10:39:11 PM: > Thanks all for the ton or responses. I missed a point in my initial post: > > The restore is on a hot backup server. > Probably a silly question but you did change the value of DBSERVERNAME and ALIAS in the $ONCONFIG afte…
Network connection is broken
Hi, I'm experiencing a strange issue with my Informix server. When I try to connect from a PHP script, I get the error "(-25582) Network connection is broken". There is no problem on the network though, the server correctly receives the connection from the client, the request …
ODBC Connection error
Sounds like it didn't find a database of the name you provided or the user that tried to connect has no connect priveledges on the database…
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: Digital UNIX V4.0F + 7.31.FD1 Performance
Thank you, today on evening we make this changes in $ONCONFIG, restart the machine and hope it works! Greetings from Austria…
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…
Different users on different instances?
No. The server has to be owned by user informix. But you do not have to have a separate installation for each server instance. They can all share the same INFORMIXDIR, you just need a different ONCONFIG file for each instance with a different SERVERNUM and DBSERVERNAME/DBSERVERAL…
oninit
On Wednesday 25 April 2007 14:50, WAQAS ARSHAD wrote: > oninit -i > > informixserver does not match dbservername or any of the > dbserveraliases failed Please compare your configuration of IDS with steps described in this simple tutorial: http://www-128.ibm.com/developerworks/db…
onconfig problem
when i try to initialize server using oninit following message appears on screen "ONCONFIG can only specify a simple filename whith no path components" plz do replay me how to solve this one…
Initializing rhead structure...oninit: DBSERVERNAME 'cfms' not in sqlhosts file or sqlhosts file contents are damaged.
Hi all, I have a little problem here....after changing the IP address from our server the informix database don´t start. The error is: Initializing rhead structure...oninit: DBSERVERNAME 'cfms' not in sqlhosts file or sqlhosts file contents are damaged. I´m a oracle dba and I r…
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…
Data Replication
Hi, We are using the IDS 7.31 of informix on TRU64 unix. We have a Primary db. server which replicates to secondary db. server. In case of a failure with the primary server. (OS level, Disk error ), is there any way to configure the database onconfig parameter to ensure that th…
RE: Listing all the tables in using a dbspace in Informix
> Make sure $INFORMIXDIR and $ONCONFIG are set and that you have > permissions with your login ID to access them. There is also system > tables that can give you this information. System tables which can list out all the tables in a particular dbspace ?…
Re: onconfig
Hello, apart from editing ONCONFIG directly, some parameters are dynamically changeable: Usage: onparams ... -m <param> <value> ... -m - Modify the value of one of the following configuration parameters: AFFAIL, AFCRASH, AFW…
RE: onconfig
I don't run onbar, but I suspect you're right. LTAPEDEV, etc. would also probably be in this group as well. Either way, restore the old onconfig and you're OK. It may be a good idea to check the permissions on the file before you're done, though... --EEM -----Original Me…
Re: onconfig
I think the onbar config parameters can be changed on the fly as well. ----- Original Message ----- From: "Everett Mills" <eemills@nationalbeef.com> To: <informix-list@iiug.org> Sent: Friday, February 09, 2007 11:45 AM Subject: RE: onconfig > Stan- > TAPEDEV, TAPEBLK and TAPESI…
RE: onconfig
Stan- TAPEDEV, TAPEBLK and TAPESIZE can be modified on the fly through onconfig. Restore your old onconfig and you should be fine. --EEM -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Stan Sent: Friday, …
onconfig
Hello. What will happen when during work (online state) IDS unfortunately someone modify onconfig. Which paramaters takes effect immediately (without restrart IDS). Thanks in advance Stan…
Onspaces freezes!
Paul, If you get connection refused, then it is obvious that IDS does not open the socket listener. This is mostly because you forgot to set DBSERVERALIASES in onconfig.suse. Read my previous email for details. Marcus -----Original Message----- From: ids-bounces@iiug.org [mai…
Re: ISQL install problem
andrew.burridge@gmail.com wrote: > Hi, > > It's pretty much everything regarding isql that isn't working... > > When I go to query language, it attempts to connect to the server to > find a list of databases, but fails with the error: > > "908: Attempt to connect to the database …
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: infdump
couldn't we at least ask him for a tiny snippet of his online.log - maybe there's more wisdom in such file than you might imagine. Tip: set MSGPATH (in onconfig) to ... ... and don't forget to restart the engine ;-)…
onmode -ky hangs
On 10/18/06, SANJIT CHAKRABORTY <c_sanjit@lycos.com> wrote: > The onmode is nothing but a client application. Whenever, you execute an > onmode command, it will make a new connection to the database server and each > new connection uses some virtual memory. Well, ON-Mode is not …
HELP : All logical logs are FULL
Hi All Thanks for your response. I solved the "All logical logs are FULL" . I did the following : ShutdownServer : onmode -ky Change Onconfig : LTAPEDEV in the onconfig to /DEV/NULL Restart Server : oninit After RECOVERY : onmode -ky Change Onconfig : LTAPEDEV change…
Re: Performance tuning suggestions needed
On 1 Oct 2006 20:10:51 -0700, calyanram@hotmail.com wrote: >this my onconfig file. > ...onconfig file snipped... Please give us a bit more information. Hardware specs (number of CPUs, memory, OS. etc.) would be good . . . JWC…
SHMADD and EXTSHMADD
Hi, What is the difference between SHMADD and EXTSHMADD? We know the meaning of the SHMADD onconfig parameter. Thanks, Khaled Bentebal ConsultiX Email: khaled.bentebal@consult-ix.fr…
NETTYPE for db server
If I've got - a db server and a remote app server connecting to it - 12 cpu vps - a few local shm connections for maintenance / monitoring jobs - mostly tcp connections for apps What would be the preferred setting for my NETTYPEs? Bob Roussey robert.roussey@spiritair.com…
Users connected to a DB
Hi all onstat -u or querying sysmaster:syssessions gives me a list of connected users to a server. What if I want the list of users connected to a specific database?…
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…
DBSPACETEMP
Hello All, Just a quick question for you to ponder. Is it possible to include random dbscpaces in the DBSPACETEMP parameter with the onconfig file to prevent space problems in the temp dbspace when creating indexes etc. on very large tables?…
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…
connection to db2 database through db2 client on windows slows down intermittently
we restart the database and then connection gets established.…
Re: Error occurs when oninit: DBSERVERNAME 'sharp' not in sqlhosts file.
Superboer wrote: > BTW i would start the database as user informix, not as root. > there were some security problems in the past.... Thank you. The database server was started successfully as the informix user on my machine. The database was maintained by other people before, I…
Re: Error occurs when oninit: DBSERVERNAME 'sharp' not in sqlhosts file.
lovecreatesbeauty wrote: > None wrote: >> The machine is restarted but Informix does not come up automatically. I >> use oninit without options to bring Informix database server online. I >> get an error message then as following, how can I do with it? Can I >> edit the sqlhosts …
Error occurs when oninit: DBSERVERNAME 'sharp' not in sqlhosts file.
The machine is restarted but Informix does not come up automatically. I use oninit without options to bring Informix database server online. I get an error message then as following, how can I do with it? Can I edit the sqlhosts file manually and add an entry to correct the error…
Re: ONCONFIG and AIX
Hi, I would enable KAIO, too. Apart from KAIO the B-Tree Scanner usually benefits from some configuration: >From my experience increasing threshold (default: 500) reduces I/O significantly, enabling range scans (rangesize=500), too. BTSCANNER num=1,prio=low,threshold=50…
RE: ONCONFIG and AIX
> -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of tomcaml@yahoo.com > Sent: Thursday, July 27, 2006 12:57 PM > To: informix-list@iiug.org > Subject: ONCONFIG and AIX > > Hello All, > > I am looking for feed…
ONCONFIG and AIX
Hello All, I am looking for feedback, comments, etc. We are currently on IDS 10.FC4 on HP-UX 11 - migrating to IDS 10.FC5 on AIX on an LPAR partition on the i595 I have gotten this message in the log while performing some loads/alter tables/indexes, etc in development phase.…
Common sqlhosts file
Hi, I have different applications and different environment for each application. Applications A1, A2, A3 Environment DEV, QA, PROD Is it ok for me to have one sqlhost file that will have entries for each combination. I am also looking at putting all the entries in the /etc/s…
Parametro TXTIMEOUT
Hola, quisiera saber si alguno de ustedes me puede informar que quiere decir el parametro del onconfig TXTIMEOUT 0x12c, a cuantos segundos se refiere. Gracias de antemano. Salu2...…
Re: Help on rplication manager ids7.31 win nt
On 23 Jun 2006 02:22:19 -0700, Maumas <skakas@gmail.com> wrote: > when starting replication manager i got an error : > > invalid sqlhosts format, > > i changed INFORMIXSQLHOSTS to may machine name, but after restaring > replication manager the same error appairs. INFORMIXSQLHOS…
Help on rplication manager ids7.31 win nt
hi, when starting replication manager i got an error : invalid sqlhosts format, i changed INFORMIXSQLHOSTS to may machine name, but after restaring replication manager the same error appairs. thanks new on informix Maumas…
limit connections
Is there any way to limit connections to an informix instance ? I understand that even if you set nettype for a certain number of connections, once more than that come to the server, Informix will dynamically create a new poll thread. But what if we only want to allow a certain a…
Network down
I getting this error "network down" when I use on monitor. I am using informix 7.31 on HP UX 11.11. What could be the problem. I have checked the sqlhosts file and it is ok.…
Initialising Informix
I am trying to initialize informix on a new server and I am getting this error. The server is HP UX 11.11 and Informix IDS 7.31 What could be the problem / This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible …
Informix Connection From WIN CE.NET Emulator?
How do I connect to informix dynamic server from WIN CE.NET Emulator? Is there a WIN CE informix driver?…
Re: oninit fails using onsoctcp on linux
Adam Tauno Williams wrote: > I'm running Informx 10 on SuSe with - > (sqlhosts) > MOAIPC onipcshm localhost none > BARNET onsoctcp moa online > > >>sqlhosts: >>idbs onipcshm linux4 egal > > > What is "egal"? It means: don'…
oninit fails using onsoctcp on linux
> I installed Informix 10 on my linux (SLES9) box, everything ok. > All necessary environment variables set, "oninit -i" starts > but stops when it is about to build the sysmaster, ONLY if I > use "onsoctcp" in the sqlhosts file. No other process uses the > service port. > When (…
Linked tables in SQL
Is anyone using linked tables in SQL to connect to a ids9.4 db ken.shew@state.co.us…
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/…
Connecting to Informix
I am writting small program in C++ and need to connect to Informix database. Program should run under Solaris 8 and compile using gcc 2.95.3. Are there any free libraries to use? Can anybody help me?…
Can't INSERT blob into specific blob space using JDBC
I tried an example with 3.00.JC3 and it works fine without having a default SBSPACENAME in the onconfig file. VG.…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: Cannot create/access database on NFS mount.
Yes, sqlhosts is reconfigured per http://www.iiug.org/resources/linux/linux_faq/english/iolfaq-5.html#s1_remote_conn. I'm trying to open an ODBC connection from a Windows XP SP2 machine to an IBM AIX/Informix machine.…
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!…
connecting to Informix results error -908
I have just installed it, and I think the data base is running, but I'm not sure. I have checked the INFORMIXDIR and the DBSERVERNAME settings. But it doesn't work :-(…
Oops! IDS on Windows XP Error 900
Please help! I have installed IDS 10 on Windows XP. When dbaccess started, it connect to the internet and hang. Finally, it comes back with Error 900: Attempt to connect to database server failed. Connection Refusd. What is wrong? Why is Informix trying to connect to the int…
Re: Validating the 'SBSPACENAME' sblobspace
"Is a command-line call significantly different from file system access?" Well for SQL yes. In sysmaster.sysconfig there is a cf_effective column. This is the value in use by the database server NOW, this does not have to match the ONCONFIG value. You can change the onconfig …
Re: Validating sqlhosts and services
Thanks for this ...not knocking it or anything but what if the services are stored in yp? "ypcat services" apparently gives something that is searchable.. I'm not sure if you can store services stuff in LDAP? Very good tho..like it...portable...easy to use...…
Re: Validating sqlhosts and services
On 17 Dec 2005 13:38:56 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > > Errm.. What if people do not have perl installed? > > With C I can provide binaries that have no external dependencies. > > I just want to validate ontlitcp or onsoctcp connections with this > too…
Re: Validating sqlhosts and services
On 15 Dec 2005 19:59:43 -0800, david@smooth1.co.uk <david@smooth1.co.uk> wrote: > Does anyone know how I could write code to check the services past of > sqlhosts? > > Something that checks a servicename is valid on the current machine? > What calls does IDS use to check? > > Sam…
Re: Old INFORMIXSERVER name from onstat -g env
"Mladen Jovanovski" <mladen.jovanovski@cosmofon.com.mk> wrote in message news:dnrv0o$3v7$1@news.xmission.com... > > Did you try to delete files: > > $INFORMIXDIR/etc/.conf.<DBSERVERNAME> > $INFORMIXDIR/etc/oncfg_<DBSERVERNAME>.<SERVERNUM> > > before you restart the engine? > No,…
RE: Old INFORMIXSERVER name from onstat -g env
> > Just make sure everything matches, sometimes it is easy to miss a simple > little thing - > > DBSERVERNAME > DBSERVERALIASES > > , sqlhosts (hostname etc.), /etc/services ..... > Checked again-- all OK.…
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.
You also need to add entries to sqlhosts and add NETTYPE parameters to onconfig. Read the manuals Nuno!…
Hi group
thanks for answering, I did what you suggested : 1. ping fedora1 from the client and it answered 2. dbaccess from the server (after setting INFORMIXSERVER=demo_on_tcp) and it was worked 3. yes. the services file and sqlhosts file are the ones you mentioned with the difference t…
Re: Configuring remote tcp connections.
Nuno Paquete wrote: > Hi, > > Thanks to all of you guys. Now I just have one more question: > Do I have to install anything in the server so it can communicate using > tcp connections, or I just need to change the configuration files? > > Best regards, > Nuno Paquete > TO use mul…
v 9 stopping
search for a dir called informix (assume you installed it there) in there you should have a subdir called etc in there you should find a file called onconfig.<informixserver> search for MSGPATH which has the name of your logfile Superboer.…
Re: conversion script for Enterprise Replication - catch 22 problem
The "catch 22" issue was resolved with assistance from online support (#437614) by updating the syscdr state, then re-running the ./concdr.sh 9.21 9.4 command again. The program got further along, but still crashed due to a problem with our sqlhosts file setup. Since th…
Redirected restore failure
>From the backup and restore manual renaming chunks duing a restore..key considerations... "During a cold restore, ontape performs the following validations to rename chunks: 3. If renaming the primary root or mirror root chunk, it updates the ONCONFIG file parameters ROOTPATH…
hyperthreading and onconfig parameters
We are upgrading our database servers to HP ProLiant DL380 G4 two-way systems. This platform supports enabling or disabling "hyperthreading". (See, for example, http://sysadminforum.com/t36970.html.) With hyperthreading enabled, the OS (Solaris 9, x86) sees 2 logical processors …
Informix MULTIPROCESSOR cannot be set to 1 after upgrade from AIX5.2ML02 to ML06
Hi there, I met a strange problem here. I have 13 database instanse in one 690 machine. Last week, I upgrade my OS from AIX5.2ML02 to ML06 as IBM suggest. After that I find there are two instanse cannot startup, and reporting the following error: 10:25:29 IBM Informix Dynamic Se…
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: recording ONCONFIG changes
Tripwire or AIDE would do the trick too. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Thursday, July 07, 2005 2:16 AM To: informix-list@iiug.org Subject: Re: recording ONCONFIG changes mw…
Re: recording ONCONFIG changes
mweallans@panacea.co.uk wrote: > Scanning the old messages I came across a "suspicion" from Neil Truby > that IDS 9.2 was't recording all changes to ONCONFIG in the message > log. > I've recently spent many days trying to find why a problem had recurred > and eventually I discove…
recording ONCONFIG changes
Scanning the old messages I came across a "suspicion" from Neil Truby that IDS 9.2 was't recording all changes to ONCONFIG in the message log. I've recently spent many days trying to find why a problem had recurred and eventually I discovered that it was because a previous change…
Re: ONCONFIG - comments
Juan Pablo wrote: My comments below: > Hi: > Let me begin by saying thanks to all of the frequent posters to this group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiem…
Re: ONCONFIG - comments
"Juan Pablo" <in4mixperu@hotmail.com> wrote in message news:1120173312.07d6de6c2486de67e3cad47cd40e6341@teranews... > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ====================…
Re: ONCONFIG - comments
Juan Pablo said: > > Hi: > Let me begin by saying thanks to all of the frequent posters to this > group. > I wanted to offer my config for comments. > thanks > ============================================================ > Hola: > Muchas gracias por el tiempo y su ayuda. Est…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pode…
ONCONFIG - comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para…
HDR problem - ontape -p
Guys, first, thanks for your help . It gave me directions. The problem was services/sqlhost file already had some "dead" entries which caused confusion [shouldn't happen in a virgin/textbook cases] .…
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:…
user can still connect after CONNECT privilege get revoked
Hi, I have revoked the connect privilege from a user. The user is not admin. Still, the user can connect to the database. How to revoke the CONNECT privilege indeed from a user? How to check a user can't connect (e.g. catalog table or user setup) without letting the user try to …
Help:informix database backup/restore with netbackup agent.
You have to set correct value for the INFORMIXSERVER environment variable or check the sqlhosts file content. Here is the quote forme the finderr -25596: ------ The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry. The default database server name that th…
ODBC Connections
--0-1022851391-1118096900=:67143 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I need monitoring all ODBC connections only. For internal auditoring. Regards, --------------------------------- Do You Yahoo!? La mejor conexi�n a Internet…
RE: Format of sqlhosts file
> -----Original Message----- > From: Graham Nicholls [mailto:graham@rockcons.co.uk] > Sent: Tuesday, May 24, 2005 8:27 AM > To: informix-list@iiug.org > Subject: Re: Format of sqlhosts file Snipped > The 3 fields are as follows: > > XX 2 character server type - "on" for IDS, a…
Format of sqlhosts file
Good morning! I am having some problems with ODBC drivers, which I've managed to get past, but not without getting very confused about the $NFORMIXDIR/etc/sqlhosts file. Can anyone enlighten me on its format, please, or point me to some resource. I am, and will continue to goo…
Connection Pooling
We are using the odbc driver "INFORMIX 3.31 32 bit" The version is 3.31.000 2.40.TC1 When I look at it the set up for it in ODBC drivers, it says <not pooled> under the connection pooling heading. Yet, when I close a connection in a program, my temp tables do not drop. That is,…
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…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG para pod…
ONCONFIG comments
Hi: Let me begin by saying thanks to all of the frequent posters to this group. I wanted to offer my config for comments. thanks ============================================================ Hola: Muchas gracias por el tiempo y su ayuda. Estoy dejando mi archivo ONCONFIG par…
Connection ODBC INFORMIX CLI 2.5 32 BIT
Anyone know the connection string for connecting from a VBA Microsoft Access project to ODBC INFOCMIX CLI 2.5 without set the paramenters in setnet32.exe? Tank you. Simone…
Re: connect to database error
my sqlhosts is set demo_on onsoctcp linux linux_s thanks -- Message posted via http://www.dbmonster.com…
RE: New installation
Yes I agree with Brian, you put something in the onconfig that required 161MB but you have defined the root dbs size 60MB that is not enought to cover all the requests. Check the PHYSFILE, LOGFILES LOGSIZE in the ONCONFIG file. If you need more help give us the full ONCONFIG. b…
Help with ONCONFIG needed
Having a problem with a client connection to an informix database. The server has two databases, db1 and db2. Each database has a separate ONCONFIG file which lists the different db names in them. ONCONFIG_db1 includes db1,but not db2 in the DBSERVERNAME/DBSERVERALIAS …
Connections hang
Hi fellows, from time to time, not quite often but believe me its pretty annoying, happens that connections from remote servers or applications - every onsoctcp connections - to our main IDS box just hang without any apparent reason. Anyways local connections (e.g. a simple "dba…
Broken connections
Hi all, =20 I'm seeking an advice to detect broken and cut connections to an INFORMIX instance. =20 I got a SUN BOX running ids 9.40 =20 I found that I can tune up a parameter in Solaris for tcp. it is 'tcp_keepalive_interval' =20 Using this command 'ndd -set /dev/tcp tcp_keepali…
Re: connect to database error
Hi again, try to do one thing at a time. First: a) Configure your server with SHM connection only. Remove the other server name for TCP/IP connection from your $ONCONFIG file (DBSERVERALIASES in your case). Then bring up the server and make sure that you can connect to…
Re: connect to database error
Hi again, try to do one thing at a time. First: a) Configure your server with SHM connection only. Remove the other server name for TCP/IP connection from your $ONCONFIG file (DBSERVERALIASES in your case). Then bring up the server and make sure that you can connect to…
Re: connect to database error
Is your serever really called demo_on? thats the name of the example entry in the sqlhosts file. what does the line corresponding to demo_on say in your sqlhosts file? demo_on onipcshm on_hostname on_servername…
Re: connect to database error
What is DBSERVERNAME and DBSERVERALIASES set to in the onconfig file for the instance you are trying to communicate with? hwang fu via DBMonster.com wrote: > and i connect to demo_tcp the error message : > 908:Attemp to connect database server (demo_on_tcp) failed > ISAM error:r…
connect to database error
What is DBSERVERNAME and DBSERVERALIASES set to in the onconfig file for the instance you are trying to communicate with? hwang fu via DBMonster.com wrote: > and i connect to demo_tcp the error message : > 908:Attemp to connect database server (demo_on_tcp) failed > ISAM error:r…
Re: install IIF_9.40.UC5.linux_tl.cpi to LINUX frdora 2 ONINIT problem
Hi, you do not want to use the server name "demo_se", because it has the wrong protocol specified. I guess that is the default thing after install, but sorry - it still doesn't work ... :-( So you remove the value "demo_se" from parameter DBSERVERALIASES in your onconfig file (…
Re: install IIF_9.40.UC5.linux_tl.cpi to LINUX frdora 2 ONINIT problem
Hi, you do not want to use the server name "demo_se", because it has the wrong protocol specified. I guess that is the default thing after install, but sorry - it still doesn't work ... :-( So you remove the value "demo_se" from parameter DBSERVERALIASES in your onconfig file (…
Re: informix + pam on linux
Hi, thanks a lot for answer! don't worry for late :) I configured following items: /etc/services: sqlexec 1540/tcp Environment export INFORMIXSERVER=helios export PATH=$PATH:$INFORMIXDIR/bin export OB2APPNAME=helios export OB2BARHOSTNAME=helios export DBSERVERALIASES=…
Re: informix + pam on linux
Hi, thanks a lot for answer! don't worry for late :) I configured following items: /etc/services: sqlexec 1540/tcp Environment export INFORMIXSERVER=helios export PATH=$PATH:$INFORMIXDIR/bin export OB2APPNAME=helios export OB2BARHOSTNAME=helios export DBSERVERALIASES=…
informix + pam on linux
Hi, can somebody tell me how to configure pam.d directory/file on Linux for IDS 9.4/10.0? Which name of file for informix will be right? ... and how this file and sqlhosts should look like? Regards, Thomas…
informix + pam on linux
Hi, can somebody tell me how to configure pam.d directory/file on Linux for IDS 9.4/10.0? Which name of file for informix will be right? ... and how this file and sqlhosts should look like? Regards, Thomas…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
Re: Sudden & massive SHMADD activity; engine went BANG!
Well we have got some relatively new apps connecting via JDBC, and we have run into an issue before whereby the connection pools aren't freed unless they explicitly close the connections.... Sounds plausible. I'd appreciate a copy of the script if you're ok with that, thanks RK.…
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…
The onconfig FILLFACTOR
My day for asking questions ... but that is how one gains knowledge :) The lead DBA for the company for which I am now working for as a consultant wants to establish an initial FILLFACTOR of 100 for those indices that represent a serial column. Since none of the tables having a…
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…
RE: Informix Enterprise Replication
There may be issues with your DBSERVERNAME having to be the tcp connection. Do not have your shared memory DBSERVERNAME / ALIAS in the group :D # tbp_731a instance cdr_tbps1 group - - i=10 tbp_731a_tcp onsoctcp tbp tbp_731a_tcp g=cdr_…
Informix 7.23 connection problem
We are using Informix 7.23 Online database on Unixware 2.1.3. It works OK if less then 50 users are connected. When 51-st is connecting, it starts to refuse connections, create closed connections and go slow. I have increased tcp, MAXUP and NBUF parameters, but its not working. C…
Re: PEMEX - CDR WITH NAT
CDR uses the CDRID to replicate, not the IP address. The CDRID is the 'i=3D' field in the sqlhosts options column. As long as you make sure that your sqlhost files have the proper mapping, then changing the network, the ip address, and/or the port numbers should not impact CDR. …
how can I make a conection to informix
first create an entry in sqlhosts or modify. $INFORMIXDIR/etc/sqlhosts os whereever INFORMIXSQLHOSTS points to myserver sesoctcp <yourhostname> <someserverice or 1533> #----------^^^^^^^^ or setlitcp check rel notes. if you use someserverice add someserverice to …
how to read data from database on other machine
Hi all, I was wondering how we can read data from an Informix (IDS) database on another machine. Do I need to metion in the sqlhosts file the other database server? etc.... thanks for any tips!! Danny…
Re: SET DBSERVERALIASES
Hi, a) decide on the desired protocol and port number. b) enter a service name for the port number in /etc/services file. c) put the corresponding entry into the sqlhosts file (with the new server alias name). d) bring down the server. e) edit the $ONCONFIG file to add the new…
SET DBSERVERALIASES
Hi, I would like to setup the parameter DBSERVERALIASES in an IDS with 9.30.TC1. What is the procedure that I have to follow? Thanks, Vasilis…
Re: No ODBC access to Informix...
wolf.duttlinger-manger@gmx.de (Wolf) schrieb: >I was basically going for this option: >Setup one box with two installations of Informix (and here - as >promised - my new question: are two installations of Informix V.5.01 >supported on one Solaris system?) Two installations are …
Connect error
Hi, I've a pb to connect to ifx. I get error message 952 with ODBC. I tried with dbaccess and I surprised with 2 behaviours : - first, I launch dbaccess, user is registred, it works - I try to pass by menu "connect" and it reject me with all users/passwords giving the same error…
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'?…
Distributed systems - a small query
I have a customer who has created two systems, one for development and one for production. They have used the same instance names, database names, path names for dbspaces, even the same TCP/IP service names. They wanted the development system to be a carbon copy of the live syst…
hdr groups with ER
.. don't think my last post made it. I have a serverA as a primary (HDR) to serverB. I have a 'shm' DBSERVERNAME and two DBSERVERALIASES: serverAtcp and serverAtcpR. The serverAtcpR service talks across a separate subnet just for the HDR. I now need to add ER to replicate a bat…
IDS V7.30 and Windows 2000
Can Informix Dynamic Server Version 7.30.TC6 be run on a Windows 2000 host system? TIA Erwin…
Re: Tivoli dsmc command to query Informix Backups
Hi, how about this? Run this on the machine where the backup was done as user informix from the command line: dsmc q b -inactive "/on94shm/on94shm/*/*" and replace in my example on94shm with the name of your DBSERVERNAME variable. You can also replace the wildcard to restrict…
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: parametros ONCONFIG
Los parametros del ONCONFIG que tienes que setear para inicializar tu instancia como MINIMO son: ROOTPATH Path completo del chunk creado para almacenar el root Dbspace ROOTSIZE Tama�o del chunk en Kbytes (Ejemplo: 2048000 # 2Gb) DBSERVERNAME Nombre l�gico del server.(Eje…
parametros ONCONFIG
Me podrian ayudar con los parametros del ONCONFIG. No las tengo muy clara cada parametro, por lo que la misma me trae problemas para el momento que quiero OPTIMIZAR el servidor de bases de datos. Si alguien me puede ayudar a conocer mejor cada uno de estos parametros .... les agr…
ORACLE equivalent of DBSERVERNAME
For all the INFORMIX and ORACLE savvy folks : In INFORMIX there is a default value called DBSERVERNAME that can be assigned to a column during the table definition as follows: create table t1 (c1 char(18) default DBSERVERNAME ); Is there an ORACLE 9i equivalent for D…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
JDBC reading from SQLHOST file
It seems JDBC applications can make connections to the database without a SQLHOST file by specifying everything in the database URL. However JDBC manual also mentioned SQLH_TYPE=file and SQLH_FILE being the SQLHOST file. What is the format of this SQLHOST file. Is it the standar…
onconfig for analisis
Hi, I post the onconfig file for its analisis: Operating System: SuSE 9.0 RAM: 1024 Mb Informix version: 9.40 UC2 All chunks are raw devices. Thanks. #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig…
ONCONFIG for 9.40 offered for comment
9.40 FC3W2 on HP-UX 11.11 The server has 6 cpus and 6G of RAM. 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. kaio is enabled. Just put 9.40 live, and it's running about 5-10% more slowly on some key processes. This reflects what happened in testing. …
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ > 2Gb ram and 4 processors that seems very slow on a large sequential > write (I suppose that the problem resides in the dbspaces on > filesystem...). Any suggestion? The following is my standard…
Re: OnConfig parameters tuning
"Laverio" <laverioNO@z-1000.net> wrote in message news:cac7sg$e8v$1@newsreader.mailgate.org... > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in…
Re: OnConfig parameters tuning
Laverio wrote: > Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram > and 4 processors that seems very slow on a large sequential write (I suppose > that the problem resides in the dbspaces on filesystem...). Any suggestion? > > My onconfig it's set as fol…
OnConfig parameters tuning
Hi guys, I'm trying to speed up an IDS 9.30 on a Sun 7.5 system w/ 2Gb ram and 4 processors that seems very slow on a large sequential write (I suppose that the problem resides in the dbspaces on filesystem...). Any suggestion? My onconfig it's set as follow: # System Configura…
Re: DB Server Alias
abanero@supereva.it (Abanero) wrote in message news:<ad9fb198.0405270320.7bc98fd5@posting.google.com>... > Hi All, > > I have the following issue: > > I need to connect the same instance through 2 IP addresses, i read in > this newsgroup that there is a variable in ONCONFIG file …
Howto for Onconfig
Hi everyone, This is probably a question which has been asked often. But I could not find proper documentation on how to calculate and set correct parameters for Onconfig. I understand this is a complex question. But are there any articles on this ? Maybe they covered the topic …
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.…
Informix Connect
I'm having a problem connecting to my db due to the fact that my Informix SE (v7.23) wants to talk via (SETLITCP). Any new ODBC driver I try wants to talk via (SESOCTCP). Does anyone know if an old version of Informix Connect will talk via TLI? The oldest I can find on IBM's w…
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…
Change in sqlhost file
Dear All, I am working on informix7.30UC7. Using ODBC connectivity I am able to connect to my database which is for test environment, where m/c hostname and hostname in sqlhost is same. But on live environment ( which is a different server altogether ) connectivity is not gettin…
Re: Error -1811
Andrew Hardy wrote: > can somebody explain to me what this means: > > lesu273> finderr -1811 > -1811 Implicit connection not allowed after an explicit connection. > > Once you have used the CONNECT TO statement to establish an explicit > connection to a database server, you can…
Error -1811
Sorry to be a pain, can somebody explain to me what this means: lesu273> finderr -1811 -1811 Implicit connection not allowed after an explicit connection. Once you have used the CONNECT TO statement to establish an explicit connection to a database server, you cannot use one…
Off-platform SDK
Thanks for those that sent me advice on this. The main problem turned out to be the service listed in the sqlhosts file on the Linux machine. I had ontlitcp, and it needed to be onsoctcp. Brian McLaughlin Administrative Computing George Fox University (503) 554-2587…
Re: Informix Network Connection
With much thanks to all who contributed, I've solved it. I was running the Slackware distribution version of Apache (1.x.x) and had upgraded the Slackware distribution of PHP to 4.3.4. I finally gave up and removed both the Apache and PHP packages and configured httpd-2.0.48 and…
Re: Informix Network Connection
Please excuse me for being so stupid, but I've been through the administrators guide and all the helpful information provided here and I still don't quite get it. Following your example below, I have onconfig like this (no NETTYPE entries): DBSERVERNAME fubar_23 #…
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,…
SHARED MEMORY LIMIT
Is posible to use with informix of 32 bits more than 2GB of shared memory in a Linux Machine? The base address in onconfig is: SHMBASE 0x41000000 Thanks in advance,…
RE: Whatcha' wanta have?????
And a simple one...when message INFORMIXSERVER not found in sqlhosts file or DBSERVERNAME not found in sqlhosts file could the message include the name it is looking for? This would make it much easier to debug! Also oninit -v option to be documented. All of onstat options to b…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
configure computer for using informix
what shell I do to make my computer work with informix. I have installed winXP on my computer, informix 4 i informix dynamic server? THANKS…
DSN-less and oledb connection scrint for Informix using OpenLink drivers
I've recently started to work with performing queries against an Informix 2000 database using the OpenLink drivers and ADO. I've figured out to use a DSN connection string in my VBScript, but I would prefer to use a DSN-less connection. I would also like to try an oledb connecti…
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…
ODBC Connectivity
I'm after some advise. Current situation: User 'fredn' can log into Unix host and run 4GL application User 'fredn' can access database via ODBC in update mode User 'pcuser' has been set up specifically to allow ODBC access in read-only mode I want to stop user 'fredn' accessin…
Changing database local / dbexport tapesize
Hi, Did you change TAPESIZE on your onconfig file? That could be the restriction! REGARDS…
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.…
Connection problem
Hi all, I have this problem : Error -951 while trying to connect to the Informix 7.31TD2 server (on = win2000) from an windows XP (client APP) via ODBC. The ODBC test connection works ok, but the application throws this error = : user not known on the database server. When I us…
connection problem
Hi everyone, did someone meet the following issue? We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V Release 4.0). Currently only 91 users can connect to the database. Afterwards no new user can login - till someone logs out and the user can connect to the server…
Network driver cannot bind a name to the port!
Hi bro, Probably you've some kind of mess in onconfig and specially sqlhosts file Check for correct DBSERVERNAME, DBSERVERALIASES, hostname and port. See also services file for correct service name/number Greetz…
Re: database open Error -761 : INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.
Carlos Perez wrote: > Hello I have the following problem. > > Due an old program limitation the size of the servername can no be > larger than 6 characters in the client and the server is a corporative > Database used by several sistems to the same server. > > The client sqlhost…
database open Error -761 : INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.
Hello I have the following problem. Due an old program limitation the size of the servername can no be larger than 6 characters in the client and the server is a corporative Database used by several sistems to the same server. The client sqlhosts is: pro699 onsoctcp …
Re: onconfig and sqlhosts
Hi Thomas. Administrator's Guide for Informix Dynamic Server, Version 7.3 http://www-3.ibm.com/software/data/informix/pubs/library/ids_73.html HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Thomas Ronayne <trona@ameritech.net> >Reply-To: Thomas Ronayne <trona…
onconfig and sqlhosts
I've managed to blow away my installed Informix system and cannot for the life of me find the notes I had about onconfig and sqlhosts. It's version 7.30.UC5 running on Slackware 9.0 -- can someone point me at the right document in Answers for the appropriate settings? Thanks.…
client port number
Is there a way Informix can return the port number of the client it uses to talk to for a connection. We need this to identify some connections amongst hundreds of connection from iplanet server which uses the same user name. Since client port number is always unique,it can be us…
Re: Disconnect current costs very long time to finish
Have you tried to issue SET MOUNTING TIMEOUT TO NOT WAIT? "Kevin Walsh" <yys@fiberhome.com.cn> wrote in message news:982f7ec8.0309162325.6ddbf70f@posting.google.com... > I configured a local DBSERVVERNAME with onipcshm, and a remote > DBSERVERALIASES with ontlitcp on my IDS7.31 …
Disconnect current costs very long time to finish
Kevin Walsh wrote: > I configured a local DBSERVVERNAME with onipcshm, and a remote > DBSERVERALIASES with ontlitcp on my IDS7.31 with SUN solaris 9, > installed client sdk 2.81.But when I run the demo1.ec program, the > statement "disconnect current" cost very long time to fini…
cannot connect
hello, we are experiencing a sporadic problem where the database will not allow any new connections. does anyone have a script they run that will connect to the database, do a simple select and then exit? this script would only send mail if there was a problem, otherwise we would…
Re: Setting up the Informix ODBC driver on Windows
On Mon, 18 Aug 2003 20:02:35 GMT, "Jack A" <jacka8@excite.com> wrote: >I need help/confirmation regarding the following parameters. I've been >trying to set up WinSql for some time now ; You mean ODBC? > >Server Name: The name of the box on which Informix is running. Can pick >…
Setting up the Informix ODBC driver on Windows
I need help/confirmation regarding the following parameters. I've been trying to set up WinSql for some time now ; Server Name: The name of the box on which Informix is running. Can pick from /etc/hosts Host Name: DBSERVERNAME from ONCONFIG. Service Name: I picked it up from /…
Re: Onconfig file parameters
Sometimes even the ontape parameters (TAPEDEV, LTAPEDEV, TAPESIZE, etc.) are not dynamic. What you can do is change a parameter in the onconfig file and then dump out the reserve page that holds the onconfig parameters with: oncheck -pP 1 1 Hope this suggestion helps. Brice Av…
DataBase Connection
hi!!!! I have 2 linux Red hat 7.2 servers with informix 7.31 UD2 version, I want to get the connection between them but it shows "908: Attempt to connect to database server (servgra) failed. ISAM error: record is locked. ". I defined this: ** On the services file:(both servers) …
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…
Connectivity Issue
Can anyone please provide help with the following. I am trying to access db tables in an IDS instance running on WinNT from MS Office 2000 applications. The IDS is ver 9.3 and the ODBC driver is Informix 3.33 from the ver 2.6 CLI SDK Using MS Access or Excel I can create a link…
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…
Which version to use of Informix Connect?
Hi Community, I have some questions about Informix Connect and hope that somebody knows the answers :-) We are using HP-UX 10.20/Informix 7.31.UD5 and the clients (OS: WIN NT/WIN2000) are connecting to the database through I-Connect 7.20. Are there known problems with this vers…
RE: HPL Unloading error [1467]
Here's my onconfig file SHMVIRTSIZE 147456 SHMADD 8192 SHMTOTAL 0…
Catastrophic Error
I connect to an Informix database with Visual Basic using ADO, and have a program that must periodically connect to the database, make some process, and then disconnect. The problem is that when I use oledb Informix provider (ifxoledbc), after a number of connection/disconnectio…
Re: How to rename Informix Instance name
Hi Chavan. Try the following. 1. rename DBSERVERNAME in your ONCONFIG file. 2. rename 1st entry in your sqlhosts file. 3. rename INFORMIXSERVER variable. 4. bounce your IDS. e.g) 1. DBSERVERNAME tsutoo930uc3shm # Name of default database server …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
Re: multiple instances
For basics it's setting Informix environment variables and exporting them. 1. INFORMIXSERVER=sqlhosts entry 2. ONCONFIG=onconfig file name 2. If the second instance is installed in a different Directory then set INFORMIXDIR to there. 3. If it's a different sqlhosts file name o…
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…
onconfig file
The system administrator at my current site thought he would be very clever and he linked the onconfig files to different directories using ln -s. We have now discovered that these links are being lost when we use onmonitor and replaced by a local file, but not when we use vi. I…
INFORMIXSERVER / DBSERVERNAME limitations?
Hi all. I had an interesting problem Saturday night (aren't all problems more interesting on a Saturday night?). I am running IDS 9.20.UC3 on AIX 4.3.3. The instance hung in a checkpoint (CKPT REQ). I have seen this before and support claims it is an existing error in our version…
native connection to 2nd network card
We currently have our sqlhosts file setup to allow connection for one port on ip address aaa.aa.aa.aaaa through odbc or native connection. I want to add another network card on the same server to the sqlhosts file so that we can connect to that ip address of bbb.bb.bb.bbbb as wel…
Syntax
Do someone know the syntax to connect to an Informix database via Internet (ASP Program)…
NETTYPE
I would just like to clarify on the setting of NETTYPE on the ONCONFIG. Can I put several NETTYPEs on the one file, like: NETTYPE ipcshm,3,,CPU NETTYPE soctcp,,20,NET because I use the DBSERVERNAME and the DBSERVERALIASES with different connections? I wasn't so clear to me in t…
ODBC connectivity
Has anyone set up links between an Oracle database on Windows or Unix to an Informix database. I would appreciate any information or documentation which is available. Of particular interest is 1) What ODBC drivers were used 2) What port numbers does Informix 3) Any 3rd party soft…
sqlhosts on W2k
Hi all, I have got define the group on the UNIX server : #sqlhosts on UNIX g_repl1 group - - i=1,e=tranzit tranzit ontlitcp tranzit online g=g_repl1 How do I define this group on W2k in registry? I have got this in the registry, but this isn't functional: [HKEY_LOCAL_MACHIN…
Re: enterprise replication
You probably have a misconfiguration in one of your sqlhosts files. I'd examine them first. If you can't figure out where the inconsistancy, then I suspect that you can get this fixed quickest by contacting tech support.…
I-connect limitation
We are using VB with ODBC and I-connect 7.2 connecting to our Informix SE DB on SCO Unix. The problem is that we try to connect several db simultaneously for some queries but i-connect only allow one DBPATH. Thus only one db connection per pc configuration. I tried the SDK2.5 wit…
ODBC Connection Timeout?
Does anyone know if the TXTIMEOUT parameter in the $ONCONFIG file would time out an ODBC connection after the specified period of inactivity? We have a client making an ODBC connection to our informix server and it is losing it's connection intermittently. Any other ideas on wh…
RE: Informix CLI 32 and Access
Hi Simone. How do you you connect Access ( or plan to connect ) to the tables you want to use ? /Falco…
URGENT.I NEED HELP.THANKS
I NEED HELP. HOW TO CONNECT PERL WITH INFORMIX DATABASE?? THANKS ALOT.…
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…
IDS 7.31.Txx Windows NT Alaramprogram
i have change the path in the onconfig-file and restart the server but the alarmprogram will not be start if a event (logs) a generated! thomas…
Which Connection ?
I have written a perl program predisponsing a lot of INSERT sql command. Now I would be glad to connect with remote database and execute the remote insert. Anyone know about which kind of connection software I can look for (some peole tell me about SDK, other ODBC) ? …
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…
Attunity Connect
Has anyone here used a product called Attunity Connect with Informix? TIA. Colleen ========== The preceding e-mail message (including any attachments) contains information that may be confidential, be protected by the attorney-client or other applicable privileges, or constitu…
Sluggish connections between NT Client and IDS on NT
When connecting to IIF.2000, I am experiencing connect times as long as 15 seconds. The environment that I am has less than 5 connections. The sluggish connections has through ODBC and via Ilogin utility. Below is an overview of my configuration. My client consists of: ------…
protocol
I notice that our informix server has the sqlhosts set to ONSOCTCP and that the windows connect is set to OLSOCTCP shouldn't these be the same? What is the difference between the two?…
Help needed: sqlhosts basics
Hi all. We try to configure an IDS 9.21 FC2 on Solaris 7 with HDR. The clients though are 32-bits, so we were told to use TCP connections, not shared memory. For the previous version used (7.30), we were using shared memory, and our sqlhosts on one of the servers looks like: …
Connect to informix
Hi, First of all, i'm very new with using linux. :-) Now i have a UNIX with informix server 7.3 on it. I use ODBC to connect under windows, so that's no problem, and works fine. Now, i have a linux. And (you can guess) i want to connect to the UNIX. The idea is that i want to ma…
Connection / Disconnection
Can anyone explain the following behaviour ? Configuration : Ifx 9.21 UC 2 , IBM S80 AIX 4.3.3 16 Go 18 proc. NETTYPE onsoctcp, 17, 180, CPU When 1500 users ( that's to say 3000 connections to the databaserver) are working, time are quite ok. But when the first users disconnec…
Insert performance is poor
mr_potato_head@my-deja.com schrieb: > DBSERVERNAME n36_shm # Name of default database server > DBSERVERALIASES n36_tcp # List of alternate dbservernames > NETTYPE ipcshm,1,50,NET # Override sqlhosts nettype parameters > NETTYPE tlitcp,1,50,CPU …
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 …
Re: ONCONFIG History
put it under source code control? SCCS and RCS are free tools and dont take too much resources. HTH Sujit testNews <mtabunda@amellar.com> on 10/04/2000 09:05:30 PM Please respond to testNews <mtabunda@amellar.com> To: informix-list@iiug.org cc: Subject: ONCONFIG History I…
RE: ONCONFIG History
Look at your online message log onstat -c |grep MSG -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Wednesday, October 04, 2000 9:06 PM To: informix-list@iiug.org Subject: ONCONFIG History Is there a way to know/track the changes made to ONCONFIG …
RE: ONCONFIG History
Changes are recorded in the message log at startup. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: testNews [mailto:mtabunda@amellar.com] Sent: Thursday, October 05, 2000 12:06 AM To: informix-list@iiug.org Subject: ONCONFIG History…
ONCONFIG History
Is there a way to know/track the changes made to ONCONFIG files?…
Re: onsoctcp..?
Hi, se means the standard edition according to Informix SE. Both, on, ol means OnLine. btw: the first entry in sqlhosts is the DBSERVERNAME not the DBNAME. Greetings, Andi…
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
Can you help me please ?
>Server name : ? > Host name : IP adress (maybe) > Service : ? > Protocol : onsoctcp (maybe) > Options : ? > Database name : my database > User id : root (maybe) > Password : ******** Hi, Server name is your $INFORMIXSERVER or DBSERVERN…
TBLSPACE_STATS
Hi, what is the meaning of TBLSPACE_STATS variable in onconfig file? thank in advance.…
ODBC Connection
Is there any particular svc that Online (7.23) would use as a default? I've looked through /etc/services but really am not sure which one... Thanks in advance, Joe Robinson, SFC System Administrator USPFO for Oregon, Oregon Army National Guard Email: robinsonj@or-arng.ngb.arm…
Does risql connect via odbc?
Administrators, I'm trying to connect to Redbrick 6 via a 3rd party application on Solaris 2.7. This application connects via Odbc. I CAN NOT conect via this application or via the "adhoc" program, but can connect via "risql". I'm trying to determine where the problem lies. …
Hi
Savio Mario Bartholomeo Pereira wrote: > > Hi, > > What is the difference between an instance and a server ? In Informix-speak - a server is the machine on which an instance runs and by extension, if there is only a single instance, often the instance itself if one is being s…
DSNless connection
Hi there: How to use DSNless connection in VB6.0 and Informix7.x. I can do that in using MS SQL Server7.0, but not with informix. Thanks! -- ------------------------------------ ������(Kuang-ming Kuo) �]�Ϊk�H�_����|�q���� (Chi-Mei Foundation Hospital) kmkuo@mail.chimei.org.tw …
Query Optimization: Wrong execution plan?
Xavi Tarafa Mercader wrote: > Any suggestion about how to improve the query performance? Set OPTCOMPIND parameter ( in onconfig file ) to 0. > Xavi. Leonid.…
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…
Regarding connect permissions of the database.
Hi All, Is there any restrictions on number of users for granting permissions (connect) to a databases? What will be effect of revoking connect permissions from public after adding connect permissions to the application users. (Running HP-UX 10.20 and Informix 7.3). Please hel…
RE: sqlhosts on IDS 7.31
Jane We have been running this combination at a client with AIX live since February - 32 bit tools and 64 bit engine. The information you were given was wrong. MW -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On B…
RE: sqlhosts on IDS 7.31
I have been in contact with informix and found out that I was shipped the 32-bit versions of tools and the 64-bit version of the IDS engine. The engineer said they were not compatible. 64-bit versions are on their way here as I type (I hope). ---------------------------- Jane …
Solaris 8, IDSWE 7.31, WARNING: Network Down
I changed $INFORMIXDIR/etc/sqlhosts and created one entry: ep01_net_shm onipcshm eprospector01 shmcon The database server initialized and sysmaster and sysutil were created. I then added the following line back to $INFORMIXDIR/etc/sqlhosts: ep01_net ontlitcp eprospector0…
Re: sqlhosts on IDS 7.31
Jane, I'm running the same environment OS and IDS versions. Check your environment (INFORMIXSERVER/ALIAS and your network, then please post your onconfig and sqlhosts files. John ---------------------------------------------------- John F. Coyle Senior Database Administrator …
sqlhosts on IDS 7.31
I have just installed IDS 7.31 on an HP-UX 11 box. I have created a database with tables with data and can access it all fine via dbaccess. But - when I try to access the data via isql I get error message 25588 which says there is a problem with my sqlhosts file. I've looked ov…
WSTATS and Performance
Hi, does anybody know the performance degradation by setting WSTATS 1 in the onconfig file? Is this 1%, 5% or 10% ??? TIA Ruediger Papke…
ADO
Is it possible to connect to Informix using ADO/OLE DB ?????…
Redbrick Connection
Hi Folks, Does anybody know if there is some kind of driver to connect a Redbrick database with an Oracle database so that I can do selects from both. Either direction would be fine. Thanks, Gregg Sent via Deja.com http://www.deja.com/ Before you buy.…
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…
SqlHosts information in database table.
Use the UNIX cut command to format the SQLHOSTS file into a table unload format. Then load the results into a temp table. Run an insert SQL statement against a table you've created called SQLHOSTS where the temp row isn't already in the SQLHOSTS table. This could be setup to run …
Connect fail with error 908
Hi, I try to connect to a remote database with dbaccess comand 'connect to '@dataserver';' and gor error '908: Attemp to connect to database server (dataserver) failed'. Can someone tell me what the probem is? The remote database is up and running. Thanks, Thanh Ngo…
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…
sqlhost file
Can someone please tell me how the sqlhosts file is layed out? I'm trying to identify database name and instance to connect with ODBC...not sure if the instance would be one of the parms here or not... Thanks in advance for your help, Joe Robinson, SFC System Administrator USP…
Web connection
Hello. I am interested in developing web-based solutions with my Informix IDS7.32UC2. I have a Microsoft IIS server, with ASP-pages, and the 1st solution could be the creation of ASP pages with ODBC-connectivity to Informix. But I suppose this is not a very secure environment, f…
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…
Informix Client on Solaris 8
Did you remember to change the appropriate entries in sqlhosts? I recall receiving this error after inattentively copying a sqlhosts file over from another (functional) informixserver to a fresh install and not correctly editing the hostname field. walther@my-deja.com wrote: >…
RE: Query on SQLHOSTS
Thanks for the reply. My problem was solved. In SQLHOSTS file instead of giving the service name (sqlexec2) , I gave the port no (1529). It got connected !!! But still the mistry remains. I checked the sqlhosts and the /ect/services thoroughly. the service name is same everywher…
Query on SQLHOSTS
Hi All, I have two databases running on two different machines A and B. I have logged into machine A and wanted to connect to database@B. In machine A sqlhosts file in $INFORMIXDIR/etc dir, I have made an entry for database running on server B. dbservername olsoctcp server-B sq…
dynamic server with Informix distant database
We have this problem : - write of a html page (this pages will contain many many fields). - Receiving of the page data on a http server based on a M1 machine. - Using of 4gl/informix programs based on the M2 machine with the pages data - 4GL programs will set up a � result � tabl…
Re: more:after adding DBSERVERALIASES into onconfig file
Kathy Huo wrote: > > Here I got the error message: > > ************************************************* > Wed Mar 8 10:42:26 2000 > > 10:42:26 Event alarms enabled. ALARMPROG = > '/usr/informix/etc/log_full.sh' > 10:42:32 DR: DRAUTO is 0 (Off) > 10:42:32 Requested shared me…
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…
RE: sqlhosts configuration
depends is the answer, check out your search order for server lookup, you don't mention the OS but I'd use nsswitch.conf on Solaris -----Original Message----- From: Thierry Achaintre [mailto:thierry.achaintre@euriware.fr] Sent: Wednesday, March 29, 2000 3:36 PM To: informix-list…
RE: sqlhosts configuration
-----Mensaje original----- De: Thierry Achaintre <thierry.achaintre@euriware.fr> Para: informix-list@iiug.org <informix-list@iiug.org> Fecha: mi�rcoles 29 de marzo de 2000 02:40 Asunto: sqlhosts configuration >Hi all, > >When I build my sqlhosts file, is the hostname field the r…
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…
Re: Doubt in configuring IDS for multiple network cards.
From: "Christian Kondo" <christian_hk@hotmail.com> > >>From: "Obnoxio The Clown" <obnoxio@hotmail.com> >> >>From: "Christian Kondo" <christian_hk@hotmail.com> >>> >>>My server have to work in two different subnets, but with the same >>>dbservername, so I can�t do the bellow confi…
Re: Doubt in configuring IDS for multiple network cards.
>From: "Obnoxio The Clown" <obnoxio@hotmail.com> >To: christian_hk@hotmail.com, informix-list@iiug.org >Subject: Re: Doubt in configuring IDS for multiple network cards. >Date: Tue, 28 Mar 2000 18:30:40 BST > >From: "Christian Kondo" <christian_hk@hotmail.com> >> >>My server have…
Doubt in configuring IDS for multiple network cards.
all you need is a NIC that supports subnet grouping. Nona >Subject: Doubt in configuring IDS for multiple network cards. >From: "Christian Kondo" christian_hk@hotmail.com >Date: 28.03.00 21:08 W. Europe Daylight Time >Message-id: <8bqr8a$34p$1@news.xmission.com> > > >Hi people,…
Re: Doubt in configuring IDS for multiple network cards.
From: "Christian Kondo" <christian_hk@hotmail.com> > >My server have to work in two different subnets, but with the same >dbservername, so I can�t do the bellow configuration (like manual says): Why the same dbservername? Why not a dbserveralias? >in $INFORMIXDIR/etc/sqlhosts >…
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…
HELP! Can't start IDS9.2 w/tcp!
Hi all... I have an error which has me stumped. Any help appreciated. Machine: Sun E4000 w/4G Ram; Solaris 2.7 Installing IDS9.2 Given: Environment variable: INFORMIXSERVER=devtcp; export INFORMIXSERVER sqlhosts: testdb onipcshm dev xxx testdbtcp ontlitcp dev devtcp onconfi…
Re: Memory problems? Please help.
>>What is the connection type? shm or soc ? >> >What are these? See NETTYPE in your onconfig file. HTH Michael…
OFFICE Connect V.1
Informix Office Connect, Version 1.0, is compatible with the following Informix servers: Informix Dynamic Server, Version 7.3 or later Informix Dynamic Server with Universal Data Option, Version 9.14 Informix Dynamic Server 2000, Version 9.2 or later e Informix-SE 7.23 n�o func…
Re: cdr replication
Thanks. If I remove g= I can't keep server1 in DBSERVERNAME. I get (onstat -m): 13:57:44 CDR no group entry value for server1 -- J.RAGE FRAME SA…
Re: after adding DBSERVERALIASES into onconfig file
Nick, Thank you so much for your help! You are right about the unique port id, I did it and it works. But one thing I don't like is that for a user to be able to access the remote server without giving out been prompted for his password, he has to be either trusted by the server …
FW: after adding DBSERVERALIASES into onconfig file
Means you must update sqlhosts file to know about new alias. Wayne E. Martin Informix Database Administrator Kmart Corp. -----Original Message----- From: Kathy Huo [mailto:kathy.huo@ssi1.com] Sent: Wednesday, March 08, 2000 1:04 PM To: informix-list@iiug.org Subject: after addi…
Re: more:after adding DBSERVERALIASES into onconfig file
Kathy, You need to add the alias servername to the sqlhosts file and also the /etc/services file(+ the port) this will get rid of your problems. -25572 is a generic(at least i think so, it ranks right up there with a -908) networking error. -brian On Wed, 08 Mar 2000 11…
RE: after adding DBSERVERALIASES into onconfig file
Nigel, Thank you very much for your help! The red lines are the one I added: In sqlhosts: # added on Tue Dec 14 16:49:53 PST 1999 dataPower ontlitcp su598u 4010 # added on Tue Dec 14 16:49:53 PST 1999 dataPowerShm onipcshm su598u 4010 # remote server dpTod …
RE: after adding DBSERVERALIASES into onconfig file
First off, it may prove helpful to provide us with a snapshot of your DBSERVERNAME and DBSERVERALIASES lines from your $ONCONFIG file (before and after your changes were made) as well as snapshots of your sqlhosts file. Off the top of my head, though, you may want to check the f…
Re: more:after adding DBSERVERALIASES into onconfig file
Sounds like you might habe a FIN_WAIT on the port, check with a netstat -a if this is the case wait for it clear (typically 15 minutes) then have another go. Later versions of the engine seem to have resolved this problem, presumeably they are now using SO_REUSEADDR on the maste…
Re: after adding DBSERVERALIASES into onconfig file
There is a maximum limit for the no. of DBSERVERALIASES in 7.30 and below versions. I hope it is 10. But it depends on your NETTYPE too. We could not add morethan 8 ALIASES in 6 GB memory Box. We got create_vp: cannot allocate memory error. I don't think you need to reinitialize …
after adding DBSERVERALIASES into onconfig file
I can't bring the server ON-LINE after manually adding server aliases into onconfig file. The error message was: "shared memory not initialized for INFORMIXSERVER 'dataPower'. Does it mean I have to reinitialize the root database or reboot the server?…
dbserveraliases connect slower than dbservername
Hi, A connect issued through Dbserveraliases seems slower than through dbservername. They are using both ontlitcp. They are each mapped to a network card. If I switch the names, the one with the dbservername became faster. Nettype is tlitcp,1,100,NET Thanks for any idea ? Regard…
ODBC Connection
I am trying to connect an Access2000 database to our Informix side. ODBC is setup and I see Informix (on a Unix box) and all the objects of the database. I can import the tables from Informix and get all the data but am unable to view the data if I choose to link to the table. L…
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…
connecting to informix
I'm using NT4 and need to connect to Informix. I have not had much luck with connecting using Iconnect and DataDirect. What other connectivity software is available to do this, otherwise, what version of IConnect and DataDirect should I be using? thanks Dg…
Multiple Instance
Sarah Jessica wrote: > > Hello Solution Providers, > Is Informix 8.2 can have two different instance on the same server? If yes > then how can I have to create the other? Yes you can. I'm sure like other Informix versions you just create a separate ONCONFIG file with differen…
se 7.24 uc5 with redhat 6.1
i. cant connect to my database server either from dbaccess or informix cli from windows i receive the error -952 user's password is not correct for the database server the configuration in sqlhosts in correct, any idea Thanks Ruben…
Invalid sqlhosts format
I've this message where startup Replication Manager on my Windows NT 4.0 Workstation. The rest of programs (ODBC, IECC, ..) haven't problems with SQLHOSTS values. Thanks.…
Re: DBSERVERNAME change
From: Dick.Brieck@chase.com > >Greetings. I have a situation where I'm attempting to create an Informix > instance for test purposes which is a copy of our production system. I >want to use ontape to do a restore onto another machine. I would like to >know if it is possible t…
DBSERVERNAME change
Greetings. I have a situation where I'm attempting to create an Informix instance for test purposes which is a copy of our production system. I want to use ontape to do a restore onto another machine. I would like to know if it is possible to change the DBSERVERNAME of this r…
arcunload not working - table restore
Honda75 wrote: > Am using arcunload like this: > "arcunload -i /dev/rmt0 -s 4500000 -b 16 -o /tmp/arcunload.out -m > /tmp/arcunload.tmp cars@cars:relation_rec" > > Our tape device is set in onconfig for 4.5 Gig, and our AIX 4.3 drive is using > compression. The block size in onc…
Compatability between Informix products
Hi, I need some version compatability information for the following products. Hardware Platform: Hewlett Packard OS Platform: HP-UX version 10.20 Informix s/w: Informix Universal Server 9.20 Informix Dynamic Server 7.31 Informix Gateway to DRDA vers…
Re: What is in the name ?
From: tqma@my-deja.com > >In article <82oird$9eb$1@news.xmission.com>, > "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > > > From: tqma@my-deja.com > > > > > >Would someone please explain what are the > > >relationship/difference among: > > > > > >DBSERVERNAME, > > >INFORM…
Re: What is in the name ?
From: tqma@my-deja.com > >Would someone please explain what are the >relationship/difference among: > >DBSERVERNAME, >INFORMIXSERVER, and >hostname INFORMIXSERVER points to an entry in your sqlhosts and the DBSERVERNAME or DBSERVERALIASES entries in the onconfig file. It allows …
Re: 4gl run-time error number -25588 ..
Thanks ! We have connection on tcp !!!!!!!!!!!!! By,by ! Elvis In article <82ofam$83b$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > From: Elvis > <elvis.perezNOelSPAM@lua.sms.sachsen.de.invalid> > > > >Hello ! > >Our files: > I assume this was the "un…
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…
SQL CONNECT
Greetings, I have been asked to provide some estimates for "connect" times to databases. Does anyone have any average times for completion of an execution of the Informix SQL CONNECT statement ? I realise that this will be one of these "It Depends ..." type situations, but I woul…
odbc
Hi all I made it all. (add in c:\\windows\\services) But i have error -908 I check my network and all is right. I can connect to my aix server. I check /usr/informix/etc/sqlhosts file /etc/hosts /etc/services all is ok nut i cant connect to informix 7.2 I wath network using 'tcp…
Connect problems
--------------203C6B2724A3084FED993DB8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I have installed Informix Dinamic Server 7.3 in a redhat Linux 6.0. Before I had installed it in redhat Linux 5.2. I followed the same steps that i make in redhat 5.…
how do I find out the server name
Hi How can I find out what the server name of the Informix database is. (I need it in the jdbc url). I've been using a DBSERVERNAME variable in a config file. Is that correct? Is it somewhere else? Thanks, Salman…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Re: Dumb question
Sorry all, I think I found the answer to my own dumb question in the documentation (last place I would have thought to look). "The database server uses the ONCONFIG file during initialization" >Is it safe to edit my onconfig file when the database is live ? > >Or should I stop…
Re: oninit complain with sqlhosts file error
From: "W. J. Hsu" <wjhsu@pti.com.tw> > >Hello out there, Hello in there... >I tried to installed Informix Dynamic server 7.3 on my Linux box. >However, the oninit always complained with: > >"oninit DBSERVERNAME 'HOME' not in sqlhosts file or sqlhosts file contents > are damage…
oninit complain with sqlhosts file error
Hello out there, I tried to installed Informix Dynamic server 7.3 on my Linux box. However, the oninit always complained with: "oninit DBSERVERNAME 'HOME' not in sqlhosts file or sqlhosts file contents are damaged" The file "$INFORMIXDIR/etc/sqlhosts" was tailored from file "…
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…
Help on the minimum to test replication laptop to desktop
Hi, I would like to set up a test of replicating data from a laptop to a desktop. What is required, caveats etc and most important least cost. I would like to test on a dialup and direct connect. The connection on the dialup connection will be brought up and down on schedule …
ASF_INIT_DATA
Either: 1. your nettype in sqlhosts is invalid or it's unsupported. Check your release documentation to neee what nettype's work for your hardware. 2. your servicename in sqlhosts doesn't match.…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
Help! Cant start database service
Hello All I had my informix dynamic server (7.3) running fine till a few days back. Now the dynamic server service and the informix messenger service won't start automatically and if I try to start the server, it does start but I'm unable to connect to it. If I try to start the…
number of connections in NETTYPE
What is the limitation on numbers of connections in parameter NETTYPE in IDS7.31FC2…
problem during installation
hi i´ve had this problem in windows nt workstation and server with service pack 1, 3 and 5. I´ve been trying to install informix dynamic server 7.23 in celeron 300A, scsi drive and 128 MB of memory. I´m getting always the same problem: 'unable to create <dbservername> dbspace' …
Crossed Connections
I have recently upgraded my client/server applications from 16-bit to 32-bit NT. They are powerbuilder applications and an Image Display C DLLs. The pb and c pgms both connect to an Informix server using 7.23 Informix Esql-C (the powerbuilder using native drivers). The problem …
why is connect via C++ so slow?
There is an important detail that I ommitted, connection is via ISAPI.…
Lock Table Overflow - onconfig
We get an error in the Informix log-file. Lock table overflow. What do we have to change in the onconfig-file ? Kind Regards, Franky Thiel franky.thiel@Infohos.be…
Setting up shared memory connection
Did you add the DBSERVERALIASES line in the onconfig file? -- James Edmiston Quest Information Systems, Inc. www.questisinc.com…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
Re: ontape in HP-UX
You need verify the sintax of onconfig file for this entries: TAPEDEV /dev/rmt/0m # Tape device path TAPEBLK 512 # Tape block size (Kbytes) TAPESIZE 7800000 # Maximum amount of data to put on tape (Kbytes) (This is my onconfig fil…
No more connections
All, When i do "netstat -a | grep inf1_svc | wc -l" i get +- 50. (inf1_svc being my Informix service name). This is always when the users can't log in anymore - even though i've got NETTYPE tlitcp,2,250,CPU. Only thing i can do is bounce the server. Anyone seen this on Unixware…
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…
IFMX/Redhat 6.0
I am having problems connecting to my Informix instance...well kinda! I am able to use dbaccess to successfully connect to the stores7@demo database. These options work: * dbaccess->database->select->{select database} * dbaccess->connection->connect->{select server…
SQLhosts file
How do I modify the sqlhosts file on the UNIX server so that my server will listen for two requests, (ie: seipcpip and setlitcp) at the same time. Thanks!…
Sqlhosts Option
Hello. I have just inherited a IDS 7.30.TC3 on Windows NT system. In the SQLHOSTS entry for the server, there is an option "x=ol_maxserver", where ol_maxserver is the INFORMIXSERVER name. Does anyone know what the x option is? I checked the documentation but there is nothing t…
Number of Connections
Is there any good way of determining the number of database connections currently active or zoombies? Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc…
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.…
sqlhosts and dns.
We're attempting to migrate from having the lmhosts file on all the windows-based pc's to using DNS. However, once the lmhosts file is removed, the Informix client software can no longer find the database server. When attempting to connect using the ilogin utility, I get the -2…
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…
Connection Question....
The current system is informix 5.x with a 4gl front end. All the users IP addresses are in the DB servers host file. They are changing the network to use DHCP what do i need to do on the DB server to make sure i don't get -954 errors(client unknown to host). TIA, Bill…
Server Name
Your experience is correct. Informix will accept the dash (-) in the hostname field of the sqlhosts file, assuming that is the real hostname, but the DBSERVERNAME and DBSERVERALIASES, and the equivalent field in sqlhosts, cannot contain a dash. Either drop it or map it to an un…
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…
Multiplexed connection
Hi, I am trying to use multiplexed connection to connect between 2 machine. Server is AIX4.3.2 with IDS 7.31 UC2. Client is ESQL/C 7.24 application on AIX4.2, IDS 7.22. I have configured server for multiplexed connection like it says in manuals, but when I connect with 25 users…
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…
SqlhostsEditor for NT
amgad@starnet.com.eg wrote: > > Dear all, > > Does any one have any clue on how to obtain the Sqlhosts Editor for NT > used by the replication manager to define the SQLhosts entries in > windows NT registery. > > In the Replication training manual it says that "The sqlhosts edito…
More details
Eric Shipek wrote: > > Sorry, I can log into the server -- I just can't log into the database. In > fact I can log into the Unix server with the informix login and password. > Then I run dbaccess and try to connect to the database ol_nisbc. Then when > I try to connect with the…
Re: How to get the DBServername into my VB program ?
Have you tried 'select dbservername from systables where tabid=1` check the options of the DBINFO built-in function as well. Francis Teo Ee Cheok wrote: > ANy body has an idea how to get the dbservername into my VB Programs. > > Thanks.…
How to get the DBServername into my VB program ?
ANy body has an idea how to get the dbservername into my VB Programs. Thanks.…
unable to connect
Hi I have an Informix DBS 7.23 for NT 4 and an Informix DBS 7.30 for Solaris 5.6 On my PC I installed the Command center (Tools 7.23) The database explorer (7.23) shows both DBS and I can work with the databases. The command center shows me bothz DBS - but only the 7.23 (NT) onli…
Problems starting IDS 7.30.TC7 on Windows NT SP4.
When i try to start informix dynamic Server, the following message appears "Only informix user can start informix dynamic server" this message appears when i logged on with the informix's user. When i try to start the service on the control panel , error 2140 appears.…
Re: Informix 7.3 UC5 on RH Linux 5.2
Additional INFO: Please see attached "sqlhosts" and ONCONFIG files...…
Re: Informix 7.3 UC5 on RH Linux 5.2
In article <3756C50D.B2B0DC33@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> wrote: >> Aris A wrote: >> >> When I tried to run "oninit -i" on my Redhat Linux 5.2, I came up with the >> following "online.log". Please let me know what's wrong. Thanks. >> >> ****CONTENTS of MY …
New Era program written for local engine on online
datashark@fastlane.net wrote: > > I have an old (obviously) NewEra program running on a local SE database. > It needs to run on a laptop running OWS. I have created the database > tables, etc with the same name database on the laptop. Of course, the > program can't connect sinc…
Newbie `bout Informix/RH60 install
Andris Sverigs wrote: > > I'm trying to start informix on RedHat6.0, > but oninit fails with "Segmentation fault". > Any other executable says "Unable to load locale categories". > What could be the problem? You must set and export the environment variable INFORMIXDIR set to the…
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…
IDS refuse connection on NT when connected to Internet?
>The strangest thing; > >I just noticed that whenever I connect to Internet, I can't connect to my IDS 7.3.TC7 >on NT (connection refused - Agent_log: Attempt to connect to database server (%s) >failed.) > >As soon as I disconnect from internet, connect works. > Sounds like some…
Problems with DBSERVERALIASES
Hello Have a problem with definition of a DBSERVERALIAS, the informix server (oninit) will not start. Have the following configuration: ----------------------------------------------------------------------------------------- onconfig: ... DBSERVERNAME iserver # Nam…
Re: onconfig parameters
> onstat -c shows you the contents of the ONCONFIG file, but then so does vi > $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? Does onstat -c reflect changes made by onmode commands? I should try that and see...that, to me, would be the compelling reason …
Re: onconfig parameters
Thomas onstat -c shows you the contents of the ONCONFIG file, but then so does vi $INFORMIXDIR/etc/$ONCONFIG. Perhaps I did not understand the question? HTH Sujit "Thomas G. Smith" <tsmith@wdn.com> on 04/28/99 12:19:10 PM Please respond to "Thomas G. Smith" <tsmith@wdn.com> …
onconfig parameters
Is there a command to force the engine to show me what all the onconfig parameters (and other perhaps unknown parameters) have been set to?…
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…
48 oninit processes, when informix started
xuejinw@shubertorg.com schrieb: > > Hello: > > We are running Informix Dynamic Server Version 7.30.FC4. recently we > noticed that when the system was rebooted, 48 oninit processes were started. > That is a lot. Could not figure out why so many. need your help! > > Thanks…
How to make both 'onipcshm' and 'onsoctcp' working ?
A liner help would be highly appreciated if somebody could advise. I'm trying to setup our BBS DB for running on DS (Linux), with NETTYPE set to both onipcshm/onsoctcp, so that it's available to the Windows client via ODBC. I tried the config as follows, but either one (ie. eith…
Re: DBA problems
I think you need to revisit : NETTYPE settings and $INFORMIXDIR/etc/sqlhosts file. Can you post them ? Also the Version you are running. Harinath Venkata Svenska Handelsbanken New York…
Re: dbserveraliases
My guess would be, your platform does not support soctcp or tlitcp. See the release notes for the supported connection protocols. -- Thomas Doug wrote: > I am trying to set up a dbserveralias but I get the following error: > > oninit: fatal error in initializing ASF with '…
dbserveraliases
I am trying to set up a dbserveralias but I get the following error: oninit: fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = '25507' My sqlhosts file: t5_online onsoctcp host t5_online t5_tcp ontlitcp host …
INFORMIX and utilization of system resources on HP-UX 10.20
Hi; with which protocol (ipcshm or soctcp) did you connect the dbservername baan? I didn't see a DBSERVERALIAS in your onconfig. If it's connected with soctcp, try ipcshm. Can make a very big difference. Andrzej Piotrowski wrote: >…
connection error
could anyone tell me what's this error is? >Cannot connect to this database. >java.sql.SQLException: DBNLS is not set or LC_COLLATE must be '%s'. I use jdbc122jc1 driver. I have no problem connect to other Informix databases on other hosts. Does it have to do with firewall? tha…
I-Connect
Could someone explain, what is I-Connect in Unix box versus sqlhosts connection, if we are talking about C/S system in db-level. Is it same thing ?.…
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…
Remote Connections
Can someone tell me what steps the engine (ODS 7.24 on Solaris 2.x) uses to determine if another user/machine is allowed connection? For some reason, when I connect the hostname is in all caps, and therefore does not get resolved because they are listed in the rhost files as lowe…
Informix Port Number
Katak wrote: > Anyone out there knows how to check the port number that the Informix > Dynamic Server is listening at. As I am currently trying to connect to > the database using JDBC drivers from Informix. By the way, what is > default port number that the Dynamic Server is list…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Re: Example sqlhosts file
Thanks for pointing me in the right direction - The release note do specifically say that the only supported protocol/interface is TCP/SOCKETS. Thanks again to everyone for their help - Despite the fact that all I needed was to Read The Manual (though I couldn;t find it), everyo…
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: Example sqlhosts file
Rick Mills wrote: > > dua1@my-dejanews.com wrote: > > In article <7c71it$qmg$1@eve.enteract.com>, > > > > Art S. Kagel > THere are no release notes with the ftp'd file, and none that I can see > on the site anywhere. Does anyone have release notes specific to RedHat > Linux 5.2? …
Example sqlhosts file
I've used Informix since ver 1.1 (just had to say that), but am confused by the sqlhosts file. The last version I worked on was 4.1 and didn't use it for the SE engine. Now that I've D/L the 7.2 SE (no docs) I'm in the dark about the sqlhost file. Can anyone give me a breif examp…
Re: Slow connect times across certain dbserveraliases
On Sat, 27 Feb 1999 07:22:06 +0000, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <36d48a27.16849418@itsinet1>, Brad Coates <bcoates@cobe.com> >writes >>Has anyone ever seen the initial connection to a database take longer >>using one dbserveralias as opposed to an…
Silly Q. How to add user to database?
Here's your answer Grant [ CONNECT | RESOURCE | DBA ] to [ USERNAME ]…
Multiplex Connection
Does anybody know what it is and how it can improve performance of a client application. Do you know if there is any documentation available about this topic and how to set it up. We have HP UX 10.2 and Informix 7.3. Thanks in advance for any responses.…
Trouble solving error -931
Hello. I've got INFORMIX-OnLine Version 7.22.UC1 running on a SunOS 5.6 workstation. It runs fine when configured for shared-memory connections but fails to initialize when set to accept TCP connections. 18:06:03 listener-thread: err = -931: Cannot locat…
Re: Connect to Server only - not database from Delphi 3
How about connecting to 'sysmaster' ?…
onconfig tuning
Hi all! I have posted to the web my collection of notes on onconfig parameters. It is not yet complete but pretty far along. http://home.earthlink.net/~mildness/bamph/informix.htm It has helped me over the years to have this list in my PDA. If you think it useful feel free…
Connection Problem
My company has Informix OnLine 7.0.2 (I believe) running on SCO UNIX Openserver 5. The server is a dual PII 400 with 256 meg of RAM. Whenever we get around 50 connections to the database, we are no longer able to start up any new applications that access the database. At first …
Slow connect times across certain dbserveraliases
Has anyone ever seen the initial connection to a database take longer using one dbserveralias as opposed to another on the same NIC? Here's a picture of what we're seeing. We have 1 T500 HP (8 CPU) server (batman) running IDS 7.30.UC6. 8 CPU VPs are defined. Valid INFORMIXSER…
Re: NT tools with UNIX server
I've been wrong before, but DBSERVERNAME and DBSERVERALIASES don't actually "matter" in this case, it just has to be in one of them. IECC _must_ connect to the INFORMIXSERVER defined as a tcp connection (for semi-obvious reasons). axp1@my-dejanews.com wrote: : In article <36c33…
NT tools with UNIX server
On Thu, 11 Feb 1999 01:52:51 GMT, axp1@my-dejanews.com wrote: >Two questions: 1. I have IECC running and it is able to detect the UNIX >server, but it is using the DBSERVERNAME value for the server. I want it to >use another name defined in DBSERVERALIASES, which I have configur…
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…
Connect to MicroStation
I`m trying to connect a INFORMIX Database (IDS 7.3) to MicroStation SE Vers. 5.7.0. The IDS, the Database and MicroStation are on the same SGI (IRIX 6.2.). The only message I get is: Unsuccessful CONNECT statement Has anybody ever tried this? Are their any specific settings neces…
CONNECTION OBJECT
I am using RMI to connect my client-app to an Informix Online Dynamic Server 7.2 I have a single connection object which is used (synchronized) by all the clients. I suspect there must be a limitation in requests to the same connection. Each remote method reuses the object fo…
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…
sqlhosts
Subject: sqlhosts Newsgroups: comp.databases.informix Summary: Keywords: I need some help.I get the error message "908: Attempt to connect to database server (unix2_se) failed", when I tried to select my database from the "isql" Datbase menu. I checked the sqlhosts, /etc/hosts a…
Database connection
Please help. I have Informix Dynamic Server version 7.3 for Solaris. I configure it and set all files as: /etc/services $INFORMIXHOME/etc/sqlhost $INFORMIXHOME/etc/onconfig But when I want conect to server over the net its not work. When I want do loopback it doesnt work too.…
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?…
Regarding calling an INFORMIX procedure from a UNIX shell script
I use dbaccess for this purpose. Syntax is "dbaccess <database> <text file with sql commands>. Just be sure your informix environment variables are set properly (INFORMIXSERVER, ONCONFIG).…
Equivalent of connect by
i have a sample code in Oracle... that use connect by. wonder what's the equivalent in Informix and do i need to change the codes. code as follow: 1 select itinerary_id, dept_station,arrv_station 2 from 3 (select rownum-level itinerary_id, 4 dept_st…
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.…
connection problem
Hello~ I want to connect to INFORMIX-Universal Server Version9.13.UC3 on SunOS5.5.1 from ASP Server winNT4.0 with NT Services Pack3.0 and Option Pack4.0 I am using INTERSOLV 3.10 32-BIT INFORMIX 9 ODBC Driver. ILogin Demo works well... When I tried DB open, IE4.0 displayed fo…
Remote Connection
I have installed the Informix connectivity software on my Windows NT box and was testing my connection with the ILoginDemo software to a database on AIX. For the connection to work properly I have to have an entry for my desktop machine in the etc/host.equiv in the AIX machine.…
ASP-Informix
Has anyone ever connected successfully to an informix database through an ASP? If so, what connection string did you use? Any help is appreciated.…
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…
RE: Poll threads
Luse, I think by specifying only 1 unique type of Interface/Protocol combination in your sqlhosts file, you only get 1 poll thread anyway. By specifying the Interface/Protocol entries as your DBSERVERALIASES, the poll thread will run on a NET VP by default. Thus, your NETYPE ent…
Re: Poll threads
Luse Harold wrote: > A quick question. > > If the sql hosts file has two entries for socket/tcp connections: > DBSERVER NETTYPE HOSTNAME SERVICES > server2 onsoctcp ibm1 infmx_service2 > server3 onsoctcp ibm1 …
Re: Poll threads
Luse Harold wrote: > A quick question. > If the sql hosts file has two entries for socket/tcp connections: > DBSERVER NETTYPE HOSTNAME SERVICES > server2 onsoctcp ibm1 infmx_service2 > server3 onsoctcp ibm1 …
Poll threads
A quick question. If the sql hosts file has two entries for socket/tcp connections: DBSERVER NETTYPE HOSTNAME SERVICES server2 onsoctcp ibm1 infmx_service2 server3 onsoctcp ibm1 infmx_service3 And the onconfig file has the following DBSERVERALIASES and NETTYPE entries: …
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Re: IECC Server Discovery Failed 2nd
Hi Dale, sorry for not reading your article correctly: Are both agents running admagent and osagent ? If so, when you run stopsa, do both stop? If not, kill them and run startsa again. Is your onconfig still up to date? The agents seem to take all information from onconfig ra…
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.…
25588: The appl process cannot connect to OnLine server
I am trying to connect to a database but it does not let me connect. It displays the following "25588: The appl process cannot connect to OnLine server red1_dev711shm. Not a typewriter" And also, does someone know about this 'typewriter' stuff ? I thought funny messages came …
Re: Conflict between two Informix databases
Kent Mills wrote: > > We have recently installed a second copy of Informix on a new server. [SNIPPED problem description] Post your sqlhosts and ONCONFIG files, the output of uname -a and the /etc/services lines showing your port numbers used in sqlhosts and someone may notice s…
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…
a problem with connections
We have a problem with remote systems: We have these products: INFORMIX-SQL Version 4.12.UE1 INFORMIX-4GL Version 4.10.UC2 and RSAM Version 5.02.UC7 and we have noted this problem, for us is quite important to solve it. I'll explain: We have to remote systems, A and B, both …
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: Connection
Irineu Rocha wrote: > > Hi folks, > > What I need to do in order to perform a select statement from one > Informix server to another informix server (NT to HPUX)? I did this when > NT was just running Informix client (setnet32), but I don't have any > idea how to do between serve…
Connection
Hi folks, What I need to do in order to perform a select statement from one Informix server to another informix server (NT to HPUX)? I did this when NT was just running Informix client (setnet32), but I don't have any idea how to do between servers. Any reply will be appreciate…
Connect Failure
I have three RS/6000 boxes (S/70, R/50, E/30). I can connect to two of the three using ILogin or ROM, but not the third (the R/50). I get a -908 error. The Setnet values are almost identical for all three (all use onsoctcp), and they're using the same ODBC drivers (Informix-CLI 2…
Updating databases
What must be done,eg onconfig, to get the fastest result on updating a database alter tables, inserts etc.…
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:…
ONCONFIG on UNIX
What kind of use if the parameter "SYSALARMPROGRAM" for. And which input parameters are used. Thanks for mailing to baumschlager@pfeiffer.co.at…
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: shared memory not initialized for INFORMIXSERVER
The fact that you can work when 'if I telnet to the server, everything works fine. ' may indicate that you have no NETTYPE for shared memory in your onconfig and sqlhosts files. Hope this helps, Carl…
Re: Multithreaded process - connect problem
David Ferguson wrote: > > G'day > I am writing a multi-threaded server. I can connect to the database in > the main > thread but not in my database thread. However, once connected, I can > close and > then re-connect successfully in my database thread. You can only have one u…
Multithreaded process - connect problem
G'day I am writing a multi-threaded server. I can connect to the database in the main thread but not in my database thread. However, once connected, I can close and then re-connect successfully in my database thread. System: Solaris 2.5, Informiix 7.22 Any ideas? Thanks.…
sizes in onconfig
OWS 7.2 on SCO UNIX: Does anybody know why all sizes of dbspaces or logs, etc. are just half as big as they are in the onconfig file. If I check the size of a dbspace, for example, its file size is 2 GByte, but oncheck -pe says it's 1 GByte. Thanks in advance, Pascal…
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…
sorry about this ...
SORRY About this: > set INFORMIXDIR to a valid DBSERVERNAME , not the hostname, not INFORMIXDIR, but INFORMIXSERVER Knut…
Re: SQLHOSTS file layout ???
Dear Sir/Madam: I am Kal Thakkar, recruiter for Software Tactics, Inc., which is a small to midsize consulting firm serving fortune 1000 clients in Chicagoland area. We provide our clients permanent placements as well as consultants in software and engineering field. Currently …
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
connectivity problem
Hello I downloaded the evaluation copy of informix Dynamic Server for Windows NT4.0. I installed the software in Primary Domian controller and I am able to create the instance and database. Now I am not able to connect to the database from the client side. The client I am using i…
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…
SQLHOSTS file layout ???
What is the layout of the sqlhosts file. Is is the same as a /etc/hosts file or does it have a special format. Can't find any examples . . .…
Re: Doubt regarding L.Log size
Sadagopan, Sathish wrote: > > Hi, > LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows > > a figure of 5000 , Page size is 2K. > How can that be ? It looks like someone used onparams to add logfiles with sizes different from that stored in the onconfig.…
Doubt regarding L.Log size
Hi, LOGSIZE in the onconfig is shown as 1000 Kb, whereas size in onstat -l shows a figure of 5000 , Page size is 2K. How can that be ? TIA Sathish…
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…
pb6
Hi, Can I-Net connect PowerBuilder 6 to Informix online 5/7?? What to make it connect? TIA Nien…
Re: ? IECC Does not provide sessions and other info
You have to first connect to the database server. To do that right click on the database server name and select connect As option. Natraj DBA, Bourns Inc…
NT to Solaris via ODBC
Hi Folks -- I want to configure my PC running NT 4.0 to reach, via ODBC, an Informix 7.24.UC2 server on Sun Solaris 2.5.1 . I've run into two problems; perhaps someone has done this and could help me out. 1. The release notes say the Sun Informix server only supports TLI fo…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
Re: dbservername/dbserveraliases/nettype
"Scott Kolaya" <skolay1@nycap.rr.com> offerred: +>BTW be careful to not use the same port for shared memory and tcp in +>the sqlhosts on the server > +>Art S. Kagel +We've been using the same port for shared memory and tcp for a year now in +production. Yes, shared memory connec…
Re: dbservername/dbserveraliases/nettype
Scott Kolaya wrote: > Art S. Kagel wrote: > >BTW be careful to not use the same port for shared memory and tcp in > >the sqlhosts on the server > > >Art S. Kagel > Art, > We've been using the same port for shared memory and tcp for a year now in > production. > 7.23 > ex. sql…
Re: dbservername/dbserveraliases/nettype
>BTW be careful to not use the same port for shared memory and tcp in >the sqlhosts on the server > >Art S. Kagel Art, We've been using the same port for shared memory and tcp for a year now in production. 7.23 ex. sqlhosts: prod onipcshm aruba sqlexec onconfig: DBSERVERN…
Re: dbservername/dbserveraliases/nettype
> MS CARLEEN C AVANT wrote: > > Looking for some guidance regarding the following: > > E4000, utilizing Solaris 2.6 and Informix 7.24.UC2 > > Following is the configuration: > > DBSERVERNAME sims4000_prod > > DBSERVERALIASES prod_tcp4000 > > SQLHOSTS: > > sims40…
Re: dbservername/dbserveraliases/nettype
This is a multi-part message in MIME format. --------------7FA9E4DABEBF445E171E4B2A Content-Type: text/plain; charset=EUC-KR Content-Transfer-Encoding: 7bit Is there esqlc7.1 installed with your informix 7.2x?(It,s not good for tlitcp) MS CARLEEN C AVANT wrote: > Looking for s…
Connect Privileges
Trying to give connect to a user in dbaccess. Says permission granted, but that user name is not added to the sysusers table. Can anyone help with this ?? John…
Problem with connection PC to INFORMIX ONLINE 7.22
I have problem with connection PC (WIN95) to INFORMIX ONLINE server 7.22. On my PC I have instaled Informix Connect software as a Informix client and I traying to connect to INFORMIX ONLINE 7.22 server on SCO Unix - there is no efect. I configured every needing file on my PC ( C:…
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: +…
dbservername/dbserveraliases/nettype
Looking for some guidance regarding the following: E4000, utilizing Solaris 2.6 and Informix 7.24.UC2 Following is the configuration: DBSERVERNAME sims4000_prod DBSERVERALIASES prod_tcp4000 SQLHOSTS: sims4000_prod onipchsm SIMS4000 prod_shm prod_tcp4000 …
Re: DBSERVERALIASES
In article <3559A389.C98B48BD@cornell.edu>, Vic Goldberg <vg19@cornell.edu> wrote: > > Hi folks -- > > In order to allow easy migration to a new box, I'm trying to use more > than one > alias for a database with the same connection type. I just added the > dwdev alias > to m…
Re: DBSERVERALIASES
Vic Goldberg wrote: > Hi folks -- > In order to allow easy migration to a new box, I'm trying to use more > than one > alias for a database with the same connection type. I just added the > dwdev alias > to my onconfig: > DBSERVERNAME psdev # Name of default da…
Re: DBSERVERALIASES
This is a multi-part message in MIME format. --------------58C6CD83E9C12F5D6732CF7C Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit Don't add extra lines with the same configura…
DBSERVERALIASES
Hi folks -- In order to allow easy migration to a new box, I'm trying to use more than one alias for a database with the same connection type. I just added the dwdev alias to my onconfig: DBSERVERNAME psdev # Name of default database server DBSERVERALIASES psdev…
DBSERVERNAME
After configuring interfaces for virtuals hosts (for webservers, say server1, server2) on a host (say host0), where two instances of Informix Universal Server are running, I get the error 956 client host or user (informix@>servername>) is not trusted by the server. <servername> 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…
Informix Connectivity
Hi, I am trying to connect a WIN95 workstation that gets its IP address using DHCP and then connect to INFORMIX ON-LINE V5.x using version 5 connectivity software on the PC. We get an error -954 i.e. server does not know who the client is. Any work around or solution will be …
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…
My weird problems
Thanks to all who replied. The Logical Log problem was with memory parameters in the onconfig file. DBSPACETEMP problem still exists however Regards Lee Robertson…
problem with shared memory connections
hi all I'm having constant problems with shm connections in UDS 7.2x The error returned is -25588 - the appl process cannot connect to Online server server-name. It looks like Informix will allow so many shm connections before refusing a connection, but this seems to vary. If I …
Connectivity Question
I have a question here on OnLine7 connectivity. Consider these two machines... MachineA 1 OnLine database called "dbA" MachineB 1 OnLine database called "dbB" MachineA sqlhosts ----------------- dbAshm onipcshm MachineA shm_file dbAtli ontlitcp MachineA …
Re: OnLine Error - Network down (25588)
In article <890927184.674.0.nnrp-05.c2d9cf02@news.demon.co.uk>, Nicholas Rumble <Nick.Rumble@btinternet.com.REMOVE> writes >Did the files in /INFORMIXTMP get removed - I've seen similar problems if >they are .... > >There's an onmode command to rebuild the if so .. > >Regards > …
Onconfig Question
I sent this a few weeks ago and didn't get any responses. I am rephrasing the heading and trying again. We are not currently having any performance problems, but I am interested in hearing some opinions from the experts out here. One of our systems is as follows: Sun SPARCcen…
Re: [Fwd: OWS ERROR]
In this case you have to give the user who is trying to connect to the database, a permision to connect as minimum, how you do that?, connect to the server using user informix and then run the dbaccess or the sql editor, and do a new query: grant connect to user…
Connection to the database
We're going to install the system(using Power Builder) that we're developed outside the LAN where our database server(Online Workgroup Server) are located. Can anybody tell me what we need to do to : 1. The server that contain the database 2. The machine that will run the …
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.…
Connecting to multiple databases (one local, one remote in New Era)
Hello, We are trying to connect to 2 databases: + 1 on the local database + 1 on a remote UNIX database Both databases are Informix. Connecting to 2 databases on the remote server causes no problems. Connecting to the local database or the remote database cause no problems ei…
Database Connectivity
Is there any database connectivity between Tcl/Tk 8.0 and Informix? I believe there are drivers for Oracle and Sybase, but what about Informix? Thanks for any info.…
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…
Re: Multi Thread App
David Williams wrote: > In article <68tpjb$q9j@cssun.mathcs.emory.edu>, "Art S. Kagel" > <kagel@ns1.bloomberg.com> writes > >On Tue, 6 Jan 1998, Alexander Jaremenko wrote: > >You use the CONNECT TO ... AS <connection name> statement repeatedly with > >different connection names…
Re: Multi Thread App
On Tue, 6 Jan 1998, Alexander Jaremenko wrote: } Hello Mr Kagel, } Thank You for response. } } > ODS/ESQL-C versions 7.21 and later support threaded applications. } > Versions prior to 7.13 supported only one connection per process and } > 7.13->7.20 supported multiple sessions …
Connecting to websites
Friends, I'm using newera (v 2.12) for our database application development. I'm trying to open netscape navigator browser and go to a particular website. I could open the browser with the statement RUN "c:\\\\progra~1\\\\netscape\\\\navigator\\\\program\\\\netsca…
connection to ERwin
Greetings, I am trying to get a connection to a database from ERwin from a NT 4.0 workstation to our Informix instance which is on a Solaris 2.5 Unix box (Informix ODS 7.23). I have tlitcp configured in the onconfig and the sqlhosts done but I'm not sure what I need on the cl…
ODBC unix and dynamic SQL
Hi, Can someone give me some help on using informix odbc drivers (unix) with dynamic SQL on Informix-online dynamic server (7.22 unix) when I use "SQLprepare" I receive the message "too many or too few host variables given" but I think all is Ok R. Gueye…
Re: sqlhosts - valid entries ???
Although I come from a Windows NT environment, I might be able to share a little bit of wisdom. I will (unfortunately) need to speak in "Windows NT-speak" so I hope you are able to translate into AIX =) I run Informix Online Dynamic Server on NT4.0 (version 7.23 of the database…
Re: Freeing Logical Log with Status U
What's LOGFILES set to in your onconfig file? Try forcing a checkpoint? Jon.…
sqlhosts - valid entries ???
I'm running INFORMIX-SQL Version 7.10.UC1 on a Powerstack (AIX 4.1) and attempting to access and older 4.x SE database via NFS. I get an error to the effect that I have en invalid entry in the sqlhosts file. Now, I've setup entries in this file before using tcp sockets, etc but …
ODBC connectivity
Hi guys, Can u tell me how to connect an informix database with visualBasic's Crystal Reports? Roshni roshni@comsysmgt.com…
OPTIONS values in SQLHOSTS registry
I' m having difficulty finding complete documentation on the OPTIONS:REG_SZ: key in HKEY_LOCAL_MACHINE\\SOFTWARE\\Informix\\SQLHOSTS\\mname\\ for Informix under Windows NT. Of particular interest are possible r=0 and s=0 options. Does anyone have a pointer to reference documenta…
Beginner: What is Sqlhosts good for ?
Hello, in our department we got the informix database, and I has to deal with it. (Programming in perl/DBI/DBD). Though I looked through all manuals we got, I cannot find a specification regarding the /etc/Sqlhosts file. What is it good for ? Besides, our database was a gift, an…
Re: INFORMIX 5 : is there a SQLHOSTS file ?
Apostolos Varnas wrote: > > Peries, Chaminda wrote: > > for Online 5 you need an extra product Informix Star Ver. 5.xx in order > to communicate with > ODBC drivers that doesn't provide server side software for the > communication such those from > Openlink,SCO,Esker etc. > > Wit…
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…
INFORMIX 5 : is there a SQLHOSTS file ?
Hi ! I have been using Informix 7.2 / CLI 2.5 / ODBC. Now, I have an application I need to test against an Informix - Online 5 Database. The database was installed, I have created tables etc.. The problem is connecting to this database via CLI or ODBC. I was not able to c…
Unable to connect
Here a question from a newbie: I have a copy of Informix OnLine (as shipped by Baan) running on an NT-server. The version is 7.20.TE1. Now I would like to manage this server from my Workstation (Windows95). I have installed the client-apps that come with the other copy of Inform…
Informix Connect
Quick question. . . Will Informix Connect 7.2x for Windows 95 work with Informix 5.0 or do we need to upgrade to Informix 7.0? If this information is available from an FAQ, please point me in that direction. Unfortunately, the Informix web site leaves much to be desired as a su…
Re: Connections
>From: Johannes Plassmann <plassmann.pad@sni.de> >Date: Thu, 10 Jul 1997 09:05:43 +0200 >X-Informix-List-Id: <news.40292> > >I have a question concerning connections (CONNECT to, DISCONNECT from >commands). During program execution we set a connection to a database >server throug…
Connections
Hi there, I have a question concerning connections (CONNECT to, DISCONNECT from commands). During program execution we set a connection to a database server through (e.g. CONNECT to '@soc20_1'). In other parts of the program (running in a shared library, used by several instances…
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…
Network connection.,,
Hello all, I'm trying to connect to a INFORMIX-OnLine Version 7.12.UC1 (online dynamic server) with a esql/c application (INFORMIX-ESQL Version 7.12.UC1). I have doubled-checked the sqlhosts files, onconfig, hosts.equiv, hosts files, and restarted the database engine, only to ge…
Connection problem
I am trying to connect to my Informix box with Space Manager (I have Informix OnLine Workgroup Server on a NT4.0 SP2 box). I get an error message saying I can't connect to <server>. Now I can connect with the Database Manager. I have no clue to where to look to try and correct…
Informix sqlhosts and LiveWire connection
Do anyone know what's wrong here? I have an entry in the sqlhosts file with a g=xxx option(used for replication?). Trouble is that LiveWire reports this error during connect: [VENDORLIB] Vendor Library Error: Illegal sqlhosts file option/parameter Removing the g=xxx option wou…
Re: Resizing Logical Logs
Also, there is a MAXLOGS parameter in the onconfig file that should be increased. Madison Pruet…
Connecting to OnLine Workgroup Server 7.12 for Windows NT
Please Help!!! I am trying to connect to OnLine Workgroup Server 7.12 for Windows NT from the work station . I can ping my machine and I can see ILOGIN is working but I can not get connected to the Server using ODBC Connect CLI Driver. Please Help!!! igor13@ix.netcom.com…
Re: 7.1 initialization error
Check if the "informix" user can write into "/INFORMIXTMP" if this directory exists or into "/tmp". If this doesn't work you should send more information (logfile, onconfig, sqlhosts, ...) Uwe…
Informix connectivity
I have an Online 7.2 database. I have purchased CLI for the INET piece on the server. I will run on HP, Sun Solaris, Aix, and SCO platforms. I have an application written in ANSI C++ that runs on Windows95 and NT. I do not want to implement ODBC because we will be deploying the …
ODBC connect
Hi, I'm looking for help. I try to install ODBC 3.0 (Intersolv) on NT 3.51 for Informix Database 7.12. As I try to configure the driver I get error code 126. I found in the documentation that I need isqlt07c.dll. Where can I find it ? thanks for any help. -- -------------------…
Connect Informix databases with Paradox forms
Hi, Does anyone know how to connect an Informix database with Paradox Forms ? Eric…
trusted connection
How to set up trusted connection for Informix Online for NT server? Basically, I want to do is using SQL*editor on my Win95 machine to access Informix server on NT server. TIA…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
JDBC Connectivity
Connect Software, Inc. is pleased to announce that release 2.5 of FastForward is now available for download at our website: http://www.connectsw.com/ The new release brings major performance improvements across the entire product line, as well as compatibility with the new Java…
ODBC for Informix?
What are other ODBC choices to connect to Informix (without I-Net) besides OpenLink? I have had some problems connecting with OpenLink.…
Re: ONCONFIG
Kerry Davids wrote: > > Jacob Salomon <jake@apparel.net> wrote: > > >Patrick, > > >onconfig.std is meant as a template to copy from. If I had my druthers, > >I would have it shipped with 666 permissions so that even user Informix > >could not (or at least is less likly to) inadv…
Re: ONCONFIG
>From: satriguy@aol.com (SaTriGuy) >Date: 21 Jan 1997 06:01:04 GMT >X-Informix-List-Id: <news.32813> > >If I had my way, I'd remove it from the system all together so that it >would not be possible to 'accidentally' use the wrong onconfig. ;) >Madison Pruet I think the 'it' refe…
Re: ONCONFIG
If I had my way, I'd remove it from the system all together so that it would not be possible to 'accidentally' use the wrong onconfig. ;) Madison Pruet…
Re: ONCONFIG
Jacob Salomon <jake@apparel.net> wrote: >Patrick, >onconfig.std is meant as a template to copy from. If I had my druthers, >I would have it shipped with 666 permissions so that even user nformix >could not (or at least is less likly to) inadvertently modify it. >(Actually, in …
RE: ONCONFIG
Hi Patrick! OK. please check with env command to see the ONCONFIG environment variable, this sould containg the file being use at this moment, and please, make a copy before you make any changes, Regards :) ---------------------------------------------------------------- Mario…
RE: ONCONFIG
You have to check your env variables. One of them is ONCONFIG which will be set to either of the files. Munaf g086mnf@bomplant3.appl.ge.com ---------- From: informix-list-owner[SMTP:informix-list-owner@rmy.emory.edu] Sent: Friday, January 17, 1997 4:04 PM To: informix-list S…
Re: ONCONFIG
In <32DF327E.1DBB@mediacity.com.sg>, Patrick Stacey wrote: }I see 2 onconfig files in my etc directory (sol 2.5.1 platform). } }one has .ifmx and the other .std } }which do I edit in order to change the system configuration? }Specifically I want to configure informix for a multip…
Re: ONCONFIG
Patrick, Type the command "onstat -c | more". This option prints a copy of the current configuration to the screen, but more importantly, the second line gives the path and filename of the current configuation in use. Tracy > > I see 2 onconfig files in my etc directory (sol …
Re: ONCONFIG
If you have to ask this you shouldn't attempt to modify the file. This is RTFM, very much so. You'll depend on knowing so much before tuning OnLine in this way that if you have missed this in the manuals, you may also have missed a lot of other info. Sorry for this. I don't mean …
Re: ONCONFIG
Patrick Stacey wrote: > > I see 2 onconfig files in my etc directory (sol 2.5.1 platform). > > one has .ifmx and the other .std Patrick, onconfig.std is meant as a template to copy from. If I had my druthers, I would have it shipped with 666 permissions so that even user nform…
ONCONFIG
I see 2 onconfig files in my etc directory (sol 2.5.1 platform). one has .ifmx and the other .std which do I edit in order to change the system configuration? Specifically I want to configure informix for a multiprocessor machine (4 CPUs actually). many thanks, /pks -- [ Pat…
Multiple Open Connections to Informix 7 and Intersolv's Informix 7 ODBC Driver
It appears that if I have two or more open connections and close one ( SQLDisconnect() ), all connections terminate. Has anyone experienced this? If so, know of a way around it?…
Connectivity
Can I connect from a 7.20 OnLine and reference a 5.0 SE table? HELP???…
Re: Help I'm in crisis
Hi Tony, Check you $ONCONFIG file if the PDQPIORITY > 0, modify it to be 0, that means disable PDQ in $ONCONFIG. Please set PDQPIORITY as user environment variable for large report/ bach job only. Otherwise, every single session takes a lot of memory. Regards Eric Lam Taipei/Tai…
Re: onconfig
Hi Sue, >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this question may >appear to come from a simpleton. Stop right there. Go and fin…
Re: onconfig
> From: Sue Alsbury <salsbury@mdshealth.com> > Date: Friday, October 18, 1996 4:11 PM > > Hi there. I am an Oracle/Sybase dba. I've just been put on a project > which uses Informix Workgroup Server V7.12 on Windows NT. I have no > training or manuals in either Informix or NT, so …
Re: onconfig
In article <3267E47A.54DA@mdshealth.com>, Sue Alsbury <salsbury@mdshealth.com> writes >Hi there. I am an Oracle/Sybase dba. I've just been put on a project >which uses Informix Workgroup Server V7.12 on Windows NT. I have no >training or manuals in either Informix or NT, so this …
onconfig
Hi there. I am an Oracle/Sybase dba. I've just been put on a project which uses Informix Workgroup Server V7.12 on Windows NT. I have no training or manuals in either Informix or NT, so this question may appear to come from a simpleton. I issue a select * from tablename. The tab…
Erwin connection:
Does anybody out there know who I can get Erwin ODBC (Win95) connection to informix database…
Re: Shared memory connections
>>The purpose of the alias is to allow the same server to have different types of >>connections. If you only need shared memory connections you only need one line >>in the sqlhosts file per server. > >True. And I also have a need for network connections, and have a line for tha…
Re: ONLINE DS and NT registry
> Hi informix'ers > in the registry : SOFTWARE --> INFORMIX --> SQLHOSTS > I have 2 unix machines with ONLINE installed, > the dbservername is equal on both of them, I 've added > the values for machine one successfully, but when I tried > to add the other on the registry won't a…
Re: ONLINE DS and NT registry
adel@q8petroleum.com.kw wrote: : Hi informix'ers : in the registry : SOFTWARE --> INFORMIX --> SQLHOSTS : I have 2 unix machines with ONLINE installed, : the dbservername is equal on both of them, I 've added : the values for machine one successfully, but when I tried : to add th…
I-NET 16 bit using PPP connection
I am trying to connect to Informix 5.04 running on Sun Solaris 2.4 using ppp connection from a windows 95 winsock.dll. I am getting a -932 error/getservbyname(WSANODATA). If I am using a network connection from the same box the ILOGIN will work. The serv…
Socket Connections
Hello I am trying to develop a Java applet that allows employees to do their timecards online with an existing Informix database. My first thought was to try and use JDBC, but I am now told that Informix already listens for a socket connection on port 1525. How can I access the…
Informix Remote Commands
Is there an Informix "remote" command which connects to an Informix database not on the Web Server?…
Re: esqlcgi, how to use INFORMIXSERVER with web freeware?
in 5.xx for online it is TBCONFIG and INFORMIXDIR but INFORMIXSERVER is new from 6 on. DBSERVERNAME must match the DBSERVERNAME in the TBCONFIG file in your INFORMIXDIR/etc directory..... Hope this helps!!! ------------------------------------------------------------------------…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: Communication between servers and Informix 5 and 7
U should use the server name set up on remote host and this server should have an entry in your sqlhosts file. HTH ____________ Sanjay Kumar Email: skumar@raileurope.com…
Re: John Powells question - dbservername in SPL
Jack Parker wrote: > > I think what John wants to do is: > > create procedure tst_dbs(srvnm CHAR(64)) > > CALL database@srvnm:procedure(parameters); > {^^^^^} > > end procedure; > > (I also want to do it) > > any thoughts? > > cheers > j. Hi Jack, ok if I understoo…
John Powells question - dbservername in SPL
I think what John wants to do is: create procedure tst_dbs(srvnm CHAR(64)) CALL database@srvnm:procedure(parameters); {^^^^^} end procedure; (I also want to do it) any thoughts? cheers j. _________________________________________________________________________…
Changing DBSERVERNAME - correction
In a previous note I indicated that we had successfully created an onipcshm alias - this is not the case. We had no problems with a tcp alias, but since each alias starts a listening thread - the second onipcshm thread gets heartburn. Yours in trial by fire cheers j. _________…
Re: Chaning DBSERVERNAME on the fly
(problem with upper case letters in DBSERVERNAME - wanted to change DBSERVER name) The Jonathan spake: > > You would probably be able to edit $ONCONFIG, take OnLine off-line, > and then bring it back up again. Add the old name as a DBSERVERALIAS, > perhaps in all lower case. > …
Chaning DBSERVERNAME on the fly
Probably an RTFM. Is it possible to change the DBSERVERNAME w/o re-initializing the engine? Some poor fellow I know named their SERVER with a capital letter in it. Online does not appear to appreciate the cap. cheers j. __________________________________________________________…
Test Delete This Message
Test, to check is connection okay…
Multiple Instances Problem
I have 2 Online-Instances running under SINIX-Y V5.42 on a RM600. Informix Version 6.00.UE1. Let's say one is named server01 with the alias server01_net for net access, the other server02 with the alias server02_net as well. server01 emphasizes net access, so the tlitcp is set to…
7.12 SGI sqlhosts problem?
I am installing 7.12 for SGI Irix. I run oninit -i and get: DBSERVERNAME xxx not in sqlhosts file or sqlhosts file damaged. This file works fine with 7.1. I have checked and re-installed the product 3 times, ensuring the INFORMIXDIR env var is set etc. I have check the permiss…
Connection to Informix
I'm working with PowerBuilder 4.0 and Informix 7.4 (?). I have a dialog box when the user have to type his login and his password and press an accept button. Then, the login and the password in the sqlca are setted with the values of the fields in the dialog, and …
CONNECT syntax
Can anyone tell me the syntax for the CONNECT statement for ISQL 6.0? Specifically, how is the USER clause specified? Please email if possible. Thanks -- Allen Nguyen…
Re: Connection performance 7.10.uc2
dproksch@vrx.vhi.com wrote: >We have toyed with the idea of multiple DBSERVERALIASES to have >multiple listener threads but I think this would cause the problem >to happen in three different places. This does help. We use 5. Also, you can increase the number of Poll Threads (NE…
Re: INFORMIX-Online Dynamic Server intallation
copy the standard onconfig file and make as few changes as possible to the different parameters. after you are sure you can bring informix online, should you begin to make changes to the onconfig parameters. Use ONMONITOR to make the changes. It will protect you from many mista…
INFORMIX-Online Dynamic Server intallation
I'm about to install INFORMIX-Online Dynamic Server V.7.1 on a SPARC 1000. Has anyone installed this database on a sparc before? If yes...do you have any suggestions or could you give me any advice on certain aspects of the installation you felt might be important to take notice?…
Re: dbservername conventions
Not necessarily. You may consider to use the following convention. 2-char (standard) state name, 3-char location name, 1-char machine id, 1-char application id, 1-digit infomix online instance running on it. Hope this helps. thanx. Ravi.…
dbservername conventions
How do other shops name their online instances? We are new to Informix and want to set up our environment intelligently. We are a large multi-state bank with a fairly sophisticated network. We will be putting two servers, in different states, to run a new application. In the …
sqlhosts file
Does anyone know the fomat for the sqlhosts file? I am using Informix for SCO unix. -- Long Live UNIX !, Windoze is a waste of time.…
Process Priority with onilne 4.10
Does Online ver 4.10 have fixed priority support like ver 7.0 does with the NOAGE onconfig param. Thanks Chris…
Informix connectivity
-> How can one tell if informix i-net & i-star are installed properly? They work! Seriously, though, there isn't much you can do beyond a -ps- to see if the processes are running. Maybe johnl@informix.com has some ideas. Regards Billy ---- Digitec Online - 20 Nodes....* Joha…
Database connectivity
I get the following error when trying to attach to an on-line database on a remote server. 908: Attempt to connect to database server (segfs001) failed. Bad file number I've set up the /etc/hosts, /etc/services $INFORMIXDIR/etc/sqlhosts files. -- ___ / /( \\ \\ …
Informix connectivity
How can one tell if informix i-net & i-star are installed properly? -- ___ / /( \\ \\ | \\ | \\ \\ _)/ / (__ __) : ^ : """…