If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Database getting strange

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-20-08, 09:56
inzomnia inzomnia is offline
Registered User
 
Join Date: Jun 2008
Posts: 1
Database getting strange

Dear Expert;

I am confused with my database, suddenly my database is look like this

#onstat -l


Bddress numBer flBgs uniqid Begin size used %used
42B428900 4 U------ 459203 4:54 20000 20000 000.00
42B428998 5 U------ 459208 2:54 20000 20000 000.00
42B428cB8 00 U------ 459209 4:80054 20000 20000 000.00
42B428d00 00 U------ 459203 2:000054 20000 20000 000.00
42B428d38 02 U------ 459208 4:000054 20000 20000 000.00
42B428de0 04 U---C-L 459209 2:020054 20000 09433 93.49
42B428e48 04 U-B---- 459080 4:020054 20000 20000 000.00
42B428eB0 05 U-B---- 459080 2:040054 20000 20000 000.00
42B428f08 09 U-B---- 459082 4:040054 20000 20000 000.00
42B904940 24 U-B---- 459090 4:220054 20000 20000 000.00
42B904998 25 U-B---- 459090 2:240054 20000 20000 000.00
42B904300 29 U------ 459092 4:240054 20000 20000 000.00
42B904398 23 U------ 459094 2:290054 20000 20000 000.00
42B9043d0 28 U------ 459094 4:290054 20000 20000 000.00
42B904848 29 U------ 459095 2:280054 20000 20000 000.00
42B9048B0 40 U------ 459099 4:280054 20000 20000 000.00
42B904908 40 U------ 459093 2:400054 20000 20000 000.00
42B904930 42 U------ 459098 4:400054 20000 20000 000.00


Question is how to change onbar to ontape backup ?

Regards,

inzomnia
Reply With Quote
  #2 (permalink)  
Old 06-23-08, 08:16
ceinma ceinma is offline
Registered User
 
Join Date: Apr 2007
Location: Jundiai / SP - Brasil
Posts: 311
There is no secret.. just run the ontape command...

ontape -a : backup all logical log automatically
ontape -c : backup logical log continuous

You can automatize you logical log backup with shells using the ALARMPROGRAM option on your ONCONFIG .
__________________
________________________________________
César Inacio Martins
Jundiai / SP - Brasil
http://www.imartins.com.br/informix - em Português
http://www.imartins.com.br/informix - English (translated by Google).
________________________________________
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On