从 DB2 迁移到 MySQL

Question

database_adm

Asked: 2023-06-12 19:49:35 +0800 CST2023-06-12 19:49:35 +0800 CST 2023-06-12 19:49:35 +0800 CST

如何修复 db2prereqcheck 挂起且不响应的问题？

772

当我跑步时

./db2prereqcheck -i -v 11.5.8.0

服务器没有回复。它挂起并且没有响应。

可能是什么问题？

该机器运行在 AIX 7.2 上。

当我运行时有相同的效果（没有响应）：

db2 list applications

但是，如果我运行：

db2 list db directory

或者

db2pd -db DBNAME -apinfo

我得到了预期的输出。我用export LC_ALL运行它，结果是一样的：

14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
Reading DB2 prerequisites from DB2prereqs.xml
Scanning line :   <MinPowerLevel>7</MinPowerLevel>
 ==>Adding  PREREQ[MinPowerLevel]=7
Scanning line :   <MinOSVersion>7</MinOSVersion>
 ==>Adding  PREREQ[MinOSVersion]=7
Scanning line :   <MinOSRelease>2</MinOSRelease>
 ==>Adding  PREREQ[MinOSRelease]=2
Scanning line :   <TLSP value="OSVersion = 7 OSRelease = 2">
   Evaluate for PREREQ[TLSP]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[TLSP]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
Scanning line :   <MinTL>3</MinTL>
 ==>Adding  PREREQ[MinTL]=3
Scanning line :   <MinSP>3</MinSP>
 ==>Adding  PREREQ[MinSP]=3
Scanning line :   </TLSP>
Scanning line :   <DDRIBFirmware>0x2000021</DDRIBFirmware>
 ==>Adding  PREREQ[DDRIBFirmware]=0x2000021
Scanning line :   <QDRIBFirmware>0x0000</QDRIBFirmware>
 ==>Adding  PREREQ[QDRIBFirmware]=0x0000
Scanning line :   <QDRIBDeviceID>b3153c67</QDRIBDeviceID>
 ==>Adding  PREREQ[QDRIBDeviceID]=b3153c67
Scanning line :   <MinQDRIBROM>000200091000</MinQDRIBROM>
 ==>Adding  PREREQ[MinQDRIBROM]=000200091000
Scanning line :   <RoceCX340GDeviceID>b31503101410b504</RoceCX340GDeviceID>
 ==>Adding  PREREQ[RoceCX340GDeviceID]=b31503101410b504
Scanning line :   <RoceCX310GDeviceID>b31507101410e704</RoceCX310GDeviceID>
 ==>Adding  PREREQ[RoceCX310GDeviceID]=b31507101410e704
Scanning line :   <MinRoceCX340GROM>000200325100</MinRoceCX340GROM>
 ==>Adding  PREREQ[MinRoceCX340GROM]=000200325100
Scanning line :   <MinRoceCX310GROM>000200325310</MinRoceCX310GROM>
 ==>Adding  PREREQ[MinRoceCX310GROM]=000200325310
Scanning line :   <RoceCX2Firmware>0x0000</RoceCX2Firmware>
 ==>Adding  PREREQ[RoceCX2Firmware]=0x0000
Scanning line :   <RoceCX2FlexDeviceID>b3155067b3157265</RoceCX2FlexDeviceID>
 ==>Adding  PREREQ[RoceCX2FlexDeviceID]=b3155067b3157265
Scanning line :   <RoceCX2DeviceID>b315506714101604</RoceCX2DeviceID>
 ==>Adding  PREREQ[RoceCX2DeviceID]=b315506714101604
Scanning line :   <MinRoceCX2FlexROM>00200091302</MinRoceCX2FlexROM>
 ==>Adding  PREREQ[MinRoceCX2FlexROM]=00200091302
Scanning line :   <MinRoceCX2ROM>000200091316</MinRoceCX2ROM>
 ==>Adding  PREREQ[MinRoceCX2ROM]=000200091316
Scanning line :   <xlcPackage>
Scanning line :   <xlcPackageName>xlC.rte</xlcPackageName>
 ==>Adding  PREREQ[xlcPackageName]=xlC.rte
Scanning line :   <xlcLabel>XL C/C++ Runtime</xlcLabel>
 ==>Adding  PREREQ[xlcLabel]=XL C/C++ Runtime
Scanning line :   <xlcVersion>13</xlcVersion>
 ==>Adding  PREREQ[xlcVersion]=13
Scanning line :   <xlcMajorRelease>1</xlcMajorRelease>
 ==>Adding  PREREQ[xlcMajorRelease]=1
Scanning line :   <xlcMinorRelease>2</xlcMinorRelease>
 ==>Adding  PREREQ[xlcMinorRelease]=2
Scanning line :   <xlcMinorRelease2>0</xlcMinorRelease2>
 ==>Adding  PREREQ[xlcMinorRelease2]=0
Scanning line :   </xlcPackage>
Scanning line :   <uDAPLLabel>uDAPL</uDAPLLabel>
 ==>Adding  PREREQ[uDAPLLabel]=uDAPL
