Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC86463 Status: Closed

DB2SUPPORT DOESNOT WORK IN PHYSICAL DATA PARTITION ENVIRONMENT ON WINDOWS
PLATFORM.

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* DB2 V9.7 and 10.1                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* You can use "-member all" or upgrade to DB2 V10.2            * 
****************************************************************
Local Fix:
You can use "-member all"
available fix packs:
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 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 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
11.09.2012
17.12.2012
17.12.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.2 FixList
10.5.0.2 FixList