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 will work. Call or re

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Zoltan Forray
-- 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 ddca...@gmail.com wrote: Zoltan, there is no show logpinned command in V6.2.2, but it is still possible to figure out which

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Dave Canan
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 ddca...@gmail.com wrote: 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

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Zoltan Forray
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 ddca...@gmail.com wrote: 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

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Dave Canan
am going straight to 6.2.2.30 On Mon, May 2, 2011 at 12:26 PM, Dave Canan ddca...@gmail.com wrote: 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

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Zoltan Forray
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 ddca...@gmail.com wrote: Zoltan, there is no show logpinned command in V6.2.2, but it is still possible to figure out which session and transaction

Re: 6.2.2 equivalent of show logpinned?

2011-05-02 Thread Dave Canan
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 ddca...@gmail.com wrote: 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

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 bounce it soon

logpinned

2009-11-11 Thread Gill, Geoffrey L.
For the past 2 days something has been screwing up backups by filling the log and this morning I remembered the show logpinned command and found the server that is causing it. I've cancelled the session but as far as I know am at the mercy of TSM to kill it at some point. I contacted

Re: logpinned

2009-11-11 Thread Shawn Drew
Internet geoffrey.l.g...@saic.com Sent by: ADSM-L@VM.MARIST.EDU 11/11/2009 12:48 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject [ADSM-L] logpinned For the past 2 days something has been screwing up backups by filling the log and this morning I remembered the show

Re: logpinned

2009-11-11 Thread Xav Paice
- Geoffrey L. Gill geoffrey.l.g...@saic.com wrote: For the past 2 days something has been screwing up backups by filling the log and this morning I remembered the show logpinned command and found the server that is causing it. I've cancelled the session but as far as I know am

Re: logpinned

2009-11-11 Thread Gill, Geoffrey L.
Take a look also at the 'show logpinned cancel' command if that's not what you used to cancel the session - sometimes it's helpful. If that doesn't work then halting the server will do the trick, but that's not the most tidy or convenient way... assuming you're about to run out of log

Re: logpinned

2009-11-11 Thread Gill, Geoffrey L.
From what I understand, when you cancel the session, TSM rolls back the transaction. Sometimes it's quick, sometimes it can take quite a while. but the log won't grow any more from the session while it is rolling back. It may well be that the log isn't 'supposed to grow but that isn't what I

Re: logpinned

2009-11-11 Thread Shawn Drew
. Regards, Shawn Shawn Drew Internet geoffrey.l.g...@saic.com Sent by: ADSM-L@VM.MARIST.EDU 11/11/2009 02:20 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] logpinned From what I understand, when you cancel

Re: show logpinned

2002-10-16 Thread Large, Matthew
logpinned :) it is 'show logpin', and my 4.2.2.10 server understands this perfectly. On dinsdag, oktober 15, 2002, at 02:53 , Large, Matthew wrote: correction: the command is tsm show log whatever is placed after the 'log' is ignored. Matthew Large TSM Infrastructure Engineer

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 Princeton

Re: show logpinned

2002-10-15 Thread Large, Matthew
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: show log pin ...and it works on 5.1.1.6

Re: show logpinned

2002-10-15 Thread Remco Post
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 What is the show command to see who has the log pinned? Is it in AIX server 5.1.1.6 level? SHOW

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