=======================================
Informix Database - system mgmt notes
=======================================

1) Error: $INFORMIX_HOME/tmp/online.log: Logical Log Files are Full -- Backup is Needed

---
informix@berlin:/opt/app/informix/tmp$ onstat -l

IBM Informix Dynamic Server Version 11.50.FC4DE -- Fast Recovery (CKPT REQ) -- Up 00:17:00 -- 149740 Kbytes
Blocked:CKPT 

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-1  0        64       0          0          0.00
      phybegin         physize    phypos     phyused    %used   
      1:263            25000      8702       2          0.01    

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-1  1        32       0          0          0          0.0        0.0     
	Subsystem    numrecs    Log Space used

Buffer Waiting
Buffer  ioproc   flags            
  L-1   0        0x1      0

address          number   flags    uniqid   begin                size     used    %used
4b656f98         1        U------  1        1:25263              5000     5000   100.00
4b79bf50         2        U------  2        1:30263              5000     5000   100.00
4b79bfb8         3        U------  3        1:35263              5000     5000   100.00
4b783c50         4        U------  4        1:40263              5000     5000   100.00
4b783cb8         5        U------  5        1:45263              5000     5000   100.00
4b783d20         6        U---C-L  6        1:50263              5000     5000   100.00

---
 
Solution:
using onmonitor->Logical_logs, set LTAPEDEV to be /opt/app/informix/tmp
and run 
ontape -a

then restart IDS.
make sure ontape -a worked.

add more logical log space/ files as needed.
G/

08032009 15:26:00
informix@berlin:/opt/app/informix$ ontape -a

Performing automatic backup of logical logs.

File created: /opt/app/informix/tmp/berlin_0_Log0000000002
File created: /opt/app/informix/tmp/berlin_0_Log0000000003
File created: /opt/app/informix/tmp/berlin_0_Log0000000004
File created: /opt/app/informix/tmp/berlin_0_Log0000000005
File created: /opt/app/informix/tmp/berlin_0_Log0000000006
Do you want to back up the current logical log? (y/n) y
File created: /opt/app/informix/tmp/berlin_0_Log0000000007

Program over.




-------------
->Informix 11 IDS went into full-recovery mode probably because logical logs were full. Did the following:

onstat -g glo
notedown the PID for cpu under INDVIDUAL VIRTUAL PROCESSES

kill -9 <PID#>
onstat -
oninit -vy

then add additional logical logs


refs:
http://qaix.com/informix-database-development/274-814-logical-log-files-are-full-backup-is-needed-read.shtml

how to add logical logs in informix manually:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin532.htm

moving a log file to another dbspace
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin580.htm
========================================================================

2)Tools:  Informix administration commands:
startup:
oninit -vy
or just oninit

check status:
onstat -

shutdown:
onmode -kuy (without confirmation)
onmode -u (immediate)
onmode -s (graceful)

To let users exit and shut down the database server gracefully

   1. Execute the onmode -sy command to put the database server in quiescent mode.
   2. Wait for all users to exit.
   3. Execute the onmode -l command to move to the next logical log.
   4. Execute the onmode -c to force a checkpoint.
   5. Make a level-0 backup of the database server.
   6. Run ontape -a after the level-0 backup is complete.
   7. Execute the onmode -yuk command to shut down the system.

To perform an immediate shutdown of the database server

onmode -l
onmode -c
onmode -ky


refs:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin196.htm

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.mig.doc/mig80.htm

HP unix:
http://forums13.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1249314762790+28353475&threadId=942973







--
gv1: 2 Aug 2009