If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Error when upgrade db2 from V8 to V9.7FP2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-03-10, 10:02
junli0411 junli0411 is offline
Registered User
 
Join Date: May 2008
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 08-07-10, 00:31
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On