I've had the same here. IBM told me to do this :
Customer Env: Win2k TSM/ADSM SERVER v5.1.6
.
Problem: Client schedules do not run, anr0102e dsalloc.c (980);
.
Action Taken: Customer says that around Feb 5th there was a problem
dismounting a tape volume in a library. They had shut down TSM with the
problem tape in the drive. After the drive was cleared and TSM was
restarted they got the following error:
.
ANR0102E dsalloc.c(980): Error 1 inserting row in table
"DS.Segments".
ANR0102E dsalloc.c(980): Error 1 inserting row in table
"DS.Segments".
.
Initially this error was reported every time a single node scheduled and
ran a backup, Chris says that over time all but one of his 10 nodes have
become affected by this TSM database corruption.
.
Researched, found that he will need to do the following:
.
1. Stop backups to the disk stgpool
2. Migrate all the data in the disk stgpool to tape
3. Assuming Step 2. complete without issue, halt the TSM server
4. Perform a restricted offline database audit with the following
command:
.
DSMSERV AUDITDB DISKSTORAGE FIX=YES
.
I explained to Customer that this is a restricted audit of the database
(TSM
only looks at tables relating to the disk stgpools) it will not run as
long as a full db audit.
____________________________________________________
____________________________________________________
Jens Gebhardt
We are getting a series of these ANR0102E again.
- the database is not nearly full ..............67% currently
- no volumes in the volhist show STGREUSE
( checking suggestions at http://people.bu.edu/rbs/ADSM.QuickFacts
( What is an Audit DB online ?)
Any suggestions other than do an AUDIT DB...we did one a month ago
prior to upgradeing to TSM 5.1
09/03/2003 2:21:50 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:23:37 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:26:04 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:36:21 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:36:30 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:47:58 AM ANR0102E dsalloc.c(980): Error 1 inserting row in
table "DS.Segments".
09/03/2003 2:47:58 AM ANR0530W Transaction failed for session 5333 for
node PRXYMSSQL (TDP MSSQL) - internal server error detected.
*******************
