Migrating from IDS 9.40.UC6 to 11.50.UC3
- From: Alexander <homo.programmerus@xxxxxxxxx>
- Date: Sat, 4 Apr 2009 15:11:16 -0700 (PDT)
Hello everybody,
We are currently running IDS 9.40UC6 on top of Solaris/Sparc 9 and in
about two weeks we will be moving that to new location. We couldn't
get support for IDS 9.40 so may be it is good time to upgrade to more
recent Informix version.
I tried to follow migration procedure using our test server.
Installation went almost flawless and after copying onconfig and
sqlhosts from previous installation I started oninit that supposed to
automatically convert database. Documentation says that conversion is
done when online.log contains "Conversion Completed Successfully". It
started well without any errors:
15:55:03 IBM Informix Dynamic Server Started.
Sat Apr 4 15:55:08 2009
15:55:08 Event alarms enabled. ALARMPROG = '/opt/informix/etc/
alarmprogram.sh'
15:55:09 Booting Language <c> from module <>
15:55:09 Loading Module <CNULL>
15:55:09 Booting Language <builtin> from module <>
15:55:09 Loading Module <BUILTINNULL>
15:55:09 Warning: CONSOLE = /dev/console open failed. Redirecting
output to '/dev/null'.
15:55:16 DR: DRAUTO is 0 (Off)
15:55:16 DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
15:55:16 Requested shared memory segment size rounded from 560KB to
1024KB
15:55:16 Fast poll /dev/poll enabled.
15:55:16 IBM Informix Dynamic Server Version 11.50.FC3 Software
Serial Number AAA#B000000
15:55:17 Conversion from version 9.40 Started
15:55:17 Checking partition header pages for needed free space
15:55:19 Checking for free space in partition header pages succeeded
15:55:29 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
15:55:29 Started 1 B-tree scanners.
15:55:29 B-tree scanner threshold set at 5000.
15:55:29 B-tree scanner range scan size set to -1.
15:55:29 B-tree scanner ALICE mode set to 6.
15:55:29 B-tree scanner index compression level set to med.
15:55:29 Physical Recovery Started at Page (1:84371).
15:55:29 Physical Recovery Complete: 0 Pages Examined, 0 Pages
Restored.
15:55:29 Logical Recovery Started.
15:55:29 22 recovery worker threads will be started.
15:55:30 Going to conv
15:55:31 Logical Recovery has reached the transaction cleanup phase.
15:55:31 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
15:55:32 Onconfig parameter CONSOLE modified from /dev/console to /
dev/null.
15:55:32 Onconfig parameter SHMBASE modified from 167772160 to
4462739456.
15:55:32 Onconfig parameter STACKSIZE modified from 64 to 128.
15:55:32 Dataskip is now OFF for all dbspaces
15:55:33 Conv/rev: Started check phase of conversion for component
RSAM
15:55:33 Conv/rev: Finished check phase of conversion for component
RSAM
15:55:33 Conv/rev: Started check phase of conversion for component
SQL
15:55:33 Conv/rev: Finished check phase of conversion for component
SQL
15:55:33 Conv/rev: Started check phase of conversion for component
SMI
15:55:33 Conv/rev: Finished check phase of conversion for component
SMI
15:55:33 Conv/rev: Started check phase of conversion for component
BAR
15:55:33 Conv/rev: Finished check phase of conversion for component
BAR
15:55:33 Conv/rev: Started check phase of conversion for component
PLOAD
15:55:33 Conv/rev: Finished check phase of conversion for component
PLOAD
15:55:33 Conv/rev: Started check phase of conversion for component
RTREE
15:55:33 Conv/rev: Finished check phase of conversion for component
RTREE
15:55:33 Conv/rev: Started check phase of conversion for component
SECURE
15:55:33 Conv/rev: Finished check phase of conversion for component
SECURE
15:55:33 Conv/rev: Started check phase of conversion for component
SCHAPI
15:55:33 calling schapi_cvr1150_check_convertable
15:55:33 Conv/rev: Finished check phase of conversion for component
SCHAPI
15:55:33 Conv/rev: Started check phase of conversion for component HA
15:55:33 Conv/rev: Finished check phase of conversion for component
HA
15:55:33 Conv/rev: Started conversion for component RSAM
15:55:33 Converting Secondary Partition Header Pages Started
15:55:33 Converting Secondary Partition Header Pages Succeeded
15:55:33 Checkpoint Completed: duration was 1 seconds.
15:55:33 Sat Apr 4 - loguniq 53042, logpos 0x6018, timestamp:
0xd4da7e0b Interval: 2
15:55:33 Maximum server connections 0
15:55:33 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns
blocked 1, Plog used 856, Llog used 1
15:55:33 Quiescent Mode
15:55:34 Checkpoint Completed: duration was 0 seconds.
15:55:34 Sat Apr 4 - loguniq 53042, logpos 0x7044, timestamp:
0xd4da7e16 Interval: 3
15:55:34 Maximum server connections 0
15:55:34 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns
blocked 0, Plog used 26, Llog used 1
15:55:34 Conv/rev: Finished conversion for component RSAM
15:55:34 Conv/rev: Started conversion for component SQL
15:55:34 processing sysmaster
15:55:34 Converting database sysmaster ...
15:55:34 Single-User Mode.
15:55:34 Affinitied VP 1 to phys proc 1
15:55:34 Affinitied VP 4 to phys proc 5
15:55:34 Affinitied VP 11 to phys proc 14
15:55:34 Affinitied VP 9 to phys proc 12
15:55:34 Affinitied VP 3 to phys proc 4
15:55:34 Affinitied VP 8 to phys proc 11
15:55:34 Affinitied VP 12 to phys proc 15
15:55:34 Affinitied VP 10 to phys proc 13
15:55:34 Affinitied VP 5 to phys proc 8
15:55:34 Affinitied VP 6 to phys proc 9
15:55:34 Affinitied VP 7 to phys proc 10
15:55:34 The database sysmaster has been converted successfully.
15:55:34 Converting database sysmaster ...
15:55:37 The database sysmaster has been converted successfully.
15:55:37 Converting database sysmaster ...
15:55:37 The database sysmaster has been converted successfully.
15:55:37 processing sysutils
15:55:37 Converting database sysutils ...
15:55:38 The database sysutils has been converted successfully.
15:55:38 Converting database sysutils ...
15:55:56 The database sysutils has been converted successfully.
15:55:56 Converting database sysutils ...
15:55:56 The database sysutils has been converted successfully.
15:55:56 processing sysuser
15:55:56 Converting database sysuser ...
15:56:02 The database sysuser has been converted successfully.
15:56:02 Converting database sysuser ...
15:56:20 The database sysuser has been converted successfully.
15:56:20 Converting database sysuser ...
15:56:20 The database sysuser has been converted successfully.
16:26:44 Checkpoint Completed: duration was 1242 seconds.
16:26:44 Sat Apr 4 - loguniq 53042, logpos 0x804018, timestamp:
0xd4db1393 Interval: 4
16:26:44 Maximum server connections 0
16:26:44 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns
blocked 0, Plog used 1273, Llog used 2045
It's been silent for almost two hours since last event. No expected
"Conversion Completed Successfully" so far and no errors either.
I'm just wondering if that's is normal. How long it supposed to take
for relatively small database (about 25Gb Level 0 archive)?
There is shell script /opt/informix/etc/dummyupds that has been on
process list for all that time. It started dbaccess to execute some
set of updates. My logical log usage didn't change since I started to
suspect that migration process got stuck.
Any help is greatly appreciated.
Cheers,
Alexander
.
- Follow-Ups:
- Re: Migrating from IDS 9.40.UC6 to 11.50.UC3
- From: Alexander
- Re: Migrating from IDS 9.40.UC6 to 11.50.UC3
- Prev by Date: Re: IBM to hire Gumby!
- Next by Date: Re: IBM to hire Gumby!
- Previous by thread: Hey when IBM buys Sun, can someone fix the glassfish and sun docs?
- Next by thread: Re: Migrating from IDS 9.40.UC6 to 11.50.UC3
- Index(es):
Relevant Pages
|
