RE: oninit -i
Posted in 2006
Topics: Storage & Space Management, Stored Procedures & SPL, Server Administration, Logging & Checkpoints, Migration, Import/Export & Data Conversion, Platform-Specific Issues
Hmmmmm,,,,did you change your servernum?
________________________________
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Quman
Sent: Wednesday, July 05, 2006 11:28 AM
To: informix-list@iiug.org
Subject: oninit -i
HI,
I am using "oninit -i " to creat a new instance. Following is message
log,
18:07:00 IBM Informix Dynamic Server Started.
18:07:01 Segment locked: addr=0x40000000, size=441319424
Mon Jul 3 18:07:01 2006
18:07:01 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecurepermissions
18:07:01 Event alarms enabled. ALARMPROG =
'/usr/informix/etc/alarmprogram.sh'
18:07:01 Booting Language <c> from module <>
18:07:01 Loading Module <CNULL>
18:07:01 Booting Language <builtin> from module <>
18:07:01 Loading Module <BUILTINNULL>
18:07:06 DR: DRAUTO is 0 (Off)
18:07:06 AIX MP latch code enabled
18:07:07 IBM Informix Dynamic Server Version 10.00.UC4 SoftwareSerial Number AAA#B000000
18:07:09 IBM Informix Dynamic Server Initialized -- Complete DiskInitialized.
18:07:09 Checkpoint Completed: duration was 0 seconds.
18:07:09 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x73
18:07:09 Maximum server connections 0
18:07:09 Dataskip is now OFF for all dbspaces
18:07:09 On-Line Mode
18:07:09 Building 'sysmaster' database ...
18:07:10 Logical Log 1 Complete, timestamp: 0x41a5.
18:07:11 Logical Log 2 Complete, timestamp: 0x7689.
18:07:11 Checkpoint Completed: duration was 0 seconds.
18:07:11 Checkpoint loguniq 3, logpos 0x18, timestamp: 0x76ab
18:07:11 Maximum server connections 1
18:07:11 Booting Language <spl> from module <>
18:07:11 Loading Module <SPLNULL>
18:07:12 Unloading Module <SPLNULL>
18:07:12 Loading Module <SPLNULL>
18:07:12 Logical Log 3 Complete, timestamp: 0x8c8e.
18:07:12 Unloading Module <SPLNULL>
18:07:13 Loading Module <SPLNULL>
18:07:13 Logical Log 4 Complete, timestamp: 0xcc4e.
18:07:13 Checkpoint Completed: duration was 0 seconds.
18:07:13 Checkpoint loguniq 5, logpos 0x104, timestamp: 0xcc94
18:07:13 Maximum server connections 1
18:07:13 Aborting Long Transaction: tx 0x6025eaac username: informix
uid: 3000
18:07:14 'sysmaster' database built successfully.
18:07:14 'sysutils' database built successfully.
18:07:14 Error building 'sysuser' database. see output file
/tmp/blduser.out.
I looked at file : /tmp/blduser.out:
458: Long transaction aborted.
12204: RSAM error: Long transaction detected.
Error in line 16Near character position 31
349: Database not selected yet.
Error in line 26Near character position 39
349: Database not selected yet.
Error in line 29Near character position 36
349: Database not selected yet.
Error in line 31Near character position 25
349: Database not selected yet.
Error in line 32Near character position 22
349: Database not selected yet.
Error in line 34Near character position 26
349: Database not selected yet.
Error in line 35Near character position 13
I have no idea why iit says:
18:07:14 Error building 'sysuser' database. see output file
/tmp/blduser.out.
IDS 10 UC4 on AIX 5
Thanks,
Quman
Hamilton, Jerry wrote:
> Hmmmmm,,,,did you change your servernum?
>
> ------------------------------------------------------------------------
> *From:* informix-list-bounces@iiug.org
> [mailto:informix-list-bounces@iiug.org] *On Behalf Of *Quman
> *Sent:* Wednesday, July 05, 2006 11:28 AM
> *To:* informix-list@iiug.org
> *Subject:* oninit -i
>
> HI,
>
> I am using "oninit -i " to creat a new instance. Following is message log,
>
>
> 18:07:00 IBM Informix Dynamic Server Started.
> 18:07:01 Segment locked: addr=0x40000000, size=441319424>
> Mon Jul 3 18:07:01 2006
>
> 18:07:01 Warning: ONCONFIG dump directory (DUMPDIR) '/tmp' has insecure> permissions
> 18:07:01 Event alarms enabled. ALARMPROG =
> '/usr/informix/etc/alarmprogram.sh'
> 18:07:01 Booting Language <c> from module <>
> 18:07:01 Loading Module <CNULL>
> 18:07:01 Booting Language <builtin> from module <>
> 18:07:01 Loading Module <BUILTINNULL>
> 18:07:06 DR: DRAUTO is 0 (Off)
> 18:07:06 AIX MP latch code enabled
> 18:07:07 IBM Informix Dynamic Server Version 10.00.UC4 Software> Serial Number AAA#B000000
> 18:07:09 IBM Informix Dynamic Server Initialized -- Complete Disk> Initialized.
> 18:07:09 Checkpoint Completed: duration was 0 seconds.
> 18:07:09 Checkpoint loguniq 1, logpos 0xd0, timestamp: 0x73
>
> 18:07:09 Maximum server connections 0
> 18:07:09 Dataskip is now OFF for all dbspaces
> 18:07:09 On-Line Mode
> 18:07:09 Building 'sysmaster' database ...
> 18:07:10 Logical Log 1 Complete, timestamp: 0x41a5.
> 18:07:11 Logical Log 2 Complete, timestamp: 0x7689.
> 18:07:11 Checkpoint Completed: duration was 0 seconds.
> 18:07:11 Checkpoint loguniq 3, logpos 0x18, timestamp: 0x76ab
>
> 18:07:11 Maximum server connections 1
> 18:07:11 Booting Language <spl> from module <>
> 18:07:11 Loading Module <SPLNULL>
> 18:07:12 Unloading Module <SPLNULL>
> 18:07:12 Loading Module <SPLNULL>
> 18:07:12 Logical Log 3 Complete, timestamp: 0x8c8e.
> 18:07:12 Unloading Module <SPLNULL>
> 18:07:13 Loading Module <SPLNULL>
> 18:07:13 Logical Log 4 Complete, timestamp: 0xcc4e.
> 18:07:13 Checkpoint Completed: duration was 0 seconds.
> 18:07:13 Checkpoint loguniq 5, logpos 0x104, timestamp: 0xcc94
>
> 18:07:13 Maximum server connections 1
> 18:07:13 Aborting Long Transaction: tx 0x6025eaac username: informix
> uid: 3000
> 18:07:14 'sysmaster' database built successfully.
> 18:07:14 'sysutils' database built successfully.
> 18:07:14 Error building 'sysuser' database. see output file
> /tmp/blduser.out.>
>
>
> I looked at file : /tmp/blduser.out:
>
> 458: Long transaction aborted.>
> 12204: RSAM error: Long transaction detected.
> Error in line 16> Near character position 31
>
>
>
> I have no idea why iit says:
>
> 18:07:14 Error building 'sysuser' database. see output file
> /tmp/blduser.out.>
>
>
> IDS 10 UC4 on AIX 5
>
> Thanks,
>
> Quman
>
>
>
What have you got set for LOGFILES and LOGSIZE and LTXHWM and LTXEHWM??
Possibly, maybe, perhaps related to the "Long transaction aborted" ...
just a guess tho'