Have a look at:
http://www-1.ibm.com/support/docview...f-8&lang=en+en
Catalog the loopback node. Enter the following command:
db2 catalog tcpip node <nodename> remote 127.0.0.1 server <connection
service name>
where <nodename> is a local alias for the node to be cataloged. This is
an arbitrary name on
the user's workstation, used to identify the node. e.g.
db2 catalog tcpip node mynode remote 127.0.0.1 server db2cdb2inst1
To verify that the catalog command worked properly, issue the following
command:
db2 list node directory
Sample output (blank lines have been removed to make it more readable):
Node Directory
Number of entries in the directory = 1
Node 1 entry:
Node name = MYNODE
Comment =
Protocol = TCPIP
Hostname = 127.0.0.1
Service name = db2cdb2inst1
5. Catalog the database as follows:
a. db2 catalog db <database name> as <database alias>
b. db2 uncatalog db <database name>
c. db2 catalog db <database alias> as <database name> at node <nodename>
e.g.
db2 catalog db WAS as WASLOOP
db2 uncatalog db WAS
db2 catalog db WASLOOP as WAS at node MYNODE
Stefano Barca wrote:
Sorry, what do you mean about loopback node?
"Anton Versteeg" <an************@nnll.ibm.com> ha scritto nel messaggio
news:c8**********@sp15en20.hursley.ibm.com...
Perhaps you can try to create a loopback node, so you can change local
connections to the database to remote connections.
Stefano Barca wrote:
Ciao a tutti,
stò migrando dalla versione 7 alla versione 8 di DB2.
Ho migrato l'istanza ma non riesco a migrare il database.
Mi da l'errore SQL1224N con SQLSTATE= 55032.
Ho controllato sul sito IBM dove mi dicono che devo aumentare il
maxagents
oppure inserire il Sysadm nel gruppo di amministrazione di db2.
Ho fatto queste due cose ma non ho risultati diversi.
Premetto che non riesco a migrare neanche il database di esembio di
Db2V7.
Cosa posso fare?
Grazie a tutti per la risposta
--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands
--
Anton Versteeg
IBM Certified DB2 Specialist
IBM Netherlands