|
Problem IT21485
|
Status: Closed |
SCRIPTS FAILS WITH SQLSTATE 42702 / SQLCODE: -204 |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
It is possible for multiple 'db2' frontends issued from
different shell sessions or scripts to
end up using the same 'db2bp' agent and causing unexpected
results / errors. For example:
Window 1
Window 2
tst1.sh (pid N)
tst2.sh (pid M)
db2 -tvf script1
connect to db
db2bp created
set schema WHATEVER1
insert into tab1
db2bp performs insert
db2 -tvf script2
connect to tst
insert into tab1
db2bp already connected
but with this problem we
use same db2bp for both
frontend
set schema WHATEVER2
insert into tab1
db2bp now inserts into
WHATEVER2.tab1 !!!! |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
na |
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 17.07.2017
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
