expanding physical log failed
Bill Hamilton
This is IDS 9.4 UC2 on Windows 2000.
I attempted to increase the size of the physical log today with ugly
results.
I created the new space and checked it for contiguous space.
I executed
onparams -p -s 32768 -d physpace1 -y
Onparams kept telling me that the server had to be in quiescent mode,
even though it was already it that mode.
I then modified the ONCONFIG file to change the PHYSFILE and PHYSDBS
variables and restarted the IDS.
I got this:
14:47:13 Booting Language <c> from module <>
14:47:13 Loading Module <CNULL>
14:47:13 Booting Language <builtin> from module <>
14:47:13 Loading Module <BUILTINNULL>
14:47:18 IBM Informix Dynamic Server Version 9.40.TC2 Software Serial
Number AAA#B000000
14:47:18 listener-thread: err = -25572: oserr = 48: errstr = : Network
driver cannot bind a name to the port.
System error = 48.
14:47:18 sql_listener: ASF_LISTEN failed
14:47:18 Attempting to bring listener thread down.
14:47:18 Server stopped.
I put the onconfig back the way it was and restarted with the same result.
I booted the machine and started IDS again with the same result.
I tried one more time to start IDS and it came up correctly.
Any ideas as to what caused this?
sending to informix-list
Bill Hamilton
sending to informix-list
sending to informix-list
Alexey Sonkin
Bill,
Are You sure, that fiel /etc/hosts was not modified since
last informix startup, or server was renamed, or file
sqlhosts was modified?
That error usaully means, that IDS is unable to open
listen socket on specific network adapter.
------------------------------------------
Alexey Sonkin
Senior Database Administrator
Alexey Sonkin
Bill,
sending to informix-list
Mark D. Stock
Bill Hamilton wrote:
Are you using Stream Pipe connections? If so, you need to clear out the
files in /INFORMIXTMP.
To change the physical log, you have to go all the way to off-line mode
then back on-line.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mds...@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list
Mark D. Stock
Bill Hamilton wrote:
Cheers,
--
Mark.
sending to informix-list
sending to informix-list
Bill Hamilton
This is windows, so there is no sqlhosts file.
It is in the registry someplace.
There were no mods.
The system came back eventually (with the physical still in the rootdbs)
after enough restarts.
> Bill,
>
> Are You sure, that fiel /etc/hosts was not modified since
> last informix startup, or server was renamed, or file
> sqlhosts was modified?
>
> That error usaully means, that IDS is unable to open
> listen socket on specific network adapter.
>
> ------------------------------------------
> Alexey Sonkin
> Senior Database Administrator
>
>
> > -----Original Message-----
> > From: Bill Hamilton [mailto:laid...@finsco.com]
> > Sent: Monday, February 09, 2004 4:14 PM
> > To: informix-list
> > Subject: expanding physical log failed
> >
> > sending to informix-list
> sending to informix-list
sending to informix-list
Bill Hamilton
sending to informix-list
sending to informix-list
Alexey Sonkin
Bill,
It looks like 'setnet32' registry information was
corrupt. Wonderful, that IDS is back again.
The alternative (and the most reliable method) to move
the physical log to anouther dbspace is:
1. Create necessary dbspace
2. Bring IDS down
3. Edit $ONCONFIG (on Windows, it's usually onconfig.$INFORMIXSERVER)
and modify PHYSDBS, PHYSFILE to proper values
4. Start IDS
Alexey Sonkin
Bill,
sending to informix-list