API tools faq
paste
Guest User

Informix startup

a guest
Dec 16th, 2022
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 8.06 KB | Software | 0 0
raw download clone embed print report
  1. Wed Dec 14 00:30:05 2022
  2.  
  3. 00:30:05  Successfully added a bufferpool of page size 2K.
  4.  
  5. 00:30:05  Event alarms enabled.  ALARMPROG = '/opt/IBM/informix/12.10/etc/alarmprogram.sh'
  6. 00:30:05  Booting Language <c> from module <>
  7. 00:30:05  Loading Module <CNULL>
  8. 00:30:05  Booting Language <builtin> from module <>
  9. 00:30:05  Loading Module <BUILTINNULL>
  10. 00:30:11  DR: DRAUTO is 0 (Off)
  11. 00:30:11  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
  12. 00:30:11  Entries in the surrogates file /etc/informix/allowed.surrogates are loaded into surrogate cache.
  13. 00:30:11  Trusted host cache successfully built:/etc/hosts.equiv.
  14. 00:30:11  Event notification facility epoll enabled.
  15. 00:30:11  IBM Informix Dynamic Server Version 12.10.FC2WE Software Serial Number AAA#B000000
  16. 00:30:11  Performance Advisory: The physical log size is smaller than the recommended size for a
  17. server configured with RTO_SERVER_RESTART.
  18. 00:30:11   Results: Fast recovery performance might not be optimal.
  19. 00:30:11   Action: For best fast recovery performance when RTO_SERVER_RESTART is enabled,
  20. increase the physical log size to at least 158543 KB. For servers
  21. configured with a large buffer pool, this might not be necessary.
  22. 00:30:12  IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
  23.  
  24. 00:30:12  Started 1 B-tree scanners.
  25. 00:30:12  B-tree scanner threshold set at 5000.
  26. 00:30:12  B-tree scanner range scan size set to -1.
  27. 00:30:12  B-tree scanner ALICE mode set to 6.
  28. 00:30:12  B-tree scanner index compression level set to med.
  29. 00:30:12  Physical Recovery Started at Page (2:13466).
  30. 00:30:12  Physical Recovery Complete: 147 Pages Examined, 147 Pages Restored.
  31. 00:30:12  Logical Recovery Started.
  32. 00:30:12  12 recovery worker threads will be started.
  33. 00:30:13  Logical Recovery has reached the transaction cleanup phase.
  34. 00:30:13  Logical Recovery Complete.
  35.           0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
  36.  
  37. 00:30:16  Dataskip is now OFF for all dbspaces
  38. 00:30:16  Checkpoint Completed:  duration was 1 seconds.
  39. 00:30:16  Wed Dec 14 - loguniq 60976, logpos 0x74e0c0, timestamp: 0x8ad6fa45 Interval: 16236
  40.  
  41. 00:30:16  Maximum server connections 0
  42. 00:30:16  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 152, Llog used 1
  43.  
  44. 00:30:16  On-Line Mode
  45. 00:30:17  SCHAPI: Started dbScheduler thread.
  46. 00:30:18  Booting Language <spl> from module <>
  47. 00:30:18  Loading Module <SPLNULL>
  48. 00:30:18  Auto Registration is synced
  49. 00:30:18  SCHAPI: Started 2 dbWorker threads.
  50. 00:30:19  Defragmenter cleaner thread now running
  51. 00:30:19  Defragmenter cleaner thread cleaned:0 partitions
  52. 00:31:18  Loading Module <$INFORMIXDIR/extend/ifxmngr/ifxmngr.bld>
  53. 00:31:18  pid 24792: ELF .eh_frame section missing in /opt/IBM/informix/12.10/gls/dll/64-libicudata.so.48
  54. 00:31:18  The C Language Module </opt/IBM/informix/12.10/extend/ifxmngr/ifxmngr.bld> loaded
  55. 00:43:20  Performance Advisory: Based on the current workload, the physical log might be too small to
  56. accommodate the time it takes to flush the buffer pool.
  57. 00:43:20   Results: The server might block transactions during checkpoints.
  58. 00:43:20   Action: If transactions are blocked during the checkpoint, increase the size of the
  59.  physical log to at least 262584 KB.
  60. 00:43:20  Performance Advisory: The physical log is too small for automatic checkpoints.
  61. 00:43:20   Results: Automatic checkpoints are disabled.
  62. 00:43:20   Action: To enable automatic checkpoints, increase the physical log to at least 262584 KB.
  63. 00:43:22  Logical Log 60976 Complete, timestamp: 0x8ada9b57.
  64. 00:43:23  Checkpoint Completed:  duration was 1 seconds.
  65. 00:43:23  Wed Dec 14 - loguniq 60977, logpos 0xfa728, timestamp: 0x8adaa2b1 Interval: 16237
  66.  
  67. 00:43:23  Maximum server connections 2
  68. 00:43:23  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 24590, Llog used 2789
  69.  
  70. 00:43:51  Checkpoint Completed:  duration was 1 seconds.
  71. 00:43:51  Wed Dec 14 - loguniq 60977, logpos 0x95923c, timestamp: 0x8adc3ebd Interval: 16238
  72.  
  73. 00:43:51  Maximum server connections 2
  74. 00:43:51  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 24576, Llog used 2399
  75.  
  76. 00:43:59  Logical Log 60977 Complete, timestamp: 0x8adcda88.
  77. 00:44:14  Performance Advisory: Logical log file size might be too small for a
  78.           checkpoint to complete.
  79. 00:44:14   Results: The size of individual logical log files is too small for
  80.           the current workload, resulting in each log file filling very
  81.           quickly. If log files fill in less than 30 seconds, the checkpoint
  82.           might remain blocked because the last log file fills during the time
  83.           needed to perform the checkpoint.
  84. 00:44:14   Action: Increase the size of the individual logical log files so
  85.           that it takes at least 30 seconds to fill each one. Look at the
  86.           online log to determine how quickly the log files are filling, and
  87.           then increase the size of the files proportionately.
  88. 00:44:14  Logical Log 60978 Complete, timestamp: 0x8adea183.
  89. 00:44:31  Logical Log 60979 Complete, timestamp: 0x8ae08232.
  90. 00:44:53  Logical Log 60980 Complete, timestamp: 0x8ae22248.
  91. 00:45:01  Checkpoint Completed:  duration was 1 seconds.
  92. 00:45:01  Wed Dec 14 - loguniq 60981, logpos 0x598690, timestamp: 0x8ae2bf05 Interval: 16239
  93.  
  94. 00:45:01  Maximum server connections 2
  95. 00:45:01  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 1, Plog used 24588, Llog used 15459
  96.  
  97. 00:45:12  Logical Log 60981 Complete, timestamp: 0x8ae3c926.
  98. 00:45:31  Logical Log 60982 Complete, timestamp: 0x8ae547c5.
  99. 00:45:50  Logical Log 60983 Complete, timestamp: 0x8ae6c4fd.
  100. 00:46:09  Logical Log 60984 Complete, timestamp: 0x8ae87aa2.
  101. 01:00:02  Logical Log 60985 Complete, timestamp: 0x8ae9d232.
  102. 01:00:05  Logical Log 60986 Complete, timestamp: 0x8aead60a.
  103. 01:00:07  Logical Log 60987 Complete, timestamp: 0x8aeb84b0.
  104. 01:00:10  Logical Log 60988 Complete, timestamp: 0x8aec72a6.
  105. 01:00:13  Logical Log 60989 Complete, timestamp: 0x8aed4c09.
  106. 01:00:15  Logical Log 60990 Complete, timestamp: 0x8aede596.
  107. 07:04:05  Logical Log 60991 Complete, timestamp: 0x8aef1d1d.
  108. 07:51:50  Check for password aging/account lock-out.
  109.  
  110. 08:32:46  ** AUTO TUNING - Extending bufferpool 2K.
  111. 08:32:46  Extended bufferpool 2K
  112.         196608K memory, 91171 buffers
  113.  
  114. 09:37:46  ** AUTO TUNING - Extending bufferpool 2K.
  115. 09:37:46  Extended bufferpool 2K
  116.         196608K memory, 91171 buffers
  117.  
  118. 20:04:05  Logical Log 60992 Complete, timestamp: 0x8af06d96.
  119.  
  120. Thu Dec 15 00:36:14 2022
  121.  
  122. 00:36:14  Checkpoint Completed:  duration was 0 seconds.
  123. 00:36:14  Thu Dec 15 - loguniq 60993, logpos 0x6a5018, timestamp: 0x8af11e33 Interval: 16240
  124.  
  125. 00:36:14  Maximum server connections 26
  126. 00:36:14  Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 8018, Llog used 49421
  127.  
  128. 00:36:15  IBM Informix Dynamic Server Stopped.
  129.  
  130. 00:36:16  IBM Informix Dynamic Server Started.
  131. 00:36:16  Warning: The IBM IDS Workgroup Edition license restriction limits
  132. 00:36:16  the total shared memory size for this server to 16777216 KB.
  133. 00:36:16  The maximum allowable shared memory was reset to this size to start the database server.
  134. 00:36:16  Requested shared memory segment size rounded from 11472KB to 12040KB
  135.  
  136. Thu Dec 15 00:36:17 2022
  137.  
  138. 00:36:17  Successfully added a bufferpool of page size 2K.
  139.  
  140. 00:36:17  Event alarms enabled.  ALARMPROG = '/opt/IBM/informix/12.10/etc/alarmprogram.sh'
  141. 00:36:17  Booting Language <c> from module <>
  142. 00:36:17  Loading Module <CNULL>
  143. 00:36:17  Booting Language <builtin> from module <>
  144. 00:36:17  Loading Module <BUILTINNULL>
  145. 00:36:22  Entries in the surrogates file /etc/informix/allowed.surrogates are loaded into surrogate cache.
  146. 00:36:22  Trusted host cache successfully built:/etc/hosts.equiv.
  147. 00:36:22  DR: DRAUTO is 0 (Off)
  148. 00:36:22  DR: ENCRYPT_HDR is 0 (HDR encryption Disabled)
  149. 00:36:22  Event notification facility epoll enabled.
  150. 00:36:23  IBM Informix Dynamic Server Version 12.10.FC2WE Software Serial Number AAA#B000000
  151. 00:36:23  (5) connection rejected - no calls allowed for sqlexec
  152. 00:36:23  (6) connection rejected - no calls allowed for sqlexec
  153.  
Tags: informix
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!