OK, the only outright errors I see are when the logical logs fill the
ALARMPROGRAM is being executed to back them up, but there was some
problem. Most likely the default in the default ALARMPROGRAM is to use
onbar to back up the logical logs and you probably did not configure any
storage manager parameters so that is failing. Not a real issue, except
that if you don't back up the logical logs manually instead (ontape -a or
the equivalent onbar command once a storage manager is configured) the
server will block updates to disk when all of the logs are filled.
There are warning about the logical logs being too small, but that's a
small thing.
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, Mar 23, 2015 at 5:37 PM, GUY DILLEN <guy.dillen@hotmail.com> wrote:
> Hi,
>
> The logfile after install, see below.
>
> Thanks.
> Guy
>
> 19:28:20 Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
> 19:28:20 Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
> 19:28:20 Parameter's user-configured value was adjusted. (MAX_PDQPRIORITY)
> 19:28:20 IBM Informix Dynamic Server Started.
> 19:28:20 Warning: The IBM IDS Innovator-C Edition license restriction
> limits
> 19:28:20 the total shared memory size for this server to 2097152 KB.
> 19:28:20 The maximum allowable shared memory was reset to this size to
> start
> the database server.
> 19:28:20 Requested shared memory segment size rounded from 8308KB to 8836KB
>
> Mon Mar 23 19:28:23 2015
>
> 19:28:23 Successfully added a bufferpool of page size 2K.
>
> 19:28:23 Event alarms enabled. ALARMPROG =
> '/opt/informix/etc/alarmprogram.sh'
> 19:28:26 Booting Language <c> from module <>
> 19:28:26 Loading Module <CNULL>
> 19:28:26 Booting Language <builtin> from module <>
> 19:28:26 Loading Module <BUILTINNULL>
> 19:28:31 DR: Cannot set the value of the onconfig parameter DRINTERVAL to
> 0.
>
> This configuration parameter is not supported
>
> in IDS Innovator-C Edition.
> 19:28:31 Event notification facility epoll enabled.
> 19:28:31 Waiting 600 seconds for startup to complete.
> 19:28:31 IBM Informix Dynamic Server Version 12.10.FC4IE Software Serial
> Number AAA#B000000
> 19:28:49 Performance Advisory: The physical log size is smaller than the
> recommended size for a
> server configured with RTO_SERVER_RESTART.
> 19:28:49 Results: Fast recovery performance might not be optimal.
> 19:28:49 Action: For best fast recovery performance when
> RTO_SERVER_RESTART is
> enabled,
> increase the physical log size to at least 56155 KB. For servers
> configured with a large buffer pool, this might not be necessary.
> 19:28:49 IBM Informix Dynamic Server Initialized -- Complete Disk
> Initialized.
> 19:28:49 Started 1 B-tree scanners.
> 19:28:49 B-tree scanner threshold set at 5000.
> 19:28:49 B-tree scanner range scan size set to -1.
> 19:28:49 B-tree scanner ALICE mode set to 6.
> 19:28:49 B-tree scanner index compression level set to med.
> 19:28:49 Warning: Invalid (non-existent/blobspace/disabled) dbspace listed
>
> in DBSPACETEMP: 'tempdbs'
> 19:28:49 Dataskip is now OFF for all dbspaces
> 19:28:49 CDR: Cannot set the value of the onconfig parameter CDR_SERIAL to
> 0.
>
> This configuration parameter is not supported
>
> in IDS Innovator-C Edition.
> 19:28:49 Building 'sysmaster' database ...
> 19:28:49 Checkpoint Completed: duration was 0 seconds.
> 19:28:49 Mon Mar 23 - loguniq 1, logpos 0x3e0, timestamp: 0xaf Interval: 2
>
> 19:28:49 Maximum server connections 0
> 19:28:49 Checkpoint Statistics - Avg. Txn Block Time 0.003, # Txns blocked
> 2,
> Plog used 5, Llog used 1
>
> 19:28:49 Performance Advisory: Based on the current workload, the physical
> log
> might be too small to
> accommodate the time it takes to flush the buffer pool.
> 19:28:49 Results: The server might block transactions during checkpoints.
> 19:28:49 Action: If transactions are blocked during the checkpoint,
> increase
> the size of the
> physical log to at least 14000 KB.
> 19:28:49 Performance Advisory: The physical log is too small for automatic
> checkpoints.
> 19:28:49 Results: Automatic checkpoints are disabled.
> 19:28:49 Action: To enable automatic checkpoints, increase the physical
> log to
> at least 14000 KB.
> 19:28:49 On-Line Mode
> 19:29:09 Logical Log 1 Complete, timestamp: 0x1109a.
> 19:29:09 Process exited with return code 127: /bin/sh /bin/sh -c
> /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 1 Complete, timestamp:
> 0x1109a." "Logical Log 1 Complete, timestamp: 0x1109a." "" 23001
> 19:29:16 Booting Language <spl> from module <>
> 19:29:16 Loading Module <SPLNULL>
> 19:29:27 Unloading Module <SPLNULL>
> 19:29:27 Loading Module <SPLNULL>
> 19:29:33 Checkpoint Completed: duration was 0 seconds.
> 19:29:33 Mon Mar 23 - loguniq 2, logpos 0x639018, timestamp: 0x1396e
> Interval:
> 3
>
> 19:29:33 Maximum server connections 1
> 19:29:33 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 13, Llog used 4665
>
> 19:29:35 Performance Advisory: Logical log file size might be too small
> for a
>
> checkpoint to complete.
> 19:29:35 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.
> 19:29:35 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.
> 19:29:36 Logical Log 2 Complete, timestamp: 0x1a379.
> 19:29:36 Process exited with return code 127: /bin/sh /bin/sh -c
> /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 2 Complete, timestamp:
> 0x1a379." "Logical Log 2 Complete, timestamp: 0x1a379." "" 23001
> 19:29:39 Checkpoint Completed: duration was 1 seconds.
> 19:29:39 Mon Mar 23 - loguniq 3, logpos 0xd3018, timestamp: 0x1a7d1
> Interval:
> 4
>
> 19:29:39 Maximum server connections 1
> 19:29:39 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 55, Llog used 1690
>
> 19:29:45 Checkpoint Completed: duration was 0 seconds.
> 19:29:45 Mon Mar 23 - loguniq 3, logpos 0x76d018, timestamp: 0x215b8
> Interval:
> 5
>
> 19:29:45 Maximum server connections 1
> 19:29:45 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 59, Llog used 1690
>
> 19:29:45 'sysmaster' database built successfully.
> 19:29:46 'sysutils' database built successfully.
> 19:29:46 'sysuser' database built successfully.
> 19:29:53 Building 'sysadmin' database ...
> 19:29:55 Logical Log 3 Complete, timestamp: 0x28650.
> 19:29:55 Process exited with return code 127: /bin/sh /bin/sh -c
> /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 3 Complete, timestamp:
> 0x28650." "Logical Log 3 Complete, timestamp: 0x28650." "" 23001
> 19:30:10 SCHAPI: Using
> (/opt/informix/etc/sysadmin/sch_init_ol_informix1210.sql) to initialize
> this
> instance.
>
> 19:30:16 Checkpoint Completed: duration was 0 seconds.
> 19:30:16 Mon Mar 23 - loguniq 4, logpos 0xbf92e4, timestamp: 0x2faf3
> Interval:
> 6
>
> 19:30:16 Maximum server connections 1
> 19:30:16 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 153, Llog used 4236
>
> 19:30:28 Checkpoint Completed: duration was 0 seconds.
> 19:30:28 Mon Mar 23 - loguniq 4, logpos 0xbfc084, timestamp: 0x2fb01
> Interval:
> 7
>
> 19:30:28 Maximum server connections 1
> 19:30:28 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 17, Llog used 3
>
> 19:30:29 Checkpoint Completed: duration was 0 seconds.
> 19:30:29 Mon Mar 23 - loguniq 4, logpos 0xbfe0d0, timestamp: 0x2fb0b
> Interval:
> 8
>
> 19:30:29 Maximum server connections 1
> 19:30:29 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 0, Llog used 2
>
> 19:30:30 Logical Log 4 Complete, timestamp: 0x2fb0e.
> 19:30:30 Process exited with return code 127: /bin/sh /bin/sh -c
> /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 4 Complete, timestamp:
> 0x2fb0e." "Logical Log 4 Complete, timestamp: 0x2fb0e." "" 23001
> 19:30:30 Physical log location changed to dbspace plog.
> 19:30:30 Physical log size changed to 65430 KB.
> 19:30:30 Space 'plog' added.
> 19:30:30 Checkpoint Completed: duration was 0 seconds.
> 19:30:30 Mon Mar 23 - loguniq 5, logpos 0x1080, timestamp: 0x2fb31
> Interval: 9
>
> 19:30:30 Maximum server connections 1
> 19:30:30 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 4, Llog used 6
>
> 19:30:31 Checkpoint Completed: duration was 0 seconds.
> 19:30:31 Mon Mar 23 - loguniq 5, logpos 0x72e4, timestamp: 0x2fb57
> Interval:
> 10
>
> 19:30:31 Maximum server connections 1
> 19:30:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 9, Llog used 6
>
> 19:30:31 Space 'llog' added.
> 19:30:31 Checkpoint Completed: duration was 0 seconds.
> 19:30:31 Mon Mar 23 - loguniq 5, logpos 0xa080, timestamp: 0x2fb68
> Interval:
> 11
>
> 19:30:31 Maximum server connections 1
> 19:30:31 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:33 Checkpoint Completed: duration was 0 seconds.
> 19:30:33 Mon Mar 23 - loguniq 5, logpos 0xf2e4, timestamp: 0x2fb9c
> Interval:
> 12
>
> 19:30:33 Maximum server connections 1
> 19:30:33 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 5
>
> 19:30:34 Space 'datadbs1' added.
> 19:30:34 Checkpoint Completed: duration was 0 seconds.
> 19:30:34 Mon Mar 23 - loguniq 5, logpos 0x12080, timestamp: 0x2fbad
> Interval:
> 13
>
> 19:30:34 Maximum server connections 1
> 19:30:34 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:37 Checkpoint Completed: duration was 0 seconds.
> 19:30:37 Mon Mar 23 - loguniq 5, logpos 0x172e4, timestamp: 0x2fbe1
> Interval:
> 14
>
> 19:30:37 Maximum server connections 1
> 19:30:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 5
>
> 19:30:37 Space 'datadbs2' added.
> 19:30:37 Checkpoint Completed: duration was 0 seconds.
> 19:30:37 Mon Mar 23 - loguniq 5, logpos 0x1a080, timestamp: 0x2fbf2
> Interval:
> 15
>
> 19:30:37 Maximum server connections 1
> 19:30:37 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:41 Checkpoint Completed: duration was 0 seconds.
> 19:30:41 Mon Mar 23 - loguniq 5, logpos 0x1f354, timestamp: 0x2fc2d
> Interval:
> 16
>
> 19:30:41 Maximum server connections 1
> 19:30:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 10, Llog used 5
>
> 19:30:41 Space 'datadbs3' added.
> 19:30:42 Checkpoint Completed: duration was 0 seconds.
> 19:30:42 Mon Mar 23 - loguniq 5, logpos 0x22080, timestamp: 0x2fc40
> Interval:
> 17
>
> 19:30:42 Maximum server connections 1
> 19:30:42 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:44 Successfully added a bufferpool of page size 8K.
>
> 19:30:47 Checkpoint Completed: duration was 0 seconds.
> 19:30:47 Mon Mar 23 - loguniq 5, logpos 0x2739c, timestamp: 0x2fc82
> Interval:
> 18
>
> 19:30:47 Maximum server connections 1
> 19:30:47 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 11, Llog used 5
>
> 19:30:47 Space 'data8dbs1' added.
> 19:30:47 Checkpoint Completed: duration was 0 seconds.
> 19:30:47 Mon Mar 23 - loguniq 5, logpos 0x2a080, timestamp: 0x2fc95
> Interval:
> 19
>
> 19:30:47 Maximum server connections 1
> 19:30:47 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:50 Checkpoint Completed: duration was 0 seconds.
> 19:30:50 Mon Mar 23 - loguniq 5, logpos 0x2f2e4, timestamp: 0x2fccd
> Interval:
> 20
>
> 19:30:50 Maximum server connections 1
> 19:30:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 5
>
> 19:30:50 Space 'data8dbs2' added.
> 19:30:50 Checkpoint Completed: duration was 0 seconds.
> 19:30:50 Mon Mar 23 - loguniq 5, logpos 0x32080, timestamp: 0x2fce0
> Interval:
> 21
>
> 19:30:50 Maximum server connections 1
> 19:30:50 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:53 Checkpoint Completed: duration was 0 seconds.
> 19:30:53 Mon Mar 23 - loguniq 5, logpos 0x372e4, timestamp: 0x2fd18
> Interval:
> 22
>
> 19:30:53 Maximum server connections 1
> 19:30:53 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 5
>
> 19:30:53 Space 'data8dbs3' added.
> 19:30:53 Checkpoint Completed: duration was 0 seconds.
> 19:30:53 Mon Mar 23 - loguniq 5, logpos 0x3a080, timestamp: 0x2fd2b
> Interval:
> 23
>
> 19:30:53 Maximum server connections 1
> 19:30:53 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:57 Checkpoint Completed: duration was 1 seconds.
> 19:30:57 Mon Mar 23 - loguniq 5, logpos 0x3f2e4, timestamp: 0x2fd5f
> Interval:
> 24
>
> 19:30:57 Maximum server connections 1
> 19:30:57 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 5
>
> 19:30:57 Space 'tmpdbspace' added.
> 19:30:57 Checkpoint Completed: duration was 0 seconds.
> 19:30:57 Mon Mar 23 - loguniq 5, logpos 0x42018, timestamp: 0x2fd80
> Interval:
> 25
>
> 19:30:57 Maximum server connections 1
> 19:30:57 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 5, Llog used 5
>
> 19:30:58 Checkpoint Completed: duration was 0 seconds.
> 19:30:58 Mon Mar 23 - loguniq 5, logpos 0x46018, timestamp: 0x2fdbc
> Interval:
> 26
>
> 19:30:58 Maximum server connections 1
> 19:30:58 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 7, Llog used 9
>
> 19:30:59 Checkpoint Completed: duration was 0 seconds.
> 19:30:59 Mon Mar 23 - loguniq 5, logpos 0x4d018, timestamp: 0x2fe06
> Interval:
> 27
>
> 19:30:59 Maximum server connections 1
> 19:30:59 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 16, Llog used 12
>
> 19:31:02 Checkpoint Completed: duration was 0 seconds.
> 19:31:02 Mon Mar 23 - loguniq 5, logpos 0x553b4, timestamp: 0x2fe37
> Interval:
> 28
>
> 19:31:02 Maximum server connections 1
> 19:31:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 14, Llog used 8
>
> 19:31:02 Checkpoint Completed: duration was 0 seconds.
> 19:31:02 Mon Mar 23 - loguniq 5, logpos 0x595a8, timestamp: 0x2fe95
> Interval:
> 29
>
> 19:31:02 Maximum server connections 1
> 19:31:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 10, Llog used 4
>
> 19:31:02 Space 'sbspace1' added.
> 19:31:02 Checkpoint Completed: duration was 1 seconds.
> 19:31:02 Mon Mar 23 - loguniq 5, logpos 0x5e088, timestamp: 0x2fecc
> Interval:
> 30
>
> 19:31:02 Maximum server connections 1
> 19:31:02 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 6, Llog used 8
>
> 19:31:05 Checkpoint Completed: duration was 0 seconds.
> 19:31:05 Mon Mar 23 - loguniq 5, logpos 0x645a8, timestamp: 0x2ff09
> Interval:
> 31
>
> 19:31:05 Maximum server connections 1
> 19:31:05 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 21, Llog used 6
>
> 19:31:05 Increasing # of AIO VPs to 2
>
> 19:31:05 Increasing # of CLEANER threads to 3.
>
> 19:31:05 Adding 1 additional cleaner threads.
> 19:31:05 Checkpoint Completed: duration was 0 seconds.
> 19:31:05 Mon Mar 23 - loguniq 5, logpos 0x66148, timestamp: 0x2ff3c
> Interval:
> 32
>
> 19:31:05 Maximum server connections 1
> 19:31:05 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 9, Llog used 2
>
> 19:31:05 Space 'tmpsbspace' added.
> 19:31:05 Value of SBSPACENAME has been changed to sbspace1.
> 19:31:05 Checkpoint Completed: duration was 0 seconds.
> 19:31:05 Mon Mar 23 - loguniq 5, logpos 0x6b088, timestamp: 0x2ff7c
> Interval:
> 33
>
> 19:31:05 Maximum server connections 1
> 19:31:05 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 6, Llog used 10
>
> 19:31:05 Value of DBSPACETEMP has been changed to tmpdbspace.
> 19:31:06 Value of SBSPACETEMP has been changed to tmpsbspace.
> 19:31:06 Log file 5 added to DBspace 3.
> 19:31:06 Checkpoint Completed: duration was 0 seconds.
> 19:31:06 Mon Mar 23 - loguniq 5, logpos 0x742e0, timestamp: 0x2ffa9
> Interval:
> 34
>
> 19:31:06 Maximum server connections 1
> 19:31:06 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 17, Llog used 9
>
> 19:31:07 Log file 6 added to DBspace 3.
> 19:31:08 Checkpoint Completed: duration was 1 seconds.
> 19:31:08 Mon Mar 23 - loguniq 5, logpos 0x76108, timestamp: 0x2ffb9
> Interval:
> 35
>
> 19:31:08 Maximum server connections 1
> 19:31:08 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 2
>
> 19:31:09 Log file 7 added to DBspace 3.
> 19:31:11 Checkpoint Completed: duration was 1 seconds.
> 19:31:11 Mon Mar 23 - loguniq 5, logpos 0x78108, timestamp: 0x2ffc9
> Interval:
> 36
>
> 19:31:11 Maximum server connections 1
> 19:31:11 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:12 Log file 8 added to DBspace 3.
> 19:31:12 Checkpoint Completed: duration was 0 seconds.
> 19:31:12 Mon Mar 23 - loguniq 5, logpos 0x7a108, timestamp: 0x2ffd9
> Interval:
> 37
>
> 19:31:12 Maximum server connections 1
> 19:31:12 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:13 Log file 9 added to DBspace 3.
> 19:31:13 Checkpoint Completed: duration was 0 seconds.
> 19:31:13 Mon Mar 23 - loguniq 5, logpos 0x7c108, timestamp: 0x2ffe9
> Interval:
> 38
>
> 19:31:13 Maximum server connections 1
> 19:31:13 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:13 Log file 10 added to DBspace 3.
> 19:31:14 Checkpoint Completed: duration was 0 seconds.
> 19:31:14 Mon Mar 23 - loguniq 5, logpos 0x7e108, timestamp: 0x2fff9
> Interval:
> 39
>
> 19:31:14 Maximum server connections 1
> 19:31:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:14 Log file 11 added to DBspace 3.
> 19:31:14 Checkpoint Completed: duration was 0 seconds.
> 19:31:14 Mon Mar 23 - loguniq 5, logpos 0x80108, timestamp: 0x30009
> Interval:
> 40
>
> 19:31:14 Maximum server connections 1
> 19:31:14 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:15 Log file 12 added to DBspace 3.
> 19:31:15 Checkpoint Completed: duration was 0 seconds.
> 19:31:15 Mon Mar 23 - loguniq 5, logpos 0x82108, timestamp: 0x30019
> Interval:
> 41
>
> 19:31:15 Maximum server connections 1
> 19:31:15 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:16 Log file 13 added to DBspace 3.
> 19:31:16 Checkpoint Completed: duration was 0 seconds.
> 19:31:16 Mon Mar 23 - loguniq 5, logpos 0x84108, timestamp: 0x30029
> Interval:
> 42
>
> 19:31:16 Maximum server connections 1
> 19:31:16 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:17 Log file 14 added to DBspace 3.
> 19:31:17 Checkpoint Completed: duration was 0 seconds.
> 19:31:17 Mon Mar 23 - loguniq 5, logpos 0x86108, timestamp: 0x30039
> Interval:
> 43
>
> 19:31:17 Maximum server connections 1
> 19:31:17 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 3, Llog used 2
>
> 19:31:17 Log file number 2 has been dropped from DBspace 1.
> 19:31:18 Checkpoint Completed: duration was 0 seconds.
> 19:31:18 Mon Mar 23 - loguniq 5, logpos 0x89288, timestamp: 0x3005d
> Interval:
> 44
>
> 19:31:18 Maximum server connections 1
> 19:31:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 7, Llog used 3
>
> 19:31:18 Log file number 3 has been dropped from DBspace 1.
> 19:31:18 Checkpoint Completed: duration was 0 seconds.
> 19:31:18 Mon Mar 23 - loguniq 5, logpos 0x8c288, timestamp: 0x3007d
> Interval:
> 45
>
> 19:31:18 Maximum server connections 1
> 19:31:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 11, Llog used 3
>
> 19:31:18 Log file number 4 has been dropped from DBspace 1.
> 19:31:18 Checkpoint Completed: duration was 0 seconds.
> 19:31:18 Mon Mar 23 - loguniq 5, logpos 0x8f288, timestamp: 0x3009d
> Interval:
> 46
>
> 19:31:18 Maximum server connections 1
> 19:31:18 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 11, Llog used 3
>
> 19:31:19 Logical Log 5 Complete, timestamp: 0x300b0.
> 19:31:19 Process exited with return code 127: /bin/sh /bin/sh -c
> /opt/informix/etc/alarmprogram.sh 2 23 "Logical Log 5 Complete, timestamp:
> 0x300b0." "Logical Log 5 Complete, timestamp: 0x300b0." "" 23001
> 19:31:21 Checkpoint Completed: duration was 0 seconds.
> 19:31:21 Mon Mar 23 - loguniq 6, logpos 0x2018, timestamp: 0x300cd
> Interval:
> 47
>
> 19:31:21 Maximum server connections 1
> 19:31:21 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 10, Llog used 6
>
> 19:31:22 Log file number 1 has been dropped from DBspace 1.
> 19:31:22 Checkpoint Completed: duration was 0 seconds.
> 19:31:22 Mon Mar 23 - loguniq 6, logpos 0x5288, timestamp: 0x300f0
> Interval:
> 48
>
> 19:31:22 Maximum server connections 1
> 19:31:22 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 11, Llog used 3
>
> 19:31:23 Checkpoint Completed: duration was 0 seconds.
> 19:31:23 Mon Mar 23 - loguniq 6, logpos 0xa018, timestamp: 0x3011b
> Interval:
> 49
>
> 19:31:23 Maximum server connections 1
> 19:31:23 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 0,
> Plog used 10, Llog used 5
>
> 19:31:24 Value of AUTO_TUNE has been changed to 2.
> 19:31:24 Current value for AUTO_READAHEAD (1,128) was saved in config file.
>
> 19:31:24 Current value for AUTO_LRU_TUNING (1) was saved in config file.
>
> 19:31:24 Value of AUTO_AIOVPS has been changed to 1.
> 19:31:24 Value of AUTO_REPREPARE has been changed to 1.
> 19:31:24 Value of AUTO_STAT_MODE has been changed to 1.
> 19:31:24 Value of AUTO_CKPTS has been changed to 1.
> 19:31:24 Value of AUTO_LLOG has been changed to 1,llog,204800.
> 19:31:25 Value of DEF_TABLE_LOCKMODE has been changed to row.
> 19:31:25 Current value for BAR_BSALIB_PATH (<BLANK>) was saved in config
> file.
>
> 19:31:25 Value of DS_NONPDQ_QUERY_MEM has been changed to 2048 kilobytes.
> 19:31:25 Value of DS_MAX_QUERIES has been changed to 4.
> 19:31:25 Current value for LTAPEDEV (/dev/null) was saved in config file.
>
> 19:31:25 Value of TEMPTAB_NOLOG has been changed to 1.
> 19:31:25 Current value for USTLOW_SAMPLE (1) was saved in config file.
>
> 19:31:25 Current value for DIRECTIVES (1) was saved in config file.
>
> 19:31:25 Value of DUMPSHMEM has been changed to 2.
> 19:31:25 Value of CDR_AUTO_DISCOVER has been changed to 1.
> 19:31:25 Value of SMX_COMPRESS has been changed to 1.
> 19:31:25 Current value for ENABLE_SNAPSHOT_COPY (0) was saved in config
> file.
>
> 19:31:25 Value of CDR_QUEUEMEM has been changed to 51200.
> 19:31:25 Value of CDR_APPLY has been changed to 1,4.
> 19:31:26 Value of CDR_EVALTHREADS has been changed to 1,4.
> 19:31:26 Value of SDS_PAGING has been changed to
>
> /opt/informix/storage/ifx_sds_paging1_ol_informix1210,/opt/informix/storage/ifx_sds_paging2_ol_informix1210.
> 19:31:26 Value of SDS_TEMPDBS has been changed to
>
> ifx_sds_tmpdbs_ol_informix1210,/opt/informix/storage/ifx_sds_tmpdbs_ol_informix1210,2,0,51200.
> 19:31:26 Value of OFF_RECVRY_THREADS has been changed to 11.
> 19:31:26 Value of USERMAPPING has been changed to BASIC.
> 19:31:28 Entries in the surrogates file /etc/informix/allowed.surrogates
> are
> loaded into surrogate cache.
> 19:31:29 'sysadmin' database built successfully.
> 19:31:29 SCHAPI: Started dbScheduler thread.
> 19:31:29 Auto Registration is synced
> 19:31:30 Checkpoint Completed: duration was 0 seconds.
> 19:31:30 Mon Mar 23 - loguniq 6, logpos 0x74018, timestamp: 0x30602
> Interval:
> 50
>
> 19:31:30 Maximum server connections 1
> 19:31:30 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked
> 1,
> Plog used 67, Llog used 121
>
> 19:31:30 Updating Low Memory Manager to version 11
> 19:31:30 Installing patch to upgrade ph_task code. version(13.04)
> 19:31:30 SCHAPI: Started 2 dbWorker threads.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--90e6ba61409ceea2900511fcbef7