Scanning line :   <uDAPLPackage>udapl.rte</uDAPLPackage>
 ==>Adding  PREREQ[uDAPLPackage]=udapl.rte
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 3">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 3
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>3</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>3</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 4">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 4
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>4</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>4</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 5">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 5
   Evaluate PREREQ[TL] current value= 5
   condition matched
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
 ==>Adding  PREREQ[uDAPLVersion]=7
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
 ==>Adding  PREREQ[uDAPLMajorRel]=2
Scanning line :   <uDAPLMinorRel>4</uDAPLMinorRel>
 ==>Adding  PREREQ[uDAPLMinorRel]=4
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
 ==>Adding  PREREQ[uDAPLMinorRel2]=0
Scanning line :   </uDAPL>
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 2 TL = 6">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 2
   Evaluate PREREQ[OSRelease] current value= 2
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: TL   Operator: =     Value: 6
   Evaluate PREREQ[TL] current value= 5
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>2</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>2</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>6</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>6</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <uDAPL value ="OSVersion = 7 OSRelease = 3 TL = 0">
   Evaluate for PREREQ[uDAPL]
   Operand: OSVersion    Operator: =     Value: 7
   Evaluate PREREQ[OSVersion] current value= 7
   condition matched
   Evaluate for PREREQ[uDAPL]
   Operand: OSRelease    Operator: =     Value: 3
   Evaluate PREREQ[OSRelease] current value= 2
   condition not matched
=== Skip tag BEGIN ===
   push to stack = uDAPL
Scanning line :   <uDAPLVersion>7</uDAPLVersion>
   Skipping =>  <uDAPLVersion>7</uDAPLVersion>
Scanning line :   <uDAPLMajorRel>3</uDAPLMajorRel>
   Skipping =>  <uDAPLMajorRel>3</uDAPLMajorRel>
Scanning line :   <uDAPLMinorRel>0</uDAPLMinorRel>
   Skipping =>  <uDAPLMinorRel>0</uDAPLMinorRel>
Scanning line :   <uDAPLMinorRel2>0</uDAPLMinorRel2>
   Skipping =>  <uDAPLMinorRel2>0</uDAPLMinorRel2>
Scanning line :   </uDAPL>
=== END skip tag RESUME ===
Scanning line :   <pureScale>
=== Skip tag BEGIN ===
   Pushing XML Tag to stack pureScale
   Skipping =>  <pureScale>
Scanning line :   <MinOSVersion>7</MinOSVersion>
   Skipping =>  <MinOSVersion>7</MinOSVersion>
Scanning line :   <MinOSRelease>2</MinOSRelease>
   Skipping =>  <MinOSRelease>2</MinOSRelease>
Scanning line :   <TLSP value="OSVersion = 7 OSRelease = 2">
   Skipping =>  <TLSP value="OSVersion = 7 OSRelease = 2">
Scanning line :   <MinTL>3</MinTL>
   Skipping =>  <MinTL>3</MinTL>
Scanning line :   <MinSP>3</MinSP>
   Skipping =>  <MinSP>3</MinSP>
Scanning line :   </TLSP>
   Skipping =>  </TLSP>
Scanning line :   </pureScale>
=== END skip tag RESUME ===
Finishing reading XML for platform </platform>
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
sqloCheckForIOPorts ENTRY
szCmd ---> lslpp -lc bos.iocp.rte >> /dev/null  2>&1 > /tmp/db2prereqcheck.10420674
 IO Ports installed
szCmd ---> LANG=C /usr/sbin/lsdev -Cc iocp >> /dev/null  2>&1 > /tmp/db2prereqcheck.10420674
IO Ports not Available
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
sqloCheckForIOPorts EXIT
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
resetEtcHosts ENTRY
resetEtcHosts EXIT
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat
 14743 : Cateory file path => /universal/db2/aix/bin/locale/en_US.iso88591/db2istring.cat

1 个回答

Voted

database_adm · Answer 1 · 2023-06-14T18:06:23+08:00

Best Answer

database_adm

2023-06-14T18:06:23+08:002023-06-14T18:06:23+08:00

我可以按照官方文档中的以下步骤解决该问题：

执行以下命令查看IOCP状态。

/usr/sbin/lsdev | grep iocp

如果此命令返回结果“可用”，则您无需完成此任务中的任何其他步骤。

如果该命令返回的结果不是可用结果（例如Defined），则完成此任务中的其余步骤。以 root 用户身份登录并运行以下命令：

smitty iocp

选择更改/显示 I/O 完成端口的特性。将系统重新启动时要配置的状态从Defined更改为available。使用以下命令重新启动服务器：

shutdown –Fr

使用以下命令确认 IOCP 状态为可用：

lsdev | grep iocp

iocp0 可用 I/O 完成端口

2

如何修复 db2prereqcheck 挂起且不响应的问题？

连接到 PostgreSQL 服务器：致命：主机没有 pg_hba.conf 条目

如何让sqlplus的输出出现在一行中？

选择具有最大日期或最晚日期的日期

如何列出 PostgreSQL 中的所有模式？

列出指定表的所有列

如何在不修改我自己的 tnsnames.ora 的情况下使用 sqlplus 连接到位于另一台主机上的 Oracle 数据库

你如何mysqldump特定的表？

使用 psql 列出数据库权限

如何从 PostgreSQL 中的选择查询中将值插入表中？

如何使用 psql 列出所有数据库和表？

如何修复 db2prereqcheck 挂起且不响应的问题？

1 个回答

相关问题