DB2 FOR LUW / DB2FORLUW / 950 - DB2

Referring to DB2 Information Center, we know, when we run a 
CLP script file using the db2 -tvf filename command, it sets the 
special register CLIENT APPLNAME to CLP filename. 
 
  However, the special register CLIENT ACCTNG is also changed to 
BLANK unexpectedly after "db2 -tvf" execution. 
 
  A sample of the problem symptom is as follows. 
 
  $ db2 "call 
sysproc.wlm_set_client_info('MYID','MYPC','MYAPPL','MYACC',NULL) 
" 
 
  $ db2 list applications global show detail | grep db2bp | read 
a b agentid d ; db2 get snapshot for application agentid 
$agentid | egrep "^TP" 
  TP Monitor client user ID                  = MYID 
  TP Monitor client workstation name         = MYPC 
  TP Monitor client application name         = MYAPPL 
  TP Monitor client accounting string        = MYACC 
 
  $ db2 "values ( char(CLIENT USERID, 8), char(CLIENT 
WRKSTNNAME, 8), char(CLIENT APPLNAME, 16), char(CLIENT ACCTNG, 
32) )" 
  1        2        3                4 
  -------- -------- ---------------- 
-------------------------------- 
  MYID     MYPC     MYAPPL           MYACC 
 
  1 record(s) selected. 
 
  $ echo "select * from TAB01;" > select.sql 
  $ db2 -tvf select.sql > /dev/null 
  $ db2 list applications global show detail | grep db2bp | read 
a b agentid d; db2 get snapshot for application agentid $agentid 
| egrep "^TP" 
  TP Monitor client user ID                  = MYID 
  TP Monitor client workstation name         = MYPC 
  TP Monitor client application name         = CLP select.sql 
  TP Monitor client accounting string        =

**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The special register CLIENT ACCTNG is changed to blank after * 
* "db2 -tvf" execution                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version V9.5 FP8                              * 
****************************************************************

not available

DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.5 FixPak 8

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC75579 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

09.03.2011
05.07.2011
05.07.2011

9.5.,
9.5.FP8