Update to DB2 9.7 FP07 hung

[Former Member]

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

db6_update_db_out.sql.txt.zip

[hugo_amo · Accepted solution]

Hi,

You are hitting a known issue fixed in fixpack 8. This is documented in APAR IC89221.

http://www-01.ibm.com/support/docview.wss?uid=swg1IC89221

Hope it helps.

Regards,

Hugo

[Former Member · Accepted solution]

Hello Hugo,

I think  that you are giving support through  OSS

Regard

DAnny

[hugo_amo · Accepted solution]

Hi Danny,

Is the issue fixed? Can I ask what the solution was? Did you follow the steps in the note or apply fp 8?

Regards,

Hugo

[Former Member · Accepted solution]

Hello Hugo

Thanks  for  your support,

The fix was:  logon directly in the server  with the root user and to execute again all process update  before I entered on the server through <SID>adm  next  "su - root" command

Actually  the system has the Fixpack 08

Thanks

Danny