home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC81773 Status: Geschlossen

-1032 WHEN TRYING TO CONNECT TO DB EVEN THOUGH MEMBER IS STARTED

Produkt:
DB2 FOR LUW / DB2FORLUW / 980 - DB2
Problembeschreibung:
After a successful global db2start, connect attempt to a db 
could failed with -1032 (SQL1032N No start database manager 
command was issued) which is inconsistent 
 
$ cat db2nodes.cfg 
0 coralx501 0 coralx501-10ge - MEMBER 
1 coralx505 1 coralx505-10ge - MEMBER 
128 coralx507 0 coralx507-10ge - CF 
129 coralx508 0 coralx508-10ge - CF 
 
$ db2instance -list 
ID        TYPE            STATE                HOME_HOST 
CURRENT_HOST            ALERT  PARTITION_NUMBER 
LOGICAL_PORT    NETNAME 
--        ----            -----                --------- 
------------            -----  ---------------- 
------------    ------- 
0      MEMBER          STARTED                coralx501 
coralx501              NO                  0                  0 
coralx501-10ge 
1      MEMBER          STARTED                coralx505 
coralx505              NO                  0                  1 
coralx505-10ge 
128    CF              PRIMARY                coralx507 
coralx507              NO                  -                  0 
coralx507-10ge 
129    CF                  PEER                coralx508 
coralx508              NO                  -                  0 
coralx508-10ge 
 
HOSTNAME                  STATE                INSTANCE_STOPPED 
ALERT 
--------                  -----                ---------------- 
----- 
coralx508                ACTIVE                              NO 
NO 
coralx507                ACTIVE                              NO 
NO 
coralx505                ACTIVE                              NO 
NO 
coralx501                ACTIVE                              NO 
NO 
 
(jcolaco@coralx505) /home/jcolaco 
$ db2 connect to X 
SQL1032N  No start database manager command was issued. 
SQLSTATE=57019
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* PureScale                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* db2instance -list shows that all the members have started.   * 
* However, when trying to connect, it will fail with -1032 (no * 
* start database manager command issued.)                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v98fp5                                        * 
****************************************************************
Local-Fix:
N/A
Lösung
v9.8.0.5
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
01.03.2012
13.06.2012
13.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.8.0.5
Problem behoben lt. FixList in der Version
9.8.0.5 FixList