Re: problems installing informix 7.31 on aix

We are edging closer. I put in the TERM=vt100 variable, PLUS export INFORMIXTERM=terminfo. This allowed me to start onmonitor. However, now I am stuck in onmonitor itself. When going to 'parameters', initialize', I am stuck on the line 'Primary Path' where I am supposed to put in the pathname of the root dbspace chunk. I have no idea what that means, nor do I want to ;-). I merely want to get a test database up and running. Do you have any suggestions what to put in there, or if I should make any modifications to the onconfig file to work around this? Many thanks for your help so far. Ernst "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> wrote in message news:3ED3696A.8080704@sqlcanada.com... You can try TERM=ansi and in the worst case (if the screen appears garbled) hit E (for exit). I don't run AIX here so this is a guess. HTH Michael Ernst Meyer wrote: Hi Michael I tried the procedure that you suggested, but got stuck with the missing TERM environment variable. When trying to run onmonitor, I end up with the following: "tb4_main.4gl", line number 71 FORMS statement error number -170 type of your terminal is unknown to the system. I do not know what terminal setting it is expecting. I know that on our terminal console ibm3151 is the correct setting, but onmonitor does not like it. The Informix documentation hasn't been much help. Right now I am at a loss. Ernst "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> wrote in message news:3ED2BED7.3040306@sqlcanada.com... Ernst Meyer wrote: Hi all I am experiencing difficulty in getting Informix 7.31 to work on an AIX433 system. The AIX box used to have Informix 9.3 installed. I removed it, then installed v7.31 successfully. Then I installed ISA, then the SDK client. When trying to configure the demo database via ISA, I receive the following error: Unable to access onconfig file /u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local Informix Servers... to check for >incorrect values. I copied the missing onconfig.demo file from an operational 9.3 installation, and changed the settings about the installation directories in that file. The I tried to configure the demo database again. This time the database appears as 'off-line'. When trying to change the mode to on-line, I get the following error: 11:07:22 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 11:07:22 Dynamically allocated new virtual shared memory segment (size 8192KB) 11:07:28 DR: DRAUTO is 0 (Off) 11:07:28 Requested shared memory segment size rounded from 604KB to 608KB 11:07:28 Dynamically allocated new message shared memory segment (size 608KB) 11:07:28 Informix Dynamic Server Version 7.31.FD2 Software Serial Number ACP#J267193 11:07:28 Cannot Open Primary Chunk '/u01/app/informix-7.31/server/demo/server/online_root', errno = 2 oninit: Cannot open chunk '/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 oninit: Fatal error in shared memory initialization 11:07:28 Informix Dynamic Server Stopped. 11:07:28 mt_shm_remove: WARNING: may not have removed all/correct segments I now manually created the missing directory (server) and the missing file (online_root). After trying to change the mode to on-line, I now receive this error: oninit: Cannot open chunk '/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 oninit: Fatal error in shared memory initialization What am I doing wrong? Can someone point me in the right direction how to install Informix Dynamic Server 7.31 on AIX? Many thanks. Ernst Meyer Login as informix set ONCONFIG and INFORMIXSERVER variables start onmonitor Parameters->Initialize Go through all screens, last one will ask if you want to initialize rootdbs. I belive you do. Then use Mode to bring it up to Online. I think you understand that any data you had in the database under 9.3 will have to be imported into 7.3, yes? HTH Michael

