IDS Forum

RE: Another archive is already in progress-hel....

Posted By: Knox, Ernest
Date: Wednesday, 30 September 2009, at 2:58 p.m.

In Response To: RE: Another archive is already in progress-hel.... (Knox, Ernest)

$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.

Messages In This Thread

• Re: Another archive is already in progress-help [1
  brucemarchu@aol.com -- Wednesday, 30 September 2009, at 2:02 p.m.
  • Re: Another archive is already in progress-hel....
    debadatta -- Wednesday, 30 September 2009, at 2:41 p.m.
    • RE: Another archive is already in progress-hel....
      Knox, Ernest -- Wednesday, 30 September 2009, at 2:53 p.m.
      • RE: Another archive is already in progress-hel....
        Knox, Ernest -- Wednesday, 30 September 2009, at 2:58 p.m.
        • Re: RE: Another archive is already in progress-hel
          GARY ANDRUS -- Tuesday, 18 May 2010, at 10:45 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.