By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,087 Members | 1,520 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,087 IT Pros & Developers. It's quick & easy.

list applications only show one connection (catalog/uncatalog database)

P: n/a
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:~>

May 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.