我必须在db2中执行哪些规范驱动程序.cfg连接到aDB2数据库？我得到SQL1532N

Question

我安装了python3.4和ibm_db以连接到DB2数据库；我在Python解释器中看到安装了ibm_db 2.0.7，但是在连接到DB2数据库的过程中，我收到了SQL1532N错误消息，因此我想我需要配置db2dsdriver.cfg，为此我得到了db2dsdriver.xsd文件，但我不知道必须在其中做什么更改。我应该将所有“databases”更改为我尝试连接的DB2实例中数据库的实际名称吗？或者我还需要改变什么？在

顺便说一句，我的Windows10没有安装db2dsdriver.cfg，关于周围的一些信息，我认为它是从Python34下的\cfg子目录中的db2dsdriver.xsd动态创建的。在

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="configuration" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" >
  <xs:element name="parameter">
    <xs:complexType>
      <xs:attribute name="name" type="xs:string" />
      <xs:attribute name="value" type="xs:string" />
    </xs:complexType>
  </xs:element>
  <xs:simpleType name="whitespacesonly">
    <xs:restriction base="xs:string">
      <xs:pattern value="\s*" />
    </xs:restriction>
  </xs:simpleType>
  <xs:element name="client">
    <xs:complexType>
     <xs:simpleContent>
       <xs:extension base="whitespacesonly">
        <xs:attribute name="name" type="xs:string" />
        <xs:attribute name="hostname" type="xs:string" />
        <xs:attribute name="listname" type="xs:string" />
      </xs:extension>
     </xs:simpleContent>  
    </xs:complexType>
  </xs:element>
  <xs:element name="configuration" >
    <xs:complexType>
      <xs:all>
        <xs:element name="dsncollection" minOccurs="0">
          <xs:complexType>
            <xs:choice minOccurs="0" maxOccurs="unbounded"> 
              <xs:element name="dsn" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:choice minOccurs="0" maxOccurs="unbounded">
                    <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                    <xs:element name="specialregisters" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="sessionglobalvariables" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                  </xs:choice>
                  <xs:attribute name="alias" type="xs:string" />
                  <xs:attribute name="name" type="xs:string" />
                  <xs:attribute name="host" type="xs:string" />
                  <xs:attribute name="port" type="xs:string" />
                  <xs:attribute name="ldap" type="xs:integer" />
                </xs:complexType>
              </xs:element> 
              <xs:element name="defaultdsn" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                  </xs:sequence>
                  <xs:attribute name="alias" type="xs:string" />
                  <xs:attribute name="name" type="xs:string" />
                  <xs:attribute name="host" type="xs:string" />
                  <xs:attribute name="port" type="xs:string" />
                </xs:complexType>
              </xs:element>
            </xs:choice>
          </xs:complexType>
          <xs:unique name="oneDSNforEachAlias">
            <xs:selector xpath="dsn"/>
            <xs:field xpath="@alias"/>
          </xs:unique>
        </xs:element>
        <xs:element name="databases" minOccurs="0">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="database" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                  <xs:choice minOccurs="0" maxOccurs="unbounded">
                    <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                    <xs:element name="specialregisters" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="sessionglobalvariables" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="wlb" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:sequence>
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                        </xs:sequence>
                      </xs:complexType>
                    </xs:element>
                    <xs:element name="acr" minOccurs="0" maxOccurs="1">
                      <xs:complexType>
                        <xs:choice minOccurs="0" maxOccurs="unbounded">
                          <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                          <xs:element name="alternateserverlist" minOccurs="0" maxOccurs="1">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element name="server" minOccurs="0" maxOccurs="unbounded">
                                  <xs:complexType>
                                    <xs:simpleContent>
                                      <xs:extension base="whitespacesonly">
                                        <xs:attribute name="name" type="xs:string" />
                                        <xs:attribute name="hostname" type="xs:string" />
                                        <xs:attribute name="port" type="xs:string" />
                                      </xs:extension>                                    
                                    </xs:simpleContent>                                    
                                  </xs:complexType>
                                </xs:element>
                              </xs:sequence>
                            </xs:complexType>
                          </xs:element>
                          <xs:element name="alternategroup" minOccurs="0" maxOccurs="1">
                            <xs:complexType>
                              <xs:choice minOccurs="0" maxOccurs="unbounded"> 
                                <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                                <xs:element name="database" minOccurs="0" maxOccurs="unbounded">
                                  <xs:complexType>
                                    <xs:simpleContent>
                                      <xs:extension base="whitespacesonly">
                                        <xs:attribute name="name" type="xs:string" />
                                        <xs:attribute name="host" type="xs:string" />
                                        <xs:attribute name="port" type="xs:string" />
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                              </xs:choice>
                            </xs:complexType>
                          </xs:element>
                          <xs:element name="affinitylist" minOccurs="0" maxOccurs="1">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element name="list" minOccurs="0" maxOccurs="unbounded">
                                  <xs:complexType>
                                    <xs:simpleContent>
                                      <xs:extension base="whitespacesonly">
                                        <xs:attribute name="name" type="xs:string" />
                                        <xs:attribute name="serverorder" type="xs:string" />
                                      </xs:extension>
                                    </xs:simpleContent>  
                                  </xs:complexType>
                                </xs:element>
                              </xs:sequence>
                            </xs:complexType>
                          </xs:element>
                          <xs:element name="clientaffinitydefined" minOccurs="0" maxOccurs="1">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element ref="client" minOccurs="0" maxOccurs="unbounded" />
                              </xs:sequence>
                            </xs:complexType>
                          </xs:element>
                          <xs:element name="clientaffinityroundrobin" minOccurs="0" maxOccurs="1">
                            <xs:complexType>
                              <xs:sequence>
                                <xs:element ref="client" minOccurs="0" maxOccurs="unbounded" />
                              </xs:sequence>
                            </xs:complexType>
                          </xs:element>
                        </xs:choice>
                      </xs:complexType>
                    </xs:element>
                  </xs:choice>
                  <xs:attribute name="name" type="xs:string" />
                  <xs:attribute name="host" type="xs:string" />
                  <xs:attribute name="port" type="xs:string" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="parameters" minOccurs="0">
          <xs:complexType>
            <xs:choice minOccurs="0" maxOccurs="unbounded">
              <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
              <xs:element name="specialregisters" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
              <xs:element name="sessionglobalvariables" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
                  </xs:sequence>
                </xs:complexType>
              </xs:element>
            </xs:choice>
          </xs:complexType>
        </xs:element>
        <xs:element name="ldapserver" minOccurs="0">
         <xs:complexType>
            <xs:sequence>
              <xs:element ref="parameter" minOccurs="0" maxOccurs="unbounded" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:all>
    </xs:complexType>
  </xs:element>
</xs:schema>

Answer 1

error message corresponding to SQL1532N显示：

The db2dsdriver.cfg configuration file contains multiple entries for the database alias "database-alias".

这可能意味着您在其中一个standard locations中有一个db2dsdriver.cfg的副本。根据您安装的驱动程序包，它可能位于C:\ProgramData\IBM\DB2\<driver_copy_name or other path>\cfg下。在

.xsd文件描述了配置文件的模式，没有必要编辑它。您需要找到实际的.cfg文件并从中删除重复的数据库记录，只留下一个您需要的记录。在