|
Problem IC86786
|
Status: Closed |
DB2SUPPORT DOESNOT WORK IN PHYSICAL DATA PARTITION ENVIRONMENT ON WINDOWS PLATFORM. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Data collection tool db2support doesn't work in physical data
partition environment on windows platform.
db2support.exe quits early in windows DPF(Physical partition)
environment.
when issuing db2support command with "-host all" option,
following will be the output.
C:\tmp>db2support . -d sample -host all
"db2support_options.in"
In the db2diag.log following entries can be seen:
2012-08-23-10.10.18.593000+060 I137531H865 LEVEL:
Warning
PID : 1068 TID : 1540 PROC :
db2systray.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: P360
EDUID : 1540
FUNCTION: DB2 UDB, base sys utilities,
sqleInitApplicationEnvironment, probe:32
MESSAGE : ZRC=0xFFFFE871=-6031
SQL6031N Error in the db2nodes.cfg file at line
number "". Reason
code "".
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -6031 sqlerrml: 4
sqlerrmc: 2 10
sqlerrp : SQLFRCFG
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0x00000000 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The issue is not reported with logical partition, it is only
present for physical partition |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users below DB2 v97fp8 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v97fp8 *
**************************************************************** |
| Local Fix: |
You can use "-member all" |
| available fix packs: |
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
Problem fixed in DB2 v97fp8 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.09.2012
05.04.2013
05.04.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.8
|
 |
| 10.1.0.2
|
|
| 10.5.0.2
|
|
