Oninit® Archive
Results for “DBSERVERNAME”
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ú ------------------------------…
Cannot connect to Informix database via Python
Hi Malcom, I followed following document and it worked for me using sqlhosts onsoctcp protocol. https://github.com/OpenInformix/IfxPy Note: Client SDK should be installed and LD_LIBRARY_PATH should be exported. Regards, Nandkishor ------------------------------ Nandkishor Singare…
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
The failure to connect could well be behind those version mismatch messages - how could a version match or mismatch be determined without a connection? - so let's consider those irrelevant for the moment. Koonjul, can you try the following password-less remote connects and select…
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…
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…
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…
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?…
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
Thank you all who are responding and very active in IIUG. Hello, I am able to connect to database server through OAT only while i mention the IP address instead of hostname in SQLHOSTS file. but whlie using the hostname in SQLHOSTS file it is not connecting to database server. …
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…
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
If I connect to the instance on the local machine, I can connect. If I try and connect to the instance on the remote machine, it fails...darn.…
sqlhosts file
For the sqlhosts file, if you have two servers (primary and secondary for HDR), will the sqlhosts file have 3 entries? Primary One for shared memory with name of primary and two for tcp(one for each server)? Secondary Same thing(3 entries) except for shared memory, it will have…
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 ?…
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…
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…
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…
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
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
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?…
Sessions Connection Info
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.…
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? …
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.…
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 ?…
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!…
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…
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:)…
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…
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…
Any Mac IDS users out there?
I'm curious if IBM supports IDS connectivity via Informix's connectivity or DRDA?…
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…
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…
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 …
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…
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…
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 …
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 don't know how to specify the protocol, for the jdbc connector? Could you send an example of the onconfig and sqlhosts? Is the protocol "fixed" by the entries in the files you mentioned?…
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…
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.…
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: 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…
oninit
oninit -i informixserver does not match dbservername or any of the dbserveraliases failed…
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: 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 …
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 …
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…
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…
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…
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?…
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 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: 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…
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…
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…
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…
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
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…
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…
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…
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…
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'?…
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…
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…
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 Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
RE: 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…
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…
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 /…
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…
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…
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…
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…
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: 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…
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. …
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 …
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…
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…
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…
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…
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…
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 …
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: 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.…
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…
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…
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.…
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…
Linux VS NT4.0
Hi, Is it true that Informix Dynamic Server workgroup edition 7.30 is ported for Linux, and if it is so does anyone can tell me what to chose between Linux and NT4.0 for running Informix Dynamic Server workgroup edition 7.30. Also I'd like to know for which version of Linux, Inf…
Re: 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…
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 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…
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.…
Re: Connect to Server only - not database from Delphi 3
How about connecting to 'sysmaster' ?…
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 …
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
Michal Klacan wrote: > > 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 If the above two lines are not a typo this is the problem. The en…
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?…
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…
Index on Informix Online 7.22 ?
I have installed a new Informix Online Dynamic Server 7.22UC3 on our server (HP-UX 10.20). I find it is much much slower than the Informix 7.12 Online DS server if I do not create index for a same program. Why and what is the difference between the two version of Dynamic serv…
Re: esqlvers statement.....results are different on 2 DB servers ???
Tim Jones wrote: > > I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 > servers. Let's call them Server A and B. > > Both A and B had a prior ESQL/C versions. > > After the install, logged in as informix userid on A and ran "esqlvers" > and got this : > I…
esqlvers statement.....results are different on 2 DB servers ???
I've installed Informix 7.30UC3 with the ClientSDK 2.01 software on 2 servers. Let's call them Server A and B. Both A and B had a prior ESQL/C versions. After the install, logged in as informix userid on A and ran "esqlvers" and got this : INFORMIX-ESQL Version 7.22.UC1 …
Informix Dynamic Server Personal Edition
What development apps are known to work with IDS-PE for 95? Infrmx wants to sell me licenses for Dynamic 4gl, esql-c, ddvb for 150usd. Do these work and are there others? 150 sounds ok but the catch is is that the Open-Line Support is outrageous for this (3K usd for unlim. suppor…
Will informix 7.24.uc5 compatiable with solaris 7?
Hi there, I was wondering if Informix Dynamic Server 7.24.uc.5 will be compatiable with solaris 7 when it comes out? Thanks advance, Pat Militzer pmilitzer@ultracom.com…
Informix Online Dynamic Server 7.2.2
When I try to iniailize the shared memory I get an error "oninit: Critical error initializing shared memory" I checked the log and it says the base memory address is 0x80080000 and should be 0x80400000 when I change it it reverses. this is on a SCO open server 5. nay ideas.…
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…
Deployment Licenses of Informix Dynamic Server
I need a free Deployment Licenses of Informix Dynamic Server!…
Re: Informix Dynamic Server blocks
In article <3609EB18.2AB1B1CD@bull.net>, Helmut Leininger <Helmut.Leininger@bull.net> writes >Hi, > >Sporadically, the Informix server seems to block (every try to connect >or onstat times out and no reaction on onmode -ky). In the MSGPATH I >find the following message: > >09:03:…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Informix Dynamic Server blocks
Hi, Sporadically, the Informix server seems to block (every try to connect or onstat times out and no reaction on onmode -ky). In the MSGPATH I find the following message: 09:03:42 mt.c, line 8362, thread 2139, proc id 17096, mt_notifyvp timed out. Informix server is 7.22.UC2…
Re: 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.…
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: 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…
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 …
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…
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 > …
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…
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…
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.…
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???…
Erwin connection:
Does anybody out there know who I can get Erwin ODBC (Win95) connection to informix database…
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…
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: 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.…
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? -- ___ / /( \\ \\ | \\ | \\ \\ _)/ / (__ __) : ^ : """…