Migração de DB2 para 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

Como corrijo o bloqueio do db2prereqcheck e não está respondendo?

772

quando eu corro

./db2prereqcheck -i -v 11.5.8.0

não há resposta do servidor. Ele trava e não responde.

Qual pode ser o problema?

A máquina é executada no AIX 7.2.

Há o mesmo efeito (não respondendo) quando eu corro:

db2 list applications

Mas, se eu executar:

db2 list db directory

ou

db2pd -db DBNAME -apinfo

Eu recebo a saída esperada. Executei com export LC_ALL e o resultado é o mesmo:

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 respostas

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

Eu poderia resolver o problema seguindo estas etapas da documentação oficial :

Execute o seguinte comando para verificar o status do IOCP.

/usr/sbin/lsdev | grep iocp

Se este comando retornar o resultado, Available , não será necessário concluir mais nenhuma etapa nesta tarefa.

Se o comando retornar algo diferente do resultado Available , por exemplo, Defined , conclua as etapas restantes nesta tarefa. Faça login como usuário root e execute o seguinte comando:

smitty iocp

Selecione Alterar/mostrar características das portas de conclusão de E/S . Altere o estado a ser configurado na reinicialização do sistema de Definido para Disponível . Reinicie o servidor usando o seguinte comando:

shutdown –Fr

Confirme se o status do IOCP está disponível usando o seguinte comando:

lsdev | grep iocp

iocp0 Portas de conclusão de E/S disponíveis

2

Como corrijo o bloqueio do db2prereqcheck e não está respondendo?

conectar ao servidor PostgreSQL: FATAL: nenhuma entrada pg_hba.conf para o host

Como fazer a saída do sqlplus aparecer em uma linha?

Selecione qual tem data máxima ou data mais recente

Como faço para listar todos os esquemas no PostgreSQL?

Listar todas as colunas de uma tabela especificada

Como usar o sqlplus para se conectar a um banco de dados Oracle localizado em outro host sem modificar meu próprio tnsnames.ora

Como você mysqldump tabela (s) específica (s)?

Listar os privilégios do banco de dados usando o psql

Como inserir valores em uma tabela de uma consulta de seleção no PostgreSQL?

Como faço para listar todos os bancos de dados e tabelas usando o psql?

Como corrijo o bloqueio do db2prereqcheck e não está respondendo?

1 respostas

relate perguntas