home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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