Server does not stay up!!
2014-08-26-14.37.09.781000 Instance:SERVER1 Node:000
PID:8188(db2syscs.exe) TID:12844 Appid:none
data protection services sqlpgArchiveLogFile Probe:3150
ADM1848W Failed to archive log file "S0102568.LOG" to
"J:\tsm\archlog\archmeth1\SERVER1\TSMDB1\NODE0000\C0000000\" from
"I:\tsm\log\".
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of
Vandeventer, Harold [OITS]
Sent: Tuesday, 26 August, 2014 2:20 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
I lean to your "halt system", "move folder" approach.
Dangerous to have a full C: drive I suspect; Windows won't be happy trying to
do anything on a full boot disk.
You'll have better luck giving Windows room to do its work; while letting TSM
deal with the new x:\ path.
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=Rveuv9wfhvxes5bW3Vceme%2FE5xpU4rGtsaHlis93bkY%3D%0A&s=a8fccf485976041a5944375b4dad8fab77e7f224babc60c0ce739ab7422886f6]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 12:24 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
There is one on another drive that is full , OOPS C:
c:\tsmarchlogfailover
If I create a new one on a new drive x:\tsmarchlogfailover and update
dsmserv.opt will it eventually free up the files on c:
never realized it was on C: to begin with, have had this environment for over 2
years
Or Is it better to
Halt system
Move c:\tsmarchlogfailover to x:\tsmarchlogfailover with windows copying
Update dsmserv.opt to ARCHFAILOVERLOGDirectory x:\tsmarchlogfailover
Restart TSM
Tim
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=Rveuv9wfhvxes5bW3Vceme%2FE5xpU4rGtsaHlis93bkY%3D%0A&s=a8fccf485976041a5944375b4dad8fab77e7f224babc60c0ce739ab7422886f6]
On Behalf Of Vandeventer, Harold [OITS]
Sent: Tuesday, 26 August, 2014 1:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
Can you create the ARCHFAILOVERLOGDirectory?
That would give you additional space without moving your current files from
ARCHIVELOG to the new volume.
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 11:57 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=Rveuv9wfhvxes5bW3Vceme%2FE5xpU4rGtsaHlis93bkY%3D%0A&s=a8fccf485976041a5944375b4dad8fab77e7f224babc60c0ce739ab7422886f6>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
Since it appears that my archive log drive is full, I found the steps to follow
relocate to larger drive.
Create an new archive log directory.
Update the dsmserv.opt option file for the new archive log directory.
Halt and restart the server.
Move the archive logs from the old directory to the new directory. Preserve any
subdirectory structure. Use and verify a recursive copy directory command.
By doing this , after the server restarts and before moving the archive logs
wont the backup still continue.
Tim
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f]
On Behalf Of Rhodes, Richard L.
Sent: Tuesday, 26 August, 2014 12:26 PM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=Rveuv9wfhvxes5bW3Vceme%2FE5xpU4rGtsaHlis93bkY%3D%0A&s=a8fccf485976041a5944375b4dad8fab77e7f224babc60c0ce739ab7422886f6>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
Cound something wrong with your archive log filesystem? Might it be unmounted
or something?
Rick
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wLQwo6jEM4gBohY6PaUggUKrw4TZKeuDMgOs7FtRQdQ%3D%0A&s=37a9c6f9d2e7c472c894e68ee88ab04eb74a4c87016a83326c058eb0e36cd30d]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 12:13 PM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: tsm archive log full, causes repeated backups
There have actually been 5 backups completed in a row since server was started
all with success! ?
All started due to ANR0299I A full database backup will be started. The
archive log space used is 99 % and the archive log space used threshold is 80
percent.
Tim
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wLQwo6jEM4gBohY6PaUggUKrw4TZKeuDMgOs7FtRQdQ%3D%0A&s=37a9c6f9d2e7c472c894e68ee88ab04eb74a4c87016a83326c058eb0e36cd30d]
On Behalf Of Prather, Wanda
Sent: Tuesday, 26 August, 2014 12:05 PM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
That usually means your activity log is enormous! :>) But restarting the
server would have killed any reorg or pinning transaction.
Try 2 db backups in a row now, your archive log should clear.
W
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=59fjuhngA9cOaKKoSEEx7QKvB8n8WS8AJcQc7dKkvOg%3D%0A&s=b9b987e96026d7ceb61565c822db7a14a1f95296ced725cff1999c4c0687b4eb]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 11:32 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
I had even restarted the tsm server today
If I enter with just =today it comes right back If I enter with today-1 the
query hangs
Tim
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=59fjuhngA9cOaKKoSEEx7QKvB8n8WS8AJcQc7dKkvOg%3D%0A&s=b9b987e96026d7ceb61565c822db7a14a1f95296ced725cff1999c4c0687b4eb]
On Behalf Of Prather, Wanda
Sent: Tuesday, 26 August, 2014 11:16 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
You could have a reorg running and pinning the log.
Try: q actlog begindate=today-2 search=reorg
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=QJwU6pc4k02OIaQLlHzQMrXul8%2BYJojUNnuh%2Fs91wxo%3D%0A&s=a65decc3894f7c9fae1a61e6b2087a6511ffef0e590b9e0aa9b8acbbf7846978]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 11:10 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
6.3.1
Tim
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=QJwU6pc4k02OIaQLlHzQMrXul8%2BYJojUNnuh%2Fs91wxo%3D%0A&s=a65decc3894f7c9fae1a61e6b2087a6511ffef0e590b9e0aa9b8acbbf7846978]
On Behalf Of Prather, Wanda
Sent: Tuesday, 26 August, 2014 10:42 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: Re: [ADSM-L] tsm archive log full, causes repeated backups
What version of TSM?
-----Original Message-----
From: ADSM: Dist Stor Manager
[https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=WGFM1MwQYmdG60UDE8OSw1g%2BOcDaDhXYoMB5ty9btmc%3D%0A&s=e4b40d364f7ded807ac7a3b7e58fb1e895fe5c250d61f997bcea2b981110fbc6]
On Behalf Of Tim Brown
Sent: Tuesday, August 26, 2014 10:21 AM
To:
ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f<mailto:ADSM-L@VM.MARIST.EDU<https://urldefense.proofpoint.com/v1/url?u=http://mailto:ADSM-L%40VM.MARIST.EDU&k=pCpgOv%2FKLW5dYRss05kLEw%3D%3D%0A&r=tQq0J85k4w4CeO1cI0sWanGhPyb3Fq7EC6ctgNHLxNs%3D%0A&m=wa93BxyEvkOqRkwWlA4IOnrE6sLSsibrrmWz%2FIk7bwQ%3D%0A&s=c7c5ea195c1c97a6797c0a13b9eca8d3101c70631667dc56a1859cf2ed67133f>>
Subject: [ADSM-L] tsm archive log full, causes repeated backups
ANR0299I A full database backup will be started. The archive log space used is
99 % and the archive log space used threshold is 80 percent. (PROCESS: 23)
This is continually happening, I have had this issue in the past but I don't
recall the resolution.
The prior backup that ran before that completed successfully.
There are no sessions or processes running.
Thanks,
Tim Brown
-----------------------------------------The information contained in this
message is intended only for the personal and confidential use of the
recipient(s) named above. If the reader of this message is not the intended
recipient or an agent responsible for delivering it to the intended recipient,
you are hereby notified that you have received this document in error and that
any review, dissemination, distribution, or copying of this message is strictly
prohibited. If you have received this communication in error, please notify us
immediately, and delete the original message.
[Confidentiality notice:]
***********************************************************************
This e-mail message, including attachments, if any, is intended for the person
or entity to which it is addressed and may contain confidential or privileged
information. Any unauthorized review, use, or disclosure is prohibited. If
you are not the intended recipient, please contact the sender and destroy the
original message, including all copies, Thank you.
***********************************************************************