Ernst Meyer wrote: > We are edging closer. > > I put in the TERM=vt100 variable, PLUS export INFORMIXTERM=terminfo. > This allowed me to start onmonitor. However, now I am stuck in > onmonitor itself. > > When going to 'parameters', initialize', I am stuck on the line > 'Primary Path' where I am supposed to put in the pathname of the root > dbspace chunk. I have no idea what that means, nor do I want to ;-). I > merely want to get a test database up and running. It wants the name of a file (cooked - part of file system) or raw partition from your disk to put the initial rootdbs on it. If you have the old onconfig printout it can be the same file (or partition). Try with "ls -l" to make sure it is owned by user "informix" and group "informix" and has rw-rw-r-- (at least). > > Do you have any suggestions what to put in there, or if I should make > any modifications to the onconfig file to work around this? I assume this is your "play" machine.... Make changes to onconfig. You can always reinstall IDS and get everything back. > > Many thanks for your help so far. > > Ernst BTW Go to ibm.com/informix click on Library and find appropriate IDS docs (Installation and Server Admin). HTH Michael > "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com > <mailto:NOmichaelkSPAM@sqlcanada.com>> wrote in message > news:3ED3696A.8080704@sqlcanada.com... > You can try TERM=ansi and in the worst case (if the screen appears > garbled) hit E (for exit). > I don't run AIX here so this is a guess. > > HTH > > Michael > > > Ernst Meyer wrote: > >> Hi Michael >> I tried the procedure that you suggested, but got stuck with the >> missing TERM environment variable. When trying to run onmonitor, >> I end up with the following: "tb4_main.4gl", line number 71 FORMS >> statement error number -170 type of your terminal is unknown to >> the system. >> >> I do not know what terminal setting it is expecting. I know that >> on our terminal console ibm3151 is the correct setting, but >> onmonitor does not like it. >> >> The Informix documentation hasn't been much help. Right now I am >> at a loss. >> >> Ernst >> >> "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com >> <mailto:NOmichaelkSPAM@sqlcanada.com>> wrote in message >> news:3ED2BED7.3040306@sqlcanada.com... >> Ernst Meyer wrote: >> >>>Hi all >>> >>>I am experiencing difficulty in getting Informix 7.31 to work on an AIX433 >>>system. The AIX box used to have Informix 9.3 installed. I removed it, then >>>installed v7.31 successfully. Then I installed ISA, then the SDK client. >>> >>>When trying to configure the demo database via ISA, I receive the following >>>error: >>> >>> >>> >>>>Unable to access onconfig file >>>> >>>> >>>/u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local >>>Informix Servers... to check for >incorrect values. >>> >>>I copied the missing onconfig.demo file from an operational 9.3 >>>installation, and changed the settings about the installation directories in >>>that file. The I tried to configure the demo database again. This time the >>>database appears as 'off-line'. When trying to change the mode to on-line, I >>>get the following error: >>> >>> >>> >>>>11:07:22 Event alarms enabled. ALARMPROG =>>>> >>>> >>>'/usr/informix/etc/log_full.sh' >>> >>> >>>>11:07:22 Dynamically allocated new virtual shared memory segment (size>>>> >>>> >>>8192KB) >>> >>> >>>>11:07:28 DR: DRAUTO is 0 (Off) >>>>11:07:28 Requested shared memory segment size rounded from 604KB to 608KB >>>>11:07:28 Dynamically allocated new message shared memory segment (size>>>> >>>> >>>608KB) >>> >>> >>>>11:07:28 Informix Dynamic Server Version 7.31.FD2 Software Serial>>>> >>>> >>>Number ACP#J267193 >>> >>> >>>>11:07:28 Cannot Open Primary Chunk>>>> >>>> >>>'/u01/app/informix-7.31/server/demo/server/online_root', errno = 2 >>> >>> >>>>oninit: Cannot open chunk >>>> >>>> >>>'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 >>> >>> >>>>oninit: Fatal error in shared memory initialization >>>>11:07:28 Informix Dynamic Server Stopped. >>>>11:07:28 mt_shm_remove: WARNING: may not have removed all/correct segments>>>> >>>> >>> >>>I now manually created the missing directory (server) and the missing file >>>(online_root). After trying to change the mode to on-line, I now receive >>>this error: >>> >>> >>> >>>>oninit: Cannot open chunk >>>> >>>> >>>'/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 >>> >>> >>>>oninit: Fatal error in shared memory initialization >>>> >>>> >>> >>>What am I doing wrong? Can someone point me in the right direction how to >>>install Informix Dynamic Server 7.31 on AIX? >>> >>>Many thanks. >>> >>>Ernst Meyer >>> >>> >>> >>> >> Login as informix >> set ONCONFIG and INFORMIXSERVER variables>> start onmonitor >> Parameters->Initialize >> Go through all screens, last one will ask if you want to >> initialize rootdbs. I belive you do. >> Then use Mode to bring it up to Online. >> >> I think you understand that any data you had in the database >> under 9.3 >> will have to be imported into 7.3, yes? >> >> HTH >> >> Michael >> >

