ADSM-L

[ADSM-L] TSM Manager Issue

2008-04-02 08:53:13
Subject: [ADSM-L] TSM Manager Issue
From: Adrian Compton <acompton AT ASPENPHARMA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 2 Apr 2008 14:51:05 +0200
Hi

 

Has anyone had any issues with TSM Manager causing locks in the TSM
Database from the Collector service.

The collector runs on Windows Server 2003.

TSM 5.3.5.2 on AIX 5.3 LPAR

 

I have logged an PMR with IBM and they found from my actlog extracts
that there are multiple selects and queries happening when a DB backup
is trying to take place causing an error as below:

 

03/28/08   08:27:05      ANR0538I A resource waiter has been aborted.

03/28/08   08:27:05      ANR9999D icvolhst.c(4060): ThreadId <61> Lock
Conflict

                          encountered in updating volume history
list.(SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:05      ANR9999D ThreadId <61> issued message 9999
from: (SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:05      ANR9999D ThreadId <61>  0x0000000100017e6c
outDiagf

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:05      ANR9999D ThreadId <61>  0x00000001000d5864
IcvhAddVolume

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:05      ANR9999D ThreadId <61>  0x00000001000d17e0

                          IcUpdateVolumeHistory  (SESSION: 7734,
PROCESS: 132)

03/28/08   08:27:06      ANR9999D ThreadId <61>  0x00000001006be528

                          DoSnapshotBackup  (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      ANR9999D ThreadId <61>  0x00000001006bf398
IcBackupThread

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      ANR9999D ThreadId <61>  0x0000000100006320
StartThread

more...   (<ENTER> to continue, 'C' to cancel)

 

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      ANR9999D ThreadId <61>  0x09000000003f42f8
_pthread_body

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (61) Context report (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (61) Thread CsRunCmdThread (23) is a parent
thread related

                          to: 61 (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) Generating TM Context Report:
(struct=tmTxnDesc)

                          (slots=256)(SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) slot -> 207: (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) Tsn=0:214593231, Resurrected=False,
InFlight=True,

                          Distributed=False (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (23)  Participants=1, summaryVote=ReadOnly
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06          Participant DB: voteReceived=False,
ackReceived=False

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06        Locks held by Tsn=0:214593231 : (SESSION:
7734, PROCESS:

                          132)

03/28/08   08:27:06          Type=17011, NameSpace=0, SummMode=sLock,
Mode=sLock,

                          Key='BKUP_STG_DB' (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (23) slot -> 236: (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) Tsn=0:214628588, Resurrected=False,
InFlight=True,

                          Distributed=False (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (23)  Participants=1, summaryVote=ReadOnly
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06          Participant DB: voteReceived=False,
ackReceived=False

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) Generating Database Transaction Table
Context:

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23) Tsn=0:214628605 --> Valid=1, inRollback=0,
endNTA=0,

                          State=2, Index=1, LatchCount=0, SavePoint=0,

                          TotLogRecs=2501, TotLogBytes=1100216,
UndoLogRecs=1,

                          UndoLogBytes=216, LogReserve=0, PageReserve=0,

                          Elapsed=3878 (secs), MinLsn=809252.115.2854,

                          MaxLsn=809253.168.1984,
LastLsn=809253.168.1984,

                          UndoNextLsn=0.0.0, logWriter=False,
backupTxn=True

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (23)  Open objects: (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (23)    name ->Seq.Volume.History<- (sp=0)
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23)  *** no transactions found *** (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23) Generating SM Context Report:  (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23)  *** no sessions found *** (SESSION: 7734,
PROCESS:

                          132)

03/28/08   08:27:06      (23) Generating AS Vol Context Report:
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23)  No mounted (or mount in progress)
volumes. (SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:06      (23) Generating ssSession Context Report:
(SESSION: 7734,

more...   (<ENTER> to continue, 'C' to cancel)

 

                          PROCESS: 132)

03/28/08   08:27:06      (23)  No storage service sessions active.
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23) Generating ssOpenSeg Context Report:
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23)  No storage service segments found.
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23) Generating BF Copy Control Context Report:
(SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:06      (23)  No global copy control blocks. (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (23)   procNum=132, status=Full backup: 1055517
pages of

                          1055517 backed up. , cancelInProgress=False
(SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:06      (23)   descr=Database Backup, name=DATABASE
BACKUP,

                          cancelled=False (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06       (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (61) Thread CsCmdSchedulerThread (39) is a
grandparent

                          thread related to: 23 (SESSION: 7734, PROCESS:
132)

03/28/08   08:27:06      (39) Generating TM Context Report:
(struct=tmTxnDesc)

                          (slots=256)(SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (39)  *** no transactions found *** (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39) Generating Database Transaction Table
Context:

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (39)  *** no transactions found *** (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39) Generating SM Context Report:  (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39)  *** no sessions found *** (SESSION: 7734,
PROCESS:

                          132)

03/28/08   08:27:06      (39) Generating AS Vol Context Report:
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39)  No mounted (or mount in progress)
volumes. (SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:06      (39) Generating ssSession Context Report:
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39)  No storage service sessions active.
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39) Generating ssOpenSeg Context Report:
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39)  No storage service segments found.
(SESSION: 7734,

                          PROCESS: 132)

03/28/08   08:27:06      (39) Generating BF Copy Control Context Report:
(SESSION:

                          7734, PROCESS: 132)

03/28/08   08:27:06      (39)  No global copy control blocks. (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06       (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (61) Thread CsScheduleManager (38) is a
great-grandparent

                          thread related to: 39 (SESSION: 7734, PROCESS:
132)

more...   (<ENTER> to continue, 'C' to cancel)

 

03/28/08   08:27:06      (38) Generating TM Context Report:
(struct=tmTxnDesc)

                          (slots=256)(SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (38)  *** no transactions found *** (SESSION:
7734,

                          PROCESS: 132)

03/28/08   08:27:06      (38) Generating Database Transaction Table
Context:

                          (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (38) Tsn=0:214611477 --> Valid=1, inRollback=0,
endNTA=0,

                          State=2, Index=3, LatchCount=0, SavePoint=0,

                          TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0,

                          UndoLogBytes=0, LogReserve=0, PageReserve=0,

                          Elapsed=10669 (secs), MinLsn=0.0.0,
MaxLsn=0.0.0,

                          LastLsn=0.0.0, UndoNextLsn=0.0.0,
logWriter=False,

                          backupTxn=False  (SESSION: 7734, PROCESS: 132)

03/28/08   08:27:06      (38)  Open objects: (SESSION: 7734, PROCESS:
132)

 

I would not have thought that selects and queries would cause TSM DB to
think there were locks placed on it.

 

Any ideas?

 

 

 

 

Adrian Compton

IT Baan Operation/ Group IBM Tivoli Admin

Pharmacare Limited trading as Aspen Pharmacare

P O Box 4002

Korsten

Port Elizabeth

6014

Switchboard Tel No: +27 (0) 41 407 2111

Tel No: +27 (0) 41 407 2855

Fax: +27 (0) 41 453 7452

Cell: +27 (0) 82 320 4495

Email : acompton AT aspenpharma DOT com   This email is solely for the named
addressee.   Any unauthorised use or interception of this email, or the
review, retransmission, dissemination or other use of, or taking of any
action in reliance upon the contents of this email, by persons or
entities other than the intended recipient, is prohibited. If you are
not the named addressee please notify us immediately by way of a reply
e-mail, and also delete this email and any attached files.

Disclaimer:  You must scan this email and any attached files for viruses
and/or any other defects.  Pharmacare Limited accepts no liability for
any loss, damages or consequence, whether direct, indirect,
consequential or economic, however caused, and whether by negligence or
otherwise, which may result directly or indirectly from this
communication or of any attached files.  

 

 

<Prev in Thread] Current Thread [Next in Thread>