Oninit® Archive
Results for “SP_WAITTIME”
Not enough room in ROOT DBspace
Reduce the size of your PHYSFILE. You probably moved it to another dbspace after setting up the first server. Start it smaller, then create the plog dbspace and move it there and resize. j. On 1/4/17 4:09 PM, STEVEN AB wrote: > Hi, > > I'm trying to setup a new server with the …
Web Based Accounting Packages?
Are there any true web based accounting packages? We're interested in installing the software on a Windows2000 server using SQL2000 as the database but want the remote locations to install a thin client utilizing the web to connect to the server?…
Gathering EXTREME amounts of time in %sys CPU
It looks like we found our problem. We run Patrol to monitor our system automatically. When we took a dump tape and sent it to NCR for analysis, the only thing that they found that was running on all cpu's was Patrol. We subsequently turned Patrol off, and the %sys cpu problem…
Error -25587 using a shared memory connection.
Anything in online.log ? MARCUS HAARMANN…
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 ------------------------------…
Question of dostats
Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection. There is an option to use a shared memory connection but then you can only process one database per run. Art ------------------------------ Art S. Kagel, President and Principal Con…
curious about extendable chunks
Hello Mark, you don't need a storage pool to extend chunks. You only need to set that chunk extendable: $ echo 'EXECUTE FUNCTION task("modify chunk extendable on", 4);' | dbaccess sysadmin - # set chunk#4 extendable $ echo 'EXECUTE FUNCTION task("modify chunk extend", 4, "8GB");'…
NETTYPE connections per thread
Hmm, I think I'm getting threads and listeners tangled up. The config is about connections per listener, performance is not affected below 500-700 connections per listener. Per your reply on my other post, the engine will increase the number of connections as required (except for…
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…
Error in SQL Linked server to Informix DB
Hi Eric, I created an ODBC connection on my client (a windows client with Sql Sqerver), then a created a linked server in sql server. I try your tip and let you know. Thanks Gianni…
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…
ONMODE -Y on the client side
"onmode -Y" turns on SET EXPLAIN for given session. "onmode" isn't distributed with the client software and connects to an instance's shared memory so is strictly server only. Presumably you don't control what the client is doing otherwise the obvious thing to do would be to run…
listener-thread@soc_be.c:3073: err = -25582:
The message will be seen whenever something connects to your Informix listener and disconnects without following the Informix SQLI protocol. This could be more or less anything like the telnet or curl client utilities or any program that opens a socket and disconnects. Whether t…
Re: 12.10.FC9 1809 Error
i'm just connecting on shared memory (onipcshm in sqlhosts) regards…
Informix and speculative execution
Hi all, I have seen speculative execution patches for Firefox and SQL Server. Are there speculative execution patches for Informix in progress? There is no IBM Flash for Informix Dynamic Server and speculaative execution! Regards, David.…
Rovoke insert permission but still can insert
I am doing it at the command line in the server directly in the directory C:\\\\Program Files\\\\IBM\\\\IBM Informix Dynamic Server\\\\11.50\\\\bin…
sqlhosts file
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px #715FFA solid !important; padding-left:1ex !important; background-color:white !important; } I wouldn't use a shared memory connection because of the issues that it will cause if a failover is required. Clie…
Sqlhost entry on the client server
Original post: 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…
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)…
new features about dynamic parameter added in 12.1
There may be a better approach, but if not you can do something like: 11.7: onmode -wf dummy=1 Configuration Parameter to be changed is not valid or not supported with this option. The following documented configuration parameters and environment variables can be modified on t…
Setting up SDS cluster
HP-UX B.11.31 IDS 11.70.FC8W1 Setnet 4.10.TC5 Hi All When I start the connection manager and try to connect from a Ilogin I get a -908 error. I have checked the port setting on both client and server match but still get this error. Any advice will be appreciated. thnx…
SDK degrades IDS
When Web Server connect With SDK client, the IDS degrade. I configure the NETTYPE soctcp,2,600,NET NETTYPE ipcshm,2,500,CPU I need know what happen and if I reconfigure another parameters…
SQLHOSTS for HDR
Hi Jacob. Enterprise Replication requires that all database servers participating in replication be members of database server groups. So, if you are combining Enterprise Replication with HDR, both the primary and secondary HDR servers must be members of the same database server…
RSS not working
-bash-4.2$ onstat - IBM Informix Dynamic Server Version 11.50.FC9 -- On-Line --…
System Or Internal Error InterruptedIOException
Hi, in your Informix Server environment you can do: % finderr 25582 -25582 Network connection is broken. The connection terminated because the network is down, the database server is offline, or the client is offline. If you receive this error on a client, check the network co…
Informix upgrade
Can we upgrade informix from Dynamic Server Version 11.70 to 12.1 workgroup edition directly?…
Warning: The storage pool is out of space
Doesn't SP_THRESHOLD = 0 mean it is the automatic is off ? > Hello All, > > I am using the IDS 11.70 FC4, and I am not using the automatic storage > pool > provisioning feature. > > But, I have seen this message in the online.log file. > > I have enough free space available in t…
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.…
Trusted JDBC Connections to IDS
Hi Forum, I understand that it is possible to configure IDS to trust DB connections from particular hosts, so that a password is not required. In the past I have done this with 4GL and dbaccess client connections to remote linux servers, by specifying the client host names in t…
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,…
What are best onconfig parameters for a DSS app
Frank.... first question: Is your database installation being made for a production system???? Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 IBM Information Management Informix Technical Professional IBM Infosphere DataStage Technical Professional …
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…
952 errors
I have had this error heaps. Often happens when client pases incorrect connection string to the server which contains login/passwd. Could it also be batch running regularly with wrong connection string ? Have experinced it a lot with OAT related connections…
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 …
Shared memory connection to HDR Secondary
Folks, IDS11.50 FC8, Redhat Linux It is not allowed to have a shared memory connection to a HDR Secondary( with dbacess..), is it? Thanks, Frank --001517588cfa01cb4304b178d099…
PSORT_NPROCS
Hi, If I have a large box, lots of physical CPUs in the server, the client application run in another box, connected trhough TCPIP, I want to set environment PSORT_NPROCS, Is it being set in client or server side ?…
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
Just to be clear. You cannot use a shared memory connection in HDR, etc as DBSERVERNAME. You may use it in DBSERVERALIASES. My HDR is operational. I have identified the problem ( with tips from Madison) and posted below.…
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.…
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.…
Err -25571 to connect server
Hello guys, I have the following scenario: Recently i installed the new IDS 11.70 FC1 on RedHat EL 5.5 (server A) without problem until this time, but today i tried to connect to this server from clientsdk 3.50 TC1 on windows (client) and i get the following error to apply and te…
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…
Shared memory connection - IDS 10.00.FC8 on HP-UX
HI all, I have shell script which am running from server has dbaccess command ( example - dbaccess database_name test.sql ) (test.sql contains delete statements) while running this shell script it takes shared memory connection which I can see through (onstat -g nss and ps -eaf…
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…
loading file from the CLIENT (in SP)
Hi there, does anybody know is there a way of loading a file from the client file system to the SP running on the same client connected to IDS? I would use LOAD if that would work in SP, I would use EXTERNAL TABLE but it reads the file from the server side not the client's filesy…
951: Incorrect password or user informix is not kn
Hi, I forgot to mention that, on this instance i can connect with an unix user other than 'informix'. Doesn't this alleviates the assumption of 'a lack of shared memory or a problem with shared memory' ? Regards…
IDS 10.00 maximum concurrent sessions
First, you CAN limit the number of concurrent shared memory connections. Since the communications blocks that shared memory connections use and the semaphores that protect them are allocated when IDS starts up, the number of available connections via shared memory is fixed at sta…
How to secure ODBC connection
Hi, how can i implement secure (encripted) odbc connection from windows clients to informix dynamic servers 11.5 ? I read something about client supports SSL but no idea how to implement or use it. The big problem is some sniffer catching odbc users and passwords, and of course…
Informix Dynamic Server Software Downloads
It appears IBM has cleverly hidden the IDS downloads again on the Passport Advantage Website, at least from my prying eyes. I can find the Solid DB and the DB2 links just fine. Does anyone out there in IIUG-land with a Passport Advantage account know where IBM has stashed the dow…
OPTCOMPIND and perl
Anyone know if I can change OPTCOMPIND after establishing a DB connection or does it need to be set before connecting? ta SLES10 SP1 IBM Informix Dynamic Server Version 10.00.UC5…
Re: Connection manager redirect
Hi Madison, and how we work around this problem, because in a real situation when we have remote clients connecting throw the connection manager, the information that receive the client about the way to connect directly to the IDS server is the same that the server has at the sql…
Informix Dynamic Server Scheduler question
Hi! I'm working on a project at my faculty. It's a java desktop application with an informix database. I have a problem using informix dynamic server scheduler. I have a particular table in my database. This table contains records that are inserted by the desktop aplication I'm …
IDS 9.40 End of Support Imminent
I have seen a number of posts on CDI recently related to IDS 9.40 As per the announcement on September 7th 2007, effective on the dates listed below, IBM will withdraw support from the following product releases licensed under the IBM International Program License Agreement: 9…
IDS connectivity with Client running INFORMIX STAR
We have our server running the database in Informix Server (IDS 11.0). This machine is having the RHEL 5.0 OS We have a machine having INFORMIX STAR or INFORMIX NET (5.0) client. This machine is having the SCO Unix OS Is there any possible ways to connect INFORMIX STAR with IDS …
-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…
connecting to database instance through remote VB
HI We have application on VB which used to connect to remote unix/informix server using RDO. this server was not secured, now we migrated to new server which can only connect through SSH. Now when we are testing application VB client it fails and is not able to connect. can an…
use stored proc that return multiple columns in a query
forgot to include version info: IBM Informix Dynamic Server Version 10.00.UC6W5 -- On-Line -- Up 207 days 22:14:39 -- 1441100 Kbytes…
installing informix dynamic server in linux
hi, I'm new to informix... I tried to install informix dynamic server(iif. 11.50.UC2E.Linux-RHEL4.tar) in my linux machine. I'm getting an error like this... One or more prerequisite system libraries are not installed on your computer. Install libpam.so.0, libncurses.so.5…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
Informix Dynamic Server v 11.50 Developer's Edition
Does everyone know that the Informix Dynamic Server Developer's Edition v11.50 that you can download from the IIUG Web site (www.iiug.org) is NOT timebombed, is completely and fully functional (including HDR, MACH11, ER etc.). Do you know that the only limitations on this versio…
CONFIGURATION ONAUDIT-IBM Informix Dynamic Server
Hello, I need to configure onaudit and onshowaudit able to register for each of the consultations that are made to the database, either through dbaccess, ODBC or another application. I've been reviewing the IBM Informix Trusted Facility Guide, but I was not working. What param…
How to use Informix Dynamic Server
I have installed trial version of "Informix IDS Dynamic Server Developer Edition 11.5 for Windows 2003, XP, Vista, 32bit Version 1150TC1DE". But i am new to informix. Can anyone explain how to use IDS in detail.…
shared memory connection problem/misconfiguration
I have the following very simple esql program that uses a shared memory connection: main() { EXEC SQL WHENEVER ERROR STOP; EXEC SQL connect to 'mydb'; EXEC SQL disconnect 'mydb'; } About every fifth run of the program, I get the following error: Program stopped by WHENEVER …
PHP/PDO maintained? *NM*
Adam -- The PDO_IBM driver uses the common CLI driver to connect to IDS. Because the CLI driver is included in the IBM Data Server client bundles only, you cannot build PDO_IBM with the Informix CSDK. Regards, Mac Gerling…
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…
Update from Digital 7.31.FD1to ....
Baan IV run not on the same machine and connect to the informix server with an 1GB crossoverethernetcable. so we use not Shared Memory to access the database!…
Number of users
Ricardo Manzo wrote: > 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 ) > > It depends. If you use TCP connections, I don't think there is any way. If you're using shared memory connections, you can …
Error 25588 : IDS 7.31UD1 on Solaris8
Thank you Art for your quick response. First of all sorry for dropping the threat in the second message I posted! I thought the number specified in the parameter NETTYPE was the maximum of concurrent connections of that type. We are having the problem after 50 sequential connec…
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…
how to I know I am connected to shared memory.
Hi, I am hoping some Informix expert can give me some info on this. I have setup shared memory connection for informix. After I connected to the database using shared memory, is there a way to verified what I connected. Like may be some database views or tables that show the …
Re: TCP Listeners: Preferences?
david@smooth1.co.uk wrote: > I believe you need shm listeners as some commands reply on a shm > listener. Which command are you thinking of? There are utilities which attach direct to the main shared memory segments - ON-Stat being a representative - but that is different from …
problems with Informix dynamic server 9.4 @ WIndows 2003
I have problems with connecting the server. I use correct user/password to connect to the server, but the server do not known the server. I'm sure the user exist and is one of the user in Informix_Admin group. I have installed Informix dynamic server 9.4 in a windows xp system in…
Re: # of cpu' vs. cpu speed
Be sure to use shared memory connection if batch runs on same server ac DB engine rather tha tcp/ip sockets for batch --- it saves quite a bit of overhead. Ken…
Re: Attempt to connect to database server (mydbSer
On 1/17/07, ART KAGEL, BLOOMBERG/ 731 LEXIN <kagel@bloomberg.net> wrote: > That's very odd. I've never had to add a shared memory port to /etc/services. > indeed the manual says: > > Because this is a shared-memory connection, no entries in network > configuration files are requi…
shared memory
Hi, Your shared memory is used because Informix needs it. It is that simple. Shared memory is being allocated for each connection. I saw systems with several Gb of Shared memory. Why do you think the 100000 is a maximum value for initial segment ? What OS is being used ? The sys…
How to prevent user connect with ids
set up shared memory connections and use that connection protocol for your 4gl prgrams don't set up any tcpip connections roger@star2000.com.tw wrote: > Hi, > MY box is ids 9.40 on AIX 5.2. > How can I make a user that he can telnet to the AIX and run 4gl > program, > But prev…
Re: ISQL install problem
Hi Clive, I do have an unlimited shared memory connection, but am not sure of any others - is there a way that I can check this? Thanks Andy…
Re: ISQL install problem
I assume you are connecting to a server called linux_test and you are using a shared memory connection? there is no mix up here with a 32bit and 64 bit product (FC tool and a UC engine or vice versa?) otherwise it sounds like it may be time to contact your support provider…
onmode -ky hangs
Hello Frank 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. During the load job you added several virtual memory segments and consumed…
Re: Shared memory connection error.
Hi, no. This address is not the problem. It is the address where the SHM segment is mapped to in the instances private memory space. [ Each process has it's private memory space. SHM (shared memory) segments are allocated by the OS and then mapped into the private memory sp…
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: Contiguous shared memory segment allocation failed at 0xd0000000
SHMBASE is different in your config from standard - why? How much shared memory is allocated to this instance (onstat -g seg) ? How many locks do you need for this process (16:10:23 dynamically allocated 100000 locks) ? OR you could lock the table. You need to configure LOCK…
Contiguous shared memory segment allocation failed at 0xd0000000
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000.…
Contiguous shared memory segment allocation failed
I was doing a mass update, delete ( big transaction) and found the info in online log, 16:10:21 Maximum server connections 21 16:10:23 Requested shared memory segment size rounded from 8604KB to 8608KB 16:10:23 Contiguous shared memory segment allocation failed at 0xd0000000. Al…
Re: Security Vulnerabilities Addressed in Informix Dynamic Server
Clive Eisen wrote: > Ian Michael Gumby wrote: > > Yes the buffer overflow issues are a pain and frankly they shouldn't occur > > if IBM did formal code reviews. Or rather they should be caught and > > corrected prior to release. > > > > "Paul Watson" <paul@oninit.com> wrote in m…
Security Vulnerabilities Addressed in Informix Dynamic Server
Not sure if this has posted here or not but .... http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=D600&u id=swg21242921&loc=en_US&cs=UTF-8&lang=en Cheers Paul Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THER…
Initialising Informix
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: 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/…
program hangs
On Mon, 20 Feb 2006 17:05:30 +0100, "Danny De Koster" <ddk@fidelity-soft.be> wrote: >OS: Linux SuSe 9.2 >IDS. 9.40 > >The program can't make any connections too the INFORMIXSERVER > > Are these connections shared memory or network? JWC…
Fragmentation Elimination Problem
I am on version IBM Informix Dynamic Server Version 10.00.FC4.…
Re: Informix Dynamic Server 9.30 - Shared Memory
Ronald Schwingel wrote: > Can someone please tell me how much Shared Memory (gigabytes?) > Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use > before asserting with a Shared Memory access error? Can you provide > documentation that I can pass on also? It looked to…
RE: Informix Dynamic Server 9.30 - Shared Memory
First off you shouldn't be getting shared memory access errors. That sounds more like a bug that technical support should address. I wouldn't be surprised if your getting can't allocate additional shared memory segment messages. Informix 32-bit on AIX is a bitch. The problem …
Informix Dynamic Server 9.30 - Shared Memory
Can someone please tell me how much Shared Memory (gigabytes?) Informix Dynamic Server 9.30 (32-bit version) for AIX 5L can use before asserting with a Shared Memory access error? Can you provide documentation that I can pass on also? We are looking at providing one of cust…
create a DB on Linux
Hi! I have installed Informix dynamic server on Linux. Now I want to create a data base. What should I do? Thanks…
Re: flagship sunk
Funny I have been able to download IDS 10 for Solaris, Windows and Linux am I just smarter than everyone else? www.informix.com Support and downloads In the middle trials and betas Oh look Informix Dynamic Server (IDS) V10.0 easy!…
connecting to Informix results error -908
Hi ! I have Informix Dynamic Derver 9.4 and Client-SDK 2.90 running on Windows XP. The problem is that trying to connect the client to the data base results : error -908. Informix Error Messages tells about this error: "Attempt to connect to database server (servername) failed." …
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 sqlexecd for remote tcp connections.. problems :(
I ended up getting everything working. It was a combination of: for connecting from the local server with dbaccess: 1. setting the DBPATH=//database_connection_name/path/to/db I also had to set 1. on the client plus the following: 2. changing the sqlhosts from onsoctcp to se…
New IDS Forum on IBM Developerworks website
This forum provides a place for Informix Dynamic Server developers and users to share their questions, thoughts, and ideas with others. http://www-128.ibm.com/developerworks/forums/dw_forum.jsp?forum=548&cat=19…
IBM Informix IDS 9.3 UC3 for aix
I had install Informix database on my servier. entironment just like this: service: ibm rs/6000, m85 os: IBM aix 4.3.3-11 database: Informix IDS 9.3 UC3 Question: sometime, client program report "Can't connect server", but at same time, some client(same program) will connect s…
Re: IDS 10 Express Edition
Note 10.00.xC3 = Enterprise Version 10.00.xC3E = Express Edition http://publib.boulder.ibm.com/infocenter/ids9help/index.jsp?topic=/com.ibm.relnotes.doc/uc3E/idse_win_release_notes_10.0.html Then click on "IBM Informix Dynamic Server Express Edition" in the right pane:…
setup Informix Dynamic Server Version 9.40.UC1E1 to linux error
I setup Informix Dynamic Server Version 9.40.UC1E1 to linux execcute oninit -ivy is failed the online.log is write /// 16:31:32 Dynamically allocated new virtual shared memory segment (size 8192KB) 16:31:32 Informix Dynamic Server Version 9.40.UC1E1 Software Serial Number AA…
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…
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…
Catching runnig SQLs
Nebojsa Sevo wrote: > On Wed, 11 Aug 2004 10:32:31 +0200, Claus Samuelsen <csa@eye-bee-em.com> wrote: > > >>Consider using I-Spy. >> > > Does I-Spy "listen" shared memory connection2?? No, shared memory and stream pipe connections are not supported, so clients must be set up to …
Re: Error Initialize Informix Dynamic Server
Art S. Kagel wrote: > On Wed, 04 Aug 2004 05:05:41 -0400, madiego wrote: >>I install Informix Dynamic Server and when I initialize 'oninit -iv' : >> >>This action will initialize Informix Dynamic Server; any existing Informix >>Dynamic Server databases will NOT be accessible - Do…
Error Initialize Informix Dynamic Server
Hello, I install Informix Dynamic Server and when I initialize 'oninit -iv' : This action will initialize Informix Dynamic Server; any existing Informix Dynamic Server databases will NOT be accessible - Do you wish to continue (y/n)? y Checking group membership to determine ser…
Re: Informix Dynamic Server and DB Tuning
I am experiencing similar problems with users migrating from Standard Engine to IDS 9.30. It appears that some applications are more susceptible than others. What application(s) are you running? We also have experience of adding more BUFFERS, LOCKS, etc and not improving the sit…
RE: Informix Dynamic Server and DB Tuning
Muthana Increase BUFFERS in onconfig file. UPDATE STATISTICS for each table (as a minimum) rerun the query and see what improvements you get. If you still have problems post the results of:- onstat -p onstat -m onstat -R and sqexplain.out of any particularly slow query or updat…
Informix Dynamic Server and DB Tuning
Dear Sir, The question how can make DB Tuning for Informix Dynamic Server version 9:30 to get the query faster. I used IDS 9:30 and it's not quick enough like our old Standard Engine. which Parameter can i change to make that or what shall i do? Regards Muthana AL-Temimi…
Can IDS accessing Informix SE Tables.
Hello, Now we are using Informix SE. We are planning to go Infomix Dynamic Server 9.x. Before migrating our current applications to IDS 9.x., first we have to develop a new application in IDS 9.x, in that we need to use some of the tables from informx SE. Could you please answer…
Re: Problem with Linux client connecting to Solaris Informix Server
hello possibly in the file /etc/services on Linux client need correct the value of informix's service name compliance with /etc/services on SUN server And show it in the corresponding property of DB connect. I'm so sorry for my very bed english ;-\\ Vladimir "Richard Sanders…
Problem with Linux client connecting to Solaris Informix Server
Hi all, I have a problem where the initial connection from a Linux client failing with the following error : DB connect failed: inf_open_conn: (25507) The specified service name or protocol is unknown. I believe this is something to do with the client not seeing that the DB (…
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.…
Work group edition - Unlimited edition??
Taken from IBM web site:- =========================================================================== The following Informix Dynamic Server Workgroup Unlimited editions have been added to the IBM Data Management Gold Transaction Processing Bundle for SMB Unlimited: IBM Informix…
Re: [Informix Dynamic Server (IDS):] Digest 2671
For a course in the US, check out: http://www-306.ibm.com/services/learning/ites.wss?pageType=course_description&co urseCode=L1760&country=us&language=en (IBM course L1760). There is probably a similar course offered in Europe somewhere. Hope this helps. Kevin Doiron Toronto,…
Re: Transaction support in informix dynamic server(IDS)
chaithra wrote: > i wanted to know, if in IDS we can get to know the status of a > transaction at any given time. or once any transaction commits or > rollsback we should be able to know the status. > is it possible through c++ interface provided by the IDS. I'm not quite s…
Transaction support in informix dynamic server(IDS)
hi all, i wanted to know, if in IDS we can get to know the status of a transaction at any given time. or once any transaction commits or rollsback we should be able to know the status. is it possible through c++ interface provided by the IDS. thanx in advace chaithra…
RE: Client/Server Connection Problem
Maybe it's just a typo in this message, but I see an extra "_" in the name (1st column) in your sqlhosts entry, i.e., "my_host_se" vs. "myhost_se". HTH, Paul Mosser -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of …
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…
Re: Client/Server Connection Problem
Sorry all. I attached IDS release note. Please change setlitcp instead of ontlitcp using Solaris box. Sorry again. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> >To: levartze@hotmail.com, informix-list@iiug.org >Su…
Re: Client/Server Connection Problem
Hi Levartze. You are using Solaris box. You should specify ontlitcp. Here is a part of release note under Solaris. a. NETTYPE in the ONCONFIG file and the nettype field in the sqlhosts file entry must contain "ontlitcp". HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:1681…
Re: Client/Server Connection Problem
I'm trying to setup our Informx SE 7.24, so that we can connect it to a Crystal Reports application. I seem to be having problems with getting the server daemon up and going. Here's what I have: 1. The /etc/hosts file has the following entry: 10.8.33.1 my_hostname …
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…
Memory allocation error - esql/c
R?diger Papke wrote: > Jonathan Leffler <jleffler@earthlink.net> wrote: >>R?diger Papke wrote: >>>I have a problem during memory allocation in esql/c routine on following components: >>> >>>OS: SiniX 5.44 B1007 4/2560 >>>IDS: 7.31.UD2X5 >>>ESQL/C 7.24.UC6 >>> >>>with the command…
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.…
Re: max number of connections
On Tue, 11 Nov 2003 12:42:00 -0500, Micha wrote: <SNIP>> We use both ontlitcp for remote connections and onipcshm for local > connections. NETTYPE is not defined in onconfig. How can nettype limit the > number of shared memory connections? AFAICT, the remote connections actually…
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…
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…
Lost database connections
Our configuration is IDS 9.21UC7 on a Sun VX880 server running Solaris 9. This server is running in 64-bit mode although our database is 32-bit. We have clients connected running a Power Builder application. Since upgrading our server from a Sun E-450 on Solaris 6 we are exper…
freebsd to a remote informix db
I am trying to connect from my freebsd server using php to a remote redhat 7.3 server running informix. I am running into problems. Informix Client SDK would not successfully install. does anyone have experience with installing on freeBSD anyone??? thanks…
not initializing shared memory
Joe: Check any pending/hanging shared memory and/or semaphore connections and remove it. You can find it using "ipcs | grep informix" remove using "ipcrm <sem id / shm id>". Once all removed successfully, you can restart Informix server without this error. Thank You Ramesh Vas…
RE: Dynamic Server versus Universal Server ??
Originally, Version 7.x was called 'Informix Dynamic Server', Version 9.0x was called 'Universal server' Starting with 9.1, Universal server became 'Dynamic server with Universal data option'. With 9.2, new names 'Internet Foundation 2000 ' and 'Dynamic server 2000' ware given…
Informix Dynamic Server 2000 startup problem
Hi, While starting up informix in multi user mode , we wait for the database to come up by checking the onstat - o/p . But if the system is loaded, even after onstat shows status as online , the connection is rejected by the database . The wait loop that we do is as follow…
I think I need a DB with no shared memory
dimonex wrote: > Whilst installing DBD::Informix, I encountered the following problem > > > bash-2.03# esql -o esqlbasic esqlbasic.ec > bash-2.03# ./esqlbasic > $DBI_DBNAME unset - defaulting to 'stores'. > $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'. > …
why I can't see the output of "onstat -g wts"
test:/informix>onstat -g wst Informix Dynamic Server 2000 Version 9.21.FC7 -- On-Line -- Up 5 days 13:23:03 -- 11132960 Kbytes Wait statistics not enabled How to enable the wait statistics???…
informix SDK 2.81 ifxoledbc OLEDB and ADO
When Updating or deleting a non existing row in a table, the informix oledb provider produces an "UnSpecified error". Environment: Informix Dynamic Server 7.31 Informix SDK 2.81 ADO 2.6 Any help will be appreciated. Thanks in advance…
Guidance on ipcshm v. ipcstr
In message <200303131429.JAA21169@ace.iiug.org>, Tim Bragg <BRAGGTIM@pentamation.com> writes >I am running UnixWare 7.1.1 with IDS 7.3.1.UD5. > >I am not understanding from the docs I am reading when one is prefered >over the other. Are there any guidlines to making the decision …
-27001 Read error occurred during connection atte
We running Informix Dynamic Server 2000 Version 9.21.UC2 on SCO 5.0.5 In sometimes the next error are on my system, we heave in house system, and the last change was an system uptdate to a hosts, and 4, or 5 users can work , if another attemp connect from 4gi or dbaccess or anoth…
INFORMIXSERVER value not listed...
The client machine is a NT4(SP6) server connecting to Informix2000 on NT. Both applications developed with Visual Studio, the one that works using VB6 and the one that doesn't using C++. As I said, the INFORMIXSERVER is listed correctly in the registry of the designated INFORMIX…
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: Shared memory not initialized...
From: mars1972@my-deja.com > >Anybody have any idea why I'm getting the message 'Shared Memory not >Initialized' when I run onstat, but I can run dbaccess and connect to >the database just fine? > >I'm running 9.21TC3 on Windows2K. It's possible dbaccess is connecting via TCP, b…
What requires an IDS Linux?
Jacqueline Romero wrote: > What requires an Informix Dynamic Server Linux a desktop and/or a network > version of Linux? If you want to use multiple connections or network connections, you need a network version of Linux. Otherwise, you can get away with a standalone system an…
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…
Client Server comunication
Hello I have Informix server 7.30 UC7 running on Linux suse 6.4 and client sdk 2.4 TC1-2 on Windows '98. When the client application connects to the server there are more than 50.000 packages between them Is it so much? (each packages have 2 bytes of data) Thank in advance Andr…
Client Server comunication
Hello I have Informix server 7.30 UC7 running on Linux suse 6.4 and client sdk 2.3 on Windows '98. When the client application connects to the server there are more than 50.000 packages between them Is it so much? (each packages have 2 bytes of data) Thank in advance Andrea…
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: ------…
Help please (reposted)
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: …
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: …
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: HPL issues
> Also, I can't use a shared-memory connection. Presumably because HPL's > 32-bit? onpload is 64-bit, ipload is 32-bit. So your shared memory presumption is correct. After you're done with ipload, you can tweak the onpload database to refer to the shared memory connections. …
IDS 7.3x on Win2000?
Does Informix Online Dynamic Server 7.3x runs on Windows 2000 (Professional)? Thanks for your help. Guy Dillen…
HDR: Error -956 on WindowsNT
Hello, we are trying to set up HDR with Informix 7.31 using the Administrator's guide. Everything is ok until the secondary server shall connect to the primary server using the onmode command. The connection fails and error -956 (Client host or user not trusted by server) is sho…
dbcopy and shm
cyclonejls@my-deja.com wrote: > > Can dbcopy use a shared memory connection? When I run dbcopy using a > shared memory connection, I get the following error: Dbcopy uses a separate connection to a database server for each side of the copy. That is why it can copy between datab…
connecting to informix database on unix from Microsoft Acess on windows
Hi, We have informix database on Sun Spark server. I was wondering if there is a way to connect to that database from a client machine using Microsoft Access. Vijay Sent via Deja.com http://www.deja.com/ Before you buy.…
Re: Error 27001!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
From: Simbarashe.Pangeti@icl.com > >please help me out to sort out this error >just do a finderr 27001 and you will get the details!!! Just read what the finderr says, and you might find some clues!!! -27001 Read error occurred during connection attempt. This error can occur …
RE: Error 27001!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Will it help you? -27001 __________________________________________________________ Read error occurred during connection attempt. This error can occur on either the client or database server side. When you encounter this error on the client side, it indicates that a network…
IDS2000 on Red Hat 6.2
All, I have my server running on Linux and can connect locally but I can't connect across a network. I get an error -908 "Attempt to connect to database server (servername) failed" when using I-Connect. My client machines can still connect to my NT server which has informix7 ser…
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…
Adding additional Listener ports
It has been suggested to me that adding additional Listener ports to /etc/services and corresponding aliases to sqlhosts may provide a performance gain by spreading user connectivity between the multiple listener ports. We run 7.31.UC5 on HPUX11 and all connections via tcp. We do…
Re: Puzzled: connect
Norbert.Heidbrink@home.of.the.brave.de wrote: > Sorry, folks, for a basic question, but at the moment I am absolutely > puzzled and do not see anything. > > Scenario: > SERVER is a Linux machine. > There is IDS running von Computer SERVER. > On Computer SERVER there is a user "d…
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…
no remote access with dbaccess
Hi, Please try to use ontlitcp on the client side (in sqlhosts). Did you configure the name of the server (sun) in sqlhosts file as DBSERVERALIASES in both onconfig files ? Please try as well, i guess if you use the real DBSERVERNAME it is connected to onipcshm on teh server sid…
Version 7.31.UC5 memory question
Steven L Cooper wrote: > > Howdy, > I am installing my 7.31.UC5 upgrade and have a question about the memory. I > see a message about rounding the memory up, which is find with me, but does > anyone know which onconfig parameter this is using? > > OS: SCO 5.0.4 on 4/way Intel bo…
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…
WWW.DSLRESOURCE.NET
WWW.DSLRESOURCE.NET xDSL information for beginners and experts alike. Firewall software,FTP server and client software and tons of information regarding this wildfire broadband connection!!…
How to prevent
users to create Database? We have database server with clients connecting via network. I'm curious is there a possibility to prevent user to create database (users can fill whole disk space) Thnx in advance JS…
Two Instances on Linux IDS2000
Hi guys, I'm trying to set up a second instance on a Linux version of IDS2000 using a different TCP Port for SOCTCP connection and, obviously, different server number & name. I get a fatal error in shared memory creation: shmget:[EEXIST[17]]: key[52574801]: shared memory alrea…
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…
Service name for Shared Mem connections
The idea was that you should always run shared memory connections thru CPU VP's and network/IP connections thru NET VP's, lest CPU VP 1 spend a lot of time spinning and generating LOTS of unnneeded system calls. As for monitoring CPU VP usage, I think an onstat -g glo would work…
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: Slow Connection from clients
Make shure you have ip adresses of clients in server's hosts file > >LAN Scenario: > >Nt server 4.0 SP4; IDS Workgroup Ed. 7.31.TC3 > >Primary Domain Controller, Wins and Simple TCP/Ip Service installed > >Some Win NT Workstation clients. > > > >No problems connecting to the Info…
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…
Informix Client SDK on Solaris 2.7
I am attempting to connect to an Informix server running on an HP-UX machine from a Sun Solaris box. I installed the Client SDK 2.40 on the Sun box and I am not able to connect. I get the following error from a simple esqlc program: Error -25574 while connecting to the database:…
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: is there ant limit on how many clients can connect to the server
>Subject: is there ant limit on how many clients can connect to the server >From: Kathy Huo kathy.huo@ssi1.com >Date: 12.03.00 19:28 W. Europe Standard Time >Message-id: <38CBE1B1.66CE55A2@ssi1.com> > >I understand this might depend on the hardware and other >configureations. But…
is there ant limit on how many clients can connect to the server simultaneously?
I understand this might depend on the hardware and other configureations. But can some one give me a rough estimate and some tips on where to find the informstion? Thanks!…
Question
For any of you using Informix on a database server runnning HP-UX 10.20/11.00 using shadow passwords... Any problems or are there any issues with client connectivity ?? thanks in advance. mac…
Informix -931 error
How can i solve this error(-931) in Informix 7.30 tc6 NT. I install client part of this server and try to connect to the remote machine. At that i create all necessary settings in the setNet32. Thanks…
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…
ODBC configuration problem
Hello, I am unable to configure client running on one machine to connect to Informix Dynamic 2000 server running on another machine in WinNT. I am using Informix ODBC driver 3.31.00 for Win NT. When the client and server are on the same machine, everything works fine. But when …
Problems with connecting via ODBC
Daniel Isvén wrote: > > I have a problem > I can't connect to my Informix 7.31 server from a client on any other > machine than the one that the server is installed on. > I'm sure it's a simple problem but right now it isn't for me. You have to give us a little more info Daniel.…
err = -956 Client host or user is not trusted by the server
Hello all ! I use Informix-SE for Windows-95. When I connect to the server using seipcpip service - its OK. But if I want connect by sesoctcp service - I receive message err = -956: Client host or user is not trusted by the server. Thanks for help. Victor Vat vavic@chat.ru…
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: network down error
> From: Don Johnson <DJohnson@usdl.com> > > > >We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get > >around 100 users connected new users cannot connect to the database. > >Onmonitor gives the error "Network Down". When you check shared memory with > >onstat i…
Re: network down error
From: Don Johnson <DJohnson@usdl.com> > >We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get >around 100 users connected new users cannot connect to the database. >Onmonitor gives the error "Network Down". When you check shared memory with >onstat it says that …
network down error
We have a new installation of 7.24.UC5X7 on an IBM S80 and when we get around 100 users connected new users cannot connect to the database. Onmonitor gives the error "Network Down". When you check shared memory with onstat it says that shared memory is not initialized but when yo…
RE: shared memory problems
Hi I have set the INFORMIXSHMBASE to 0x0 (0x10000000L) did not seem to make any difference. The calls which return NULL are indeed shmat - the funny thing is that when I swapped the two calls around (so that the second (unrelated) call was called first and vice versa, the program…
accessing shared memory
John Horton wrote: > > Hi > How do I set up a user so that they can access shared memory (ie. they can use the onstat - command) . Currently only root can access shared memory (not even informix can access shared memory or use the onstat - command) > > I have tried stting up the …
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
In article <383706D3.D184B438@iname.com>, John Shepherd <johnshepherd@iname.com> wrote: > 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 CONNE…
Informix Dynamic Server on IBM SSA
Can any one share their experiences, recommendations, pit-falls, comments about creating an IDS db engineOLTP environment on an IBM SSA Raid system? We have 2 SSA adapters and have 4 loops with 4 drives each. The IBM techs for the Smoothstart services will be coming next Tuesday…
Please help me!
Hello! 1, Can somebody give me information, what is the new features for Version 7.24 of Informix Dynamic Server according to Version 7.20 of Informix Dynamic Server? 2, Are Version 7.20 of Informix Dynamic Server and 7.20 INFORMIX-ESQL/C 2000 Year Compatible? 3, W…
Re: installing Informix dynamic server
From: "Joerg_Mauz@abs.org" <Joerg_Mauz@abs.org> > Is there something wrong the the gateway, Hotmail or are there just loads of idiots posting today. (Apart from me, that is! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hot…
installing Informix dynamic server
hi all, can anybody give me an URL where to find a good description of how to setup and install an Informix Dynamic Server with using RedHat Linux ??? I've searched a whole day but founf nothing useful.. :( thx ind advance joerg…
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…
IDS7.30 + Linux Kernel 2.2.10 +onsoctcp ?
Martin Gutjahr wrote: Hi Martin, > Is it possible to connect to an IDS running on Linux (suse 6.1) Kernel > 2.2.x > via onsoctcp ? > The only way I get access to the db-server is local via shared memory. i´m running IDS 7.30UC7 with SuSE Linux 6.2 (Kernel is 2.2.10). I can wor…
Setting up shared memory connection
I'm using IDS 7.30.UC2 on Solaris 2.6 x86. I have an instance up and running using a tli connection. I would like to set up an alias to allow local users shared memory access. I have added another line in the sqlhosts file, and the alias and another NETTYPE in my onconfig file…
Client_local and DB_locale pb
Hi evryboby, I have a pb of conversion between a informix server on HP UX and my client web form. For example I have a "�" insteadf of a "�" character. My connection is an ODBC connection with client SDK 2.30 installed on NT server and parameter on the server are "fr_fr.8859-1…
Informix Online Dynamic Server DBA Book
Hello Could anyone recommend a good Informix Online Dynamic Server book. I did a search in Amazon.com but I could not decide on which one to choose. Thanks in advance. Ajay…
pricing for informix info?
Hello, Was wondering what other people out there paid for informix dynamic server 7.3... Basically, i wanted to know if they had a web server licensing schem like microsoft. or ibm's db2 (per cpu license). and would the licenses be transferable if I decided to move from le…
Re: Determining version dynamically
Hi, If you have Informix Dynamic Server then use the following sql-statement ' select DBINFO('version', 'full') from systables where tabid = 1' result from the sql is : Informix Dynamic Server Version 7.30.UC5 Take a look in Informix Guide to SQL: Syntax for more about DBINFO…
KAIO: out of OS resources error
Hi~ My informix dynamic server write "KAIO: out of OS resources error .." in online.log. This error log is written during ontape task. How can I solve this problem? platfom : SunOs 5.5.1 Informix Dynamic Server 7.24 uc6 Thanks.…
64bit IDS for Solaris 7/SPARC ?
Is there a 64bit Informix Dynamic Server 7.3x for Solaris 7/SPARC available? tia, joerg…
Posting from the Informix-list
what is the last version of Informix Dynamic Server for HP-UX 10.20, where can i find more Information about this.…
Latest versions for various Informix products ???
Which are the latest versions for Informix Dynamic Server Informix Dynamic Server, Workgroup Edition Informix 4GL Informix SQL on Solaris 7/SPARC ? Where can I find such informations on Informix's website ? tia, joerg…
cdr command line utility in informix 7.24
Hi, Is there a cdr command line utility in informix dynamic server 7.24? I tried to locate it, but the executable is nowhere to find. Thanks, Lu…
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…
error 951
Hi guys, When trying to connect to a network server from a client, I get an error 951. any ideas would help. I'm sure that the user name i'm using is correct, and I can access the server and database without any problems from the console through the network port.…
Problem Installing Informix Dynamic Server
I downloaded a Try&Buy version of Informix Dynamic Server V7.30 for NT. I installed it on an NT Server. The install seemed to go ok, but after a short time of investigating IECC, I got a blue screen. After this when I started the Command Center, a task seemed to start, but it w…
Shared Memory Connection for Dynamic Server 7.30UC6x1 for HP-UX 10.20
Hi I need help. I'm having a problem connecting to a server which uses shared memory for communication. The following error mesaage is returned "25588: The appl process cannot connect to Dynamic server phoenix. Interrupted system call" The sqlhosts file has the following entry…
client troubles
Anyone an idea about error : 956: Client host or user <user@host> is not trusted by the server. ??? I try to connect from a perl script to the server and I'm logged as DBA. I edited /etc/sqlhosts about ten times and a couple of others in /etc too. It' s 7.20 on Solaris. Tha…
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.…
NT large memory configuration
Jay Walters wrote: > > I'm trying to configure a large amount of memory on Informix 7.3tc8 on > Windows NT Server 4.0 sp3. > > When I go about 300000 buffers and some 131MB of shared memory I get the > usual complaints - [SNIP] Do you have 750MB of memory on that NT system in th…
Multiple Informix Servers on one hardware.
This question deals with the basic setup and implementation of Informix. A customer wishes to run multiple Informix servers on one hardware system. My question is can this be done physically and if so how do the clients connect to the right server? Are there any other problems…
RE: IDS refuse connection on NT when connected to Internet?
How are you connecting to the Internet? Can your client ping the database server when you are connected to the internet? It is possible than the way you connect to the internet causes you to loose connectivity to your server Or if both your client and server are on the same ma…
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…
CoreDump with an SQL/CLI
Hi, I made some API to connect to INFORMIX server. This API use functions like : SQLAllocEnv(); SQLAllocConnect(); SQLConnect(); SQLDisconnect(); SQLFreeConnect(); SQLFreeEnv(); In this order, i connect my client one time and at the second time i have a core when i call SQLAllocE…
Re: How to connect Win95/NT to Unix Informix Box via ODBC??
From: Grant Neilson <gdn@crt.co.nz> > > We want to connect via windows to unix informix database (SE). >I can get the software Client from iWWW.intraware.com but how does >This let me see the unix informix database. Do I need NFS or something else >To connect or does the client j…
How to connect Win95/NT to Unix Informix Box via ODBC??
Hi all, We want to connect via windows to unix informix database (SE). I can get the software Client from iWWW.intraware.com but how does This let me see the unix informix database. Do I need NFS or something else To connect or does the client just use TCP/IP addresses etc to co…
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…
Find IP-Adress of ODBC-Client on Informix-Online (7.x)
In our WAN we have some Clients, they connect to our central Informix-Online (on Digital Unix) with ODBC. If the Client is listed in the Hosts-Table of the server, i can see the name of the host with the Syntax 'onstat -g ses'(hostname). But if the client is not listed in the hos…
Find IP-Adress from ODBC-Client on Informix-Online (7.x)
schrage_markus@my-dejanews.com wrote: > > In our WAN we have some Clients, they connect to our central Informix-Online > (on Digital Unix) with ODBC. If the Client is listed in the Hosts-Table on > the server, i can see the name of the host with the Syntax 'onstat -g > ses'(hostn…
Re: Tracing ALL sql queries - is it possible?
In our case we have around 100 users telnetting into a sun box (UE4000) from a pc - using a 3rd party (Acadia) telnet product. Once connected to the Sun box and logged in, they establish a connection to the database using shared memory (since at this point they are local on the …
Re: Tracing ALL sql queries - is it possible?
> The facility to monitor with ZERO impact -- shared memory connections or > IPC to an Informix database server from a network telnet session will be > available in the product next week. This reeks of marketing-speak. Your product does NOT monitor shared memory connections nor…
Re: ZERO Impact Performance Monitor for Informix BETA program
> C.1 The functionality for the monitoring of a SHARED MEMORY CONNECTION > when the SQL was issued across the network (e.g. telnet session) will be > available next week. Okay, but wouldn't this also work for a network connection for a telnet session also? What relevance does …
Re: Tracing ALL sql queries - is it possible?
> Your statement of the capabilities of the Sql Power SniFFFer product line > is not quite correct regarding shared memory connections or IPC > connections to an Informix database server. Actually, it was one of your people who verified that it doesn't work for shared memory, st…
Re: Tracing ALL sql queries - is it possible?
Chuck Renaud wrote: > Except for shared memory and loopback connections. I think it's > important to make that clear in your advertising when answering a > question like this one. How do you know Michael isn't running a > shared memory installation or using stream pipes? Yes,…
Slow connectivity to NT4/7.30
Hi, I'm having connectivity probs from Win95 client to NT4 (SP3) running IDS 7.30. The response is like 15 secs for each new connection. Specs: 1 CPU, 256MB RAM, db on NTFS, swap=64K Tested using ilogin demo on server - response of 1-2 secs. Tested using ilogin on client - resp…
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…
exec sql connect + shared memory
Could anybody enlighten me: IDS v7.24 and above - Informix will only allow a single database connection via SHM, as opposed to multiple for TCP/IP (for example). Does anybody know if or when Informix is planning to migrate this functionality? Cheers, Joe Blackman.…
Informix Dynamic Server Archive/Restore
Hello All: We have a large scale Informix DB resident on an HP 9000, K460, with AutoRaid Disk Subsystem (218gb). And we are running IDS 7.30. Currently, we are using the Informix ontape archive/restore utility to archive the DB and to perform continuous logical logging. We u…
Any one know this?
Hi folks: Is there a script that can check informix on-line dynamic server is up and running or not? If not it will e-mail a note to D.B.A. groups Thanks in advance Garry…
Informix ODBC
I have installed the Informix Client SDK (including the Intersolv ODBC driver) and have used the Windows ODBC Administrator to create a profile for connecting to an Informix server on our network. But when I try to connect from any client app., I get told that the INFORMIXSERVER…
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…
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…
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…
Connecting a NT client to a Sparc Solaris Server.
Does anyone know what software I need to install on either side, to connect a NT box as a client to a Sparc Solaris 2.6 box as the server. At this point I have Universal Server running on my Sparc station, that is it. I beleive I need I-connect on the NT box... is this correct?…
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?…
RE: Client disconnects
> -----Original Message----- > From: Marichamy, Udaykumar > Sent: Thursday, January 14, 1999 3:51 PM > To: 'iiug@informix-list.com' > Subject: Client disconnects > > If during a client-server Informix Update process, initiated from the > client desktop, the NT client is disconnec…
IECC over a dialup connection
I'm trying to use IECC over a dial-up connection, and cannot seem to connect to the server. When I'm directly connected to the network, I can connect to the server fine, but when dialed in to the network, I can't seem to see the server(s) (but I know they are there, and accessabl…
Re: Need help with Windows NT client connectivity
Call it a guess... Every time I've encountered this slow connection problem (albeit on UNI*) the issue was that the server system and/or Informix's idea of same was mal configured or suffered from failed startup. This then means a timeout or timeouts need to occur before the netw…
Attempt to connect to database server xxxx failed
Yi Chen wrote: > Hi, > > We randomly had a connection problems from client to server with > followning error message: > > Attempt to connect to database server xxxx failed. Any messages in your online.log? June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plai…
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.…
ODBC
How can I connect an ODBC driver to an informix database server? What should I install - on the server side, - on the client side? Are there different drivers? What are their advantages? What is the price? Where could I buy it? Thank's in advance for your answers. Benjamin GUI…
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…
Re: How does remote client connect to 5.10 online server
Jubal Kohlmeier wrote: > > I'm a seasoned Online 7.x veteran, but I've been asked to work with, ahem, > online 5.10. All my training on 7.x seems not to pan out on 5.10. I've > been able to connect locally using dbaccess, I'm trying to connect 5.10 > Online server, remotely using…
How does remote client connect to 5.10 online server
I'm a seasoned Online 7.x veteran, but I've been asked to work with, ahem, online 5.10. All my training on 7.x seems not to pan out on 5.10. I've been able to connect locally using dbaccess, I'm trying to connect 5.10 Online server, remotely using dbaccess. I believe I need I-NET…
oninit: shared library problem
I'm having problems when initialising the DB using oninit. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR…
Initi DB
I'm having problems when initialising the DB. Config: INFORMIX Dynamic Server Ver 7.23, on a UNISYS-UNIX SVR4. When Initializing, I get the error ...dynamic linker: oninit: symbol not found: gettimeofday The LD_LIBRARY_PATH is set to $INFORMIXDIR/bin and �INFORMIXDIR/esql help wo…
Re: Poll threads again
I have to admit I goofed. The poll thread simply issues a poll() to determin network completions. An array of file descriptors is passed to the poll() function and completed statuses are returned for any connections that have data ready. This is a bit different with shared memo…
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 …
Re: isql dumps a huge core
Ph. Chantry wrote: > > Hi. > > Sometimes, isql dumps a very huge core (between 80 MB and 150 MB). > We do not know the context of this problem. Probably isql was idle for a > long time. > > Have you encountered such a phenomenon ? > > Thanks in advance for all information. Why i…
Error 25506
I am new to this listserve, so I apologize if this has been asked before. I am trying to connect to Informix5.03 from a Windows95 pc using odbc. I installed Client SDK from Intraware. The sqlhosts file and /etc/services on the server are setup correct. The sqlexecd daemon is …
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.…
16-bit ODBC connection
Has anyone had any success with a 16-bit ODBC connection from a Windows 95/NT client, to an Informix database (9.1.4) running on a UNIX server (SUN Solaris 2)? If so what are the components I need to connect, i.e. middleware and ODBC driver. Thanks in advance, Glenn Moodie…
Informix Dynamic Server on Linux NOW!
Check out the Informix WEB Site. There is an announcement that IDS 7.3 is shipping on Linux TODAY! http://www.informix.com/ Art S. Kagel…
Problem installing to NT4.0 server
I'm trying to install Informix dynamic server workgroup edition to Primary domain Nt 4.0 Server. I have created Informix-Admin group and Informix account and grant it all Administrators rights and also Domain administrator rights. The server setup runs ok, but when setup is tryi…
Re: TWO ONCONFIG per INSTANCE ...........
Girish Manmadkar wrote: > > Hi All, > > I am working on one issue here. I need to have different onconfig file > for users. I mean , Can have two onconfig for one instance, sharing > the same "rootdbs".. If yes, then are there any issue to be looked into > ?? I need to have a sca…
Re: Q: multiple connections
Fredrik Fyring wrote: > > Hi! > > I'm using a java/jdbc application to connect to an Informix 7.24 > server residing on a SunOs 5.5.1 machine. > > Sometimes the connections don't get closed properly, and when I > try to reconnect I get the error-message > > "SQLException: XIX00…
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: Clients remaining locks when connection to server is broken
In article <3603b1bc.105461075@news.siemens.at>, johann.luczanich@siemens.at wrote: > Hi Comrades, > > how can I kill automatically (I know onmode -z) sessions remained by > clients (e.g. MS-Query, ...) that lost connection to a server, > for example, PC users shut off the powe…
Clients remaining locks when connection to server is broken
Hi Comrades, how can I kill automatically (I know onmode -z) sessions remained by clients (e.g. MS-Query, ...) that lost connection to a server, for example, PC users shut off the power without first exiting from the client application ??? Who has experience with the Keep-Alive…
ODBC to Linux connection. Error -956?
Hi, I'm trying to get a windows client to connect to my SE server on Linux (Red Hat 5.2). The problem I'm having is when I run Ilogin, I get an error -956 ("Client client-name is not in /etc/hosts.equiv on the remote host."). I can watch, when I try to connect, and see message…
Re: Connectivity UNIX/Client Unix/Server for Informix OnLine 5.11
On Thu, 13 Aug 1998 14:28:42 -0500, Gene FOTSO <efotso@uswest.com> wrote: >Hi Folks, >I have an Informix OnLine 5.11 database Server running on a Unix >(solaris 2.5.1) workstation. >I need to remotely query (Remote SQL) the database from a client Unix >workstation. > >What UN…
Connectivity UNIX/Client Unix/Server for Informix OnLine 5.11
--------------AB3F3D71169BF81DA0826639 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Folks, I have an Informix OnLine 5.11 database Server running on a Unix (solaris 2.5.1) workstation. I need to remotely query (Remote SQL) the database from a …
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 …
Re: Bad ESQL/C Memory Configuration
Jonathan Leffler <jleffler@earthlink.net> offerred: +Christian Kissner wrote: +> +> I have a problem allocating medium-sized memory when using ESQL-C. +> Actually, it happens after connecting to my Database: All the +> Memory I can get is just below 8MB ! +> +> [...] +> +> For I…
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…
Help with Informix Dynamic Server 7.30 - IECC
Hello, we just upgrade our version of Informix to the latest Dynamic Server 7.30.UC3 on our Sparc 1000 server running Solaris 2.5.1. We also installed the IECC Server Agent 3.00.UC1 on the server. The connectivity looks to be ok (because we already use it with the oldest version…
Re: Informix Online Dynamic Server 7 on Linux
Piet le Roux wrote: > > If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would > be appreciated. > I have installed iBCS and the shared libraries and the binaries work, > except that the engine cannot initialize shared memory: Error message > semctl: errno 22…
Informix Online Dynamic Server 7 on Linux
If anyone has succeeded to run Informix ODS 7 (SCO) on Linux help would be appreciated. I have installed iBCS and the shared libraries and the binaries work, except that the engine cannot initialize shared memory: Error message semctl: errno 22 create_vp: cannot allocat m…
Problems with Informix Dynamic Server for NT
Hi Has anyone tried downloading and running the dynamic server product for NT? I have it installed, but get the following error when I boot the system: AdmAgent.exe - Applicatioin error The instruction at "0x10087c69 referenced memory at "0x00000000". The memory could not be r…
Re: Online 7
Jamie Nash wrote: > > When trying to connect to a database (dbaccess or isql) I get the > error -25588 > Any ideas? It usually means you have a 6.xx executable trying to connect to a 7.xx database server using a shared memory connection. Looks like the dbaccess in your PATH may…
RE: What are the differences between Informix Dynamic Server
It is confusing! =20 Here's what I know: Prior to renaming: 7.2x =3D ODS 8.0 =3D XPS 9.1 =3D IUS After renaming: 7.2x =3D IDS 8.0 =3D IDS/AD/XP 9.1 =3D IDS/UDO=20 After the 7.3 release: 7.3 =3D IDS 9.1 =3D IDS/UDO After the 8.2 release: 8.0 =3D…
RE: What are the differences between Informix Dynamic Server and
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BDA3AF.9242A58C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Good quest…
Re: Index for Informix Dynamic Server
William Lai wrote: > > Hello, > > We alreay upgrade our database server from SE5.X to IDS 7.3. After we > convert all the old data to the new server, we have some problems on the > index search. For example, a table: > > table : ith ( ithitno, ithname ), total 1,500,000 records…
Re: Index for Informix Dynamic Server
William Lai <rwie@netvigator.com> offerred: +We alreay upgrade our database server from SE5.X to IDS 7.3. After we +convert all the old data to the new server, we have some problems on the +index search. For example, a table: + +table : ith ( ithitno, ithname ), total 1,500,000…
Index for Informix Dynamic Server
Hello, We alreay upgrade our database server from SE5.X to IDS 7.3. After we convert all the old data to the new server, we have some problems on the index search. For example, a table: table : ith ( ithitno, ithname ), total 1,500,000 records index : ith_1 on ithitno, ithn…
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…
Actuate Report Server -Connectivity Problem
We are trying to run an Actuate Report Server on an NT Server with a informix client installed connecting to an informix 7.23 UNIX on HP. When we are trying to run the report server we are receiving error -406. We tried different clients (Connect 7.23 , CLI 2.…
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…
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: +…
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…
Client Locale problem IDS_PE
I just installed a Informix Dynamic Server Personnal Edition v7.22 on a Windows 95 system. This W95 system us English Us language When I try to connect to the local Informix Server just created, I have this error message : Unable to connect to server ds_fifolap because the serve…
Intermittent Problem - error 529 Cannot attach to transaction
We have a HP-UX box (Ver 10.20) running Informix Online Dynamic Server Ver 7.13 and a NT Server (NT4.0) running Informix Online Dynamic Server Ver 7.23. We are trying to access some of the database tables resided in the HP-UX box from the NT Server via synonyms. But we faced inte…
Re: problem with shared memory connections
In article <3523658A.35AAE31C@aethos.co.uk>, Pete Smith <pete.smith@aethos.co.uk> writes >many thanks for suggestions made ( Art and others ) > >unfortunately... it hasn't made a lot of difference. >I added these lines to the config: > >NETTYPE ipcshm,1,50,CPU >NETTYPE …
Re: problem with shared memory connections
many thanks for suggestions made ( Art and others ) unfortunately... it hasn't made a lot of difference. I added these lines to the config: NETTYPE ipcshm,1,50,CPU NETTYPE soctcp,1,50,NET It seems that once I get to 24 shm connections then no more are allowed, al…
Re: problem with shared memory connections
Art S. Kagel wrote: > > Pete Smith wrote: > > > > 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 co…
Re: problem with shared memory connections
Pete Smith wrote: > > 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 connecti…
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 …
Re: JDBC
Ben wrote: >Has anyone gotten JDBC to work with servlets for informix? I have >gotten it to work directly from the UNIX prompt, but whenever I try to >connect more than once to a shared memory connection server, I get >errors about shared memory. When I try to connect to tli, …
OWS: CLIENT LOCALE error
Hi, I got this error message when I in the command center, I select the one of the oline database server . Error message : Unable to connect to server ol_hpirpa because the server locale could not be converted to the client locale. Change the CLIENT_LOCALE environment varia…
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.…
JDBC
Has anyone gotten JDBC to work with servlets for informix? I have gotten it to work directly from the UNIX prompt, but whenever I try to connect more than once to a shared memory connection server, I get errors about shared memory. When I try to connect to tli, I get a -908, wh…
Re: A question on shared memory usage
com@netinfo.moldova.net wrote: > > Hello, > > In article <34dcff94.500279443@10.209.30.200>, > jharris@westpac.com.au wrote: > > > > Octav, > > > > Once Infomrix allocates a shared memory segment it is not > > automatically freed when no longer needed. > > > > To make online fr…
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…
IUS, WebDatablade and nsapi
Hi! I decided to use the web datablade as a nsapi function as it is faster then the cgi version. But ... it doesn't seem to work in some conditions, for example in a page with two or three frames. The log reports: 14817-72838,18) DEBUG: Fri Jan 9 19:03:17 1998 [MI_Exception] o…
Re: 4GL Error 4502 = 1319
christian.winterhager@orbit.de wrote: > > Our customer has Online 4.1 and 4GL 4.12; if more then 10 - 12 Users > connect to the database, then this error 4502 (now 1319) comes. The > machine has SCO-Unix 3.2.4.2, 128MB Memory, and the shared memory of > OnLine is about 40MB. So w…
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: memory
Thuc Nguyen wrote: > > Hi > > I am running Online 7.23 on HP 10.20 > > We want to find out why we allocate alot of memory per user and never > release it. > > Is that memory leak? Actually you are probably not allocating any memory "per user". If your default connection, or the…
Re: 930 Error - Trying to connect win95 client to Informix 5.02
Charles J. Sergent wrote: > > I'm trying to connect a windows 95 client to a RS6000 (Unix) system. I > configured the sqlhosts file, services files on both systems and I keep > getting the 930 error when I try to run ilogon. Does anyone have the > correct procedure for setting …
Next Extent Calc.
Hi, I have INFORMIX-OnLine Dynamic Server Version 7.14.UD2. Does anyone know of a script or program to calculate the next extent size ? Thanks in advance Manuel…
Re: Client/Server Connection
We currently use Online version 7.23 and GQL version 4.11. Within windows 95 you will have to use setnet32 to install the 32 bit I-NET layer needed for connectivity. Other than that, its a piece of cake. One thing you will have to watch out for is the hosts.equiv file that res…
Client/Server Connection
-- [ From: Richard Wellis Sinyem * EMC.Ver #2.5.02 ] -- Dear All, We are planning to install and implement a client EIS application development tool (i.e Andyne GQL). Environment listed below: client: Win95 client service protocol: Microsoft TCP/IP EIS: Andyne GQL v3 (Wi…
Re: Connecting from Win95-client to Informix on NT-server
Nils van der Laan (NilsL@simac.nl) wrote: : 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. I have installed the client-apps t…
Connecting from Win95-client to Informix on NT-server
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. I have installed the client-apps that come with the other cpoy of Informix we have (…
Re: Protocol
Hi Elisa, Elisa Hoffman wrote: > Has anyone connected to an Informix UNIX database through a firewall? > > How does INFORMIX (on UNIX) using I-NET, via ISQL, validate and confirm > who the remote client is? > - Is DNS used? If so, is the lookup based on IP address, where > ser…
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…
ONLINE -27001 Error
-ONLINE 7.14 runnnig under HP-UX 10.10. -4GL clients on the same machine, connecting via onipcshm. There are about 16 users working...Suddenly, someone gets -27001 Error: Read error occurred during connection attempt. The onstat utility says state is 'OnLine Mode', and I can …
Re: Connecting Access97 client to Informix On-Line Workgroup Server 7.2 (NT)
I have installed Informix-CLI which allows us Access to link to Informix tables. In our case we have set up a remote(dial-up) connection, from w95 with Access 95 into a Rs/6000 with Informix vn4. I haven't investigated the versions you have, but the www.Informix.com has some info…
Connecting Access97 client to Informix On-Line Workgroup Server 7.2 (NT)
Any Ideas? Thanks,…
cannot locate service_name on service/tcp service
Hi Configuration : Server : 7.22 server on Solaris 2.51 Client : 7.22 client on HP-UX 10.20 Client machine : /etc/services : dummy_srv 2001/tcp $INFORMIXDIR/etc/sqlhosts : informix_on onsoctcp xxx.yyy.com dummy_srv My esql program doesn't connect to the server…
Does OS/2 connect using ODBC via TCP/IP?
Hi all, Does anybody know if it is possible to connect an OS/2(version 3)-client to an informix database via ODBC? The server and client are connected via IBM TCP/IP version 3.…
Q. Informix CLI 2.5 on NT client
I have been using Informix CLI 2.5 on Windows 95 clients to connect to our Solaris server via MS TCP/IP. The first time I tried to do the same thing on a Windows NT client, I get a 931 (cannot locate service) from Ilogin32. I copied the services and hosts files from the server t…
Problem with DSA 7.2 + Hp UX 10.20
I have a problem with DSA 7.2 running on a K250 with 256 Mb I hope anyone could help me. Sometimes the database server seems to 'freeze', it is, it is still on-line and running, there are no error messages on the log but nobody can access it thru shared memory, and it is possibl…
Re: Memory problems with 7.12UC1 and Dec Unix 4.0a
Hello; I am not too knowleable of Livewire. Correct me if I am wrong but it it sounds like it may be using dedicated connections to the database (from the symptoms). For example when using ODBC and a DB process is started it usually takes about 500kb of the servers memory and op…
informix net with windows clients running dhcp
Hi folks, This may turn out to be a vague question - mostly because I don't have many details - I am not doing the work myself.... Anyway, we'll be connecting some windows nt clients using informix net (is that the name?) to a backed informix db running on an hp system. The init…
Re: sqlrmsoctcp
Bug is with shared memory configuration (onipcshm). TCP is absolutely fine. FYI I append the Informix Defect Report - and the problem is not specific to AIX, we had the same on HP-UX. (You can search defect reports at http://www.informix.com/ - it's a good place to look for probl…
Re: <UNKNOWN-HOST> id for Client-Server Connection ...
"Mr. Munaf A.Razzak" <g086mnf@bomplant3.appl.ge.com> wrote in article <5bcfda$km1@cssun.mathcs.emory.edu>... > > Hi, > I have a certain application which uses : > Gupta - SQLWindows as the front end and Informix Online 7.11 DSA as the > backend with I-Net as the connectivity too…
<UNKNOWN-HOST> id for Client-Server Connection ...
Hi, I have a certain application which uses : Gupta - SQLWindows as the front end and Informix Online 7.11 DSA as the backend with I-Net as the connectivity tool over TCP/IP. The question I have is that is there anyway I can configure I-Net to identify the hostname in the syssess…
Re: Shared memory connections
I generally use a local loopback tcp to communicate with the engine, but the main reason that I do that is because I have limited memory. As far as performance, if your application is doing a lot of data transfer to/from the engine, then SHM will be faster/better. However, if t…
Re: Shared memory connections
Neil Truby wrote: > > My site uses OnLine 7.13 on Solaris 2.4 > > I've noticed that one of our instances has only network connections > defined, no shared memory ones, so not even local utilities are using > shared memory connections. Does anyone have a feel for the effect this …
Shared memory connections
My site uses OnLine 7.13 on Solaris 2.4 I've noticed that one of our instances has only network connections defined, no shared memory ones, so not even local utilities are using shared memory connections. Does anyone have a feel for the effect this will have on administration p…
Re: SHM CONNECTION SOLARIS
> We had the same problem before, but it has been such a long time .... > > Make sure your $INFORMIXSERVER is defined correctly in your sql.hosts. > Next, check your hosts.equiv. Your own server name should be in > hosts.equiv. > > Let me know, if it still does not work. > > Cha…
Re: Shared Memory Not released
>Brian Li <cphdcbl@ted.cs.depaul.edu> wrote in article ><511nel$aft@shrike.depaul.edu>... >> >> Dear Informix experts, >> >> We are currently have Informix Dynamic Online running on our HP T500 >machine >> and recently have shared memory problem which is only known to be solved …
Re: Database Connection NT-Unix
Hi, Check the $home/.rhosts file in the client or the /etc/.hosts.equiv in the server. These files contain the list of hosts and clients considered trusted. The .rhosts file should have the name of the server you are trying to connect. Or the .hosts.equiv should have the name of…
Database Connection NT-Unix
Has anyone an idea how to connect from an Unix-Client (OnLine 7.13) to an Informix-Workgroup-Server 7.1 running on NT 3.51 ? The connection is always refused with the error -956 (client is not trusted by the database server). Username and password are identical on both machines. …
Re: Shared memory connections
>>The purpose of the alias is to allow the same server to have different types of >>connections. If you only need shared memory connections you only need one line >>in the sqlhosts file per server. > >True. And I also have a need for network connections, and have a line for tha…
Re: Shared memory connections
On 20 Aug 96, Kate Tomchik/IS/SSC/THD <Kate_Tomchik@homedepot.com> wrote: >The purpose of the alias is to allow the same server to have different types of >connections. If you only need shared memory connections you only need one line >in the sqlhosts file per server. True. An…
Sinix - access via Shared Memory
Hi all, i'm using informix 7.12 on Sinix and HP-UX with some big c++ applications. on hp-ux i can access the database via shared memory without problems. on sinix, i got following error message: -25588 - The appl process cannot connect to OnLine server sinix_shm. with some …
Shared memory connections
I am attempting to define two dbserver aliases (one for the DB-Cockpit, one for our Non-client/Server users who are using character-based Fourgen). One HAS to be Shared memory (DB-Cockpit, per the manual), the other I would LIKE to be shared memory (for performance). In the "A…
I-NET AND CA-UNICENTER
We have a client server application that establishes a connection to Informix database server on the HP-UX box using I-NET with WINSOCK DLL. It's bypassing CA-Unicenter's security system. Has anyone had this problem? Thanks…
OS/2 Connectivity
I need help connecting to an Informix 7 database using OS/2 Warp Connect 3+. The INET 5 client for OS/2 is not supported by Informix for OS/2 Warp Connect 3+. We are able to "ping" the database server (TCP/IP is the protocol), but are unable to get any farther then this. Also in …
(no subject)
We have Informix 7.12 on a server host and 6.0 on a client host. We have two dedicated hosts for database servers because we are using Informix data replication. One database server, the primary server resides on one host and the second database server resides on the second hos…
Informix Certified Professional Program Update
Informix offers two certification paths. Each path requires the successful completion of two exams. Each exam is US $250 and is between 60-90 minutes long. * Database Specialist for INFORMIX-OnLine Dynamic Server 7.x 111 - Database Fundamentals Exam 112 - Managin…
Re: System tuning
mickey.mestel@etak.com (Mickey Mestel) writes: > johnny, > > > An alternative to the relay module is local loopback network connection (TLI > > or SOC). > > We use 4.x tools with 7.x engine using this method. We tried the relay > > module, but it was > > incredibly slow and a re…
How To connect to remote database in Online 7.1
Informix Experts, We are having a problem connecting to a remote database. The sqlhosts file on the client station looks like level3 onsoctcp level3 wideworld and the /etc/services file looks like wideworld 1556/tcp The sqlhosts file on the se…
Re: ONLINE - Cannot sort Errors
: We are experiencing a problem with Online Version 6.00.UH1 running on AIX 3.2 : The system runs quite happily for several days Usually) then we receive the : following error (The offending program is being run by 40-50 users) :- : Date: 15/02/96 Time: 16:02:56 : Program e…
US-CA-Burbank TECH SUP PC, MAC, TCP/IP, Connectivity to mainframe/client server SMCI
Keywords: TECH SUP Term: CON 1 year State: CA Job Id: #818 Title : Technical Support Representative Skills: TCP/IP, PC and MAC, DOS, Windows Preferred - Hypertext Programming, Novell/Netware Location : Burbank Start Date: Immediate Pay Rate : $27.65 an hr. Length : 1…
Re: Client Server Connections w/INET
Mike Renda <mrenda@tribeca.ios.com> wrote: >I have been connecting to an Informix database (on a SCO >Unix server) using the INET software with the FTP TCP stack on a >Windows 3.1 workstation. >I recently converted to Windows for Workgroups 3.11 on an NT >domain and switched to…
Client Server Connections w/INET
I have been connecting to an Informix database (on a SCO Unix server) using the INET software with the FTP TCP stack on a Windows 3.1 workstation. I recently converted to Windows for Workgroups 3.11 on an NT domain and switched to Microsofts TCP stack. Now my client server conn…
Client not connecting to Server!!!
I am running SCO Openserver Enterprise 5, and just installed Informix 7.1. I can initialize the dbspace just fine. However, when I try to connect to the server with dbaccess, I get a 908 error message - permission denied - attempt to connect to database server failed. My tcp/ip…
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?…
Connecting thru PB 3.0 to Informix 6.0
We have Informix 6.0 running on ScoUnix (ODT) Server and PowerBuilder 3.0 on a Novell Server. The Connectivity between the two servers is well established as lot of other Client/Server Applications are running on it. We do not have I-Star or I-Net , however we heard that they ar…
Client/Server connection thru isql/4gl
Thanx Sean , Edwin for responding to my earlier query. In fact the +ve point is that I have been able to connect the client/server using netline 1254/tcp in the /etc/services as the service with ontlitcp as the protocall. Hard luck when I try to connect using isql QueryLanguag…
Re: Connecting From Client to Server in Online
In <D5LAEx.C74@shakti.ncst.ernet.in> mastek1@shakti.ncst.ernet.in (Mastek Limited) writes: >$INFORMIXDIR/etc/sqlhosts on Server is as follows >testing ontlitcp Client telnet ^^^^^^ According to this entry, the connection is using…
Connecting From Client to Server in Online
We are working in Online 6.0. Had a tough time connecting from one Unix Client to the other Unix Server. $INFORMIXDIR/etc/sqlhosts on Client I hope need not be the same as of on the server. $INFORMIXDIR/etc/sqlhosts on Server is as follows testing ontlitcp Client telnet where…
<No Subject Supplied>
I have a client that wants to utilize viewpoint on client machines to connect to a server database. What do they need to buy to allow connectivity? Their informix sales person does not seem to be clear on what is needed. First they gave a bottom line of $40,000 then $3,000.…
How to pick the version of I-Net for TCP/IP
Hi there, I would like do client/server; would I have any problem if I have a number of f clients that use 10BaseT2 and also a number of clients that use BNC connectors. My server will be running INFORMIX SE 5.01 on SCO UNIX 3.2.4. What is the version of I-Net for TCP/IP I shou…
Is informix a client-server DBMS?
I'm interested in connecting informix running on a UNIX server to powerbuilder running on a PC. Can this be done? Some one told me that it could not -- because Informix was not a client server DBMS... Any input would be appreciated. Thanks - faisal…
Unix UID
Does anybody know whether the Unix UID is significant when a client establish a database connection to the server? For example, if at the server end, there is a user id called xyz with uid 100, at the client end, is it ok to have a user id xyz with a different user uid say 99? Wi…
Online 4.1 shared memory initialization
Problem using Informix-Online 4.1 When I try to start isql I get the following error messages: -529 Cannot attach to shared memory. Your application program is unable to initialize its connection to the database engine because you are using a shared-memory implementation and e…