IC89833: SERVER HALTS AFTER FAILED START WITHOUT AN ERROR MESSAGE

APAR status

• Closed as program error.

Error description

• Error Description: The server does not display an error message
  stating why it is halting after a failed start.  The following
  is seen.
  
  ANR0171I dbieval.c(931): Error detected on 3:1, database in
  evaluation mode.
  
  Transaction hash table contents (slots=256):
  slot -> 94:
  Tsn=0:94, Resurrected=False, InFlight=True, Distributed=False,
  Persistent=Tru-
  e, Addr 03374588
    Start ThreadId=0, Timestamp=01/18/2013 10:10:57,
  Creator=iminit.c(1278)
    Last known in use by ThreadId=0
    Participants=1, summaryVote=ReadOnly
    EndInFlight False, endThreadId 0, tmidx 0 0, processBatchCount
  0, mustAbort
  False.
      Participant DB: voteReceived=False, ackReceived=False
        DB: Txn 03489590, ReadOnly(NO), connP=032E1AF8,
  applHandle=665,
  openTbls=3:
        DB: --> OpenP=03492A00 for table=Expiration.Restart.
        DB: --> OpenP=034926A8 for table=Unresolved.Leaders.
        DB: --> OpenP=03492350 for table=Unresolved.Objects.
  
  Lock hash table contents (slots=3002):
    *** no locks found ***
  ANR1912I Stopping the activity log because of a server shutdown.
  ANR0369I Stopping the database manager because of a server
  shutdown.
  ANR0991I Server shutdown complete.
  
  However, there is no error message reported as to the cause of
  the server shutting down.
  
  Tivoli Storage Manager Versions Affected: 6.1, 6.2
  
  Customer/L2 Diagnostics: None
  
  Initial Impact: Low
  
  Additional Keywords:  halt, stop, stopping, shut, down, fail,
  fails
  

Local fix

• The following commands can be run from a DB2 command window in
  order to allow the server to start.
  
  db2 connect to tsmdb1
  db2 set schema tsmdb1
  
  db2 drop view archive_nameview
  db2 drop view backup_nameview
  db2 drop view object_ids
  
  
  db2 "create view archive_nameview as SELECT imar.nodeid,
  imar.fsid, imar.objtype, imar.hl_name as \"HL\", imar.ll_name as
  \"LL\", imar.insdate, imar.objid, imar.descr, imar.retinit_date,
  imar.objinfo, imar.owner, imar.mcid, imar.cgid,
  imar.encrypt_key, imar.bfsize, imar.hdrsize, imar.sharedobjid,
  imar.send_hdr, imar.stg_hint,  imar.clnttype, imar.bksetret,
  imar.setdatatype, imar.held,  imar.voldategmt, imar.aliasof,
  imar.volseq, imar.position,  imar.metadatasize, imar.flags,
  imar.hl as hlid, imar.ll as llid, imar.parenthl  FROM
  archive_objects imar WHERE imar.fsid<>1073741823 "
  
  
  db2 "create view backup_nameview as SELECT imbk.nodeid,
  imbk.fsid, imbk.objtype, imbk.hl_name as \"HL\", imbk.ll_name as
  \"LL\", imbk.state, imbk.insdate, imbk.objid, imbk.deacdate,
  imbk.objinfo, imbk.owner, imbk.mcid, imbk.cgid,
  imbk.encrypt_key, imbk.bfsize, imbk.hdrsize, imbk.sharedobjid,
  imbk.send_hdr, imbk.stg_hint, imbk.attrlength, imbk.extobjid,
  imbk.exttoken, imbk.grouptype, imbk.groupid, imbk.recogtoken,
  imbk.tocentries, imbk.bypassrecog, imbk.metadatasize,
  imbk.flags, imbk.hl as "HLID", imbk.ll as "LLID", imbk.parenthl
  FROM backup_objects imbk "
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in level 6.2.6.  Note that this is           *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem has been corrected.
  Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP