Problem while taking backup
An IDS 7.31 user reported that nightly 'ontape -s -L 0' level-0 backups, previously taking 15-20 minutes, had stopped completing after inserting about a million rows and rebuilding a table; the archive stalled before reaching 100MB. Respondents asked about TAPEDEV/LTAPEDEV settings (disk file paths here), the 2GB file limit, environment variables, online log messages, checkpoint durations, 'onstat -g arc -r 1' scanner progress, and whether tar to the same directory worked. The poster said tar worked, logical log backups worked, and no errors appeared. No resolution is recorded in the thread.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi
We are using IDS 7.31
I used to take 0 level backup using ontape everyday it used to take 15-20
minutes only
But now for last one week backup is not happening.
Last week we have inserted some 10lakh records after that we have rebuilded
the table
But still not able to take ontape backup. Its taking lot of time and not
completing the backup.
What could be the reason?
Pls help
Regards
suresh
Hi,
How do you take your backup ?
On disk, on tape ?
You probably pass the 2 Gb limit ?
Jacques Lapeire
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of S
SURESH
Sent: dinsdag 27 februari 2007 10:56
To: ids@iiug.org
Subject: Problem while taking backup [8518]
Hi
We are using IDS 7.31
I used to take 0 level backup using ontape everyday it used to take
15-20
minutes only
But now for last one week backup is not happening.
Last week we have inserted some 10lakh records after that we have
rebuilded
the table
But still not able to take ontape backup. Its taking lot of time and not
completing the backup.
What could be the reason?
Pls help
Regards
suresh
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Are checkpoints getting longer during backup ?
Is there an activity going on during backup ?
Kenneth Penza
Technical Services Officer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd
Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
P
Please consider your environmental responsibility before printing this
e-mail.
END OF TEXT
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of S
SURESH
Sent: 27 February 2007 10:56
To: ids@iiug.org
Subject: Problem while taking backup [8518]
Hi
We are using IDS 7.31
I used to take 0 level backup using ontape everyday it used to take
15-20
minutes only
But now for last one week backup is not happening.
Last week we have inserted some 10lakh records after that we have
rebuilded
the table
But still not able to take ontape backup. Its taking lot of time and not
completing the backup.
What could be the reason?
Pls help
Regards
suresh
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
hi
I take it manually using ontape -s -L 0
its not even crossing 100MB.
Hi No activity is going on. I kill the backup process after waitinf for 10 -15 mins
Hi,
Ok you take it manually, but where is it going to ?
(TAPEDEV and LTAPEDEV in your ONCONFIG_file)
If you take it manually, are your variables INFORMIXDIR, INFORMIXSERVER
and ONCONFIG
Correctly set ?
Any messages in your logfile ? (find logfile with : grep MSG
$INFORMIXDIR/etc/$ONCONFIG)
Messages such as :
12:30:08 Level 0 Archive started on rootdbs, jpa, logspace
12:35:35 Checkpoint Completed: duration was 0 seconds.
12:41:41 Archive on rootdbs, jpa, logspace Completed.
Jacques Lapeire
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of S
SURESH
Sent: dinsdag 27 februari 2007 11:18
To: ids@iiug.org
Subject: Re: RE: Problem while taking backup [8521]
hi
I take it manually using ontape -s -L 0
its not even crossing 100MB.
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Hi all the parameters are properly set its not showing any error Its taking long time now than before After waiting for some time im killing the process
What about the message log file, is there anything usual, errors/
checkpoint duration?
If you do a file system backup to the tape drive, say of a 4G data how
does it behave ?
If you do onstat -g arc -r 1 does the scanner value increment?
Kenneth Penza
Technical Services Officer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd
Please read our Legal Notice: http://emailpolicy.mitts.gov.mt
P
Please consider your environmental responsibility before printing this
e-mail.
END OF TEXT
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of S
SURESH
Sent: 27 February 2007 11:20
To: ids@iiug.org
Subject: Re: RE: Problem while taking backup [8522]
Hi
No activity is going on.
I kill the backup process after waitinf for 10 -15 mins
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
As asked before but you didn't reply, what are TAPEDEV & LTAPEDEV ? What OS ? Can you backup a dir. or file using tar/cpio on the device (Tape or filesystem), being referenced by TAPEDEV ? ----- Original Message ---- From: S SURESH <suresh.sambana@ril.com> To: ids@iiug.org Sent: Tuesday, February 27, 2007 9:32:57 PM Subject: Re: RE: RE: Problem while taking backup [8524] Hi all the parameters are properly set its not showing any error Its taking long time now than before After waiting for some time im killing the process ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo! Games. http://games.yahoo.com/games/front
im able to take tar backup in that dir
TAPEDEV /data/informix/archive/ril1_tape
LTAPEDEV /logicallogs/clogfile
ok. Before killing ontape process, can you check:
1. check onstat - to see if any thing unusual e.g "Archive Blocked" , "Block
Checkpoint" etc.
2. onstat -u | grep -M- and see if Read / Write counts are changing
3. Does Online log file record message about Level 0 started ?????
4. What about logical logs ? Are they being backuped up ?
----- Original Message ----
From: S SURESH <suresh.sambana@ril.com>
To: ids@iiug.org
Sent: Tuesday, February 27, 2007 10:21:49 PM
Subject: Re: RE: RE: Problem while taking backup [8527]
im able to take tar backup in that dir
TAPEDEV /data/informix/archive/ril1_tape
LTAPEDEV /logicallogs/clogfile
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
________________________________________________________________________________
____
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
Hi Onstat - is not showing any unusual status logical logs are backed by ontape--its working fine When i start 0 level bkp online log shows archive started i m not getting any errors
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g