Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Dave Canan
ead, Storage 733, AllocCnt 14 > > > > > HighWaterAmt > > > > > 37761 > > > > > tid=1100364096, ptid=1971136576, det=1, zomb=0, join=0, result=0, > > > sess=0 > > > > > Awaiting cond NAV->checkConfig (0x0x2b78790770a0), using

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Zoltan Forray
; > > DB: --> OpenP=1144d3e38 for table=Nodes. > > > > > DB: --> OpenP=114d1ce58 for table=Policy.Domain.Members. > > > > >Participant IM: voteReceived=False, ackReceived=False > > > > > Locks held by Tsn=0:688679 : > >

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Dave Canan
t=1, zomb=0, join=0, result=0, > sess=0 > > > > > > (lot of snippage to not anger the listserv gods) > > > > > > > > > Awaiting cond descP->outReady (0x0x2b78790900f0), using mutex > > OUTV->mutex > > > (0x0xb

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Zoltan Forray
; > AllocCnt > > 4574 HighWaterAmt 321609 > > tid=1120319808, ptid=1201375552, det=0, zomb=0, join=0, result=0, sess=0 > > Holding mutex THRV->mutex (0x0xb5ea958), acquired at pkthread.c(2397) > > Server PID: 8520 > > Active threads: 126 >

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Dave Canan
t; AllocCnt > 4574 HighWaterAmt 321609 > tid=1120319808, ptid=1201375552, det=0, zomb=0, join=0, result=0, sess=0 > Holding mutex THRV->mutex (0x0xb5ea958), acquired at pkthread.c(2397) > Server PID: 8520 > Active threads: 126 > Zombie threads: 0 > Cached descriptors: 6 > >

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Zoltan Forray
8520 Active threads: 126 Zombie threads: 0 Cached descriptors: 6 -- I know there are fixes to import in 6.2.2.2 so I am going straight to 6.2.2.30 On Mon, May 2, 2011 at 12:26 PM, Dave Canan wrote: > Zoltan, there is no "s

Re: 6.2.2 equivalent of "show logpinned"?

2011-05-02 Thread Dave Canan
Zoltan, there is no "show logpinned" command in V6.2.2, but it is still possible to figure out which session and transaction is causing the log to be pinned. Here is an example of what you would need to do: This isn't quite as straight-forward as the old show command, but this wil

6.2.2 equivalent of "show logpinned"?

2011-04-29 Thread Zoltan Forray
Yes, I realize 6.x is DB2 but I was wondering is there is an equivalent to "show logpinned". I seem to be in some kind of situation where the logs are not being released and growing daily, eventhough I have performed numerous full DB backups and backup volhist. I am going to have to

Re: show logpinned

2002-10-16 Thread Large, Matthew
ored. > > > > Matthew Large > TSM Infrastructure Engineer > Lavington Street > Int: 7430 4995 > Ext: +44 207 902 4995 > > > -Original Message- > From: Steve Roder [mailto:[EMAIL PROTECTED]] > Sent: 15 October 2002 13:50 > To: [EMAIL PROTECTED] > Subject:

Re: show logpinned

2002-10-15 Thread Remco Post
; > Matthew Large > TSM Infrastructure Engineer > Lavington Street > Int: 7430 4995 > Ext: +44 207 902 4995 > > > -Original Message- > From: Steve Roder [mailto:[EMAIL PROTECTED]] > Sent: 15 October 2002 13:50 > To: [EMAIL PROTECTED] > Subject: Re: show logp

Re: show logpinned

2002-10-15 Thread Large, Matthew
2002 13:50 To: [EMAIL PROTECTED] Subject: Re: show logpinned > >What is the show command to see who has the log pinned? Is it in AIX server > >5.1.1.6 level? > > SHOW LOGPIN is not in v5.1.1.6. It was added back in on the newest > maintenance/patch - v5.1.5.1. The command is:

Re: show logpinned

2002-10-15 Thread Steve Roder
> >What is the show command to see who has the log pinned? Is it in AIX server > >5.1.1.6 level? > > SHOW LOGPIN is not in v5.1.1.6. It was added back in on the newest > maintenance/patch - v5.1.5.1. The command is: show log pin ...and it works on 5.1.1.6 on AIX > > Gretchen Thiele > Princeto

show logpinned

2002-10-14 Thread Gretchen L. Thiele
>What is the show command to see who has the log pinned? Is it in AIX server >5.1.1.6 level? SHOW LOGPIN is not in v5.1.1.6. It was added back in on the newest maintenance/patch - v5.1.5.1. Gretchen Thiele Princeton University