Hi Michael Why is this so hard? I've managed to kick off the initialisation of the database after all, after a lot of tweaking with the syntax. but now, alas, I get this: oninit: DBSERVERNAME 'aix433' not in sqlhosts file or sqlhosts file contents are damaged'. I've got an aix51 machine which is running Informix 9.3. I had a look at the sqlhosts file on that machine, and it looks exactly the same as the file that I have on my problem 7.31 machine. I even copied the 9.3 file to the 7.3 install, but no luck. Then I decided to put an entry for my aix433 machine into this sqlhosts file. when I looked up the syntax in the IBM documentation, I had no pleasure either. I do not know what to put into the file. I'd appreciate if you could pass on any suggestions as to what the entry in the sqlhosts file is supposed to be. Many thanks. Ernst "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> wrote in message news:3ED441C6.8080401@sqlcanada.com... Ernst Meyer wrote: We are edging closer. I put in the TERM=vt100 variable, PLUS export INFORMIXTERM=terminfo. This allowed me to start onmonitor. However, now I am stuck in onmonitor itself. When going to 'parameters', initialize', I am stuck on the line 'Primary Path' where I am supposed to put in the pathname of the root dbspace chunk. I have no idea what that means, nor do I want to ;-). I merely want to get a test database up and running. It wants the name of a file (cooked - part of file system) or raw partition from your disk to put the initial rootdbs on it. If you have the old onconfig printout it can be the same file (or partition). Try with "ls -l" to make sure it is owned by user "informix" and group "informix" and has rw-rw-r-- (at least). Do you have any suggestions what to put in there, or if I should make any modifications to the onconfig file to work around this? I assume this is your "play" machine.... Make changes to onconfig. You can always reinstall IDS and get everything back. Many thanks for your help so far. Ernst BTW Go to ibm.com/informix click on Library and find appropriate IDS docs (Installation and Server Admin). HTH Michael "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> wrote in message news:3ED3696A.8080704@sqlcanada.com... You can try TERM=ansi and in the worst case (if the screen appears garbled) hit E (for exit). I don't run AIX here so this is a guess. HTH Michael Ernst Meyer wrote: Hi Michael I tried the procedure that you suggested, but got stuck with the missing TERM environment variable. When trying to run onmonitor, I end up with the following: "tb4_main.4gl", line number 71 FORMS statement error number -170 type of your terminal is unknown to the system. I do not know what terminal setting it is expecting. I know that on our terminal console ibm3151 is the correct setting, but onmonitor does not like it. The Informix documentation hasn't been much help. Right now I am at a loss. Ernst "Michael Krzepkowski" <NOmichaelkSPAM@sqlcanada.com> wrote in message news:3ED2BED7.3040306@sqlcanada.com... Ernst Meyer wrote: Hi all I am experiencing difficulty in getting Informix 7.31 to work on an AIX433 system. The AIX box used to have Informix 9.3 installed. I removed it, then installed v7.31 successfully. Then I installed ISA, then the SDK client. When trying to configure the demo database via ISA, I receive the following error: Unable to access onconfig file /u01/app/informix-7.31/server/etc/onconfig.demo. Click Specify Local Informix Servers... to check for >incorrect values. I copied the missing onconfig.demo file from an operational 9.3 installation, and changed the settings about the installation directories in that file. The I tried to configure the demo database again. This time the database appears as 'off-line'. When trying to change the mode to on-line, I get the following error: 11:07:22 Event alarms enabled. ALARMPROG = '/usr/informix/etc/log_full.sh' 11:07:22 Dynamically allocated new virtual shared memory segment (size 8192KB) 11:07:28 DR: DRAUTO is 0 (Off) 11:07:28 Requested shared memory segment size rounded from 604KB to 608KB 11:07:28 Dynamically allocated new message shared memory segment (size 608KB) 11:07:28 Informix Dynamic Server Version 7.31.FD2 Software Serial Number ACP#J267193 11:07:28 Cannot Open Primary Chunk '/u01/app/informix-7.31/server/demo/server/online_root', errno = 2 oninit: Cannot open chunk '/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 oninit: Fatal error in shared memory initialization 11:07:28 Informix Dynamic Server Stopped. 11:07:28 mt_shm_remove: WARNING: may not have removed all/correct segments I now manually created the missing directory (server) and the missing file (online_root). After trying to change the mode to on-line, I now receive this error: oninit: Cannot open chunk '/u01/app/informix-7.31/server/demo/server/online_root'. errno = 2 oninit: Fatal error in shared memory initialization What am I doing wrong? Can someone point me in the right direction how to install Informix Dynamic Server 7.31 on AIX? Many thanks. Ernst Meyer Login as informix set ONCONFIG and INFORMIXSERVER variables start onmonitor Parameters->Initialize Go through all screens, last one will ask if you want to initialize rootdbs. I belive you do. Then use Mode to bring it up to Online. I think you understand that any data you had in the database under 9.3 will have to be imported into 7.3, yes? HTH Michael