Skip to Content
0
Former Member
Dec 07, 2013 at 09:01 PM

Update to DB2 9.7 FP07 hung

80 Views


Hello

I have problem with upgrade from 9.7 FP05 to FP07

After that I executed this command the process not continue

./installFixPack -b /db2/db2<sid-db>/db2_software OK

db6_update_client.sh -d <SID> OK

db2 -z db6_update_db_out.sql.log -tvf db6_update_db_out.sql --> Problem process hung

this information is in the Db6_update_db_out-sql.log is attached and I found this message inthe db2diag.log

2013-12-07-14.15.44.128353-300 E1485083790A702 LEVEL: Info (Origin)
PID : 14942430 TID : 11380 PROC : db2sysc 0
INSTANCE: db2bid NODE : 000 DB : BID
APPHDL : 0-61 APPID: *LOCAL.db2bid.131207191551
AUTHID : DB2BID
EDUID : 11380 EDUNAME: db2agent (BID) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_regen_function, probe:1
DATA #1 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
DATA #2 : String, 0 bytes
Object not dumped: Address: 0x0000000000000000 Size: 0 Reason: Address is NULL
DATA #3 : String, 9 bytes
SYSIBMADM
DATA #4 : String, 18 bytes
DBMS_LOB_COMPARE_5

2013-12-07-14.15.55.428725-300 I1485084493A460 LEVEL: Warning
PID : 14942430 TID : 11380 PROC : db2sysc 0
INSTANCE: db2bid NODE : 000 DB : BID
APPHDL : 0-61 APPID: *LOCAL.db2bid.131207191551
AUTHID : DB2BID
EDUID : 11380 EDUNAME: db2agent (BID) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_db_diagnose, probe:150
MESSAGE : WARNING: Diagnostic request received (Type = 3)

2013-12-07-14.15.55.436519-300 E1485084954A443 LEVEL: Error (OS)
PID : 14942430 TID : 11859 PROC : db2sysc
INSTANCE: db2bid NODE : 000 DB : BID
EDUID : 11859 EDUNAME: db2agent (BID) 0
FUNCTION: DB2 UDB, Client-side (app) latches, sqloxltc_app, probe:15
MESSAGE : ZRC=0x83000016=-2097151978
CALLED : OS, -, unspecified_system_function
OSERR : EINVAL (22) "Invalid argument"

2013-12-07-14.15.55.436990-300 E1485085398A443 LEVEL: Error (OS)
PID : 14942430 TID : 11859 PROC : db2sysc
INSTANCE: db2bid NODE : 000 DB : BID
EDUID : 11859 EDUNAME: db2agent (BID) 0
FUNCTION: DB2 UDB, Client-side (app) latches, sqloxult_app, probe:10
MESSAGE : ZRC=0x83000016=-2097151978
CALLED : OS, -, unspecified_system_function
OSERR : EINVAL (22) "Invalid argument"

2013-12-07-14.18.34.791449-300 I1485085842A494 LEVEL: Event
PID : 14942430 TID : 4370 PROC : db2sysc 0
INSTANCE: db2bid NODE : 000 DB : BID
APPHDL : 0-45 APPID: *LOCAL.DB2.131207191535
AUTHID : DB2BID
EDUID : 4370 EDUNAME: db2stmm (BID) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20
CHANGE : STMM CFG DB BID: "Database_memory" From: "337216" <automatic> To: "351460" <automatic>

Please Any suggestion about that.

Additional , Can I start the SAp instance, in this ponit ??, Can I re- execute the steps to upgrade?, or Can I close this Windows and open other and upgrade the db2 client.?

Thanks very much

System SAP : BW

SO: AIX 7.1

Attachments

processupgrade.JPG (42.0 kB)