Hi,
after uncatalog one database, and catalog again with other name, if I
try to connect
with this database, everything is ok, but list applications only show
me the
connection with the uncatalog/catalog database. After I disconnect from
this database,
list applications command show all instances connection.
Below I paste the situation.
This example is from DB2 UDB Version 8 WSE for Linux
Database server = DB2/LINUX 8.1.0
I get the same situation for DB2 UDB WSE Version 8
Database server = DB2/6000 8.1.6
Thanks in advance.
db2inst1@lnxvm03:~> db2start
SQL1063N DB2START processing was successful.
db2inst1@lnxvm03:~> db2 create database test01
DB20000I The CREATE DATABASE command completed successfully.
db2inst1@lnxvm03:~> db2 uncatalog database test01
DB20000I The UNCATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is
refreshed.
db2inst1@lnxvm03:~> db2 terminate
DB20000I The TERMINATE command completed successfully.
db2inst1@lnxvm03:~> db2 create database test01 on /data/db2Databases
DB20000I The CREATE DATABASE command completed successfully.
db2inst1@lnxvm03:~> db2 catalog database test01 as test03 on
/home/db2inst1
DB20000I The CATALOG DATABASE command completed successfully.
DB21056W Directory changes may not be effective until the directory
cache is
refreshed.
db2inst1@lnxvm03:~> db2 connect to test01
Database Connection Information
Database server = DB2/LINUX 8.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST01
db2inst1@lnxvm03:~> db2 list applications
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
DB2INST1 db2bp 6 *LOCAL.db2inst1.078B22044607
TEST01 1
db2inst1@lnxvm03:~> db2 connect reset
db2inst1@lnxvm03:~> echo "CONNECT FROM ANOTHER LINUX SESSION"
CONNECT FROM ANOTHER LINUX SESSION
db2inst1@lnxvm03:~> db2 list applications
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
DB2INST1 db2bp 8 *LOCAL.db2inst1.079EA2044807
TEST01 1
db2inst1@lnxvm03:~> db2 connect to test01
Database Connection Information
Database server = DB2/LINUX 8.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST01
db2inst1@lnxvm03:~> db2 list applications
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
DB2INST1 db2bp 9 *LOCAL.db2inst1.078B22044832
TEST01 1
DB2INST1 db2bp 8 *LOCAL.db2inst1.079EA2044807
TEST01 1
db2inst1@lnxvm03:~> db2 connect to test03
Database Connection Information
Database server = DB2/LINUX 8.1.0
SQL authorization ID = DB2INST1
Local database alias = TEST03
db2inst1@lnxvm03:~> db2 list applications
Auth Id Application Appl. Application Id DB
# of
Name Handle Name
Agents
-------- -------------- ---------- ------------------------------
-------- -----
DB2INST1 db2bp 10 *LOCAL.db2inst1.078B22044841
TEST01 1
db2inst1@lnxvm03:~>