Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: Error when upgrade db2 from V8 to V9.7FP2

    OS:
    AIX 5300-09-05-0943

    Error info when doing "db2 upgrade database gtm" :

    2010-08-03-13.31.21.369879+000 E11555A1097 LEVEL: Error (OS)
    PID : 540690 TID : 2830 PROC : db2sysc 0
    INSTANCE: db2cdt01 NODE : 000 DB : GTM
    APPHDL : 0-7 APPID: *LOCAL.db2cdt01.100803132957
    AUTHID : DB2CDT01
    EDUID : 2830 EDUNAME: db2agent (GTM) 0
    FUNCTION: DB2 UDB, oper system services, sqloopenp, probe:80
    MESSAGE : ZRC=0x870F0016=-2029060074=SQLO_SHAR "File sharing violation."
    DIA8519C A file sharing violation has occurred, filename was "".
    CALLED : OS, -, open
    OSERR : ETXTBSY (26) "Text file busy"
    DATA #1 : Codepath, 8 bytes
    4:11:12:13:22:36:37
    DATA #2 : File name, 27 bytes
    /DB2GTM05/DB2/GTM/GTMSCADR3
    DATA #3 : SQO Open File Options, PD_TYPE_SQO_FILE_OPEN_OPTIONS, 4 bytes
    SQLO_REVISE, SQLO_READWRITE, SQLO_EXCLUSIVE, SQLO_WRITETHRU
    DATA #4 : Hex integer, 4 bytes
    0x000001A0
    DATA #5 : signed integer, 4 bytes
    50
    DATA #6 : signed integer, 4 bytes
    0
    DATA #7 : String, 105 bytes
    Search for ossError*Analysis probe point after this log entry for further
    self-diagnosis of this problem.


    Can anybody help me for it ?

    Thanks a lot.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    DB2 can't open /DB2GTM05/DB2/GTM/GTMSCADR3 because it's locked by some other process. What is this file? Some tablespace container? You can try stopping the instance and perform a manual cleanup of all processes / IPC resources owned this instance and then retry migrate db again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •