Re: Another archive is already in progress-help [1

Hi, It sounds like your original ontape process is still running.? So, when you started up the ontape backup again the conflict happened.? I suggest that you kill off all of the ontape sessions and then restart the ontape ?backup.? On UNIX systems you could do something like:?? ps? -ef? | grep ontape? to see what ontape sessions currently exist. Regards, Bruce Marchu -----Original Message----- From: debadatta <mishra.dd@gmail.com> To: ids@iiug.org Sent: Wed, Sep 30, 2009 2:52 am Subject: Another archive is already in progress-help [17248] Hi I am facing issue with my ontape backup. I was running a backup with ontape with exited out due to no more space on tape. Now when i increased the tape space still it is failing with the below error. Archive failed - Another archive is already in progress on DBspace can anybody direct me how to fix the problem without restarting the server. thanks Deba --000e0cd69526a583530474c87b5e ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

the problem actually started somedays back.the issue is now i cant see any ontape session running so ps -eaf |grep ontape does not work. there are no sessions. but its is still stuck for one dbspace. Is there any other way i can find out sid or pid so that i can kill it On Wed, Sep 30, 2009 at 11:32 PM, brucemarchu@aol.com <brucemarchu@aol.com>wrote: > Hi, > > It sounds like your original ontape process is still running.? So, when you > started up the ontape backup again the conflict happened.? I suggest that > you > kill off all of the ontape sessions and then restart the ontape ?backup.? > On > UNIX systems you could do something like:?? ps? -ef? | grep ontape? > > to see what ontape sessions currently exist. > > Regards, > > Bruce Marchu > > -----Original Message----- > From: debadatta <mishra.dd@gmail.com> > To: ids@iiug.org > Sent: Wed, Sep 30, 2009 2:52 am > Subject: Another archive is already in progress-help [17248] > > Hi > > I am facing issue with my ontape backup. > I was running a backup with ontape with exited out due to no more space on > tape. Now when i increased the tape space still it is failing with the > below > error. > > Archive failed - Another archive is already in progress on DBspace > > can anybody direct me how to fix the problem without restarting the server. > > thanks > Deba > > --000e0cd69526a583530474c87b5e > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd630624787790474cfe184

$onstat -u | grep informix;ps -eaf | grep Informix 501fe79c Y-AP--M 52826 informix 0 50d60ba8 0 0 738 0 50201f20 ------- 52826 informix 0 0 0 0 7630 0 50202938 ------- 52826 informix 0 0 0 0 0 0 informix 897240 282876 8 13:52:28 pts/0 0:00 ontape -s -L 0 Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of debadatta Sent: Wednesday, September 30, 2009 1:42 PM To: ids@iiug.org Subject: Re: Another archive is already in progress-hel.... [17260] the problem actually started somedays back.the issue is now i cant see any ontape session running so ps -eaf |grep ontape does not work. there are no sessions. but its is still stuck for one dbspace. Is there any other way i can find out sid or pid so that i can kill it On Wed, Sep 30, 2009 at 11:32 PM, brucemarchu@aol.com <brucemarchu@aol.com>wrote: > Hi, > > It sounds like your original ontape process is still running.? So, when you > started up the ontape backup again the conflict happened.? I suggest that > you > kill off all of the ontape sessions and then restart the ontape ?backup.? > On > UNIX systems you could do something like:?? ps? -ef? | grep ontape? > > to see what ontape sessions currently exist. > > Regards, > > Bruce Marchu > > -----Original Message----- > From: debadatta <mishra.dd@gmail.com> > To: ids@iiug.org > Sent: Wed, Sep 30, 2009 2:52 am > Subject: Another archive is already in progress-help [17248] > > Hi > > I am facing issue with my ontape backup. > I was running a backup with ontape with exited out due to no more space on > tape. Now when i increased the tape space still it is failing with the > below > error. > > Archive failed - Another archive is already in progress on DBspace > > can anybody direct me how to fix the problem without restarting the server. > > thanks > Deba > > --000e0cd69526a583530474c87b5e > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd630624787790474cfe184 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

$onstat -u | grep informix 50200ffc ------- 52868 informix 0 0 0 0 0 0 50201f20 ------- 52868 informix 0 0 0 0 3130 0 50202938 --AP--M 52868 informix 0 0 0 0 687 0 $ps -eaf | grep Informix informix 897268 282876 6 13:55:54 pts/0 0:00 ontape -s -L 0 $onstat -g ses 52868 IBM Informix Dynamic Server Version 10.00.UC5 -- On-Line -- Up 4 days 11:40:33 -- 106944 Kbytes session #RSAM total used dynamic id user tty pid hostname threads memory memory explain 52868 informix 0 897268 sls8870 3 4591616 4544464 off tid name rstcb flags curstk status 65391 ontape 50202938 Y-AP--M 3928 cond wait(sm_read) 65393 arcbacku 50201f20 ------- 1112 sleeping(secs: 1) 65394 arcbacku 50200ffc ------- 536 sleeping(secs: 1) Memory pools count 2 name class addr totalsize freesize #allocfrag #freefrag 52868 V 50d7d020 4587520 44704 133 32 52868*O0 V 50dc7020 4096 2448 1 1 name free used name free used overhead 0 3296 scb 0 96 opentable 0 3920 filetable 0 760 log 0 42288 temprec 0 2376 keys 0 824 gentcb 0 2360 ostcb 0 2736 net 0 4463192 sort 0 56 sqscb 0 13928 sql 0 40 rdahead 0 448 hashfiletab 0 840 osenv 0 1848 sqtcb 0 5408 fragman 0 48 sqscb info scb sqscb optofc pdqpriority sqlstats optcompind directives 513f6728 51420018 0 0 0 2 1 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers Explain 52868 - - - Not Wait 0 0 9.03 Off Last parsed SQL statement : select ( sum ( chksize - nfree ) ) from sysdbspaces , syschunks where sysdbspaces . dbsnum = syschunks . dbsnum Thanks, ******************************************************************* Ernie Knox IT Database Administrator Specialist Sears Holdings 3333 Beverly Rd., B4-266A Hoffman Estates, IL. 60179 Office: (847) 286-5735 Email: Ernest.Knox@searshc.com Blackberry: 2244650553@messaging.sprintpcs.com Page via Skytel: 2244650553@sprint.skytel.com Informix or MySQL Primary: 9110210@skytel.com Informix or MySQL Secondary: 7276872@skytel.com " Yes we can make a Change! " " It's always a great day to watch Sports - GO LIONS, TIGERS, and BEARS! " " Lets not forget - GO Pistons and Red Wings! " GSU ******************************************************************* -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of debadatta Sent: Wednesday, September 30, 2009 1:42 PM To: ids@iiug.org Subject: Re: Another archive is already in progress-hel.... [17260] the problem actually started somedays back.the issue is now i cant see any ontape session running so ps -eaf |grep ontape does not work. there are no sessions. but its is still stuck for one dbspace. Is there any other way i can find out sid or pid so that i can kill it On Wed, Sep 30, 2009 at 11:32 PM, brucemarchu@aol.com <brucemarchu@aol.com>wrote: > Hi, > > It sounds like your original ontape process is still running.? So, when you > started up the ontape backup again the conflict happened.? I suggest that > you > kill off all of the ontape sessions and then restart the ontape ?backup.? > On > UNIX systems you could do something like:?? ps? -ef? | grep ontape? > > to see what ontape sessions currently exist. > > Regards, > > Bruce Marchu > > -----Original Message----- > From: debadatta <mishra.dd@gmail.com> > To: ids@iiug.org > Sent: Wed, Sep 30, 2009 2:52 am > Subject: Another archive is already in progress-help [17248] > > Hi > > I am facing issue with my ontape backup. > I was running a backup with ontape with exited out due to no more space on > tape. Now when i increased the tape space still it is failing with the > below > error. > > Archive failed - Another archive is already in progress on DBspace > > can anybody direct me how to fix the problem without restarting the server. > > thanks > Deba > > --000e0cd69526a583530474c87b5e > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ************************************************************************ ******* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd630624787790474cfe184 ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.