Installing Informix 11.50 On MAC OSX 10.5.5
InDeep
I attempted an install on my MacBook Pro, and could not get IDS to start.
The install _did_ complete without incident up until the demo was being
initialized, and then completed telling me to look at the log. Several
attempts at oninit -iy yielded more errors... help! *<8o)
Model Name: MacBook Pro
Model Identifier: MacBookPro3,1
Processor Name: Intel Core 2 Duo
Processor Speed: 2.4 GHz
Number Of Processors: 1
Total Number Of Cores: 2
L2 Cache: 4 MB
Memory: 4 GB
Bus Speed: 800 MHz
Boot ROM Version: MBP31.0070.B07
SMC Version: 1.16f10
OS: MAC OSX 10.5.5
12:12:50 IBM Informix Dynamic Server Started.
Tue Sep 16 12:12:50 2008
12:12:50 Event alarms enabled. ALARMPROG =
'/Applications/IBM/informix/etc/alarmprogram.sh'
12:12:50 Booting Language <c> from module <>
12:12:50 Loading Module <CNULL>
12:12:50 Booting Language <builtin> from module <>
12:12:50 Loading Module <BUILTINNULL>
12:12:50 Warning: CONSOLE = /Applications/IBM/informix/tmp/online.con open
failed. Redirecting output to '/dev/null'.
12:12:55 Waiting 60 seconds for startup to complete.
12:12:55 DR: DRAUTO is 0 (Off)
12:12:55 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
12:12:55 IBM Informix Dynamic Server Version 11.50.FC2DE Software Serial Number
AAA#B000000
12:12:55 listener-thread: err = -25572: oserr = 49: errstr = : Network driver
cannot bind a name to the port.
System error = 49.
12:12:55 sql_listener: ASF_LISTEN failed
12:12:55 Attempting to bring listener thread down.
12:12:55 Server stopped.
12:12:55 IBM Informix Dynamic Server Stopped.
12:12:55 mt_shm_remove: WARNING: may not have removed all/correct segments
11:16:52 IBM Informix Dynamic Server Started.
Tue Sep 16 11:16:52 2008
11:16:52 Event alarms enabled. ALARMPROG =
'/Applications/IBM/informix/etc/alarmprogram.sh'
11:16:52 Booting Language <c> from module <>
11:16:52 Loading Module <CNULL>
11:16:52 Booting Language <builtin> from module <>
11:16:52 Loading Module <BUILTINNULL>
11:16:52 Warning: CONSOLE = /Applications/IBM/informix/tmp/online.con open
failed. Redirecting output to '/dev/null'.
11:16:57 DR: DRAUTO is 0 (Off)
11:16:57 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
11:16:57 IBM Informix Dynamic Server Version 11.50.FC2DE Software Serial Number
AAA#B000000
11:16:57 listener-thread: err = -25572: oserr = 49: errstr = : Network driver
cannot bind a name to the port.
System error = 49.
11:16:57 sql_listener: ASF_LISTEN failed
11:16:57 Attempting to bring listener thread down.
11:16:57 Server stopped.
11:16:57 IBM Informix Dynamic Server Stopped.
11:16:57 mt_shm_remove: WARNING: may not have removed all/correct segments
11:17:49 IBM Informix Dynamic Server Started.
Tue Sep 16 11:17:49 2008
11:17:49 Event alarms enabled. ALARMPROG =
'/Applications/IBM/informix/etc/alarmprogram.sh'
11:17:49 Booting Language <c> from module <>
11:17:49 Loading Module <CNULL>
11:17:49 Booting Language <builtin> from module <>
11:17:49 Loading Module <BUILTINNULL>
11:17:49 Warning: CONSOLE = /Applications/IBM/informix/tmp/online.con open
failed. Redirecting output to '/dev/null'.
11:17:54 DR: DRAUTO is 0 (Off)
11:17:54 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
11:17:54 IBM Informix Dynamic Server Version 11.50.FC2DE Software Serial Number
AAA#B000000
11:17:54 listener-thread: err = -25572: oserr = 49: errstr = : Network driver
cannot bind a name to the port.
System error = 49.
11:17:54 sql_listener: ASF_LISTEN failed
11:17:54 Attempting to bring listener thread down.
11:17:54 Server stopped.
11:17:54 IBM Informix Dynamic Server Stopped.
11:17:54 mt_shm_remove: WARNING: may not have removed all/correct segments
11:18:06 IBM Informix Dynamic Server Started.
Tue Sep 16 11:18:06 2008
11:18:06 Event alarms enabled. ALARMPROG =
'/Applications/IBM/informix/etc/alarmprogram.sh'
11:18:06 Booting Language <c> from module <>
11:18:06 Loading Module <CNULL>
11:18:06 Booting Language <builtin> from module <>
11:18:06 Loading Module <BUILTINNULL>
11:18:06 Warning: CONSOLE = /Applications/IBM/informix/tmp/online.con open
failed. Redirecting output to '/dev/null'.
11:18:11 DR: DRAUTO is 0 (Off)
11:18:11 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
11:18:11 IBM Informix Dynamic Server Version 11.50.FC2DE Software Serial Number
AAA#B000000
11:18:11 Assert Warning: chunk failed sanity check
11:18:11 IBM Informix Dynamic Server Version 11.50.FC2DE
11:18:11 Who: Session(1, ro...@machtim.local, 0, 0x200c79028)
Thread(7, main_loop(), 200c38028, 1)
File: rspartn.c Line: 9297
11:18:11 Results: Chunk 1 is being taken OFFLINE.
11:18:11 Action: For all spaces other than temporary dbspaces, restore the space
containing the chunk from the archive. If this chunk belongs to a
temporary dbspace and if it is not the only chunk in that dbspace,
then drop and re-create the chunk. Otherwise drop and re-create
the temporary dbspace.
11:18:11 stack trace for pid 21986 written to
/Applications/IBM/informix/tmp/af.3ef0673
11:18:11 See Also: /Applications/IBM/informix/tmp/af.3ef0673
11:18:11 chunk failed sanity check
11:18:11 listener-thread: err = -25572: oserr = 49: errstr = : Network driver
cannot bind a name to the port.
System error = 49.
11:18:11 sql_listener: ASF_LISTEN failed
11:18:11 Attempting to bring listener thread down.
11:18:11 Server stopped.
11:18:11 IBM Informix Dynamic Server Stopped.
11:18:11 mt_shm_remove: WARNING: may not have removed all/correct segments
InDeep
I uninstalled it and then put it in /opt/informix ... all seems to be working...
Looks like there's some kind of permissions problems on Mac if you try to put it in /Applications or under that tree.
-ID-
IBM Informix Dynamic Server Version 11.50.FC2DE -- On-Line -- Up 00:04:35 -- 41756 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
200c37028 ---P--D 1 informix - 0 0 0 38 27551
200c37828 ---P--F 0 informix - 0 0 0 0 2441
200c38028 ---P--F 0 informix - 0 0 0 0 0
200c38828 ---P--F 0 informix - 0 0 0 0 421
200c39028 ---P--F 0 informix - 0 0 0 0 101
200c39828 ---P--F 0 informix - 0 0 0 0 418
200c3a028 ---P--F 0 informix - 0 0 0 0 226
200c3a828 ---P--F 0 informix - 0 0 0 0 50
200c3b028 ---P--F 0 informix - 0 0 0 0 59
200c3b828 ---P--- 5 informix - 0 0 0 0 0
200c3c028 ---P--B 6 informix - 0 0 0 6 0
200c3c828 ---P--D 7 informix - 0 0 0 0 29
200c3d028 Y--P--D 14 informix - 200110b88 0 0 0 0
200c3d828 ---P--- 22 informix - 0 0 1 2 2
200c3e028 ---P--- 23 informix - 0 0 1 38 233
200c3e828 ---P--- 24 informix - 0 0 1 271 240
16 active, 128 total, 16 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1574 1579 358415 99.56 6422 36828 110541 94.19
isamtot open start read write rewrite delete commit rollbk
259575 39802 39076 64360 35774 3644 2704 3209 0
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 5.35 4.32 5 9
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
14 0 113909 0 0 4 2027 679
ixda-RA idx-RA da-RA RA-pgsused lchwaits
4 0 16 20 17
and the online.log:
12:51:34 IBM Informix Dynamic Server Started.
Tue Sep 16 12:51:34 2008
12:51:34 Event alarms enabled. ALARMPROG = '/opt/informix/etc/alarmprogram.sh'
12:51:34 Booting Language <c> from module <>
12:51:34 Loading Module <CNULL>
12:51:34 Booting Language <builtin> from module <>
12:51:34 Loading Module <BUILTINNULL>
12:51:34 Warning: CONSOLE = /opt/informix/tmp/online.con open failed. Redirecting output to '/dev/null'.
12:51:39 Waiting 60 seconds for startup to complete.
12:51:39 DR: DRAUTO is 0 (Off)
12:51:39 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
12:51:39 IBM Informix Dynamic Server Version 11.50.FC2DE Software Serial Number AAA#B000000
12:51:59 IBM Informix Dynamic Server Initialized -- Complete Disk Initialized.
12:51:59 Dataskip is now OFF for all dbspaces
12:51:59 Checkpoint Completed: duration was 0 seconds.
12:51:59 Tue Sep 16 - loguniq 1, logpos 0x110, timestamp: 0xb5 Interval: 2
12:51:59 Maximum server connections 0
12:51:59 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 5, Llog used 1
12:51:59 On-Line Mode
12:51:59 Building 'sysmaster' database ...
12:52:02 Booting Language <spl> from module <>
12:52:02 Loading Module <SPLNULL>
12:52:02 Performance Advisory: Based on the current workload, the logical log space might be too small to
accommodate the time it takes to flush the buffer pool.
12:52:02 Results: The server might block transactions during checkpoints.
12:52:02 Action: If transactions are blocked during the checkpoint, increase the size of the
logical log space to at least 79100 KB.
12:52:02 Performance Advisory: The logical log space is too small for automatic checkpoints.
12:52:02 Results: Automatic checkpoints are disabled.
12:52:02 Action: To enable automatic checkpoints, increase the logical log space to at least 79100
KB.
12:52:03 Unloading Module <SPLNULL>
12:52:03 Logical Log 1 Complete, timestamp: 0xe70e.
12:52:03 Checkpoint Completed: duration was 0 seconds.
12:52:03 Tue Sep 16 - loguniq 2, logpos 0xc018, timestamp: 0xe745 Interval: 3
12:52:03 Maximum server connections 1
12:52:03 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 53, Llog used 2512
12:52:04 Loading Module <SPLNULL>
12:52:04 Unloading Module <SPLNULL>
12:52:05 Checkpoint Completed: duration was 0 seconds.
12:52:05 Tue Sep 16 - loguniq 2, logpos 0x2582e8, timestamp: 0x1307d Interval: 4
12:52:05 Maximum server connections 1
12:52:05 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 118, Llog used 588
12:52:06 Loading Module <SPLNULL>
12:52:06 Unloading Module <SPLNULL>
12:52:07 Checkpoint Completed: duration was 0 seconds.
12:52:07 Tue Sep 16 - loguniq 2, logpos 0x488018, timestamp: 0x17644 Interval: 5
12:52:07 Maximum server connections 1
12:52:07 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 78, Llog used 560
12:52:08 'sysmaster' database built successfully.
12:52:09 'sysutils' database built successfully.
12:52:09 'sysuser' database built successfully.
12:52:16 Building 'sysadmin' database ...
12:52:17 Loading Module <SPLNULL>
12:52:17 'sysadmin' database built successfully.
12:52:17 SCHAPI: Started dbScheduler thread.
12:52:17 SCHAPI: Started 2 dbWorker threads.
12:52:18 Checkpoint Completed: duration was 0 seconds.
12:52:18 Tue Sep 16 - loguniq 2, logpos 0x921018, timestamp: 0x1e3f3 Interval: 6
12:52:18 Maximum server connections 1
12:52:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 97, Llog used 1228
12:52:18 Performance Advisory: Logical log file size might be too small for a
checkpoint to complete.
12:52:18 Results: The size of individual logical log files is too small for
the current workload, resulting in each log file filling very
quickly. If log files fill in less than 30 seconds, the checkpoint
might remain blocked because the last log file fills during the time
needed to perform the checkpoint.
12:52:18 Action: Increase the size of the individual logical log files so
that it takes at least 30 seconds to fill each one. Look at the
online log to determine how quickly the log files are filling, and
then increase the size of the files proportionately.
12:52:18 Logical Log 2 Complete, timestamp: 0x1fc3e.
12:57:23 Checkpoint Completed: duration was 0 seconds.
12:57:23 Tue Sep 16 - loguniq 3, logpos 0x119018, timestamp: 0x21058 Interval: 7
12:57:23 Maximum server connections 1
12:57:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 64, Llog used 444
Fernando Nunes
In another OS it's:
#define EADDRNOTAVAIL 49 /* Can't assign requested address */
Did you only change the install path? I don't see how the install path can
cause any that error... But I never put my hands on Mac OSX...
Regards
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
InDeep
> Can you find what error 49 means?
> In another OS it's:
>
> #define EADDRNOTAVAIL 49 /* Can't assign requested address */
>
> Did you only change the install path? I don't see how the install path
> can cause any that error... But I never put my hands on Mac OSX...
>
> Regards
>
I installed everything as it came, no changes to the installation. The installer
pointed the installation to /Applications/IBM/Informix. Not exactly what I would
recommend with what little I know about MacOSX, or my preference. I wanted to see
if the default installation would actually install. I also enabled roles, just an
FYI. But everything else was default.
On the second pass I changed it to /opt/informix, which is more compatible with
having nothing to do with IBM on my system--well at least visually or mechanically
anyway.
Thanks,
-ID-