Can't connect to server

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET, Server Administration, Security, Permissions & Auditing, Licensing & Editions

EDWARD MORARU — Sat, 06 Dec 2003 13:50:04 — source: IIUG Forums & Mailing Lists

Hello, Maybe it's trivial, but I'm a beginner in IDS. I have a IDS Workgroup Edition 7.30 on UnixWare 7.1.1. Basically, I want to connect through JDBC to this machine, but I can't. First, I tried the dbaccess utility, because I wanted to create my database tables. But on Connect menu, when I enter the server name, user name and password it tells me "930: cannot connect to database server(manrzb)". onstat is giving me "shared memory not initialized on INFORMIXSERVER 'manrzb'" message. I tried oninit with -iy and -sy and -i and -s or no parameters and I get the same message with onstat . Can you please tell me how do I start my server, or what is wrong with it ? Thank you, Edward.

↪ replying to EDWARD MORARU

Support Informix — Mon, 08 Dec 2003 09:23:46 — source: IIUG Forums & Mailing Lists

You need environment variables : INFORMIXDIR, ONCONFIG, INFORMIXSERVER, SQLHOSTS You need in the $INFORMIXDIR/etc/$ONCONFIG file the right parameters with parameter ROOTDBS pointing to your root chunk. This root chunk is a unix file, a unix cooked partition or a unix raw partition (last is best for performance). Then you can issue the onstat -i command to initialize your DB Look into manuals Admin reference or Admin guide and the Configuration guide (chapter 3) for these configuration. There exists also a demo DB stores5. You can initialise and start this DB, how look in the manuals available at http://www-3.ibm.com/software/data/informix/pubs/library/ good luck Yves -----Original Message----- From: nobody@ace.iiug.org [mailto:nobody@ace.iiug.org] Sent: 06 December 2003 14:50 To: ids@iiug.org Subject: Can't connect to server [2306] Hello, Maybe it's trivial, but I'm a beginner in IDS. I have a IDS Workgroup Edition 7.30 on UnixWare 7.1.1. Basically, I want to connect through JDBC to this machine, but I can't. First, I tried the dbaccess utility, because I wanted to create my database tables. But on Connect menu, when I enter the server name, user name and password it tells me "930: cannot connect to database server(manrzb)". onstat is giving me "shared memory not initialized on INFORMIXSERVER 'manrzb'" message. I tried oninit with -iy and -sy and -i and -s or no parameters and I get the same message with onstat . Can you please tell me how do I start my server, or what is wrong with it ? Thank you, Edward. ------_=_NextPart_001_01C3BD64.22788990 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>RE: Can't connect to server [2306] </TITLE> </HEAD> <BODY> You need environment variables : INFORMIXDIR, = ONCONFIG, INFORMIXSERVER, SQLHOSTS You need in the $INFORMIXDIR/etc/$ONCONFIG file the = right parameters with parameter ROOTDBS pointing to your root = chunk. This root chunk is a unix file, a unix cooked = partition or a unix raw partition (last is best for = performance). Then you can issue the onstat -i command to = initialize your DB Look into manuals Admin reference or Admin guide and = the Configuration guide (chapter 3) for these configuration. There exists also a demo DB stores5. You can = initialise and start this DB, how look in the manuals available = at <A = HREF=3D"http://www-3.ibm.com/software/data/informix/pubs/library/"; = TARGET=3D"_blank">http://www-3.ibm.com/software/data/informix/pubs/libra= ry/</A> good luck Yves -----Original Message----- From: nobody@ace.iiug.org [<A = HREF=3D"mailto:nobody@ace.iiug.org">mailto:nobody@ace.iiug.org</A>]</FON= T> Sent: 06 December 2003 14:50 To: ids@iiug.org Subject: Can't connect to server [2306] Hello, Maybe it's trivial, but I'm a beginner in IDS. I have a IDS Workgroup Edition 7.30 on UnixWare = 7.1.1. Basically, I want to connect through JDBC to this = machine, but I can't. First, I tried the dbaccess utility, because I = wanted to create my database tables. But on Connect menu, when I enter the server name, = user name and password it tells me "930: cannot connect to = database server(manrzb)". onstat is giving me "shared memory not = initialized on INFORMIXSERVER 'manrzb'" message. I tried oninit with -iy and -sy and -i and -s or no = parameters and I get the same message with onstat . Can you please tell me how do I start my server, or = what is wrong with it ? Thank you, Edward. </BODY> </HTML> ------_=_NextPart_001_01C3BD64.22788990--

Can't connect to server

Related threads

Glossary

Your privacy choices